EmpDepnd

EmpUID	Employee Unique ID	BigID	12
DepndID	Dependent Identifier	BigID	12
CompanyID	Company Identifier	SmallID	12
ExtDepndID	Unique dependent ID for external use	Varchar	40
Address1	Address, Line 1	Varchar	80
Address2	Address, Line 2	Varchar	80
City	City	Varchar	80
State	State Code	Varchar	2
ZipCode	Zip Code	Varchar	10
Country	Country	Varchar	80
AIStatus	Active/Inactive Status	Enum	1		ENUM A Active I Inactive E Eligible X Ineligible
BirthDate	Date of Birth	Date	32
DepndSSN	Dependent Soc Sec Nbr	Varchar	11
DepndType	Dependent Type	Enum	1		ENUM S Spouse E Ex-Spouse C Child P Domestic Partner O Other
FirstName	First Name	Varchar	80
LastName	Last Name	Varchar	80
MiddleName	Middle Name	Varchar	40
PhoneNbr	Phone Number	Varchar	40
SameResdnc	Same Residence as Employee	Varchar	1
Sex	Sex (M-Male, F-Female)	Enum	1		ENUM M Male F Female
SmokerFlag	Smoker (Y-Yes, N-No)	Varchar	1
StudentFlg	Student (Y-Yes, N-No)	Varchar	1
Disabled	Disabled Status Flag	Varchar	1
HpOldSSN	Social Security Number	Varchar	25
HpOldLastName	Last Name	Varchar	80
HpOldFirstName	First Name	Varchar	80
HpOldMiddleName	Middle Name	Varchar	80
HpOldBirthDate	Date of Birth	Date	32
HpOldSex	Sex (M-Male, F-Female)	Enum	1		ENUM M Male F Female
IdChgTS		Timestamp	32
DemChgTS	Demographic changes	Timestamp	32
HpChgTS		Timestamp	32
LstModBy	Last Modified By Name	Varchar	40
LstModDate	Last Modified Date	Date	32
LockSeqNbr	*SYSTEM* Row Sequence Nbr	Long	12