| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 CTX_COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 2 |
CTX_TAXFORM_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax form ID
|
| 3 |
CTX_PROVINCE |
Character(6) |
VARCHAR2(6) NOT NULL |
Province
|
| 4 |
CTX_WAGE_LOSS_PLAN |
Character(3) |
VARCHAR2(3) NOT NULL |
Wage Loss Plan
|
| 5 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 6 |
SEQUENCE_NUMBER |
Number(2,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 7 |
CAN_YE_SLIP_SEQ |
Number(2,0) |
SMALLINT NOT NULL |
This is the Canadian year-end slip sequence number. For T4 and T4A, they have a slip sequence number of 0 (default value). As for RL-1 and RL-2, if a box amount exceeds maximum box amount allowed by MRQ, additional slip will have incremental slip number.
|
| 8 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 9 |
TAXFORM_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Form Identification
A=T4A Slip
B=Business Payrolls Survey - CAN
C=WCB Assessable Earnings
E=Record of Employment
F=940 - Annual Employer's FUTA
I=W-2VI
J=W-2cVI
M=W-2GU
N=W-2cGU
P=W-2PR
Q=W-2cPR
R=RL-1 Slip
S=W-2AS
T=T4 Slip
U=W-2cAS
V=RL-2 Slip
W=W-2
X=W-2c
Y=1099-R
Z=1042-S
|
| 10 |
PROVINCE |
Character(6) |
VARCHAR2(6) NOT NULL |
Province
|
| 11 |
WAGE_LOSS_PLAN |
Character(3) |
VARCHAR2(3) NOT NULL |
Wage Loss Replacement Plan
|
| 12 |
YE_SLIP_PROCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Slip Process Type
A=Amended
C=Cancelled
D=Delete
N=Newly Reissued
O=Original
|
| 13 |
SLIP_SURNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Surname
|
| 14 |
SLIP_FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 15 |
SLIP_INITIAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Middle Initial
|
| 16 |
SIN |
Character(9) |
VARCHAR2(9) NOT NULL |
Social Insurance Nbr
|
| 17 |
REPORTING_ID |
Character(16) |
VARCHAR2(16) NOT NULL |
Tax Reporting ID
|
| 18 |
EMPLOYMENT_CODE |
Character(2) |
VARCHAR2(2) NOT NULL |
Employment Code
11=Placement Agency-Self-Employed
12=Taxi Driver/Psgr-Carry Vehicle
13=Barber or Hairdresser
14=Withdrawal-Deferred Salary Pln
15=Seasonal Agricultural Wrkr Pgm
16=Detached EE-Soc Sec Agreement
17=Fisher
|
| 19 |
SIN_CONTRB_SPOUSE |
Character(9) |
VARCHAR2(9) NOT NULL |
Spouse SIN
|
| 20 |
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
|
| 21 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 22 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|