Top of ENR Index Table of Contents Feedback

ENRJ9020 - Training Plan Template Extract

Purpose

This job extracts informationcontained in one or more Training Plan Templates.

SubSystem

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

 

Training Plan Template Extract

This job extracts data for Training Plan Templates that satisfy the parameters.
Information extracted in this process will include:

  • Training Plan Template details
  • Employer and host employer details
  • RTO Assessor details
  • Training Plan Template Unit Groups
  • All text content for the Training Plan Template
  • Approver details of those required to sign the Training Plan Template

RTOs can then utilise this information to create their own Training Plan Template or for reporting purposes.

This job is accessed via the Callista menu.

 

The Training Plan Template Extract block contains:

Parameters

  • Training Plan Template Code
  • Training Plan Template Status
  • Approver Person ID
  • Employer Code
  • Course Code
  • Start Date Range
  • End Date Range

    Buttons

    • Find Person
    • Find Course
    • Calendar

Rule/Notes:

An entry must be made for at least one parameter.

Person ID and Course Code must exist in Callista.

 

 

S_EXTRACT record

Column

Data

Training Plan TemplateUnit

S_EXTRACT_TYPE

TPTEMPLATE

CREATION_DT

Sysdate
KEY

p_trng_plan_template_cd p_tpt_version_number
p_trng_plan_status
p_approver_person_id
p_employer_cd
p_course_cd
p_crv_version_number
p_tpt_start_dt_between
p_tpt_start_dt_and
p_tpt_end_dt_between
REQUEST_JOB_RUN_ID

As passed in by job scheduler

S_EXTRACT_RECORD records

Column

Data

Training Plan Template Details

 Course Details Approver Details Unit Group Details Unit 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

Trng_plan_template_cd

Tpt.Trng_plan_template_cd

Tpt.Trng_plan_template_cd

Tpt.Trng_plan_template_cd

Tpt.Trng_plan_template_cd
KEY2

Version_number

Tpt.Version_number

tpt.Version_number

tpt.Version_number

tpt.Version_number
KEY3

NULL

Tptcoo.course_cd

NULL

NULL

Tptcoo.course_cd
KEY4

NULL

Tptcoo.crv_course_version

NULL

NULL

Tptcoo.crv_course_version
KEY5

NULL

NULL

NULL

NULL

tptug.trng_plan_tmplt_unit_group_cd
KEY6

NULL

NULL

NULL

NULL

NULL
KEY7

NULL

NULL

NULL

NULL

NULL
KEY8

NULL

NULL

NULL

NULL

NULL
KEY9

NULL

NULL

NULL

NULL

NULL
KEY10

NULL

NULL

NULL

NULL

NULL
RECORD_TYPE TRNG PLAN TEMPLATE

COURSE

ASSESSOR

UNIT GROUP

UNIT
TEXT

Tptm.
trng_plan_template_cd||’|’||
Tptm.
version_number ||’|’||
Tptm.title

crv.
course_cd ||’|’||
crv.
version_number||’|’||
crv.
title

tpta.person_id ||’|’|| tpta.sequence_number ||’|’|| tpta.trng_plan_approver_type||’|’|| tpta.display_order||’|’||
ptpa.signatory_compulsory_ind

More fields here depending on the ptpa.trng_plan_approver_type

tptug.trng_plan_tmplt_unit_group_cd ||’|’||
tptug.title||’|’||
tptug.display_order

tptu.unit_cd ||’|’|| tptu.uv_version_number ||’|’||
uv.title

For Training Plan Approver type ‘EMPLOYER’, the hierarchy is:

  1. Person
  2. Employer
  3. Person Training Plan Approver

For Training Plan Approver type ‘RTO’, get details from Institution.
For the rest, the hierarchy is

 

Last modified on 29 May, 2008 10:36 AM

History Information

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