| # |
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 |
BALANCE_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Balance ID
Prompt Table:
BALANCE_ID_TBL
|
| 4 |
BALANCE_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Balances for Year
Prompt Table:
BALANCE_YR_VW
|
| 5 |
WAGE_LOSS_PLAN |
Character(3) |
VARCHAR2(3) NOT NULL |
Wage Loss Replacement Plan
Prompt Table:
WAGELS_PLAN_TBL
|
| 6 |
PROVINCE |
Character(6) |
VARCHAR2(6) NOT NULL |
Province
|
| 7 |
BALANCE_QTR |
Number(3,0) |
SMALLINT NOT NULL |
Balances for Quarter
Prompt Table:
BALANCE_ID_QTR
|
| 8 |
BALANCE_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Balances for Period
Prompt Table:
BALANCE_ID_DEF
|
| 9 |
TAX_CLASS_CAN |
Character(3) |
VARCHAR2(3) NOT NULL |
Canadian Tax Class
ALL=Total Gross
CBT=Canadian Bonus Tax
CIT=Canadian Income Tax (T4)
CP2=CPP Second Additional Employee
CPA=Pension Adjustment
CPP=Canada Pension Plan Employee
CPR=Canada Pension Plan Employer
CR2=CPP Second Additional Employer
EIE=Employment Insurance Employee
EIR=Employment Insurance Employer
HTX=Provincial Health Tax
PYT=Payroll Tax
QBT=Quebec Bonus Tax
QCD=Quebec Tax Deduction
QIE=Quebec Parental Plan Employee
QIR=Quebec Parental Plan Employer
QIT=Quebec Income Tax (RL-1)
QP2=QPP Second Additional Employee
QPP=Quebec Pension Plan Employee
QPR=Quebec Pension Plan Employer
QR2=QPP Second Additional Employer
RV2=Quebec Income Tax (RL-2)
T4A=Canadian Income Tax (T4A)
TRV=True RL
TT4=True T4
|
| 10 |
NLGRS_YTD |
Signed Number(15,2) |
DECIMAL(13,2) NOT NULL |
No Limit Gross YTD
|
| 11 |
NLGRS_QTD |
Signed Number(15,2) |
DECIMAL(13,2) NOT NULL |
No Limit Gross QTD
|
| 12 |
NLGRS_MTD |
Signed Number(15,2) |
DECIMAL(13,2) NOT NULL |
No Limit Gross MTD
|
| 13 |
TXGRS_YTD |
Signed Number(15,2) |
DECIMAL(13,2) NOT NULL |
Taxable Gross YTD
|
| 14 |
TXGRS_QTD |
Signed Number(15,2) |
DECIMAL(13,2) NOT NULL |
Taxable Gross QTD
|
| 15 |
TXGRS_MTD |
Signed Number(15,2) |
DECIMAL(13,2) NOT NULL |
Taxable Gross MTD
|
| 16 |
TAX_YTD |
Signed Number(15,2) |
DECIMAL(13,2) NOT NULL |
Tax YTD
|
| 17 |
TAX_QTD |
Signed Number(15,2) |
DECIMAL(13,2) NOT NULL |
Tax QTD
|
| 18 |
TAX_MTD |
Signed Number(15,2) |
DECIMAL(13,2) NOT NULL |
Tax MTD
|
| 19 |
PY_CAN_PEN_EXEMPT |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Canada Pension Plan or Quebec Pension Plan - Basic Annual Exemption Amount.
|
| 20 |
PY_F5A_YTD |
Signed Number(15,2) |
DECIMAL(13,2) NOT NULL |
Year-to-date deductions for Canada (or Quebec) Pension Plan additional contributions for the pay period deducted from the periodic income.
|
| 21 |
PY_F5B_YTD |
Signed Number(15,2) |
DECIMAL(13,2) NOT NULL |
Year-to-date deductions for Canada (or Quebec) Pension Plan additional contributions for the pay period deducted from the non-periodic payment.
|