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, entries 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. |
| SITReceiptData | XML version of receipt data stored for reprinting. |