OPSAltDivisionAssignments
Name: OPS Alternative Division Assignments
Type: Application
Modules: OPS-Dispatch, OPS-Employee Profile
Description: Contains alternative division work.
| Field | Documentation |
|---|---|
| LDate | Date of the work. |
| Type | Type of assignment (0 = Work, 1 = Bid, 2 = Publish). |
| WorkType | Work type identifier from WorkSubtypes.Worktype. References the associated work type. |
| WorkId | Work identifier from TkWork.WorkId. References the associated work. |
| PieceNum | Sequential number of the associated piece of work. |
| EmployeeId | Employee identifier from Employees.EmployeeId. References the associated employee. |
| EmployeeDivisionId | Division identifier from MasterDivisions.DivisionId. References the employee's division. |
| WorkDivisionId | Division identifier from MasterDivisions.DivisionId. References the division the work belongs to. |
| SourceId | Run identifier from MasterRuns.RunId or work identifier from TkExtraWork.WorkId. |
| SchId | Schedule identifier from Schedules.SchId. References the associated schedule. |
| EvStrId | Event string identifier from EventStrings.EvStrId. References the associated event string. |