COURSEPrompt Table: COURSE_TBL
VENDORINSTRUCTOR_IDPrompt Table: TRN_INSTRCT_TBL
LANGUAGE_CDTRN_CRS_INSTVWL(SQL View) |
Index Back |
|---|---|
Rel Lang for TRN_CRS_INST_VWRelated language record for TRN_CRS_INST_VW. |
| SELECT A.COURSE ,B.VENDOR ,A.INSTRUCTOR_ID ,C.LANGUAGE_CD ,C.NAME_DISPLAY FROM PS_TRN_INSTRCT_CRS A ,PS_TRN_INSTRCT_TBL B ,PS_NAMES_LNG C WHERE B.INSTRUCTOR_ID = A.INSTRUCTOR_ID AND %EffdtCheck(TRN_INSTRCT_TBL, B, %currentdatein) AND 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 | VENDOR |
Character(6) | VARCHAR2(6) NOT NULL | Vendor ID |
| 3 | INSTRUCTOR_ID |
Character(11) | VARCHAR2(11) NOT NULL |
Instructor ID
Prompt Table: TRN_INSTRCT_TBL |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |