EmployeeImport

Name: Employee Import

Type: Interface

Modules: OPS-Workforce Management

Description: Used to import employee information.

Field Documentation
TransactionDate Date the record was changed in the source system.
TransactionTime Time the record was changed in the source system. Value is in seconds from midnight.
BadgeNum Employee's badge number.
DueDate Effective date of this employee change.
BirthDate Employee's date of birth.
Comments Comments about the record.
DriverLicenceCode Employee's driver's licence code.
DriverLicenceExp Employee's license expiry date.
DriverLicenceNumber Employee's licence number.
EmergencyContact Employee's main emergency contact.
EmergencyContactRel Employee's relationship to the emergency contact.
EmergencyPhone Employee's emergency contact's phone number.
EmployeeCode Unique identifier for an employee.
EmployeePositionAbbr Abbreviation of the employee's position.
EmployeeTypeAbbr Abbreviation of the type of employee.
FirstName Employee's first name.
LastName Employee's last name.
Gender Employee's gender.
HireDate Date when the employee was hired.
MaritalStatus Employee's marital status.
MiddleName Employee's middle name.
NickName Employee's nickname.
Seniority Employee's seniority ranking, which is used in determining bidding order. The lower the number, the higher the ranking.
SeniorityDate Date when the employee is credited for accruing seniority.
SSN Employee's social security number.
StartDate Employee's first day of employment.
EmployeeStatusAbbr Abbreviation of the employee's current status.
StepProgressionDate Employee's step progression date.
TerminationDate Date when the employee was terminated.
Title Employee's title (e.g., 'Mr.', 'Ms.').
VacationGroupAbbr Abbreviation of the employee's vacation group, from VacationGroups.Abbreviation.
VacationSeniority Employee's vacation seniority ranking, which is used to rank employees for vacations. The lower the number, the higher the ranking.
VacationSeniorityDate Date when the employee is credited for accruing vacation seniority.
DivisionAbbr Abbreviation of the employee's division.
PayRate Employee's hourly pay rate.
Violations Import violations (e.g., 'Invalid Hire Date').
DoneFlag If true, the record has been processed and inserted into the database.
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.
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.
UserShort1 Client supplementary data.
UserShort2 Client supplementary data.
UserLongString1 Client supplementary data.
UserLongString2 Client supplementary data.
UserLongString3 Client supplementary data.
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 Employee's number of safe driving awards received.
RedCircleJobClass If true, the employee's job class and pay rate are frozen for a period of time.
JobClassAbbr Abbreviation of the employee's job class.
DriverLicenceState State/province where the employee's driver licence was issued.
CorrectiveLenses Flag that indicates whether the employee uses corrective lenses.
OrgUnitAbbr Abbreviation of the employee's organization unit (if applicable).
NextPhysicalDate Date of the employee's next physical examination.
PinNumber Personal identification number used at Employee Information kiosks.