Payroll Master Dependent – Archive (UPRA0111)

Product: Human Resources (414)
Series:

Display Name: Payroll Master Dependent - Archive
Physical Name: UPRA0111
Technical Name: Archive_uprMstrDependent

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	COMMENTSTR20	CommentStr20	String	STR20	20
5	FRSTNAME	First Name	String	STR15	15
6	MIDDLEINITIAL	Middle Initial	String	STR1	1
7	LASTNAME	Last Name	String	STR20	20
8	DEPENDENTSSN	Dependent SSN	String	STR15_Social_Security_Number	15
9	GENDER	Gender	Integer	DDL_Gender	0
10	BRTHDATE	Birth Date	Date	DT	8
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	FLTMSTDNTCB	Full Time Student CB	Boolean	CB	0