TRN_INS_NAME_VW (SQL View)	Index Back
Instructors Name View Administer Training/Budget Training modules. View to retrieve from PERSONAL_DATA the instructor's name and the alternate character name.

TRN_INS_NAME_VW

(SQL View)

Instructors Name View

Administer Training/Budget Training modules. View to retrieve from PERSONAL_DATA the instructor's name and the alternate character name.

SELECT A.INSTRUCTOR_ID , B.NAME , B.NAME_AC FROM PS_TRN_INSTRCT_TBL A , PS_PERSON_NAME B WHERE A.INSTRUCTOR_ID = B.EMPLID AND %EffdtCheck(TRN_INSTRCT_TBL, A, %currentdatein) AND A.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTRUCTOR_ID Character(11) VARCHAR2(11) NOT NULL Instructor ID

2 NAME Character(50) VARCHAR2(50) NOT NULL Name

3 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTRUCTOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Instructor ID
2	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
3	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name