PY_SS_USA_GDE (SQL Table)	Index Back
Year-End Form Self Service Year-End Form Self Service Guide Table. Each entry on this table corresponds to one year-end form.

PY_SS_USA_GDE

(SQL Table)

Year-End Form Self Service

Year-End Form Self Service Guide Table. Each entry on this table corresponds to one year-end form.

# 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

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 PY_W2_PROCESS_TYPE Character(1) VARCHAR2(1) NOT NULL Year End using XML Publisher: Identifies type of process.
1=Original
2=Corrected
3=Reissued Statement
4=No Specific Reason

10 YE_FORM_ISSUE_DT Date(10) DATE This field is used in Payroll for North America Self Service Year-End Forms. It stores the date when the forms were generated.

11 YE_FORM_VIEWING_DT Date(10) DATE This field is used in Payroll for North America Self Service Year-End Forms. It stores the date that determines when the forms become viewable in Self Service.

12 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename

13 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File

14 PY_YE_FILEURLID Character(30) VARCHAR2(30) NOT NULL URL ID used to store and retrieve year-end pdf forms.

15 PY_YE_REPORT_URL Character(254) VARCHAR2(254) NOT NULL Report URL

16 PY_YE_BURST_ID Character(40) VARCHAR2(40) NOT NULL Stores the value used for bursting a PDF file into separate employee-level files.

17 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

18 REPORT_DEFN_ID Character(12) VARCHAR2(12) NOT NULL Report Name (see PSXPRPTDEFN).

19 BURST_FIELDNAME Character(30) VARCHAR2(30) NOT NULL Burst Field Name

20 PY_YE_NOTIFY_FLG Character(1) VARCHAR2(1) NOT NULL Indicates whether notification of availability for viewing a year-end form has been sent to employee. Y - notification already sent to employee N - notification not yet sent to employee
Y/N Table Edit
Default Value: N

21 PY_W2_FINAL_PRINT Character(1) VARCHAR2(1) NOT NULL Identifies whether final run or not.
Y/N Table Edit

#	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
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	PY_W2_PROCESS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Year End using XML Publisher: Identifies type of process. 1=Original 2=Corrected 3=Reissued Statement 4=No Specific Reason
10	YE_FORM_ISSUE_DT	Date(10)	DATE	This field is used in Payroll for North America Self Service Year-End Forms. It stores the date when the forms were generated.
11	YE_FORM_VIEWING_DT	Date(10)	DATE	This field is used in Payroll for North America Self Service Year-End Forms. It stores the date that determines when the forms become viewable in Self Service.
12	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
13	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
14	PY_YE_FILEURLID	Character(30)	VARCHAR2(30) NOT NULL	URL ID used to store and retrieve year-end pdf forms.
15	PY_YE_REPORT_URL	Character(254)	VARCHAR2(254) NOT NULL	Report URL
16	PY_YE_BURST_ID	Character(40)	VARCHAR2(40) NOT NULL	Stores the value used for bursting a PDF file into separate employee-level files.
17	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
18	REPORT_DEFN_ID	Character(12)	VARCHAR2(12) NOT NULL	Report Name (see PSXPRPTDEFN).
19	BURST_FIELDNAME	Character(30)	VARCHAR2(30) NOT NULL	Burst Field Name
20	PY_YE_NOTIFY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether notification of availability for viewing a year-end form has been sent to employee. Y - notification already sent to employee N - notification not yet sent to employee Y/N Table Edit Default Value: N
21	PY_W2_FINAL_PRINT	Character(1)	VARCHAR2(1) NOT NULL	Identifies whether final run or not. Y/N Table Edit