The Expiring Certifications report uses the Employee Certifications topic to display a list of employee certifications that are going to expire in the next 30 days.
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Employee | Yes | A to Z | |
| Days Until Expiration | Smallest to largest | ||
| Certification | Ascending | ||
| Job Assignment | Ascending | ||
| Location | Ascending | ||
| Effective End | Oldest to newest |
Custom Fields
Days Until Expiration
The Days Until Expiration custom field displays the number of days remaining before the certification expires. It uses the following expression:
DATEDIFF(dd, CURRENT_TIMESTAMP, LMSEmployeeCertification.EffectiveEnd)
Filters
The template includes the following filters: