PY_1042S_YE_EE (SQL Table)	Index Back
1042S Year End Employee Info 1042S Year End Process - Employee Information

PY_1042S_YE_EE

(SQL Table)

1042S Year End Employee Info

1042S Year End Process - Employee Information

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TAX_YEAR Signed Number(5,0) DECIMAL(4) NOT NULL Tax Year

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

3 PY_EE_SEQ_NO Number(2,0) SMALLINT NOT NULL 1042S Employee Information Sequence No

4 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country

5 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1

6 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2

7 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3

8 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4

9 CITY Character(30) VARCHAR2(30) NOT NULL City

10 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: STATE_TBL

11 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

12 COUNTRY_CD_1042 Character(2) VARCHAR2(2) NOT NULL Country Code for 1042

13 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

14 TAXPAYER_ID_NO Character(9) VARCHAR2(9) NOT NULL Taxpayer ID Number

15 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID

16 LAST_UPDT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Updated User Name

17 LAST_UPDATE_DTTM 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	TAX_YEAR	Signed Number(5,0)	DECIMAL(4) NOT NULL	Tax Year
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	PY_EE_SEQ_NO	Number(2,0)	SMALLINT NOT NULL	1042S Employee Information Sequence No
4	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
5	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
6	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
7	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
8	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
9	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
10	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
11	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
12	COUNTRY_CD_1042	Character(2)	VARCHAR2(2) NOT NULL	Country Code for 1042
13	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
14	TAXPAYER_ID_NO	Character(9)	VARCHAR2(9) NOT NULL	Taxpayer ID Number
15	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
16	LAST_UPDT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Updated User Name
17	LAST_UPDATE_DTTM	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.