Person Training Plan Correspondence Extract

ENRJ9050 - Person Training Plan Correspondence Extract

Purpose	Use this job to extract data for Person Training Plan Correspondence Extract
SubSystem	Enrolments
Normally Run By	Administration Staff
Anticipated Frequency	Enrolments
Structure	Block	Person Training Plan Correspondence Extract
	Tabs	Parameters
		More
	Buttons	Calendar Lookup
		Find Person (ADMF1213)

Training Plan Correspondence Extract

The purpose of this job is to produce extracts the data used by institutions for different types of correspondence relating Person Training Plans.

This information may be used for Acceptance of NAN information, Training Plan cover letter, to create a letter to cancel, suspend or defer a Training Plan, to notify of employer endorsement or to notify of completion of the Training Plan.

An S_EXTRACT record of type PTP-COR is created. Details for these records are included in a table below

S_EXTRACT_RECORD records are created of type:

HEADER as per the HEADER record definition below,
PERSON as per the PERSON record definition below,
ADDRESS as per the PERSON ADDRESS DETAILS record definition below,
PTP-DETAILS as per the PERSON TRAINING PLAN DETAILS record definition below,
PTP-COURSE-DETAILS as per the PERSON COURSE DETAILS record definition below,
PTP-APPROVER-DETAILS PERSON TRAINING PLAN DETAILS record definition below,
FOOTER as per the FOOTER record definition below.

If this job is run with the 'Do Not Record Correspondence' indicator set to N, then:

A correspondence_item record is created with a correspondence_type as specified in the parameter form and including the request job run details and the person ID of the person who ran this job
An out_correspondence record is created for the person whose training plan has had a correspondence_item record created in the pevious step.
An out_correspondence_ref record is created for this person for the out_correspondence record created in the above step. The person ID and sequence_number are recorded in the other reference field of this out_correspondence_ref record and the system other reference type is ‘PTP-REQ’

This form is accessed via the main menu.

The Person Training Plan Correspondence Extract block contains:

Parameters

Correspondence Type
Person Training Plan Status
Person Training Plan Title
Created After
Person ID
Person ID Group
Ignore Previous Correspondence Records check box
Do Not Record Correspondence check box
Button
- Calendar Lookup
- Find Person (ADMF1213)

Rules/Notes:

If the Person ID entered does not exist then an error is generated.

A Person ID and Person ID group cannot be specified together.

If the Correspondence Type entered does not exist, then an error is generated in the run log and no processing will occur.

When a Correspondence Type is not selected, then the 'Do Not Record Correspondence' check box must be unset.

If no person training plan records are found for the parameters entered, then an error message is entered in the run log.

If the 'Ignore Previous Correspondence Records' checkbox is not selected, then only those Person Training Plans that have not previously had extracts created by this job will have extracts created by the current job run.

To run this job:

Navigate to ENRJ9050
Nominate the required parameters for this extract
Select Schedule ASAP

Rules/Notes:

This job will generally be run for an individual student or a group of students as defined in a Person ID group:

S_EXTRACT record generated

Field Name	Field Description	Max Length
S_EXTRACT_TYPE	The Extract Type	PTP-COR
CREATION_DT	The Creation Date Of The Extract	SYSDATE
KEY	The key created from the passed in job parameters	p_correspondence_type\|\| ‘\|’ \|\| p_person_trng_plan_ status\|\| ‘\|’ \|\| p_title\|\| ‘\|’ \|\| p_person_id \|\| ‘\|’ \|\| p_person_id_group\|\| ‘\|’ \|\| p_creation_dt \|\| ‘\|’ \|\| p_record_ correspondence_ind \|\| ‘\|’ \|\| p_ignore_prev_cor _recs_ind
REQUEST_JOB_RUN_ID	The Request Job Run ID of the job passed as a parameter.	p_request_job_run_id

S_EXTRACT_RECORD records generated

Note: The s_extract_record records generated have a single 'TEXT' field which includes all the extract details in fields1-26 in the tables below. The associated view PERSON_TRNG_PLN_COR_EXTRACT_V has separate fields for each value.

Column	Data
Column	Person	Alternate Person ID Details	Person Address Details	Person Training Plan Details	Person Course Details	Person Approver Details
S_EXTRACT_TYPE	TPTEMPLATE	TPTEMPLATE	TPTEMPLATE		TPTEMPLATE	TPTEMPLATE
CREATION_DT	As defined in s_extract	As defined in s_extract	As defined in s_extract		As defined in s_extract	As defined in s_extract
SEQUENCE NUMBER	Ser_sequence_number.nextval	Ser_sequence_number.nextval	Ser_sequence_number.nextval		Ser_sequence_number.nextval	Ser_sequence_number.nextval
KEY1	person_trng_plan.person_id	person_trng_plan.person_id	person_trng_plan.person_id	person_trng_plan.person_id	person_trng_plan.person_id	person_trng_plan.person_id
KEY2	NULL	NULL	Person_addr.addr_type		NULL	NULL
KEY3	NULL	NULL	Person_addr.start_dt		NULL	NULL
KEY4	NULL	NULL	NULL	person_trng_plan.sequence_number	person_trng_plan.sequence_number	person_trng_plan.sequence_number
KEY5	NULL	NULL	NULL	NULL	person_trng_plan.course_cd	person_trng_plan.course_cd
KEY6	NULL	NULL	NULL	NULL	NULL	Person_trng_plan_approver.ptp_sequence_number
KEY7	NULL	NULL	NULL	NULL	NULL	NULL
KEY8	NULL	NULL	NULL	NULL	NULL	NULL
KEY9	NULL	NULL	NULL	NULL	NULL	NULL
KEY10	NULL	NULL	NULL	NULL	NULL	NULL
RECORD_TYPE	‘PERSON '	'ALT-PERSON-ID’	‘ADDRESS’	‘PTP-DETAILS’	‘PTP-COURSE-DETAILS’	‘PTP-APROVER-DTLS’
TEXT	person.person_id \|\|’\|’\|\| person.title \|\|’\|’\|\| person.surname\|\|’\|’\|\| person.given_names \|\|’\|’\|\| person.birth_dt \|\|’\|’\|\| person.email_addr	api.api_person_id\|\|’\|’\|\| api.person_id_type\|\|’\|’\|\| api.start_dt\|\|’\|’\|\| api.end_dt	person.person_id\|\|’\|’\|\| person_addr.addr_type\|\|’\|’\|\| person_addr.addr_line_1 \|\|’\|’\|\| person_addr.addr_line_2 \|\|’\|’\|\| person_addr.addr_line_3 \|\|’\|’\|\| person_addr.addr_line_4 \|\|’\|’\|\| person_addr.addr_line_5 \|\|’\|’\|\| person_addr.aust_postcode person_addr.os_code \|\|’\|’\|\| person_addr.phone_1 \|\|’\|’\|\| person_addr.phone_2 \|\|’\|’\|\| person_addr.phone_3 \|\|’\|’\|\| person_addr.other_details \|\|’\|’\|\| addr_type.correspondence_ind	person_trng_plan.person_id\|\|’\|’\|\| person_trng_plan.sequence_number\|\|’\|’\|\| person_trng_plan.creation_dt\|\|’\|’\|\| person_trng_plan.start_dt\|\|’\|’\|\| person_trng_plan.end_dt\|\|’\|’\|\| person_trng_plan.title\|\|’\|’\|\| person_trng_plan.nan_receipt_dt\|\|’\|’\|\| person_trng_plan.trng_plan_template_cd\|\|’\|’\|\| person_trng_plan.tptm_version_number\|\|’\|’\|\| person_trng_plan.emp_endorsement_req_ind\|\|’\|’\|\| person_trng_plan.school_based_training_plan_ind\|\|’\|’\|\| person_trng_plan.status_review_dt\|\|’\|’\|\| person_trng_plan.status_update_on\|\|’\|’\|\| person_trng_plan.status_comments\|\|’\|’\|\| person_trng_plan.comments	person_trng_plan.person_id\|\|’\|’\|\| person_trng_plan.sequence_number\|\|’\|’\|\| student_course_attempt.course_cd\|\|’\|’\|\| student_course_attempt.version_number\|\|’\|’\|\| student_course_attempt.version_number\|\|’\|’\|\| student_course_attempt.location_cd\|\|’\|’\|\| student_course_attempt.attendance_mode\|\|’\|’\|\| student_course_attempt.attendance_type\|\|’\|’\|\| student_course_attempt.course_attempt_status\|\|’\|’\|\| student_course_attempt.student_confirmed_ind\|\|’\|’\|\| course_version.course_type\|\|’\|’\|\| course_type.description	Person Training Plan Approver Type Name of the Person Training Plan Approver Person Training Plan Approver Contact Person ID Business Name Contact name of the Person Training Plan Approver Contact position of the Person Training Plan Approver Contact qualification of the Person Training Plan Approver Address Line 1 of the Person Training Plan Approver Address Line 2 of the Person Training Plan Approver Address Line 3 of the Person Training Plan Approver Address Line 4 of the Person Training Plan Approver Address Line 5 of the Person Training Plan Approver Aust Postcode of the Person Training Plan Approver OS Code of the Person Training Plan Approver Phone 1 of the Person Training Plan Approver Phone 2 of the Person Training Plan Approver Phone 3 of the Person Training Plan Approver Other Details of the Person Training Plan Approver Correspondence Indicator Person Training Plan Approver Endorsed Date

1. Header

Field Name	Field Description	Max Length	Type	Source/Value
CREATION_DT – CREATION DATE	The creation date of the extract	B	DATE	SYSDATE
KEY1 PERSON_ID	Person Training Plan Person ID	10	NUMBER	Person_trng_plan.person_id
KEY2 SEQUENCE_NUMBER	Person Training Plan sequence number.	6	NUMBER	Person_trng_plan.sequence_number
KEY3 CORRESPONDENCE_ TYPE	The correspondence type.	10	CHAR	Correspondence.correspondence_type
KEY4 PERSON_TRNG_PLAN_ STATUS	Person Training Plan Status	10	CHAR	Person_trng_plan.person_trng_plan_status
KEY5 TITLE	Person Training Plan Title	10	CHAR	Person_trng_plan.title
KEY6 CREATION_DT	Person Training Plan Creation date	B	DATE	Person_trng_plan.creation_dt
KEY7	NULL	B	B	B
KEY8	NULL	B	B	B
KEY9	NULL	B	B	B
KEY10	NULL	B	B	B
RECORD TYPE - RECORD_TYPE	Record Type	20	CHAR	'HEADER'
FIELD1	The Correspondence Type	10	CHAR	p_correspondence_type
FIELD2	The Person Training Plan Status	10	CHAR	p_person_trng_plan_status
FIELD3	The Person Training Plan Title	100	CHAR	p_ci_sequence_number
FIELD4	Record Correspondence Indicator	1	CHAR	p_record_correspondence
FIELD5	Ignore Previous Correspondence Records Indicator	1	CHAR	p_ignore_prev_corres_rec
FIELD6	Creation Date		DATE	p_creation_dt
FIELD7	Person ID	10	NUMBER	p_person_id
FIELD8	Person ID Group	10	CHAR	p_person_id_group_cd
FIELD9	Address Type	10	CHAR	institution_addr.addr_type
FIELD10	Address Line 1	40	CHAR	institution.addr_line_1
FIELD11	Address Line 2	40	CHAR	institution_addr.addr_line_2
FIELD12	Address Line 3	40	CHAR	institution_addr.addr_line_3
FIELD13	Address Line 4	40	CHAR	institution_addr.addr_line_4
FIELD14	Address Line 5	40	CHAR	institution_addr.addr_line_5
FIELD15	Australian Postcode	4	NUMBER	institution_addr.aust_postcode
FIELD16	Overseas Code	10	CHAR	institution_addr.os_code
FIELD17	Phone 1	20	CHAR	institution_addr.phone_1
FIELD18	Phone 2	20	CHAR	institution_addr.phone_2
FIELD19	Phone 3	20	CHAR	institution_addr.phone_3
FIELD20	Other Details	40	CHAR	institution_addr.other_details
FIELD21-26	NULL	B	B	B

2. Person

Field Name	Field Description	Max Length	Type	Source/Value
CREATION_DT – CREATION DATE	The creation date of the extract	B	DATE	SYSDATE
KEY1 PERSON_ID	Person Training Plan Person ID	10	NUMBER	Person_trng_plan.person_id
KEY2 SEQUENCE_NUMBER	Person Training Plan sequence number.	6	NUMBER	Person_trng_plan.sequence_number
KEY3 CORRESPONDENCE_ TYPE	The correspondence type.	10	CHAR	Correspondence.correspondence_type
KEY4 PERSON_TRNG_PLAN_ STATUS	Person Training Plan Status	10	CHAR	Person_trng_plan.person_trng_plan_status
KEY5 TITLE	Person Training Plan Title	10	CHAR	Person_trng_plan.title
KEY6 CREATION_DT	Person Training Plan Creation date		DATE	Person_trng_plan.creation_dt
KEY7	NULL	B	B	B
KEY8	NULL	B	B	B
KEY9	NULL	B	B	B
RECORD TYPE - RECORD_TYPE	Record Type	20	CHAR	'PERSON'
FIELD1	Person ID of the Person Training Plan	10	NUMBER	person.person_id
FIELD2	Title of the Person	10	CHAR	person.title
FIELD3	Surname of the person.	30	CHAR	person.surname
FIELD4	Given Names of the person	40	CHAR	person.given_names
FIELD5	Date of Birth of the person	60	DATE	Person.birth_dt
FIELD6	Email Address of the person	100	CHAR	Person.email_addr
FIELD7-26	B	B	B	B

3. Person Address

Field Name	Field Description	Max Length	Type	Source/Value
CREATION_DT – CREATION DATE	The creation date of the extract	B	DATE	SYSDATE
KEY1 PERSON_ID	Person Training Plan Person ID	10	NUMBER	Person_trng_plan.person_id
KEY2 SEQUENCE_NUMBER	Person Training Plan sequence number.	6	NUMBER	Person_trng_plan.sequence_number
KEY3 CORRESPONDENCE_ TYPE	The correspondence type.	10	CHAR	Correspondence.correspondence_type
KEY4 PERSON_TRNG_PLAN_ STATUS	Person Training Plan Status	10	CHAR	Person_trng_plan.person_trng_plan_status
KEY5 TITLE	Person Training Plan Title	10	CHAR	Person_trng_plan.title
KEY6 CREATION_DT	Person Training Plan Creation date	B	DATE	Person_trng_plan.creation_dt
KEY7	NULL	B	B	B
KEY8	NULL	B	B	B
KEY9	NULL	B	B	B
KEY10	NULL	B	B	B
RECORD TYPE - RECORD_TYPE	Record Type	20	CHAR	‘ADDRESS’
FIELD1	Person ID	10	CHAR	person.person_id
FIELD2	Address Type	10	CHAR	person_addr.addr_type
FIELD3	Address Line 1	40	CHAR	person_addr.addr_line_1
FIELD4	Address Line 2	40	CHAR	person_addr.addr_line_2
FIELD5	Address Line 3	40	CHAR	person_addr.addr_line_3
FIELD6	Address Line 4	40	CHAR	person_addr.addr_line_4
FIELD7	Address Line 5	40	CHAR	person_addr.addr_line_5
FIELD8	Australian Postcode	4	CHAR	person_addr.aust_postcode
FIELD9	Overseas Postal Code	10	CHAR	person_addr.os_code
FIELD10	Phone 1	20	CHAR	person_addr.phone_1
FIELD11	Phone 2	20	CHAR	person_addr.phone_2
FIELD12	Phone 3	20	CHAR	person_addr.phone_3
FIELD13	Other Details	40	CHAR	person_addr.other_details
FIELD14	Correspondence check box	1	CHAR	addr_type.correspondence_ind
FIELD15-26	B	Blank	B	B

4. Person Training Plan Details

Field Name	Field Description	Max Length	Type	Source/Value
CREATION_DT – CREATION DATE	The creation date of the extract	B	DATE	SYSDATE
KEY1 PERSON_ID	Person Training Plan Person ID	10	NUMBER	Person_trng_plan.person_id
KEY2 SEQUENCE_NUMBER	Person Training Plan sequence number.	6	NUMBER	Person_trng_plan.sequence_number
KEY3 CORRESPONDENCE_ TYPE	The correspondence type.	10	CHAR	Correspondence.correspondence_type
KEY4 PERSON_TRNG_PLAN_ STATUS	Person Training Plan Status	10	CHAR	Person_trng_plan.person_trng_plan_status
KEY5 TITLE	Person Training Plan Title	10	CHAR	Person_trng_plan.title
KEY6 CREATION_DT	Person Training Plan Creation date	B	DATE	Person_trng_plan.creation_dt
KEY7 COURSE_CD	Person Training Plan Course Code	10	CHAR	Person_trng_plan.course_cd
KEY8	NULL	B	B	B
KEY9	NULL	B	B	B
KEY10	NULL	B	B	B
RECORD TYPE - RECORD_TYPE	Record Type	20	CHAR	‘PTP-DETAILS’
FIELD1	Person training plan person id.	10	NUMBER	person_trng_plan.person_id
FIELD2	person training plan person sequence number	6	NUMBER	person_trng_plan.sequence_number
FIELD3	person training plan creation date	B	DATE	person_trng_plan.creation_dt
FIELD4	person training plan start date	B	DATE	person_trng_plan.start_dt
FIELD5	person training plan end date	B	DATE	person_trng_plan.end_dt
FIELD6	person training plan title	10	CHAR	person_trng_plan.title
FIELD7	person training plan NAN receipt date	B	DATE	person_trng_plan.nan_receipt_dt
FIELD8	person training plan training template code	10	CHAR	person_trng_plan.trng_plan_template_cd
FIELD9	person training plan template code version number	6	NUMBER	person_trng_plan.tptm_version_number
FIELD10	person training plan employer endorsement required indicator	1	CHAR	person_trng_plan.emp_endorsement_req_ind
FIELD11	person training plan school based training plan indicator	1	CHAR	person_trng_plan.school_based_training_plan_ind
FIELD12	person training plan status reviewed date	10	DATE	person_trng_plan.status_review_dt
FIELD13	person training plan status comments	10	CHAR	person_trng_plan.status_comments
FIELD14	person training plan comments	2000	CHAR	person_trng_plan.comments
FIELD15-26	NULL	B	B	B

5. Person Course Details

Field Name	Field Description	Max Length	Type	Source/Value
CREATION_DT – CREATION DATE	The creation date of the extract	B	DATE	SYSDATE
KEY1 PERSON_ID	Person Training Plan Person ID	10	NUMBER	Person_trng_plan.person_id
KEY2 SEQUENCE_NUMBER	Person Training Plan sequence number.	6	NUMBER	Person_trng_plan.sequence_number
KEY3 CORRESPONDENCE_ TYPE	The correspondence type.	10	CHAR	Correspondence.correspondence_type
KEY4 PERSON_TRNG_PLAN_ STATUS	Person Training Plan Status	10	CHAR	Person_trng_plan.person_trng_plan_status
KEY5 TITLE	Person Training Plan Title	10	CHAR	Person_trng_plan.title
KEY6 CREATION_DT	Person Training Plan Creation date	B	DATE	Person_trng_plan.creation_dt
KEY7 COURSE_CD	Person Training Plan Course Code	10	CHAR	Person_trng_plan.course_cd
KEY8 VERSION_NUMBER	Person Training Plan Course Version Number	10	CHAR	Student_course_attempt.version_number
KEY9	NULL	B	B	B
KEY10	NULL	B	B	B
RECORD TYPE	Record Type	20	CHAR	‘PTP-COURSE-DETAILS’
FIELD1	Person ID of the person training plan	10	NUMBER	Person_trng_plan.person_id
FIELD2	Person ID Sequence of the person training plan	6	NUMBER	Person_trng_plan.sequence_number
FIELD3	Course Code of the Person Training Plan Person	10	CHAR	Student_course_attempt.course_cd
FIELD4	Course Version Number Person Training Plan Person	3	CHAR	Student_course_attempt.version_number
FIELD5	Course Version Number Person Training Plan Person	40	CHAR	Student_course_attempt.version_number
FIELD6	Course Location Code of the Person Training Plan Person	10	CHAR	Student_course_attempt.location_cd
FIELD7	Course Attendance mode of the Person Training Plan Person	40	CHAR	Student_course_attempt.attendance_mode
FIELD8	Course Attendance Type of the Person Training Plan Person	40	CHAR	Student_course_attempt.attendance_type
FIELD9	Course attempt status of the Person Training Plan Person	40	CHAR	Student_course_attempt.course_attempt_status
FIELD10	Student Course Confirmed Indicator	40	CHAR	Student_course_attempt.student_confirmed_ind
FIELD11-26	NULL	B	B	B

6. Person Approver Details

Field Name	Field Description	Max Length	Type	Source/Value
CREATION_DT – CREATION DATE	The creation date of the extract	11	DATE	SYSDATE
KEY1 PERSON_ID	Person Training Plan Person ID	10	NUMBER	person_trng_plan.person_id
KEY2 SEQUENCE_NUMBER	Person Training Plan sequence number	6	NUMBER	person_trng_plan.sequence_number
KEY3 CORRESPONDENCE_TYPE	Correspondence type	10	CHAR	correspondence.correspondence_type
KEY4 PERSON_TRNG_PLAN_STATUS	Person Training Plan Status	10	CHAR	person_trng_plan.person_trng_plan_status
KEY5 TITLE	Person Training Plan Title	10	CHAR	person_trng_plan.title
KEY6 CREATION_DT	Person Training Plan Creation date	B	DATE	Person_trng_plan.creation_dt
KEY7 COURSE_CD	Person Training Plan Course Code	10	CHAR	Person_trng_plan.course_cd
KEY8 VERSION_NUMBER	Person Training Plan Course Version Number	10	CHAR	Student_course_attempt.version_number
KEY9 APPROVER_TYPE	Person Training Plan Approver Type	10	CHAR	person_trng_plan_approver.trng_plan_approver_type
KEY10	NULL	B	B	B
RECORD_TYPE	Record Type	20	CHAR	‘PTP-APROVER-DTLS’
FIELD1	Person Training Plan Approver Type	10	NUMBER	person_trng_plan_approver.trng_plan_approver_type
FIELD2	Name of the Person Training Plan Approver	10	CHAR	person_trng_plan_approver.approver_person_name
FIELD3	Contact name of the Person Training Plan Approver	30	CHAR	person_trng_plan_approver.contact_person_name
FIELD4	Contact position of the Person Training Plan Approver	40	CHAR	person_trng_plan_approver.contact_position
FIELD5	Contact qualification of the Person Training Plan Approver	10	CHAR	person_trng_plan_approver.contact_qualification
FIELD6	Address Line 1 of the Person Training Plan Approver	40	CHAR	person_trng_plan_approver.addr_line_1
FIELD7	Address Line 2 of the Person Training Plan Approver	40	CHAR	person_trng_plan_approver.addr_line_2
FIELD8	Address Line 3 of the Person Training Plan Approver	40	CHAR	person_trng_plan_approver.addr_line_3
FIELD9	Address Line 4 of the Person Training Plan Approver	40	CHAR	person_trng_plan_approver.addr_line_4
FIELD10	Address Line 5 of the Person Training Plan Approver	40	CHAR	person_trng_plan_approver.addr_line_5
FIELD11	Aust Postcode of the Person Training Plan Approver	4	NUMBER	person_trng_plan_approver.aust_postcode
FIELD12	OS Code of the Person Training Plan Approver	10	CHAR	person_trng_plan_approver.os_code
FIELD13	Phone 1 of the Person Training Plan Approver	20	CHAR	person_trng_plan_approver.phone_1
FIELD14	Phone 2 of the Person Training Plan Approver	20	CHAR	person_trng_plan_approver.phone_2
FIELD15	Phone 3 of the Person Training Plan Approver	20	CHAR	Person_addr.hone_3
FIELD16	Other details of the Person Training Plan Approver	40	CHAR	person_trng_plan_approver.other_details
FIELD17	Correspondence Indicator	1	CHAR	person_trng_plan_approver.correspondence_ind
FIELD18	Person Training Plan Approver Endorsed Date	B	DATE	person_trng_plan_approver.endorsed_dt
FIELD19 – 26	NULL	B	B	B

7. Footer (Record Counts)

Field Name	Field Description	Max Length	Type	Source/Value
CREATION_DT – CREATION DATE	The creation date of the extract	11	DATE	SYSDATE
KEY1 PERSON_ID	Person Training Plan Person ID	10	NUMBER	person_trng_plan.person_id
KEY2 SEQUENCE_NUMBER	Person Training Plan sequence number	6	NUMBER	person_trng_plan.sequence_number
KEY3 CORRESPONDENCE_TYPE	Correspondence type	10	CHAR	correspondence.correspondence_type
KEY4 PERSON_TRNG_PLAN_STATUS	Person Training Plan Status	10	CHAR	person_trng_plan.person_trng_plan_status
KEY5	NULL	B	B	B
KEY6	NULL	B	B	B
KEY7	NULL	B	B	B
KEY8	NULL	B	B	B
KEY9	NULL	B	B	B
KEY10	NULL	B	B	B
RECORD_TYPE	Record Type	20	CHAR	‘FOOTER’
FIELD1	For each person, count of record type PERSON TRAINING PLAN DETAILS	6	NUMBER	Calculated
FIELD2	For each person, count of record type PERSON TRAINING PLAN APPROVER DETAILS	6	NUMBER	Calculated
FIELD3	For each person, count of record type PERSON TRAINING PLAN COURSE DETAILS	6	NUMBER	Calculated
FIELD4 – 26	NULL	B	B	B

Last modified on 7 May, 2008 5:17 PM

History Information

Release Version	Project	Change to Document
11.0.0.0.0.0	1416 - Apprentice Management	New job.