P 2 K_PR_CDN_PAY_RULES

Alias: PPRC#

(P2K_PR_CDN_PAY_RULES)

Unique Keys:
Child Table:
Parent Table:
ERD: ERD-PR35


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

Notes #

Click to create a new notes page

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation