French Instruction Hours Calculation
Introduction
This extract calculates student French instruction hours for the entire school year. The extract can be run district-wide or for current school. This report saves student French hours values in the Students table.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Use | If run at the district level, choose one of the following from the pop-up menu:
If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list. |
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.
Data Element | [Table]FieldName | Max Length | Position |
Transaction Type | Populated Value – SSR3 | 4 | 1 - 4 |
School Authority Code | [Prefs]Value [Prefs]Name=DistrictNumber | 4 | 5 - 8 |
School Code | [Schools]School_Number [Schools]Alternate_School_Number - if populated | 4 | 9 - 12 |
Form Action Code | Populated Value – A | 1 | 13 - 13 |
Modification Effective Date | Blank | 8 | 14 - 21 |
Alberta Student Number | [Students]State_StudentNumber | 9 | 22 - 30 |
Legal Surname | [StudentCoreFields]PSCore_Legal_Last_Name | 25 | 31 - 55 |
Legal Given Name | [StudentCoreFields]PSCore_Legal_First_Name [StudentCoreFields]PSCore_Legal_Middle_Name | 25 | 56 - 80 |
School/Authority Student ID | [Students]Student_Number | 15 | 81 - 95 |
Calculated French Hours | [S_AB_STU_X]FrenchHours | 4 | 96 - 99 |