Time and Labor Tables

TL_EMPL_DATA
Contains high level data of an employee like Workgroup, Taskgroup, Time Reporter Status.

TL_RPTD_TIME
Extracts employee time reported data.
Both the elapsed and punch type data is stored in this table.
TL_QUANTITY is field which stores the reported hours data.
DUR field contains Date value.

File Layout: Previewing Input Data

Some useful information related to previewing data in File Layouts.

1. Preview file data is available only for FIXED and CSV file layouts.
2. With an XML file, you cannot preview the data

The preview data appears only if you selected an import file, if the file format matches the format specified for the file layout definition, and if it contains a file record ID that matches the file record ID of the selected segment.

Source referred from PeopleTools 8.52