TKExtraPay
Name: Timekeeping Extra Pay
Type: Ancillary
Modules: OPS-Dispatch, OPS-Timekeeping, OPS-SIT
Description: Contains daily extra pay transactions.
| Field | Documentation |
|---|---|
| WorkId | Work identifier from TkWork.WorkId. References the associated work. |
| ExtraPayTypeId | Extra pay type identifier from ExtraPayTypes.ExtraPayTypeId. References the associated extra pay type. |
| FromTime | Start time of the chargeable period. Value is in seconds from midnight. |
| ToTime | End time of the chargeable period. Value is in seconds from midnight. |
| PayTime | Total amount of time in seconds that the period lasted. This is FromTime-ToTime. |
| Sequence | Sequential number used when records with the same WorkId are ordered. |
| PieceNum | Sequential number of a piece of work. |
| SchId | Schedule identifier from Schedules.SchId. References the associated schedule. |
| EvStrId | Event string identifier from EventStrings.EvStrId. References the associated event string. |
| ModBy | User who last modified the record. |
| ModDate | Date the record was last modified. |
| ModTime | Time the record was last modified. Value is in seconds from midnight. |
| JobClassId | Job class identifier from OpsJobClasses.JobClassId. References the associated job class. |
| ReasonId | Reason identifier from ExtraPayReasons.ReasonId. References the associated extra pay reason. |
| ModAction | Last action performed on the record. |
| DecisionStatus | Extra pay request decision status (0 = Not Applicable, 1 = Pending, 2 = Denied, 3 = Approved). |
| DecisionDate | Initially 0 and stamped when DecisionStatus is stamped 2 (Denied) or 3 (Approved). |
| DecisionTime | Initially -1 and stamped when DecisionStatus is stamped 2 (Denied) or 3 (Approved). |
| EmployeeComments | Comments about extra pay made by the employee. |
| SupervisorComments | Comments about extra pay made by the supervisor. |
| DecisionBy | Supervisor that made the extra pay decision. |