SK Generate Student Marks Query File

Contents

Introduction

This report creates the query file needed to upload to SDS in order to obtain a response file containing student marks from the Ministry, which can then be imported into PowerSchool. The report must be run at the school level as the report will only contain student attendance data for the current school.

When run on the Ministry site, the generated course mark query will return all student completed courses, from any school that administered a mark – for any student that is currently enrolled as their base at the school that sent the query request. This includes online courses, credit transfers and ‘regular’ marks. The purpose of the query is to allow schools to obtain a complete mark history for a student, as well as retrieve the final blended mark for departmental exams.

Report Input

For help with navigation and running the report, seeHow to Find and Generate a Report.

Field	Description
Data to be Filled	Select the checkbox next to the filter fields to save the settings as defaults. To select all checkboxes, choose Set All from the pop-up menu. To clear all checkboxes, choose Reset All.
Select Grade	Select the grade level for which you wish to request student marks. If you want student marks for all grade levels in the school, select 'All Grades'.

Report Output

This report generates an XML file that can be used as a query file to request student marks from SDS for the currently selected school year and school.

To prepare the files for submittal to SDS:

Run the report
Download the file and save to a local directory

The name of this file uses the format SK_StudentMarksQuery-{SDNameAbbr}@{Timestamp}.xml

Each of the fields displayed in the output of this report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Data Element	Description	[Table]FieldName
SL_Header/SL_MsgId	Displays a Global Unique Identifier.	N/A
SL_Header/SL_Date	Displays the date that the Report was generated.	N/A
SL_Header/SL_Time	Displays the time that the Report was generated in the format HH:MM:SS, using a 24-hour clock.	N/A
Zone	Display the time zone for the time that the Report was generated.	N/A
SL_Header/SL_SourceId	Displays the current School Number. This is the department-assigned number of the organization.	[Schools]School_Number
SL_Query
QueryBySchool	This object always contains the values ObjectName="StudentCompletedCourses" and IncludeLookupNames="Yes".	N/A
RefId	Display an auto-increment reference ID for returning the response.	Calculated
SchoolId	Displays the current School Number. This is the department-assigned number of the organization.	[Schools]School_Number
FromDate	The earliest date for which student marks will be returned.	[Terms]FirstDay where SchoolId = currently selected school, YearId = currently selected year, and IsYearRec = 1
ToDate	The latest date for which student marks will be returned.	[Terms]LastDay where SchoolId = currently selected school, YearId = currently selected year, and IsYearRec = 1
FromGrade	The lowest grade for which student marks will be returned.	Selected grade from report page, or <FromGrade> tag is not included if 'All Grades' was selected.
ToGrade	The highest grade for which student marks will be returned.	Selected grade from report page, or <ToGrade> tag is not included if 'All Grades' was selected.

Back to Top