Exporting Leave Data: Configuring Export Templates in TimeTec Leave

Friday, January 15, 2021 TimeTec 0 Comments

Users can export the leave data into a template and format of their preference. The leave export formats are divided into 2 general forms schema which are Detailed and Summary.

With the leave application schema you can export the leave details of all users. You will have to define the position arrangement and the length of certain data fields before exporting the leave data.

User Leave Summary schema exports all users’ leave summary. Define the position arrangement and the data type/size before exporting the leave data.

A: Leave Application Schema Template Configuration
1. In your TimeTec Leave account, go to Leave > Export Leave> Click on Leave Application Schema.

2. The Leave Application Schema module displays the following information:
Position: Enables users to select the order of the data fields (column-by-column)
Description: name of each data field as a header.
Size: The length and the maximum number of characters needs to be carried to the export file for each data field.

For example, the order of the data for the 3rd party system is this:
1 - TimeTec User ID (9 = 9 characters max)
2 - Employment ID (15 = 15characters max)
3 - Name (30 = 30 characters max)
4 - Organization Structure (30 = 30 characters max)
5 - Group Duty Roster (5 = 5 characters max)

Therefore, in the table below you need to determine the position and the size of each data field appropriately.

3. Data Field Module
After the position and the size of the required data fields at every module is set, click “Save” to move on to the next data field module. In case you don’t want any of the data fields to be exported, leave the Position blank. Every data field has a default Size value that can be changed up to max 99.

4. When the data field Position and Size are set, press Save to be directed to the Export Leave module. From the Export Leave Module, Select the Date Range, and User ID(s), then click on the “Submit” icon, the system will generate the export file based on your choice.

B: Summary Schema Template Configuration
1) At your TimeTec Leave admin account, go to Leave > Export Leave > Click on the Summary Schema.

2) The Summary Schema contains different data field modules. However, for the data field setup and configuration, repeat steps 2 to 4 of the Leave Application Schema Configuration.

3) At the Export Leave Module click on Select then choose >select  the date range and Users > Submit.

Note: If some of the screenshots or steps viewed here are different from the ones in the current system, this is due to our continuous effort to improve our system from time to time. Please notify us at info@timeteccloud.com, we will update it as soon as possible.


Have any questions or inquiries about FingerTec? Drop your input here.