OPSMasterRun
Name: OPSMaster Run
Type: Application
Modules: OPS Only
Description: Based on the MasterRun table. Populated via bulk data importation from either MasterRun or from a third party database.
| Field | Documentation |
|---|---|
| RunId | Combined with ExcComboid forms a unique identifier for a run. |
| RunVersionId | Run versioning identifier that is employed along with RunId to uniquely identify a run in OPSMasterRun and OPSRun; generally sourced from the FX ExcComboId. |
| SignId | Sign-up period identifier from OPSSignUpPeriods.SignId. |
| ServiceGroupId | Service group identifier from MasterServiceGroup.ServiceGroupId. |
| DivisionId | Division identifier from MasterDivisions.DivisionId. |
| RunName | Full name of run. |
| NumPieces | Total number of pieces in the run. A piece is a portion of work for a driver from a single block. |
| RunNum | Identifier for a run that is unique within a sign-up period, service group, and division. |
| LineGroupId | Line group identifier from MasterLineGroup.LineGroupId. |
| PlatformTime | Time during which an operator operates the revenue vehicle. |
| ReportTime | Time for which an operator is paid to report to work before pulling the vehicle out of the garage. |
| ClearTime | Time for which an operator is paid to clear a vehicle after returning it to the garage. |
| WorkTime | Time when the operator is performing work. |
| SpreadTime | Normally SignOffTime - SignOnTime. |
| TravelTime | Time for which an operator is paid when traveling to and from relief points. |
| MakeupTime | Payment to an operator for time not actually worked on a piece to meet a guaranteed time. |
| OverTime | Amount of WorkTime beyond a normal working day. |
| PayTime | Amount of time for which compensation will be provided. |
| SignOnTime | Time at which the operator checks in to complete a run. |
| SignOffTime | Time at which the operator signs off after completing a run. |
| SpreadOverTime | Spread time in excess of a normal working day. |
| InterveningTime | Incidental time between pieces. |
| OverTimePrem | The premium, in seconds, an operator is paid for working longer than a standard day. |
| SpreadOverTimePrem | The premium, in seconds, an operator is paid for spread time greater than a standard day. |
| SwingTime | Time between pieces. |
| UserLong1 | Client supplementary data. |
| UserLong2 | Client supplementary data. |
| UserLong3 | Client supplementary data. |
| UserLong4 | Client supplementary data. |
| UserLong5 | Client supplementary data. |
| UserLong6 | Client supplementary data. |
| UserLong7 | Client supplementary data. |
| UserLong8 | Client supplementary data. |
| UserLong9 | Client supplementary data. |
| UserLong10 | Client supplementary data. |
| UserLong11 | Client supplementary data. |
| UserLong12 | Client supplementary data. |
| UserLong13 | Client supplementary data. |
| UserLong14 | Client supplementary data. |
| UserLong15 | Client supplementary data. |
| RunTypeNum | The identifier of the runtype for this run from MasterRunType.RunTypeNum. |
| StartWait | For wait and travels, the wait time at the start of the run. |
| EndWait | For wait and travels, the wait time at the end of the run. |
| OriginDivisionId | Original division that the run belonged to in FX (used by OPS). |
| CommentId | Comment identifier from Comments.CommentId. |
| OpsVersionId | Import version ID from third-party external source. |
| RunSchId | Uniquely identifies a run in OPSRunSchedules. |
| FromDate | Start date from when the alert is valid. |
| ToDate | End date after which the alert is no longer valid. |
| WeekTemplate | Indicates which days of the week the employee has a day off. |
| EventStatus | Operator status. |
| SourceRunId | For data that is imported from an external source, this contains the run identifier from the other system. |
| ExcComboIdSrc | For data that is imported from an external source, this may contain the exception combination identifier from the other system. |