Employee

CompanyID	Company Identifier	SmallID	12
EmpUID	Employee Unique ID	BigID	12
SSN	Social Security Number	Varchar	25
LastName	Last Name	Varchar	40
FirstName	First Name	Varchar	80
MiddleName	Middle Name	Varchar	40
Email	Email Address	Varchar	80
Email2	Email Address 2	Varchar	80
EssFirstLogin	First login or re-authentication (Y/N)	Varchar	1
AdrChgDate	Last Address Change Date	Date	32
EssAllowed	Is this employee allowed to access ESS?	Varchar	1
ArchiveFlg	Employee Archive Flag	Varchar	1
BirthDate	Date of Birth	Date	32
Citizenshp	Citizenship	Enum	1		Enum
UserPID	User Personal Login ID	Varchar	80
UserPwd	User Password	Varchar	40
Disabled	Disabled Status Flag	Varchar	1
DisabledVt	Disabled Veteran Flag	Varchar	1
OtherVet	Y/N	Varchar	1
EEOStatus	EEO Status?	Enum	1		Enum
EEO4JobCategory	EEO-4 Job Category	Enum	1		Enum
EmpAddr1	Employee Address, Line 1	Varchar	80
EmpAddr2	Employee Address, Line 2	Varchar	80
EmpCity	Employee City	Varchar	80
EmpCntry	Employee Country	Varchar	20
EmpGCstF1	Employee General Custom Fld 1	Varchar	40
EmpHPhone	Employee Home Phone Number	Varchar	40
EmpI9Date	Employee I9 Date	Date	32
EmpI9Stats	Employee I9 Status	Enum	1		Enum
EmpID	Employee Identifier	Varchar	35
EmpState	Employee State Code	Varchar	2
EmpW4Stats	Employee W4 Status	Enum	1		Enum
EmpWPhone	Employee Work Phone Number	Varchar	40
EmpZipCode	Employee Zip Code	Varchar	10
EthnicOrg	Ethnic Origin	Enum	1		Enum
HispLatinFlg	Hispanic/Latino Indicator	Varchar	1	Hispanic/Latino flag
FilStatus	Filing Status	Enum	1		Enum
GenCodeID	Generic Code Identifier	BigID	12
HireDate	Hire Date	Date	32
MarStatus	Marital Status	Enum	1		Enum
PreviousName	Usually MaidenName	Varchar	80
NickName	Nick Name	Varchar	40
NbrExempt	Number of Exemptions	Long	12
Sex	Sex (M-Male, F-Female)	Enum	1		Enum
SmokerFlag	Smoker (Y-Yes, N-No)	Varchar	1
SuperVFlg	Supervisor Flag	Varchar	1
SuperVEmpUID	Supervisors EmpUID	BigID	12
TermDate	Termination Date	Date	32
UnionBargU	Union Bargin Unit (Gen Code)	BigID	12
Veteran	Veteran Flag	Varchar	1
VietnamVet	Vietnam Veteran Flag	Varchar	1
ActDutyRelDate	Active Duty Release Date	Date	32
AdjSenDate	Adjusted seniority date	Date	32
Rehire	0-no, 1-yes	Varchar	1
W4Exempt	W4 Exemption Status	Enum	1		Enum
TermType	from Categories	Varchar	40
TermReason	from Categories	Varchar	40
VisaType	Type of Visa	Varchar	80
VisaNumber	Visa Number	Varchar	40
VisaExpires	Expiration Date for Visa	Date	32
EssLck	Ess is locked for this user	Varchar	1
EssLckSince	Ess has been locked out for this user since (date)	Timestamp	32
HpOldSSN	Social Security Number	Varchar	25
HpOldLastName	Last Name	Varchar	40
HpOldFirstName	First Name	Varchar	80
HpOldMiddleName	Middle Name	Varchar	40
HpOldBirthDate	Date of Birth	Date	32
HpOldSex	Sex (M-Male, F-Female)	Enum	1		Enum
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