PY_IN_YE_FMS (SQL Table)	Index Back
Insights YE Forms Year End Forms table populated by Pre-processing application engine.Used in Insights visualization.

PY_IN_YE_FMS

(SQL Table)

Insights YE Forms

Year End Forms table populated by Pre-processing application engine.Used in Insights visualization.

Related Language Record: PY_IN_YE_FMS_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 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 PY_W2_CMP_DESCR Character(254) VARCHAR2(254) NOT NULL W-2 company description

14 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Payroll Status
A=Active
D=Deceased
L=Leave of Absence
P=Leave With Pay
Q=Retired With Pay
R=Retired
S=Suspended
T=Terminated
U=Terminated With Pay
V=Terminated Pension Pay Out
W=Short Work Break
X=Retired-Pension Administration

15 HR_STATUS Character(1) VARCHAR2(1) NOT NULL HR Status
A=Active
I=Inactive

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

17 PRINT_TYPE Character(1) VARCHAR2(1) NOT NULL Forms Print Type
O=Self-Service Only
P=Paper

18 STATE_DESC Character(250) VARCHAR2(250) NOT NULL State Description

19 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	PY_W2_CMP_DESCR	Character(254)	VARCHAR2(254) NOT NULL	W-2 company description
14	EMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payroll Status A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration
15	HR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	HR Status A=Active I=Inactive
16	TAXFORM_ID_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Taxform ID Description
17	PRINT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Forms Print Type O=Self-Service Only P=Paper
18	STATE_DESC	Character(250)	VARCHAR2(250) NOT NULL	State Description
19	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.