ProviderTripCost
Name: Provider Trip Cost
Type: Application
Modules: Scheduling, Faring
Description: Definition of pricing for provider contracts by trip including for what, when, activities covered, deadheads, slack time, etc.
| Field | Documentation |
|---|---|
| PCCId | Numeric identifier the provider contract cost. |
| PCCNum | Hard-coded, numeric identifier of the activity at the destination of the trip (e.g., pick-up, drop-off, pullout, pullin, break etc.). It is used to associate a cost with a trip (a from/to event pair, not a booking). |
| FromActivity | Comma-separated list of hard-coded values for schedule statuses of the FromActivity (e.g., Missed Trip, Scheduled, etc.) |
| ToActivity | Comma-separated list of hard-coded values for schedule statuses of the ToActivity (e.g., Missed Trip, Scheduled, etc.) |
| FromSchedStatus | Comma-separated list of hard-coded values for schedule statuses of the FromActivity (e.g., Missed Trip, Scheduled, etc.) |
| ToSchedStatuses | Comma-separated list of hard-coded values for schedule statuses of the ToActivity (e.g., Missed Trip, Scheduled, etc.) |
| FromTime | Time used to differentiate the set of costs to specific time intervals. For example, driving at night is more expensive than driving during the day. This field indicates whether an activity is within the time interval based on the estimated time (EstTime) at the start of the activity. Value is in seconds from midnight. |
| ToTime | Time used to differentiate the set of costs to specific time intervals. For example, driving at night is more expensive than driving during the day. This field indicates whether an activity is within the time interval based on the estimated time (EstTime) at the start of the activity. Value is in seconds from midnight. |
| FromPolyId | If polygon-based costing is in use, then this field contains the numeric identifier of the polygon that the address of the FromActivity is in from the Polygons table |
| ToPolyId | If polygon-based costing is in use, then this field contains the numeric identifier of the polygon ID that the addres of the ToActivity is in from the Polygons table |
| PassOnBoard | Comma-separated list of passenger types from the PassTypes table and how many passengers are on the trip. If empty, then assume all. If any in the list match who is on board during this trip then apply. |
| SpaceOnBoard | Comma-separated list of space types from the SpaceTypes table and how many of each are on the trip. If empty then assume all. If any in list match who is on board during this trip then apply those space types. |
| IsDeadheadCost | Indicates whether the deadhead cost applies: 0 = No, 1 = Yes, 2 = Either |
| IsOutsideRunCost | Flag that indicates whether the activity is violating the pullout and pullin times of the run: 0 = No, 1 = Yes, 2 = Either. If yes, then slack and travel costs are applied to only the time spent outside of the run valid time. If no, then slack and travel costs are applied to only the time spent within the valid time of the run. If Either, then full slack and travel are costed regardless of whether any of it is outside of the valid time of the run |
| IsGuaranteedCost | Whether the activity is scheduled within the GuaranteedTime: 0 = No, 1 = Yes, 2 = Either |
| AddToGuaranteed | Whether this record affects the calculation of the guaranteed time (1 = Yes, 0 = No) |
| SlackLimit | For internal use. |
| TravelLimit | For internal use. |
| DistanceLimit | For internal use. |
| UseLimitsAsOr | For internal use. |
| BelowFlatRate | For internal use. |
| AboveFlatRate | For internal use. |
| BelowSlackRate | For internal use. |
| AboveSlackRate | For internal use. |
| BelowTimeRate | For internal use. |
| AboveTimeRate | For internal use. |
| BelowDistanceRate | For internal use. |
| AboveDistanceRate | For internal use. |
| CostBreakdownType | Used for tracking this cost in the ProviderCostBreakdown field in the Events table. |
| CostSet | For internal use. |
| PPId | For internal use. |
| PRId | Secondary key in conjuction with the PRID. |
| PeriodConvenience | For internal use. |
| CombineSlackAndTime | For internal use. |