!!!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.


----
![Notes|Edit:Internal.INF_CV_CDNPAYRULES] 	
[{InsertPage page='Internal.INF_CV_CDNPAYRULES' default='Click to create a new notes page'}]