!!!Alias: DWRD Unique Keys: ___\\ Child Table: ___\\ Parent Table: ___\\ \\ Hours per specific day of a period !!Table Columns \\ ||Column name||Data Type / Size||Domain||Mand.||Notes |[ID]|Number(10)|[ID]|Y| |[DWR_ID]|Number(10)|[ID]|Y|link to [P2K_CM_WORK_RULES] |[DHC_ID]|Number(10)|[ID]| |link to [P2K_CM_HOLIDAY_CALENDARS] |[DCR_ID]|Number(10)|[ID]| |link to [P2K_CM_CHANGE_REASONS] |[DWC_ID]|Number(10)|[ID]| |link to [P2K_CM_WORK_CALENDARS] |[EFFECTIVE]|Date()|[EFFECTIVE]|Y| |[EXPIRY]|Date()|[EXPIRY]|Y| |[DESCRIPTION]|Varchar2(50)|[DESCRIPTION]| | |[FIRST_DAY_OF_WEEK]|Varchar2(3)|[X_DAY_OF_WEEK]| | |[PIECES_PER_DAY]|Number(9)|[AMT5V4|AMTnn]| | |[STD_HOURS_PER_DAY]|Number(9)|[AMT5V4|AMTnn]| | |[STD_HOURS_PER_WEEK]|Number(9)|[AMT5V4|AMTnn]| | |[STD_HOURS_PER_PAY]|Number(9)|[AMT5V4|AMTnn]| | |[WEEKS_PER_YEAR]|Number(9)|[AMT5V4|AMTnn]| | |[MONTHS_PER_YEAR]|Number(9)|[AMT5V4|AMTnn]| | |[PAYS_PER_CONTRACT]|Number(5)|[NUMBER5|NUMBERn]| | |[FLSA_METHOD]|Varchar2(2)|[X_FLSA_CALC_METHOD]| | |[FLOAT_DAYS_ALLOWED]|Number(5)|[NUMBER5|NUMBERn]| | |[WORK_IS_SCHEDULED]|Varchar2(1)|[TOGGLE]| | |[MUST_BE_ACKNOWLEDGED]|Varchar2(1)|[TOGGLE]| | |[TIME_ROUNDING_RULE]|Varchar2(2)|[X_TIME_ROUNDING_RULE]| | |[TIME_ROUNDING_FACTOR]|Number(9)|[AMT5V4|AMTnn]| | |[PAY_STARTING_DATE]|Date()|[DATE]| | |[CREATE_DATE]|Date()|[DATE]|Y| |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[CHANGE_DATE]|Date()|[DATE]|Y| |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[GROUP_SOURCE]|Varchar2(2)|[X_GROUP_SOURCE]| | |[WORK_IN_RESTRICTION_RULE]|Varchar2(2)|[X_WORK_IN_RESTRICTION_RULE]| | |[TRACK_WORK_PUNCHES]|Varchar2(1)|[TOGGLE]| | |[TRACK_MEAL_PUNCHES]|Varchar2(1)|[TOGGLE]| | User Fields: Allowed\\ Audit Logging: Allowed\\ [{If var='loginstatus' contains 'authenticated' ---- ![Discussion|Edit:Internal.P2K_CM_WORK_RULE_DETAILS] [{InsertPage page='Internal.P2K_CM_WORK_RULE_DETAILS' default='Click to create a new discussion page'}] }]