!!!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 name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)|[ID]| |
|[ENTITY_CODE]|Varchar2(16)|[CODE]|Y|
|[PERSON_CODE]|Varchar2(16)|[CODE]|Y|
|[EMPLOYMENT_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[HIRE_DATE]|Date()|[DATE]| |
|[COUNTRY_CODE]|Varchar2(16)|[CODE]| |
|[STATE_PROVINCE_CODE]|Varchar2(16)|[CODE]| |
|[GEO_CODE]|Varchar2(16)|[CODE]| |
|[DESCRIPTION]|Varchar2(50)|[DESCRIPTION]| |
|[EFFECTIVE]|Date()|[EFFECTIVE]|Y|
|[EXPIRY]|Date()|[EXPIRY]|Y|
|[CHANGE_CODE]|Varchar2(16)|[CODE]| |
|[UFED_FILING_STATUS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[UFED_NUM_EXEMPTIONS]|Number(5)|[NUMBER5|NUMBERn]| |
|[UFED_ANN_EXEMPTION]|Number(18)|[AMT12V6|AMTnn]| |
|[UFED_ADD_EXEMPTION]|Number(18)|[AMT12V6|AMTnn]| |
|[UFED_ADD_TAX_PER_PERIOD]|Number(18)|[AMT12V6|AMTnn]| |
|[UFED_TAX_AMOUNT]|Number(18)|[AMT12V6|AMTnn]| |
|[UFED_TAX_PERCENT]|Number(5)|[PERCENT]| |
|[UFED_TAX_METHOD]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[UFED_SUPPL_TAX_METHOD]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[UFED_FICA_METHOD]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[UFED_MEDICARE_METHOD]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[UFED_FUTA_METHOD]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[UFED_EIC_METHOD]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[UST_RECIPROCATION]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[UST_FILING_STATUS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[UST_NUM_EXEMPTION_1]|Number(5)|[NUMBER5|NUMBERn]| |
|[UST_NUM_EXEMPTION_2]|Number(5)|[NUMBER5|NUMBERn]| |
|[UST_ANN_EXEMPTION]|Number(18)|[AMT12V6|AMTnn]| |
|[UST_ADD_EXEMPTION]|Number(18)|[AMT12V6|AMTnn]| |
|[UST_ADD_TAX_PER_PERIOD]|Number(18)|[AMT12V6|AMTnn]| |
|[UST_ADD_TAX_RES]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[UST_ADD_TAX_WORK]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[UST_TAX_AMOUNT]|Number(18)|[AMT12V6|AMTnn]| |
|[UST_TAX_PERCENT]|Number(5)|[PERCENT]| |
|[UST_TAX_METHOD]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[UST_SUPPL_TAX_METHOD]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[UST_ALT_TAX_METHOD]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[UST_SUI_EE_METHOD]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[UST_SUI_ER_METHOD]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[UST_SDI_EE_METHOD]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[UST_SDI_ER_METHOD]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[UST_WCB_METHOD]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[ULOC_RECIPROCATION]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[ULOC_FILING_STATUS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[ULOC_NUM_EXEMPTIONS]|Number(5)|[NUMBER5|NUMBERn]| |
|[ULOC_ANN_EXEMPTION]|Number(18)|[AMT12V6|AMTnn]| |
|[ULOC_EXEMPTION_PERCENT]|Number(5)|[PERCENT]| |
|[ULOC_ADD_TAX_PER_PERIOD]|Number(18)|[AMT12V6|AMTnn]| |
|[ULOC_ADD_TAX_WORK]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[ULOC_ADD_TAX_RES]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[ULOC_TAX_AMOUNT]|Number(18)|[AMT12V6|AMTnn]| |
|[ULOC_TAX_PERCENT_1]|Number(5)|[PERCENT]| |
|[ULOC_TAX_PERCENT_2]|Number(5)|[PERCENT]| |
|[ULOC_COUNTY_TAX_METHOD]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[ULOC_CITY_TAX_METHOD]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[ULOC_SCHOOL_TAX_METHOD]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[ULOC_SCHOOL_TAX_AMOUNT]|Number(18)|[AMT12V6|AMTnn]| |
|[ULOC_SCHOOL_TAX_PERCENT]|Number(5)|[PERCENT]| |
|[ULOC_HEAD_TAX_METHOD]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[ULOC_HEAD_TAX_AMOUNT]|Number(18)|[AMT12V6|AMTnn]| |
|[UST_EIC_METHOD]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[CREATE_DATE]|Date()|[DATE]| |
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[CHANGE_DATE]|Date()|[DATE]| |
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |