Alias: PCTC#
(P2K_PR_CDN_PAY_CATEGORIES)Unique Keys:
Child Table:
Parent Table:
ERD: ERD-PR05
Cdn Pay Categories
Table Columns#
| Column name | Data Type / Size | Domain | Mand. | Notes |
|---|---|---|---|---|
| ID | Number(10) | ID | Y | |
| PCT_ID | Number(10) | ID | Y | link to P2K_PR_PAY_CATEGORIES |
| CREATE_DATE | Date() | DATE | Y | |
| CREATE_USER | Varchar2(30) | VARCHAR30 | Y | |
| CHANGE_DATE | Date() | DATE | Y | |
| CHANGE_USER | Varchar2(30) | VARCHAR30 | Y | |
| CFED_CPP_METHOD | Varchar2(2) | X_CFED_CPP_METHOD | ||
| CFED_EI_METHOD | Varchar2(2) | X_CFED_EI_METHOD | ||
| CPRV_HEALTH_TAX_METHOD | Varchar2(2) | X_CPRV_HEALTH_TAX_METHOD | ||
| CFED_TAX_METHOD | Varchar2(2) | X_CFED_TAX_METHOD | ||
| CPRV_QPP_METHOD | Varchar2(2) | X_CPRV_QPP_METHOD | ||
| CPRV_TAX_METHOD | Varchar2(2) | X_CPRV_TAX_METHOD | ||
| CPRV_WCB_METHOD | Varchar2(2) | X_CPRV_WCB_METHOD | ||
| T4A_RELEVE2_ELIGIBLE | Varchar2(1) | TOGGLE | ||
| CPRV_PPIP_METHOD | Varchar2(2) | X_CPRV_PPIP_METHOD |
User Fields: Allowed
Audit Logging: Allowed
