XML_TRN_STUD_VW

(SQL View)
 Index Back

FT Students Data

Students inscribed in a course of the tripartite foundation. This view retrieves student data for PARTICIPANTES.XML file

SELECT A.COURSE , A.SESSION_NBR , D.NATIONAL_ID , D.NATIONAL_ID_TYPE , D.FIRST_NAME , D.LAST_NAME , D.SECOND_LAST_NAME , E.NATIONAL_ID , D.SEX , D.BIRTHDATE FROM %Table(TRN_T_SESSN_ESP) A , %Table(TRAINING) C , %Table(PERSDATA_ESP_VW) D , %Table(XML_SSN_ESP_VW) E WHERE A.COURSE = C.COURSE AND A.SESSION_NBR = C.SESSION_NBR AND C.ATTENDANCE = 'E' AND C.EMPLID = D.EMPLID AND E.EMPLID = C.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COURSE Character(6) VARCHAR2(6) NOT NULL Course Code
2 SESSION_NBR Character(4) VARCHAR2(4) NOT NULL Course Session Nbr
3 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
4 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type
5 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
6 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
7 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
8 TRN_T_SSN_ESP Character(20) VARCHAR2(20) NOT NULL Social Security Number
9 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
10 BIRTHDATE Date(10) DATE Date of Birth