XML_TRN_IN_D_VW

(SQL View)
 Index Back

FT Long Distance Instruct Data

Tripartite Foundation. Long Distance Training Instructor data

SELECT A.COURSE , A.SESSION_NBR , C.FIRST_NAME , C.LAST_NAME , C.SECOND_LAST_NAME , C.NATIONAL_ID , B.TRN_T_HOURS_ESP FROM %Table(TRN_T_SESSN_ESP) A , %Table(TRN_T_INS_D_ESP) B , %Table(PERSDATA_ESP_VW) C WHERE A.COURSE = B.COURSE AND A.SESSION_NBR = B. SESSION_NBR AND B.INSTRUCTOR_ID = C. 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 Character(20) VARCHAR2(20) NOT NULL National ID
7 TRN_T_HOURS_ESP Number(7,2) DECIMAL(6,2) NOT NULL Total Hours