ParaRuns

Name: Para Runs

Type: Application

Modules: Runs, Scheduling

Description: Main table holding information about vehicle runs and cross-references to related tables.

Field Documentation
ParaRunId Numeric identifier of the para run.
ParaRunType Hard-coded value for the type of run (Flex, FX, PARA, Taxi).
ParaRunName Alphanumeric name of the para run.
SchTypeId Numeric identifier of the para run schedule type (from the ScheduleTypes table).
WeekTemplate 7-digit string indicating the days of the week for the run (e.g., 0100100 = Monday and Thursday).
FromDate Start date from which trips can be booked on to the para run.
ToDate End date after which trips can no longer be booked on to the para run.
FromGarageId Numeric identifier of the garage from which the vehicle for the run originates (from the Garages table).
ToGarageId Numeric identifier of the garge to which the vehicle for the run returns (from the Garages table).
FromTime Start time from which trips can be scheduled to the run. Value is in seconds from midnight.
ToTime End time after which trips can no longer be scheduled to the run. Value is in seconds from midnight.
MaxLength Maximum length of time in seconds that the run is allowed to be active and have trips assigned to it.
CapType Numeric identifier of the capacity type that the run can accommodate (from the CapacityTypes table).
EmployeeId Numeric identifier of the employee (e.g., driver, supervisor, custom employee type) assigned to the run (from the Employees table).
CoDriver Flag that indicates whether a co-driver is required for the run.
CoEmployeeId Numeric identifier of the employee or driver who is assigned to the run as a co-driver (from the Employees table).
GasCard Card number (e.g., debit card number, credit card number) used to refuel the vehicle assigned to the run.
ProviderId Numeric identifier of the provider used for the run (from the Providers table).
EvStrClass Hard-coded value that classifies the run to a run type (e.g., PARA, FLEX, Taxi).
LineGroupId Deprecated.
BlockNum Deprecated.
VehicleId Numeric identifier of the vehicle assigned to the run (from the Vehicles table).
UserDouble1 Client supplementary data.
UserDouble2 Client supplementary data.
UserLong1 Client supplementary data.
UserLong2 Client supplementary data.
UserLong3 Client supplementary data.
UserLong4 Client supplementary data.
UserLong5 Client supplementary data.
UserString1 Client supplementary data.
UserString2 Client supplementary data.
UserString3 Client supplementary data.
UserString4 Client supplementary data.
UserString5 Client supplementary data.
SpeedFactor Percentage of an average speed (e.g., if the driver is new and unfamiliar with a route, he may take 110% of the average speed for travel).
Priority Order in which the events are evaluated for scheduling.
ParaServiceAreaId Numeric identifier of the para service area (from the ParaServiceAreas table).
ProviderContractId Numeric identifier of the provider contract assigned to the run (from the ProviderContract table).
ParaTimeRules Deprecated.
SchedulePeriodId Numeric identifier of the schedule period (from the SchedulePeriods table).
FromTimeRule Numeric value indicating the FromTime rule to use (Garage, First Pickup, Last Dropoff, or Last Pickup).
ToTimeRule Numeric value indicating the ToTime rule to use (Garage, First Pickup, Last Dropoff, or Last Pickup).
SignOnTime Time that the driver must sign on by. Value is in seconds from midnight.
SignOffTime Time that the driver must sign off by. Value is in seconds from midnight.
DivisionId Division identifier of the para run (from MasterDivisions.DivisionId).
LineGroupAbbr Deprecated.
Comments Comments about the record.
ReportTime Time in seconds required for drivers to complete reports (e.g., sign on, vehicle inspection) before starting the run.
ClearTime Time in seconds required for drivers to sign off, do vehicle inspection, etc., after finishing the run.
RunCategoryId Numeric identifier of the run category that logically groups runs to types (from ParaRunCategory table).
BreakRuleId Numeric identifier of the break rule for the run (from the ParaRunBreakRule table).
DirNum Numeric value indicating the direction of the run (0 = Outbound, 1= Inbound).
MinLength Minimum time in seconds a run must last before it can be added to a schedule.
CallDriver Flag that indicates whether the driver must be called (e.g., with updates, with notifications).
ClusterType Hard-coded character type of a cluster run (M = master, C = cluster).
ClusterOverlapFromRule Hard-coded value that identifies the overlap rule to apply when scheduling pullout or first event activities.
ClusterOverlapToRule Hard-coded value that identifies the overlap rule to apply when scheduling pullin or last event activities.
MaxClusterEmptyTime Total time that is not scheduled in seconds. Used for the Master Cluster run from which child runs will be created.
IsBumpRun Flag that indicates that the run is a bump run.
BumpRule Hard-coded value for the rule that is applied to bump trips onto this run.
MaxTrips Maximum number of trips allowed on a bump run. The run must be a bump run.
OverdraftTrips Number of trips allowed that exceeds the MaxTrips. Used for bump runs.
MaxProviderCost Maximum allowable cost that can be charged to a provider for a bump run.
OverdraftProviderCost Allowable cost that exceeds the MaxProviderCost that can be charged to a provider for a bump run.
RequireOrderNo Flag that indicates an order number is required for the run.
EligibleForSwapping Flag that indicates the run can allow for a change of vehicle or vehicle type.
MaxEscorts Maximum number of passengers that can be escorts.
VehicleType Numeric identifier of the vehicle type for the run (from the VehicleTypes table).
IsFrozen Flag that indicates whether the run is frozen so that trips, trip order, etc. cannot be changed.
MirrorParaRunId Numeric identifier of the para run from which this run was mirrored.
IsInPlanningMode Flag that indicates that if the run is in planning mode, then no live schedules, runs, etc., can be created from it.