EMPLIDEMPL_RCDBEGIN_DTABSW_HOL_VW(SQL View) |
Index Back |
|---|---|
EE Holiday Schedule ViewEE Holiday Schedule View |
| select A.EMPLID , A.EMPL_RCD , A.BEGIN_DT , B.HOLIDAY from PS_ABSW_SCHEDULE A , PS_HOLIDAY_DATE B where A.HOLIDAY_SCHEDULE = B.HOLIDAY_SCHEDULE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | BEGIN_DT |
Date(10) | DATE | Begin Date |
| 4 | HOLIDAY | Date(10) | DATE | Holiday |