P 2 K_PR_CDN_PAY_RULES
Back to current versionRestore this version

Alias: PPRC#

Unique Keys: _
Child Table:
_
Parent Table: _

Cdn Pay Rules

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
EEM_IDNumber(10)IDYlink to P2K_HR_EMPLOYMENTS
EFFECTIVEDate()EFFECTIVEY
EXPIRYDate()EXPIRYY
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(2)X_CFED_FILING_STATUS
CFED_TAX_METHODVarchar2(2)X_CFED_TAX_METHOD
CFED_CPP_METHODVarchar2(2)X_CFED_CPP_METHOD
CFED_EI_METHODVarchar2(2)X_CFED_EI_METHOD
CFED_LABOUR_FUNDNumber(18)AMT12V6
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(2)X_CPRV_FILING_STATUS
CPRV_TAX_METHODVarchar2(2)X_CPRV_TAX_METHOD
CPRV_QPP_METHODVarchar2(2)X_CPRV_QPP_METHOD
CPRV_HEALTH_TAX_METHODVarchar2(2)X_CPRV_HEALTH_TAX_METHOD
CPRV_WCB_METHODVarchar2(2)X_CPRV_WCB_METHOD
PCC_ID_FEDNumber(10)IDYlink to P2K_PR_CDN_CLAIM_CODES
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
PCC_ID_PRVNumber(10)ID link to P2K_PR_CDN_CLAIM_CODES
CPRV_ANN_TAX_CREDITNumber(18)AMT12V6
CPRV_ANN_AREA_DEDUCTIONNumber(18)AMT12V6
DCR_IDNumber(10)ID link to P2K_CM_CHANGE_REASONS
CPRV_PPIP_METHODVarchar2(2)X_CPRV_PPIP_METHOD

User Fields: Not Allowed
Audit Logging: Allowed