ParaServiceAreaRules
Name: Para Service Area Rules
Type: Application
Modules: Scheduling
Description: Restrictions attached to paraservices for what polygons areas they can or cannot travel in and when.
| Field | Documentation |
|---|---|
| ParaServiceId | Numeric identifier of the paraservice area (from the ParaServiceAreas table). |
| ServiceAreaRuleId | Numeric identifier of the paraservice area rule. |
| EffectiveFromDate | Start date from which the paraservice area rule is in effect. |
| EffectiveToDate | End date after which the paraservice area rule is no longer in effect. |
| WeekTemplate | 7-character string representing the days of the week for which the rule is in use (e.g., 0100100 = Monday and Thursday). |
| FromPolyId | Numeric identifier of the polygon from which the trip originates (from the Polygons table in MmsMap.dbd). |
| FromLocId | Numeric identifier of the location from which the trip originates (from the Locations table). |
| ToPolyId | Numeric identifier of the polygon in which the trip ends (from the Polygons table in MmsMap.dbd). |
| ToLocId | Numeric identifier of the location in which the trip ends (from the Locations table). |
| FromTime | Start time from when the paraservice area rule is used (pick-up). Value is in seconds from midnight. |
| ToTime | End time when the paraservice area rule is no longer used (drop-off). Value is in seconds from midnight. |
| ReverseOk | Flag that indicates whether a reverse trip will use the same paraservice area rule. |
| RevFromTime | If the trip is reversed or there is a return trip, the FromTime is the time from which the paraservice area rule is enforced. |
| RevToTime | If the trip is reversed or there is a return trip, the ToTime is the time to which the paraservice area rule is enforced. |
| Description | Description of the the paraservice area rule. |
| FromLoc | Flag indicating whether the trip Origin must be defined in the FromLocType field. |
| FromLocType | Comma-separated string of LocTypes the trip can use as an Origin (when FromLoc is true). |
| ToLoc | Flag indicating whether the trip Destination must be defined in the ToLocType field. |
| ToLocType | Comma-delimited list of LocTypes which the trip can use as a Destination (when ToLoc is true). |
| CliRegServices | Comma-delimited list of paraservice IDs. The client must have one or more of the listed paraservice IDs on their record. |
| CliRegServicesApply | Specifies the applications that must adhere to the client registered services rule (0 = none, 1 = WEB, 2 = Workstation, 3 = Both). |
| FxOptions | Options available when integrating fixed route solutions to the route (0 = N/A, 1 = Check Only, 2 = Display Only, 3 = Check and Display). |
| FxOptionsApply | Specifies the applications that must adhere to the FX options rule (0 = none, 1 = WEB, 2 = Workstation, 3 = Both). |
| TripTakenPastDays | Number of days (prior to today) within which the current trip's PU and DO location must match a previous booking's PU and DO location. |
| TripTakenPastDaysApply | Specifies the applications that must adhere to the trips taken options rule (0 = none, 1 = WEB, 2 = Workstation, 3 = Both). |
| EarliestReqDayOffset | Earliest number of days a trip request can be made for from the current date. |
| EarliestReqDayOffsetApply | Specifies the applications that must adhere to the earliest days rule (0 = none, 1 = WEB, 2 = Workstation, 3 = Both). |
| LatestReqDayOffset | Latest number of days a trip request can be made for from the current date. |
| LatestReqDayOffsetApply | Specifies the applications that must adhere to the latest days rule (0 = none, 1 = WEB, 2 = Workstation, 3 = Both). |
| DefaultWebSubtypeAbbr | Default booking subtype abbreviation that will be stamped on bookings created through Pass-WEB. |
| WebSchedAction | Allowable scheduling action for trip bookings via Pass-WEB (0 = unscheduled, 1 = Schedule). |