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/

 

School List (Active and Inactive) (csv) School List (Active only) (csv) (updated Nov 7, 2018)

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)

Recent Changes

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:
  1. Intensive Supports,
  2. eIIP (Electronic Inclusion and Intervention Plan),
  3. EAL (English as an Additional Language),
  4. Student Assessments (literacy and numeracy).
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
  • The biggest change is that we have rolled together version 1 and version 2 of the schema and it is being called version 3.  Therefore all headers will require changing. 
  • We have removed all objects relating to EAL, ePPP, Intensive Supports, and Educator from the Schema.  These objects will have their own schema.
  • Added fields called Home Room ID and Resident Type and have removed PreK Shared Space indicator and Tuition Status
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:

  • preK Ministry Designated and Shared Space fields
  • Organization Affiliation
  • Home Room Teacher
  • Student Intensive Supports Information
  • Student Personal Program Plan Information
  • Student English as an Additional Language Requirements

Changes to existing rules and queries:

  • Schools that have a non-base enrolment relationship with students will no longer be able to update any demographic information for that particular student. This is the responsibility of the "base" school.
  • P3 grade is no longer valid.
  • Writing Centres can be submitted for any approved school in the province rather than just the source_id school.
  • QueryByStudent and QueryBySchool Student Personal and StudentEnrollment Object's have been expanded to return all of the new demographic and enrolment fields that were added to the database for the 2011/2012 and 2012/2013 school years.
  • New QueryByStudent and QueryBySchool Object Names have been created for IntensiveSupportInfo and EnglishAdditionalLanguageInfo.
  • Languages and Country Codes have been updated
2010/2011 Changes SDS

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.

2009/2010 Changes SDS

The updates include:

  • changes to existing country codes and names
  • new country codes
  • changes to existing language codes and names
  • new language codes
  • Addition of StudentPAAModule Object
  • other changes as noted in the Revision History section of the document
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.
Registration changes
-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.
Miscellaneous
-Modified SL_SourceId validation to include school divisions as well as schools
- Added DeptAssignedPersonId (if known) to the returned ErrorMessage where applicable.

Information Section

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 PowerPoint   Adobe 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

http://www.sifinfo.org/

Questions / Comments

Frequently Asked Questions Updated September 29, 2003