ESS Profile Dependents (UPR30603)

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: ESS Profile Dependents
Physical Name: UPR30603
Technical Name: uprESSProfileDependents

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	EMPLOYID	Employee ID	String	STR15_Employee_ID	15
2	SEQNUMBR	Sequence Number	Long Integer	LI_Sequence_Number	10
3	RELATIONSHIP	Relationship	Integer	DDL_Relationship	0
4	FRSTNAME	First Name	String	STR15	15
5	MIDDLEINITIAL	Middle Initial	String	STR1	1
6	LASTNAME	Last Name	String	STR20	20
7	BRTHDATE	Birth Date	Date	DT	8
8	DEPENDENTSSN	Dependent SSN	String	STR15_Social_Security_Number	15
9	GENDER	Gender	Integer	DDL_Gender	0
10	FLTMSTDNTCB	Full Time Student CB	Boolean	CB	0
11	HOMEPHONE	Home Phone	String	STR10_Phone	10
12	WORKPHONE	Work Phone	String	STR10_Phone	10
13	EXTENSION	Extension	String	STR4	4
14	ADDRESS1	Address 1	String	STR60	60
15	ADDRESS2	Address 2	String	STR60	60
16	CITY	City	String	STR35	35
17	STATE	State	String	STR30_State	29
18	ZIPCODE	Zip Code	String	STR10	10
19	HealthInsDependentCov	Health Ins Dependent Coverage	Integer	DDL_Health_Ins_Dependent_Coverage	0
20	Effective_Date	Effective Date	Date	DT	8