TRN_INS_LNG_VW

(SQL View)
 Index Back

Qualified Instr Crse/Lang

TRN_INS_LNG_VW is a view of which instructors are qualified to teach a particular training course according to the session language. This functionality is part of the Training Administration application.

SELECT A.COURSE ,B.VENDOR ,A.INSTRUCTOR_ID ,E.NAME ,B.INTERNAL_EXTERNAL ,C.ACCOMPLISHMENT FROM PS_TRN_INSTRCT_CRS A ,PS_TRN_INSTRCT_TBL B ,PS_TRN_INS_TLNG_VW C ,PS_COURSE_TBL D ,PS_PERSON_NAME E WHERE B.INSTRUCTOR_ID = A.INSTRUCTOR_ID AND C.INSTRUCTOR_ID = A.INSTRUCTOR_ID AND E.EMPLID = A.INSTRUCTOR_ID AND A.COURSE = D.COURSE AND D.CRSE_MULTILNG_SW='Y' 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
    6 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Teaching Language

    Prompt Table: LANGUAGE_VW