INF_CV_USPAYRULES
Back to current versionRestore this version

Alias: IVPPRU#

(INF_CV_USPAYRULES)
US Pay Rules

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