| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON
|
| 2 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
SPECIAL_CIT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Special CIT Status
E=Exempt (not subject to CIT)
G=Maintain gross
N=None
Default Value: N
|
| 5 |
CIT_ADDL_AMT |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
CIT Additional Amount
|
| 6 |
CIT_ADDL_PCT |
Number(6,3) |
DECIMAL(5,3) NOT NULL |
CIT Additional Percentage
|
| 7 |
CIT_NET_CLAIM_AMT |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
CIT Net Claim Amount
|
| 8 |
TD1_ADJUST |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
TD1 Adjustment
|
| 9 |
CIT_PRESCR_AREA |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
CIT Prescibed Area Deduction
|
| 10 |
CIT_TAX_CREDITS |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
CIT Other Federal Tax Credits
|
| 11 |
CIT_SPECIAL_LTRS |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Special Letters
|
| 12 |
CIT_FACTOR_Y |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
CIT Y Factor
|
| 13 |
CIT_FACTOR_TH |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
CIT TH Factor
|
| 14 |
SPECIAL_QIT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Special QIT Status
E=Exempt (not subject to QIT)
G=Maintain gross
N=None
Default Value: N
|
| 15 |
QIT_ADDL_AMT |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
QIT Additional Amount
|
| 16 |
QIT_ADDL_PCT |
Number(6,3) |
DECIMAL(5,3) NOT NULL |
QIT Additional Percentage
|
| 17 |
QIT_NET_CLAIM_AMT |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
QIT Net Claim Amount
|
| 18 |
QIT_OTHER_DEDUCTS |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
QIT Other Deductions
|
| 19 |
QIT_TAX_CREDITS |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
QIT Other Tax Credits
|
| 20 |
QIT_SPECIAL_LTRS |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
QIT Special Letters
|
| 21 |
QIT_PRESCR_AREA |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
QIT Prescribed Area
|
| 22 |
CPP_SUBJECT_MONTHS |
Number(2,0) |
SMALLINT NOT NULL |
Months Subject to CPP/QPP Con.
|
| 23 |
UI_EXEMPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Exempt from EI Premiums
A=UI Based On Yearly Calculation
A=UI Based On Yearly Calculation
E=Calculation Based on EI Rates
N=UI Based On Pay Period Rules
N=UI Based On Pay Period Rules
Y=Exempt From EI Premiums
|
| 24 |
PAYROLL_TAX_EXEMPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Payroll Tax Exempt
Y/N Table Edit
Default Value: N
|
| 25 |
WAGE_LOSS_PLAN |
Character(3) |
VARCHAR2(3) NOT NULL |
Wage Loss Replacement Plan
Default Value: REG
Prompt Table:
WAGELS_PLAN_TBL
|
| 26 |
LAST_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Last Action
C=System
D=Hire Process
J=Job Data
O=Online User
S=Supplier Deduction File
W=Employee Self Service User
|
| 27 |
CIT_ANNUAL_COMM |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
TD1X Estimated Commissions
|
| 28 |
CIT_ANNUAL_EXP |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
TD1X Estimated Expenses
|
| 29 |
QIT_ANNUAL_COMM |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
MR19-CV Estimated Commissions
|
| 30 |
QIT_ANNUAL_EXP |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
MR19-CV Estimated Expenses
|
| 31 |
LCF_AMT |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Labour Sponsored Shares Amount
|
| 32 |
UI_YEARLY_AMT |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Max. Yearly Insurable Earnings
|
| 33 |
CIT_F_FACTOR_EE |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
RPP/RRSP Limit
|
| 34 |
CROSS_PROVINCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Cross Province
Y/N Table Edit
Default Value: N
|
| 35 |
USE_PROV_OF_RES |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Province of Residence
Y/N Table Edit
Default Value: Y
|
| 36 |
PROVINCE |
Character(6) |
VARCHAR2(6) NOT NULL |
Province
Prompt Table:
PROVINCE_NM_VW
|
| 37 |
STATUS_INDIAN |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Indian
Y/N Table Edit
Default Value: N
|
| 38 |
PCT_EXEMPT |
Number(3,0) |
SMALLINT NOT NULL |
Field to define the percentage of taxable gross that is exempt from income tax.
Default Value: 0
|
| 39 |
USE_FOR_CPP |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to determine is the Status Indian percentage is to be applied to CPP/QPP as well as income tax.
Y/N Table Edit
Default Value: Y
|
| 40 |
NON_INDEX_AMT |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Non-Indexed Amount
|
| 41 |
CREATION_DT |
Date(10) |
DATE |
Creation Date
Default Value: %DATE
|
| 42 |
QPIP_EXEMPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Exempt from QPIP Premiums
N=QPIP Payable
Y=Exempt From QPIP Premiums
Default Value: N
|
| 43 |
SUBJECT_CPP |
Character(1) |
VARCHAR2(1) NOT NULL |
Subject to CPP indicator.
Y/N Table Edit
Default Value: N
|
| 44 |
QC_HLTH_EXMPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used to identify whether or not an employee is exempt from the calculation of Quebec Health Tax during a Canadian Payroll Calculation
Y/N Table Edit
Default Value: N
|
| 45 |
HIST_CPP_NLGRS_YTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
No Limit Gross YTD
|
| 46 |
HIST_CPP_TAX_YTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Tax YTD
|
| 47 |
HIST_CPP_TXGRS_YTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Taxable Gross YTD
|
| 48 |
HIST_EI_TAX_YTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Carryover EI tax YTD
|
| 49 |
HIST_EI_TXGRS_YTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Taxable Gross YTD
|
| 50 |
HIST_QPE_TAX_YTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Carryover QPIP tax YTD
|
| 51 |
HIST_QPE_TXGRS_YTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Taxable Gross YTD
|
| 52 |
HIST_QPP_NLGRS_YTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
No Limit Gross YTD
|
| 53 |
HIST_QPP_TAX_YTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Carryover QPP tax YTD
|
| 54 |
HIST_QPP_TXGRS_YTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Taxable Gross YTD
|
| 55 |
HIST_CP2_NLGRS_YTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
No Limit Gross Year-to-Date
|
| 56 |
HIST_CP2_TAX_YTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Tax Year-to-Date
|
| 57 |
HIST_CP2_TXGRS_YTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Taxable Gross Year-to-Date
|
| 58 |
HIST_QP2_NLGRS_YTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
No Limit Gross Year-to-Date
|
| 59 |
HIST_QP2_TAX_YTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Tax Year-to-Date
|
| 60 |
HIST_QP2_TXGRS_YTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Taxable Gross Year-to-Date
|