COURSEPrompt Table: COURSE_SRCH_VW
SESSION_NBRLANGUAGE_CDTRN_T_SESN_LNG(SQL View) |
Index Back |
|---|---|
Search record Sess- Rel. Lang.Related Language Record for TRN_T_SESN_SRCH |
| SELECT A.COURSE ,B.SESSION_NBR ,D.LANGUAGE_CD ,A.DESCR FROM %Table(COURSE_TBL) A ,%Table(COURSE_TBL_LANG) D , %Table(CRSE_SESSN_TBL) B LEFT OUTER JOIN %Table(TRN_T_SESSN_ESP) C ON C.COURSE = B.COURSE AND C.SESSION_NBR = B.SESSION_NBR WHERE A.SESSN_ADMINISTRATN = 'Y' AND A.COURSE = B.COURSE AND A.COURSE = D.COURSE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COURSE |
Character(6) | VARCHAR2(6) NOT NULL |
Course Code
Prompt Table: COURSE_SRCH_VW |
| 2 | SESSION_NBR |
Character(4) | VARCHAR2(4) NOT NULL | Course Session Nbr |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |