COURSEPrompt Table: COURSE_TBL
INSTRUCTOR_IDPrompt Table: TRN_INSTRCT_TBL
LANGUAGE_CDTRN_CRS_INSTR_L(SQL View) |
Index Back |
|---|---|
Rel lang for TRN_CRS_INSTRCTRelated language record for TRN_CRS_INSTRCT. |
| SELECT A.COURSE ,A.INSTRUCTOR_ID ,C.LANGUAGE_CD ,C.NAME_DISPLAY FROM PS_TRN_INSTRCT_CRS A ,PS_NAMES_LNG C WHERE C.EMPLID = A.INSTRUCTOR_ID AND C.NAME_TYPE = 'PRI' AND %EffdtCheck(NAMES_LNG, C, %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COURSE |
Character(6) | VARCHAR2(6) NOT NULL |
Course Code
Prompt Table: COURSE_TBL |
| 2 | INSTRUCTOR_ID |
Character(11) | VARCHAR2(11) NOT NULL |
Instructor ID
Prompt Table: TRN_INSTRCT_TBL |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |