P 2 K_CM_WORK_RULE_DETAILS

Alias: DWRD#

Unique Keys: _
Child Table: _
Parent Table: _

Hours per specific day of a period

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
DWR_IDNumber(10)IDYlink to P2K_CM_WORK_RULES
DHC_IDNumber(10)ID link to P2K_CM_HOLIDAY_CALENDARS
DCR_IDNumber(10)ID link to P2K_CM_CHANGE_REASONS
DWC_IDNumber(10)ID link to P2K_CM_WORK_CALENDARS
EFFECTIVEDate()EFFECTIVEY
EXPIRYDate()EXPIRYY
DESCRIPTIONVarchar2(50)DESCRIPTION
FIRST_DAY_OF_WEEKVarchar2(3)X_DAY_OF_WEEK
PIECES_PER_DAYNumber(9)AMT5V4
STD_HOURS_PER_DAYNumber(9)AMT5V4
STD_HOURS_PER_WEEKNumber(9)AMT5V4
STD_HOURS_PER_PAYNumber(9)AMT5V4
WEEKS_PER_YEARNumber(9)AMT5V4
MONTHS_PER_YEARNumber(9)AMT5V4
PAYS_PER_CONTRACTNumber(5)NUMBER5
FLSA_METHODVarchar2(2)X_FLSA_CALC_METHOD
FLOAT_DAYS_ALLOWEDNumber(5)NUMBER5
WORK_IS_SCHEDULEDVarchar2(1)TOGGLE
MUST_BE_ACKNOWLEDGEDVarchar2(1)TOGGLE
TIME_ROUNDING_RULEVarchar2(2)X_TIME_ROUNDING_RULE
TIME_ROUNDING_FACTORNumber(9)AMT5V4
PAY_STARTING_DATEDate()DATE
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
GROUP_SOURCEVarchar2(2)X_GROUP_SOURCE
WORK_IN_RESTRICTION_RULEVarchar2(2)X_WORK_IN_RESTRICTION_RULE
TRACK_WORK_PUNCHESVarchar2(1)TOGGLE
TRACK_MEAL_PUNCHESVarchar2(1)TOGGLE
FLSA_HOURSNumber(9)AMT5V4
DCL_ID_FLSANumber(10)ID link to P2K_CM_CALENDARS

User Fields: Allowed
Audit Logging: Allowed

Notes #

Click to create a new notes page

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation