TKWork

Name: Timekeeping Work

Type: Application

Modules: OPS-Dispatch, OPS-Timekeeping, OPS-SIT

Description: Contains daily dispatch information.

Field Documentation
WorkId Unique identifier or each piece of work.
DivisionId Division identifier from MasterDivisions.DivisionId. References the associated division.
LDate Date the work was carried out.
SignId Sign-up period identifier from OPSSignUpPeriods.SignId. References the associated sign-up period.
WorkType Work type identifier from WorkSubtype.WorkType. References the type of work.
SourceId Extra work identifier from TkExtraWork.WorkId or run identifier from MasterRun.RunId.
PieceNum Sequential number of the associated piece of work.
SignOnTime Timeout duration for Sign On. Value is in seconds from midnight.
SignOffTime Timeout duration for Sign Off. Value is in seconds from midnight.
FromTime Start time for the piece of work. Value is in seconds from midnight.
ToTime End time for the piece of work.
AssignTypeId Custom assignment type identifier from OpsCustomAssignmentTypes.AssignTypeId. References the associated custom assignment type.
EmployeeId Employee identifier from Employees.EmployeeId. References the employee to whom the work has been assigned.
StartEventType Event that occurred at the starting trip (1 = Pull Out, 2 = Pull In, 3 = Node Time, 4 = Relief, 5 = Break Start, 6 = Break end, 7 = Relief Start, 8 = Relief End, 9 = Created Pull In, 10 = Created Pull Out, 11 = Break Relief Start, 12 = Break Relief End, 13 = Unattended Start, 14 = Unattended End, 15 = Pull Out End, 16 = Pull In Start, 17 = Interline Start, 18 = Interline End).
EndEventType Event that occurred at the end trip (1 = Pull Out, 2 = Pull In, 3 = Node Time, 4 = Relief, 5 = Break Start, 6 = Break end, 7 = Relief Start, 8 = Relief End, 9 = Created Pull In, 10 = Created Pull Out, 11 = Break Relief Start, 12 = Break Relief End, 13 = Unattended Start, 14 = Unattended End, 15 = Pull Out End, 16 = Pull In Start, 17 = Interline Start, 18 = Interline End).
WorkName Name of the work.
SplitNum Sequential number of the associated split.
BlockNum Number of the associated block.
ActualSignOnTime Time the employee actually signed on when doing this work. Value is in seconds from midnight.
ActualSignOffTime Time the employee actually signed off when doing this work. Value is in seconds from midnight.
ActualFromTime Time the work actually began. Value is in seconds from midnight.
ActualToTime Time the work actually ended. Value is in seconds from midnight.
OdometerFrom Odometer reading in meters when the work began.
OdometerTo Odometer reading in meters when the work ended.
UserDouble1 Client supplementary data.
UserDouble2 Client supplementary data.
UserDouble3 Client supplementary data.
Status Driver's awareness of the work (1 = Driver Told, 2 = Driver Notified).
BidEmployeeId Employee identifier from Employees.EmployeeId. References the employee who bid on the work.
StartTravel Elapsed travel time in seconds starting from the beginning of the work.
EndTravel Elapsed travel time in seconds to the end of the work.
LineGroupId Line group identifier from MasterLineGroup.LineGroupId. References the associated line group.
Mileage Total mileage of the work (in meters).
ServiceGroupId Service group identifier from ServiceGroup.ServiceGroupId. References the associated service group.
BusTypeId Bus type identifier from BusTypes.BusTypeId. References the associated bus type.
WorkSubtype Work subtype identifier from WorkSubtypes.WorkSubtype. References the associated work subtype.
RunTypeId Run type identifier from MasterRunType.RunTypeId. References the associated run type.
TimeSort Used to sort records when loading work for a report. Usually has the same value as SignOnTime. Value is in seconds from midnight.
FromAddrType Originating location type (e.g., 'Garage').
FromNodeId Node identifier for start point from Nodes.NodeId. References the associated originating node.
ToAddrType Destination location type (e.g., 'Stop').
ToNodeId Node identifier for start point from Nodes.NodeId. References the associated destination node.
UserLong1 Client supplementary data.
UserLong2 Client supplementary data.
UserLong3 Client supplementary data.
UserLong4 Client supplementary data.
UserString1 Client supplementary data.
PickUpTime Scheduled pickup time. Value is in seconds from midnight.
PickUpLocation Scheduled pickup location.
DropOffTime Scheduled dropoff time. Value is in seconds from midnight.
DropOffLocation Scheduled drop off location.
RidCount Total ridership count for charters and specials.
Violations Potential rule violations.
BidAssignTypeId Work assignment type. Values can be predefined (0 = None, 1 = Bid, 2 = Substitution, 3 = Hold-Down, 4 = Rota, 10 = Planned Extraboard, 11 = Planned Volunteee, 20 = Daily Extraboard, 21 = Daily Volunteer) or can be a custom assignment type from OpsCustomAssignmentTypes.AssignTypeId.
ExcComboId Exception combination identifier from ExceptionCombinations.ExcComboId. References the associated exception combination.
StartWait Elapsed wait time in seconds from the beginning of the work.
EndWait Elapsed wait time in seconds to the end of the work.
RunTypeNum Run type identifier from OpsRunTypes.RunTypeNum. References the associated run type.
SignInRequired If true, sign-in is required for clients with the Sign-In Terminal.
ReportTime Total report time (in seconds).
ClearTime Total clear time (in seconds).
AssignListId Indicates the specific ExtraBoard or Volunteer list from which the assignment was made.
ModDate Date the record was last modified.
ModTime Time the record was modified. Value is in seconds from midnight.
ModBy User who last modified the record.
WorkJobClassId Job class identifier and alias from OpsJobClasses.JobClassId. References the work's associated job class.
BlockName.TKWork Name of the associated block.
JobClassId Job class identifier from OpsJobClasses.JobClassId. References the associated job class.
SignOffRequired If true, a sign-off is required when the work is finished.
PieceName Name of the associated piece of work.
Comments Comments about the record.
ReasonId Reason identifier from OpsDispatchReason.ReasonId. References the associated cancelled work reason, if the work was cancelled.
MaxOBT Maximum allowable On Board Time, on the vehicle of the client for the trip. Value is in seconds from midnight.
FromAddrId Unique identifier of the originating location.
ToAddrId Unique identifier of the destination location.
ModAction The last action performed on the record.
HaveCanceledTrips If true, the work has cancelled trips.
ShiftLayover Total shift layover time (in seconds).
MakeupTime Total makeup time (in seconds).
StartTimeStamp Time the operator's work starts.
EndTimeStamp Time the operator's work end.
SignOnNodeId Signon Node for run.
SignOffNodeId Signoff Node for run.
LineList List of lines in the block.
RunVersionId Run versioning identifier employed along with RunId to uniquely identify a run in OPSMasterRun and OPSRun; generally sourced from the FX ExcComboId
IsFlex If true. then the work is a Flex run.
AdjustedFlag this filed will be set to true if work piece(s) are 'adjusted' through the Edit Work Time function.