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 / SizeMand.Notes
IDNumber(10)
ENTITY_CODEVarchar2(16)Y
WORK_RULE_CODEVarchar2(16)Y
STANDINGVarchar2(30)
EFFECTIVEDate()Y
EXPIRYDate()Y
CHANGE_CODEVarchar2(16)
WORK_CALENDAR_CODEVarchar2(16)
HOLIDAY_CALENDAR_CODEVarchar2(16)
DESCRIPTIONVarchar2(50)
FIRST_DAY_OF_WEEKVarchar2(30)
PIECES_PER_DAYNumber(9)
STD_HOURS_PER_DAYNumber(9)
STD_HOURS_PER_WEEKNumber(9)
STD_HOURS_PER_PAYNumber(9)
WEEKS_PER_YEARNumber(9)
MONTHS_PER_YEARNumber(9)
PAYS_PER_CONTRACTNumber(5)
FLSA_METHODVarchar2(30)
FLOAT_DAYS_ALLOWEDNumber(5)
WORK_IS_SCHEDULEDVarchar2(4)
MUST_BE_ACKNOWLEDGEDVarchar2(4)
TIME_ROUNDING_RULEVarchar2(30)
TIME_ROUNDING_FACTORNumber(9)
PAY_STARTING_DATEDate()
GROUP_SOURCEVarchar2(30)
WORK_IN_RESTRICTION_RULEVarchar2(30)
STATUS_CODEVarchar2(16)
TIME_CODE_REGULARVarchar2(16)
TIME_CODE_SALARYVarchar2(16)
TIME_CODE_OVERTIMEVarchar2(16)
TIMESHEET_REQUIREDVarchar2(30)
TIME_GENERATION_RULEVarchar2(30)
GENERATE_HEADERSVarchar2(30)
GENERATE_DETAILSVarchar2(30)
GENERATE_HOLIDAYSVarchar2(30)
ACCUMULATE_EXPERIENCEVarchar2(30)
SIGN_OFF_TYPEVarchar2(30)
TIME_GENERATION_DESTINATIONVarchar2(30)
CREATE_DATEDate()
CREATE_USERVarchar2(30)
CHANGE_DATEDate()
CHANGE_USERVarchar2(30)