Top of ENR Index Table of Contents Feedback

ENRJ9030 - Training Plan Schedule Extract

Note: If you wish to print this help page, then you should select landscape settings.

Purpose

Use this job to extract Person Training Plan data. This extract can be run for one or many Person Training Plans.

SubSystem

Enrolments
Normally Run By Apprenticeship Staff
Anticipated Frequency As Required
Structure  Block Person Training Plan Extract
Buttons Find Person (ADMF1213)
Find Course (ADMF1220)

 

Person Training Plan Extract

The extract includes:

  • Person/Apprentice details
  • Person Training Plan details
  • Employer and Host Employer details
  • RTO Assessor details
  • Person Training Plan unit groups and unit details
  • All generic Training Plan text content and all text content for the Person Training Plan
  • Approver details of those required to sign the Person Training Plan

This job extracts all Person Training Plan details that are available.
After this has been created for a specific Person Training Plan, the date will be recorded against the Person Training Plan extracted date to identify when it was created.
RTOs can then utilise this information to create their own Person Training Plan or for reporting purposes.

This job is accessed via the main menu.

 

The Person Training Extract block contains:

Parameters

  • Run For Person Training Plan
  • Person ID
  • Person Training Plan Status
  • Course Code
  • Start Date Range
  • End Date Range
  • Include Unit Schedule check box

Parameters

  • Run For Date Extracted
  • Training Plan Extracted Date Range
  • Include Unit Schedule check box

  • Buttons

    • Find Person
    • Find Course
    • Calendar

Rule/Notes:

The set of parameters displayed depends on the value select in the Run For: field.

Person Training Plans are not extracted for Deceased Persons.

 

1. For Person Training Plan:

S_EXTRACT record

Column

Data

Training Plan TemplateUnit

S_EXTRACT_TYPE

TP-PERSON

CREATION_DT

Sysdate
KEY

p_person_ id ||’|’|| p_person_trng_plan_status ||’|’|| p_ptp_course_cd ||’|’||
p_ptp_start_between ||’|’||
p_ptp_start_and ||’|’||
p_ptp_end_between ||’|’||
p_ptp_end_and
REQUEST_JOB_RUN_ID

As passed in by job scheduler

S_EXTRACT_RECORD records

Column

Data

Person Training Plan Details

Alternate Person *

 Person Details Person Address Approver Unit Group

Unit Details
If the ‘Include Unit Schedule’ is ‘Y’, create extra data**

 Unit Details**

S_EXTRACT_TYPE

TP-PER-EXT

TP-PERSON

 TP-PER-EXT

TP-PER-EXT

TP-PER-EXT

 TP-PER-EXT

TP-PER-EXT

TP-PERSON

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

 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

 Ser_sequence_number.nextval

Ser_sequence_number.nextval

Ser_sequence_number.nextval
KEY1

Ptp.person_id

Ptp.person_id

 Ptp.person_id

Ptp.person_id

Ptp.person_id

 Ptp.person_id

Ptp.person_id

Ptp.person_id
KEY2

Ptp.sequence_number

Ptp.sequence_number

 Ptp.sequence_number

Ptp.sequence_number

Ptp.sequence_number

 Ptp.sequence_number

Ptp.sequence_number

Ptp.sequence_number
KEY3

NULL

NULL

 NULL

NULL

NULL

 Ptp.trng_plan_template_cd

Ptp.trng_plan_template_cd

Ptp.trng_plan_template_cd
KEY4

NULL

NULL

 NULL

NULL

NULL

 Ptp.tptm_version_number

Ptp.tptm_version_number

Ptp.tptm_version_number
KEY5

NULL

NULL

 NULL

NULL

NULL

 NULL

ptpug.trng_plan_tmplt_unit_group_cd

ptpug.trng_plan_tmplt_unit_group_cd
KEY6

P_ext_between_dt

NULL

 P_ext_between_dt

P_ext_between_dt

P_ext_between_dt

 P_ext_between_dt

P_ext_between_dt

NULL
KEY7

P_ext_and_dt

NULL

 P_ext_and_dt

P_ext_and_dt

P_ext_and_dt

 P_ext_and_dt

P_ext_and_dt

NULL
KEY8

NULL

NULL

 NULL

NULL

NULL

 NULL

NULL

NULL
KEY9

NULL

NULL

 NULL

NULL

NULL

 NULL

NULL

NULL
KEY10

NULL

NULL

 NULL

NULL

NULL

 NULL

NULL

NULL
RECORD_TYPE

PERSON TRAINING PLAN

ALT PERSON ID

 PERSON

ADDRESS

APPROVER

 UNIT GROUP

UNIT

UNIT SCHEDULE
TEXT

ptp.person_id ||’|’|| ptp.sequence_number ||’|’|| ptp.title ||’|’|| ptp.person_trng_plan_status||’|’|
|ptp.creation_dt||’|’||
ptp.start_dt ||’|’||ptp.end_dt ||’|’||ptp.course_cd  ||’|’|| crv.title

api.api_person_id ||’|’|| api.person_id_type ||’|’|| api.start_dt  ||’|’|| api.end_dt

pe.person_id ||’|’||
pe.title ||’|’||
pe.given_names ||’|’|| pe.surname

pa.person_id ||’|’||
pa.addr_type ||’|’|| pa.addr_line_1||’|’|| pa.addr_line_2||’|’||
pa.addr_line_3 ||’|’|| pa.addr_line_4 ||’|’|| pa.addr_line_5||’|’|| pa.aust_postcode ||’|’|| pa.os_code ||’|’||
pa.phone_1 ||’|’||
pa.phone_2 ||’|’|| pa.phone_3||’|’|| pa.other_details ||’|’|| pa.correspondence_ind

ptpa.person_id ||’|’|| ptpa.ptp_sequence_number ||’|’|| ptpa.sequence_number ||’|’|| ptpa.trng_plan_approver_type||’|’|| ptpa.display_order||’|’||
ptpa.compulsory_indicator ||’|’||

More fields here depending on the ptpa.trng_plan_approver_type

see Approver details

 ptpug.trng_plan_tmplt_unit_group_cd ||’|’||
ptpug.title||’|’||
ptpug.display_order

ptpu.unit_cd ||’|’|| ptpu.uv_version_number ||’|’||
uv.title

ptpu.unit_cd ||’|’||
ptpu.uv_version_number ||’|’||
uv.title||’|’||
ptpu.intended_delivery_details||’|’||
ptpu.intended_assessment_details||’|’||
ptpu.intended_delivery_dt||’|’||
ptpu.intended_unit_period

* Alternate Person ID Details – only extracted where the alternate_person_id has a person_id_type with a system value of ‘TCI’ and the current date is between or equal to the alternate person_id start and end dates.

2. For Date Extracted:

S_EXTRACT record

Column

Data

Training Plan TemplateUnit

S_EXTRACT_TYPE

TP-PER-EXT

CREATION_DT

Sysdate
KEY

p_ext_between_dt ||’|’||
p_ext_and_dt
REQUEST_JOB_RUN_ID

As passed in by job scheduler

S_EXTRACT_RECORD records

Column

Data

Person Training Plan Details

Alternate Person *

 Person Details Person Address Approver Unit Group Unit Details
 Unit Details**
If the ‘Include Unit Schedule’ is ‘Y’, create extra data as below

S_EXTRACT_TYPE

TP-PER-EXT

TP-PER-EXT

TP-PER-EXT

TP-PER-EXT

TP-PER-EXT

 TP-PER-EXT

TP-PER-EXT

TP-PER-EXT

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

 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

 Ser_sequence_number.nextval

Ser_sequence_number.nextval

Ser_sequence_number.nextval
KEY1

Ptp.person_id

Ptp.person_id

Ptp.person_id

Ptp.person_id

Ptp.person_id

 Ptp.person_id

Ptp.person_id

Ptp.person_id
KEY2

Ptp.sequence_number

Ptp.sequence_number

Ptp.sequence_number

Ptp.sequence_number

Ptp.sequence_number

 Ptp.sequence_number

Ptp.sequence_number

Ptp.sequence_number
KEY3

NULL

NULL

NULL

NULL

NULL

 Ptp.trng_plan_template_cd

Ptp.trng_plan_template_cd

Ptp.trng_plan_template_cd
KEY4

NULL

NULL

NULL

NULL

NULL

 Ptp.tptm_version_number

Ptp.tptm_version_number

Ptp.tptm_version_number
KEY5

NULL

NULL

NULL

NULL

NULL

 NULL

ptpug.trng_plan_tmplt_unit_group_cd

ptpug.trng_plan_tmplt_unit_group_cd
KEY6

P_ext_between_dt

P_ext_between_dt

P_ext_between_dt

P_ext_between_dt

P_ext_between_dt

 P_ext_between_dt

P_ext_between_dt

P_ext_between_dt
KEY7

P_ext_and_dt

P_ext_and_dt

P_ext_and_dt

P_ext_and_dt

P_ext_and_dt

 P_ext_and_dt

P_ext_and_dt

P_ext_and_dt
KEY8

NULL

NULL

NULL

NULL

NULL

 NULL

NULL

NULL
KEY9

NULL

NULL

NULL

NULL

NULL

 NULL

NULL

NULL
KEY10

NULL

NULL

NULL

NULL

NULL

 NULL

NULL

NULL
RECORD_TYPE

PERSON TRAINING PLAN

ALT PERSON ID

PERSON

ADDRESS

APPROVER

 UNIT GROUP

UNIT

UNIT SCHEDULE
TEXT

Ptp.person_id ||’|’||
ptp.sequence_number ||’|’||
ptp.title ||’|’|| ptp.person_trng_plan_status||’|’||
ptp.creation_dt||’|’||
ptp.start_dt ||’|’||
ptp.end_dt ||’|’||
ptp.course_cd  ||’|’||
crv.title

Api.api_person_id ||’|’|| api.person_id_type ||’|’|| api.start_dt  ||’|’||
api.end_dt

Pe.person_id ||’|’||
pe.title ||’|’||
pe.given_names ||’|’|| pe.surname

Pa.person_id ||’|’|| pa.addr_type ||’|’|| pa.addr_line_1||’|’|| pa.addr_line_2||’|’||
pa.addr_line_3 ||’|’|| pa.addr_line_4 ||’|’|| pa.addr_line_5||’|’|| pa.aust_postcode ||’|’|| pa.os_code ||’|’||
pa.phone_1 ||’|’||
pa.phone_2 ||’|’|| pa.phone_3||’|’|| pa.other_details ||’|’|| pa.correspondence_ind

Ptpa.person_id ||’|’|| ptpa.ptp_sequence_number ||’|’|| ptpa.sequence_number ||’|’|| ptpa.trng_plan_approver_type||’|’|| ptpa.display_order||’|’||
ptpa.compulsory_indicator ||’|’||

More fields here depending on the ptpa.trng_plan_approver_type

see Approver details

 ptpug.trng_plan_tmplt_unit_group_cd ||’|’||
ptpug.title||’|’||
ptpug.display_order

ptpu.unit_cd ||’|’|| ptpu.uv_version_number ||’|’||
uv.title

ptpu.unit_cd ||’|’||
ptpu.uv_version_number ||’|’||
uv.title||’|’||
ptpu.intended_delivery_details||’|’||
ptpu.intended_assessment_details||’|’||
ptpu.intended_delivery_dt||’|’||
ptpu.intended_unit_period

* Alternate Person ID Details – only extracted where the alternate_person_id has a person_id_type with a system value of ‘TCI’ and the current date is between or equal to the alternate person_id start and end dates.

 

Last modified on 7 May, 2008 5:33 PM

History Information

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