Query to be Scheduled
Query names listed in the table below are to be scheduled using the steps below as it deals with a large amount of data.
Roles Involved: Reports for Department of Planning
Schedule Query
Navigate to Main menu > Reporting Tools > Query > Schedule Query.
User will be directed to the Schedule Query page.
Click on Add a New Value tab.
Enter the Run Control ID, enter any value without spacing (e.g. RPT_RP_001).
Click on the Add button.
User will be directed to the Schedule Query page.
Enter the Query Name.
Click on the Search button.
User will be directed to the Scheduled Query Search Page which shows the search results.
Click on the Query link to select the report or click Cancel button to return back to Schedule Query page.
User will be directed back to the Schedule Query page.
Click on the Run button to run the psquery process.
Ensure the process name PSQUERY in Process Scheduler Request page is checked.
Click on OK button.
User will be directed back to Schedule Query page. Take note of process instance number and click on the Process Monitor link.
User will be directed to Process List Page and should be able to see that “Run Status: Queued” and “Distribution Status: N/A” for the process name PSQUERY.
At interval times, click on the Refresh button until user sees the “Run Status: Success” and “Distribution Status: Posted”
Click on the Details link that is to the right of the process name PSQUERY.
In the Process Details page, click on the View Log/Trace link.
In the View Log/Trace page, click on the .csv link to download the file.
Note: Refer to the table at the end of the page for the list of Query Names.
List of Queries
| Report ID | Report Name |
|---|---|
| MOE_RPT_RP_001 | No. Of Students In Pre-School |
| MOE_RPT_RP_002 | No. Of Students In Primary School |
| MOE_RPT_RP_003 | No. Of Students In Secondary Schools |
| MOE_RPT_RP_004 | No. Of Students In Sports Schools |
| MOE_RPT_RP_005 | No. Of Students In Sixth Form Schools |
| MOE_RPT_RP_006 | No. Of Teachers In Pre-Schools |
| MOE_RPT_RP_007 | No. Of Teachers In Primary Schools |
| MOE_RPT_RP_008 | No. Of Teachers In Secondary Schools |
| MOE_RPT_RP_009 | No. Of Teachers In Sports Schools |
| MOE_RPT_RP_010 | No. Of Teachers In Sixth Form Schools |
| MOE_RPT_RP_011 | Survival Rate (Pre-School) |
| MOE_RPT_RP_012 | Survival Rate (Primary School) |
| MOE_RPT_RP_013 | Survival Rate (Secondary And Sports School) |
| MOE_RPT_RP_014 | Survival Rate (Sixth Form) |
| MOE_RPT_RP_015 | Summary |
| MOE_RPT_RP_016 | No. Of Female/Male Teachers |
| MOE_RPT_RP_017 | Statistics On Salary Scale & Terms Of Service |
| MOE_RPT_RP_018 | Statistics On Teacher's Qualification |
| MOE_RPT_RP_019 | Number Of Teachers By Level And District |
| MOE_RPT_RP_020 | Teachers' Academic Qualification And Terms Of Service By Level |
| MOE_RPT_RP_021 | Teachers' Age Group By Level |
| MOE_RPT_RP_022P | Enrolment By Level And District (Pre-School And Primary) |
| MOE_RPT_RP_022S | Enrolment By Level And District (Secondary) |
| MOE_RPT_RP_022L | Enrolment By Level And District (Sixth Form) |
| MOE_RPT_RP_023P | Enrolment By Race And Level (Pre-School And Primary) |
| MOE_RPT_RP_023S | Enrolment By Race And Level (Secondary) |
| MOE_RPT_RP_023L | Enrolment By Race And Level (Sixth Form) |
| MOE_RPT_RP_024P | Number Of Classes, Enrolment And Number Of Teachers By Level (Pre-School And Primary) |
| MOE_RPT_RP_024S | Number Of Classes, Enrolment And Number Of Teachers By Level (Secondary) |
| MOE_RPT_RP_024L | Number Of Classes, Enrolment And Number Of Teachers By Level (Sixth Form) |
| MOE_RPT_RP_025 | Enrolment, Number Of Classes And Students-Class Ratio By Level |
| MOE_RPT_RP_026 | Number Of Teachers, Number Of Classes And Teacher-Class Ratio By Level |
| MOE_RPT_RP_027 | Enrolment, Number Of Teachers And Student-Teacher Ratio By Level |
| MOE_RPT_RP_028 | Number Of Schools By Level And District |
| MOE_RPT_RP_029 | No. Of Students Enrolment To Government School (Primary) |
| MOE_RPT_RP_030 | No. Of Students Enrolment To Government School (Secondary) |
| MOE_RPT_RP_031 | No. Of Students Enrolment To Government School (Sixth Form) |
| MOE_RPT_RP_032 | Statistics Report Of Applicants Categorized By Date Of Birth/ Gender/ Race/ School/ Cluster Or Zone/District/ Nationality/ Citizenship/ Religion |
| MOE_RPT_RP_033 | Enrolment By Academic Career And District |
| MOE_RPT_RP_034P | Enrolment By Age And Level (Pre-School And Primary) |
| MOE_RPT_RP_034S | Enrolment By Age And Level (Secondary) |
| MOE_RPT_RP_034L | Enrolment By Age And Level (Sixth Form) |
| MOE_RPT_RP_035 | Number Of Students By Schools/Catchment Area/ District/ Gender/ Level/ Zone/Cluster |
| MOE_RPT_RP_036 | No. Of Students In Each Programme In Secondary Schools |
| MOE_RPT_RP_037 | No. Of Students In Each Stream In Sixth Form Schools |
| MOE_RPT_RP_038 | No. Of Students Taking Core Subjects/General Subjects/Elective Subjects |
| MOE_RPT_RP_039 | No. Of Students Admitted/Promoted, Repeat/Enrolled |
| MOE_RPT_RP_040 | Student Transition |
| MOE_RPT_RP_041 | Art Stream To Science Stream Ratio |
| MOE_RPT_RP_042 | No. Of Student Progression/Survival (Pre-School) |
| MOE_RPT_RP_043 | No. Of Student Progression/Survival (Primary) |
| MOE_RPT_RP_044 | No. Of Student Progression/Survival (Secondary) |
| MOE_RPT_RP_045 | No. Of Student Progression/Survival (Sports School) |
| MOE_RPT_RP_046 | No. Of Student Progression/Survival (Sixth Form) |
| MOE_RPT_RP_047P | Number Of Classes, New Students And Repeaters (Pre-School And Primary) |
| MOE_RPT_RP_047S | Number Of Classes, New Students And Repeaters (Secondary) |
| MOE_RPT_RP_047L | Number Of Classes, New Students And Repeaters (Sixth Form) |