HOLIDAY_SCHEDULEPrompt Table: HOLIDAY_TBL
HOLIDAYBRG=Bridge Day
CAN=Canadian Statutory Holiday
HALF=1/2 Day Holiday
HIGH=High Holiday
LOW=Low Holiday
STD=Standard
USA=U.S. Statutory Holiday
VERY=Very High
Default Value: STD
HOLIDAY_DATE_VW(SQL View) |
Index Back |
|---|---|
Holiday DatesHoliday dates and descriptions for a holiday schedule. |
| SELECT Holiday_SCHEDULE , HOLIDAY , 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 |
This is the holiday schedule field.
Prompt Table: HOLIDAY_TBL |
| 2 | HOLIDAY |
Date(10) | DATE NOT NULL | Holiday |
| 3 | HOLIDAY_HRS | Number(5,2) | DECIMAL(4,2) NOT NULL | Holiday Hours |
| 4 | 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 LOW=Low Holiday STD=Standard USA=U.S. Statutory Holiday VERY=Very High Default Value: STD |
| 5 | HOL_TIME_START | Time(15) | TIMESTAMP | Start Time |
| 6 | HOL_TIME_END | Time(15) | TIMESTAMP | Time End |