Generating Certificate Expiry Report

Generate Certificate Expiry Report

This page enables the user to generate the certification Report for employees based on some filters. The Report displays the certification details of employees.

Select the “Generate Certificate Expiry Report” activity under the “Manage Employee Roster” business component.

The “Generate Certificate Expiry Report” page appears.

Enter the following fields in the “Search Criteria” group box:

Expires From/To Date	The starting date from which the certificate expiry report is to be generated.
	The ending date until which the certificate expiry report is to be generated.
Employee #	The employee whose certificate expiry report is to be generated. Help facility available.
Certification Category	Use the drop-down list box to select the certification category of the employee. The system lists all the ‘active’ quick codes defined under Process Variable ‘Certification Category’ and Business Process ‘HR Setup’ in the “Maintain Quick Codes” activity of the “HR General Information” business component.
Work Center	Use the drop-down list box to select the work center of the employee. The system lists all the ‘active’ workcenters defined in the “Create Work Center” activity of the “Work Center” business component.
Organizational Unit	Use the drop-down list box to select the login Organization unit of the user. The system lists the login Organization unit of the user.
Report Generation Option	Use the drop-down list box to specify the report generation option. The system lists the following values: § Flight Operations – Displays the report of all employees with job family mapped to the role "Pilot", "Co-Pilot", "Instructor", "Crew" defined in “Set Sales Process Parameters” activity of the “Customer” business component. § Maintenance – Displays the report of all employees those are not under flight operations. The system displays the value “Flight Operations”, by default on page launch.

Click the “Generate Certificate Expiry Report” link to generate the certificate expiry Report for employees.

The report is generated with all certificate expiry details as columns and all employees in report generation criteria as rows.

The color of the columns is generated as below:

· Green - If the report is being generated before "Currency Date".

· Amber - If the report is being generated between the “Currency Date” and “Valid Till Date”.

· Red - If the report is being generated after “Valid Till Date”.

Note: If no employee is selected the report displays all employees based on Report Generation Option.

If an employee is selected, work center is disregarded and the report is generated for that employee.

If an employee is selected, report generation option is disregarded and the report is generated for that employee.