Person Training Plan Approver Details Configuration

Person Training Plan Approver Details Configuration

The Approver details that are displayed in Person Training Plan Reports and Extracts depend upon the Approver Type. The Training Plan Approver Type may have a System Training Plan Approver Type of APPRENTICE, EMPLOYER, RTO, EMPLOYER_H, GUARDIAN, SCHOOL, OTHER. The details displayed for Approvers of different types are shown in the table below:

Approver Type	Label	Value (source)
Apprentice/Trainee	Surname	person.surname
	Other Names	person.given_names
	Student ID	person_tpa.person_id
	TCI	alternate_person_id.api_person_id where person_ID_type = ‘TCI’
	ACI	alternate_person_id.api_person_id where person_ID_type = ‘ACI’
	Address	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 Note: (current Correspondence Address) PERSON_ADDR.addr_type = addr_type.addr_type and addr_type.correspondence_ind = ‘Y’
RTO Representative	RTO Name	institution.name Where institution.local_institution_ind = ‘Y’
	RTO Contact	person.title person.given_names person.surname Note: use person_trng_plan_approver.contact_person_id
	Position	person_trng_plan_approver.contact_position
	Phone	person_addr.phone_1
	Email	person.email_addr
Employer	Business Name	employer.description
	Contact	If person_trng_plan_approver.contact_person_id is not null then person.title person.given_names person.surname Else person_trng_plan_approver.contact_person_name
	Position	person_trng_plan_approver.contact_position
	Address	If person_trng_plan_approver.contact_person_id is not null then get detail from person_addr: 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 (current Correspondence Address) person_addr.addr_type = addr_type.addr_type and addr_type.correspondence_ind = ‘Y’ Else if training_plan_template_approver.employer_cd is not null then get detail from employer employer.addr_line_1 employer.addr_line_2 employer.addr_line_3 employer.addr_line_4 employer.addr_line_5 employer.aust_postcode employer.os_code employer.phone_1 employer.phone_2 employer.phone_3 (current Correspondence Address) employer.addr_type = addr_type.addr_type and addr_type.correspondence_ind = ‘Y’ Else get detail from person_training_plan_approver: person_trng_plan_approver.addr_line_1 person_trng_plan_approver.addr_line_2 person_trng_plan_approver.addr_line_3 person_trng_plan_approver.addr_line_4 person_trng_plan_approver.addr_line_5 person_trng_plan_approver.Aust_postcode person_trng_plan_approver.Os_code person_trng_plan_approver.Phone_1 person_trng_plan_approver.Phone_2 person_trng_plan_approver.Phone_3 (current Correspondence Address) person_trng_plan_approver.addr_type = addr_type.addr_type and addr_type.corespondence_ind = ‘Y’
Host Employer	Business Name	employer.description
	Contact	If person_trng_plan_approver.contact_person_id is not null then person.title person.given_names person.surname Else person_trng_plan_approver.contact_person_name
	Position	person_trng_plan_approver.contact_position
	Address	If person_trng_plan_approver.contact_person_id is not null then get detail from person_addr: 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 (current Correspondence Address) person_addr.addr_type = addr_type.addr_type and addr_type.correspondence_ind = ‘Y’ Else if person_trng_plan_approver.employer_cd is not null then get detail from employer Emp.addr_line_1 Emp.addr_line_2 Emp.addr_line_3 Emp.addr_line_4 Emp.addr_line_5 Emp.aust_postcode Emp.os_code Emp.phone_1 Emp.phone_2 Emp.phone_3 (current Correspondence Address) emp.addr_type = adt.addr_type and addr_type.corespondence_ind = ‘Y’ Else get detail from person_trng_plan_approver: person_trng_plan_approver.addr_line_1 person_trng_plan_approver.addr_line_2 person_trng_plan_approver.addr_line_3 person_trng_plan_approver.addr_line_4 person_trng_plan_approver.addr_line_5 person_trng_plan_approver.Aust_postcode person_trng_plan_approver.Os_code person_trng_plan_approver.Phone_1 person_trng_plan_approver.Phone_2 person_trng_plan_approver.Phone_3 (current Correspondence Address) person_trng_plan_approver.addr_type = addr_type.addr_type and addr_type.correspondence_ind = ‘Y’
Guardian	Name	If person_trng_plan_approver.contact_person_id is not null then person.title person.given_names person.surname Else person_trng_plan_approver.contact_person_name
	Address	If person_trng_plan_approver.contact_person_id is not null then get detail from person_addr: 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 (current Correspondence Address) Person_addr.addr_type = addr_type.addr_type and addr_type.correspondence_ind = ‘Y’ Else get detail from person_trng_plan_approver: person_trng_plan_approver.addr_line_1 person_trng_plan_approver.addr_line_2 person_trng_plan_approver.addr_line_3 person_trng_plan_approver.addr_line_4 person_trng_plan_approver.addr_line_5 person_trng_plan_approver.Aust_postcode person_trng_plan_approver.Os_code person_trng_plan_approver.Phone_1 person_trng_plan_approver.Phone_2 person_trng_plan_approver.Phone_3 (current Correspondence Address) person_trng_plan_approver.addr_type = addr_type.addr_type and addr_type.correspondence_ind = ‘Y’
Other	Name	If person_trng_plan_approver.contact_person_id is not null then person.title person.given_names person.surname Else person_trng_plan_approver.contact_person_name
	Position	person_trng_plan_approver.contact_position
	Address	If person_trng_plan_approver.contact_person_id is not null then get detail from person_addr: 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 (current Correspondence Address) person_addr.addr_type = addr_type.addr_type and addr_type.correspondence_ind = ‘Y’ Else get detail from person_trng_plan_approver: person_trng_plan_approver.addr_line_1 person_trng_plan_approver.addr_line_2 person_trng_plan_approver.addr_line_3 person_trng_plan_approver.addr_line_4 person_trng_plan_approver.addr_line_5 person_trng_plan_approver.Aust_postcode person_trng_plan_approver.Os_code person_trng_plan_approver.Phone_1 person_trng_plan_approver.Phone_2 person_trng_plan_approver.Phone_3 (current Correspondence Address) person_trng_plan_approver.addr_type = addr_type.addr_type and addr_type.correspondence_ind = ‘Y’
School	Name	If person_trng_plan_approver.contact_person_id is not null then person.title person.given_names person.surname Else person_trng_plan_approver.contact_person_name
	Position	person_trng_plan_approver.contact_position
	Address	If person_trng_plan_approver.contact_person_id is not null then get detail from person_addr: 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 (current Correspondence Address) person_addr.addr_type = addr_type.addr_type and addr_type.correspondence_ind = ‘Y’ Else get detail from person_trng_plan_approver: person_trng_plan_approver.addr_line_1 person_trng_plan_approver.addr_line_2 person_trng_plan_approver.addr_line_3 person_trng_plan_approver.addr_line_4 person_trng_plan_approver.addr_line_5 person_trng_plan_approver.Aust_postcode person_trng_plan_approver.Os_code person_trng_plan_approver.Phone_1 person_trng_plan_approver.Phone_2 person_trng_plan_approver.Phone_3 (current Correspondence Address) person_trng_plan_approver.addr_type = addr_type.addr_type and addr_type.correspondence_ind = ‘Y’

Last Modified on 06-Jun-2008 5:17 PM

History Information

Release Version	Project	Change to Document
11.0.0.0.0.0	1614 - Apprentice Management	New help page