Alias: PPRC#

(P2K_PR_CDN_PAY_RULES)

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

Cdn Pay Rules

Table Columns#

Column name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
EEM_ID	Number(10)	ID	Y	link to P2K_HR_EMPLOYMENTS
EFFECTIVE	Date()	EFFECTIVE	Y
EXPIRY	Date()	EXPIRY	Y
CFED_TD1_AMOUNT	Number(18)	AMT12V6
CFED_ANN_TAX_CREDIT	Number(18)	AMT12V6
CFED_ANN_TAX_DEDUCTION	Number(18)	AMT12V6
CFED_ANN_AREA_DEDUCTION	Number(18)	AMT12V6
CFED_TAX_AMOUNT	Number(18)	AMT12V6
CFED_TAX_PERCENT	Number(5)	PERCENT
CFED_ADD_TAX_PER_PERIOD	Number(18)	AMT12V6
CFED_FILING_STATUS	Varchar2(2)	X_CFED_FILING_STATUS
CFED_TAX_METHOD	Varchar2(2)	X_CFED_TAX_METHOD
CFED_CPP_METHOD	Varchar2(2)	X_CFED_CPP_METHOD
CFED_EI_METHOD	Varchar2(2)	X_CFED_EI_METHOD
CFED_LABOUR_FUND	Number(18)	AMT12V6
CPRV_CLAIM_AMOUNT	Number(18)	AMT12V6
CPRV_NUM_DEPENDENTS	Number(5)	NUMBER5
CPRV_ANN_TAX_DEDUCTION	Number(18)	AMT12V6
CPRV_TAX_AMOUNT	Number(18)	AMT12V6
CPRV_TAX_PERCENT	Number(5)	PERCENT
CPRV_ADD_TAX_PER_PERIOD	Number(18)	AMT12V6
CPRV_FILING_STATUS	Varchar2(2)	X_CPRV_FILING_STATUS
CPRV_TAX_METHOD	Varchar2(2)	X_CPRV_TAX_METHOD
CPRV_QPP_METHOD	Varchar2(2)	X_CPRV_QPP_METHOD
CPRV_HEALTH_TAX_METHOD	Varchar2(2)	X_CPRV_HEALTH_TAX_METHOD
CPRV_WCB_METHOD	Varchar2(2)	X_CPRV_WCB_METHOD
PCC_ID_FED	Number(10)	ID	Y	link to P2K_PR_CDN_CLAIM_CODES
CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y
PCC_ID_PRV	Number(10)	ID		link to P2K_PR_CDN_CLAIM_CODES
CPRV_ANN_TAX_CREDIT	Number(18)	AMT12V6
CPRV_ANN_AREA_DEDUCTION	Number(18)	AMT12V6
DCR_ID	Number(10)	ID		link to P2K_CM_CHANGE_REASONS
CPRV_PPIP_METHOD	Varchar2(2)	X_CPRV_PPIP_METHOD

User Fields: Not Allowed
Audit Logging: Allowed

---

Notes #

Click to create a new notes page