Generate Student Clearance Reports
This function allows the users to view the information about Leaving Certificate Collection by Students.
MOE_RPT_CL_004 – Leaving Certificate Collection
Role Involved: School Admin – Student Clearance (MOE_SCHL_ADMIN_STDNT_CL)
Navigate to Main Menu > Reporting Tools > Query > Query Viewer.
Select ‘Query Name’ from the drop-down list to Search.
Enter the Query Name. (Eg: MOE_RPT_CL_004 )
Click on the Search button.
Click on the Run to HTML link. (Eg: ‘MOE_RPT_CL_004’)
HTML: Will open a web page to enter the input to run the report. The report results will be displayed on the web page.
Excel: Will open a web page to enter the input to run the report. The report results will be opened in an Excel Worksheet
Click on the look-up icon to select the *Academic Institution value.
Click on the Campus look-up icon and select the Campus (School) the user belongs to or enter ‘%’ to select all the values in the lookup.
Click on the look-up icon to select the Academic Career or enter ‘%’ to select all the values in the lookup.
Click on the *From Date calendar icon to select the date range user wants to query.
Click on the *To Date calendar icon to select the date range user wants to query.
Click on the View Results button.
The Report Results will be displayed.
If required, the Report results can be downloaded to an Excel Spreadsheet by clicking on the Excel Spreadsheet link.
Notes:
MOE_RPT_CL_002_01 – O’ Level students after leaving school
Roles Involved: School Admin – Student Clearance, Department of Schools and Department of Planning (MOE_SCHL_ADMIN_STDNT_CL), (MOE_HQ_STDNT_CLEARANCE_OFFCR) and (MOE_DP_RPT)
Navigate to Main Menu > Reporting Tools > Query > Query Viewer.
Select ‘Query Name’ from the drop-down list to Search.
Enter the Query Name. (Eg: MOE_RPT_CL_002_01)
Click on the Search button.
Click on the Run to HTML link.
- HTML: Will open a web page to enter the input to run the report. The report results will be displayed on the web page.
- Excel: Will open a web page to enter the input to run the report. The report results will be opened in an Excel Worksheet
Click on the look-up icon to select the *Academic Institution value.
Click on the Campus look-up icon and select the Campus (School) the user belongs to or enter ‘%’ to select all the values in the lookup.
Click on the look-up icon to select the Academic Career or enter ‘%’ to select all the values in the lookup.
Click on the lookup icon to select the *Term.
Click on the lookup icon to select the *Session.
Click on the View Results button.
The Report Results will be displayed.
If required, the Report results can be downloaded to an Excel Spreadsheet by clicking on the Excel Spreadsheet link.
Notes:
MOE_RPT_CL_002_02 – A’ Level students after leaving school
Roles Involved: School Admin – Student Clearance, Department of Schools and Department of Planning (MOE_SCHL_ADMIN_STDNT_CL), (MOE_HQ_STDNT_CLEARANCE_OFFCR) and (MOE_DP_RPT)
Navigate to Main Menu > Reporting Tools > Query > Query Viewer.
Select ‘Query Name’ from the drop-down list to Search.
Enter the Query Name. (Eg: MOE_RPT_CL_002_02)
Click on the Search button.
Click on the Run to HTML link.
- HTML: Will open a web page to enter the input to run the report. The report results will be displayed on the web page.
- Excel: Will open a web page to enter the input to run the report. The report results will be opened in an Excel Worksheet
Click on the look-up icon to select the *Academic Institution value.
Click on the Campus look-up icon and select the Campus (School) the user belongs to or enter ‘%’ to select all the values in the lookup.
Click on the look-up icon to select the Academic Career or enter ‘%’ to select all the values in the lookup.
Click on the lookup icon to select the *Term.
Click on the lookup icon to select the *Session.
Click on the View Results button.
The Report Results will be displayed.
If required, the Report results can be downloaded to an Excel Spreadsheet by clicking on the Excel Spreadsheet link.
Notes:
MOE_RPT_CL_002_03 – PSR students after leaving school
Roles Involved: School Admin – Student Clearance, Department of Schools and Department of Planning (MOE_SCHL_ADMIN_STDNT_CL), (MOE_HQ_STDNT_CLEARANCE_OFFCR) and (MOE_DP_RPT)
Navigate to Main Menu > Reporting Tools > Query > Query Viewer.
Select ‘Query Name’ from the drop-down list to Search.
Enter the Query Name. (Eg: MOE_RPT_CL_002_03)
Click on the Search button.
Click on the Run to HTML link.
- HTML: Will open a web page to enter the input to run the report. The report results will be displayed on the web page.
- Excel: Will open a web page to enter the input to run the report. The report results will be opened in an Excel Worksheet
Click on the look-up icon to select the *Academic Institution value.
Click on the Campus look-up icon and select the Campus (School) the user belongs to or enter ‘%’ to select all the values in the lookup.
Click on the look-up icon to select the Academic Career or enter ‘%’ to select all the values in the lookup.
Click on the lookup icon to select the *Term.
Click on the lookup icon to select the *Session.
Click on the View Results button.
The Report Results will be displayed.
If required, the Report results can be downloaded to an Excel Spreadsheet by clicking on the Excel Spreadsheet link.
Notes:
