COUNTRYPrompt Table: COUNTRY_TBL
HOLIDAY_TYPEBRG=Bridge
CAN=Canadian
HALF=1/2 Day
HIGH=High
LOW=Low
STD=Standard
USA=U.S. Public
VERY=Very High
Prompt Table: HOLIDAY_TBL
HOLIDAY_VW(SQL View) |
Index Back |
|---|---|
View For Holiday Scrollselect |
| select country, holiday_type, from_date, thru_date from PS_HOLIDAY_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 2 | 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 Prompt Table: HOLIDAY_TBL |
| 3 | FROM_DATE | Date(10) | DATE | From Date |
| 4 | THRU_DATE | Date(10) | DATE | Through Date |