Generate Attendance Statistics Reports

This function allows the users to view the Attendance Statistics Reports.

• Monthly Statement Report - PP1
• Monthly Statement Report - PP2
• Monthly Statement Report - PP3
• Monthly Attendance Statistics Summary
• Monthly National Statistics
• MOE_RPT_AT_003 - Eligibility for the Transport Allowance
• MOE_RPT_AT_004 - List of Absentee Students
• MOE_RPT_AT_005 - Students below Attendance Threshold
• MOE_UNMRKD_ATTEND - Report for Unmarked Attendance

Monthly Statement Report - PP1

Roles Involved: Class Teacher, Principal, School Student Registrar and MOE – Manage Attendance Officer (MOE_SCHL_CLASS_TEACHER), (MOE_SCHL_PRINCIPAL), (MOE_SCHL_ADMIN_ATTDNCE) and (MOE_HQ_ATTENDANCE_OFFR)

1. Navigate to Main Menu > Curriculum Management > Attendance Roster > Reports > Monthly Statement Report PP1.

2. To run process to generate the report, click on the Add a New Value tab.

3. Enter the Run Control ID to identify the process run to generate the report.

Note:
Run Control ID is a unique ID assigned to identify the data entered to run the process to generate the report. The ID cannot contain any spaces, hyphens ‘-‘ and underscores ‘_’ between words.

4. Click on the Add button.

5. User will be directed to the Process page.

6. Click on the lookup to select the *Academic Career.

7. Click on the lookup to select the *Campus which school the user has access to.

8. Click on the lookup to select the *Term.

9. Click on the lookup to select the *Session.

10. Enter the *Month for which the report is run for and belongs to the selected term.

11. Click on the lookup to select the Course ID matching the *Year of study of the class for which the attendance statistics report needs to be created for.

12. Click on the Save button.

13. Click on the Run button.

14. Select the process, Attendance Report from the process list.

15. Click on the OK button to select the process and run it.

16. Once the process has begun to run, a Process Instance number will be assigned.

17. Click on the Process Monitor to check the Status of the process run.

18. User will be directed to the Process Monitor page.

19. Monitor the process against the Process Instance number and initially the Run Status and Distribution Status are ‘Queued’ and ‘N/A’.

20. Click on Refresh button to view the refreshed Run Status. Continue to click until Run Status changes to ‘Success’ and Distribution Status goes to ‘Posted’.

21. Once the Run status goes ‘Success’ and distribution Status goes to ‘Posted’, click on the Go back to Monthly Statement Report – PP1 link.

22. To fetch the Monthly Statement Report – PP1, click on the Report Manager link.

23. Click on the Administration tab.

24. Click on the MOE_AT_STDNT – MOE_AT_STDNT.xlsx file created against the Prcs Instance of the process which was just run to generate the report.

25. Click on the .xlsx(Excel) file created.

26. A prompt will be displayed suggesting to the user to either save or open the excel sheet to view the generated report. Select the Save option.

27. Open the saved excel sheet to view the Monthly Statement Report- PP1.

↑ Back to Top

Monthly Statement Report PP2

Roles Involved: Class Teacher, Principal, School Student Registrar and MOE – Manage Attendance (MOE_SCHL_CLASS_TEACHER), (MOE_SCHL_PRINCIPAL), (MOE_SCHL_ADMIN_ATTDNCE) and (MOE_HQ_ATTENDANCE_OFFCR)

1. Navigate to Main Menu > Curriculum Management > Attendance Roster > Reports > Monthly Statement Report PP2.

2. To run process to generate the report, click on the Add a New Value tab.

3. Enter the Run Control ID to identify the process run to generate the report.

Note:
Run Control ID is a unique ID assigned to identify the data entered to run the process to generate the report. The ID cannot contain any spaces, hyphens ‘-‘ and underscores ‘_’ between words.

4. Click on the Add button.

5. User will be directed to the Process page.

6. Click on the lookup to select the *Academic Career.

7. Click on the lookup to select the *Campus which school the user has access to.

8. Click on the lookup to select the *Term.

9. Click on the lookup to select the *Session.

10. Enter the *Month for which the report is run for and belongs to the selected term.

11. Click on the Save button.

12. Click on the Run button.

13. Select the process, MOE_ATMNT_AE from the process list.

14. Click on the OK button to select the process and run it.

15. Once the process has begun to run, a Process Instance number will be assigned.

16. Click on the Process Monitor to check the Status of the process run.

17. User will be directed to the Process Monitor page.

18. Monitor the process against the Process Instance number and initially the Run Status and Distribution Status are ‘Queued’ and ‘N/A’.

19. Click on Refresh button to view the refreshed Run Status. Continue to click until Run Status changes to ‘Success’ and Distribution Status goes to ‘Posted’.

20. Once the Run status goes ‘Success’ and distribution Status goes to ‘Posted’, click on the Go back to Monthly Statement Report – PP2 link.

21. To fetch the Monthly Statement Report – PP2, click on the Report Manager link.

22. Click on the Administration tab.

23. Click on the MOE_ATMNT_AE.TXT file created against the Prcs Instance of the process which was just run to generate the report.

24. Click on the .xlsx(Excel) file created.

25. A prompt will be displayed suggesting to the user to either save or open the excel sheet to view the generated report. Select the Save option.

26. Open the saved excel sheet to view the Monthly Statement Report- PP2.

↑ Back to Top

Monthly Statement Report - PP3

Roles Involved: Class Teacher, Principal, School Student Registrar and MOE – Manage Attendance Officer (MOE_SCHL_CLASS_TEACHER), (MOE_SCHL_PRINCIPAL), (MOE_SCHL_ADMIN_ATTDNCE) and (MOE_HQ_ATTENDANCE_OFFCR)

1. Navigate to Main Menu > Curriculum Management > Attendance Roster > Reports > Monthly Statement Report PP3.

2. To run process to generate the report, click on the Add a New Value tab.

3. Enter the Run Control ID to identify the process run to generate the report.

Note:
Run Control ID is a unique ID assigned to identify the data entered to run the process to generate the report. The ID cannot contain any spaces, hyphens ‘-‘ and underscores ‘_’ between words.

4. Click on the Add button.

5. User will be directed to the Process page.

6. Click on the lookup to select the *Academic Career.

7. Click on the lookup to select the *Campus which school the user has access to.

8. Click on the lookup to select the *Term.

9. Click on the lookup to select the *Session.

10. Enter the *Month for which the report is run for and belongs to the selected term.

11. Click on the Save button.

12. Click on the Run button.

13. Select the process, MOE_ATMNT3_AE from the process list.

14. Click on the OK button to select the process and run it.

15. Once the process has begun to run, a Process Instance number will be assigned.

16. Click on the Process Monitor to check the Status of the process run.

17. User will be directed to the Process Monitor page.

18. Monitor the process against the Process Instance number and initially the Run Status and Distribution Status are ‘Queued’ and ‘N/A’.

19. Click on Refresh button to view the refreshed Run Status. Continue to click until Run Status changes to ‘Success’ and Distribution Status goes to ‘Posted’.

20. Once the Run status goes ‘Success’ and distribution Status goes to ‘Posted’, click on the Go back to Monthly Statement Report – PP3 link.

21. To fetch the Monthly Statement Report – PP3, click on the Report Manager link.

22. Click on the Administration tab.

23. Click on the Monthly Statement Report – PP3 .TXT file created against the Prcs Instance of the process which was just run to generate the report.

24. Click on the .xlsx(Excel) file created.

25. A prompt will be displayed suggesting to the user to either save or open the excel sheet to view the generated report. Select the Save option.

26. Open the saved excel sheet to view the Monthly Statement Report- PP3.

↑ Back to Top

Monthly Attendance Statistics Summary

Roles Involved: Principal, School Student Registrar and MOE – Manage Attendance Officer (MOE_SCHL_PRINCIPAL), (MOE_SCHL_ADMIN_ATTDNCE) and (MOE_HQ_ATTENDANCE_OFFCR)

1. Navigate to Main Menu > Curriculum Management > Attendance Roster > Reports > Monthly Attendance Statistics.

2. To run process to generate the report, click on the Add a New Value tab.

3. Enter the Run Control ID to identify the process run to generate the report.

Note:
Run Control ID is a unique ID assigned to identify the data entered to run the process to generate the report. The ID cannot contain any spaces, hyphens ‘-‘ and underscores ‘_’ between words.

4. Click on the Add button.

5. User will be directed to the Process page.

6. Click on the lookup to select the *Academic Career.

7. Click on the lookup to select the *Campus which user has access to.

8. Click on the lookup to select the *Term.

9. Click on the lookup to select the *Session.

10. Enter the *Month for which the report is run and belongs to the selected term.

11. Click on the Save button.

12. Click on the Run button.

13. User will be directed to the Process Scheduler Request page.

14. Select the process, MOE_AT_PP4 from the process list.

15. Click on the OK button to select the process and run it.

16. Once the process has begun to run, a Process Instance number will be assigned.

17. Click on the Process Monitor link to check the Status of the process run.

18. User will be directed to the Process Monitor page.

19. Monitor the process against the Process Instance number and initially the Run Status and Distribution Status are ‘Queued’ and ‘N/A’.

20. Click on the Refresh button to view the refreshed Run Status. Continue to click until Run Status changes to ‘Success’ and Distribution Status goes to ‘Posted’.

21. Once the Run status goes ‘Success’ and distribution Status goes to ‘Posted’, click on the Go back to Monthly Attendance Statistics link.

22. To fetch the Monthly Attendance Statistics, click on the Report Manager link.

23. Click on the Administration tab.

24. Click on the Monthly Attendance Summary .TXT file created against the Prcs Instance of the process which was just run to generate the report.

25. Click on the .xlsx(Excel) file created.

26. A prompt will be displayed suggesting to the user to either save or open the excel sheet to view the generated report. Select the Save option.

27. Open the saved excel sheet to view the Monthly Attendance Summary.

↑ Back to Top

Monthly National Statistics

Roles Involved: MOE – Manage Attendance Officer (MOE_HQ_ATTENDANCE_OFFCR)

1. Navigate to Main Menu > Curriculum Management > Attendance Roster > Reports > Monthly National Statistics.

2. To run process to generate the report, click on the Add a New Value tab.

3. Enter the Run Control ID to identify the process run to generate the report.

Note:
Run Control ID is a unique ID assigned to identify the data entered to run the process to generate the report. The ID cannot contain any spaces, hyphens ‘-‘and underscores ‘_’ between words.

4. Click on the Add button.

5. User will be directed to the Process page.

6. Click on the lookup to select the *Academic Career.

7. Click on the lookup to select the *Term.

8. Click on the lookup to select the *Session.

9. Enter the *Month for which the report is run and belongs to the selected term.

10. Click on the Save button.

11. Click on the Run button.

12. User will be directed to the Process Scheduler Request page.

13. Select the process, MOE_PP5_1 from the process list.

Note:
There are 5 reports under the Monthly National Statistics Report.

1. MOE_PP5_1 – Salary Grade Summary

2. MOE_PP5_2 – Salary Grade by Cluster

3. MOE_PP5_3 – Teacher Count by Cluster

4. MOE_PP5_4 - Student and Teacher Count by Cluster

5. MOE_PP5_5 – Student and Teacher Count Summary

Note:
A separate report will be generated for each of the zone/cluster separately for MOE_PP5_2 (Salary Grade by Cluster) and MOE_PP5_4 (Student and Teacher Count by Cluster).

14. Click on the OK button to select the process.

15. Once the process has begun to run, a Process Instance number will be assigned.

16. Click on the Process Monitor link to check the Status of the process run.

17. User will be directed to the Process Monitor page.

18. Monitor the process against the Process Instance number and initially the Run Status and Distribution Status are ‘Queued’ and ‘N/A’.

19. Click on the Refresh button to view the refreshed Run Status. Continue to click until Run Status changes to ‘Success’ and Distribution Status goes to ‘Posted’.

20. Once the Run status goes ‘Success’ and distribution Status goes to ‘Posted’, click on the Go back to Monthly National Statistics link.

21. To fetch the Monthly Attendance Statistics, click on the Report Manager link.

22. Click on the Administration tab.

23. Click on the MOE_PP5_1 .TXT file created against the Process Instance of the process which was just run to generate the report.

24. Click on the .xlsx(Excel) file created.

25. A prompt will be displayed suggesting to the user to either save or open the excel sheet to view the generated report. Select the Save option.

26. Open the saved excel sheet to view the Monthly National Statistics for PP5_1.

Note:
Repeat steps 12 to 29 to fetch the rest of the Monthly National Statistics reports.

↑ Back to Top

MOE_RPT_AT_003 - Eligibility for the Transport Allowance

Roles Involved: Class Teacher, Principal and School Student Registrar (MOE_SCHL_CLASS_TEACHER), (MOE_SCHL_PRINCIPAL) and (MOE_SCHL_ADMIN_ATTDNCE)

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

2. Select ‘Query Name’ from the dropdown list to Search.

3. Enter ‘MOE_RPT_RPT_AT_003’ as the *Query Name.

4. Click on the Search button.

5. The search results will display the query.

6. Click on HTML link to open a web page to enter the input to run the report and the results will be displayed on the web page.
   Click on Excel link to open a web page to enter the input to run the report and the results will be opened in an Excel worksheet.

7. Click on the Run to HTML link.

8. User will be directed to the Eligibility for the Transport Allowance Report.

9. Click on the lookup icon to select the *Academic Institution value.

10. Click on the lookup icon to select the Campus or School or enter ‘%’ sign to select all the values in the lookup.

11. Click on the lookup icon to select the Academic Career or enter ‘%’ sign to select all the values in the lookup.

12. Click on the lookup icon to select the Academic Program or enter ‘%’ sign to select all the values in the lookup.

13. Click on the lookup icon to select the Academic Plan or enter ‘%’ sign to select all the values in the lookup.

14. Click on the lookup icon to select the *Term.

15. Click on the lookup icon to select the *Session.

16. Click on the lookup icon to select the *Month

17. Click on the View Results button.

18. The Report Results will be displayed.

19. Click on the Excel Spread Sheet link to download the Report Results in an Excel Spread Sheet.

↑ Back to Top

MOE_RPT_AT_004 - List of Absentee Students

Roles Involved: Class Teacher, Principal and School Student Registrar (MOE_SCHL_CLASS_TEACHER), (MOE_SCHL_PRINCIPAL) and (MOE_SCHL_ADMIN_ATTDNCE)

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

2. Select ‘Query Name’ from the dropdown list to Search.

3. Enter ‘MOE_RPT_RPT_AT_004’ as the *Query Name.

4. Click on the Search button.

5. The search results will display the query.

6. Click on HTML link to open a web page to enter the input to run the report and the results will be displayed on the web page.
   Click on Excel link to open a web page to enter the input to run the report and the results will be opened in an Excel worksheet.

7. Click on the Run to HTML link.

8. User will be directed to the List of Absentee Students Report.

9. Click on the lookup icon to select the *Academic Institution value.

10. Click on the lookup icon to select the Campus or School or enter ‘%’ sign to select all the values in the lookup.

11. Click on the lookup icon to select the Academic Career or enter ‘%’ sign to select all the values in the lookup.

12. Click on the lookup icon to select the Academic Program or enter ‘%’ sign to select all the values in the lookup.

13. Click on the lookup icon to select the Academic Plan or enter ‘%’ sign to select all the values in the lookup.

14. Click on the lookup icon to select the *Term.

15. Click on the lookup icon to select the *Session.

16. Click on the lookup icon to select the *Month

17. Click on the View Results button.

18. The Report Results will be displayed.

19. Click on the Excel Spread Sheet link to download the Report Results in an Excel Spread Sheet.

↑ Back to Top

MOE_RPT_AT_005 - Students below Attendance Threshold

Roles Involved: Class Teacher, Principal and School Student Registrar (MOE_SCHL_CLASS_TEACHER), (MOE_SCHL_PRINCIPAL) and (MOE_SCHL_ADMIN_ATTDNCE)

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

2. Select ‘Query Name’ from the dropdown list to Search.

3. Enter ‘MOE_RPT_RPT_AT_005’ as the *Query Name.

4. Click on the Search button.

5. The search results will display the query.

6. Click on HTML link to open a web page to enter the input to run the report and the results will be displayed on the web page.
   Click on Excel link to open a web page to enter the input to run the report and the results will be opened in an Excel worksheet.

7. Click on the Run to HTML link.

8. User will be directed to the Students below Attendance Threshold Report.

9. Click on the lookup icon to select the *Academic Institution value.

10. Click on the lookup icon to select the Campus or School or enter ‘%’ sign to select all the values in the lookup.

11. Click on the lookup icon to select the Academic Career or enter ‘%’ sign to select all the values in the lookup.

12. Click on the lookup icon to select the *Term.

13. Click on the lookup icon to select the *Session.

14. Click on the View Results button.

15. The Report Results will be displayed.

16. Click on the Excel Spread Sheet link to download the Report Results in an Excel Spread Sheet.

↑ Back to Top

MOE_UNMRKD_ATTEND - Report for Unmarked Attendance

Roles Involved: Class Teacher, Principal and School Student Registrar (MOE_SCHL_CLASS_TEACHER), (MOE_SCHL_PRINCIPAL) and (MOE_SCHL_ADMIN_ATTDNCE)

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

2. Select ‘Query Name’ from the dropdown list to Search.

3. Enter ‘MOE_UNMRKD_ATTEND’ ’ as the *Query Name.

4. Click on the Search button.

5. The search results will display the query.

6. Click on HTML link to open a web page to enter the input to run the report and the results will be displayed on the web page.
   Click on Excel link to open a web page to enter the input to run the report and the results will be opened in an Excel worksheet.

7. Click on the Run to HTML link.

8. User will be directed to the Unmarked Attendance Report.

9. Click on the lookup icon to select the *Academic Institution value.

10. Click on the lookup icon to select the *Term.

11. Click on the lookup icon to select the *Session.

12. Click on the lookup icon to select the Campus or School or enter ‘%’ sign to select all the values in the lookup.

13. Click on the lookup icon to select the Subject to select all the values in the lookup

14. Click on the lookup icon to select the Year of Study or enter ‘%’ sign to select all the values in the lookup..

15. 13. Click on the lookup icon to select the Class or enter ‘%’ sign to select all the values in the lookup.

16. Click on the View Results button.

17. The Report Results will be displayed.

18. Click on the Excel Spread Sheet link to download the Report Results in an Excel Spread Sheet.

↑ Back to Top