In SmartTID all registrations are stored in a journal from where changes can be made before the actual approval and posting.

Here it's possible to get more detalies info about each day for each employee to get specifikations about how the employees punched in/out, break, extra and job registrations.

These info can even be taken before any user as approved the registratons. So these an be used for live view in dashboards etc.

Get Journal line


There is 5 possible functions to call

The main functions is to get jornal lines. There is typically 1 journal line for each employee each day. This records also gives you totals for the day.


To narrow down the dataset you get back you can specifiy one or more of these filters

sJournalCode
The code of the actual journal you want to select from. Eg. STANDARD
sEmployeeCode
If you only want data from a specific employee you can use this parameter
dtStartDate
First date in a date range 
dtEndDate
Last date in a date range
If you don't specify any parameters you will get all but be aware this can be a huge dataset.

Get Journal Line Entry

This dataset gives you more detailed information about each time registration for a specific journal line. I can also include GPS info, which device has been used etc. You must pass the nJournalLineID parameter to this function which is the ID returned from GetJournalLine


Get Journal Line Break

This dataset gives you more detailed information about each break registration for a specific journal line. You must pass the nJournalLineID parameter to this function which is the ID returned from GetJournalLine


Get Journal Line Extra

This dataset gives you more detailed information about each extra that has been released for a specific journal line. You must pass the nJournalLineID parameter to this function which is the ID returned from GetJournalLine


Get Job Journal

This dataset gives you more detailed information about each job registration for a specific journal line. You must pass the nJournalLineID parameter to this function which is the ID returned from GetJournalLine


From database version 6.17.41