Alias: IVDGR#

The INF_CV_GROUPS table is used to import group codes and their attendant data into the software data structures. A group divides a unit into subsections which have a common set of processing policies.

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
ENTITY_CODEVarchar2(16)CODEY
UNIT_CODEVarchar2(16)CODEY
GROUP_CODEVarchar2(16)CODEY
STANDINGVarchar2(30)VARCHAR30
EFFECTIVEDate()EFFECTIVE
EXPIRYDate()EXPIRY
CHANGE_CODEVarchar2(16)CODE
DESCRIPTIONVarchar2(50)DESCRIPTION
STATUS_CODE_STARTEDVarchar2(16)CODE
STATUS_CODE_ENDEDVarchar2(16)CODE
WORK_RULE_CODEVarchar2(16)CODE
PAYROLL_CODEVarchar2(16)CODE
WAGE_STEP_RULE_CODEVarchar2(16)CODE
GROUP_TYPEVarchar2(30)VARCHAR30
PAY_TYPEVarchar2(30)VARCHAR30
STD_HOURS_PER_DAYNumber(9)AMT5V4
STD_HOURS_PER_PAYNumber(9)AMT5V4
STD_HOURS_PER_WEEKNumber(9)AMT5V4
USE_FTE_WAGESVarchar2(4)VARCHAR4
HOURLY_ROUNDINGNumber(18)AMT12V6
DAILY_ROUNDINGNumber(18)AMT12V6
WEEKS_PER_YEARNumber(9)AMT5V4
MONTHS_PER_YEARNumber(9)AMT5V4
ACCRUAL_METHODVarchar2(30)VARCHAR30
GOVT_REGIST_NUMBERVarchar2(30)VARCHAR30
CDN_EI_REDUCED_RATENumber(18)AMT12V6
PAY_BY_CHECKVarchar2(4)VARCHAR4
CONTRACT_TYPEVarchar2(30)VARCHAR30
EMPLOYMENT_TYPEVarchar2(30)VARCHAR30
FLSA_FACTORNumber(9)AMT5V4
FLSA_HOURSNumber(9)AMT5V4
FLSA_CALENDARVarchar2(16)CODE
FLSA_USER_CALCVarchar2(16)CODE
W2_EMPLOYMENT_TYPEVarchar2(30)VARCHAR30
FED_REGIST_TYPEVarchar2(30)VARCHAR30
STATE_REGIST_TYPEVarchar2(30)VARCHAR30
LOCAL_REGIST_TYPEVarchar2(30)VARCHAR30
GOVT_REGIST_SET_FEDVarchar2(16)CODE
GOVT_REGIST_SET_STATEVarchar2(16)CODE
GOVT_REGIST_SET_LOCALVarchar2(16)CODE
FUND_USER_CALCVarchar2(16)CODE
WC_REGIST_TYPEVarchar2(30)VARCHAR30
ALLOCATION_TYPEVarchar2(30)VARCHAR30
BURDEN_PERCENTNumber(5)PERCENT
DISTRIBUTION_DR_MASKVarchar2(50)DISTRIBUTION
DISTRIBUTION_CR_MASKVarchar2(50)DISTRIBUTION
ELEMENT_CODE_PRORATED_BYVarchar2(16)CODE
ELEMENT_CODE_BASE_OFVarchar2(16)CODE
DISTR_MASK_RULEVarchar2(30)VARCHAR30
BURDEN_METHODVarchar2(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