Within the SelectHR Admin Tool, you can create data export definitions, build a data export and filter the results to suit your needs.
SQL criteria
To filter down the results in your data export, you can use the following SQL criteria:
Action | SQL criteria to insert in data export |
Return records equal to | = |
Return records that are not equal to | != |
Return records greater than | > |
Return records less than | < |
Return records less than or equal to | <= |
Return records greater than or equal to | >= |
Return records that are not equal to | <> |
Return records like | % |
Return records blank or empty | Is Null |
Return records dated from and to | Between '01/Jan/2008' And '04/Jul/2017' |
Search for any results that contain what you enter as content. Replace content with your searching term. | '%content%' |
Workflow status
Workflow statuses and their meanings in data exports and lists:
Workflow status | Status icon | Status meaning |
2 | ↻ | Pending Update: The system needs to run the holiday data refresh cycle. |
1 | ✔ | Live Record: The system has completed the holiday data refresh cycle and the record is active. |
0 | 🕒 | Pending Authorisation: The absence request needs approval. |
-1 | ⦵ | Declined: The approver declined the absence. |
-2 | ⨷ | Cancelled: The initiator cancelled the absence request. |
-3 | ⨷ | Soft Deleted: HR deleted the live absence records. |
To bring back live records only when creating a data export, enter 1 in the criteria field.
Use the person snapshot view
You can use the snapshot view in a data export to view many details related to an employee. To do this, next to the Person view in the schema, expand Views then double-click Snapshot.
The following fields can be found in the snapshot view:
Person Number
Appointment Number
First name
Surname
Post Name
Manager Name
Pattern Name
Start Date
End Date
Gender
Email
Continuous Service Date
Length of Service
This is one of the most versatile tools when connecting to other tables, for additional data such as absence history, holiday entitlement, and pay history data.
Run an export 'as of' a specific date
The data export feature in the admin tool cannot generate exports based on a specific date. For example, if you need to see all career records that were current on 1st January 2024, this would require a custom Crystal Report.