TRN_CRS_INS_LNG

(SQL View)
 Index Back

Qualified Instr Course/Lang

TRN_CRS_INS_LNG 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 ,C.ACCOMPLISHMENT ,A.INSTRUCTOR_ID ,E.NAME ,B.INTERNAL_EXTERNAL ,B.VENDOR 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 %EffdtCheck(TRN_INSTRCT_TBL, B, %currentdatein) AND B.EFF_STATUS = 'A' AND A.COURSE = D.COURSE AND D.CRSE_MULTILNG_SW='Y'

# 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 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Teaching Language

Prompt Table: LANGUAGE_VW

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 VENDOR Character(6) VARCHAR2(6) NOT NULL Vendor ID