Skip to main content
Skip table of contents

OnSIS Summer School Submission Report

Introduction

Use this report to create OnSIS files for Summer School Submissions at the end of each school year.

Reports may be run at the School level or at the District level. At the District level, the report can only be run for a selected school (BSID). The submission period is from September 1 to September 6 of the next year.

IMPORTANT NOTES:

  • The Run Demographic Snapshot process must be run at least once prior to running any OnSIS Submission report.

  • Before running this report for the first time for each submission period ensure that the OnSIS Create Class Codes Report has been run. This ensures that class codes are created for classes added to the master schedule since the previous submission period.

  • In this report, Submission Satrt date is calculated as the earliest school start date or the submission start date (next day of June CountDate).

Additional Resources-

See the following resources for more information on PowerSchool and OnSIS Batch File Processing.

  • Ontario Ministry of Education School Information System (OnSIS Core System), Batch File Specifications.

  • Ontario Ministry of Education School Information System (OnSIS Core System), School Data Submission Business Rules.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Data Selection

  • Refer to the selection criteria for each segment for detailed information on how data is used to generate the segment.

  • Ensure that the count dates have been set up correctly in the District Info Setup. This report will not produce any output if the count date is not filled in.

Report Input

For help with navigation and running the report, refer to How to Find and Generate a 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 alternate school to run the submission report for. The drop-down contains only alternate school numbers (BSIDs) for schools where the summer school flag ([Schools]IsSummerSchool) is on. If the report is run at the school level, only the alternate school number for the current school is available. If the alternate school number ([Schools]Alternate_School_Number) is undefined, the local school number ([Schools]School_Number) is shown. If two schools have the same BSID, the BSID appears only once in the drop-down.

List Of Alternative Schools

This is a read-only list of the schools in PowerSchool that have the selected alternative school number and for which the summer school flag ([Schools]IsSummerSchool) is on. Students enrolled in any of these schools are included in the XML submission file created by the report.

Submission Type*

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

Report Output

Each of the fields displayed in the output of the report is described below. Refer to Understanding the Report Output Table for a definition of each column in the table.

XML Version and Encoding

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

ONSIS_BATCH FILE Segment

Data Element

Description

[Table]FieldName

ONSIS_BATCH_FILE

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

n/a

HEADER Segment

There is only one Header Segment per OnSIS Data Submission.

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 Segment

The DATA Segment contains the data related portion of the OnSIS Data Submission.

Data Element

Description

[Table]FieldName

DATA

This is the outer tag for all data.

n/a

SCHOOL SUBMISSION Segment

Each submission is for a single school, therefore there will only be one SCHOOL_SUBMISSION segment.

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, 2012-2013.

[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 ministry OnSIS Reference Table Spreadsheet and will be set by the UI settings of Submission Type and Submission Period.

The combination of element ACADEMIC_YEAR and SUBMISSION_PERIOD_TYPE is used to uniquely identify the submission period.

SUMSEC

SCHOOL Segment

Each submission is for a single school. Therefore there will only be one SCHOOL segment. More than one school can have the same Alternate School Number. All schools with the same alternate school number are processed as one summer school.

For all CLEAR_* elements, refer to Appendix A - Batch Files Purge and Pre-Population XML Tags of the ministry OnSIS Batch Process and File Specifications document.

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

Student Segment

Selection Criteria

  • A student is included if he or she has included data for any school with an alternate school number (BSID) matching that selected on the report input page. If alternate school number is undefined then school number is used. Only one <STUDENT> segment is generated for a student but child segments (e.g. <STUDENT_CLASS_ENROLMENT>) may include data from more than one school.

  • A student without an OEN ([Students]state_studentNumber) is submitted with an OEN value of '000000000'.

  • A student is not submitted if the exclude from Provincial Reporting flag is enabled for this student.

  • A student is not submitted if his attendance type ([Students]EnrollmentType) is 'EX' (excluded),

  • If the student is cross-enrolled, then the report uses the previous regular day school enrolment to check if the attendance type is 'EX'. In the case when there is no previous enrolment, and there is no direct summer enrolment at the school, then the report looks at the first next regular day school enrolment attendance type. When the attendance type is EX, the report won't generate the student.

  • Enrolment records with an exit date equal to entry date are ignored by the report, as are 'no show' enrolment records - i.e. records with an exit code of "NS".

  • A Student Segment is submitted if the Student Date of Entry in and Date of Exit to the School falls within the submission period start and end date AND this student has one or more class enrolments (with final marks or full disclosure or in a non-credit course).

  • A Student Segment is submitted if a student is cross-enrolled in one or more classes in this school and if the class is in session during this submission period and the student is not enrolled in this summer school during this submission. The student's current enrolment does not need to be active. For example, they could have an end date for their enrolment school during the school year and now be cross enrolled in a summer school class.

  • Student Segments do not have an ACTION element. Instead it is only created if the STUDENT_SCHOOL_ENROLMENT segment has an ACTION with a value of 'ADD''.

Data Element

Description

[Table]FieldName

STUDENT

This is the outer tag for student.

n/a

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.

[S_ON_STU_X]First_Language

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

Otherwise use 'E'.

Student School Enrolment Segment

Selection Criteria

  • A minimum of one student enrolment record must be present. If the student enters and departs from the school multiple times during the submission period, only one student school enrolment record is required. Enrolment records with an exit date equal to entry date are ignored by the report, as are 'no show' enrolment records; that is, records with an exit code of "NS".

  • A student is excluded if the attendance type ([Students]EnrollmentType) is 'EX' (excluded) and the student is enrolled in the school (or class for cross-enrolled students) as of the submission period count date.

  • If the student left before the count date and has data (e.g. marks) to report for the submission period, the student is included regardless of the attendance type.

  • If the student is only taking ILE courses, a Student School Enrolment segment will not be generated for the student.

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"

PowerSchool Business Rules:

If the student is enrolled or cross-enrolled during the school term, the school enrolment segment is generated with the 'ADD'.

Note - 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.

n/a

SCHOOL_STUDENT_NUMBER

School student number.

[Students]Student_Number

RESIDENCE_STATUS_TYPE

Residence Status

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

If ACTION is "ADD" or "UPDATE"

Value is extracted from [ON_OnSIS_Snapshot]Residence_Status if the snapshot record exists; otherwise

[S_ON_STU_X]/[S_ON_REN_X]Residence_Status from the latest enrolment within the submission period from the school belonging to the selected BSID. For cross enrolled students, if no school enrolment record found within the submission period, values are populated from the last school enrolment found for the student.


If ACTION is "UPDATE" for a non-returning student, then [ON_School_Enrollments]Resident_Status_Type

ENROLMENT_START_DATE

Enrolment start date. Format = yyyy/mm/dd

If a student is enrolled in multiple schools with the same BSID

  • For Directly enrolled students:

    • Enrollment Start Date is the earliest (earliest class start date of the directly enrolled student or entrydate in the school if student does not have classes)

  • For Cross enrolled students: The enrolment start date is the earliest [CC]DateEnrolled that falls within the submission period


For directly enrolled students: [PSSR_Enrollment]EntryDate

For cross enrolled students: The enrolment start date is the earliest [CC]DateEnrolled that falls within the submission period

ENROLMENT_END_DATE

Enrolment end date. Format = yyyy/mm/dd

If a student is enrolled in multiple schools with the same BSID

  • For Directly enrolled students:

    • Enrollment End Date is the last (latest class end date of the student enrolled in summer school or exitdate of the student if student does not have classes)

  • For cross-enrolled students: The enrolment end date is the latest [CC]DateLeft that falls within the submission period


For directly enrolled students: [PSSR_Enrollment]ExitDate

For cross enrolled students: The enrolment end date is the latest [CC]DateLeft that falls within the submission period

POSTAL_AREA_TYPE

Postal Code

Format = "AnA nAn"

Populated only if CURRENT_RESIDENCE_PROVINCE 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

STU_BRD_RES_STAT_TYPE

Board Residence Status.

[ON_OnSIS_Snapshot]Brd_Res_Status if the snapshot record exists; set to '01' (Pupil Of The Board) if no value is defined on the record otherwise,

If Brd_Res_Status (from S_ON_STU_X/S_ON_REN_X) is one of: '02' (Native Education Authority), '03' (Government Of Canada), '05' (Study Permit/Temporary Resident), or '07' (Other Student), use that value.

Otherwise, set to '01' (Pupil Of The Board)

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) data entry field is not Canada.

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

[S_ON_STU_X/S_ON_REN_X]Curr_Country, [S_ON_REN_X//S_ON_REN_X]Curr_Country from the latest enrolment within the submission period from the school belonging to the selected BSID. For cross enrolled students, if no school enrolment record found within the submission period, values are populated from the last school enrolment found for the student.

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) data entry 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_STU_X,/S_ON_REN_X]Curr_Province, [S_ON_REN_X,/S_ON_REN_X]Curr_Province from the latest enrolment within the submission period from the school belonging to the selected BSID. For cross enrolled students, if no school enrolment record found within the submission period, values are populated from the last school enrolment found for the student.

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

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 required only 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.

ONLINE_GRADUATION_REQUIREMENT_TYPE

Student's online learning graduation requirement status.

Valid Values:

1- Successfully completed

2 - Not applicable

Non Credit Average Daily Enrolment Segment

Each segment within a BSID within a submission file is uniquely identified by the combination of:

  • COURSE_OFFERING_TYPE

  • NATIVE_LANGUAGE_TYPE (course offering 16 only)

  • PROGRAM_START

  • PROGRAM_END

  • PARENT_NUMBER (course offering 15 only)

In cases where multiple classes with the same combination of these values are present, the classes are combined into a single segment. The values of the following elements are set as follows:

  • CAMPUS_NUMBER - the value associated with the constituent class with the lowest DCID.

  • START_TIME - the earliest start time of the constituent classes.

  • END_TIME - the latest end time of the constituent classes.

  • ADE_SUMMER - all values from the constituent classes added together.

Selection Criteria

  • This segment is generated if the student is enrolled in a class where ([S_ON_SEC_X]Course_Offering)= '06' (Elementary Program For Developmentally Delayed Pupils), '13' (7/8 Remedial Literacy & Numeracy), '14' (Non-credit 9/10 Remedial Literacy & Numeracy), '15' (Literacy & Numeracy - Parents / Guardians), '16' (Adult Indigenous Language Instruction), regardless of whether marks are posted for the student.

  • The course type ([S_ON_CRS_X]/[S_ON_SEC _X]Course Type) for the associated class must be one of 'M', 'L', or blank.

  • The class should not be an independent study class. A class is independent study when [S_ON_SEC_X]IsIndependentStudy_Class or [S_ON_CC_X]IsIndependentStudy_Class equals one (i.e. flags are On on course and/or section level)

  • Date enrolled (CC.Dateenrolled) must fall within the submission period (between the submission start and count dates.

  • Session will be excluded from the ADE calculation if associated with the attendance category, CEUNFUNDED.

  • Non Credit Average Daily Enrolment Segment is not generated for ILE courses.

Data Element

Description

[Table]FieldName

NON_CREDIT_AVERAGE_DAILY_ENROLMENT

This is the outer tag for student non-credit average daily enrolment.

n/a

ACTION

This is the action associated with this submission.

Value: "ADD" "UPDATE" "DELETE"

PowerSchool Business Rules:

The only action supported is "ADD".

COURSE_OFFERING_TYPE

Course offering associated with the class.

[S_ON_SEC_X]Course_Offering, if not empty otherwise [S_ON_CRS_X]Course_Offering.


When [S_ON_SEC_X]Course_Offering/[S_ON_CRS_X]Course_Offering='13' (7/8 Remedial Literacy & Numeracy) or '14' (Non-credit 9/10 Remedial Literacy & Numeracy), the following calculation is applied:

  • IF student is under 21 years of age as of December 31st of the current school year and enrolled in the day school register and all credits in which student is enrolled are non-exempt high-credits (HIGH_CREDIT_FTE >0 and REGULAR_FTE= 0) THEN

    • COURSE_OFFERING_TYPE= 19 if course is a grade 7/8 course or 22 if course is a grade 9/10 course

    • Otherwise, COURSE_OFFERING_TYPE= 13 if course is a grade 7/8 course or 14 if course is a grade 9/10 course.

  • IF student is 21 years of age or older as of December 31st of the current school year and enrolled in the day school register, THEN

    • COURSE_OFFERING_TYPE= 18 if course is a grade 7/8 course or 21 if course is a grade 9/10 course.

  • IF student has not met the requirements above and is only enrolled in a Continuing Education school, THEN

    • COURSE_OFFERING_TYPE= 17 if course is a grade 7/8 course, or 20 if course is a grade 9/10 course.

  • Note:

    • IF any of the full-time flags under "Student's Full Time Status at Other Day School" on the summer school enrolment are selected, THEN Regular FTE and High Credit FTE override fields calculate the COURSE_OFFERING_TYPE.

NATIVE_LANGUAGE_TYPE

Adult Indigenous Language Instruction. Applies only to course offering '16'.

When [S_ON_SEC_X]/[S_ON_CRS_X]Course_Offering = 15, [Sections]Instruction_Lang, if not empty

Otherwise

[Courses]Instruction_Lang

CAMPUS_NUMBER

Location where the section is taught.

The following characters can be included in the Campus number as per OnSIS
• a-zA-Z0-9ÀàÄäÂâÁáÈèÉéÊêËëÎîÏïÌìÔôÖöÓóÜüÙùÛûÚúÇçÿŸ/,""';:=_.`~!@#%-$&^{}[](|)*+?\
• Accents are to be accepted.

The following characters are not to be included:
• < and >
• Control characters (ESC, CTRL, Alt, TAB, Page Up, Page Down, Space, Insert)

[S_ON_SEC_X]Campus

PROGRAM_START_DATE

Date student enrolled.

[CC]DateEnrolled

PROGRAM_END_DATE

Date student left.


DateLeft[cc] if on or before LastDay[Terms]; otherwise, LastDay[Terms]

When DateLeft[cc] > than submission count date, then PROGRAM_END_DATE = Subission count date

PARENT_NUMBER

Literacy & Numeracy - Parents / Guardians. Applies only to course offering '15'.

When [S_ON_SEC_X]/[S_ON_CRS_X]Course_Offering = 15, THEN [S_ON_CC_X ]LNPG_reference

START_TIME

HH:MM using 24 hour clock. Calculated in the same manner as the corresponding register.


END_TIME

HH:MM using 24 hour clock. Calculated in the same manner as the corresponding register.


ADE_SUMMER

ADE is calculated only for certain course offering types: '06', '13', '14', '15', '16'.

Calculated in the same manner as the corresponding register using the number of hours (or number of work units) for the particular student rather than the entire class.

Small class adjustments are not used when calculating ADE values.

A value of 0.0000 is reported if ADE is not calculated or the course starts before June 25th

All ADE values are rounded to 4 decimal places.

ADE = ( Sessions Recognized per Sections) TIMES Hours Section Meets (from Start Time of first period to end time of last period ) Divided by 950 and rounded to 4 decimals (Displayed as 0.####)


Session will be excluded from the ADE calculation if associated with the attendance category, CEUNFUNDED.

CLASS_CODE

Value of Class Code.

This element will be valid for 20162017+ Submission Periods

Notes:

  • Mandatory when Action is ADD.

  • Before running this report for the first time for each submission period ensure that the OnSIS Create Class Codes Report has been run. This ensures that class codes are created for classes added to the master schedule since the previous submission period.

[S_ON_SEC_X]Class_Code.

Otherwise derived from [Courses]Course_Number - [Sections]Section_Number

Student Class Enrolment Segment

Selection Criteria

  • A Class Enrolment segment is submitted if the class started within the submission period date range (on or after the start date or on or before the end date).

  • A Class Enrolment segment is submitted if the student is enrolled in a class at anytime during the submission period, even if the class is not completed and no final mark is present.

  • If the student transferred out but subsequently transferred back to this school within the same submission period and resumed a previous class enrolment, only one Class Enrolment segment is submitted and the enrolment period of the class will be displayed as if the student had not transferred out mid-session.

  • The course type ([S_ON_CRS_X]/[S_ON_SEC_X]Course Type) for the class must be one of 'M' or 'L'.

  • Classes where the Ministry Defined Course Code starts with PLE, QEE, QSE, QMA, QAP are not submitted.

Data Element

Description

[Table]FieldName

CLASS_ENROLMENT

This is the outer tag for student class enrolment.

n/a

ACTION

This is the action associated with this submission.

Value: "ADD"

n/a

MINISTRY_DFND_CRS

Ministry Defined Course Code.

OnSIS Business Rules:

Only MINISTRY_DFND_CRS (including INSTITUTION_TYPE for Dual Credit Course) or LOCAL_DEV_CRS can have values, not both.

ADE is 0 for Dual Credit classes when the course is a Ministry defined course and the institution type is defined.

[Courses]Alt_Course_Number if [S_ON_CRS_X]Course_Type = 'M'

INSTITUTION_TYPE

Institution (College or University) - used to identify the Dual Credit Course.

ADE is 0 for Dual Credit classes when the institution type is defined.

[S_ON_CRS_X]Institution_Type

LOCAL_DEV_CRS

Locally Developed Course Code.

OnSIS Business Rules:

Only MINISTRY_DFND_CRS (including INSTITUTION_TYPE for Dual Credit Course) or LOCAL_DEV_CRS can have values not both.

[Courses]Alt_Course_Number if [S_ON_CRS_X]Course_Type = 'L'

CAMPUS_NUMBER

The number of the campus.

The following characters can be included in the Campus number as per OnSIS
• a-zA-Z0-9ÀàÄäÂâÁáÈèÉéÊêËëÎîÏïÌìÔôÖöÓóÜüÙùÛûÚúÇçÿŸ/,""';:=_.`~!@#%-$&^{}[](|)*+?\
• Accents are to be accepted.

The following characters are not to be included:
• < and >
• Control characters (ESC, CTRL, Alt, TAB, Page Up, Page Down, Space, Insert)

[S_ON_SEC_X]Campus

LANGUAGE_TYPE

Segment language of instruction (English or French).

This element is mandatory.

[Sections]Instruction_Lang. If undefined, [Courses]Instruction_Lang.

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

COURSE_DELIVERY_TYPE

Course Delivery Type.

This element is mandatory.

[S_ON_SEC_X]Delivery_Type

'1' (Regular) if undefined.

OTHER_COURSE_INFO

The Outer Tag of the Other Course Information Segment.



Action

The action associated with this submission.

Value: "ADD"

Action of ADD is generated for new values.

OTHER_COURSE_INFO_TYPE

Valid values:

  • 1 - Credit Recovery

  • 2 - Ministry Developed Content

  • 3 - Upgrading Credit Course

  • 4 - Online

[S_ON_SGR_X]OtherCrsInfo_Cred_Recovery
if not defined,[S_ON_SEC_X]OtherCrsInfo_Cred_Recovery

S_ON_SGR_X]OtherCrsInfo_Ministry_Content
if not defined,
[S_ON_SEC_X]OtherCrsInfo_Ministry_Content

S_ON_SGR_X]OthCrsInfo_UpgradCrdtCourse
if not defined
[S_ON_SEC_X]OthCrsInfo_UpgradCrdtCourse

S_ON_SGR_X]OthCrsInfo_Online
if not defined
[S_ON_SEC_X]OthCrsInfo_Online

NEW COURSE_DELIVERY_TYPE

Not Used

n/a

COURSE_SEM_TYPE

The value '6'

Set to '6'

NEW COURSE_SEM_TYPE

Not Used

Set to '6'

COURSE_START_DATE

Course Start date Format = yyyy/mm/dd.

[CC]DateEnrolled

NEW_COURSE_START_DATE

The tag is created but has no value.


COURSE_END_DATE

Course End date Format = yyyy/mm/dd.

[CC]DateLeft

If [CC]DateLeft is > the last day the class meets ([Terms]LastDay for the term associated with the class) the set to [Terms]LastDay

EARNED_CREDIT_VALUE

Credit value earned.

Set to 0.00 when [S_ON_SGR_X]Transcript_W = 1

[Storedgrades]EarnedCrHrs

When [Storedgrades]grade is not null

ATTEMPED CREDIT_VALUE

Credit Hours for the course.

[Courses]credit_hours

NEW ATTEMPED CREDIT VALUE

Not Used

n/a

FINAL_MARK

Final Mark

Set to "0" if <COURSE_INCOMPLETE_FLAG> is "T".

Set to [StoredGrades]Grade when grade is not null and not 'W'.

Set to "0" when [StoredGrades]Grade is null or non-numeric.

[Storedgrades]grade

COURSE_SBST_FLAG

Indicates if this course is a substitution.

PowerSchool Business Rules:

A course substitution occurs when the credit in a StoredGrades record is associated with a different diploma category (other than 'Optional Credits) than that normally associated with the course for the StoredGrades record. For example, a student may be exempt from taking French classes and is permitted to take another class (e.g. a PE class) to fulfill the French credit requirement. Courses for which [StoredGrades]ExcludeFromTranscripts is on are not considered when determining the diploma category for a course's credit.

StoredGrades records containing equivalent credit cannot be used for substitutions.

Set to 'T' or 'F'

COURSE_COMPLETE_FLAG

Flag indicating this course is complete.

OnSIS Business Rules:

Only one of <COURSE_COMPLETE_FLAG> and <COURSE_INCOMPLETE_FLAG> can be 'T', but not both.

PowerSchool Business Rules:

'F' if [S_ON_SGR_X]Transcript_W = 1

'T' if [cc]dateleft < [terms]lastday, [storedgrades]grade is not null and not equal to 'W'

Either [storedgrades]potentialCrHrs and [courses]credit_hours > 0 or [courses]credit_hours = 0 for the [storedgrades]course_number

'T' if [cc]dateleft >= [terms]lastday and [storedgrades]grade is not null.

Otherwise 'F'

Set to 'T' or 'F'

COURSE_REPEAT_FLAG

Flag indicating this course is a repeated course

Regardless of submission period, the course repeat flag for the first (earliest) instance of a course is "F". The flag is "T" for all subsequent instances.

When a student has multiple enrolment in the same class in a term, the report considers these as one enrolment and the COURSE_REPEAT_FLAG will be "F".


Refer to Appendix L for details on Course Repeat Logic.

Set to 'T' or 'F'

COMPULSORY_COURSE_FLAG

If any of the credit for a course reported in a <Student_Class_Enrolment> segment is considered compulsory set the <Compulsory_Course_Flag> element to 'T', otherwise set the element empty.

PowerSchool Business Rules:

A credit is considered compulsory if it is assigned to a diploma category other than 'Optional Credits'. This determination is made using the logic described in OnSIS Summer School Submission Report.

Set to 'T' or 'F'

COURSE_INCOMPLETE_FLAG

Flag indicating this course is incomplete.

PowerSchool Business Rules:

'T' if [S_ON_SGR_X]Transcript_W = 1

'T' if [cc]dateleft < [terms]lastday, [courses]credit_hours > 0,

and [storedgrades]grade is null or W

'T' if [cc]dateleft >= [terms]lastday and [storedgrades]grade is null

Otherwise 'F'

Set to 'T' or 'F'

Average Daily Enrolment Segment

The following Average Daily Enrolment (ADE) rules apply:

  • ADE - 'Summer' must be >= 0 and less than (0.59).

  • If Course End Date /Course Complete Date is prior to June 25th of the current academic year 'ADE - Summer' must = 0.

  • Course Offering must be one of the following for Class Enrolment/Other Credit related ADE records: 01, 02, 03, 04, 05, 07, 08, 09, 10, 11,12.

Selection Criteria

  • A segment is generated for each parent <STUDENT_CLASS_ENROLMENT> segment.

  • If the parent <STUDENT_CLASS_ENROLMENT> segment is for a summer school class, a Correspondence/Self-Study/Online class, or an adult diploma credit class, an <ADE_SUMMER> value is calculated as described below, otherwise the ADE is set to 0.0000. These classes are identified using the criteria described in the report sections for the corresponding paper registers in OnSIS Summer School Submission Report.

  • Session will be excluded from the ADE calculations if associated with the attendance category, CEUNFUNDED.

Data Element

Description

[Table]FieldName

AVERAGE_DAILY_ENROLMENT

This is the outer tag for student average daily enrolment.

n/a

ACTION

This is the action associated with this submission.

Value: "ADD" "UPDATE" "DELETE"

PowerSchool Business Rules:

The only action supported is "ADD"

Always "ADD"

COURSE_OFFERING_TYPE

Course offering associated with the class.

[S_ON_SEC_X]Course_Offering, if not empty

Otherwise

[S_ON_CRS_X]Course_Offering

ADE_SUMMER

Student's ADE in the class.

ADE is calculated only for certain course offering types: 01, 02, 03, 04, 05, 07, 08, 09, 10, 11, 12.

Fields referenced to the right are described in the Summer School Register, Correspondence/Self-Study/Online Register, and Continuing Education Credit Courses Register reports under OnSIS Summer School Submission Report.

Classes for which a student is marked with an attendance code configured with Presence Status = "Present" and Code Category = "Non-Instr" are not included toward sessions recognized.

A value of 0.0000 is reported if ADE is not calculated.

A value of 0.0000 is reported if the class starts before June 25th of the current year.

A value of 0.0000 is reported for all dual credit classes. A dual credit class is a class with the fourth and fifth characters are 4T or 4Y.

If class qualifies as Correspondence/Self-Study/Online:

ADE = (Lessons Recognized TIMES 0.00579 and rounded to 4 decimals

If class qualifies as an Adult Diploma Credit:

ADE = ( Sessions Recognized per Sections) TIMES Hours Section Meets (from Start Time of first period to end time of last period ) Divided by 950 and rounded to 4 decimals (Displayed as 0.####)


Session will be excluded from the ADE calculation if associated with the attendance category, CEUNFUNDED.

CLASS_CODE

Value of Class Code.

This element will be valid for 20162017+ Submission Periods

Notes:

  • Mandatory when Action is ADD.

  • Before running this report for the first time for each submission period ensure that the OnSIS Create Class Codes Report has been run. This ensures that class codes are created for classes added to the master schedule since the previous submission period.

[S_ON_SEC_X]Class_Code.
Otherwise derived from [Courses]Course_Number - [Sections]Section_Number

ILE Segment

This segment is a repeating child segment of the SCHOOL segment.

Selection Criteria

  • A segment is generated for each campus number ([S_ON_SEC_X]Campus) in the set of classes for the school for which [S_ON_CRS _X]Register_Code is "IL" or [S_ON_SEC_X]Register_Code is "IL".

Data Element

Description

[Table]FieldName

ACTION

This is the action associated with this submission.

Value: "ADD" "UPDATE" "DELETE"

PowerSchool Business Rules:

The only action supported is "ADD"


CAMPUS_NUMBER

Location where the section is taught. The campus number is mandatory. The segment is not generated without it.

The following characters can be included in the Campus number as per OnSIS
• a-zA-Z0-9ÀàÄäÂâÁáÈèÉéÊêËëÎîÏïÌìÔôÖöÓóÜüÙùÛûÚúÇçÿŸ/,""';:=_.`~!@#%-$&^{}[](|)*+?\
• Accents are to be accepted.

The following characters are not to be included:
• < and >
• Control characters (ESC, CTRL, Alt, TAB, Page Up, Page Down, Space, Insert)

[S_ON_SEC_X]Campus

ILE Language Program Count Segment

Selection Criteria

  • This segment is added as a repeating child segment of the ILE segment.

  • A segment is generated for each distinct language code ([S_ON_CRS_X]/[S_ON_SEC_X]ConEd_InternationalLanguage) in the set of IL classes for the school with the same campus number.

  • When multiple values exist where the LANGUAGE_TYPE code is OTH, a segment is generated for each unique value found for OTHER_LANGUAGE_DESC.

Data Element

Description

[Table]FieldName

ACTION

This is the action associated with this submission.

Value: "ADD" "UPDATE" "DELETE"

PowerSchool Business Rules:

The only action supported is "ADD"


LANGUAGE_TYPE


[S_ON_SEC_X]ConEd_InternationalLanguage, if not empty

Otherwise

[S_ON_CRS_X]ConEd_InternationalLanguage

OTHER_LANGUAGE_DESC

Extracted only if language type is 'OTH'

S_ON_SEC_X]OtherLanguageDesc, if not empty

Otherwise

[S_ON_CRS_X]OtherLanguageDesc .

CLASS_COUNT

The number of classes for the school/campus for the language code in which at least one student was enrolled at some time during the submission period.


INSTRUCTOR_COUNT

The distinct number of teachers associated with classes included in the segment.

Note: When an instructor teaches multiple ILE classes, the instructor is counted for each class taught. When an instructor teaches the same ILE class multiple times over different periods, the instructor is counted only once.


STUDENT_COUNT

The total number of students enrolled in classes included in the segment at some time during the submission period.

Note: If the student is taking the same language course in more than one class in an overlapping period of time, the student is counted once per campus, even if the overlap is only one day. The student is counted more than once only when the classes do not overlap.


STUDENT_PUPIL_OF_BOARD_COUNT

The total number of students of pupil of board.

If a student's "Exclude From Provincial Reporting Flag" is checked, the student is not included in the count


STUDENT_OTHER_COUNT

Total number of students of "other".

If a student's "Exclude From Provincial Reporting Flag" is checked, the student is not included in the count


HOUR_COUNT

The total number of hours of funded classroom instruction for all classes included in the segment.

The total hours of a funded classroom instruction is the number of sessions multiplied by the hours per session.

Session will be excluded if associated with the attendance category, CEUNFUNDED.


ILE Language Program TOD Count Segment

Selection Criteria

  • This segment is added as a repeating child segment of the ILE segment.

  • A segment is generated for each distinct time of day type code value ([S_ON_CRS_X]/[S_ON_SEC_X]TimeOfDay_Type) in the set of IL classes for the school with the same campus number.

Data Element

Description

[Table]FieldName

ACTION

This is the action associated with this submission.

Value: "ADD" "UPDATE" "DELETE"

PowerSchool Business Rules:

The only action supported is "ADD"

Always "ADD"

TIMEOFDAY_TYPE


[S_ON_SEC_X]TimeOfDay_Type, if not empty

Otherwise

[S_ON_CRS_X]TimeOfDay_Type

CLASS_COUNT

The number of classes for the school/campus for the time of day type in which at least one student was enrolled at some time during the submission period.



JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.