Data Management
Export, reports & data audits
By Harry1 author76 articles
Data Export & Reports
Useful data export queries
- Data Export: Pending/Outstanding holiday requests for employeesData export to show all pending holiday requests.
- Find the data location for data export fieldsFind the location of a field to add to a data export or report.
- Create a custom report or data exportCreate a new report or export.
- Data Export: Overlapping absence data exportData export to show overlapping absences.
- Pay related reportsStandard pay history reports available in the document store.
- Troubleshoot Bradford Factor calculationsSteps to troubleshoot an incorrect Bradford Factor score.
- Data Export: Emergency contact informationData export to show all emergency contacts.
- Data Export: Exit Interview informationReporting on Exit Interview information.
- Data Export: Current employee detailsData export to show basic employee details.
- Standard Holiday reportsStandard holiday reports available in SelectHR.
- Data Export: List of leaversData export to show a list of leavers.
- Run GDPR reportsRun GDPR related reports
- Identify the schema, table and key number for use in an audit exportInformation on how to find fields to include in a data export
- Data Export: Employees and their assigned working patterns/schedulesData export to show all employees with their working pattern and schedules.
- Data Export: Employee passport numbers & expiry dates
- Data Export: All users and their last login time and dateData export to show all users and the last time they logged into SelectHR.
- Turnover and headcount reportsTurnover and headcount reports explained.
- Data Export: Employee holiday entitlementData export to show days and hours taken and remaining for each employee.
- Data Export: All holiday rule overrides on career history recordsData export to show all employee's who have a career level holiday rule override.
- Export definition error: Incorrect syntaxError message when creating a data export: Incorrect syntax
- Data Export: All running absence workflowsData export to show all running workflow.
- Data Export: Employee addressesData export of all employee addresses.
- Data Export: Employee absence history recordsData export to show absence history for an employee.
- Data export advanced filters
- Error opening crystal report: Failed to open the connectionError opening crystal report: Failed to open the connection.
- Crystal Reports: Application crashes when clicking open or saveApplication crashes when trying to open or save a crystal report.
- Save a data export onto a local machine or network drive instead of the hosted environmentUnable to save a document on PC when hosted.
- Calculations in Sickness and Sickness Cost ReportsCalculations used in the sickness cost reports.
- Data export tipsUseful tips to help when creating a data export.
- Error when trying to open non-default Crystal Report added to the website: You may not have permissions, or an error may have occurredUnable to open all reports: You may not have permissions, or an error may have occurred.
- Error when saving export/performing an import: This operation has been cancelled due to restrictions in effect on this computerError message when selecting a file for a data import.
- Bradford Factor ReportsStandard Bradford Factor reports available.
- View employee bank details reportsAccess standard bank details reports.
- Restrict access to data within a crystal reportRestrict access to data within a standard crystal report. Allow managers to only see their employees in a report.
- Review the work email assigned to all person recordsData export to show the email addresses of all person records.
- Reports failing when run from a batch job: The report to run has not been specified or could not be found.Reports failing when run from a batch job: The report to run has not been specified or could not be found.
- Error when trying to open a data export: Conversion failed or Execution Timeout ExpiredUnable to open a data export in the admin tool.
- Clicking view document fails to load Crystal Report or documentWhen clicking on a report to run, nothing happens; it fails to load with no error message.
- Error when exporting a Crystal Report: The system cannot find the path specifiedError when exporting Crystal Report: The system cannot find the path specified
- Data Export: All users, their assigned menu sets and assigned rolesData export to show all users, their assigned menu sets and assigned roles.
- Unable a open report from custom buttonUnable a open report from custom button which has been added to a menu set.
- Gender Pay Gap reportingConfiguring your system for Gender Pay Gap reporting.
- Data Export: All pay changes submitted to SelectPay for a specific employeeSee what pay information been submitted to SelectPay for an employee via a data export.
- Unable to open reports or choose date parametersUnable to choose a date when opening a crystal report. Unable to click on the icons when trying to open a report.
- Export or import Crystal reports in a hosted environmentExport, import and edit crystal reports in a hosted environment.
- Error: The report could not be loaded. You may not have permission.Unable to open reports from the website with the error: The report could not be loaded. You may not have permission.
- Data Export: Auditing User Account logins, Menu Set & Group AssignmentsData Export: Auditing User Account logins, Menu Set & Group Assignments.
- Create a data audit exportCreate a data export to identify who has inserted, updated or delete a record.
- Starters reportsStandard reports available to view new starter information.
- Standard leaver reportsStandard reports for leaver details.
- Equality and Diversity reportsStandard reports for equality and diversity.
- Connect Crystal reports (Hosted by Access)Create a database connection for Crystal Reports Developer report writer for Hosted customers.
- An employee is missing from a custom crystal reportEmployee is not visible in a custom crystal report.
- Run a data export definition from the websiteAdd the ability to run a data export directly from the website.
- Error when editing a data export: Conversion failed when converting date and/or time from characterError when editing criteria in a data export.
- Error when running report: Service unavailableError message when running a crystal report via the website.
- Standard employee reportsReports available in the employee folder of the document store.
- Quotation marks added to values when exporting data to ExcelUnderstand why quotation marks may be included in some values when exporting data to Excel and which characters trigger this behaviour.
- Create a data exportGuidance on creating custom data exports.
- Data Export: Employee bank detailsSQL code for exporting employee bank details.
Audit Exports
Run a query to audit a record
- Audit: Identify changes made to a pay history recordFind out who has made a change to a pay history record.
- Audit: Identify changes made to an Absence History record using an Audit Export in the Admin ToolAudit export to identify changes made to an absence record.
- Audit: Identify changes made to a career history recordA data export audit to identify changes made to a career record.
- Audit: Identify changes made to a Person Details record using the Audit Export function of the Admin ToolAudit changes made to a person details record.
- Audit: Identify changes made to an address history record using the audit export functionData export audit to see when/who changed an address.
- Audit: Identify changes made to an employee's Bank Details using an audit exportData export audit to see who has changed an employee's bank details and when.
- Identify changes made to an appointment history record using an audit exportRun an audit to identify changes made to an appointment history record.
- Audit: Identify changes made to a Holiday Addition recordRun an audit to see who created, edited or deleted a holiday addition.
Data Imports
Import data into SelectHR
- Error: INSERT statement exceeds the maximum number of 1000 row valuesError on data import: INSERT statement exceeds the maximum number of 1000 row values
- Import new employees in bulkImport new employees in bulk.
- Error during import: Incorrect Syntax near '[X]'Error during import: Incorrect Syntax near '[X]'
- Error: Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column informationError when trying to upload data into SelectHR: Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand
- Error: The following records could not be imported: Candidate #: (Person) String or binary data would be truncated.Error when importing new employees.
- Process a data importThe basics of making a data import to amend, update, correct or create data.
- Troubleshoot the employee import workflowLearn how the bulk employee import process works in SelectHR, how data is validated, and what to do when the import fails.
- Error when importing data: Failed to enable constraints. One or more rows contain values non-null, unique, or foreign-key constraintsError message when processing a data import in the admin tool.