Employees

Name: Employees

Type: Ancillary

Modules: OPS-Bidding, OPS-Employee Profile, OPS-Dispatch, OPS-Timekeeping, OPS-Yard, OPS-Workforce Management, OPS-SIT, OPS-Web (Bidding)

Description: Contains employee information.

Field Documentation
EmployeeTypeId Employee type identifier from EmployeeTypes.EmployeeTypeId. References the employee type associated with an employee.
EmployeeId Unique identifier for an employee. Usually set to be the badge number.
EmployeeCode Unique identifier of employees. Typically the payroll number.
BadgeNum Employee's badge number.
SupNumber Supervisor number.
Title Employee's title (e.g., Mr., Ms.).
LastName Employee's last name.
FirstName Employee's first name.
MiddleName Employee's middle name.
NickName Employee's nick name.
FullName Employee's full name.
Gender Employee's gender.
MaritalStatus Employee's marital status.
EmergencyContact Name of the employee's emergency contact.
EmergencyContactRel Relationship of the emergency contact to the employee (e.g., Friend, Wife).
EmergencyPhone Employee's emergency contact's phone number.
DriverLicenceNumber Employee's driver's license number.
DriverLicenceExp Date when the employee's driver's license expires.
DriverLicenceCode Employee's driver's license type/grade.
SSN Employee's social security number.
Status Employee's status.
BirthDate Employee's birth date.
HireDate Date when the employee was hired.
StartDate The employee's first work day.
SeniorityDate Date when the employee is credited for accruing seniority.
TerminationDate Date when the employee was terminated.
SuspFromDate Start date of the employee's suspension.
SuspToDate End date of the employee's suspension.
LastPhysicalDate Date of the employee's last physical examination.
NextPhysicalDate Date of the employee's next physical examination.
LastDrugTestDate Date of the employee's last drug test.
Comments Comments about the record.
Priority Deprecated.
Certifications Contains the employee's certifications.
Seniority Employee's seniority ranking which is used in determining bidding order. The lower the number, the higher the ranking.
VacationSeniorityDate Date when the employee is credited for accruing vacation seniority.
VacationSeniority Employee's vacation seniority ranking which is to rank employees for vacations. The lower the number, the higher the ranking.
UserString1 Client supplementary data.
UserString2 Client supplementary data.
UserString3 Client supplementary data.
UserString4 Client supplementary data.
UserString5 Client supplementary data.
UserString6 Client supplementary data.
UserString7 Client supplementary data.
UserString8 Client supplementary data.
UserString9 Client supplementary data.
UserString10 Client supplementary data.
UserString11 Client supplementary data.
UserString12 Client supplementary data.
UserString13 Client supplementary data.
UserString14 Client supplementary data.
UserString15 Client supplementary data.
UserString16 Client supplementary data.
UserString17 Client supplementary data.
UserString18 Client supplementary data.
UserString19 Client supplementary data.
UserString20 Client supplementary data.
UserString21 Client supplementary data.
UserString22 Client supplementary data.
UserString23 Client supplementary data.
UserString24 Client supplementary data.
UserString25 Client supplementary data.
UserLong1 Client supplementary data.
UserLong2 Client supplementary data.
UserLong3 Client supplementary data.
UserLong4 Client supplementary data.
UserLong5 Client supplementary data.
UserLong6 Client supplementary data.
UserLong7 Client supplementary data.
UserShort1 Client supplementary data.
UserShort2 Client supplementary data.
DrugTestResults Employee's last drug test results.
ProviderId Provider identifier from Providers.ProviderId. References the associated provider.
EmployeePositionAbbr Abbreviation of the employee's position.
StepProgressionDate Date when pay rates begin.
VacationGroupId Vacation group identifier from VacationGroups.VacationGroupId. References the employee's vacation group.
LongevityDate Date used for determining pay rates where HireDate and StartDate apply to the current position.
SmartCardId Smart card identification number.
TitleId Title identifier from Titles.TitleId. References the employee's title.
PinNumber Personal identification number used at employee information kiosks.
VTTDate Employee's vehicle transit training expiration date.
MedicalDate Employee's medical expiration date.
AwardEligibilityDate Employee's safe driving eligibility date.
SafeDrivingStartDate Date when the employee started the safe driving program.
LastAwardDate Date when the employee last received a safe driving award.
NumberOfAwards Number of safe driving awards the emloyee has received.
MobilePhone Employee's mobile phone number.
EmployeeRun Used for PASS.
SpeedFactor Used for PASS.
DriverLicenceState The state/province where the employee's driver's license was issued.
InActive Flag that indicates whether the employee is inactive.
NextReviewDate The date of the employee's next review.
UserLongString1 Client supplementary data.
UserLongString2 Client supplementary data.
UserLongString3 Client supplementary data.
Documentation Indicates whether the employee must provide documentation when returning to work from an absence.
DefaultSpaceType Employee's default space type.
UserLong8 Client supplementary data.
UserLong9 Client supplementary data.
UserLong10 Client supplementary data.
UserLong11 Client supplementary data.
UserLong12 Client supplementary data.
UserLong13 Client supplementary data.
UserLong14 Client supplementary data.
UserLong15 Client supplementary data.
UserLong16 Client supplementary data.
UserLong17 Client supplementary data.
UserLong18 Client supplementary data.
UserLong19 Client supplementary data.
UserLong20 Client supplementary data.
UserLong21 Client supplementary data.
UserLong22 Client supplementary data.
UserLong23 Client supplementary data.
UserLong24 Client supplementary data.
UserLong25 Client supplementary data.
UserLong26 Client supplementary data.
UserLong27 Client supplementary data.
UserLong28 Client supplementary data.
UserLong29 Client supplementary data.
UserLong30 Client supplementary data.
UserLong31 Client supplementary data.
UserLong32 Client supplementary data.
UserLong33 Client supplementary data.
UserLong34 Client supplementary data.
UserLong35 Client supplementary data.
UserLong36 Client supplementary data.
FileGroupId File group identifier from FileGroups.FileGroupId. References the associated file group.
Supervisor If true, the employee is a supervisor.
Assist Used for PASS.
ModBy User who last modified the record.
ModDate Date the record was last modified.
ModTime Time the record was last modified. Value is in seconds from midnight.
ModAction Last action performed on the record.
AwardCreditDays Number of credit days to award.
CorrectiveLenses If true, the employee uses corrective lenses.
EMailAddress Email address of the employee.
RestrictedAccessAllowed List of allowable restricted locations to which the employee can go.