ScheduleImportDetail
Name: Schedule Import Detail
Type: Application
Modules: OPS Only
Description: Contains the scheduling import details for roster or run information to be compared with existing records. Works with the ScheduleImportInfo table.
| Field | Documentation |
|---|---|
| ProcessId | Unique identifier for an OPS process (from the OPSProcessLog table.) |
| Sequence | Priority number used for ordering data query records. |
| Type | Schedule import type (0=Run, 1=Roster). |
| SectionId | Internal use only. Defines a group of run or roster records. |
| DivisionId | Division identifier of the agency. |
| WeekTemplate | Indicates which days of the week on which the run or roster has had changes. |
| RunName | Run name associated with the schedule import (when it is for a run). |
| RosterName | Roster name associated with the schedule import (when it is for a roster). |
| Days | Days the compare is in effect (e.g., holidays). |
| Compare | Comparison type (0 = delete, 1 = add, 2 = change). |
| Comments | Comments about the record. |