Alias: IVPPRU#

(US Only) The INF_CV_USPAYRULES table is used to import the rules for employee taxation into the software data structures. The U.S. Pay Rules contain the individual pay factors and rules that are required to calculate all legislated deductions and contributions required for each Employee, by effective date. Completed according to the W-4 form submitted by employees. Employees may have different rule sets by state, if desired.

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
ENTITY_CODEVarchar2(16)CODEY
PERSON_CODEVarchar2(16)CODEY
EMPLOYMENT_TYPEVarchar2(30)VARCHAR30
HIRE_DATEDate()DATE
COUNTRY_CODEVarchar2(16)CODE
STATE_PROVINCE_CODEVarchar2(16)CODE
GEO_CODEVarchar2(16)CODE
DESCRIPTIONVarchar2(50)DESCRIPTION
EFFECTIVEDate()EFFECTIVEY
EXPIRYDate()EXPIRYY
CHANGE_CODEVarchar2(16)CODE
UFED_FILING_STATUSVarchar2(30)VARCHAR30
UFED_NUM_EXEMPTIONSNumber(5)NUMBER5
UFED_ANN_EXEMPTIONNumber(18)AMT12V6
UFED_ADD_EXEMPTIONNumber(18)AMT12V6
UFED_ADD_TAX_PER_PERIODNumber(18)AMT12V6
UFED_TAX_AMOUNTNumber(18)AMT12V6
UFED_TAX_PERCENTNumber(5)PERCENT
UFED_TAX_METHODVarchar2(30)VARCHAR30
UFED_SUPPL_TAX_METHODVarchar2(30)VARCHAR30
UFED_FICA_METHODVarchar2(30)VARCHAR30
UFED_MEDICARE_METHODVarchar2(30)VARCHAR30
UFED_FUTA_METHODVarchar2(30)VARCHAR30
UFED_EIC_METHODVarchar2(30)VARCHAR30
UST_RECIPROCATIONVarchar2(30)VARCHAR30
UST_FILING_STATUSVarchar2(30)VARCHAR30
UST_NUM_EXEMPTION_1Number(5)NUMBER5
UST_NUM_EXEMPTION_2Number(5)NUMBER5
UST_ANN_EXEMPTIONNumber(18)AMT12V6
UST_ADD_EXEMPTIONNumber(18)AMT12V6
UST_ADD_TAX_PER_PERIODNumber(18)AMT12V6
UST_ADD_TAX_RESVarchar2(30)VARCHAR30
UST_ADD_TAX_WORKVarchar2(30)VARCHAR30
UST_TAX_AMOUNTNumber(18)AMT12V6
UST_TAX_PERCENTNumber(5)PERCENT
UST_TAX_METHODVarchar2(30)VARCHAR30
UST_SUPPL_TAX_METHODVarchar2(30)VARCHAR30
UST_ALT_TAX_METHODVarchar2(30)VARCHAR30
UST_SUI_EE_METHODVarchar2(30)VARCHAR30
UST_SUI_ER_METHODVarchar2(30)VARCHAR30
UST_SDI_EE_METHODVarchar2(30)VARCHAR30
UST_SDI_ER_METHODVarchar2(30)VARCHAR30
UST_WCB_METHODVarchar2(30)VARCHAR30
ULOC_RECIPROCATIONVarchar2(30)VARCHAR30
ULOC_FILING_STATUSVarchar2(30)VARCHAR30
ULOC_NUM_EXEMPTIONSNumber(5)NUMBER5
ULOC_ANN_EXEMPTIONNumber(18)AMT12V6
ULOC_EXEMPTION_PERCENTNumber(5)PERCENT
ULOC_ADD_TAX_PER_PERIODNumber(18)AMT12V6
ULOC_ADD_TAX_WORKVarchar2(30)VARCHAR30
ULOC_ADD_TAX_RESVarchar2(30)VARCHAR30
ULOC_TAX_AMOUNTNumber(18)AMT12V6
ULOC_TAX_PERCENT_1Number(5)PERCENT
ULOC_TAX_PERCENT_2Number(5)PERCENT
ULOC_COUNTY_TAX_METHODVarchar2(30)VARCHAR30
ULOC_CITY_TAX_METHODVarchar2(30)VARCHAR30
ULOC_SCHOOL_TAX_METHODVarchar2(30)VARCHAR30
ULOC_SCHOOL_TAX_AMOUNTNumber(18)AMT12V6
ULOC_SCHOOL_TAX_PERCENTNumber(5)PERCENT
ULOC_HEAD_TAX_METHODVarchar2(30)VARCHAR30
ULOC_HEAD_TAX_AMOUNTNumber(18)AMT12V6
UST_EIC_METHODVarchar2(30)VARCHAR30
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30