OnSIS Summer 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 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.

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, 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

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

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

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.

Rules:

If the Create Only Summer School Class Enrollment Records flag is selected. Only CC enrolments are created(i.e., no summer school enrolment)

• the board residence status is taken from the lastest school enrolment that is not a night school and falls in the same year as the CC enrollment.

• if this record does not exist, it should be taken from the student record.

[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

• snapshot value is extracted if defined otherwise

  • function PSSR_ON_Common.GetStudentOnlineLearningRequirement is used: if NAflag or OptedOutFlag = 1 then report 2, if Earned to date is 2.0 then report 1 otherwise Null is reported.

WITHDRAWAL_TYPE

Withdrawal Type if student has withdrawn from this course during the current submission period. If a student has withdrawn from this course during the current submission period and the withdrawal occurs after the end of the submission period, but the Transcript_W flag = 1, the withdrawal type is set to 'W'.

If the student has completed the course (i.e., has a final mark posted) and withdraws prior to the end of the class, the Withdrawal Type is not set.

If [StoredGrades]Grade is missing or null and the student is enrolled in the class until the last day or second last day of the term, the withdrawal type is blank.

If the course is not complete and is an ESL/ELD or credit recovery course, withdrawal type is set to "D" even if the full disclosure flag is on and the course is a grade 11 or 12 course.

ESL/ELD courses are those where the first 3 characters of the ministry course code ([Courses]Alternate_Course_Number) are 'ESL' or 'ELD'.

Credit recovery courses are those where ANY of the following are true:

• [S_ON_SEC_X]Class_Type = 'RCR'

• [S_ON_SEC_X]OthCrsInfo_Cred_Recovery = 1

• [S_ON_SGR_X]OthCrsInfo_Cred_Recovery = 1

PowerSchool Business Rules:

'W' if the student withdrew from this class..

'D' if the student dropped this class.

If [S_ON_SGR_X]Transcript_W = 1 then 'W'. If [CC]DateLeft is before the [terms]lastDay and Transcript_W = 0 AND [storedgrades]grade is null, then 'D'

WITHDRAWAL_DATE

The withdrawal date. Format = yyyy/mm/dd

OnSIS Business Rules:

WITHDRAWAL_DATE must be the same as COURSE_END_DATE.

If [S_ON_SGR_X]Transcript_W = 1 then COURSE_END_DATE

The Withdrawal_Date is set to Course_End_Date if Withdrawal_Type is W. Otherwise, set to null.

Withdrawal date is only submitted if it falls within the current submission period.

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

[S_ON_CRS_X]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

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, [S_ON_CRS_X]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'

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

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

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.

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.