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 nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
ENTITY_CODEVarchar2(16)CODEY
PERSON_CODEVarchar2(16)CODEY
EMPLOYMENT_TYPEVarchar2(30)VARCHAR30
HIRE_DATEDate()DATE
EFFECTIVEDate()EFFECTIVEY
EXPIRYDate()EXPIRYY
CHANGE_CODEVarchar2(16)CODE
TAX_CLAIM_CODE_FEDVarchar2(16)CODEY
CFED_TD1_AMOUNTNumber(18)AMT12V6
CFED_ANN_TAX_CREDITNumber(18)AMT12V6
CFED_ANN_TAX_DEDUCTIONNumber(18)AMT12V6
CFED_ANN_AREA_DEDUCTIONNumber(18)AMT12V6
CFED_TAX_AMOUNTNumber(18)AMT12V6
CFED_TAX_PERCENTNumber(5)PERCENT
CFED_ADD_TAX_PER_PERIODNumber(18)AMT12V6
CFED_FILING_STATUSVarchar2(30)VARCHAR30
CFED_TAX_METHODVarchar2(30)VARCHAR30
CFED_CPP_METHODVarchar2(30)VARCHAR30
CFED_EI_METHODVarchar2(30)VARCHAR30
CFED_LABOUR_FUNDNumber(18)AMT12V6
TAX_CLAIM_TYPE_PRVVarchar2(30)VARCHAR30
TAX_CLAIM_CODE_PRVVarchar2(16)CODE
CPRV_CLAIM_AMOUNTNumber(18)AMT12V6
CPRV_NUM_DEPENDENTSNumber(5)NUMBER5
CPRV_ANN_TAX_DEDUCTIONNumber(18)AMT12V6
CPRV_TAX_AMOUNTNumber(18)AMT12V6
CPRV_TAX_PERCENTNumber(5)PERCENT
CPRV_ADD_TAX_PER_PERIODNumber(18)AMT12V6
CPRV_FILING_STATUSVarchar2(30)VARCHAR30
CPRV_TAX_METHODVarchar2(30)VARCHAR30
CPRV_QPP_METHODVarchar2(30)VARCHAR30
CPRV_HEALTH_TAX_METHODVarchar2(30)VARCHAR30
CPRV_WCB_METHODVarchar2(30)VARCHAR30
CPRV_ANN_TAX_CREDITNumber(18)AMT12V6
CPRV_ANN_AREA_DEDUCTIONNumber(18)AMT12V6
CPRV_PPIP_METHODVarchar2(30)VARCHAR30
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30
This particular version was published on 26-Nov-2021 10:22 by JEscott.Top