ProviderActivityCost
Name: Product Activity Cost
Type: Application
Modules: Faring
Description: Definition of the cost of different types of activities that a trip provider will incur. Includes conditions and constraints for each.
| Field | Documentation |
|---|---|
| PCCId | Numeric identifier of the provide costing contract. |
| PCCNum | Numeric identifier of the provider contract cost under each PCCId. |
| Activity | Event activity (e.g., Pickup, dropoff, pullout, pullin, break etc.) used to accociate a cost with a single activity. Not associated with travel time or distance from previous or next event (use the ProviderTripCost table instead). |
| MobAidCode | Mobility aid code from the MobilityAid table used for the trip. |
| SchedStatuses | Comma-separated list of Schedule statuses (e.g., '4,20,21') used to identify NoShow trips. If empty, assume all. |
| FromTime | Start time when the provider activity begins. Used to differentiate the set of cost to specific timeintervals. For example, nightdriving is more expensive. Determining whether an activity is within timeinterval is based on estimated time (EstTime) of activity. Value is in seconds from midnight. |
| ToTime | End time when the provider activity is finished for the day. Used to define the end of a time interval. Used to differentiate the set of cost to specific timeintervals. For example, nightdriving is more expensive. Determining whether an activity is within timeinterval is based on estimated time (EstTime) of activity. Value is in seconds from midnight. |
| PolyId | If polygon-based cost is used, then this field contains the numeric identifier of the polygon from the polygons table, otherwise it is not set. |
| PassOnOff | Comma-separated list of passenger types (e.g., CLI,COM). If empty, then assume all. If any in the list match who is being picked up or dropped off during this activity, then apply the cost. |
| SpaceOnOff | Comma-separated list of space types (i.e. AM,WH). If empty, then assume all. If any in the list match who is being picked up or dropped off during this activity, then apply the value. |
| IsCoDriverCost | Flag that indicates whether a co-driver is included in the costing (0 = No, 1 = Yes, 2 = Does not matter). |
| IsOutsideRunCost | Flag that indicates whether the activity is violating the runs out and in time (0 = No, 1 = Yes, 2 = Either). If yes, then dwelltime costs are applied to only the time spent outside of the valid time of the run. If no, then dwelltime costs are applied to only the time spent within the valid time of the run. If Either, then full dwelltime is costed regardless of whether any of it is outside of the valid time of the run. |
| IsGuaranteedCost | Flag that indicates if the activity is scheduled within the GuaranteedTime (0 = No, 1 = Yes, 2 = Does not matter). |
| AddToGuaranteed | Flag that indicates whether dwelltime adds to the calculation of guaranteed time (1 = Yes, 0 = No). |
| DwellLimit | Maximum time in seconds an activity can wait or dwell on an event such as waiting for a pickup. The formula is calculated as BelowTimeRate * DwellTime + BelowFlatRate applies if DwellTime < DwellLimit. Otherwise AboveTimeRate * DwellTime + AboveFlatRate applies. |
| BelowFlatRate | Rate to apply if dwelltime is under the limit. |
| AboveFlatRate | Rate to apply if dwelltime is at or above the limit. |
| BelowTimeRate | Rate to apply if the price or time unit is under the dwell limit. |
| AboveTimeRate | Rate to apply if the price or time unit is at above the dwell limit. |
| CostBreakdownType | Used for tracking this cost in the ProviderCostBreakdown field in the Events table. |
| CostSet | For internal use. |
| PeriodConvenience | For internal use. |
| PPId | For internal use. |
| PRId | Secondary key in conjuction with the PRID. |