If you need to report for which employees have confirmed they’ve read your HR policies, you can use the export function in SelectHR to pull this data directly from the system.
To create the export, follow the steps below.
In the Admin Tool, click Import/Export Data.
Click Create an export definition.
Click Select the data to export.
Change the database to SelectCDMS.
Click the SQL tab, then delete Select*.
Copy the following SQL query into the blank space;
Select docnot.[Notification Number], docnot.[Item Version Number], docnot.[Person Number], dbo.[Document Confirmation].Required, docnot.Status, docnot.[Last Notified], iv.[Item Number], pd.[Informal Name], iv.Title From dbo.[SelectHR.Person.Details] As pd Left Join (dbo.[Item Version] As iv Left Join dbo.[Document Notifications] As docnot On iv.[Item Version Number] = docnot.[Item Version Number] Right Join dbo.[Document Confirmation] On iv.[Item Version Number] = dbo.[Document Confirmation].[Item Version Number]) On pd.[Person Number] = docnot.[Person Number] Inner Join dbo.[SelectHR.Employee.Person] On pd.[Person Number] = dbo.[SelectHR.Employee.Person].[Person Number]