OpsBlockActivityLog
Name: OPS Block Activity Log
Type: Log
Modules: OPS-Dispatch, OPS-Yard
Description: Contains block activity log entries.
| Field | Documentation |
|---|---|
| BlockLogId | Unique identifier for a block activity log. |
| DailyBlockId | Daily block identifier from DailyBlocks.DailyBlockId. References the associated daily block. |
| Sequence | Unique sequential identifier given to logs with the same DailyBlockId, SchId and EvStrId. |
| VehicleId | Vehicle identifier from Vehicles.VehicleId. References the associated vehicle. |
| Activity | Activity that was logged (1 = Assign Vehicle, 2 = Unassign Vehicle, 3 = Split Block, 4 = Vehicle Change-Out, 5 = Undo Vehicle Change-Out, 6 = Cancel Block, 7 = Undo Cancel Block, 8 = Undo Split Block, 9 = Pull In, 10 = Pull Out). |
| AssociateDailyBlockId | Daily block identifier from DailyBlocks.DailyBlockId. References the new block which was split from the original. |
| AssociateSequence | Sequence number of the newly-split daily block. |
| 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. |
| ModAction | Last action performed on the record. |