| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 2 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 3 |
CALENDAR_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Calendar Year
|
| 4 |
SEQUENCE_NUMBER |
Number(2,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 5 |
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
|
| 6 |
WAGE_LOSS_PLAN |
Character(3) |
VARCHAR2(3) NOT NULL |
Wage Loss Replacement Plan
|
| 7 |
PROVINCE |
Character(6) |
VARCHAR2(6) NOT NULL |
Province
|
| 8 |
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.
Default Value: 0
|
| 9 |
FOOTNOTE_COUNT |
Number(2,0) |
SMALLINT NOT NULL |
Footnote Count
|
| 10 |
REPORTING_ID |
Character(16) |
VARCHAR2(16) NOT NULL |
Tax Reporting ID
|
| 11 |
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
Default Value: N
|
| 12 |
PROCESS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Flag
C=Complete
V=Void
X=W-2c Issued
|
| 13 |
RELEVE_SLIP_NO |
Character(9) |
VARCHAR2(9) NOT NULL |
RL-1 Slip Number
|
| 14 |
CIT_TO_T4A_GRS |
Signed Number(15,2) |
DECIMAL(13,2) NOT NULL |
T4 Gross Reclassified as T4A
|
| 15 |
CIT_TO_T4A_TAX |
Signed Number(15,2) |
DECIMAL(13,2) NOT NULL |
T4 Tax Reclassified as T4A
|
| 16 |
PROVENANCE |
Character(6) |
VARCHAR2(6) NOT NULL |
RL-2 Provenance
|
| 17 |
PROVENANCE2 |
Character(6) |
VARCHAR2(6) NOT NULL |
RL-2 Provenance 2
|
| 18 |
RELEVE2_SLIP_NO |
Character(9) |
VARCHAR2(9) NOT NULL |
RL-2 Slip Number
|
| 19 |
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
|
| 20 |
SIN_CONTRB_SPOUSE |
Character(9) |
VARCHAR2(9) NOT NULL |
Spouse SIN
|
| 21 |
NAME_CONTRB_SPOUSE |
Character(12) |
VARCHAR2(12) NOT NULL |
Spouse Last Name
|
| 22 |
YE_SLIP_PROCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Slip Process Type
A=Amended
C=Cancelled
D=Delete
N=Newly Reissued
O=Original
Default Value: O
|