Segments

Internal Table Name: VRPOutputSegments

The Segments table provides information about each leg between an origin and destination on the vehicle routes generated by Transportation Optimization.

Scenario

Table: VRPOutputSegments

Internal Name: Not Applicable (Scenario column not in table)

The scenario for which the output data was generated.

Route ID

Table: VRPOutputSegments

Internal Name: RouteID

The identifier of the route (from the Route table) on which the segment is located.

Start Date Time

Table: VRPOutputSegments

Internal Name: StartDateTime

The start date and time at the first stop on the segment.

End Date Time

Table: VRPOutputSegments

Internal Name: EndDateTime

The end date and time at the last stop on the segment.

Distance

Table: VRPOutputSegments

Internal Name: Distance

The distance from the first stop to the last stop on the segment.

Drive Time

Table: VRPOutputSegments

Internal Name: OperatingTime

The total time from the first stop to the last stop on the segment (drive time plus any handling time).

Start Date Time Local

Table: VRPOutputSegments

Internal Name: StartDateTimeLocal

The start date and time in local time at the first stop on the segment.

End Date Time Local

Table: VRPOutputSegments

Internal Name: EndDateTimeLocal

The end date and time in local time at the last stop on the segment.

Segment ID

Table: VRPOutputSegments

Internal Name: SegmentID

The identifier of the segment.

Sequence ID

Table: VRPOutputSegments

Internal Name: SequenceID

The sequence number of the segment on the route.

Start Stop ID

Table: VRPOutputSegments

Internal Name: StartStopID

The identifier of the first stop on the segment. The identifier is from the Stops table.

Start Site

Table: VRPOutputSegments

Internal Name: StartSite

This field displays the name of the site represented by the Start Stop ID.

End Stop ID

Table: VRPOutputSegments

Internal Name: EndStopID

The identifier of the last stop on the segment. The identifier is from the Stops table.

End Site

Table: VRPOutputSegments

Internal Name: EndSite

This field displays the name of the site represented by the End Stop ID.

CO2 Emission

Table: VRPOutputSegments

Internal Name: CO2Emission

Displays the CO2 emission incurred on the segment. The emission is calculated as:

((Tare weight of vehicle + weight of shipments onboard) * CO2 factor) * Distance traveled

The CO2 factor is defined on the Transportation Assets table.

Additive Cost

Table: VRPOutputSegments

Internal Name: AdditiveCost

The cost added to the calculated cost on the segment when Additive Cost is defined in the Transit Matrix table.

Scenario ID

Table: VRPOutputSegments

Internal Name: ScenarioID

The identifier of the scenario for which the output data was generated.

Sub-Scenario ID

Table: VRPOutputSegments

Internal Name: StepNumber

The identifier of the sub-scenario, if applicable, for which the output data was generated.

Last modified: Wednesday May 15, 2024

Is this useful?