Understanding Payable Time Fields

This table lists the fields maintained for each entry of payable time in TL_PAYABLE_TIME:

Field Name	Description
Emplid	Employee identification number.
Empl_Rcd	Employee record number.
DUR	Date to which this time was reported.
Seq_Nbr	Unique serial number. The link for payroll update and distribution.
Initial_Seq_Nbr	Initial sequence number. Used for PNA check reversal integration. Has a value equal to the Seq_Nbr field value when a check is reversed.
Task_Prfl_Tmplt_ID	Task template for task elements.
TRC	Time reporting code for this time.
TL_Quantity	Hours, amount, or units reported by elapsed time reporters. This field is calculated for punch time reporters.
Shift_ID	The shift under which the original time was reported.
Billable_Ind	Billable indicator.
Override_Rate¹	Override rate, entered directly by an authorized user or derived through rules.
Comp_RateCd	Alternate rate code to be used with this time. Entered directly by an authorized user or derived through rules.
Country	Country to be used with this time. Entered directly by an authorized user or derived through rules.
State	State to be used with this time. Entered directly by an authorized user or derived through rules.
Location	Location to be used with this time.
Locality	Locality to be used with this time. Entered directly by authorized individual or derived through rules.
Est_Gross	The estimated gross pay for this entry.
Currency_Cd	The monetary unit in which the Reported, Override_Rate and Est_Gross fields are stated.
Lbr_Dist_Amt	Actual gross from your payroll system, spread evenly across all relevant TRCs in the period.
Diluted_Gross	Labor distribution amount after dilution.
Currency_Cd2	The monetary unit in which the Lbr_Dist_Amt and Diluted_Gross fields are stated.
Payable_Status	Identifies the status for this time.
TL_Pybl_Reason_Cd	Payable reason code.
TL_Rule_ID	Rule ID. Indicates which rule has created the time. This field is populated only if a rule has created the time.
Pay_System	Payroll system that processed this entry.
Payroll_Req_Num	Sequential number of payroll requests.
Frozen_Sw	Indicates that this record will not be changed by Time Administration.
Frozen_Date	Date the frozen flag was set.
Record_Only_Adj	Record only adjustments.
Publish Sw	Indicates if the row was published.
Actual_Pub_Date	Date published as the final paid time.
Oprid	Operator ID that approved the time.
Apprv_Prcs_Dttm	Date time was approved.
Source_Ind	Source indicator: Offset, System Generated, or User Reported (Record Adjustments)
Rt_Source	Reported time source.
Orig_Seq_Nbr	The original sequence number, if this is an offset.
Company	Company code.
Business_Unit_PC	Project Costing business unit.
Business_Unit	HR business unit.
DeptID	Department ID.
Product	Product code.
Project_ID	Project ID.
Task	Task code.
Customer	Customer code.
Acct_CD	Account code.
Resource_Type	Resource type.
Resource_Category	Resource category.
Resource_Sub_Cat	Resource sub category.
Activity_ID	Activity ID.
User_Field_1	User field 1.
User_Field_2	User field 2.
User_Field_3	User field 3.
User_Field_4	User field 4.
User_Field_5	User field 5.
Business Unit PF	Performance Management business unit.
SetID_Dept	Department set ID.
SetID_Resource	Resource set ID.
SetID_Activity	Activity set ID.
Deptid_CF	Department ID ChartField.
Account	Account code.
Fund Code	Fund code.
Program Code	Program code.
Class Field	Class field.
Affiliate	Affiliate field.
Operating Unit	Operating unit field.
Alt Account	Alternate account code.
Budget Ref	Budget reference field.
Chartfield 1, Chartfield 2, Chartfield 3	ChartField codes.
Affiliate Intra1, Affiliate Intra2	Affiliate Intra1 and Affiliate Intra2 fields.