TL_EMPL_DATA
o Maps data between EMPLID and T&L
parameters like Workgroup, Taskgroup and Time Reporter Status.
o The PS_JOB of Time and Labor.
o Keys: EMPLID, EMPL_RCD, EFFDT.
o Used to find the Workgroup, Taskgroup, Active
status, Time Reporter Type, Timezone etc. of an employee.
o Found under the Enroll Time Reporters
component.
o Needs to be in sync with PS_JOB data.
TL_RPTD_TIME
o The single most important transaction table in
Time and Labor.
o Holds all data regarding the time reported by
employees.
o Key: EMPLID, EMPL_RCD, DUR and SEQ_NBR.
o Both Punch and Elapsed data reside in this
table – distinguished by the PUNCH_TYPE field.
o Other important fields – TRC, TL_QUANTITY,
RT_SOURCE.
o Has an audit table – AUDIT_TLRPTTIME.
o Final target table of the timesheet component.
3TL_PAYABLE_TIME
o Contains final processed time ready to be sent
to a Payroll System.
o Output of the Time Administration process and
has the TL_RPTD_TIME as the source.
o Keys: EMPLID, EMPL_RCD, DUR, SEQ_NBR.
o Other important fields – TRC, TL_QUANTITY,
PAYABLE_STATUS, PAYROLL_REQ_NUM.
o To be used for custom reports and interfaces
requiring to take the final output in Time and Labor.
TL_TR_STATUS
o Table used by the Time Administration process
to determine the employees to be processed.
o Not externalised through any component –
updated by the Time Administration process and Peoplecode in various components
including timesheet.
o Keys – EMPLID, EMPL_RCD.
o Other important fields – EARLIEST_CHGDT,
TA_STATUS.
TL_IPT
o Intermediary Payable Time tables – IPT tables
are the most important temporary tables in Time Administration processing.
o Data from reported time and scheduling tables
are populated in TL_IPT1.
o Extensively used by almost all T&L rules
where data is transferred from one IPT table to another for rule processing.
o TL_PAYABLE_TIME data is populated from TL_IPT1
table at the end of rule processing.
TL_EXCEPTION
o Transaction table containing the details of
all exceptions that are generated.
o Exception_Status field tells whether the
exception is resolved (R), unresolved (U) , allowed (A) or changed (A).
o All exceptions with an ‘Archive’ flag on will
remain in the TL_EXCEPTION table after the exception is resolved.
o All High Severity exceptions will have to be
resolved for payable time to be generated.
