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 :
1
Date Modified :
26-Nov-2021 10:22
Author : JEscott
More Info...
Attachments
Reading time: 0.4 mins, 92 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
#
(INF_CV_CDNPAYRULES)
Cdn Pay Rules
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