| # |
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 |
PY_TAX_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Represents the year for personal income tax purposes.
|
| 4 |
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
|
| 5 |
SEQUENCE_NUMBER |
Number(2,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 6 |
BOX |
Character(4) |
VARCHAR2(4) NOT NULL |
Box
|
| 7 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 8 |
LOCALITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Locality
|
| 9 |
WORK_PSD_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Locality
|
| 10 |
RES_PSD_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Locality
|
| 11 |
W2_REPORTING_CO |
Character(3) |
VARCHAR2(3) NOT NULL |
W-2 Reporting Company
|
| 12 |
EMPL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Payroll Status
A=Active
D=Deceased
L=Leave of Absence
P=Leave With Pay
Q=Retired With Pay
R=Retired
S=Suspended
T=Terminated
U=Terminated With Pay
V=Terminated Pension Pay Out
W=Short Work Break
X=Retired-Pension Administration
|
| 13 |
HR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
HR Status
A=Active
I=Inactive
|
| 14 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
|
| 15 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 16 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 17 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 18 |
PY_W2_CMP_DESCR |
Character(254) |
VARCHAR2(254) NOT NULL |
W-2 company description
|
| 19 |
PY_DEPT_DESCR |
Character(100) |
VARCHAR2(100) NOT NULL |
Department description
|
| 20 |
PY_PAYGROUP_DESCR |
Character(100) |
VARCHAR2(100) NOT NULL |
Paygroup Description
|
| 21 |
PY_COMPANY_DESCR |
Character(100) |
VARCHAR2(100) NOT NULL |
Company description
|
| 22 |
PY_BUS_DESCR |
Character(100) |
VARCHAR2(100) NOT NULL |
Business Unit description
|