Progress SAPYR9 Student

This function allows the users to progress SAPYR9 student to their specialized plans which should only be done at the end of every final term of the year. Specialized plans for SAP Year 10 are as follows:

• Year 10 Art & Design (SCARDY10)
• Year 10 Business Administration (SCBSAY10)
• Year 10 Creative Media Production (SCCMPY10)
• Year 10 Hospitality (SCHOSY10)
• Year 10 IT User (SCITUY10)
• Year 10 Sports & Leisure (SCSALY10)

Note: Kindly refer to this document to view the type of Academic Program and Plan that is required to use SAPYR9 csv template in order to run the process.

• Generate List of SAPYR9 Student
• Create CSV (Comma delimited) File
• Upload SAPYR9 CSV File
• Verify Student Progression

Generate List of SAPYR9 Student

Roles Involved: School Student Registrar

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

2. User will be directed to Query Viewer search page

3. Enter “MOE_PR_SAPYR9” into the search field.

4. Click on the Search button.

5. The Search Results will appear at the bottom of the Query Viewer.

6. Click on the Excel link to view the report in excel format.

7. User will be directed to MOE_PR_SAPYR9 - Yr9 SAP stdnt window.

8. Click on the lookup button and select the Academic Institution.

9. Click on the lookup button and select the Campus.

Note: User should only be able to select and view reports on their own campus.

10. Click on the lookup button and select the Term.

Note: User should select the end of the term as students are only progressed at the end of the year. Example term 1530 for progressing students to year 2016.

11. Click on the View Results button to download the file in excel format.

↑ Back to Top

Create CSV (Comma delimited) File

Roles Involved: School Student Registrar

1. Open the downloaded excel file from the query MOE_PR_SAPYR9 result.

2. Delete the first row.

Note: Highlight the first row, then right-click and select Delete from the dropdown list.

3. Insert a new column before the Student ID.

Note: Right-click on the first column and select Insert from the dropdown list.

4. Fill in Process Instance as title in the new column.

5. Insert a new column before the Current Acad Prog.

Note: Right-click on the Current Acad Prog column and select Insert dropdown list.

6. Fill in Program Action as title in the new column.

7. Fill in New Acad Prog, New Acad Plan, and Class Section as title in the next three column after Current Acad Plan.

Note: The format for the file should look like this.

8. Enter PLNC for progressing student or DATA for retaining student as field in Program Action.

9. Enter SCSAP as field for New Acad Prog.

10. Enter the correct field for New Acad Plan. Example SCHOSY10, SCARDY10, SCBSAY10, SCSALY10, SCCMPY10, and SCITUY10.

11. Enter the correct field for Class Section.

Note: Class Section should only be maximum of 4 characters. Example 10A, 10XP, 10S1, and etc.

12. Save the file as .csv (Comma delimited).

↑ Back to Top

Upload SAPYR9 CSV File

Roles Involved: School Student Registrar

1. Navigate to Navigate to Main Menu > Student Admissions > Processing Applications > Student Progression.

2. User will be directed to Student Progression search page.

3. Click on Add a New Value tab.

4. Enter the Run Control ID. Format should be Code_Term_SAPYR9. Example 3030_1530_SAPYR9.

5. Click on the Add button.

6. User will be directed to the Student’s Progression page.

7. Click on the lookup button and select the Academic Career.

8. Click on the lookup button and select the Term.

Note: User should select the end of the term as students are only progressed at the end of the year. Example term 1530 for progressing students to year 2016.

9. Click on Upload File button.

10. Click on Choose File button to look for the .csv file containing the students’ progression details.

11. Click on the Upload button to attach the .csv file.

12. Click on the Run button to run the process for Student's Progression Program

13. Ensure the process name MOE_PRGSN_AE in Process Scheduler Request page is checked.

14. Click on OK button.

15. User will be directed back to the Student’s Progression page. Process Instance number will be provided, click on the Process Monitor link.

16. User will be directed to the Process List page and should be able to see that “Run Status: Queued” and “Distribution Status: N/A” for the process name MOE_PRGSN_AE.

17. At interval times, click on the Refresh button until user sees “Run Status: Success” and “Distribution Status: Posted”.

18. Click on the Details link that is to the right of the process name MOE_PRGSN_AE.

19. In the Process Detail page, click on the View Log/Trace link.

20. In the View Log/Trace page, click on the .log link.

21. User will be directed to the log file page where the Total number of input rows, No of successful uploaded rows, and No of Error rows will be shown

↑ Back to Top

Verify Student Progression

Roles Involved: School Student Registrar

1. Navigate to Main Menu > Records and Enrollment > Career and Program Information > Student Program/Plan.

2. In the Student Program/Plan page, search for a particular student by entering the Student ID.

3. Click on Search button.

4. User will be directed to the Student Program page.

5. Verify the Student Program details.

Note:

• Effective Date should be a day before the start of the term
• Program Action should be PLNC (Program Change)
• Academic Program should be the same as previous program
• Admit Term should be the same as previous record

6. Click on the Student Plan tab.

7. In the Student Plan page, verify the Student Plan details.

Note:

• Academic Plan should be Year 10 plan
• Declare Date should follow the Effective Date
• Requirement Term should follow the Admit Term

↑ Back to Top