INSTRUCTOR_IDINSTR_ABS_VW(SQL View) |
Index Back |
|---|---|
Instructor Absence ScheduleThis 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 ,E.NAME ,B.BEGIN_DT ,B.RETURN_DT ,B.ABS_BEGIN_TM ,B.ABS_RETURN_TM ,C.DESCR FROM PS_TRN_INSTRCT_TBL A , PS_ABSENCE_HIST B , PS_ABS_TYPE_TBL 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 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 3 | START_DT | Date(10) | DATE | Start Date |
| 4 | END_DT | Date(10) | DATE | end date |
| 5 | STRT_TM | Time(15) | TIMESTAMP | Start Time |
| 6 | STOP_TM | Time(15) | TIMESTAMP | Period End Time |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |