OnSIS Elementary School Submission Report

Field

Description

Current Selection Students*

If "Selected n Students Only" is selected, the report includes, subject to other student selection, only students in the current PowerSchool student selection. Default is "All Students"

Select Alternative School Number*

Choose the school for which you want to run the submission report. The pop-up menu contains alternative school numbers (BSIDs) only for schools with grade levels K-8.

If the report is run at the school level, only the alternate school number for the current school is available. If alternate school number ([Schools]Alternate_School_Number) is undefined, the local school number ([Schools]School_Number) is shown. If multiple schools have the same BSID, the BSID appears only once in the pop-up menu.

Any school with the same selected BSID but with the "Exclude From State Reporting" or "School is Closed" checkbox selected will not be included in the report output.

Submission Type*

Select the submission type for the report: one of Public School, Private School, or 380 Private School.

Submission Period (YY/MM/DD)*

Select the submission period. Dates for each of the submission periods are based on values set in Start Page > District Setup > District Information for each of the OnSIS Reporting Dates, where:

October submission is from the October Submission Period Start Date entered on the Edit District Information page (July 1 of the current school year if undefined) until the October reporting date.

March submission is from the day after the October submission until the March reporting date.

June submission is from the day after the March submission until the June reporting date. For private schools June submissions is from a day after the October count date until the June count date.

Suspension/Expulsions submission is from the start of the current school year until the June reporting date.

Select Attendance Conversion*

If the report is run at the school level and the AM/PM attendance conversions have been set up for the school, the following options are displayed:

Period to AM/PM

Time to AM/PM

If the report is run at the school level and the AM/PM attendance conversions for the school have not been set up, the following option is displayed:

Setup Attendance Conversion

If the report is run at District-Level, the following options are displayed:

Period to AM/PM

Time to AM/PM

The user must ensure that the attendance conversions have been set up for the selected school before running the report; otherwise, the report will generate incorrect results for Days_Absent and Times_Late elements in Report_Card segment.

Co-Teaching Roles For Which To Generate Class Assignments

This is a list of roles configured as co-teacher roles.

Select the roles that should cause educator <CLASS_ASSIGNMENT> segments to be generated for non-lead teachers assigned to a homeroom class when no explicit class assignments are present for an educator in the S_ON_Assign_Class_C table.

Co-Teaching Roles To Designate As Core

This is a list of roles configured as co-teacher roles.

Select the roles that should cause educator <CORE_FLAG> to be set to "T" for non-lead teachers assigned to a homeroom class.

Co-Teaching Roles For Which To Generate Assigned Subjects

This is a list of roles configured as co-teacher roles.

Select the roles that should cause educator <ASSIGNED_SUBJECT> segments to be generated for non-lead teachers assigned to a subject class when no explicit subject assignments are present for an educator in the S_ON_SSF_ASSIGNSUBJECT_C table.

List of Alternative Schools (no selection needed)

This is a read-only list of the schools in PowerSchool that have the alternative school number selected above. Students enrolled in any of these schools are included in the XML submission file created by the report.

Only schools for which "Exclude From State Reporting" ([Schools]State_ExcludeFromReporting) and "School is Closed" ([S_ON_SCH_X]IsClosed_TF) are not selected are included in this list.

Validate XML

When this checkbox is selected, the report generates the XML and validates the students against OnSIS rules. Errors and warnings can then be viewed on the Start Page > Validation Errors Viewer > Data Views page. For further information about validation rules, refer to OnSIS Elementary School Submission Report.

Save XML

When this checkbox is selected, the report saves the XML output in tables. These tables are used to generate OnSIS Elementary School Submission Report.

A logging record for the process output is inserted to a logging file and can be viewed from the Start Page > Validation Errors Viewer > Data Views page. Select 'Save XML Process Log' option from Choose data view dropdown to view the logged records.

The following Segments are saved:

Data Element

Description

[Table]FieldName

<?xml version="1.0" encoding=" ISO-8859-1"?>

XML version and encoding types - required to validate a well-formed XML file

n/a

Data Element

Description

[Table]FieldName

ONSIS_BATCH_FILE

Root node of the xml file. Required by the Ministry.

n/a

Data Element

Description

[Table]FieldName

HEADER

Section node. Required by the Ministry.

n/a

VERSION

Document version number. Must have value "1.0".

n/a

BATCH_TYPE

File type. Must have value "School Data Submission".

n/a

BATCH_FILE_ID

File id. Must have value "0001".

n/a

DATE

Date of report creation. Format 'YYYY/MM/DD'

n/a

TIME

Time of report creation. Format 'HH24MISS'

n/a

Data Element

Description

[Table]FieldName

DATA

This is the outer tag for all data

n/a

Data Element

Description

[Table]FieldName

SCHOOL_SUBMISSION

This is the outer tag for school data.

n/a

ACADEMIC_YEAR

The academic year of the submission. Format 'YYYY-YYYY'. For example, 2011-2012

[Terms]YearId (since YearId is 2 digits, representing the year after 1990, this is displayed as a span of [Terms]YearId+1990-[Terms]YearId+1991

SUBMISSION_PERIOD_TYPE

Submission period type. This code must be one of those specified in the OnSIS Reference Table and is set by the UI settings of Submission Type and Submission Period.

The combination of elements ACADEMIC_YEAR and SUBMISSION_PERIOD_TYPE are used to uniquely identify the submission period.

OCTELEM1, OCTELEM2, OCTELEM3, OCTELEM4, MARELEM2, MARELEM3, MARELEM4, JUNELEM3, JUNELEMSUS1, JUNEELEM4, MARELEM3, JUNEELEM5, JUNELEM6

Segment Name

Submission Periods

October

March

June

School

Y

Y

Y

School/Class

Y

Y

Y

School Educator Assignment

Y

Y

Y

Instructional TM

Y

Y

Y

Class Assignment

Y

Y

Y

Assigned Subject

Y

Y

Y

Assigned Grades

Y

Y

Y

TLA (not generated starting October 2012)

Y

Y

Y

Student

Y

Y

Y

Student School Enrolment

Y

Y

Y

Special Education

Y

Y

Y

Second Language Program

Y

Y

Y

Report Card

N

Y

Y

SAL

Y

Y

Y

School Incident

N

N

Y

Literacy And Numeracy (not generated starting October 2013)

N

N

Y

Average Report Card Grade

N

N

Y

Data Element

Description

[Table]FieldName

SCHOOL

This is the outer tag for all schools

n/a

SCHOOL_NUMBER

The unique identifier for the school. Format: 'NNNNNN'

[Schools]Alternate_School_Number or

[Schools]School_Number if [Schools]Alternate_School_Number is 0

CLEAR_PENDING_AREA

Flag to clear pending area. Must have value "N".

n/a

CLEAR_SCHOOL_EDUCATOR_ASSIGNMENT

Flag to clear educator assignment data. Must have a value of 'Y'.

n/a

CLEAR_ASSIGNED_SUBJECT

Flag to clear educator assigned subject data. Must have value "Y".

n/a

CLEAR_ERS

Flag to clear the ERS segment data. Must have value “Y”

n/a

CLEAR_STUDENT_SCHOOL_ENROLMENT

Flag to clear student school enrolment. Must have value "Y".

n/a

CLEAR_CLASS

Flag to class data. Must have value "Y".

n/a

CLEAR_MEDIAN_REPORT_CARD_GRADE

Flag to clear median report card grade data. Must have value "Y". Not generated if selected submission type is "Private School" or "380 Private School".

n/a

CLEAR_AVG_REPORT_CARD_GRADE

Flag to clear average report card data. Must have value "Y". Not generated if selected submission type is "Private School" or "380 Private School".

n/a

CLEAR_REPORT_CARD

Flag to clear report card data. Must have value "Y". Not generated if selected submission type is "Private School" or "380 Private School".

n/a

CLEAR_LITERACY_AND_NUMERACY

Flag to clear literacy and numeracy data. Must have value "Y". Not generated starting October 2013.

n/a

Data Element

Description

[Table]FieldName

CLASS

This is the outer tag for all school classes.

n/a

ACTION

Action to perform with this data. Must be one of: ADD, UPDATE or DELETE

PowerSchool Business Rules:

If the class, identified by CLASS_CODE exists in PowerSchool, but does not exist in the ON_CLASS table, then a <CLASS> segment will be created with the action of ADD.

If the class, identified by CLASS_CODE exists in the ON_CLASS table and in PowerSchool, then the <CLASS> segment will be generated with the action of UPDATE.

An Action of DELETE will not be generated for Class segments that exist in the PAE, if it is an eSIS Class Code. Instead, the Action will be UPDATE and the <CLASS_END_DATE> of the segment will be set to the start date of the current submission period.

Class code comparisons are case insensitive.

n/a

CLASS_CODE

Class Code must uniquely define this Class segment. This value is generated by the OnSIS Create Class Codes process.

Converted to upper case.

[S_ON_SEC_X]Class_Code

CLASS_START_DATE

First day of the class.

If Action is ADD, [Terms]FirstDay for term in Sections record. If [Terms]FirstDay earlier than the submission period start date, use the submission period start date.

If Action is UPDATE, [ON_Classes]Class_Start_Date

CLASS_END_DATE

Last day of the class.

[Terms]LastDay for term in Sections record.

CLASS_TYPE

Class type for the class.

[S_ON_SEC_X]Class_Type

'R' (Regular) if undefined.

For private school submissions always set to 'NA'.

LANGUAGE_TYPE

Language of instruction for the class.

OnSIS accepts (E, F, or B)

[Sections]Instruction_Lang If defined and is either E, F, or B,

if undefined then [S_ON_CRS_X]Instruction_Lang If defined and is either E, F, or B

otherwise, if [Prefs]Value = 1 where [Prefs]Name = 'ON_French_Board' use 'F; otherwise, use 'E'.

CLASSROOM_TYPE

Type of classroom.

[S_ON_SEC_X]Classroom_Type

'1' (Regular) if undefined.

Data Element

Description

[Table]FieldName

SCHOOL_EDUCATOR_ASSIGNMENT

This is the outer tag for all school educator assignments.

n/a

ACTION

Action to perform with this data. Must be one of: ADD or UPDATE.

UPDATE Action is always generated before ADD if both exists for the same educator.

n/a

MEN

Ministry Educator Number. MEN and POSITION_TYPE are used to uniquely identify the assignment.

[S_ON_USR_X]MEN

POSITION_TYPE

Position type. MEN and POSITION_TYPE are used to uniquely identify the assignment.

In the case where a match for the assignment is found in the PAE table based only on school and teacher, but not position type, the position type value from the assignment record is used. This is meant to result in an OnSIS error alerting the user to the fact that an assignment has not been correctly ended.

For Action ADD - [S_ON_SSF_Educator_Assign_C]Position_Type

For Action UPDATE - PAE [S_ON_SSF_Educator_Assign_C]Position_Type. If no match on position type is found in PAE, use [S_ON_SSF_Educator_Assign_C]Position_Type

NEW_POSITION_TYPE

New position type.

Not used

EDUCATOR_LEAVE_TYPE

Educator leave type. Generated when action is ADD.

For Action ADD - [S_ON_SSF_Educator_Assign_C]Leave_Type

For Action UPDATE - Empty

NEW_EDUCATOR_LEAVE_TYPE

New Educator leave type. Generated when action is UPDATE.

For Action ADD - Empty

For Action UPDATE - [S_ON_SSF_Educator_Assign_C]Leave_Type

ASSIGNMENT_WTHD_TYPE

Assignment withdrawal type. Generated when action is ADD.

For Action ADD - [S_ON_SSF_Educator_Assign_C]Assign_Withdrawal_Type

For Action UPDATE - Empty

NEW_ASSIGNMENT_WTHD_TYPE

New assignment withdrawal type. Generated when action is UPDATE.

For Action ADD - Empty

For Action UPDATE - PowerSchool [S_ON_SSF_Educator_Assign_C]Assign_Withdrawal_Type

ASSIGNMENT_START_DATE

Assignment start date.

For Action ADD and UPDATE - PowerSchool

[S_ON_SSF_Educator_Assign_C]Assignment_Start

ASSIGNMENT_END_DATE

Assignment end date.

For Action ADD and UPDATE - PowerSchool

[S_ON_SSF_Educator_Assign_C]Assignment_End

FTE

Full time equivalent.

For Action ADD and UPDATE - PowerSchool

[S_ON_SSF_Educator_Assign_C]FTE

Format as 9.99 for example, .33 will extract as <FTE>0.33</FTE>

DEPARTMENT_TYPE

Department type.

Tag is discontinued starting 2023-2024

For Action ADD and UPDATE - PowerSchool

[S_ON_SSF_Educator_Assign_C]Department_Type,

BOARD_EMPLOYEE_NUMBER

Board employee number.

For Action ADD and UPDATE - PowerSchool

[S_ON_USR_X]Board_Employee_Num,

TEACHING_TYPE

Teaching Type.

For Action ADD and UPDATE - PowerSchool

[S_ON_SSF_Educator_Assign_C]Teaching_Type

Set to N/A for withdrawal records

CORE_FLAG

Core Teacher Flag.

IF the leave type or withdrawal type in the educator assignment record is defined or if the teaching type is NOT equal to 'T' or 'B', Then set to "F"; otherwise:

Set to "T" if teacher educator assignment includes

A Class Assignment record i.e. a record exists in S_ON_Class_Assign_C table for this Educator Assignment (Teacher/Position), or

There are no S_ON_Class_Assign_C records for the educator assignment but the educator is designated (in the SectionTeacher table) as the lead teacher for a homeroom class (i.e. [S_ON_CRS_X]Course_Type = "H") where students are enrolled, or is assigned to a homeroom class with a co-teaching role matching a Co-Teaching Roles To Designate As Core selected on the report input page.

Otherwise, set to "F"

If the segment is generated as the result of a class assignment for an ECE teacher (see below), CORE_FLAG is set to "F' unless the teacher is also the lead teacher for another class.

NTIP_STATUS_TYPE

NTIP status type.

Not extracted if selected submission type is "Private School" or "380 Private School".

Tag is discontinued starting 2023-2024

For Action ADD and UPDATE - PowerSchool

[S_ON_SSF_Educator_Assign_C]NTIP_Status, if value exists

GENDER_TYPE

Educator's gender

Valid Values: M, F, N (Prefer not to disclose) and S (Prefer to Specify)

[USERSCOREFIELDS].PSCore_Legal_Gender if defined otherwise [USERSCOREFIELDS].Gender

GENDER_DESC

Educator Gender description. This field is only populated when Gender is set to S for the Educator

[S_ON_USR_X].Gender_Identity_Desc.

Data Element

Description

[Table]FieldName

INSTRUCTIONAL_TM

Section of data for an educator's instructional time type. (Optional, Repeating)

n/a

ACTION

Action to perform with this data. Must be one of: ADD or DELETE

PowerSchool Business Rules:

If an Instructional_TM exists in PowerSchool for the educator but not in S_ON_Instructional_TM_C then the <INSTRUCTIONAL_TM> is generated with ADD action.

If an Instructional_TM exists in S_ON_Instructional_TM_C for the educator but not in PowerSchool then the segment is generated with DELETE action.

n/a

INSTRUCTIONAL_TM_TYPE

Time type.

OnSIS Business Rule:

Element INSTRUCTIONAL_TM_TYPE is used to uniquely identify the educator instructional time type information.

If the Action is ADD then [S_ON_Instructional_TM_C]Time_Type

If Action is DELETE then [ON_INSTRUCTIONAL_TMS] Instructional_Tm_Type

Data Element

Description

[Table]FieldName

CLASS_ASSIGNMENT

Section of data for an educator's class assignment. (Optional, Repeating)

n/a

ACTION

Action to perform with this data. Must be one of: ADD or DELETE.

PowerSchool Business Rules:

If a class identified by Class_Code exists in PowerSchool and does not exist in ON_CLASS_ASSIGNMENTS then the segment is generated with ADD action.

If the class identified by Class_Code exists in ON_CLASS_ASSIGNMENTS and does not exist in PowerSchool then the segment is generated with DELETE action.

Class code comparisons are case insensitive.

n/a

CLASS_CODE

Class code. This value is generated by the OnSIS Create Class Codes process.

OnSIS Business Rules:

The Class_Code is used to uniquely identify the class.

The CLASS_CODE element format will be [sections]course_number+ '-' + [sections]section_number. This is stored in [S_ON_SEC_X]Class_Code.

Embedded spaces are removed. Converted to upper case.

If Action is ADD then [S_ON_SEC_X]Class_Code If Action is DELETE then [ON_CLASS_ASSIGNMENTS]Class_Code

Data Element

Description

[Table]FieldName

ASSIGNED_SUBJECT

This is the outer tag for assigned subjects

n/a

ACTION

This is the action associated with this submission

Value: "ADD", "UPDATE", "DELETE"

PowerSchool Business Rules:

If an assigned_subject identified by ELEMENTARY_SUBJECT_TYPE and LANGUAGE_TYPE and School and Reference Number exists in PowerSchool but does not exist in [ON_ASSIGNED_SUBJECTS] then the segment is generated with ADD action.

If an assigned_subject identified by ELEMENTARY_SUBJECT_TYPE and LANGUAGE_TYPE and School and Reference Number exists in [ON_ASSIGNED_SUBJECTS] but does not exist in PowerSchool then the segment is generated with DELETE action. All DELETE segments are generated before any ADD segments.

If an assigned_subject identified by ELEMENTARY_SUBJECT_TYPE and LANGUAGE_TYPE and School and Reference Number exists in [ON_ASSIGNED_SUBJECTS] and also exists in PowerSchool then the segment is generated with UPDATE action.

n/a

ELEMENTARY_SUBJECT_TYPE

OnSIS Business Rule:

The combination of elements ELEMENTARY_SUBJECT_TYPE, LANGUAGE_TYPE and REFERENCE_NUMBER are used to uniquely identify the educator assigned subjects. Note however that REFERENCE_NUMBER is not used by the report to determine the value of ACTION.

If the action is ADD or UPDATE then [S_ON_CRS_X]Subject_Type

If the Action is DELETE then [ON_ASSIGNED_SUBJECTS]Elementary_Subject_Type

LANGUAGE_TYPE

OnSIS Business Rule:

The combination of elements ELEMENTARY_SUBJECT_TYPE, LANGUAGE_TYPE and REFERENCE_NUMBER are used to uniquely identify the educator assigned subjects.

If the action is ADD or UPDATE then:

Sections]Instruction_Lang If defined and is either E, F, or B,

If undefined then [S_ON_CRS_X]Instruction_Lang if defined and is either E, F, or B

otherwise , if [Prefs]Value = 1 where [Prefs]Name = 'ON_French_Board' use 'F; otherwise, use 'E'.

If the action is DELETE then [ON_ASSIGNED_SUBJECTS]Language_Type

REFERENCE_NUMBER

OnSIS Business Rules:

To allow the user to enter duplicate single subject (+ LOI) combinations with mixed grade entries, a new field is to be added to the ASSIGNED_SUBJECT table: REFERENCE_NUMBER. This field will expand the UK and allow these entries to be entered as follows:

The Reference Number field (ASSIGNED_SUBJECT.REFERENCE_NUMBER) will be automatically generated by the application to reflect the assigned grade(s).

When the ACTION of SCHOOL_EDUCATOR_ASSIGNMENT/ASSIGNED_SUBJECT is "ADD" this element must not be identified. When action is "UPDATE" or "DELETE" the element must be provided.

PowerSchool Business Rules:

<Reference_Number>, an element in <ASSIGNED_SUBJECT> has the form 'G:x,x,x..' where an occurrence of 'x' is the grade_level of students taking that subject under that educator in that language. The Grade_levels can be: JK, K, 1, 2, 3, 4, 5, 6, 7 or 8. If the <Assigned_Grade> ( a sub segment of Assigned_Subject) is being generated for all the grade levels mentioned above, such as students of all grades are taking that course then the <Reference_number> is set to 'E'.

Derived from grade_levels of students taking that subject.

[Students/Reenrollments] Grade_level

GRADE_FLAG

OnSIS Business Rules:

Indicates the educator's assigned grades.

Values:

E - All elementary grades

S - All secondary grades

B - All elementary and secondary grades

G - Specific grades

When the ACTION of SCHOOL_EDUCATOR_ASSIGNMENT/ASSIGNED_SUBJECT is "ADD"; this element is mandatory.

PowerSchool Business Rules:

Indicates the educator's assigned grades.

Values:

E- All Elementary Grades

G- Specific Grades

Always 'G'

NUMBER_OF_CLASSES

Number of classes.

When the ACTION of SCHOOL_EDUCATOR_ASSIGNMENT/ASSIGNED_SUBJECT is "ADD"; this element is mandatory.

Tag is discontinued starting 2023-2024

If the action is ADD or UPDATE then Derived from Sections table

If the action is DELETE then [ON_ASSIGNED_SUBJECTS]number_of_classes

Data Element

Description

[Table]FieldName

ASSIGNED_GRADE

This is the outer tag for Assigned_Grade

n/a

ACTION

This is the action associated with this submission.

Value: "ADD", "DELETE"

PowerSchool Business Rules:

If there exists an assigned_grade identified by subject_key (SUBJECT_TYPE + LANGUAGE_OF_INSTRUCTION) in PowerSchool but does not exist in ON_ASSIGNED_GRADES then the segment is generated with ADD action.

If there exists an assigned_grade identified by subject_key (SUBJECT_TYPE + LANGUAGE_OF_INSTRUCTION) in ON_ASSIGNED_GRADES but not in PowerSchool then the segment is generated with DELETE action.

n/a

GRADE_TYPE

OnSIS Business Rule:

The combination of elements ELEMENTARY_SUBJECT_TYPE, LANGUAGE_TYPE and GRADE_TYPE are used to uniquely identify the educator assigned subjects grades.

Note: Only applicable if "G - Specific Grades" was indicated in GRADE_FLAG in previous section.

PowerSchool Business Rule:

One <ASSIGNED_GRADE> child segment is generated for each grade level of the students taking that Subject in that language, represented in the set of classes comprising the parent <ASSIGNED_SUBJECT> segment.

When determining whether a student is enrolled in a class for the purposes of determining the grades included in the class, the student's classes that end before the submission start date are compared to the student's class enrollment start and end date. Students' classes that end on the Submission start date are ignored.

Derived from grade_levels of students taking that subject.

[Students]Grade_level

Data Element

Description

[Table]FieldName

TLA

Section of data for an educator's TLA info. (Optional, Repeating)

n/a

ACTION

Action to perform with this data. Must be one of: ADD or DELETE

PowerSchool Business Rules:

If a TLA exists in PowerSchool and does not exist in ON_TLAs then the segment is generated with ADD action.

If a TLA exists in S_ON_TLA_C and does not exist in PowerSchool for that educator then the segment is generated with DELETE action.

n/a

NON_TEACHING_FLAG

Indicates if the educator has a non-teaching TLA.

If Action is ADD then [S_ON_TLA_C]Non_Teaching_Flag

If Action is DELETE then [ON_TLAS] Non_Teaching_Flag

ELEMENTARY_SUBJECT_TYPE

OnSIS Business Rules:

The combination of element MEN NON_TEACHING_FLAG and ELEMENTARY_SUBJECT_TYPE is used to uniquely identify the educator TLA.

If SCHOOL_EDUCATOR_TLA_ASGN.NON_TEACHING_FLAG = "F", this element is mandatory.

If Action is ADD then [S_ON_TLA_C]Subject_Type

If Action is DELETE then [ON_TLAS]ELEMENTARY_SUBJECT_TYPE

Data Element

Description

[Table]FieldName

STUDENT

This is the outer tag for student

OEN

Student OEN. Used for OEN Authentication.

Leading zeroes are included.

Non-numeric characters such as dashes and spaces are removed.

[Students]State_StudentNumber

STUDENT_LEGAL_GIVEN_NAME

Student Legal Given Name. Used for OEN Authentication.

[S_ON_STU_X]Legal_First_Name (if not supplied, then [Students]first_name)

STUDENT_LEGAL_SECOND_NAME

Student Legal Second Name.

Second name no longer is used as part of the validation. The XML Batch file will not change; the Second name is simply ignored.

[S_ON_STU_X]Legal_Middle_Name (if not supplied then [Students]middle_name)

STUDENT_LEGAL_LAST_NAME

Student Legal Last Name.

Used for OEN Authentication.

[S_ON_STU_X]Legal_Last_Name (if not supplied then [Students]last_name)

STUDENT_DOB

Student Date of Birth. Mandatory Field.

Used for OEN Authentication.

[Students]DOB

LANGUAGE_TYPE

Language first spoken

OnSIS Business Rules:

When the ACTION of STUDENT_SCHOOL_ENROLMENT is "ADD" and the STUDENT_SCHOOL_ENROLMENT.MAIN_SCHOOL_FLAG = 'T', this element is mandatory.

When the ACTION of STUDENT_SCHOOL_ENROLMENT is "ADD" and the STUDENT_SCHOOL_ENROLMENT.MAIN_SCHOOL_FLAG='F', this element is ignored. For students that have not been entered in OnSIS, the value for Language First Spoken will be set to the language of the school. If the language of the school is both "English and French", Language First Spoken of the student will be set to English.

When the ACTION of STUDENT_SCHOOL_ENROLMENT is "UPDATE" and the STUDENT_SCHOOL_ENROLMENT.MAIN_SCHOOL_FLAG='F', this element is ignored.

[S_ON_STU_X]First_Language

If undefined, if [Prefs]Value = 1 where [Prefs]Name = 'ON_French_Board' use 'F; otherwise, use 'E'.

Data Element

Description

[Table]FieldName

STUDENT_SCHOOL_ENROLMENT

This is the outer tag for student school enrolment

n/a

ACTION

This is the action associated with this submission

Value: "ADD" "UPDATE"

PowerSchool Business Rules:

If the student is enrolled at the start of the school term and student's exit date is beyond the count date of the current submission, the school enrolment segment is generated with the 'UPDATE' action if the student data exists in the PAE extract file (extract #003)

If the student is enrolled at the start of the school term and student's exit date is beyond the count date of the current submission, and the student data does not exist in the PAE extract file the school enrolment segment is generated with the 'ADD'

If the student is enrolled at the start of the school term and student has transferred out within the current submission, the school enrolment segment is generated with the 'UPDATE' action if the student data exists in the PAE extract file (extract #003)

If the student is enrolled at the start of the school term and student has transferred out during the current submission, and the student data does not exist in the PAE extract file the school enrolment segment is generated with the 'ADD'

If the student is enrolled during the current submission period date and transferred out before the end of the current submission period date (note the PAE extract #003 will not have data for this student), the school enrolment segment is generated with the 'ADD' action only if the student has Report Card Segments; otherwise, no school enrolment segment is generated for this student.

If there are multiple enrolments in the current submission period for this student, only one enrolment (the one with the earliest entry date) will qualify for the submission.

If the student is enrolled AFTER the start of the current submission period and remains currently enrolled at the school. (Note the PAE extract file will not have data for this student), The school enrolment segment is generated with the 'ADD' action

If a student is present in the student school enrolment PAE file (#0003) but there is no enrolment for this student between the submission period start date and count date in for this school in PowerSchool, then the school enrolment segment is created with the "UPDATE" action.

The above scenario usually indicates a data error in the previous school data submission between PowerSchool and the OnSIS system.

n/a

GRADE_TYPE

When the ACTION of STUDENT_SCHOOL_ENROLMENT is "ADD", this element is mandatory.

Valid entries are: JK, K, 1-8.

If ACTION is "ADD" or "UPDATE" then

[ON_OnSIS_Snapshot]Grade_level if the snapshot record exists; otherwise, [Students/ReEnrollments]Grade_Level

If ACTION is "UPDATE" for a non-returning student then [ON_School_Enrollments]grade_type if defined; otherwise, use grade level from previous enrolment.

CLASS_CODE

The CLASS_CODE is used to uniquely identify the class. This element is Mandatory. This value is generated by the OnSIS Create Class Codes process.

PowerSchool Business Rules:

the <Class_Code> tag has the following format: Trim(Courses.Course_Number) + '-' + Trim(Sections.Section_Number)

Embedded spaces are removed. Converted to upper case.

Only Classes where the Course_type is 'H' (Homeroom) are selected. The homeroom class in which the student is enrolled as of the submission period count date is reported.

For example: HRM001-05

Class_code will not be printed if the student leaves the school or dropped his homeroom class before the count date.

If ACTION is "ADD" or "UPDATE" then [S_ON_SEC_X]Class_Code where [S_ON_CRS_X]Course_Type = 'H'

If ACTION is "UPDATE" for a non-returning student then [ON_School_Enrollments].class_code

LANGUAGE_TYPE

When the ACTION of STUDENT_SCHOOL_ENROLMENT is "ADD", this element is mandatory.

PowerSchool Business Rules:

This value will be set to 'F' if the [PREFS]ON_French_Board_Flag is enabled; otherwise, set to 'E'.

If ACTION is "ADD" or "UPDATE" then 'F' if [Prefs]Name = 'ON_French_Board_Flag' = '1'.

Set to 'B' if selected submission type is "Private School" or "380 Private School".

Otherwise, default to 'E'.

STU_BRD_RES_STAT_TYPE

Board Residence Status

When the ACTION of STUDENT_SCHOOL_ENROLMENT is "ADD" this field is mandatory.

When Main School Flag is 'F' for non-returning students,or cross enrolled students set to '08.

When Not Main School Flag is 'T', set to '08'.

OnSIS Business Rules:

Elementary students cannot have a Board Residence Status Type = "E-Learning".

If ACTION is "ADD" or "UPDATE" then  [S_ON_STU_X]/[S_ON_REN_X]Brd_Res_Status.

The value is calculated by the GetStudentEnrolmentFieldBSID function, described in the Enrolment Fields Report.

CURRENT_RESIDENCE_COUNTRY

The student's current country of residence.

CURRENT_RESIDENCE_COUNTRY is ignored if CURRENT_RESIDENCE_PROVINCE is populated; otherwise, CURRENT_RESIDENCE_COUNTRY is populated if Country (Current Residence) UI field is not Canada.

ON_OnSIS_Snapshot]Curr_Country if the snapshot record exists; otherwise, [S_ON_REN/STU_X]Curr_Country

CURRENT_RESIDENCE_PROVINCE

The student's current province of residence.

If CURRENT_RESIDENCE_PROVINCE is populated, CURRENT_RESIDENCE_COUNTRY is ignored.

If Country (Current Residence) and Province (Current Residence) UI fields are not populated or if Country (Current Residence) is Canada and Province (Current Residence) is not populated, CURRENT_RESIDENCE_PROVINCE is set to Ontario.

ON_OnSIS_Snapshot]Curr_Province if the snapshot record exists; otherwise, [S_ON_REN/STU_X]Curr_Province

ATTENDANCE_TYPE

Attendance Type

When the ACTION of STUDENT_SCHOOL_ENROLMENT is "ADD", this element is mandatory.

If [Students/Reenrollments]EnrollmentType is defined (i.e. there is an override), use that value.

ATTENDANCE_TYPE for Shared Students (board residence status '08') is "PT".

ATTENDANCE_TYPE for e-learning students (board residence status of '09') is "PT".

If student grade is JK or K, and the student is 6 years or older as of December 31 of that academic year, then the attendance type for that student is "FT"

ATTENDANCE_TYPE for Student between the age of 14 and 17 as of December 31 of that academic year enrolled in SAL program less than 70 minutes (SAL program 001) is 'PT'.

ATTENDANCE_TYPE for Student between the age of 14 and 17 as of December 31 of that academic year enrolled in SAL program greater than 70 minutes (SAL program 002) is 'FT'.

ATTENDANCE_TYPE for Student enrolled in an expulsion program (i.e. [S_ON_GEN_SPECPROG_X]Expulsion_Flag is true for the associated program) is 'FT'.

if Board Residence = "other student" (board residence status of '07') or 'board pupil' (board residence status of 01) and the student is enrolled only in independent study classes ([S_ON_SEC_X]IsIndependentStudy_Class flag or [S_ON_CC_X]IsIndependentStudy_Class is on) at the school of primary enrolment, ATTENDANCE_TYPE is PT

Age is calculated as of December 31st of the current academic year.

Because attendance type and FTE are not pre-populated in the PAE file, for non-returning students, unless subject to the rules above, the number of minutes in the student's schedule from the previous year is used to determine these values. If a non-returning student has no schedule in the prior year (i.e., no minutes scheduled) and the student is not subject to one of the rules above, the attendance type is set to 'FT' and FTE is set to '1.00'.

When Main School Flag is 'F' for non-returning/cross enrolled students, set to 'PT'

When Not Main School Flag is 'T', Attendance Type is 'PT' and FTE is 0.00

For other students the attendance type is derived from the number of minutes to which the student is scheduled on the latest "in-session" day on or before the submission period count date, or the last day on which the student was enrolled if the student withdrew during the submission period). Minutes for courses taken at night schools ([S_ON_SCH_X]IsNightSchool is true) are excluded.

Attendance Type is set as follows:

When minutes enrolled >= 210, then 'FT'

When minutes enrolled = 0, then default to 'PT'

Otherwise, 'PT'

OnSIS Business Rules:

Where the student is Active, if Board Residence Status = Shared Student then FTE = 0.00, attendance_type = 'PT' and Main School Flag = N

If ACTION is "ADD" or "UPDATE" then calculated by as described to the left if [Students/Reenrollments]Attendance_Type is blank (i.e. is not overridden).

Otherwise, uses value in [Students/ReEnrollment]Attendance_Type.

The value is calculated by the GetStudentEnrolmentField function, described in the Enrolment Fields Report.

JK_TIMETABLE_TYPE

NOT GENERATED STARTING 2014-2015.

Only generated for students in grades JK and K.

OnSIS Business Rules:

When "JK/SK Timetable Type" = Other is selected, Half time Other Description (new field) must be populated. Otherwise, Half time Other Description must be display-only.

If ACTION is "ADD" or "UPDATE" for a returning student, then [Students/ReEnrollments] ON_TimetableType

If ACTION is "UPDATE" for a non-returning then [Students/ReEnrollments] ON_TimetableType; otherwise, [ON_School_Enrollments]jk_timetable_type

EDP_TYPE

For Grade = JK or K, if [S_ON_STU_X]/[S_ON_REN_X] ExtendedDayProgram is undefined, a value of 'NO' is submitted.

No value is extracted for students in grades 1 - 12 regardless of the value of [S_ON_STU_X]ExtendedDayProgram.

If ACTION is "ADD" or "UPDATE" then [S_ON_STU_X]/[S_ON_REN_X] ExtendedDayProgram.

OTHER_HALFTIME_DESC

NOT GENERATED STARTING 2014-2015.

Other Half Time Description

If JK_ TIMETABLE _TYPE = "O" (other), OTHER_HALFTIME_DESC will be extracted.

Otherwise, the field will be updated to a null value.

If ACTION is "ADD" or "UPDATE" then [Students/Reenrollments] ON_HalftimeDesc

If ACTION is "UPDATE" for a non-returning then [ON_School_Enrollments]other_halftype_desc

RESIDENCE_STATUS_TYPE

When the ACTION of STUDENT_SCHOOL_ENROLMENT is "ADD", this element is mandatory

If ACTION is "ADD" or "UPDATE" then Value is extracted from [ON_OnSIS_Snapshot]Residence_Status if the snapshot recor d exists; otherwise  [S_ON_STU_X]/[S_ON_REN_X] Residence_Status

If ACTION is "UPDATE" for a non-returning then [ON_School_Enrollments]resident_status_type

INDIGENOUS_SELF_IDENTIFICATION

OnSIS Business Rules:

In the case of UPDATE action, if an empty tag is provided, the field will be updated to a null value. If no tag is provided, the field will be ignored.

This element is not generated for private school submissions.

If ACTION is "ADD" or "UPDATE" then [S_ON_STU_X]Aboriginal_Type

If ACTION is "UPDATE" for a non-returning then [ON_School_Enrollments]aboriginal_self_identification

STUDENT_MOBILITY_TYPE

Entry Code

When the ACTION of STUDENT_SCHOOL_ENROLMENT is "ADD", this element is mandatory.

When the ACTION of the STUDENT_SCHOOL_ENROLMENT is 'UPDATE', this element will be "IA". COUNTRY_TYPE, PROVINCE_STATE_TYPE and LANGUAGE_TYPE_PREVIOUS_SCH are always empty when STUDENT_MOBILTY_TYPE is "IA".

If ACTION is "ADD" then [students/ReEnrollments]EntryCode - the extracted value is the ministry code ([Gen]Value2) to which the entry code has been mapped

If ACTION is "UPDATE" then always 'IA'

If ACTION is "UPDATE" for a non-returning then [ON_School_Enrollments]student_mobility_type

For Cross enrolled students set to '05'

COUNTRY_TYPE

Country of Entry

Not defined if STUDENT_MOBILITY_TYPE is "IA" (Internal Admission).

Only defined if STUDENT_MOBILITY_TYPE = "36" (admission from out of country).

STUDENT_MOBILITY_TYPE = "36" and Entry_Country = "CAN", the value is sent so that an OnSIS error is generated informing the user of the data inconsistency.

If ACTION is "ADD" or "UPDATE" then

ON_OnSIS_Snapshot]Entry_Country if the snapshot record exists; otherwise, [S_ON_STU_X]/[S_ON_REN_X]Entry_Country

If ACTION is "UPDATE" for a non returning then [ON_School_Enrollments]country_type

PROVINCE_STATE_TYPE

Province of Entry

Defined only if ACTION is ADD and STUDENT_MOBILITY_TYPE is "35" (Another Province/Territory).

Not defined if STUDENT_MOBILITY_TYPE is "IA" (Internal Admission).

If ACTION is "ADD" then

ON_OnSIS_Snapshot]Entry_Province if the snapshot record exists; otherwise,

[S_ON_STU_X]/[S_ON_REN_X]Entry_Province

LANGUAGE_TYPE_PREVIOUS_SCH

Language Type Previous School.

Defined only if ACTION is ADD and STUDENT_MOBILITY_TYPE is "35" (Another Province/Territory).

Otherwise, the field will be updated to a null value.

If ACTION is "ADD" then

ON_OnSIS_Snapshot]Entry_Language if the snapshot record exists; otherwise, [S_ON_STU_X]/[S_ON_REN_X]Entry_Language

If undefined, if [Prefs]Value = 1 where [Prefs]Name = 'ON_French_Board' use 'F; otherwise, use 'E'.

STUDENT_MOBILITY_TYPE_EXIT

Exit Code

For cross-enrolled students (i.e. <MAIN_SCHOOL_FLAG> = 'F') the exit code is "64" (retirement - other).

For non-returning students, if a current year no show enrolment record is present, the report uses the exit code from the previous year enrolment record.

If ACTION is "ADD" or "UPDATE" then [Students/Reenrollments]ExitCode - the extracted value is the ministry code ([Gen]Value2) to which the exit code has been mapped

If ACTION is "UPDATE" for a non returning then [Students/ReEnrollments]exitcode for no show record, if exists (Not used if exitcode = 'NS' or is defined but not mapped to a valid ministry exit code); otherwise, [Students/ReEnrollments]exitcode for prior year.

COUNTRY_TYPE_EXIT

Country of Exit

Only extracted if the database value is not "CAN" and the associated exit code is '68' (moved outside Ontario).

For non-returning students with an exit code of NS (no show) the value is taken from the most recent enrolment record prior to the no show enrolment.

If ACTION is "ADD" or "UPDATE"

And [Students/Reenrollments]ExitCode is not empty and [S_ON_STU_X]/[S_ON_REN_X]Exit_Country not = 'CAN' then [S_ON_STU_X]/[S_ON_REN_X]Exit_Country

PROVINCE_STATE_TYPE_EXIT

Province of Exit

Only extracted if the database value is not "ON" and the associated exit code is '68' (moved outside Ontario).

For non-returning students with an exit code of NS (no show) the value is taken from the most recent enrolment record prior to the no show enrolment.

If ACTION is "ADD" or "UPDATE" And [Students/Reenrollments]ExitCode is not empty and [S_ON_STU_X]/[S_ON_REN_X]Exit_Province not = 'ON' then [S_ON_STU_X]/[S_ON_REN_X]Exit_Province

POSTAL_AREA_TYPE

Postal Code

Format = "AnA nAn"

Populated only if PROVINCE_CURRENT_RESIDENCE is Ontario; otherwise, null.

If ACTION is "ADD" or "UPDATE"

If [S_ON_REN/STU_X]Curr_Province is Ontario, then ON_OnSIS_Snapshot]PostalCode if the snapshot record exists; otherwise, [Students]Zip

If ACTION is "UPDATE" for a non returning and [S_ON_REN/STU_X]Curr_Province is Ontario, then [ON_School_Enrollments]postal_area_type

COUNTRY_TYPE_BIRTH

Country of Birth

PowerSchool Business Rules:

If the student is born in Canada, this defaults to NULL.

OnSIS Business Rules:

Both Country of birth and Province of birth cannot be identified at the same time; only one or the other can be selected. If Province of birth is present it is reported and Country of birth is not.

If ACTION is "ADD" or "UPDATE" and [S_ON_STU_X]Birth_Country not empty and not = 'CAN' then [S_ON_STU_X]Birth_Country

If ACTION is "UPDATE" for a non returning then [ON_School_Enrollments]country_type_birth

If the value in the database is "CAN" or empty the value of the element is empty.

PROVINCE_STATE_TYPE_BIRTH

Province of Birth

OnSIS Business Rules:

In the case of UPDATE action, if an empty tag is provided, the field will be updated to a null value. If no tag is provided, the field will be ignored.

If ACTION is "ADD" or "UPDATE" and [S_ON_STU_X]Birth_Country = 'CAN' or is empty then [S_ON_STU_X]Birth_Province. If undefined then "ON".

If ACTION is "UPDATE" for a non returning then [ON_School_Enrollments]province_state_type_birth

YEAR_OF_ENTRY_TO_CANADA

Date of entry into Canada. Format YYYY/MM

In the case of UPDATE action, if an empty tag is provided, the field will be updated to a null value. If no tag is provided, the field will be ignored.

If ACTION is "ADD" or "UPDATE" then [S_ON_STU_X]Year_Of_Entry

If ACTION is "UPDATE" for a non returning then [ON_School_Enrollments]year_of_entry_to_canada

MAIN_SCHOOL_FLAG

Flag indicator if enrolled in main school

When the ACTION of STUDENT_SCHOOL_ENROLMENT is "ADD", this element is mandatory.

Set to F if Board Residence Status = '08' or '09' for Shared Student or E-Learning Student.

Set to F if Board Residence = "other student" (board residence status of '07') or 'board pupil' (board residence status of 01) and the student is enrolled only in independent study classes ([S_ON_SEC_X]IsIndependentStudy_Class flag or [S_ON_CC_X]IsIndependentStudy_Class is on) at the school of primary enrolment.

Set to F if 'NOT_MAIN_SCHOOL_FLAG' = T

OnSIS Business Rules:

If the student was or is currently enrolled in this school, the MAIN_SCHOOL_FLAG element value is 'T'

If the student was or is cross-enrolled in this school, the MAIN_SCHOOL_FLAG element value is 'F'.

If ACTION is "ADD" or "UPDATE" then determined by business rules

If ACTION is "UPDATE" for a non returning then [ON_School_Enrollments]main_school_flag

SCHOOL_STUDENT_NUMBER

School student number.

If ACTION is "ADD" or "UPDATE" then [Students]student_number

If ACTION is "UPDATE" for a non returning then [ON_School_Enrollments]school_student_number

FRENCH_ADMISSION_APPROVAL_DATE

French admission committee approval date.

If ACTION is "ADD" and [S_ON_STU_X]French_Approval_Date not empty then [S_ON_STU_X]French_Approval_Date

DAYS_ABSENT_YTD

Total Days absent (Year to date).

October and March submissions: Data is only calculated for students who withdrew during the submission period.

June submission: Data is calculated for all students.

The total number of absences include attendance types 'A', 'C', and 'G' (Absent, Contacted, G-Days). Days absent due to G days set at the school calendar during the period the student is enrolled at the school are also counted.

For cross enrolled students, this value is reported only from the home school. When Count Meeting attendance at another school's flag is ON, combined attendance is calculated, otherwise, only the attendance taken at the main school is calculated.

Derived

SCHOOL_CLOSURE_DAYS_ABSENT_YTD

Starting 2021-2022 onwards this tag is included to collects absence during school closure.

October and March submissions: Data is only calculated for students who withdrew during the submission period.

June submission: Data is calculated for all students.

This is the number of days the student is absent due to school closure where the school calendar is set to G during the period the student is enrolled at the school.

Students cross enrolled at another school:

• If 'Count meeting attendance at another school flag' is ON, it is the number of days the cross enrolled school have G days on the school calendar set to G during the period the student was cross enrolled at the other school.

• if 'Count meeting attendance at another school flag' is OFF: then G days on the cross enrolled school calendar are not counted.

• If the student moves from in person to remote or vise versa during his primary enrolment in the main school, SCHOOL_CLOSURE_DAYS_ABSENT_YTD will be the sum of G dates calculated as per the above rules for the period from the start to the end date of his school enrolment.

Derived

TIMES_LATE_YTD

The number of times the student was late (Year to date).

October and March submissions: Data is only calculated for students who withdrew during the submission period.

June submission: Data is calculated for all students.

For cross enrolled students, this value is calculated based on the attendance taken at the school running the report.

Derived

LOCAL_SCHOOL_PROGRAM_FLAG

Local school program flag.

PowerSchool Business Rules:

If this flag is enabled, then set to 'T'; otherwise, default to NULL

If ACTION is "ADD" or "UPDATE" then [S_ON_STU_X]/[S_ON_REN_X]Local_Program

If ACTION is "UPDATE" for a non returning then [ON_School_Enrollments]local_school_program_flag

Not reported for Cross enrolled students.

FTE

Full Time Equivalent

Not extracted if selected submission type is "Private School" or "380 Private School".

When the ACTION of STUDENT_SCHOOL_ENROLMENT is "ADD" - public elementary / secondary school this field is mandatory.

If [S_ON_STU_X]/[S_ON_REN_X]FTE is defined (i.e. there is an override), use that value.

FTE for a student between the age of 14 and 17 as of December 31 of that academic year enrolled in SAL program less than 70 minutes (SAL program 001) is 0.5.

FTE for a student between the age of 14 and 17  as of December 31 of that academic year enrolled in SAL program greater than 70 minutes (SAL program 002) is 1.0.

FTE for a student enrolled in an expulsion program (i.e. [S_ON_GEN_SPECPROG_X]Expulsion_Flag is true for the associated program) is 1.0.

if Board Residence = "other student" (board residence status of '07') or 'board pupil' (board residence status of 01) and the student is enrolled only in independent study classes ([S_ON_SEC_X]IsIndependentStudy_Class flag or [S_ON_CC_X]IsIndependentStudy_Class is on) at the school of primary enrolment. FTE is 0.0.

Otherwise, FTE is calculated based on number of minutes scheduled, either on the last "in-session" day on or before the submission period count date or the last day the student was enrolled if the student withdrew during the submission period, unless the student is a shared student (board residence status of '08) or an e-learning student (board residence status of '09') in which case report 0.0. Minutes for courses taken at night schools ([S_ON_SCH_X]IsNightSchool is true) are excluded. Minutes for independent study classes are excluded.

FTE is set as follows

If attendance type is 'FT' and minutes enrolled > 0, calculate the least of minutes enrolled/300 or 1.0

If attendance type is 'PT' calculate the least of minutes enrolled/300 or 0.4

• unless the student is an shared student (board residence status of '08') or an e-learning student (board residence status of '09') in which case report 0.0

If minutes enrolled = 0, default to 1.0

Because attendance type and FTE are not pre-populated in the PAE file, for non-returning students, unless subject to the rules above, the number of minutes in the student's schedule from the previous year is used to determine these values. If a non-returning student has no schedule in the prior year (i.e. no minutes scheduled) and the student is not subject to one of the rules above, the attendance type is set to 'F' and FTE is set to '1.00'.

When Main School Flag is 'F' for non-returning/cross enrolled students, set to 0.0

When Not Main School Flag is 'T', FTE is 0.00'.

Maximum number of decimal places is 2.

OnSIS Business Rules:

Full time equivalency (FTE) must be within the range of 0.04 - 1.00 within the same school UNLESS BOARD RESIDENCE STATUS = SHARED STUDENT, then FTE = 0

If Elementary school and student's Attendance Type = PT, FTE must be > = 0.04 and <= 0.69. UNLESS BOARD RESIDENCE STATUS = SHARED STUDENT then FTE = 0.

If Elementary school and student's Attendance Type = FT, FTE must be > = 0.70 and <= 1.00. UNLESS BOARD RESIDENCE STATUS = SHARED STUDENT, then FTE = 0.

If ACTION is "ADD" or "UPDATE" use [S_ON_STU_X]/[S_ON_REN_X]FTE if defined (i.e. FTE is overridden).

Otherwise, calculated based on the rules in the description.

The value is calculated by the GetStudentEnrolmentField function, described in the Enrolment Fields Report.

PROMOTION_FLAG

Indicates whether the student is promoted to the next grade.

OnSIS Business Rules:

This element should only be present in the June Submission period.

If ACTION is "ADD" or "UPDATE" then if [Students] grade_level_next > [Students]grade_level, then 'T'; otherwise 'F'

If ACTION is "UPDATE" for a non returning then [ON_School_Enrollments]promotion_flag

SPECIAL_EDUCATION_FLAG

Indicates whether the student receives special education.

OnSIS Business Rules:

If the <SPECIAL_EDUCATION_FLAG> is T, then a Special Education segment must be submitted in this submission.

For a student who left the reporting school, the SPECIAL_EDUCATION_FLAG is T or F, based on whether or not the student was in the Special Education program as of the student's last day in school.

If ACTION is "ADD" or "UPDATE" then determined if student has at least one spenrollment record where gen.spedIndicator = 1, The student must be enrolled in the special education program as of the submission period count date, or if the student withdraws from school, the student must be enrolled in the special education program as of the last day of school enrollment.

If ACTION is "UPDATE" for a non returning then [ON_School_Enrollments]special_education_flag

GENDER_TYPE

Student's gender

Valid values:

• M

• F

• N (Prefer not to disclose)

• S (Prefer to Specify)

[ON_OnSIS_Snapshot]Gender if the snapshot record exists; otherwise, [Students]Gender

For non-returning students and deleted students, from previous submission snapshot record if it exists; otherwise, [Students]Gender

getStudentGenderReportValues function is used to get the student's gender type from the code sets tables.

GENDER_DESC

Student's gender description. This field is only populated when Gender is set to S for the student.

getStudentGenderReportValues function is used to get the student's gender desc from the code sets tables.

ENROLMENT_START_DATE

Enrolment start date. Format = yyyy/mm/dd

For cross-enrolled students (i.e. <MAIN_SCHOOL_FLAG> = 'F') the enrolment start date is the earliest [CC]DateEnrolled that falls within the submission period from the classes that cause the cross enrollment.

OnSIS Business Rules:

For students enrolled in any previous submission at this school, the following fields are non-modifiable when pre-populated from a previous submission: Enrolment Start Date, Admission From. This business rule is applicable to student school enrolment records that were pre-populated only. In this case, the Admission From Student Mobility field is equal to Internal Admission ("IA").

If the student was enrolled in the school prior to the first day of the submission period date range (e.g. Oct submission has a date range of Nov 1, YYYY to Oct 31, YYYY + 1), then the enrolment start date equal the first day of the Student's last entry into the school (regardless of in which school year this occurred). This will identify the student as having been enrolled in the school from the beginning of the submission cycle.

If the student enrolled in the school on or after the first day of the submission period date range, the enrolment start date will equal the date the student enrolled in the school. The mobility code (Admission From) will identify where the student has come from.

If ACTION is "ADD" then [ [Students/Reenrollments]entryDate

If ACTION is "UPDATE" then [ON_School_Enrollments]enrolment_start_date

ENROLMENT_END_DATE

Enrolment end date. Format = yyyy/mm/dd

For cross-enrolled students (i.e. <MAIN_SCHOOL_FLAG> = 'F') the enrolment end date is the latest [CC]DateLeft that falls within the submission period from the classes that cause the cross enrollment. If the latest date left is after the end of the submission period, the student is still considered cross-enrolled and no enrolment end date is submitted.

For all submissions, if a student's withdrawal date in PowerSchool does not fall within the current submission period; no enrolment end date is submitted.

In a June submission, if the student's withdrawal date is after the last day in the school's calendar (i.e. the student was enrolled on the last day of school) then the submitted enrolment end date is empty.

In an October submission if the student appears in the PAE file (i.e. no enrolment end date was submitted in June) but the student is not enrolled for the current year and the student's last withdrawal date after the last day of previous school year but before July 1, then July 1 is submitted. Otherwise, if the student appears in the PAE file and is not enrolled for the current year and the latest withdrawal date is July 1 or later, then the withdrawal date is submitted.

OnSIS Business Rules:

If the student does not depart the school during the submission cycle, the enrolment end date and Transfer/Retirement code will remain blank.

If ACTION is "ADD" or "UPDATE" then [Students/Reenrollments]ExitDate

If ACTION is "UPDATE" for a non returning student then set end date in this order:

If Main School Flag is F or it is the October submission, set to first day of submission period

If [Students/Reenrollments]ExitDate less than [ON_School_Enrollments]enrolment_start_date, set to first day of submission

Otherwise, [Students/ReEnrollments]Exit Date

SAL_Flag

This flag is set to true:

• If the student is in a SAL program as of the Count date.

• If a segment exists where the Start date is earlier or on the Submission Start date and the Exit date is undefined or after the Count date.

• For June submission set to true if the exit date is is after or on the Count date.

STU_EARLY_YR_EXPERIENCE

This is the outer tag for the Early Child Experience survey.

ACTION

Indicates whether STU_EARLY_YR_EXPERIENCE is added or ready for deletion.

Is always set to ADD.

N/A

NO_REPORT_FLAG

Indicates whether there is Early Years Experiences data to report.

Valid values: 'T', 'F'

Is set to 'F' if School Year Survey Completed ([S_ON_STU_X]YearSurveyCompleted) is not set for the student, or if it is set but there is no data to report (none of the questions are answered); otherwise, is set to 'T'. Questions 3 and 7 are ignored.

The following Segments are not generated if this field is set to F.

[S_ON_STU_X]YearSurveyCompleted

STU_EARLY_YR_QUESTION

This is the outer tag for question "4. Have you heard about child and family centres in your community?"

This tag is not generated if question 4 is not answered.

ACTION

Indicates whether STU_EARLY_YR_QUESTION is added or ready for deletion.

Is always set to ADD.

N/A

QUESTION_CODE

The code of the question.

Related to question 4.

Is set to EY_Q01

ANSWER

The answer to question 4.

Valid values:

1 - Y

0 - N

If [S_ON_STU_X]EarlyYrsKnowledgeYN is 1, Y is reported; if 0, N is reported.

[S_ON_STU_X]EarlyYrsKnowledgeYN

STU_EARLY_YR_CC_PRG_HEADER

This is the outer tag for childcare center header information

Question 1. "For each age period, what was the MAIN type(s) of child care for the child you are registering for kindergarten?" and

Question 2. "If the child you are registering for school participated in licensed child care in a care centre or a home, please list the name(s) of your licensed child care centre or licensed home child care agency for each age period".

This tag/Segment is not generated if the user did not answer Questions 1 and 2 and, when generated, only elements with values are reported.

ACTION

Indicates whether STU_EARLY_YR_CC_PRG_HEADER is added or ready for deletion.

Question 1 and Question 2

Is always set to ADD.

N/A

EARLY_YR_CHILD_AGE_GRP_TYPE_CODE

The code for the child's age group.

Valid values:

010 - 0 up to 12 Months (>0 to <12 months)

020 - 12 Months to 18 Months (>=12 months to < 18 months)

030 - 18 Months to 24 Months (>= 18 months to <24 months)

040 - 24 Months to 2.5 Years (>=24 months to <2.5 years)

050 - 2.5 Years up to Present (>=2.5 years to present)

[S_ON_STU_EARLYYEARS_C]AgeofChildCode

NO_ANSWER_FLAG

Indicates whether the participant prefers not to answer.

Valid values 'T' or 'F'.

If the user didn't answer question 1 for the age group (all checkboxes are 0), then the element is not generated; otherwise, if the question 1:"Don't Remember/Prefer Not to Answer" checkbox is selected, then T; otherwise F.

[S_ON_STU_EARLYYEARS_C]DoNotAnswerCare

STU_EARLY_YR_CC_PRG_DETAIL

This is the outer tag for child care center detail for Early Child Experience survey.

ACTION

Indicates whether STU_EARLY_YR_CC_PRG_DETAIL is added or ready for deletion.

Is always set to ADD.

N/A

CHILDCARE_LICENSE_NUMBER

The license number of the licensed childcare centre or licensed home child care agency.

If question 2 license number is not defined for the same age group, this element is not generated.

Note: Generated only if the CHILDCARE_TYPE_CODE is 004 (LicensedHome-BasedChildCareAgency) or 005 (LicensedChildCareCentre)

[S_ON_STU_EARLYYEARS_C]LicenseNumber

CHILDCARE_TYPE_CODE

The type of childcare

This element is created if the next element has a value; otherwise, both elements are omitted.

Valid values:

001 - Parent Guardian Care Code

002 - UnpaidCareCode

003 - Paid Care Code

004 - Licensed Home Care Code

005 - Licensed Child Care Code

Note: If 004 or 005, the following must be populated:

CHILDCARE_LICENSE_NUMBER.

OTHER_CHILDCARE_CENTRE_NAME

OTHER_CHILDCARE_CENTRE_ADR

OTHER_CHILDCARE_CENTRE_CITY

[S_ON_STU_EARLYYEARS_C]ParentGuardianCareCode

[S_ON_STU_EARLYYEARS_C]UnpaidCareCode

[S_ON_STU_EARLYYEARS_C]PaidCareCode

[S_ON_STU_EARLYYEARS_C]LicensedHomeCareCode

[S_ON_STU_EARLYYEARS_C]LicensedChildCareCode

[S_ON_STU_EARLYYEARS_C]LicensedCareNA

CHILDCARE_ATTENDANCE_TYPE_CODE

The code for the childcare attendance type.

If both the Full Time checkbox and Part Time checkbox for the childcare type are selected, this is the Attendance type code for both.

If only the Full Time checkbox is selected for the childcare type, this is the Attendance type code for Full time.

If only the Part Time checkbox is selected for the child care type, this is the Attendance type code for Part time.

Valid values:

1 - Yes

0 - No

[S_ON_STU_EARLYYEARS_C]LicensedChildCareFT

[S_ON_STU_EARLYYEARS_C]LicensedChildCarePT

[S_ON_STU_EARLYYEARS_C]LicensedHomeCareFT

[S_ON_STU_EARLYYEARS_C]LicensedHomeCarePT

[S_ON_STU_EARLYYEARS_C]PaidCareFT

[S_ON_STU_EARLYYEARS_C]PaidCarePT

[S_ON_STU_EARLYYEARS_C]ParentGuardianCareFT

[S_ON_STU_EARLYYEARS_C]ParentGuardianCarePT

[S_ON_STU_EARLYYEARS_C]UnpaidCareFT

[S_ON_STU_EARLYYEARS_C]UnpaidCarePT

OTHER_CHILDCARE_CENTRE_NAME

The name of the other childcare centre.

Note: generated only if the CHILDCARE_TYPE_CODE is 004 (LicensedHome-BasedChildCareAgency) or 005 (LicensedChildCareCentre)

[S_ON_STU_EARLYYEARS_C]CCC_HCCA_Name

OTHER_CHILDCARE_CENTRE_ADR

The street address of the other childcare centre.

Note: generated only if the CHILDCARE_TYPE_CODE is 004 (LicensedHome-BasedChildCareAgency) or 005 (LicensedChildCareCentre)

[S_ON_STU_EARLYYEARS_C]StreetName

OTHER_CHILDCARE_CENTRE_INTER

The intersection of the other child care centre.

Note: This data is not collected.

N/A

OTHER_CHILDCARE_CENTRE_CITY

The city of the other childcare centre.

Note: generated only if the CHILDCARE_TYPE_CODE is 004 (LicensedHome-BasedChildCareAgency) or 005 (LicensedChildCareCentre)

[S_ON_STU_EARLYYEARS_C]City

STU_EARLY_YR_CC_ACTIVITY_REG

This is the outer tag for school participation.

Question "5. At each age, how often did the child who you are registering for school participate in an Ontario Early Years Child & Family Centre?"

Question "6. At each age, how often did the child you are registering for school participate in other activities in your community?"

This tag/Segment is not generated if the user did not answer question 5 and question 6.

ACTION

Indicates whether STU_EARLY_YR_CC_ACTIVITY_REG is added or ready for deletion.

Always ADD.

N/A

EARLY_YR_CHILD_AGE_GRP_TYPE_CODE

The code for the child's age group.

010 - 0 up to 12 Months (>0 to <12 months)

020 - 12 Months to 18 Months (>=12 months to < 18 months)

030 - 18 Months to 24 Months (>= 18 months to <24 months)

040 - 24 Months to 2.5 Years (>=24 months to <2.5 years)

050 - 2.5 Years up to Present (>=2.5 years to present)

[S_ON_STU_EARLYYEARS_C]AgeofChildCode

CC_CENTRE_FREQ_TYPE_CODE

Indicates how often the child obtained care - question 5

Valid values

001 - Once or More Per Week

002 - One to Three Times a Month

003 - Several Times a Year

004 - Once Per Year

005 - Did Not Participate

099 - Prefer not to answer

[S_ON_STU_EARLYYEARS_C]EarlyChildCareFrequency

OTHER_ACTIVITY_FREQ_TYPE_CODE

Indicates how often the child participated in other activities - question 6

001 - Once or More Per Week

002 - One to Three Times a Month

003 - Several Times a Year

004 - Once Per Year

005 - Did Not Participate

099 - Prefer not to answer

[S_ON_STU_EARLYYEARS_C]EarlyOtherActivity

Data Element

Description

[Table]FieldName

SPECIAL_EDUCATION

This is the outer tag for student special education.

n/a

ACTION

This is the action associated with this submission.

Value: "ADD" "UPDATE" "DELETE"

n/a

EXCEPTIONALITY_TYPE

Field can be null. This field is conditional field. Exceptionality Type Code must be completed if the Non Identified Student Flag = "F". Exceptionality Type Code must be empty if the Non Identified Student Flag = "T".

Exceptionality type must be present if MAIN_EXCEPTIONALITY_FLAG is "T".

Element EXCEPTIONALITY_TYPE is used to uniquely identify the special education.

If Action is ADD or UPDATE then [S_ON_SEN_X]Exceptionality

A database value of "NONIDE" is reported as blank as that value is valid only for care and treatment centre facilities.

If Action is DELETE then [ON_SPECIAL_EDUCATIONS] EXCEPTIONALITY_TYPE

SPECIAL_EDU_PLMNT_TYPE

When the ACTION of SPECIAL_EDUCATION is "ADD", this element is mandatory.

If Action is ADD or UPDATE then [S_ON_SEN_X]Placement

If Action is DELETE then [ON_SPECIAL_EDUCATIONS] SPECIAL_EDU_PLMNT_TYPE

NON_IDENTIFIED_STUDENT_FLAG

Indicates whether the student is non-identified.

When the ACTION of SPECIAL_EDUCATION is "ADD", this element is mandatory.

If Action is ADD or UPDATE and [S_ON_SEN_X]Exceptionality does not exist then T else F

When null or 'NONIDE' then 'T'

Otherwise, 'F'

If Action is DELETE then [ON_SPECIAL_EDUCATIONS] NON_IDENTIFIED_STUDENT_FLAG

MAIN_EXCEPTIONALITY_FLAG

Flag indicator for Special education funding. Used to identify the prime exceptionality for a student.

When the ACTION of SPECIAL_EDUCATION is "ADD", this element is mandatory.

If Action is ADD or UPDATE then evaluate [S_ON_SEN_X]Main_Flag

When 1 then 'T'

When 0 then 'F'

Otherwise, 'F'
If Action is DELETE then [ON_SPECIAL_EDUCATIONS] MAIN_EXCEPTIONALITY_FLAG

IPRC_REVIEW_DATE

Identification, Placement and Review Committee date. Format = yyyy/mm/dd.

Only defined if IPRC_STUDENT_FLAG is "T".

If Action is ADD or UPDATE then [S_ON_SEN_X]IPRC_Date

If Action is DELETE then [ON_SPECIAL_EDUCATIONS] IPRC_REVIEW_DATE

IPRC_STUDENT_FLAG

Flag indicator for identification, placement and review committee.

When the ACTION of SPECIAL_EDUCATION is "ADD", this element is mandatory.

This element is automatically set to 'T' when the EXCEPTIONALITY_TYPE element is populated.

If Action is ADD or UPDATE then Set to 'T' if [S_ON_SEN_X]Exceptionality is not NULL

Otherwise, 'F'

If Action is DELETE then [ON_SPECIAL_EDUCATIONS] IPRC_STUDENT_FLAG

INDIVIDUAL_EDUCATION_PLAN_FLAG

Flag indicator for individual education plan.

When the ACTION of SPECIAL_EDUCATION is "ADD", this element is mandatory.

If Action is ADD or UPDATE then evaluate [S_ON_SEN_X]IEP_Flag

When 1 then 'T'

When 0 then 'F'

Otherwise, 'F'

If Action is DELETE then [ON_SPECIAL_EDUCATIONS] INDIVIDUAL_EDUCATION_PLAN_FLAG

Data Element

Description

[Table]FieldName

SECOND_LANGUAGE_PROGRAM

This is the outer tag for student second language program.

n/a

ACTION

This is the action associated with this submission.

Value: "ADD", "DELETE"

PowerSchool Business Rules:

If Second_language_program identified by Type exists in PowerSchool but does not exist in ON_SECOND_LANGUAGES then the segment is generated with ADD action.

If the Second_Language_program identified by Type exists in ON_SECOND_LANGUAGES but does not exist in PowerSchool then the segment is generated with DELETE action.

All DELETE actions are generated before any ADD actions.

n/a

TYPE

The element TYPE is used to uniquely identify the second language program.

PowerSchool Business Rules:

For a ESL/ELD programs- values can be '004' (if the program name contains "ESL"), '005'(if the program name contains "ELD")

If the Action is ADD then Type value determined [Gen] Name where [S_ON_GEN_SPECPROG_X]ESL_Flag is on.

If Action is DELETE then [ON_SECOND_LANGUAGES] Type

MINUTES_PER_DAY_OF_INSTRUCTION

Minutes per day of instruction.

PowerSchool Business Rules:

The <MINUTES_PER_DAY_OF_INSTRUCTIONS> is always 0 for Secondary Schools.

Regardless of Action type - this is always 0

Data Element

Description

[Table]FieldName

SECOND_LANGUAGE_PROGRAM

This is the outer tag for student second language program.

n/a

ACTION

This is the action associated with this submission.

Value: "ADD", "UPDATE", "DELETE"

PowerSchool Business Rules:

If Second_Language_Program identified by Type exists in PowerSchool but does not exist in ON_SECOND_LANGUAGES then the segment is generated with ADD action.

If the Second_Language_Program identified by Type exists in ON_SECOND_LANGUAGES but does not exist in PowerSchool then the segment is generated with DELETE action.

All DELETE actions are generated before any ADD actions.

n/a

TYPE

The element TYPE is used to uniquely identify the second language program.

PowerSchool Business Rules:

For elementary schools, the <Type> element can contain one of the following values: '001' (FSL - Core),' 002' (FSL - Extended), '003' (FSL - Immersion), or '006' (ICFP - Intensive Core French).

When the student is enrolled in a French special program, the value is moved from the French Program Type field located on the District Setup > Special Program Information page. This field is only visible when 'French Program' is checked.

When the student is enrolled in a French Subject class, the value of this element is derived from the [S_ON_SEC_X]Lang_Pgm_Type value for the class (use [S_ON_CRS_X]Lang_Pgm_Type if the value in the Sections table is undefined):

'001' if language program type is 'C'

'002' if language program type is 'E'

'003' if language program type is 'I'

'006' if language program type is 'N'

If the Action is ADD then Type value determined from First 3 characters of [Courses] Alt_course_number if student is enrolled in a French Subject class

Or from [Gen]value2 if student is enrolled in a French special program.

If Action is DELETE then [ON_SECOND_LANGUAGES] Type

Always "030" (Private - FSL) for a private school regardless of the type of program.

MINUTES_PER_DAY_OF_INSTRUCTION

Minutes per day of instruction. Format: 'NN'

PowerSchool Business Rules:

<MINUTES_PER_DAY_OF_INSTRUCTION> is derived from Minutes_Of_Instruction field in S_ON_SCH_Lang_Inst_Minutes_C table

For private schools, if the number of minutes is zero, set to "001".

Data Element

Description

[Table]FieldName

SECOND_LANGUAGE_PROGRAM

This is the outer tag for student second language program.

n/a

ACTION

This is the action associated with this submission.

Value: "ADD", "UPDATE", "DELETE"

PowerSchool Business Rules:

If Second_language_program identified by Type exists in PowerSchool but does not exist in ON_SECOND_LANGUAGES then the segment is generated with ADD action.

If the Second_Language_program identified by Type exists in ON_SECOND_LANGUAGES but does not exist in PowerSchool then the segment is generated with DELETE action.

All DELETE actions are generated before any ADD actions.

n/a

TYPE

The element TYPE is used to uniquely identify the second language program.

PowerSchool Business Rules:

When the student is enrolled in a Native Language special program, the value is moved from the Native Language Program Type field located on the District Setup > Special Program Information page. This field is only visible when 'Native Language Program' is checked. When the student is enrolled in a Native Language course- values can be.

'020' for Cree (where [S_ON_SEC_X]/[S_ON_CRS_X]Instruction_Lang = 10)

'021' Ojibwe (where [S_ON_SEC_X]/[S_ON_CRS_X]Instruction_Lang = 34)

'022' Delaware (where [S_ON_SEC_X]/[S_ON_CRS_X]Instruction_Lang = 55)

'023' Mohawk (where [S_ON_SEC_X]/[S_ON_CRS_X]Instruction_Lang = 33)

'024' Cayuga (where [S_ON_SEC_X]/[S_ON_CRS_X]Instruction_Lang = 09)

'025' Oneida (where [S_ON_SEC_X]/[S_ON_CRS_X]Instruction_Lang = 65)

'026' Oji-Cree (where [S_ON_SEC_X]/[S_ON_CRS_X]Instruction_Lang = 64)

'027' Anything else.

'028' Inuktitut (where [S_ON_SEC_X]/[S_ON_CRS_X]Instruction_Lang = 89)

‘029’ Algonquin (where [S_ON_SEC_X]/[S_ON_CRS_X]Instruction_Lang = 109)

If the Action is ADD then Type value determined from First 3 characters of [Courses]Alt_course_number if student is enrolled in a Native Language Subject class

Or from [Gen]value2 if student is enrolled in a Native Language special program.

If Action is DELETE then [ON_SECOND_LANGUAGES] Type.

Always "031" (Private - Native) for a private school regardless of the type of program.

MINUTES_PER_DAY_OF_INSTRUCTION

Minutes per day of instruction.

PowerSchool Business Rules:

The <MINUTES_PER_DAY_OF_INSTRUCTION> is derived from Minute_Of_Instruction field in S_ON_SCH_Lang_Inst_Minutes_C table

For private schools, if the number of minutes is zero, set to "001".

Data Element

Description

[Table]FieldName

SALEP

This is the outer tag for SALEP.

OnSIS Business Rules:

Only one occurrence can exist on file. Repeating block to allow "delete" followed by an "add" action.

n/a

ACTION

This is the action associated with this submission.

Value: "ADD" "DELETE" "UPDATE"

DELETE segments are generated before ADD segments.

n/a

TYPE

When the ACTION of SALEP is "ADD", this element is mandatory.

OnSIS Business Rules:

Note. In the case of UPDATE action, if an empty tag or no tag is provided, the field will be ignored.

The valid codes are "001" and "002"

[S_ON_GEN_SPECPROG_X]SAL_Program_Type

If Action is DELETE then [ON_SAL_RECORDS]program_type

STATUS_TYPE

Status Type

When the ACTION of SALEP is "ADD", this element is mandatory.

Note: In the case of UPDATE action, if an empty tag or no tag is provided, the field will be ignored.

[S_ON_SEN_X]SAL_Status

EXIT_TYPE

Note: In the case of UPDATE action, if an empty tag is provided, the field will be updated to a null value. If no tag is provided, the field will be ignored.

If Action is ADD or UPDATE and [Spenrollments]exit_date is on or before submission end date (for June submission, if the SAL program exit date [SpEnrollments]Exit_Date is is on or before July 1.

[S_ON_SEN_X]SAL_EXIT_REASON

If Action is DELETE then [ON_SAL_RECORDS] exit_type

START_DATE

When the ACTION of SALEP is "ADD", this element is mandatory. Format = yyyy/mm/dd.

Note: In the case of UPDATE action, if an empty tag or no tag is provided, the field will be ignored.

If Action is ADD

[Spenrollments]enter_date

If Action is UPDATE or DELETE then [ON_SAL_RECORDS]start_date

END_DATE

Note: In the case of UPDATE action, if an empty tag is provided, the field will be updated to a null value. If no tag is provided, the field will be ignored.

If Action is ADD or UPDATE and [Spenrollments]exit_date is on or before submission end date

[Spenrollments]exit_date

No value is returned if the exit date is after the submission period count date, EXCEPT in a June submission where, if the program exit date is July 1st, END_DATE is set to July 1.

For non-returning students, if Action is UPDATE, set to <ENROLMENT_END_DATE>.

If Action is DELETE then [ON_SAL_RECORDS]end_date

COMPONENT

This is the outer tag for SALEP/COMPONENT.

When the ACTION of SALEP is "ADD", this element is mandatory.

n/a

ACTION

This is the action associated with this submission.

Value: "ADD" "DELETE"

n/a

TYPE

This is the outer tag for SALEP.

OnSIS Business Rules:

Only one occurrence can exist on file. Repeating block to allow "delete" followed by an "add" action.

If Action is ADD and record exists in S_ON_SEN_SAL_Component_C table

Then [S_ON_SEN_SAL_Component_C]Component_Type

If Action is DELETE then [ON_SAL_COMPONENTS]type

Data Element

Description

[Table]FieldName

EARLY READING_SCREENING

This is the outer tag for ERS.

n/a

ACTION

This is the action associated with this submission.

Value: “ADD”

n/a

ERS_COMPLETED_FLAG

When the ACTION of ERS is "ADD", this element is mandatory. This is used to identify if the student has completed ERS.

PS Business Rules:

If no records exist for the student then the this flag is to N and ERS_COMPLETED_DATE and BENCHMARK_MET_FLAG is set to null.

Derived from STUDENTTESTSCORE.ALPHASCORE

ERS_COMPLETED_FLAG Iis set to Y if

• ALPHASCORE is 1 or 2

ERS_COMPLETED_FLAG is set to N if

• Student has noTest records

• ALPHASCORE is Null, NC, or any other Invalid values

ERS_COMPLETED_FLAG is set to NA

• ALPHASCORE is NA

BENCHMARK_MET_FLAG

Indicates if the student met the ERS benchmark

Note: If ERS_COMPLETED_FLAG is Y, this is a mandatory field on ADD.

Derived from STUDENTTESTSCORE.ALPHASCORE

BENCHMARK_MET_FLAG is set to Y

• ALPHASCORE is 1

BENCHMARK_MET_FLAG is set to N

• ALPHASCORE is 2

Otherwise BENCHMARK_MET_FLAG is NULL (Empty tag)

ERS_COMPLETED_DATE

The date indicates when the student completed ERS.

Note: If ERS_COMPLETED_FLAG is Y, this is a mandatory field on ADD.

ERS_COMPLETED_DATE = [STUDENTTEST]TEST_DATE if

• ALPHASCORE is 1 or 2

Otherwise is set to NULL (EMPTY tag)

Data Element

Description

[Table]FieldName

REPORT_CARD

This is the outer tag for REPORT_CARD.

ACTION

This is the action associated with this submission

Value: "ADD" "UPDATE" "DELETE"

GRADE_IN_SEPTEMBER

The grade in which the Student will be registered the following academic year.

Grade in September is set only in the June submission.

This element is not required if the ACTION element value (see above) is 'DELETE'.

Before EOY process [Student]Sched_NextYearGrade

After EOY process [Students]Grade_Level

TERM

This is the outer tag for REPORT_CARD/TERM.

When the ACTION of REPORT_CARD is "ADD", this element is mandatory.

Data Element

Description

[Table]FieldName

TERM

This is the outer tag for REPORT_CARD/TERM.

When the ACTION of REPORT_CARD is "ADD", this element is mandatory.

ACTION

This is the action associated with this submission

Value: "ADD" "UPDATE" "DELETE"

TERM_CODE

Identifies the two report card terms.

Note: A term record is generated only if the student is enrolled within the term and has marks for that term.

Values: 1,2 for store codes R1 and R2 respectively.

Term 1 - Startday as [Terms] FirstDay where isyearrec=1 (StartDay of the School Year) and Lastday as [S_ON_SCH_X]R1_End_Date.

Term 2 - With Startday as [S_ON_SCH_X]R1_End_Date and Lastday as [Terms] Lastday where isyearrec =1 (Last day of the School Year)

ALTERNATIVE_REPORT_CARD_FLAG

It identifies whether the STUDENT has a non-standard REPORT_CARD.

Values:

"T" - Yes

"F" - No

When the ACTION of REPORT_CARD/TERM is "ADD", this element is mandatory.

If the value is 'T' SUBJECT_STRAND and LEARNING_SKILL segments are not generated.

Mapped from custom field

If Term is 1 [S_ON_STU_X]ALTREPORTCARD or if that is not present, from [S_ON_REN_X]ALTREPORTCARD

If Term is 2

[S_ON_STU_X]ALTREPORTCARD2 or if that is not present, from [S_ON_REN_X]ALTREPORTCARD2

DAYS_ABSENT

Student's total days absent in TERM.

When the ACTION of REPORT_CARD/TERM is "ADD", this element is mandatory.

For the October submission, Total Days Absent and Total Times Late must both be < or = 50.

For the March submission, Total Days Absent and Total Times Late must both be < or = 140.

For the June submission, Total Days Absent and Total Times Late must both be < or = 240.

No Longer valid starting 2020-2021 academic year

Attendance Conversions are required setup to calculate AM and PM attendance.

The nightly process calculates attendance for AM and PM based on students' enrollment in courses and the bell schedule.

Depending on the report run page parameter for Period to AM/PM or Time to AM/PM, the value is calculated from views:

[PS_ADAADM_Meeting_TTOP/PS_ADAADM_Meeting_PTOP] for Days_absent

Sum(Potential_Attendancevalue) - Sum(Attendancevalue)

The DAYS_ABSENT calculations checks the board preference 'Exclude Progress Report Card Absences':

If the preference is OFF (Default value), DAYS_ABSENT calculates from the beginning of the school term to the term 1 report card end date.

If the preference is ON, DAYS_ABSENT calculates from Progress Report Card End Date plus one day to the term 1 report card end date.

TIMES_LATE

Student's total times late in TERM.

When the ACTION of REPORT_CARD/TERM is "ADD", this element is mandatory.

For the October submission, Total Days Absent and Total Times Late must both be < or = 50.

For the March submission, Total Days Absent and Total Times Late must both be < or = 140.

For the June submission, Total Days Absent and Total Times Late must both be < or = 240.

No Longer valid starting 2020-2021 academic year

Attendance Codes that are to be calculated as Late must be set with a 'Tardy' category.

If [S_ON_SCH_X]AM_Tardy_Period has a period set or If [S_ON_SCH_X]PM_Tardy_Period has a period set then only that period will be looked at to determine if the student has an attendance code with a 'Tardy' category. If the Schools Tardy periods are not setup, then any student with a 'Tardy' attendance code in AM or PM will count as late. A student can be late up to two times a day.

The sum of AM and PM tardies is added together based on the Dates in the term.

The TIMES_LATE calculations checks the board preference 'Exclude Progress Report Card Absences':

If the preference is OFF (Default value), TIMES_LATE calculates from the beginning of the school term to the term 1 report card end date.

If the preference is ON, TIMES_LATE calculates from Progress Report Card End Date plus one day to the term 1 report card end date.

SUBJECT_STRAND

This is the outer tag SUBJECT_STRAND.

There must be one SUBJECT_STRAND element for each State Subject Strand the student is being graded upon.

LEARNING_SKILL

This is the outer tag for LEARNING_SKILL.

There must be one LEARNING_SKILL segment for each State Learning Skill upon which the student is grade.

Data Element

Description

[Table]FieldName

SUBJECT_STRAND

This is the outer tag for REPORT_CARD TERM SUBJECT_STRAND.

Note: This tag must be present for Subjects prior to submitting any data for associated strands information. Strands information will be rejected if associated Subject information is not already processed successfully.

ACTION

This is the action associated with this submission

Value: "ADD" "UPDATE" "DELETE"

SUBJECT_STRAND_CODE

Identifies Subject/Strand entry.

If Action is ADD or UPDATE

Mapped from [STANDARDGRADESECTION]StandardID

If Action is DELETE

[on_report_card_marks] subj_strand_code

SUBJECT_NAME

Required for the Optional Subject Strand. If is not generated for any other subject or strand.

For Subject_strand_code 'OPT-30'

Custom field [S_ON_SEC_X]CLASS_NAME, if not present uses custom field [COURSES]ON_COURSE_NAME

IEP_FLAG

Signifies if student has Individual Educational Plan (IEP).

Values:

"T" - Yes

"F" - No

Tag is valid only when IEP flag is applicable to Subject or Strand. It is generated only if NA_Flag is "F".

Check business rules for conditions.

Mapped from [STANDARDGRADESECTION] StandardGrade

'T' when grade is 'I' or 'EANDI'

Otherwise, 'F'

SUPPORT_PROGRAM_CODE

Signifies if student has Support Program. Value has to be consistent with SUBJ_PGM_TYPE table.

Tag is valid only when Support Program is applicable to Subject or Strand. It is generated only if NA_Flag is "F".

Check business rules for conditions.

Note: In the case of UPDATE action, if an empty tag is provided, the field will be updated to a null value. If no tag is provided, the field will be ignored.

Mapped from [STANDARDGRADESECTION] StandardGrade

'ESL/ELD' when grade is 'E' or 'EANDI'

SL_PROGRAM_CODE

Signifies if student has Second Language Program. Value has to be consistent with SCND_LANG_PGM_TYPE table.

Tag is valid only when Second Language Program is applicable to Subject or Strand. It is generated only if NA_Flag is "F".

Check business rules for conditions.

Note: In the case of UPDATE action, if an empty tag is provided, the field will be updated to a null value. If no tag is provided, the field will be ignored.

For French courses:

Mapped from custom field [S_ON_SEC_X]LANG_PGM_TYPE, or if not present use custom field [S_ON_CRS_X]LANG_PGM_TYPE.

For Native Language courses:

Mapped from [S_ON_SEC_X]Instruction_Lang or if no present use customfield [S_ON_CRS_X]Instruction_Lang

The value from the class in which the student is enrolled as of the submission period count date is used. If the student left the class prior to the end of the submission period the class with the latest exit date is used.

NA_FLAG

Indicates whether data is being reported for the subject or strand.

"T" - Yes

"F" - No

Defaults to 'F' if no value is provided

The element is generated only if it applies to the subject or strand. For a strand, the flag is set "T" if no mark is provided, and if a mark is present the flag is set "F". For a subject, the flag is set "T' if no marks are present for any of the constituent strands. If any strand for the subject has a mark the flag is set "F".

Check business rules for conditions.

Mapped from [STANDARDGRADESECTION] StandardGrade

FRENCH_FLAG

Indicates whether the student is taking the subject or subject-strand in French

"T" - Yes

"F" - No

Defaults to 'F' if no value is provided

Tag is valid only when French flag is applicable to Subject or Strand. It is generated only if NA_Flag is "F".

Check business rules for conditions

When [S_ON_SEC_X]INSTRUCTION_LANG or, if not present, use custom field [S_ON_CRS_X]INSTRCUTION_LANG is 'F' or 'B' then set to 'T'

MARK

It can contain letter grades/percentage marks or T/F (in case of Religion Subject) for this Subject.

It has to be consistent with database table RPT_CRD_LTR_GRD_TYPE (for Grades 1-8), RPT_CRD_CONFIRM_TYPE or

Values (for Grades 7-8): 50-100.

Only final (not progress) marks are reported.

If NA_Flag is "T" this element is not generated.

Check business rules for conditions.

[STANDARDGRADESECTION] StandardGrade

Data Element

Description

[Table]FieldName

LEARNING_SKILL

This is the outer tag for LEARNING_SKILL.

ACTION

This is the action associated with this submission.

Value: "ADD" "UPDATE" "DELETE"

LEARNING_SKILL_CODE

This is LEARNING_SKILL_ID for learning skill.

It has to be consistent with database table LEARN_SKILL_DESC_TYPE.

Mapped from [STANDARDGRADESECTION]StandardID

LEVEL

Measure of achievement for a learning skill.

It has to be consistent with database table LEARN_SKILL_LEVEL_TYPE.

When a student enrolls in the same standard more than once in the same school year at the same school, the latest mark is used. If the student takes the same course at different schools the mark at the corresponding school is used.

When the ACTION of REPORT_CARD/TERM/LEARNING_SKILL/ is "ADD" or 'UPDATE" than this tag is mandatory.

Mapped from [STANDARDGRADESECTION]StandardGrade

Data Element

Description

[Table]FieldName

LITERACY_AND_NUMERACY

This is the outer tag for LITERACY_AND_NUMERACY.

n/a

ACTION

This is the action associated with this submission

Value: "ADD" "UPDATE" "DELETE"

n/a

BLOCK_TYPE_CODE

Identifies Literacy or Numeracy block types. It has to be consistent with database table LTRC_NMRC_TYPE.

PowerSchool Business Rules:

<BLOCK_TYPE_CODE> is the value of ON_Literacy_Numeracy.user_defined_text (aliased as Type), either 'LIT' or 'NUM'

virtualtablesdata.user_defined_text

GRADE

This is the outer tag for LITERACY_AND_NUMERACY grade.

When the ACTION of LITERACY_AND_NUMERACY is "ADD", this element is mandatory and must be present for all the grades starting from JK to Grade 8.

When the ACTION of LITERACY_AND_NUMERACY is "UPDATE", this element is mandatory and must be present for all the grades that need the data to be modified.

n/a

GRADE_CODE

Applicable school grade.

Values have to be consistent with database table GRADE.

PowerSchool Business Rules:

<GRADE_CODE> is one of: JK, K, 1, 2, 3, 4, 5, 6, 7, or 8. Grade level is stored in ON_Literacy_Numeracy.user_defined_integer (aliased as Grade_Level. 'JK' is stored as -1, 'K' is stored as 0.

virtualtablesdata.user_defined_interger

NUMBER_OF_BLOCKS

Number representing number of blocks per week for specific grade.

The NA_FLAG tag and this tag are mutually exclusive so only of them could be submitted at a GRADE level outer tag. Either this tag or NA_FLAG tag must be present.

PowerSchool Business Rules:

<NUMBER_OF_BLOCKS> is generated only if a record exists in the ON_Literacy_Numeracy virtual table for the grade level associated with the segment. If generated, the value of the element is the value of ON_Literacy_Numeracy.user_defined_numeric (aliased as Blocks_Per_Week).

virtualtablesdata.user_defined_numeric

NA_FLAG

The value for number of blocks per week for specific grade is not applicable.

Values:

"T" - number of blocks not applicable

"F" - number of blocks applicable

The NUMBER_OF_BLOCKS tag and this tag are mutually exclusive so only of them could be submitted at a GRADE level outer tag. Either this tag or NUMBER_OF_BLOCKS tag must be present.

PowerSchool Business Rules:

NA_FLAG is generated only if no record exists in the ON_Literacy_Numeracy virtual table for the grade level associated with the segment. If generated, the value of the segment is 'T'.

created as a T if virtualtablesdata.user_defined_numeric is null

Data Element

Description

[Table]FieldName

AVG_REPORT_CARD_GRADE

This is the outer tag for AVG_REPORT_CARD_GRADE

(Note: This data is not currently being collected for Private Schools.)

n/a

ACTION

This is the action associated with this submission

Value: "ADD" "UPDATE" "DELETE"

n/a

GRADE_CODE

Identifies the 2 grades that we collect report card average marks (7, 8 grade)

n/a

NA_FLAG

Data for is not available for the Grade specified above.

Values:

"T" - No Average Marks

"F" - Average Marks Available

When the ACTION is "ADD" this tag is mandatory. When Action = "ADD" and this tag is missing then the default value of "F" will be assumed to be present.

Derived by counting [STANDARDGRADESECTION]StandardGrade for school and year for identifiers setup for grades 7 and 8. When no average marks exist, then 'T'

Otherwise, 'F'

DESCRIPTOR

"M" - Grades are Median Marks

Set to 'M' when average marks are available.

SUBJECT_STRAND

This is the outer tag for SUBJECT_STRAND.

Data Element

Description

[Table]FieldName

SUBJECT_STRAND

This is the outer tag for SUBJECT_STRAND.

n/a

ACTION

This is the action associated with this submission

Value: "ADD" "UPDATE" "DELETE"

n/a

SUBJECT_STRAND_CODE

Identifies Subject/Strand entry. It has to be the value consistent with lookup table SUBJ_STRND_TYPE.

Mapped from [STANDARDGRADESECTION]StandardID

AVG_MARK_R1

Represents a calculation for the reporting period 1 for all students in the school, in this grade, for this subject/strand, based on the DESCRIPTOR.

Values: 0-100

MEDIAN([STANDARDGRADESECTION]StandardGrade where STORECODE = 'R1'

AVG_MARK_R2

Represents a calculation for the reporting period 2, for all students in the school, in this grade, for this subject/strand, based on the DESCRIPTOR.

Values: 0-100

MEDIAN([STANDARDGRADESECTION]StandardGrade where STORECODE = 'R2'