Ministry of Education Student Data System XML Information
Production URL's for XML
|Test URL's for XML|
|Real-time - https://www.k12.gov.sk.ca/spls/sdsxml/pkgb_xml_interface.sl_message||Real-time - https://webtk12.sasked.gov.sk.ca/spls/edtemr_xml/pkgb_xml_interface.sl_message|
|Batch - https://www.k12.gov.sk.ca/sdsprod/||Batch - https://webtk12.sasked.gov.sk.ca/sdsedtemr/|
|Course Code List (Active and Inactive) (csv) Course List (Active only) (csv) (updated Nov 7, 2018)|
|Course List (Active only) K-9 (csv) (Updated June 5, 2018)|
SDS XML Specifications document (pdf) (January 2017, April 2017)
SAS-XML Specifications document (pdf) (updated April 25, 2016, Aug 2016, January 2017)
EAD-XML Specifications document (pdf) (June, 2018) EEP XML Information and Q and A Help Document (pdf) (Sept 2017) Data Disclosure Statement (pdf) (August 2017)
June 5, 2018
Français K, 1 and 2 will be inactivated July 31, 2018. Please use Programme d'études interdisciplinaire K, 1 and 2.
February 3, 2017
The 2017/2018 changes to the SDS XML Specification document are now available. Please note - changes for this year are applicable to Country and Language Codes only.
January 12, 2017
The 2017/2018 changes to the EAD-XML Specifications are now available. We will alert you as soon as it is available to test.
June 27, 2016 (To be implemented at the end of July)
A couple of minor changes have been made to the SDS XML Specifications.
March 24, 2016
The Student Achievement and Supports XML schema has been updated. Please refer to the Revision History within the document for information on the changes that were made in March 2016.
January 21, 2016
Here are the new XML specs for the Employment and Additional Data (EAD) XML schema. Updates include minor functional edits, additional examples, updated tables in the Appendix, and the addition of SPTRB-specific object.
January 21, 2016
The SDS changes for the 2016-2017 School Year have been determined. The good news is there aren't any!! The document however has been updated to reflect changes in the Appendix to Country names, language Names and new languages. An update to the wording for Query by Student is also included. See Page 7 of the document for more information.
December 11, 2015
In order to assist SIS vendors and other partners in populating their school and course code tables, we have posted csv files of those lists. The files contain both active and inactive organizations and course information. See above for the lists.
Summary of earlier changes:
|Sept 17, 2015||SAS-XML Specifications document||Please refer to the Revision History within the document for information on the changes that were made in May 2015.|
|July 24, 2015||SDS fall changes||As of Aug 1, 2015 the old enrolment/result codes will no longer be available. Please see the XMLSpecifications for more information.|
|April 16, 2015||Employment and Additional Data (EAD) XML schema has been created||Please refer to the Revision History within the document for future revisions, corrections, and enhancements.|
|Employment and Additional Data (EAD) XML schema has been created||
Power Point Presentation (updated April 16, 2015)
|Dec 30, 2014||SDS changes for the 2015-2016 School Year||Changes involve the addition and removal of Enrollment Type Codes, Enrollment Outcomes and Discontinuation Reason Codes and the renaming of Foreign Tuition to Tuition.|
|Dec 18, 2014||Student Achievement and Supports XML schema has been updated||Please refer to the Revision History within the document for information on the changes that were made.|
|Dec 10, 2014||Student Achievement and Supports XML schema||Please refer to the Revision History within the document for information on the changes that were made on August 27 and December 10.|
|May 27, 2014||SDS Changes||Spring Webinars that were held on May 21. Power Point Presentation and the Q and A Document|
|May 12, 2014||Student Achievement and Supports XML schema||Please refer to the Revision History within the document for information on the changes that were made.|
|Dec 23, 2013||Student Achievement and Supports (SAS) XML schema||Created to establish the SAS business line in its own stand-alone schema, to complement the student information that is already collected and maintained in the existing SDS XML schema. The business functions included in the new SAS schema are:
|Dec 19, 2013||SDS fall changes||There is only one change to the XML Schema for the 2014/2015 school year. This change is the creation of a Home Room Identifier field which will be used to capture an identifier for each Home Room that an educator is assigned to. For example, if an educator has a Kindergarten A.M. and a Kindergarten P.M. Home Room, the students attached to each home room can now be identified. This will support the EYE (Early Years Evaluation) and the EDI (Early Development Instrument) surveys in which the students are required to be divided into class groups.|
|July 4, 2013||SDS fall changes||Power Point Presentation and the Q and A Document from the Spring Webinars that were held in May.|
|May 23, 2013||SDS fall changes||The XML test region is now available for testing the 2013/2014 changes.|
|April 18, 2013||SDS changes||Due to Oracle having issues with XML where there are parameters and a text value at the same time, we have changed the way Resident Type is being implemented.|
|April 9, 2013||SDS changes||A decision has been made to remove the new Home Room ID field.|
|April 3, 2013||SDS changes||Resident Type of Immigrant has been changed to Permanent Resident to be consistent with the wording|
|Feb 6, 2013||SDS changes for the 2013/2014 School Year||
|Aug 24, 2012||SDS changes||Just a reminder to ensure that all schools have been sent an update to the SL_Message header. There are a number of files being submitted this week that are receiving a validation error.|
|SDS changes||Here are the Frequently Asked Questions that are being posted on the System Update section of the Student Data System. These FAQ's reflect the changes made. Frequently Asked Questions.|
|Feb 13, 2012||SDS changes||Summary of changes for the 2012/2013 School Year. Microsoft Word Adobe Acrobat .|
|Jan 10, 2012||SDS changes||
New Information being collected:
Changes to existing rules and queries:
The StudentAddress/Address/Street element has been changed from Required to Optional in order to support the new address type of PhysicalLand. This change is on page 28 of the document. It affects the printing of pages 28-33.
The Enrollment Outcome and Discontinuation Reason Code for "Discontinued Schooling, with a reason of "monitored"" had the wrong code attached to it. It should have been 61 not 54. This change is on page 36 of the document.
The updates on March 25 included a change to page 31 - Township. The acceptable numbers are 1 through 67 rather than 1 through 127. The second change was on page 37 - Student was dropped from the Foreign Exchange description.
These changes include the addition of demographic and enrolment fields necessary to support provincial funding.
The updates include:
|2004/2005 Changes and Information||Enrolment changes
- Modified processing to allow a student to be enrolled as a non-base enrolment vs rejecting the transaction when the enrolment type does not match the previous enrolment reason.
- Added SchoolAssignedPersonId to response for and StudentSchoolEnrollment:Add transaction to help the schools identify the individual.
- Modified StudentSchoolEnrolment:Change transactions to validate the LearningIdNbr and BirthDate as this was being bypassed when the name was not supplied.
- Modified HSN validation to return a warning for an invalid hsn and ignore the hsn provided, rather than rejecting the transaction
- Added checks to verify School and Program Entry and Exit dates are no more than a year in the future.
-Modified exam registration processing to accept an ExamPeriodEndDate any time within the ExamPeriod
-Modified processing to properly warn when multiple educators present.
-Modified registration to allow section identifier matching to be mixed case.
-Modified registration to trim spaces from the section identifier.
- Modified StudentClassEnrolment (Registrations) transaction to remove the check to see if the student is enrolled in the school prior to registration.
- The size of the Section Identifier field has been increased from 30 to 40 characters.
Marks and Exam registrations
-Modified processing to accept a mark or registration as long as the student has an active base or home based enrolment for any school.
-Modified SL_SourceId validation to include school divisions as well as schools
- Added DeptAssignedPersonId (if known) to the returned ErrorMessage where applicable.
May 3, 2007 SIS Symposium - SDS Update Presentation (Microsoft PowerPoint Adobe Acrobat)
XML Specifications (formerly called XML Handout). An overview of Saskatchewan Learning's XML schema and edit rules which must be followed to create complete XML transactions. (Microsoft Word Adobe Acrobat - Last updated Oct 18, 2005- rel1.1)
XML Overview - This document provides an overview and examples of how to use XML to exchange Student Data System information between schools and Saskatchewan Learning. See document XML Specifications for the detailed specifications. (Microsoft Word Adobe Acrobat - Last updated May 12, 2005)
March 2 SIS XML Business Transactions Presentation (Microsoft PowerPoint Adobe Acrobat) and XML Overview (Microsoft Word Adobe Acrobat- Last updated March 3, 2005)
Help with Post Implementation Error Messages. (Microsoft Word Adobe Acrobat - Last updated Nov 14, 2004)
Examples of complete XML messages for dialogues between schools and Saskatchewan Learning can be found in these documents. (HTML Adobe Acrobat - Last updated March 29, 2004)
All Student Data System XML Elements are defined in the schema SDSElements.xsd. Last updated March 29, 2004
All Saskatchewan Learning Messaging Elements are defined in SLMessage.xsd. SLMessage is dependant on SDSElements. Last updated March 29, 2004
Detailed Element Specifications - Last updated March 29, 2004
December SIS Presentation (Microsoft
Acrobat - Last updated December 22, 2003)
What is XML? A very high level overview of XML. (Microsoft Word Adobe Acrobat - Last updated September 22, 2003)
The XML Schema definition language (XSD) enables you to define the structure and data types for XML documents. An XML Schema defines the elements, attributes, and data types that conform to the World Wide Web Consortium (W3C) XML Schema Part 1: Structures Recommendation for the XML Schema Definition Language.
An XSD file can be viewed or edited using ordinary text processing software, however many developers prefer to work with XSD files using specialized editing tools, such as xmlspy.
XML Technology Resource Links
http://www.xml.com O'Reilly Publishing articles and tutorials on XML and related technologies.
http://www.xml.org Organization for the Advancement of Structured Information Systems XML Resource Page.
http://www.microsoft.com/xml Microsoft XML resource page.
http://www.oracle.com/xml Oracle XML resource page.
http://www.w3.org/XML/ World Wide Web Consortium - The definitive source of the XML specification.
School Interoperability Framework
Questions / Comments
Frequently Asked Questions Updated September 29, 2003