ESS Profile Personal (UPR30601)

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: ESS Profile Personal
Physical Name: UPR30601
Technical Name: uprESSProfilePersonal

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	EMPLOYID	Employee ID	String	STR15_Employee_ID	15
2	FRSTNAME	First Name	String	STR15	15
3	MIDLNAME	Middle Name	String	STR15	15
4	LASTNAME	Last Name	String	STR20	20
5	EMPLSUFF	Employee Suffix	String	STR4_Employee_Suffix	4
6	NICKNAME	NickName	String	STR20	20
7	SOCSCNUM	Social Security Number	String	STR15_Social_Security_Number	15
8	STRTDATE	Start Date	Date	DT	8
9	BRTHDATE	Birth Date	Date	DT	8
10	GENDER	Gender	Integer	DDL_Gender	0
11	ETHNORGN	Ethnic Origin	Integer	DDL_Ethnic Origin	0
12	MARITALSTATUS	MaritalStatus	Integer	DDL_MaritalStatus	0
13	SPOUSE	Spouse	String	STR15	15
14	PHONE1	Phone 1	String	Phone_Number	14
15	PHONE2	Phone 2	String	Phone_Number	14
16	PHONE3	Phone 3	String	Phone_Number3	14
17	FAX	Fax	String	STR14_FAX	14
18	INET1	INet1	String	STR200	200
19	Messenger_Address	Messenger Address	String	STR200	200
20	ADRSCODE	Address Code	String	STR15_Address_Code	15
21	ADDRESS1	Address 1	String	STR60	60
22	ADDRESS2	Address 2	String	STR60	60
23	ADDRESS3	Address 3	String	STR60	60
24	CITY	City	String	STR35	35
25	STATE	State	String	STR30_State	29
26	ZIPCODE	Zip Code	String	STR10	10
27	COUNTY	County	String	STR60	60
28	COUNTRY	Country	String	STR60	60
29	EmailToAddress	Email To Address	Text	TX32000	32000