PY_YE_IN_W2C_DL

(SQL Table)
Index Back

Insights W2 Corrections delete

Insights W2 corrections delete record for pre-processing

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 PY_TAX_YEAR Number(4,0) SMALLINT NOT NULL Represents the year for personal income tax purposes.
3 W2_REPORTING_CO Character(3) VARCHAR2(3) NOT NULL W-2 Reporting Company
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 W2C_BATCH_NBR Number(4,0) SMALLINT NOT NULL W-2c Batch Number
7 W2C_BATCH_YR Number(4,0) SMALLINT NOT NULL W-2c Batch Year
8 PY_YE_FORM_SEQNUM Number(2,0) SMALLINT NOT NULL A sequential number to indicate the number of W2/W-2c that have been issued/generated for an employee. Initial copy will have a value of 1. Used in Self Service Year-End Forms.
9 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.