TRN_INS_P_ESPVW

(SQL View)
 Index Back

FT Online Instructor Data

Tripartite Foundation. Online Training Instructor Data

SELECT A.COURSE , A.SESSION_NBR , 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 FROM %Table(TRN_T_SESSN_ESP) A , %Table(TRN_T_INS_P_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 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
4 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
5 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
6 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type
7 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
8 TRN_T_HOURS_ESP Number(7,2) DECIMAL(6,2) NOT NULL Total Hours
9 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
10 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address