14.2 Details

14.2 Details

Info
Details

The Details tab is used to configure the line items in the output file. The items are listed from top to bottom, and will be exported from left to right into the export file. The arrow buttons on the right side move a selected item up or down, double arrows move 10 places at a time.


To add a ‘Column’ into the export file, click on ‘Add’, this will create a new entry in the table. The columns can be moved from left to right using the arrows on the right.

The item type will always be either a ‘Constant’ or a ‘Field’, each item needs to be configured independently from the others.

A ‘Constant’ type will always export the same value typed into the text box. Examples: Batch Transaction codes, End of Line codes, Time Category codes, or any non-changing items necessary. To do this, type in the constant value into the ‘Constant’ text field, with the ‘Format’ as text, and the ‘Length’ being the number of characters required.

The ‘Field’ type is used to export existing items within JT (Time Categories, Counters, Dates, Clocking Times, and Employee Details etc.).

Select the export ‘Format’ for the field (e.g. Text, Number, Time or Date etc.), and then set the ‘Length’. If the length is set to ‘0’ then JT will export the entire constant, regardless of its length, otherwise JT will export the field according to the length specified.

Left Alignment - JT will begin exporting the field from the left to the right, with any additional spaces appended (specified length greater than field length). If the length of field is greater than the specified length, JT will still export from left to right, but only for the length specified. Right Alignment - JT will begin exporting the field from the right to the left, with any additional spaces suffixed (specified length greater than field length) to the beginning of the field. If the length of field is greater than the specified length, JT will still export from right to left, but only for the length specified.

Export Trigger - JT will only add a row to the export file if one or more of the ‘export trigger’ items have a value associated to it, for the date range selected to export. In most cases one would set the NT and OT etc., as triggers, then during the export if there were any NT or OT, JT would export the entire row into the file. (If there were only OT, JT will still export the entire line, but export the NT as 0.) If all employees in the filter needed to be exported, one could select the employee number as a trigger (as all employees have an employee number).

If Multiple Records per employees were selected in the General tab, JT would present the details as per below image. Each Row in the list on the left represents a separate set of details in the details list on the right (configured in the same way as the standard export). Rows can be added to the file export by clicking the + icon at the bottom of the list. Multiple Records exports the details for each row, on a new line in the file.


    • Related Articles

    • 14.1 Export File Creator

      Export File Creator The File Creator is used to create an export file for Third-Party System integration. If you are not completely familiar with the import batch layout of your Third-Party system, it may be advisable to arrange to have a payroll ...

    • 15.1 Reports (Report Groups)

      Reports To print a report, first select the person or load the filter as required, then select the report from the list on the left. Select the date range, then click ‘Preview’ to view the report on screen before printing, otherwise click ‘Print’ to ...

    • 16.1 Report Creator

      Report Creator The Report Creator is used to create or edit reports as per requirements. Click on ‘Setup’ then ‘Report Creator’ from the menu bar, then click ‘Add’ or select a report to edit, from the list on the left. You will be presented with ...

    • 17.1 File Export

      File Export The file export will export the calculated totals to an ASCII file, for the Third-Party system to import. The export format is created in the File Creator, which is beyond the scope of this manual. To export the totals, first select the ...

    • 24.1 Devices/Details

      Devices Details Enabled - each device needs to be enabled to be included in the JT Engine’s list (viewable from the Device Action Monitor). Remote Clockings Import - if selected will disable all other parameters besides the device name and will ...