PY_IN_YE_FM_DEL (SQL Table)	Index Back
Insights Year End Forms Delete Insights Year End Forms delete record for incremental processing

PY_IN_YE_FM_DEL

(SQL Table)

Insights Year End Forms Delete

Insights Year End Forms delete record for incremental 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 IRS_INCOME_CD_1042 Character(2) VARCHAR2(2) NOT NULL This field is to store the income code associated with the tax 1042 earnings. This income code is required on 1042S form.

10 DISTRIB_CODE Character(2) VARCHAR2(2) NOT NULL Distribution Code

11 COMPANY_1099R Character(3) VARCHAR2(3) NOT NULL 1099R Company

12 STATE Character(6) VARCHAR2(6) NOT NULL State

13 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	IRS_INCOME_CD_1042	Character(2)	VARCHAR2(2) NOT NULL	This field is to store the income code associated with the tax 1042 earnings. This income code is required on 1042S form.
10	DISTRIB_CODE	Character(2)	VARCHAR2(2) NOT NULL	Distribution Code
11	COMPANY_1099R	Character(3)	VARCHAR2(3) NOT NULL	1099R Company
12	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
13	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.