FxBlocks
Name: Fx Blocks
Type: Application
Modules: Exchange-ImportLib, Fx-SharedLib, Fx-TpsTransXChange, Legacy-Fx, Legacy-OPS, OPS-Lib, OPS-Report, Pass-Lib, Pass-PassSchedule
Description: Master list of all blocks. A block is a collection of trips to be performed by one vehicle.
| Field | Documentation |
|---|---|
| SignId | Sign-up period identifier from SignUpPeriods.SignId. |
| ServiceGroupId | Service group identifier from MasterServiceGroup.ServiceGroupId. |
| LineGroupId | Line group identifier from MasterLineGroup.LineGroupId. |
| BlockId | Unique identifier of a block. |
| BlockNum | Identifier of a block that is unique within a line group, service group, sign up period combination. |
| BlockName | Name assigned to the block by the user. |
| BusTypeId | Vehicle type identifier from BusTypes.BusTypeId. |
| BlockGroupId | Block group identifier from FxBlockGroups.BlockGroupId |
| NeedsFueling | If the refueling feature is used, and this is true, a vehicle must be refueled to complete this block. |
| DivisionId | Division identifier from MasterDivisions.DivisionId. |
| UserLong1 | User-defined supplementary data. |
| UserLong2 | User-defined supplementary data. |
FxBlockScenarioBlockEvents
| Field | Documentation |
|---|---|
| ScenarioId | Unique identifier of a block scenario. |
| BlockId | Block identifier from FxBlocks.BlockId |
| ExcComboId | Exception combination identifier from MasterExceptionCombinations.ExcComboId |
| EventType | Event Type: 1 = Garage Pullout, 2 = Garage Pullin, 15 = Pullout End, 16 = Pullout Start, 17 = Interline Start, 18 = Interline End. |
| EventTime | Time when the event takes place. |
| NodeId | Node identifier from Nodes.NodeId. |
| CommentId | Comment identifier from Comments.CommentId. |
| Distance | Length of a deadhead in meters. |
| FromTripId | Start trip identifier from Trips.TripId. |
| ToTripId | End trip identifier from Trips.TripId. |
| Sequence | Order of multiple deadheads between trips. |
| IsRelief | If true, the block event is a relief point. |
FxBlockScenarioBlocks
| Field | Documentation |
|---|---|
| ScenarioId | Unique identifier of a block scenario. |
| BlockId | Block identifier from FxBlocks.BlockId. |
| LineGroupId | Line group identifier from MasterLineGroup.LineGroupId. |
| BlockNum | Identifier of a block that is unique within a line group, service group, sign up period combination. |
| BlockName | Name assigned to the block by the user. |
| BusTypeId | Vehicle type identifier from BusTypes.BusTypeId. |
| BlockGroupId | Block group identifier from FxBlockGroups.BlockGroupId. |
| BlockGroupName | Full name of the block group. |
FxBlockScenarios
| Field | Documentation |
|---|---|
| ScenarioId | Unique identifier of a block scenario. |
| SignId | Sign-up period identifier from SignUpPeriods.SignId. |
| ServiceGroupId | Service group identifier from MasterServiceGroup.ServiceGroupId |
| DivisionId | Division identifier from MasterDivisions.DivisionId. |
| LineGroupId | Line group identifier from MasterLineGroup.LineGroupId. |
| ScenarioName | Name of the roster scenario. |
| ScenarioComments | Comments about the roster scenario. |
| DateSaved | Date when the file was saved. |
| TimeSaved | Time when the file was saved. |
| NumTrips | Number of trips in the block scenario. |
| RevenueTime | Total calculated time of all the revenue trips in the block between non-garage to non-garage nodes (in seconds). |
| NonRevenueTime | Total calculated time of all the non-revenue trips in the block between non-garage to garage nodes (in seconds). |
| Layover | Deprecated. |
| DeadheadTime | Total deadhead time for a block scenario. (This is filled infor Trapeze4 block scenarios, but not Blockbuster block scenarios.) |
| NumBlocks | Number of blocks in the block scenario. |
| NumBlockedTrips | Number of blocked trips in the block scenario. (This is filled in for Blockbuster block scenarios only.) |
| InterlineDeadheadTime | This is filled in for Blockbuster block scenarios, but not Trapeze4 block scenarios.) |
| GarageDeadheadTime | Total garage deadhead time for a block scenario. (This is filled in for Blockbuster block scenarios, but not Trapeze4 block scenarios.) |
| PVR | Peak vehicle requirements for a block scenario. (This is filled in for Blockbuster block scenarios, but not Trapeze4 block scenarios.) |
| MaxBlockLength | The longest block for a block scenario. (This is filled in for Blockbuster block scenarios, but not Trapeze4 block scenarios.) |
| AverageBlockLength | The average block length for a block scenario. (This is filled in for Blockbuster block scenarios, but not Trapeze4 block scenarios.) |
| Favorite | Designated by the user as the favorite scenario. |
FxBlockScenarioTripDetails
| Field | Documentation |
|---|---|
| ScenarioId | Unique identifier of a block scenario. |
| Sequence | Combined with ScenarioId, provides a unqiue identifier for this table. |
| DeadheadType | Indicates whether the deadhead is a garage or interline deadhead. Value: 0 = interline, 1 = pull out, 2 = pull in. |
| TripId | Unique identifier of a trip. |
| DivisionId | Division identifier from MasterDivisions.DivisionId. |
| BlockId | Unique identifier of a block. |
| PulloutTime | Block pull-out time. |
| PullinTime | Block pull-in tIme. |
| PulloutGarageId | Identifier of pull-out garage from Garages.GarageId. |
| PullinGarageId | Identifier of pull-in garage from Garages.GarageId. |
| VehicleBlockNum | Vehicle block number that the trip belongs to. |
| MinLayover | Minimum layover time in seconds required at the end of a trip. |
| MaxLayover | Maximum layover time in seconds allowed at the end of a trip. |
| DeadheadSequence | Order of multiple deadheads between trips. |
| BlockName | Name assigned to the block by the user. |
| NeedsFueling | If the refueling feature is used, and this is true, a vehicle must be refueled to complete this block. |
| ExcComboId | Exception combination identifier from MasterExceptionCombinations.ExcComboId. |
| BlockGroupId | Unique identifier of a block group. |
| BlockGroupName | Full name of the block group. |
| BusTypeId | Bus type identifier from BusTypes.BusTypeId. |
| IsStartRelief | Indicates whether the start of the deadhead is a potential relief point. |
| IsEndRelief | Indicates whether the end of the deadhead is a potential relief point. |
| LineAbbr | Abbreviated name of the line. |
| DirNum | Number of the line direction. This number is unique within a specific line. |
| FromTime | From Time for Consists. |
| ToTime | To Time for Consists. |
| Pattern | Full name of pattern. |
| FromTripId | Start trip identifier from Trips.TripId. |
| ToTripId | End trip identifier from Trips.TripId. |
| FromNodeId | First node block operate |
| ToNodeId | Last node block operate |
| BlockNum | Identifier of a block that is unique within a line group, service group, sign up period combination. |
FxBlockScenarioTrips
| Field | Documentation |
|---|---|
| ScenarioId | Unique identifier of a block scenario. |
| LineGroupId | Line group identifier from MasterLineGroup.LineGroupId. |
| BlockNum | Identifier of a block that is unique within a line group, service group, sign up period combination. |
| BlockName | Name assigned to the block by the user. |
| BlockId | Unique identifier of a block. |
| TripId | Unique identifier of a trip. |
| UseDriverBlocks | If true, driver blocks are used. |
| VehicleBlockNum | Vehicle block number that the trip belongs to. |