!!!Alias: DHD
Unique Keys: ___\\
Child Table: ___\\
Parent Table: ___\\
\\
Holidays Information

!!Table Columns
\\
||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)|[ID]|Y|
|[DHC_ID]|Number(10)|[ID]|Y|link to [P2K_CM_HOLIDAY_CALENDARS]
|[HOLIDAY_DATE]|Date()|[DATE]|Y|
|[DTC_ID_WORK]|Number(10)|[ID]| |link to [P2K_CM_TIME_CODES]
|[DTC_ID_LEAVE]|Number(10)|[ID]| |link to [P2K_CM_TIME_CODES]
|[HOLIDAY_IDENTITY]|Varchar2(10)|[X_HOLIDAY_IDENTITY]|Y|
|[CREATE_DATE]|Date()|[DATE]|Y|
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[CHANGE_DATE]|Date()|[DATE]|Y|
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[HOLIDAY_TYPE]|Varchar2(4)|[X_HOLIDAY_TYPE]| |
|[HOLIDAY_RULE]|Varchar2(2)|[X_HOLIDAY_RULE]| |
|[HOLIDAY_START_TIME]|Number(5)|[MINUTES]| |
|[HOURS_PER_DAY]|Number(9)|[AMT5V4]| |
|[OVERTIME_FACTOR]|Number(9)|[AMT5V4]| |
|[GENERATE_TIME]|Varchar2(1)|[TOGGLE]| |
|[SCHEDULING_OVERRIDE]|Varchar2(1)|[TOGGLE]| |
|[OBSERVED_ON]|Varchar2(2)|[X_OBSERVED_ON]| |
|[DTC_ID_OFF]|Number(10)|[ID]| |link to [P2K_CM_TIME_CODES]

User Fields: Allowed\\
Audit Logging: Allowed\\