!!!Alias: DWRC
Unique Keys: ___\\
Child Table: ___\\
Parent Table: ___\\
\\
Work Rule Time Codes

!!Table Columns
\\
||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)|[ID]|Y|
|[DWRD_ID]|Number(10)|[ID]|Y|link to [P2K_CM_WORK_RULE_DETAILS]
|[DTC_ID]|Number(10)|[ID]|Y|link to [P2K_CM_TIME_CODES]
|[TIME_CODE_SEQUENCE]|Number(5)|[NUMBER5|NUMBERn]| |
|[LUNCH_ELIGIBLE]|Varchar2(1)|[TOGGLE]| |
|[DAILY_OT_ELIGIBLE]|Varchar2(1)|[TOGGLE]| |
|[WEEKLY_OT_ELIGIBLE]|Varchar2(1)|[TOGGLE]| |
|[EXTENDED_OT_ELIGIBLE]|Varchar2(1)|[TOGGLE]| |
|[CONSECUTIVE_OT_ELIGIBLE]|Varchar2(1)|[TOGGLE]| |
|[MEAL_ALLOWANCE_ELIGIBLE]|Varchar2(1)|[TOGGLE]| |
|[CALL_IN_ELIGIBLE]|Varchar2(1)|[TOGGLE]| |
|[GUARANTEED_TIME_ELIGIBLE]|Varchar2(1)|[TOGGLE]| |
|[REASON_FOR_TIME]|Varchar2(2)|[X_REASON_FOR_TIME]| |
|[HOLIDAY_OT_ELIGIBLE]|Varchar2(1)|[TOGGLE]| |
|[CREATE_DATE]|Date()|[DATE]|Y|
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[CHANGE_DATE]|Date()|[DATE]|Y|
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[ACTUAL_TIME_REQUIRED]|Varchar2(1)|[TOGGLE]| |
|[REQUIRES_AUTHORIZATION]|Varchar2(1)|[TOGGLE]| |

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