OpsSignInLog

Name: OPS Sign-in Log

Type: Ancillary

Modules: OPS-Dispatch, OPS-SIT

Description: Contains employee sign-in/sign-off activities.

Field Documentation
KioskName Kiosk name identifier from OPSSIT.KioskName. References the associated kiosk.
EmployeeId Employee identifier from Employees.EmployeeId. References the associated employee.
WorkId Work identifier from TkWork.WorkId. References the associated work.
PieceNum Sequential number of the associated piece of work.
VehicleId Vehicle identifier from Vehicles.VehicleId. References the associated vehicle.
TransactionDate Date the transaction occurred.
TransactionTime Time the transaction occurred. Value is in seconds from midnight.
Success If true, the sign-in/sign-off was successful.
Violations Violations that may have occurred when signing in (e.g., 'Already signed in').
Comments Comments about the record.
Status Status of the transaction (values from -1-12 are for Sign-in, entires from 20-29 are for Sign-off; -1 = None, 0 = Success, 1 = Too Early, 2 = Not Signed In Yet, 3 = Too Late, 4 = Disabled, 5 = Sign-in By Daily Activity, 6 = Undone By Daily Activity, 7 = System Error, 8 = Already done, 9 = Work Not Found, 10 = Wrong Division, 11 = Wrong Garage, 12 = Invalid Card, 20 = Success, 21 = Too Early, 22 = Not Signed In Yet, 23 = Too Late, 24 = Disabled, 25 = Sign-off by Daily Activity, 26 = Undone By Daily Activity, 28 = Already Done, 29 = Second Login/Logout Timeout.
AudibleSound If true, a sound is played during the transaction.
SchId Schedule identifier from Schedules.SchId. References the associated schedule.
EvStrId Event string identifier from EventStrings.EvStrId. References the associated event string.
ReasonId Reason identifier from OpsDispatchReason.ReasonId. References the associated cancelled work reason.
ParkingInfo Parking information of the vehicle as of the Transaction Time (GarageAbbr, ParkingDescription).
UserName The name of the user whom performed the sign-on or sign-off action.