School Course Marks (SCM) Validation Report (Obsolete)
This report is replaced by the Special Function Manage SCM/CTS Validations.
Introduction
This report provides data validations for student course records while also updating the Completion and Funding Status of an enrollment, excluding manually entered marks. It is recommended to validate and correct data after storing grades to report marks to the Department of Education.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Students to Include | Indicate which students to include in the report by selecting one of the following options:
Note: If running the report for a single student, or group of students, select the students prior to running report. |
Store Code from Final Grades Setup | Choose the store code from the popup menu. Ensure that you select a Store Code value for which grades have been stored in the Stored Grades table. |
Term | Choose the term from the popup menu. By default, the full year term is processed. |
Exam Course Type | Choose one of the following Exam Course Typesfrom the pop-up menu:
|
Run for Summer School | Select the checkbox to run report for summer school and include the courses taken during summer school. |
Transfer Fields to Stored Grades | Choose to transfer data from the Alberta-specific fields from the CC table to the Stored Grades. |
Run Update Process | Select the check box to apply the business rules that set the Course Completion Status Code and the Course Completion Funding Flag. The following rule is processed when the Update Process is checked:
|
Completion Status for marks less than 25 percent | Select one from the following options based on the district’s policy:
When processing marks that are less than 25 percent, the Completion Status Code is set based on this value. |
Report Output
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Tablefor a definition of each column in the table.
SCM 1 - Authority/School
Data Element | [Table]FieldName | Max Length | Position |
Transaction Type | Populate Value – SCM1 | 4 | 1 - 4 |
Authority Code | [Prefs]Value [Prefs]Name=DistrictNumber | 4 | 5 - 8 |
School Code | [Schools]School_Number [Schools]Alternate_School_Number – if populated | 4 | 9 - 12 |
Filler | Blank | 24 | 13 - 36 |
File Creation | Calculated | 8 | 37 - 44 |
Student Count | Calculated | 6 | 45 - 50 |
SCM 2 - Student ID Detail
Data Element | [Table]FieldName | Max Length | Position |
Transaction Type | Populate Value – SCM2 | 4 | 1 - 4 |
Authority Code | [Prefs]Value [Prefs]Name=DistrictNumber | 4 | 5 - 8 |
School Code | [Schools]School_Number [Schools]Alternate_School_Number – if populated | 4 | 9 - 12 |
School/Authority Student ID | [Students]Student_Number | 15 | 13 - 27 |
Alberta Student Number | [Students]State_StudentNumber | 9 | 28 - 36 |
Last Name | [StudentCoreFields]PSCore_Legal_Last_Name | 25 | 37 - 61 |
First/Middle Name | [StudentCoreFields]PSCore_Legal_First_Name [StudentCoreFields]PSCore_Legal_Middle_Name | 25 | 62 - 86 |
DOB | [Students]DOB | 8 | 87 - 94 |
Gender | [Students.StudentCoreFields]PSCore_Legal_Gender | 1 | 95 - 95 |
SCM 3 - Course Mark Detail
Data Element | [Table]FieldName | Max Length | Position |
Transaction Type | Populate Value – SCM3 | 4 | 1 - 4 |
Authority Code Positions | [Prefs]Value [Prefs]Name=DistrictNumber | 4 | 5 - 8 |
School Code Positions | [Schools]School_Number | 4 | 9 -12 |
School/Authority Student ID | [Students]Student_Number | 15 | 13 - 27 |
Alberta Student Number | [Students]State_StudentNumber | 9 | 28 - 36 |
Course ID | [Courses]Alt_Course_Number [Courses]Course_Number | 7 | 37 - 43 |
From Action Code | Value of A | 1 | 44 - 44 |
Modification Effective Date | Blank | 8 | 45 - 52 |
Course Completion Date | [CC]DateLeft | 8 | 53 – 60 |
Course Completion Credit | [StoredGrades]PotentialCrHrs | 4 | 61 - 64 |
Course Completion Fund | [CC]AB_Course_Cmp_Fun_Flg | 1 | 65 - 65 |
Course Completion External Credential | [CC]AB_Course_Cmp_Ext_Crd | 1 | 66 - 66 |
Course Completion Funding Schedule | [S_AB_SEC_X]CourseCmpFunSch | 3 | 67 - 69 |
Course Completion Method Code | [CC]AB_Course_Cmp_Met_Cd | 3 | 70 – 72 |
Course Evaluation Province Code | [CC]AB_Course_Eva_Pro_Cd | 2 | 73 - 74 |
Course Completion Status Code | [StoredGrades]AB_Course_Cmp_Sta_Cd | 3 | 75 - 77 |
Primary Delivery Method Code | [S_AB_SEC_X]PrimaryDeliveryMethod | 3 | 78 - 80 |
Language Code | [S_AB_SEC_X]InstrLanguage | 2 | 81 - 82 |
Filler | Blank | 2 | 83 - 84 |
School Awarded Mark | [StoredGrades]Grade [StoredGrades]Percent | 3 | 85 - 87 |
Filler | Blank | 3 | 88 - 90 |
Filler | Blank | 3 | 91 - 93 |
Class ID | [S_AB_SEC_X]SectionClassID [Sections]SectionID – if SectionClassID is not populated | 8 | 94 - 101 |
Filler | Blank | 6 | 102 - 107 |
Message | 251 | 108 - 358 |
SCM Validation Logic
Final Mark | Description |
0 to less than 25 percent | Course Completion Status Code = COM Course Completion Fund Flag = N Course Completion External Credential = N Note: The Course Completion External Credential can be manually changed to Y. |
25 percent to 100 percent | Course Completion Status Code = COM Course Completion Fund Flag = Y Course Completion External Credential = N Note: The Course Completion External Credential can be manually changed to Y. Note: Records are not updated for marks with CCSC status = WDR or Funding Flag = N. |
School Course Marks Validation Code
Message Number | Condition |
1 | If the course completion status code [StoredGrades]AB_Course_Cmp_Sta_Cd is WDR, INC, or EXP, then the [StoredGrades]Grade must be blank. Note: INC is used for CTS. |
2 | If the course completion method code [StoredGrades]AB_Course_Cmp_Met_Cd is CHA, then the final mark [StoredGrades]Grade cannot be a P. |
3 | The final mark [StoredGrades]Grade must not be greater than 100. |
4 | If the final mark [StoredGrades]Grade is less than 50%, then the credits earned [StoredGrades]EarnedCrHrs must be zero. |
5 | If the course completion status code [StoredGrades]AB_Course_Cmp_Sta_Cd is EXP and the course completion method code [StoredGrades]AB_Course_Cmp_Met_Cd is JRH or REG, then the letter marks [StoredGrades]Grade A, B, C, D, and P are not valid. |
6 | If the course completion method code [StoredGrades]AB_Course_Cmp_Met_Cd is JRH, REG, or CHA, then letter marks [StoredGrades]Grade A, B, C, D, P are invalid. |
7 | The course completion method code [StoredGrades]AB_Course_Cmp_Met_Cd value WPC must have a final mark [StoredGrades]Grade of P. |
8 | If a report is run for a summer school term, then the course completion funding code [StoredGrades]AB_Course_Cmp_Fun_Sch must be SUM. |
9 | If a report is run for a non-summer school term, then the course completion funding code [StoredGrades]AB_Course_Cmp_Fun_Sch must not be SUM. |
10 | If the course completion status code [StoredGrades]AB_Course_Cmp_Sta_Cd is INC, WDR, or EXP, then the credits earned must be zero. |
11 | If the course completion method code [StoredGrades]AB_Course_Cmp_Met_Cd is OUT, then the province [StoredGrades]AB_Course_Eva_Pro_Cd must not be AB. |
12 | All mandatory fields must not be blank. [Students]State_StudentNumber [Courses]Course_alt_course_number [Courses]Course_Number - will be part of CC record or stored grade manual entry. [StoredGrades]PotentialCrHrs [StoredGrades]Grade - School Awarded Mark - There must be a value for either Percent or Grade - both values cannot be blank in PowerSchool. The following fields will come from the CC table if a CC record exists or from stored grades if this is a manually entered stored grade:
|
13 | If the final mark [StoredGrades]Grade is WDR, then the course completion status [StoredGrades]AB_Course_Cmp_Sta_Cd must be WDR and the course completion funding flag [StoredGrades]AB_Course_Cmp_Fun_Sch must be Y. |
14 | If the final mark [StoredGrades]Grade is A, B, C, D, or F, then list the grade, course completion status code [StoredGrades]AB_Course_Cmp_Sta_Cd and funding flag [StoredGrades] AB_Course_Cmp_Fun_Flg. |
15 | If the final mark [StoredGrades]Grade is greater than or equal to 50% or is P and the course completion status code [StoredGrades]AB_Course_Cmp_Sta_Cd is INC or WDR, then the completion status is invalid. |
16 | If the final mark [StoredGrades]Grade is less than 1 or not P, then the completion status code [StoredGrades]AB_Course_Cmp_Sta_Cd must not be blank, COM, or EXP. |
17 | If the final mark [StoredGrades]Grade is P or greater than 0 and if the completion status [StoredGrades]AB_Course_Cmp_Sta_Cd is blank, then the completion status must be set to COM and the funding flag must be set to blank. |
18 | The completion status must not be blank and the end date must not be greater than 30 days in the future. |