Generate Report and Queries

This function allows the users to generate reports and queries.

• Generate School Facility List
• Generate School Class list

Generate School Facility List

Roles Involved: School Timetabling Admin & Ministry of Education – Department of Schools Administrator

Note: School users can only see facilities under their schools. MOE users can see the facilities for all schools.

1. Navigate to Main menu > Reporting Tools > Query > Query Viewer

2. Select Query Name from the Search By drop-down menu.

3. Enter MOE_TT_FACSTATS in the Begins with field.

4. Click on the Search button.

5. The specified query will be listed down in the search result.

6. Click on the HTML link.

7. You will be directed to MOE_TT_FACSTATS page.

8. A list of the Facility information statistics will be listed down.

9. Click on the Excel Spreadsheet link.

10. Click on OK to Save the report.

11. View report in Excel.

↑ Back to Top

Generate School Class list

Role Involved: School Timetabling Admin

1. Navigate to Main menu > Reporting Tools > Query > Query Viewer

2. Select Query Name from the Search By drop-down menu.

3. Enter MOE_TT_CLS in the Begins with field.

4. Click on the Search button.

5. The specified query will be listed down in the search result.

6. Search for the required query name and click on the HTML link.

7. You will be directed to MOE_TT_CLS page.

8. Select or Enter the values in the Institution, Career, Campus, Term and Session fields.

9. Click on the View Result button.

10. A list of the classes under the specified academic, career, term, session and school will be listed down.

11. Click on the Excel Spreadsheet link.

12. Click on OK to Save the report.

13. View report in Excel.

↑ Back to Top