TRN_CRS_INST_VW

(SQL View)
 Index Back

Qualified Instructors - Course

TRN_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 ,B.VENDOR ,A.INSTRUCTOR_ID ,C.NAME ,B.INTERNAL_EXTERNAL 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'

  • Related Language Record: TRN_CRS_INSTVWL

    • # 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 NAME Character(50) VARCHAR2(50) NOT NULL Name
    5 INTERNAL_EXTERNAL Character(1) VARCHAR2(1) NOT NULL Internal/External
    E=External
    I=Internal