Employee

EmpUID	Employee Unique ID	BigID	12
CompanyID	Company Identifier	SmallID	12
SSN	Social Security Number	Varchar	25
LastName	Last Name	Varchar	80
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 U USA F non-USA
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 M Official/Manager P Professional T Technician S Sales Worker C Office/Clerical R Craft Worker (Skilled) O Operative (Semi-Skilled) L Laborer (Unskilled) W Service Worker
EEO4JobCategory	EEO-4 Job Category	Enum	1		ENUM E Elected/Appointed Official O Official/Administrator P Professional T Technician V Protective Service A Para-Professional S Administrative Support C Skilled Craft M Service/Maintenance
EmpAddr1	Employee Address, Line 1	Varchar	80
EmpAddr2	Employee Address, Line 2	Varchar	80
EmpCity	Employee City	Varchar	80
EmpCntry	Employee Country	Varchar	80
EmpHPhone	Employee Home Phone Number	Varchar	40
EmpI9Date	Employee I9 Date	Date	32
EmpI9Stats	Employee I9 Status	Enum	1		ENUM C Completed N Not Complete
EmpID	Employee Identifier	Varchar	35
EmpState	Employee State Code	Varchar	2
EmpWPhone	Employee Work Phone Number	Varchar	40
EmpZipCode	Employee Zip Code	Varchar	10
EthnicOrg	Ethnic Origin	Enum	1		ENUM C White (Not of Hispanic Origin) A Black (Not of Hispanic Origin) S Asian or Pacific Islander H Hispanic I American Indian or Alaskan Native
HispLatinFlg	Hispanic/Latino Indicator	Varchar	1	Hispanic/Latino flag
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	80
Sex	Sex (M-Male, F-Female)	Enum	1		ENUM M Male F Female
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
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	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
HpOldHireDate	Previous hire date for Hipaa	Date	32
IdChgTS		Timestamp	32
DemChgTS	Demographic changes	Timestamp	32
HpChgTS		Timestamp	32
HireChgTS		Timestamp	32
LstModBy	Last Modified By Name	Varchar	40
LstModDate	Last Modified Date	Date	32
LockSeqNbr	*SYSTEM* Row Sequence Nbr	Long	12