Personality Knowledgebase 5.05
Internal
Wiki
G’day (anonymous guest)
User Preferences
Log in
Register a new user!
For full search, hit enter...
Recent Searches
INF_CV_CDNPAYRULES
☰
…
Trail
TR_PERIOD_PAYBACK
WF_HIN
Info
Version :
2
Date Modified :
26-Nov-2021 10:22
Author : JEscott
More Info...
Attachments
Reading time: 0.5 mins, 121 words
E
dit
More...
View Page Source
Show Reader View
Wiki Formatting
Main
This is version
1
2
3
4
5
6
7
. It is not the current version, and thus it cannot be edited.
Back to current version
Restore this version
Alias: IVPPRC
#
(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.
Table Columns
#
Column name
Data Type / Size
Domain
Mand.
Notes
ID
Number(10)
ID
ENTITY_CODE
Varchar2(16)
CODE
Y
PERSON_CODE
Varchar2(16)
CODE
Y
EMPLOYMENT_TYPE
Varchar2(30)
VARCHAR30
HIRE_DATE
Date()
DATE
EFFECTIVE
Date()
EFFECTIVE
Y
EXPIRY
Date()
EXPIRY
Y
CHANGE_CODE
Varchar2(16)
CODE
TAX_CLAIM_CODE_FED
Varchar2(16)
CODE
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(30)
VARCHAR30
CFED_TAX_METHOD
Varchar2(30)
VARCHAR30
CFED_CPP_METHOD
Varchar2(30)
VARCHAR30
CFED_EI_METHOD
Varchar2(30)
VARCHAR30
CFED_LABOUR_FUND
Number(18)
AMT12V6
TAX_CLAIM_TYPE_PRV
Varchar2(30)
VARCHAR30
TAX_CLAIM_CODE_PRV
Varchar2(16)
CODE
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(30)
VARCHAR30
CPRV_TAX_METHOD
Varchar2(30)
VARCHAR30
CPRV_QPP_METHOD
Varchar2(30)
VARCHAR30
CPRV_HEALTH_TAX_METHOD
Varchar2(30)
VARCHAR30
CPRV_WCB_METHOD
Varchar2(30)
VARCHAR30
CPRV_ANN_TAX_CREDIT
Number(18)
AMT12V6
CPRV_ANN_AREA_DEDUCTION
Number(18)
AMT12V6
CPRV_PPIP_METHOD
Varchar2(30)
VARCHAR30
CREATE_DATE
Date()
DATE
CREATE_USER
Varchar2(30)
VARCHAR30
CHANGE_DATE
Date()
DATE
CHANGE_USER
Varchar2(30)
VARCHAR30
Hello, 10.86.0.2
Index
Recent Updates
Wiki Formatting
Search Help