W3EB_SMRY_PERS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
4	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
5	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
6	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
7	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
8	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
9	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
10	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
11	ADDRESS1_2	Character(55)	VARCHAR2(55) NOT NULL	Address Line 1
12	CITY2	Character(30)	VARCHAR2(30) NOT NULL	City
13	STATE2	Character(6)	VARCHAR2(6) NOT NULL	State
14	POSTAL2	Character(12)	VARCHAR2(12) NOT NULL	Postal Code
15	PHONE1	Character(24)	VARCHAR2(24) NOT NULL	Phone number field for discounts and perks eligibility file.
16	PHONE2	Character(24)	VARCHAR2(24) NOT NULL	Phone number field for discounts and perks eligibility file.
17	CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	Contact Name
18	RELATIONSHIP_DESC	Character(10)	VARCHAR2(10) NOT NULL	Relationship Description