!!!Alias: IVPPRC
(Canada only) The INF_CV_CDNPAYRULES table is used to import taxation rules for employees into the software data structures.   This table defines the employee’s rules for taxation, including claim codes, filing status and exemption information.
!!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]| |
|[EFFECTIVE]|Date()|[EFFECTIVE]|Y|
|[EXPIRY]|Date()|[EXPIRY]|Y|
|[CHANGE_CODE]|Varchar2(16)|[CODE]| |
|[TAX_CLAIM_CODE_FED]|Varchar2(16)|[CODE]|Y|
|[CFED_TD1_AMOUNT]|Number(18)|[AMT12V6|AMTnn]| |
|[CFED_ANN_TAX_CREDIT]|Number(18)|[AMT12V6|AMTnn]| |
|[CFED_ANN_TAX_DEDUCTION]|Number(18)|[AMT12V6|AMTnn]| |
|[CFED_ANN_AREA_DEDUCTION]|Number(18)|[AMT12V6|AMTnn]| |
|[CFED_TAX_AMOUNT]|Number(18)|[AMT12V6|AMTnn]| |
|[CFED_TAX_PERCENT]|Number(5)|[PERCENT]| |
|[CFED_ADD_TAX_PER_PERIOD]|Number(18)|[AMT12V6|AMTnn]| |
|[CFED_FILING_STATUS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[CFED_TAX_METHOD]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[CFED_CPP_METHOD]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[CFED_EI_METHOD]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[CFED_LABOUR_FUND]|Number(18)|[AMT12V6|AMTnn]| |
|[TAX_CLAIM_TYPE_PRV]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[TAX_CLAIM_CODE_PRV]|Varchar2(16)|[CODE]| |
|[CPRV_CLAIM_AMOUNT]|Number(18)|[AMT12V6|AMTnn]| |
|[CPRV_NUM_DEPENDENTS]|Number(5)|[NUMBER5|NUMBERn]| |
|[CPRV_ANN_TAX_DEDUCTION]|Number(18)|[AMT12V6|AMTnn]| |
|[CPRV_TAX_AMOUNT]|Number(18)|[AMT12V6|AMTnn]| |
|[CPRV_TAX_PERCENT]|Number(5)|[PERCENT]| |
|[CPRV_ADD_TAX_PER_PERIOD]|Number(18)|[AMT12V6|AMTnn]| |
|[CPRV_FILING_STATUS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[CPRV_TAX_METHOD]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[CPRV_QPP_METHOD]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[CPRV_HEALTH_TAX_METHOD]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[CPRV_WCB_METHOD]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[CPRV_ANN_TAX_CREDIT]|Number(18)|[AMT12V6|AMTnn]| |
|[CPRV_ANN_AREA_DEDUCTION]|Number(18)|[AMT12V6|AMTnn]| |
|[CPRV_PPIP_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]| |