Top of ENR Index Table of Contents Feedback

ENRJ9070 - Person Training Plan Progress Extract

Purpose

This job is to extract data for the creation of a Person Training Plan Progress Extract

SubSystem

Enrolments
Normally Run By VET Administration Staff
Anticipated Frequency Enrolments
Structure  Block Person Training Plan Progress Extract
Tabs Parameters
More
Buttons Find Course (ADMF1220)
Calendar Lookup
Find Person (ADMF1213)

 

Person Training Plan Progress Extract

This job extracts the data that will be used by institutions to view the progress of a person's progress. It can be used to:

  • To provide details of the Course associated with the Training Plan
  • To compare units in the Course with units in the Person Training Plan
  • To track the progress of a student against the Person Training Plan
  • For reporting purposes

An S_EXTRACT record of type PTP-PRGRS is created. This includes the job run parameters and the request job run id.

The following S_EXTRACT_RECORD records are created for each Person Training Plan that satisfies the parameters:
  • PERSON as per the PERSON table definition below
  • ALT-PERSON-ID as per the ALTERNATE PERSON ID DETAILS table definition below
  • PERSON-TRAINING-PLAN as per the PERSON TRAINING PLAN DETAILS table definition below
  • ASSESSOR-DETAILS as per the TRAINER/ASSESSOR DETAILS table definition below
  • COURSE-ATMPT-DTLS as per the COURSE ATTEMPT DETAILS table definition below
  • UNITS-DETAILS as per the UNITS DETAILS table definition below
  • ADV-STANDING-DTLS as per the ADVANCED STANDING UNIT DETAILS table definition below
  • PTP-UNIT-SMRYas per the PERSON TRAINING PLAN UNIT SUMMARY table definition below

If any errors occur in creating the above records, all the associated records created for the person ID are rolled back and an entry is created in the run log.

This form is accessed via the main menu.

 

The Person Training Plan Progress Extract block contains:

Parameters

  • Training Plan Template Code
  • Person Training Plan Status
  • Course Code
  • Assessor Person ID
  • Person ID
  • Person ID Group
  • Start Date Range
  • End Date Range
  • Created After

Buttons

Rule/Notes:

An error is generated if a person ID is entered that does not exist.

Both person ID and Person ID cannot be specified together on the parameter form.

If no training plan records are found then an error is generated in the run log.

To run this job:

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

Rules/Notes:

 

 

S_EXTRACT record generated

Column

Data

S_EXTRACT_TYPE

PTP-PRGS

CREATION_DT

Sysdate

KEY
(created from the job parameters passed in the job request.)

p_trng_plan_template_cd|| ‘|’ ||
p_person_trng_plan_status|| ‘|’ ||
p_creation_dt|| ‘|’ ||
p_course_cd|| ‘|’ ||
p_assessor_person_id|| ‘|’ ||p_person_id|| ‘|’ ||
p_person_id_group

REQUEST_JOB_RUN_ID
As passed in by job scheduler

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-18 in the tables below. The associated view PTP_PROGRESS_RECORD_V has separate fields for each value.

Column

Data

Person

 Alernative Person ID Person Training Plan Course Attempt Details Trainer's/Assessors Details Unit Details Advanced Standing Unit Details Unit Summary (Record Counts)

S_EXTRACT_TYPE

TPTEMPLATE

TPTEMPLATE

TPTEMPLATE

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

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

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

person_trng_plan.
person_id

person_trng_plan.
person_id
KEY2

NULL

NULL

person_trng_plan.
sequence_number

person_trng_plan.
sequence_number

person_trng_plan_approver.
ptp_sequence_number

person_trng_plan.
sequence_number

person_trng_plan.
sequence_number

NULL
KEY3

NULL

NULL

NULL

student_course_attempt.
course_cd

student_course_attempt.
course_cd

student_course_attempt.
course_cd

student_course_attempt.
course_cd

NULL
KEY4

NULL

NULL

NULL

NULL

 person_trng_plan_approver.
sequence_number		 NULL NULL

NULL
KEY5

NULL

NULL

NULL

NULL

NULL

NULL

 student_unit_attempt.
unit_cd

NULL
KEY6

NULL

NULL

NULL

NULL

NULL

NULL

 unit_version.
version_number

NULL
KEY7

NULL

NULL

NULL

NULL

NULL

NULL

NULL

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'

'ALT-PERSON-ID'

'PERSON TRAINING PLAN'

'COURSE-ATTEMPT-DTLS’

 ‘ASSESSOR-DTLS’ ‘UNIT-DETAILS’ ‘ADV-STANDING-DTLS’

‘PTP-UNIT-SMRY’
TEXT

The following fields from the person table separated by ||’|’||

person_id
title
surname
given_names
birth_dt
email_addr

The following fields from the alt_person_id table separated by ||’|’||

api_person_id
person_id_type
start_dt
end_dt

The following fields from the person_trng_plan table separated by ||’|’||

person_id
sequence_number
creation_dt
start_dt
end_dt
title
nan_receipt_dt
trng_plan_template_cd
tptm_version_number
person_trng_plan_status
training_plan_extract-dt
course_cd
emp_endorsement_req_ind
school_based_training_plan_ind
status_udpate_on
status_review_dt
status_comments
comments

person_trng_plan.person_id||’|’||
person_trng_plan.sequence_number||’|’||
student_course_attempt.course_cd||’|’||
student_course_attempt.version_number||’|’||
student_course_attempt.location_cd||’|’||
Course_version.title||’|’||
student_course_attempt.attendance_mode||’|’||
student_course_attempt.attendance_type||’|’||
student_course_attempt.course_attempt_status||’|’|
student_course_attempt.student_confirmed_ind

The following fields from the person_trng_plan_approvertable separated by ||’|’||

trng_plan_approver_type
approver_person_name
contact_person_id
contact_person_name
contact_position
display_order

 Person_trng_plan.person_id||’|’||
Person_trng_plan.sequence_number||’|’||
Student_course_attempt.course_cd||’|’||
Student_course_attempt.version_number||’|’||
Course_version.title||’|’||
Unit_version.unit_cd||’|’||
Unit_version.version_number||’|’||
Unit_version.title||’|’||
Student_unit_attempt.calendar_type||’|’||
Student_unit_attempt.ci_sequence_number||’|’||
Student_unit_attempt.location_cd||’|’||
Student_unit_attempt.unit_class||’|’||
Student_unit_attempt.enrolled_dt||’|’||
Student_unit_attempt.uoo_id||’|’||
Student_unit_attempt.unit_attempt_status||’|’||
adv_stnd_unit.finalised_outcome_ind||’|’||
stdnt_unit_atmpt_outcome.grading_scheme||’|’||
stdnt_unit_atmpt_outcome.version_number||’|’||
stdnt_unit_atmpt_outcome.grade||’|’||
Grading_scheme_grade.s_result_type		 Person_trng_plan.
person_id||’|’||
Person_trng_plan.
sequence_number||’|’||
adv_stnd_unit.
as_course_cd||’|’||
adv_stnd_unit.
as_version_number||’|’||
adv_stnd_unit.
unit_cd||’|’||
adv_stnd_unit.
version_number||’|’||
adv_stnd_unit.
s_adv_stnd_type||’|’||
adv_stnd_unit.
adv_stnd_granting_status||’|’||
adv_stnd_unit.
credit_percentage||’|’||
adv_stnd_unit.
s_adv_stnd_recognition_type||’|’||
adv_stnd_unit.
approved_dt||’|’||
adv_stnd_unit.
granted_dt||’|’||
adv_stnd_unit.
expiry_dt||’|’||
adv_stnd_unit.
cancelled_dt||’|’||
adv_stnd_unit.
revoked_dt

Count of the total of the Person Training Plan Units||’|’||

Count of the Person Training Plan Units with a unit attempt status of ENROLLED ||’|’||

Count of the Person Training Plan Units with a unit attempt status of COMPLETE with a satisfactory final grade||’|’||

Count of the Person Training Plan Units  with an unit attempt status of COMPLETE with an unsatisfactory final grade ||’|’||

Count of the Person Training Plan units granted advanced standing||’|’||

 

Last modified on 29 May, 2008 10:59 AM

History Information

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