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 C.OPRID , C.RUN_CNTL_ID , 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 PS_TRN_T_ENRL_ESP A , PS_PERSDATA_ESP_VW D , PS_XML_SSN_ESP_VW E , PS_TRN_T_RC_EE_ESP C WHERE A.ATTENDANCE = 'E' AND A.EMPLID = D.EMPLID AND E.EMPLID = A.EMPLID AND A.COURSE = C.COURSE AND A.SESSION_NBR = C.SESSION_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Default Value: PSOPRDEFN.OPRID

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 COURSE Character(6) VARCHAR2(6) NOT NULL Course Code
4 SESSION_NBR Character(4) VARCHAR2(4) NOT NULL Course Session Nbr
5 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
6 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type
7 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
8 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
9 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
10 TRN_T_SSN_ESP Character(20) VARCHAR2(20) NOT NULL Social Security Number
11 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
12 BIRTHDATE Date(10) DATE Date of Birth