INF_CV_WORKRULES
Back to current versionRestore this version

Alias: IVDWR#

(INF_CV_WORKRULES)
Hours per specific day of a period

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
ENTITY_CODEVarchar2(16)CODEY
WORK_RULE_CODEVarchar2(16)CODEY
STANDINGVarchar2(30)VARCHAR30
EFFECTIVEDate()EFFECTIVEY
EXPIRYDate()EXPIRYY
CHANGE_CODEVarchar2(16)CODE
WORK_CALENDAR_CODEVarchar2(16)CODE
HOLIDAY_CALENDAR_CODEVarchar2(16)CODE
DESCRIPTIONVarchar2(50)VARCHAR50
FIRST_DAY_OF_WEEKVarchar2(30)VARCHAR30
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(30)VARCHAR30
FLOAT_DAYS_ALLOWEDNumber(5)NUMBER5
WORK_IS_SCHEDULEDVarchar2(4)VARCHAR4
MUST_BE_ACKNOWLEDGEDVarchar2(4)VARCHAR4
TIME_ROUNDING_RULEVarchar2(30)VARCHAR30
TIME_ROUNDING_FACTORNumber(9)AMT5V4
PAY_STARTING_DATEDate()DATE
GROUP_SOURCEVarchar2(30)VARCHAR30
WORK_IN_RESTRICTION_RULEVarchar2(30)VARCHAR30
STATUS_CODEVarchar2(16)CODE
TIME_CODE_REGULARVarchar2(16)CODE
TIME_CODE_SALARYVarchar2(16)CODE
TIME_CODE_OVERTIMEVarchar2(16)CODE
TIMESHEET_REQUIREDVarchar2(30)VARCHAR30
TIME_GENERATION_RULEVarchar2(30)VARCHAR30
GENERATE_HEADERSVarchar2(30)VARCHAR30
GENERATE_DETAILSVarchar2(30)VARCHAR30
GENERATE_HOLIDAYSVarchar2(30)VARCHAR30
ACCUMULATE_EXPERIENCEVarchar2(30)VARCHAR30
SIGN_OFF_TYPEVarchar2(30)VARCHAR30
TIME_GENERATION_DESTINATIONVarchar2(30)VARCHAR30
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30

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