OpsDailyActivityLog
Name: OPS Daily Activity Log
Type: Log
Modules: OPS-Bidding, OPS-Employee, OPS-Dispatch, OPS-SIT
Description: Contains daily activity log entries.
| Field | Documentation |
|---|---|
| WorkId | Work identifier from TkWork.WorkId. References the associated work. |
| PieceNum | Sequential number of the associated piece of work. |
| Sequence | Priority number used for ordering data query records. |
| AssignListId | Indicates the specific ExtraBoard or Volunteer list from which the assignment was made. |
| AssignTypeId | Custom assignment type identifier from OpsCustomAssignmentTypes.AssignTypeId. References the associated custom assignment type. |
| EmployeeId | Employee identifier from Employees.EmployeeId. References the associated employee. |
| 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. |
| EvStrId | Event string identifier from EventStrings.EvStrId. References the associated event string. |
| SchId | Schedule identifier from Schedules.SchId. References the associated schedule. |
| Activity | Activity that was logged (1 = Assigned, 2 = Unassigned, 3 = Cancel Service, 4 = Resume Service, 5 = Suggest Employee, 6 = Restore Run, 7 = Suggest Work, 8 = Cancel Work, 9 = Resume Trips, 10 = Edit Work Time, 11 = Split Run, 12 = Unsplit Run). |
| PieceName | Name of the associated piece of work. |
| RespondDate | Date the response was received. |
| RespondTime | Time the response was received. Value is in seconds from midnight. |
| StatusId | Status of the response (0 = None, 1 = Waiting For Response, 2 = Accept, 3 = Refused, 4 = No Answer, 5 = Left Message, 6 = Unable to Send Message, 7 = Offer Work Expired, 8 = Unavailable, 10 = Revoke). |
| Comments | Comments about the record. |
| ContactId | Identifies the method used to contact the employee if the activity logged was 'Suggest Work' (1 = Verbal, 2 = Telephone, 3 = Radio, 4 = In-vehicle Message). |
| ModAction | Last action performed on the record. |
| RefusalId | Refusal identifier from OPSWorkRefusalLog.RefusalId. References the associated refusal. |