INF_CV_GROUPS
Back to current versionRestore this version

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

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