TKPay

Name: Timekeeping Pay

Type: Application

Modules: OPS-Timekeeping

Description: Contains daily payroll transactions.

Field Documentation
PayId Unique identifier for a payment.
LDate Date the transaction was performed.
DivisionId Division identifier from MasterDivisions.DivisionId. References the associated division.
EmployeeId Employee identifier from Employees.EmployeeId. References the associated employee.
PayCode Pay code identifier from PayCodes.PayCode. References the associated pay code.
PayrollCode Payroll code identifier from PayrollCodes.PayrollCode. References the associated payroll code.
WorkId Work identifier from TkWork.WorkId. References the associated work.
WorkName Name of the work.
PayTime Amount of work time that was paid for.
PayAmount Total pay amount.
PayRate Hourly pay rate.
DoneFlag If true, the transaction has been completed.
ExtraPayTypeId Extra pay type identifier from ExtraPayTypes.ExtraPayTypeId. References the associated extra pay type.
AbsenceTypeId Absence type identifier from AbsenceTypes.AbsenceTypeId. References the absence type associated with the absence quota type.
PaidOn Date the payment was made.
WorkBidStatus Indicates the work bid status for the associated work (B = Bid, NB = Not Bid).
EmployeeBidTypes Indicates the employee bid status for the associated work (R = Regular Bid, NB = Not Bid, HD = HoldDown, EB = ExtraBoard).
WorkStatus Status of the work (C = Complete, IC = Incomplete, St = Split).
Flag Internal use only.
ModDate Date the record was modified.
ModTime Time the record was last modified. Value is in seconds from midnight.
ModBy User who last modified the record.
EvStrId Event string identifier from EventStrings.EvStrId. References the associated event string.
SchId Schedule identifier from Schedules.SchId. References the associated schedule.
JobClassId Job class identifier from OpsJobClasses.JobClassId. References the associated job class.
PieceNum Sequential number of the associated piece of work.
Sequence Priority number used for ordering data query records.
Shift Shift worked for which to pay an employee.
PeriodProcess If true, indicates that this transaction was generated by the weekly/bi-weekly timekeeping process.
FromTime Start time of the validity period. Value is in seconds from midnight.
ToTime End time of the validity period. Value is in seconds from midnight.
CostIdentityName User who invoked the Calculate Timekeeping process.
CostTime Time when the Calculate Timekeeping Day process was invoked. Value is in seconds from midnight.
PostDate Date when the Post Timekeeping process was invoked.
PostIdentityName User who invoked the Post Timekeeping costing process.
PostTime Time when he Post Timekeeping process was invoked. Value is in seconds from midnight.
AbsenceId Absence identifier from TkAbsences.AbsenceId. References the associated absence.
CostDate Date the Calculate Timekeeping process was invoked.
Comments Comments about the record.
ModAction Last action performed on the record.
AdvancedForDate Date the vacation pay advance applies.
ClawbackFlag If true, this transaction was generated by weekly/bi-weekly overtime clawback calculations.
PriorPayAdj If true, use prior Pay Adjustment.
SourceId References the associated employee absence identifier from TKAbsences.AbsenceId or incident identifier from OPSIncidents.IncidentId.
ActivityTypeId Activity type identifier from OPSDailyActivityTypes.ActivityTypeId. References the associated activity type.
RuleId Unique identifier for a rule.
ReferenceText Reference Text could be a work name or an absence type.
ReferenceDetail Reference Detail could be a work name Work Name (s) and Line List.
TKVersionId This value is only populated when posting occurs at the end of a pay period.
WorkPublishStatus Indicates the work publish status for the associated work (P = published employee, NP = not published employee).