SFA_RTIV_HLDT_I(SQL View) |
Index Back |
|---|---|
CS Interface VW - HOLIDAY_DATECampus Solutions Interface View of Payroll record (HOLIDAY_DATE) - Holiday dates and descriptions for a holiday schedule. |
| SELECT HOLIDAY_SCHEDULE ,HOLIDAY ,DESCR ,HOLIDAY_HRS ,HOLIDAY_TYPE ,HOL_TIME_START ,HOL_TIME_END FROM PS_HOLIDAY_DATE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  HOLIDAY_SCHEDULE |
Character(6) | VARCHAR2(6) NOT NULL |
Holiday Schedule
Prompt Table: HOLIDAY_TBL |
| 2 | HOLIDAY |
Date(10) | DATE NOT NULL | Holiday |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | HOLIDAY_HRS | Number(5,2) | DECIMAL(4,2) NOT NULL | Holiday Hours |
| 5 | HOLIDAY_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Holiday Type
BRG=Bridge Day CAN=Canadian Statutory Holiday HALF=1/2 Day Holiday HIGH=High Holiday HKGS=Hong Kong Statutory Holiday LOW=Low Holiday STD=Standard USA=U.S. Statutory Holiday VERY=Very High Default Value: STD |
| 6 | HOL_TIME_START | Time(15) | TIMESTAMP | Start Time |
| 7 | HOL_TIME_END | Time(15) | TIMESTAMP | Time End |