DailyBlocks
Name: Daily Blocks
Type: Application
Modules: OPS-Dispatch, OPS-Yard
Description: Contains vehicle blocks and assignments information.
| Field | Documentation |
|---|---|
| DailyBlockId | Unique identifier for a daily block. |
| SignId | Signup period identifier from OPSSignUpPeriods.SignId. References the signup period associated with the block. |
| LineGroupId | Line group identifier from LineGroup.LineGroupId. References the line group associated with the block. |
| BlockNum | Number of the block. |
| DivisionId | Division identifier from MasterDivisions.DivisionID. References the division associated with the block. |
| ServiceGroupId | Service group identifier from ServiceGroup.ServiceID. References the service group associated with the block. |
| LDate | Date on which the record is valid. |
| BusTypeId | Bus type identifier from BusTypes.BusTypeId. References the associated bus type. |
| VehicleId | Vehicle identifier from Vehicles.VehicleId. References the associated vehicle. |
| FromTime | Start time of the validity period. Value is in seconds from midnight. |
| ToTime | End time of the validity period. Value is in seconds from midnight. |
| FromLocation | Description of the originating location. |
| ToLocation | Description of the destination location. |
| BlockMileage | Total calculated mileage, in meters, of all the trips in the block. |
| Comments | Comments about the record. |
| WorkId | Work identifier from TkWork.WorkId. References the associated work. |
| PieceNum | Sequential number of the associated piece of work. |
| SplitNum | Sequential number of the associated split piece of work. |
| DefaultVehicleId | Vehicle identifier from Vehicles.VehicleId. References the default vehicle. |
| TimeSort | Usually contains the same value as the associated sign-on time. Value is in seconds from midnight. |
| GarageId | Garage identifier from Garages.GarageId. References the associated garage. |
| ParkingLayoutId | Parking layout identifier from ParkingLayouts.ParkingLayoutId. References the associated parking layout. |
| FirstRevenueNodeId | First non-garage node of the first trip of the block. |
| LastRevenueNodeId | Last non-garage node of the first trip of the block. |
| FirstRevenueTime | Time when the first non-garage node of the first trip of the block. Value is in seconds from midnight. |
| LastRevenueTime | Time when the last non-garage node of the first trip of the block. 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. |
| ActualFromTime | Actual start time. Value is in seconds from midnight. |
| ActualToTime | Actual end time. Value is in seconds from midnight. |
| BlockName.DailyBlocks | Name of the block. |
| Flag | If true, block contains a comment. |
| 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. |
| VehicleAssignTypeId | Indicates the method of vehicle assignment (0 = None, 1 = Manual, 2 = Default, 3 = AutoAssign). |
| UserLong14 | Client supplementary data. |
| UserLong15 | Client supplementary data. |
| UserString30 | Client supplementary data. |
| UserLongString30 | Client supplementary data. |
| UserShort10 | Client supplementary data. |
| ReasonId | Reason identifier from OpsDispatchReason.ReasonId. References the reason for any cancelled service. |
| ITSPullinFlag | If true, the vehicle has pulled in for service. |
| ITSPulloutFlag | If true, the vehicle has pulled out for service. |
| UserLong2 | Client supplementary data. |
| UserLong1 | Client supplementary data. |
| UserString2 | Client supplementary data. |
| UserString1 | Client supplementary data. |
| ModAction | Last action performed on the record. |
| HaveCanceledTrips | If true, the block contains cancelled trips. |
| NonRevenueMileage | Total calculated mileage, in meters, of all the non-revenue trips in the block between non-garage to garage nodes. |
| RevenueMileage | Total calculated mileage, in meters, of all the revenue trips in the block between non-garage to non-garage nodes. |
| NonRevenueTime | Total calculated time, in seconds, of all the non-revenue trips in the block between non-garage to garage nodes. |
| RevenueTime | Total calculated time, in seconds, of all the revenue trips in the block between non-garage to non-garage nodes. |
| ActNonRevenueMileage | Total actual mileage, in meters, of all the non-revenue trips in the block between non-garage to garage nodes. |
| ActRevenueMileage | Total actual mileage, in meters, of all the revenue trips in the block between non-garage to non-garage nodes. |
| ActNonRevenueTime | Total actual time, in seconds, of all the non-revenue trips in the block between non-garage to garage nodes. |
| ActRevenueTime | Total actual time, in seconds, of all the revenue trips in the block between non-garage to non-garage nodes. |
| StartTimeStamp | Time when the operator's work starts. |
| EndTimeStamp | Time when the operator's work ends. |
| BlockId | Unique identifier for a block. |
| BlockVersionId | The block version identifier. |
| TimeIsPrevDay | Whether the block's pull out time is from yesterday. |
| LineList | List of lines in the block. |
| SourceDailyBlockId | The identifier for the original block. This is useful is the block is split. |