PY_YE_IN_W2C_TB (SQL Table)	Index Back
Insights W2 correction record Insigts W2 correction record for pre-processing

PY_YE_IN_W2C_TB

(SQL Table)

Insights W2 correction record

Insigts W2 correction record for pre-processing

Related Language Record: PY_YE_IN_W2C_LN

# 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 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

10 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

11 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

12 PY_DEPT_DESCR Character(100) VARCHAR2(100) NOT NULL Department description

13 PY_PAYGROUP_DESCR Character(100) VARCHAR2(100) NOT NULL Paygroup Description

14 PY_BUS_DESCR Character(100) VARCHAR2(100) NOT NULL Business Unit description

15 PY_W2_CMP_DESCR Character(254) VARCHAR2(254) NOT NULL W-2 company description

16 TAXFORM_ID_DESCR Character(30) VARCHAR2(30) NOT NULL Taxform ID Description

17 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.

#	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	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
10	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
11	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
12	PY_DEPT_DESCR	Character(100)	VARCHAR2(100) NOT NULL	Department description
13	PY_PAYGROUP_DESCR	Character(100)	VARCHAR2(100) NOT NULL	Paygroup Description
14	PY_BUS_DESCR	Character(100)	VARCHAR2(100) NOT NULL	Business Unit description
15	PY_W2_CMP_DESCR	Character(254)	VARCHAR2(254) NOT NULL	W-2 company description
16	TAXFORM_ID_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Taxform ID Description
17	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.