COURSEPrompt Table: COURSE_TBL
Prompt Table: TRN_INSTRCT_TBL
E=External
I=Internal
TRN_CRS_INSTR_1(SQL View) |
Index Back |
|---|---|
Qualified Instructors - CourseTRN_INSTRCT_CRS is a view of which instructors are qualified to teach a particular training course. This functionality is part of the Training Administration application. TRN_INSTRCT_CRS is used as the F4 edit/prompt table for CRSE_SESS_INSTR.INSTRUCTOR_ID to insure that only qualified instructors can be entered for a course session. |
| SELECT A.COURSE ,A.INSTRUCTOR_ID ,C.NAME ,B.INTERNAL_EXTERNAL ,B.VENDOR FROM PS_TRN_INSTRCT_CRS A ,PS_TRN_INSTRCT_TBL B ,PS_PERSON_NAME C WHERE B.INSTRUCTOR_ID = A.INSTRUCTOR_ID AND C.EMPLID = A.INSTRUCTOR_ID AND %EffdtCheck(TRN_INSTRCT_TBL, B, %currentdatein) AND B.EFF_STATUS = 'A' |
| # | 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 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 4 | INTERNAL_EXTERNAL | Character(1) | VARCHAR2(1) NOT NULL |
Internal/External
E=External I=Internal |
| 5 | VENDOR | Character(6) | VARCHAR2(6) NOT NULL | Vendor ID |