Centralised Contractor Certification Expiry Reporting Across Multiple Locations
Issue Summary
Customer would like Certification Managers to have a more centralised way to monitor contractor certifications that are due to expire across the locations they manage.
Unlike employees, contractors may be authorised to access multiple locations. A single contractor may therefore be associated with several sites, making it difficult to produce a consolidated certification expiry report based on location access.
Currently, using location-based reporting for contractors can result in the same contractor appearing against multiple sites. This can make reports repetitive and harder to review, particularly when need to monitor upcoming certification expiries across several locations.
The existing Certification Report allows users to filter by certification-related criteria, such as certification type, but this does not fully address the need to identify contractors based on the locations they are authorised to access.
Current Behaviour / Limitation
Employees can be filtered using their Home Location, providing a straightforward way to identify employees associated with a particular site.
Contractors can have access to multiple locations and are not necessarily assigned to one primary or Home Location.
A contractor with access to several sites may appear repeatedly when reporting is performed separately for each location.
The Certification Report does not currently provide a consolidated way to identify contractors based on all locations they are authorised to access, alongside their certification expiry details.
Users may need to run separate reports or export contractor location-access information and manually compare or consolidate it with certification records.
Requested Improvement
Introduce a centralised, location-access-based reporting option for contractor certification expiries.
Ideally, the report would:
Filter contractors by authorised location access – Allow Cert Managers to select one or multiple locations and identify contractors who have permission to access those sites, rather than relying on a single Home Location.
Include a managed locations option – Allow Site Owners to view contractors with access to the locations they manage, without having to select each site individually.
Avoid duplicate contractor records – Where a contractor has access to multiple selected locations, display their certification information once, with their relevant site access listed against their record.
Support multiple certification selections – Allow users to select multiple certifications or courses in one report, rather than running separate reports for each qualification.
Filter by expiry period – Allow users to select a predefined period, such as the next 30, 60 or 90 days, or enter a custom date range.
Provide a consolidated view – Display contractor details, certification names, expiry dates and relevant location-access information together in one report.
Expected Outcome
Certification Managers would have a single, consolidated view of contractors who have access to their managed locations and have certifications approaching expiry.
This would reduce duplicate records, minimise manual report consolidation and make it easier for teams to monitor contractor compliance across multiple sites.
Employees could continue to be reported using their Home Location, while contractors would be identified through their authorised location access.
Additional Context
OnLocation already supports assigning contractors access to multiple locations. It would be useful to explore whether this existing location-access information could also be used within Certification Reporting, rather than requiring contractors to be associated with one primary location for reporting purposes.
Reference:
07438557