Alias: IVPPRC#
(INF_CV_CDNPAYRULES)(Canada only) The INF_CV_CDNPAYRULES table is used to import taxation rules for employees into the software data structures. This table defines the employee’s rules for taxation, including claim codes, filing status and exemption information.
Tables loaded: P2K_PR_CDN_PAY_RULES
Table Columns#
| Column name | Data Type / Size | Mand. | Notes |
|---|---|---|---|
| ID | Number(10) | Used internally to define a unique identification for the record. This field would not be loaded. | |
| ENTITY_CODE | Varchar2(16) | Y | Validation: The Entity Code provided must be defined on P2K_CM_ENTITIES |
| PERSON_CODE | Varchar2(16) | Y | Not moved to the P2K_CM_LOCATIONS table, but used for validation of the employment record. Validation: Must be a valid PERSON_CODE already defined on the P2K_HR_IDENTITIES table. |
| EMPLOYMENT_TYPE | Varchar2(30) | Validation: The employee must have an active employment record for this employment type. Must be one of the fixed lexicon values from X_EMPLOYMENT_TYPE. Derivation: If you do not provide an employment type value, the conversion application will look for any P2K_HR_EMPLOYMENTS record that matches the other criteria. Suggestion: If you are loading employees, you can set this field to a fixed value of ‘01’. | |
| HIRE_DATE | Date() | Not moved to the software structures, but used for validation of the employment record. Derivation: If you do not provide a hire date, the conversion application will look for any P2K_HR_EMPLOYMENTS record that matches the other criteria. Validation: Must be a valid date | |
| EFFECTIVE | Date() | Y | Validation: Must be a valid date format. Suggestion: If you are not loading multiple date-effective records for the same employee, then populate this field with a constant ‘01-Jan-0001’ which represents the beginning of time. |
| EXPIRY | Date() | Y | Validation: Must be a valid date format, with a date after the effective date Suggestion: If you are not loading multiple date-effective records for the same employee, then populate this field with a constant ‘31-Dec-3999’ which represents the end of time |
| CHANGE_CODE | Varchar2(16) | Validation: The Change Code provided must be defined on P2K_CM_CHANGE_REASONS | |
| TAX_CLAIM_CODE_FED | Varchar2(16) | Y | Validation: Must be a valid federal claim code already defined on P2K_PR_CDN_CLAIM_CODES |
| CFED_TD1_AMOUNT | Number(18) | ||
| CFED_ANN_TAX_CREDIT | Number(18) | ||
| CFED_ANN_TAX_DEDUCTION | Number(18) | ||
| CFED_ANN_AREA_DEDUCTION | Number(18) | ||
| CFED_TAX_AMOUNT | Number(18) | ||
| CFED_TAX_PERCENT | Number(5) | ||
| CFED_ADD_TAX_PER_PERIOD | Number(18) | ||
| CFED_FILING_STATUS | Varchar2(30) | Validation:If provided, must be one of the fixed lexicon values from X_CFED_FILING_STATUS | |
| CFED_TAX_METHOD | Varchar2(30) | Validation:If provided, must be one of the fixed lexicon values from X_CFED_TAX_METHOD | |
| CFED_CPP_METHOD | Varchar2(30) | Validation:If provided, must be one of the fixed lexicon values from X_CFED_CPP_METHOD | |
| CFED_EI_METHOD | Varchar2(30) | Validation:If provided, must be one of the fixed lexicon values from X_CFED_EI_METHOD | |
| CFED_LABOUR_FUND | Number(18) | ||
| TAX_CLAIM_TYPE_PRV | Varchar2(30) | Validation:If provided, must be one of the fixed lexicon values from X_TAX_CLAIM_TYPE | |
| TAX_CLAIM_CODE_PRV | Varchar2(16) | Validation: Must be a valid provincial claim code already defined on P2K_PR_CDN_CLAIM_CODES | |
| CPRV_CLAIM_AMOUNT | Number(18) | ||
| CPRV_NUM_DEPENDENTS | Number(5) | ||
| CPRV_ANN_TAX_DEDUCTION | Number(18) | ||
| CPRV_TAX_AMOUNT | Number(18) | ||
| CPRV_TAX_PERCENT | Number(5) | ||
| CPRV_ADD_TAX_PER_PERIOD | Number(18) | ||
| CPRV_FILING_STATUS | Varchar2(30) | Validation:If provided, must be one of the fixed lexicon values from X_CPRV_FILING_STATUS | |
| CPRV_TAX_METHOD | Varchar2(30) | Validation:If provided, must be one of the fixed lexicon values from X_CPRV_TAX_METHOD | |
| CPRV_QPP_METHOD | Varchar2(30) | Validation:If provided, must be one of the fixed lexicon values from X_CPRV_QPP_METHOD | |
| CPRV_HEALTH_TAX_METHOD | Varchar2(30) | Validation:If provided, must be one of the fixed lexicon values from X_CPRV_HEALTH_TAX_METHOD | |
| CPRV_WCB_METHOD | Varchar2(30) | Validation:If provided, must be one of the fixed lexicon values from X_CPRV_WCB_METHOD | |
| CPRV_ANN_TAX_CREDIT | Number(18) | ||
| CPRV_ANN_AREA_DEDUCTION | Number(18) | ||
| CPRV_PPIP_METHOD | Varchar2(30) | ||
| CREATE_DATE | Date() | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. | |
| CREATE_USER | Varchar2(30) | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. | |
| CHANGE_DATE | Date() | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. | |
| CHANGE_USER | Varchar2(30) | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. |
