HOLIDAY_SCHEDULEHOLIDAYBRG=Bridge
CAN=Canadian
HALF=1/2 Day
HIGH=High
LOW=Low
STD=Standard
USA=U.S. Public
VERY=Very High
Default Value: STD
HOLIDAY_DATE(SQL Table) |
Index Back |
|---|---|
Holiday DatesHoliday dates and descriptions for a holiday schedule. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HOLIDAY_SCHEDULE |
Character(6) | VARCHAR2(6) NOT NULL | Holiday Schedule |
| 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 CAN=Canadian HALF=1/2 Day HIGH=High LOW=Low STD=Standard USA=U.S. Public VERY=Very High Default Value: STD |
| 6 | HOL_TIME_START | Time(15) | TIMESTAMP | Start Time |
| 7 | HOL_TIME_END | Time(15) | TIMESTAMP | Time End |
| 8 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 9 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |