| # |
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 |
TAX_CLASS_CAN |
Character(3) |
VARCHAR2(3) NOT NULL |
Canadian Tax Class
ALL=Total Gross
CBT=Canadian Bonus Tax
CIT=Canadian Income Tax (T4)
CPA=Pension Adjustment
CPP=Canada Pension Plan Employee
CPR=Canada Pension Plan 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)
QPP=Quebec Pension Plan Employee
QPR=Quebec Pension Plan Employer
RV2=Quebec Income Tax (RL-2)
T4A=Canadian Income Tax (T4A)
TRV=True RL
TT4=True T4
|
| 8 |
BAL_ADJ_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Balance Adjust Sequence Number
|
| 9 |
DT_ENTERED |
Date(10) |
DATE NOT NULL |
Date Entered
|
| 10 |
BALANCE_QTR |
Number(3,0) |
SMALLINT NOT NULL |
Balances for Quarter
Prompt Table:
BALANCE_ID_QTR
|
| 11 |
BALANCE_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Balances for Period
Prompt Table:
BALANCE_ID_DEF
|
| 12 |
NLGRS_YTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
No Limit Gross YTD
|
| 13 |
NLGRS_QTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
No Limit Gross QTD
|
| 14 |
NLGRS_MTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
No Limit Gross MTD
|
| 15 |
NLGRS_YTD_ADJ |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
No Limit Gross YTD Adjusted
|
| 16 |
NLGRS_QTD_ADJ |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
No Limit Gross QTD Adjusted
|
| 17 |
NLGRS_MTD_ADJ |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
No Limit Gross MTD Adjusted
|
| 18 |
NLGRS_ADJ |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
No Limit Gross Adjustment
|
| 19 |
TXGRS_YTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Taxable Gross YTD
|
| 20 |
TXGRS_QTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Taxable Gross QTD
|
| 21 |
TXGRS_MTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Taxable Gross MTD
|
| 22 |
TXGRS_YTD_ADJ |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Taxable Gross YTD Adjusted
|
| 23 |
TXGRS_QTD_ADJ |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Taxable Gross QTD Adjusted
|
| 24 |
TXGRS_MTD_ADJ |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Taxable Gross MTD Adjusted
|
| 25 |
TXGRS_ADJ |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Taxable Gross Adjustment
|
| 26 |
TAX_YTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Tax YTD
|
| 27 |
TAX_QTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Tax QTD
|
| 28 |
TAX_MTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Tax MTD
|
| 29 |
TAX_YTD_ADJ |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Tax YTD Adjusted
|
| 30 |
TAX_QTD_ADJ |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Tax QTD Adjusted
|
| 31 |
TAX_MTD_ADJ |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Tax MTD Adjusted
|
| 32 |
TAX_ADJ |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Tax Adjustment
|
| 33 |
ADJ_REASON |
Character(50) |
VARCHAR2(50) NOT NULL |
Adjustment Reason
|