Alias: IVPPRC#

(INF_CV_CDNPAYRULES)
Cdn 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
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