dbo.GO_Employees View

Description

This Table is required for Paystub only integration.

Properties

Creation Date	7/17/2015 10:23 AM
Is Schema Bound
Encrypted
Ansi Nulls

Columns

Column Name	Description	Datatype	Length
EmployeeID	Stores the unique identifier of a specific employee	char	15
EmployeePartition		varchar	7
Class	Assigned class of the employee	varchar	15
Active	1 if employee is active; 0 otherwise	bit	1
LastName	Employee's last name	varchar	21
FirstName	Employee's first name	varchar	15
MiddleName	Employee's middle name	varchar	15
SuffixName		varchar	5
PrimaryAddressCode	This column relates to AddressCodeID Column in GO_EmployeeAddresses	varchar	15
SocialSecurityNumber	Employee's social security number	varchar	15
BirthDate	Employee's birth date	datetime	4
Gender	Employee gender; options are Male, Female, and Unknown	varchar	6
EthnicOrigin	Employee's ethnic origin Accepted Values: White AmericanIndianOrAlaskan BlackOrAfricanAmerican Asian HispanicOrLatino Mixed NotApplicable PacificIslander	varchar	26
Division	Unique identifier of employee's division	varchar	7
Department	Unique identifier of employee's department	varchar	50
NativeSupervisorID		char	15
Location	the ID of the location in GO_CompanyLocations This column relates to LocationID Column in GO_CompanyLocations	varchar	15
Position	Unique identifier of employee's position	varchar	7
HireDate	Employee's hire date	datetime	4
DateInactivated	Employee's inactive date; only use if employee is no longer active	datetime	4
ReasonEmployeeInactive	Reason the employee is inactive	varchar	31
VacationTimeAvailable		int	4
SickTimeAvailable		int	4
UserDefinedOne		char	21
UserDefinedTwo		char	21
EmploymentType	Employment type, (e.g. Full-Time Regular)	varchar	17
MaritalStatus	Employee's marital status	varchar	7
BenefitAdjustedDate	Used to store a benefits-related date	datetime	4
LastDateWorked	Datetime the employee last worked	datetime	4
SpouseName	Name of the employee's spouse	varchar	15
SpouseSSN	Social Security Number of the employee's spouse	varchar	15
HRStatus	1 if Human Resouces; 0 otherwise	int	4
BenefitExpireDate	Expiration date of the benefits	datetime	4
UnionEmployee		bit	1
LastChangedBy		char	15
LastChangeDate		datetime	4
UnionCode		varchar	7
ActiveEmployeeDirectDeposit	1 if employee uses direct deposit; 0 otherwise	bit	1
WorkHoursPerYear	Number of hours worked per week.	int	4
EmployeeRowID		int	4

Related Objects

dbo Schema
SQL Objects Database