Alias: IVDWR#

The INF_CV_WORKRULES table is used to import work rule codes and their attendant data into the software data structures.

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
This particular version was published on 26-Nov-2021 10:22 by JEscott.Top