INSTR_ABS_VWLNG

(SQL View)
 Index Back

Instructor Absence Schedule

This view lists the dates and time when training instructors are not available for training due to holiday, sickness, conference, etc. This information is obtained by looking at the ABSENCE_HIST record.

SELECT A.INSTRUCTOR_ID ,C.LANGUAGE_CD ,E.NAME ,C.DESCR FROM PS_TRN_INSTRCT_TBL A , PS_ABSENCE_HIST B , PS_ABS_TY_TBL_LANG C , PS_JOB D , PS_PERSON_NAME E WHERE A.INSTRUCTOR_ID = B.EMPLID AND A.INSTRUCTOR_ID = E.EMPLID AND B.ABSENCE_TYPE = C.ABSENCE_TYPE AND B.EMPLID = D.EMPLID AND B.EMPL_RCD = D.EMPL_RCD AND D.EFFDT = ( SELECT MAX(E.EFFDT) FROM PS_JOB E WHERE E.EMPLID = B.EMPLID AND E.EMPL_RCD = B.EMPL_RCD AND E.EFFDT <= B.BEGIN_DT) AND C.SETID = ( SELECT F.SETID FROM PS_SET_CNTRL_REC F WHERE F.SETCNTRLVALUE = D.REG_REGION AND F.RECNAME = 'ABS_TYPE_TBL') AND %EffdtCheck(TRN_INSTRCT_TBL, A, B.BEGIN_DT) AND A.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTRUCTOR_ID Character(11) VARCHAR2(11) NOT NULL Instructor ID
2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
3 NAME Character(50) VARCHAR2(50) NOT NULL Name
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description