COURSESESSION_NBRXML_TRN_DIS_VW(SQL View) |
Index Back |
|---|---|
FT Disabled ParticipantsTripartite Foundation. Disabled participants enrolled in a course. |
| SELECT A.COURSE , A.SESSION_NBR , C.EMPLID , E.DISABLED FROM %Table(TRN_T_SESSN_ESP) A , %Table(TRAINING) C , %Table(DISABLTY_ESP_VW) E WHERE A.TRN_T_CHK_FNSH_ESP = 'Y' AND A.COURSE = C.COURSE AND A.SESSION_NBR = C.SESSION_NBR AND C.ATTENDANCE = 'C' AND C.EMPLID = E.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 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | DISABLED | Character(1) | VARCHAR2(1) NOT NULL | A flag that indicates whether or not (Y or N) a dependent is a disabled. |