PY_YE_IN_W2C_VW (SQL View)	Index Back
Insights W-2c Forms view Insights W-2c Forms View

PY_YE_IN_W2C_VW

(SQL View)

Insights W-2c Forms view

Insights W-2c Forms View

SELECT A.EMPLID ,A.PY_TAX_YEAR ,A.W2_REPORTING_CO ,A.TAXFORM_ID ,A.SEQUENCE_NUMBER ,A.W2C_BATCH_NBR ,A.W2C_BATCH_YR ,A.PY_YE_FORM_SEQNUM ,( SELECT X.XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'TAXFORM_ID' AND X.FIELDVALUE = A.TAXFORM_ID AND %EffdtCheck(PSXLATITEM X1, X, %CurrentDateIn)) ,%CurrentDateTimeIn FROM PS_PY_SS_USA_GDE A WHERE A.TAXFORM_ID IN ('J','N','Q','U','X')

# 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 TAXFORM_ID_DESCR Character(30) VARCHAR2(30) NOT NULL Taxform ID Description

10 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	TAXFORM_ID_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Taxform ID Description
10	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.