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_TBL(SQL Table) |
Index Back |
|---|---|
Holidays of a country |
| # | 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | FROM_DATE | Date(10) | DATE | From Date |
| 5 | THRU_DATE | Date(10) | DATE | Through Date |