INF_CV_WORKRULES
Back to current versionRestore this version

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)

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