PY_IN_YE_W2_AMT (SQL Table)	Index Back
Insights W-2 Amounts This record contains the amounts used on the W-2.

PY_IN_YE_W2_AMT

(SQL Table)

Insights W-2 Amounts

This record contains the amounts used on the W-2.

Related Language Record: PY_IN_YE_AMT_LN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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 SEQUENCE_NUMBER Number(2,0) SMALLINT NOT NULL Sequence Number

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

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

8 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality

9 WORK_PSD_CD Character(6) VARCHAR2(6) NOT NULL Locality

10 RES_PSD_CD Character(6) VARCHAR2(6) NOT NULL Locality

11 W2_AMOUNT Signed Number(15,2) DECIMAL(13,2) NOT NULL W-2 Amount

12 W2_REPORTING_CO Character(3) VARCHAR2(3) NOT NULL W-2 Reporting Company

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 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

17 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

18 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

19 PY_DEPT_DESCR Character(100) VARCHAR2(100) NOT NULL Department description

20 PY_PAYGROUP_DESCR Character(100) VARCHAR2(100) NOT NULL Paygroup Description

21 PY_COMPANY_DESCR Character(100) VARCHAR2(100) NOT NULL Company description

22 PY_BUS_DESCR Character(100) VARCHAR2(100) NOT NULL Business Unit description

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

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

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

26 EMPL_ST_DESCR Character(100) VARCHAR2(100) NOT NULL Employee Status Description

27 HR_STATUS_DSC Character(100) VARCHAR2(100) NOT NULL HR Status Description

28 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	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
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	SEQUENCE_NUMBER	Number(2,0)	SMALLINT NOT NULL	Sequence Number
6	BOX	Character(4)	VARCHAR2(4) NOT NULL	Box
7	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
8	LOCALITY	Character(10)	VARCHAR2(10) NOT NULL	Locality
9	WORK_PSD_CD	Character(6)	VARCHAR2(6) NOT NULL	Locality
10	RES_PSD_CD	Character(6)	VARCHAR2(6) NOT NULL	Locality
11	W2_AMOUNT	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	W-2 Amount
12	W2_REPORTING_CO	Character(3)	VARCHAR2(3) NOT NULL	W-2 Reporting Company
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	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
17	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
18	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
19	PY_DEPT_DESCR	Character(100)	VARCHAR2(100) NOT NULL	Department description
20	PY_PAYGROUP_DESCR	Character(100)	VARCHAR2(100) NOT NULL	Paygroup Description
21	PY_COMPANY_DESCR	Character(100)	VARCHAR2(100) NOT NULL	Company description
22	PY_BUS_DESCR	Character(100)	VARCHAR2(100) NOT NULL	Business Unit description
23	TAXFORM_ID_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Taxform ID Description
24	PRINT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Forms Print Type O=Self-Service Only P=Paper
25	STATE_DESC	Character(250)	VARCHAR2(250) NOT NULL	State Description
26	EMPL_ST_DESCR	Character(100)	VARCHAR2(100) NOT NULL	Employee Status Description
27	HR_STATUS_DSC	Character(100)	VARCHAR2(100) NOT NULL	HR Status Description
28	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.