XML_TRN_IN_I_VW

(SQL View)
 Index Back

FT Online Instructor Data

Tripartite Foundation. Online Training Instructor Data

SELECT A.COURSE , A.SESSION_NBR , B.INSTRUCTOR_ID , C.FIRST_NAME , C.LAST_NAME , C.SECOND_LAST_NAME , D.NATIONAL_ID_TYPE , D.NATIONAL_ID , B.TRN_T_HOURS_ESP , C.PHONE , C.EMAIL_ADDR , B.TRN_T_PROFILE_ESP FROM %Table(TRN_T_SESSN_ESP) A , %Table(TRN_T_INS_I_ESP) B , %Table(PERSDATA_ESP_VW) C , PS_EMP_DOC_ESPVW D WHERE A.COURSE = B.COURSE AND A.SESSION_NBR = B. SESSION_NBR AND B.INSTRUCTOR_ID = C. EMPLID AND D.EMPLID = C.EMPLID AND D.NATIONAL_ID_TYPE = ( SELECT MIN(D2.NATIONAL_ID_TYPE) FROM PS_EMP_DOC_ESPVW D2 WHERE D2.EMPLID = D.EMPLID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COURSE Character(6) VARCHAR2(6) NOT NULL Course Code

Prompt Table: CRSE_SESSN_SRCH

2 SESSION_NBR Character(4) VARCHAR2(4) NOT NULL Course Session Nbr
3 INSTRUCTOR_ID Character(11) VARCHAR2(11) NOT NULL Instructor ID

Prompt Table: TRN_INSTR_SRCH

4 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
5 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
6 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
7 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type
8 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
9 TRN_T_HOURS_ESP Number(7,2) DECIMAL(6,2) NOT NULL Total Hours
10 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
11 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
12 TRN_T_PROFILE_ESP Character(1) VARCHAR2(1) NOT NULL Instructor Profile
1=Trainer
2=Team Builder
2=Team Builder
3=Trainer/Team Builder
3=Both