PY_IN_W2C_BX_DL (SQL Table)	Index Back
Insights W2c Box Delete Insights W2c correction delete record for Pre-processing

PY_IN_W2C_BX_DL

(SQL Table)

Insights W2c Box Delete

Insights W2c correction 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 W2_REPORTING_CO Character(3) VARCHAR2(3) NOT NULL W-2 Reporting Company

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 W2C_BATCH_NBR Number(4,0) SMALLINT NOT NULL W-2c Batch Number

6 SEQUENCE_NUMBER Number(2,0) SMALLINT NOT NULL Sequence Number

7 BOX Character(4) VARCHAR2(4) NOT NULL Box

8 PRV_SSN Character(9) VARCHAR2(9) NOT NULL or SSN
Default Value: W2C_DATA.PRV_SSN

9 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: W2C_STATE_NM_VW

10 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality
Prompt Table: W2C_LOCAL_TX_VW

11 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	W2_REPORTING_CO	Character(3)	VARCHAR2(3) NOT NULL	W-2 Reporting Company
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	W2C_BATCH_NBR	Number(4,0)	SMALLINT NOT NULL	W-2c Batch Number
6	SEQUENCE_NUMBER	Number(2,0)	SMALLINT NOT NULL	Sequence Number
7	BOX	Character(4)	VARCHAR2(4) NOT NULL	Box
8	PRV_SSN	Character(9)	VARCHAR2(9) NOT NULL	or SSN Default Value: W2C_DATA.PRV_SSN
9	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: W2C_STATE_NM_VW
10	LOCALITY	Character(10)	VARCHAR2(10) NOT NULL	Locality Prompt Table: W2C_LOCAL_TX_VW
11	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.