Skip to main content

B0039 Employee Licenses, Certifications and Registrations

Report Description

B0039: Employee Licenses, Certifications & Registrations report counts the total number of employees holding specific licenses and the total number of expired licenses by org unit.

Report Location

PA: Certification and Qualifications

Report Uses

This report counts the total number of employees holding specific licenses and the total number of expired licenses by org unit.
This report is used to monitor the validity of required licenses, certifications and registrations that employees need for their job functions.

How to Generate This Report

This report is generated after selecting values for the mandatory prompts.  All mandatory prompts must have values selected before the Run Icon can be used to generate the report. Mandatory prompts can be identified as mandatory by the exclamation mark inside of the yellow-orange triangle, the square with the checkmark, or the display of (Mandatory).  Detailed instructions for interaction with each prompt can be found on the Web Intelligence Prompt List on the OSC website.

The Mandatory prompts for this report are:  

  • Organizational Unit
  • Certificate From Day (Single Value, Mandatory)
  • Certificate To Day (Single Value, Mandatory)

This report can also be further limited by utilizing the Optional prompts to further limiting the amount of data that retrieved into the body of the report. Optional prompts are indicated as optional in parentheses beside the prompt.   
The Optional prompts are: 

  • Certificate Type(s) – (Optional)
  • Employee(s) PersNo. – (Optional)
  • Employee Group(s) – (Optional)
  • Employee Subgroup(s) – (Optional)

Exclusion prompts exclude specified data by default while allowing customers the flexibility of changing them when necessary. Exclusion prompts are identified by the term Exclude followed by the prompt.   

The Exclusion prompts are: 

  • Exclude Employee Subgroup (Contractor, National Guard) G1; G5

Initial Layout

The report is generated with a list of Organizational No. of Employees by Employee Subgroup for each month. This is a sample of the report:

Available Objects

This is a list of the available objects that can be added to the report, from the Document Dictionary once in the Design mode:

Dimensions

  • Cert. Effective From
  • Cert. Effective To
  • Cert. Id.
  • Cert. Type
  • Certificate Category
  • Changed By
  • Changed On
  • Employee
  • Employee Group
  • Employee Subgroup
  • Employee’s Name
  • Issuing Auth.
  • Job
  • Organizational Unit
  • Original Hire Date
  • Personnel Area
  • Position

Measures

  • Number of Records

Variables

  • Prompt Response Certificate From Day
  • Prompt Response Certificate To Day
  • Prompt Response Certificate Type
  • Prompt Response Employee Group
  • Prompt Response Employee PersNo
  • Prompt Response Employee Subgroup
  • Prompt Response Exclude Employee Subgroup
  • Prompt Response Organizational Unit
  • License Expired

Special Report Considerations/Features

  • License Expired is determined based on the condition that if the ‘Certificate Effective To’ date is prior to system current date.
  • Employee Subgroup G1 – Contractors and G5 – National Guards are excluded from the report. Refer the Exclusion Prompt “Exclude Employee SubGroup (Contractors, National Guard) G1; G5” for details.
  • Employment Status - Active. Report runs for Active Employees only.
  • Report displays a record only for Certificate Types assigned to an Employee License, Certification or Registration. Records with no Certificate Types assigned are not displayed.

First Published

Last Updated