OnSIS Night 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 for which to run the submission report. The drop-down list contains only alternate school numbers (BSIDs) for schools where the night school flag ([S_ON_SCH_X]IsNightSchool) is on. 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 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 night school flag ([S_ON_SCH_X]IsNightSchool) is on. Students enrolled in any of these schools are included in the XML submission file created by the report. Only schools for which the "Exclude From State Reporting" flag ([Schools]State_ExcludeFromReporting) is off are included in the list.

Exclude School Student Number

Select this checkbox to exclude the School Student Number from the report.

If you do not choose this checkbox and a School Student Number is longer than 9 characters, a "Data is invalid" error will occur when submitting the file to OnSIS.

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 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 submission period.

JUNNS

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

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.

[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"

n/a

LITERACY_STATUS_TYPE

Literary Status

PowerSchool Business Rules:

Refer to the On Derived Fields document.

OnSIS Business Rules:

Literacy Status cannot be reported for students in Grade 9.

Derived by looking at [test]name 'OSSLT-E' and 'OSSLT-F' and [studenttestscore]alphaScore.

RESIDENCE_STATUS_TYPE

Residence Status

This element is mandatory.

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.

If no school enrolment exists, get from the latest school enrolment.

INDIGENOUS_SELF_IDENTIFICATION

Indigenous Type

[S_ON_STU_X]Aboriginal_Type

POSTAL_AREA_TYPE

Postal Code. Format = "AnA nAn"

This field is populated only if CURRENT_RESIDENCE_PROVINCE is Ontario.

[Students]/[ReEnrollments]Zip

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.

[S_ON_STU_X]Birth_Country

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

PROVINCE_STATE_TYPE_BIRTH

Province of Birth

[S_ON_STU_X]Birth_Province. If undefined then "ON".

If YEAR_OF_ENTRY_TO_CANADA is defined then blank.

YEAR_OF_ENTRY_TO_CANADA

Year of Entry into Canada. Format YYYY/MM

[S_ON_STU_X]Year_Of_Entry

MAIN_SCHOOL_FLAG

Flag indicator if enrolled in main school.

PowerSchool Business Rules:

• If the latest enrolment of the student falling in the submission period has the Not_MAIN_SCHOOL_FLAG ON then MAIN_SCHOOL_FLAG = 'F'

• If the student is only enrolled at this school in this submission period then MAIN_SCHOOL_FLAG = 'T'.

• If the student is only cross-enrolled at this school in the submission period, then MAIN_SCHOOL_FLAG = 'F'.

• If the student is enrolled and is cross-enrolled at this school at any time in the submission period, then MAIN_SCHOOL_FLAG = 'F'.

• If the student is both cross-enrolled and enrolled at one or more schools with the same BSID, then MAIN_SCHOOL_FLAG is T.

MAIN_SCHOOL_FLAG = 'F' when:

• • Board Residence Status = Shared Student (08)

  • OR Board Residence Status = e-Learning (09). An e-learning student is identified as a student where all their student enrolment courses are marked as e-Learning courses.

  • OR Board Residence Status = Other Student (07) OR (01) AND the student is enrolled only in Independent Study Classes. Independent Study courses are identified by the independent study flag from the sections extension table ( [S_ON_SEC_X]IsIndependentStudy_Class) and [S_ON_CC_X]IsIndependentStudy_Class).

OnSIS Business Rules:

This element is mandatory when action = "ADD"

determined by business rules

Otherwise,

[S_ON_STU_X]NOT_MAIN_SCHOOL_FLAG

[S_ON_REN_X]NOT_MAIN_SCHOOL_FLAG

SCHOOL_STUDENT_NUMBER

School student number

[Students]student_number

ONTARIO_SCHOLARSHIP_FLAG

Ontario Scholarship Approval.

Flag indicating if student is recommended for an Ontario scholarship.

Set to F if Scholarship approved by another board.

Set to 'F' is ONTARIO_SCHOLARSHIP_DATE is undefined.

Set to 'T' if [S_ON_STU_X]Scholarship_Date has a valid date; otherwise, set to 'F'

If [S_ON_STU_X]OtherBrdScholarshipFlg = 1 then ONTARIO_SCHOLARSHIP_FLAG is set to F

ONTARIO_SCHOLARSHIP_DATE

Ontario scholarship approval date of student.

No value is extracted for cross-enrolled students (i.e. for students where MAIN_SCHOOL_FLAG = "F').

Not extracted if Scholarship approved by another board.

Only extracted if the date falls within the current submission period AND if the date falls within the enrolment dates for the student.

[S_ON_STU_X]Scholarship_Date

If ONTARIO_SCHOLARSHIP_FLAG is set F then this field is not extracted

COMMUNITY_INVOLMENT_ACCU_HOURS

Community Involvement Accumulated Hours to Date.

No value is extracted for cross-enrolled students (i.e. for students where MAIN_SCHOOL_FLAG = "F').

OnSIS Business Rules:

Community Involvement Hours should not exceed 999 hours.

If student has no community involvement hours recorded, set to 0.

Calculated from [S_ON_STU_COMMUNITY_HOURS_C]Number_Of_Hours

ENROLMENT_START_DATE

Enrolment start date. Format = yyyy/mm/dd.

If the student has no class enrolments, use the school enrolment entry date ([Students/ReEnrollments]EntryDate) for the student's primary enrolment.

The earliest [CC]DateEnrolled that falls within the submission period from the classes in which the student is enrolled at the school (primary or cross-enrolment).

ENROLMENT_END_DATE

Enrolment end date. Format = yyyy/mm/dd

In a June submission, if the exit date in the associated CC record is September 1st or later, enrolment end date is set to the submission period end date.

If the student has no class enrolments, use the school enrolment exit date ([Students/ReEnrollments]ExitDate) for the student's primary enrolment.

The latest [CC]DateLeft that falls within the submission period from the classes in which the student is enrolled at the school (primary or cross-enrolment).

MATURE_STUDENT_FLAG

Flag indicating if student is a Mature Student with regards to PLAR (T/F).

OnSIS Business Rules:

June 2008++ Submission Periods

This element is optional. If the Mature Student Flag value and/or tag is not identified when the ACTION of STUDENT_SCHOOL_ENROLMENT is "ADD", the Mature Student Flag will be assigned a value of "F".

From 2023-2024 submission onwards the following logic applies:

If [ON_OnSIS_Snapshot]STUMATURE =1 then T, if 0/Null then F is reported. This is if a snapshot record exists for the submission. Otherwise, if [S_ON_STU_X]Mature_Student = 1 then T. Otherwise, F.

The following logic applies for before 2023-2024 submission:

[When [S_ON_STU_X]Mature_Student = 1 Then 'T' Otherwise 'F'

OYAP_FLAG

Flag indicating whether the student is enrolled in the Ontario Youth Apprenticeship Program (T/F).

Extracted starting with the 2014-2015 school year - i.e. the year associated with the currently selected PowerSchool term is equal to or greater than the year associated with the 2014-2015 year long term.

If MAIN_SCHOOL_FLAG = "F" then extract "F"; otherwise, [S_ON_STU_X]OYAP

STU_BRD_RES_STAT_TYPE

Board Residence Status.

Value from(from [S_ON_STU_X]/[S_ON_REN_X]table is used.

If Brd_Res_Status 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.

The Snapshot table value is used when present; otherwise, the [Student]ReEnrollment table is used.

[S_ON_STU_X]Curr_Country

[S_ON_REN_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) 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.

Snapshot table value is used when present; otherwise, the [Student.ReEnrolment] table is used.

[S_ON_STU_X]Curr_Province

[S_ON_REN_X]Curr_Province

GENDER_TYPE

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

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.

PLAR_ATTENDANCE_TYPE

The rationale for granting a mroe than 10 Grade 11 and 12 credits through the challenge and equivalency processes.

Valid values:

• Blank

• 010 - College diploma

• 020 - University degree

• 030 - Certificate of Apprenticeship and/or Qualification

This field is included only if MATURE_STUDENT_FLAG is T.

[S_ON_STU_X]PLAR_ATTENDANCE_TYPE

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

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.

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

[Courses]Instruction_Lang

[Sections]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.

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

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

PARENT_NUMBER

Literacy and numeracy for parents and guardians.

[ON_LNPG_CONTACTS]ADE_ParentNumber

START_TIME

HH:MM using 24 hour clock

END_TIME

HH:MM using 24 hour clock

ADE_SEPTEMBER_JUNE

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.

All ADE values are rounded to 4 decimal places.

If the course offering type is '10', '11', or '12 (i.e. a Correspondence/Self-Study/Online class) and the student is a full time student on the October count date, the report excludes the work units/lessons marked from September 1 - January 30 when calculating ADE. If the student is a full time student on the March count date, the report excludes the work units/lessons marked from February 1 - June 30. 

ADE is calculated when the student is enrolled in different schools on the October and March count dates, with different attendance types, and is cross-enrolled in a Correspondence/Self-Study/Online) class that crosses both count dates.

Note:

• The data for a register course associated with a school that is marked as a night school and that starts on or after June 25 is included in Summer ADE. Data for courses starting before June 25 are reported in September-June ADE.

• In Quad/Octomester model, Student attendance type is calculated based on sum of the student FTE at all the schools the student was enrolled.
  If Total FTE >= 0.7 then Student Attendance type is FT else PT

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

ADE = (Lessons Recognized multiplied by 0.00579 and rounded to 4 decimals

If class qualifies as an Adult Diploma Credit:

ADE = ( Sessions Recognized per Sections) multiplied by 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.####)

ADE = 0 if students are FT in October, PT in March, enrolled in a year-long online section, left class on the first day of semester 2 and work unites entered in the override Lessons/Work Units Completed field or entered with no Date marked.

ADE_SUMMER

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.

All ADE values are rounded to 4 decimal places.

Note: The data for a register course associated with a school marked as a night school and that starts on or after June 25 is included in Summer ADE. Data for courses starting before June 25 are reported in September-June ADE.

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

ADE = (Lessons Recognized multiplied by 0.00579 and rounded to 4 decimals.

If class qualifies as an Adult Diploma Credit:

ADE = ( Sessions Recognized per Sections) multiplied by 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 calculations if associated with the attendance category, CEUNFUNDED.

CLASS_CODE

Value of Class Code.

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.

• When multiple classes are combined into a single segment, the Class Code of the class that is first created is reported.

[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" "UPDATE"

n/a

MINISTRY_DFND_CRS

Ministry Defined Course Code.

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

[S_ON_CRS_X]Institution_Type

LOCAL_DEV_CRS

Locally Developed Course Code.

[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

Course Scheduling Indicator

This element is mandatory.

As described in the ON Derived Fields Document

Derived from [Terms]Portion

NEW COURSE_SEM_TYPE

Not Used

n/a

WITHDRAWAL_TYPE

Withdrawal Type if student has withdrawn from this course during the current submission period. If the withdrawal occurs after the end of the submission period, then the submitted withdrawal type is NULL (empty).

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 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 < [terms]lastDay and [StoredGrades]Grade is null then 'D'

WITHDRAWAL_DATE

Withdrawal date. Format = yyyy/mm/dd

If the Withdrawal_Type = 'W', then specify the withdrawal date; otherwise, set to NULL.

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

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

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.

Date is set to [S_ON_SGR_X]Credit_Date, if defined and less than CC.DateLeft and <= the submission period count date; otherwise, CC.DateLeft, if <= Count Date and <= Last Day of Term;

Otherwise, Last Day of Term (to match class End Date), if [CC]DateLeft <= Count Date and > Last Day of Term;
Otherwise, Last Day of Term, if [CC]DateLeft > Count Date and Last Day of Term = Count Date;
Otherwise, Last Day of Term.

EARNED_CREDIT_VALUE

Credit value earned.

[StoredGrades]EarnedCrHrs where [StoredGrades]Grade is not null

When [S_ON_SGR_X]Transcript_W = 1, then '0.00'

ATTEMPTED CREDIT_VALUE

Credit Hours for the course.

[Courses]Credit_Hours

NEW ATTEMPTED CREDIT VALUE

Not Used

n/a

FINAL_MARK

Final Mark

PowerSchool Business Rules:

The final mark must have a value (even if 0), if the course is complete (AND course is not an equivalent credit course), if the withdrawal_type = 'W' or if it is the end of the academic year for the school.

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

Set to "0" if <WITHDRAWAL_TYPE> is "D" (dropped).

[StoredGrades]Grade where [StoredGrades]PotentialCrHrs = [Courses]Credit_Hours

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

Either [StoredGrades]PotentialCrHrs and [Courses]Credit_Hours > 0 or [Courses]Credit_Hours = 0 for the [StoredGrades]Course_Number

'T' if [CC]DateLeft >= [Terms]LastDay

Otherwise, 'F'

Set to 'T' or 'F'

COURSE_REPEAT_FLAG

Flag indicating this course is a repeated course

Regardless of the 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_Enrollment> 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 Night 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

'F' If [CC]DateLeft > [Terms]LastDay

'T' if [CC]DateLeft < [terms]lastday, [Courses]Credit_Hours > 0, and [StoredGrades]Grade is null or W

Otherwise, 'F'

Set to 'T' or 'F'

COURSE_CONTINUED_FLAG

Flag indicating the course is continued from the previous year (T/F).

Extracted starting with the 2014-2015 school year - i.e. the year associated with the currently selected PowerSchool term is equal to or greater than the year associated with the 2014-2015 year long term.

Set to "T" if either [S_ON_CC_X]Previous_Year_Class or [S_ON_SEC_X]Previous_Year_Class is true; otherwise, set to "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

ADE_SEPTEMBER_JUNE

Student's ADE in a class starting prior to June 25th.

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

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

ADE is calculated according to the following rules:

• ADE must be >= 0 and less than (0.59) for each record. Cannot be > 0 if Course Start Date is > or = June 25th of the current academic year.

• if the student was enrolled/cross enrolled in the course on both the October and March count dates, determine the student's attendance type on both dates and calculate the ADE if the student is not FT in a day school on either date (i.e., student wasn't FT on both Oct 31 and Mar 31).

• if the student was enrolled/cross enrolled in the course on Oct 31 but not Mar 31, look only at the attendance type for Oct 31 and calculate the ADE if not FT in a day school.

• if the student was enrolled/cross enrolled in the course on Mar 31 but not Oct 31, look only at the attendance type for Mar 31 and calculate the ADE if not FT in a day school.

• if the student was not enrolled in the course on either date, calculate the ADE.

• if the student is cross-enrolled and has a FT Attendance type in another Night School, calculate ADE.

• If the student is on a Track, the ADE is calculated based on the student's active enrolment for the cross enrolled class.

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.00 is reported if ADE is not calculated.

A value of 0.0000 is reported for 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.####)

ADE_SUMMER

Student's ADE in a class starting on or after June 25th. Not calculated in a night school submission as all classes starting after on or after June 25th are reported in a summer school submission.

ADE must be >= 0 and less than (0.59). Only one can be > 0.

If Course End Date or Course Complete Date is prior to June 25th of the current academic year, ADE must = 0.

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

Always 0.00

CLASS_CODE

Value of Class Code.

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_CRS_X]ConEd_InternationalLanguage

[S_ON_SEC_X]ConEd_InternationalLanguage

OTHER_LANGUAGE_DESC

Defined only if Language Type is "OTH".

[S_ON_CRS_X]OtherLanguageDesc

[S_ON_SEC_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.

Refer to Instructor Count Logic, above

STUDENT_COUNT

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

This element is only available for the 2015-2016 school year and earlier.

Refer to Student Count Logic, above

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.

This element is available for the 2016-2017 school year and forward.

Refer to Student Count Logic, above

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.

This element is available for the 2016-2017 school year and forward.

Refer to Student Count Logic, above

HOUR_COUNT

The total number of hours of funded classroom instruction for all classes included in the segment, calculated in the same way as the paper ILE register.

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

Always 'ADD'

TIMEOFDAY_TYPE

[S_ON_CRS_X]TimeOfDay_Type

[S_ON_SEC_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.

Data Element

Description

[Table]FieldName

PLAR

This is the outer tag for student PLAR.

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"

TYPE

PLAR Information - PLAR Type.

Uniquely identify the Prior Learning Assessment Recognition type.

The combination of elements TYPE, MINISTRY_DFND_CRS and DATE_APPROVED (or NEW_DATE_APPROVED) is used to uniquely identify the PLAR.

[StoredGrades]ON_PLAR_Type

MINISTRY_DFND_CRS

Ministry Defined Course Code.

OnSIS Business Rules:

The combination of elements TYPE, MINISTRY_DFND_CRS and DATE_APPROVED (or NEW_DATE_APPROVED) is used to uniquely identify the PLAR.

[Courses]Alt_Course_Number where [S_ON_SGR_X]Course_Type = "M"

STATUS_TYPE

PLAR Information - Status Type.

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

[S_ON_SGR_X]PLAR_Status

CREDIT

The Prior Learning Assessment Recognition total credit value.

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

[StoredGrade]EarnedCrHrs

COMPULSORY_CREDIT

The Prior Learning Assessment Recognition compulsory credit value.

This value will never exceed the value of CREDIT. It represents the number of credits (as reported by CREDIT) which are considered compulsory based on the diploma categories to which the credits included in the segment are assigned. Diploma categories other than 99 (optional) are considered compulsory.

[StoredGrades]EarnedCrHrs, for those courses included in the segment which are deemed compulsory as determined by the getClassCreditXRef common function, described by OnSIS Night School Submission Report.

DATE_APPROVED

Date completed. (Other Credit Information - Date Completed) Format = yyyy/mm/dd.

The latest completion date for the set of records included in the segment is used.

OnSIS Business Rules:

The combination of elements TYPE, MINISTRY_DFND_CRS and DATE_APPROVED (or NEW_DATE_APPROVED) is used to uniquely identify the PLAR.

[S_ON_SGR_X]Credit_Date

NEW_DATE_APPROVED

The revised date of approval for Prior Learning Assessment Recognition. Format = yyyy/mm/dd.

PowerSchool Business Rules:

This element is not used.

Always blank

Data Element

Description

[Table]FieldName

DIPLOMA

This is the outer tag for student DIPLOMA.

Note: 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" "UPDATE" "DELETE"

"DELETE" if [S_ON_STU_X]Diploma_Type is null or [S_ON_STU_X]Diploma_Date is null.

"ADD" if [S_ON_STU_X]Diploma_Type is not null and [S_ON_STU_X]Diploma_Type <> 99 and [S_ON_STU_X]Diploma_Date is not null and [S_ON_STU_X]Diploma_Date is in this school year and [ON_Diplomas]Enrollment_Key is null.

"UPDATE" if [S_ON_STU_X]Diploma_Date is not equal to [ON_Diplomas]certificate_issued and [S_ON_STU_X]Diploma_Date is in this school year and [S_ON_STU_X]Diploma_Type is equal to [ON_Diplomas]type.

"DELETE" then "ADD" if [ON_Diplomas]type is not equal to [S_ON_STU_X]Diploma_Type.

n/a

TYPE

Element Type is used to uniquely identify the diplomas/certificate.

[S_ON_STU_X]Diploma_Type

For Action DELETE

[ON_Diplomas]Type

CERTIFICATE_ISSUED

Diploma Certificate issuance date. Format = yyyy/mm/dd

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

[S_ON_STU_X]Diploma_Date

For Action DELETE

[ON_Diplomas]Certificate_Issued

Data Element

Description

[Table]FieldName

OTHER_CREDIT

This is the outer tag for student Other Credits.

n/a

ACTION

This is the action associated with this submission.

Only "ADD" action is submitted.

n/a

MINISTRY_DFND_CRS

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

The combination of element MINISTRY_DFND_CRS (including INSTITUTION_TYPE for Dual Credit Course) or LOCAL_DEV_CRS (mutually exclusive) and COURSE_COMPLETE_DATE (or NEW_COURSE_COMPLETE_DATE) is used to uniquely identify the Other Credit.

If [S_ON_CRS_X]Course_Type = 'M' then [Courses]Alt_Course_Number; otherwise, blank

INSTITUTION_TYPE

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

If [S_ON_CRS_X]Course_Type = 'M' then [S_ON_CRS_X]Institution; otherwise, blank

LOCAL_DEV_CRS

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

The combination of element MINISTRY_DFND_CRS (including INSTITUTION_TYPE for Dual Credit Course) or LOCAL_DEV_CRS (mutually exclusive) and COURSE_COMPLETE_DATE (or NEW_COURSE_COMPLETE_DATE) is used to uniquely identify the Other Credit.

If [S_ON_CRS_X]Course_Type = 'L' then [Courses]Alt_Course_Number; otherwise, blank

COURSE_COMPLETE_DATE

The date when the other credit course was completed.

Format = yyyy/mm/dd

[S_ON_SGR_X]Credit_Date

NEW_COURSE_COMPLETE_DATE

The revised date when the other credit course was completed.

PowerSchool Business Rules:

This element is not submitted

n/a

TYPE

Uniquely identify the Other Credit type.

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

[S_ON_SGR_X]Credit_Type

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

[S_ON_SGR_X]OthCrsInfo_Cred_Recovery

[S_ON_SGR_X]OthCrsInfo_Ministry_Content

EARNED_CREDIT

Earned Credit Value.

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

[StoredGrades]EarnedCrHrs

FINAL_MARK

Final Mark.

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

[StoredGrades]Grade

SPCE

This is the outer tag for the SPCE Program.

Note: The student SPCE values and/or tags provided for submission periods prior to June 2018-2019 will result in error.

n/a

ACTION

This is the action associated with this submission

Only "ADD" action is submitted

TYPE

Uniquely identifies the SPCE Program

[S_ON_SEN_X]SPC_Innovation = 1

[S_ON_SEN_X]SPC_Coding = 2

[S_ON_SEN_X]SPC_MathLit = 3

Data Element

Description

[Table]FieldName

SHSM_PROGRAM

This is the outer tag for SHSM Program.

Note: 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"

Note: "UPDATE" is a valid action when changing ALL_REQUIREMENTS_MET_DATE and/or adding, updating or deleting SHSM Certifications.

n/a

TYPE

Element Type is used to uniquely identify the SHSM Program.

Gen.value2 , where

[gen]cat = 'specprog'

[S_ON_GEN_SPECPROG_X]SHSM_Flag = 1

[gen]value2 (program type) is not null

ALL_REQUIREMENTS_MET_DATE

All Requirements Met Date as it appears on the SHSM Program. Format = YYYY/MM

Spenrollments custom field.

When [S_ON_SEN_X]shsm_program_date when prior or equal to submission end date.

Otherwise, NULL.

Data Element

Description

[Table]FieldName

SHSM_CERTIFICATION

This is the outer tag for SHSM Certification

n/a

ACTION

This is the action associated with this submission.

Value: "ADD"

n/a

TYPE

Element Type is used to uniquely identify the SHSM Certification.

For Action ADD

[S_ON_STU_SHSM_Cert_C]certType

DATE_COMPLETED

Date when SHSM Certification was completed.

When the action of SHSM_CERTIFICATION is "ADD", this element is mandatory.

Format = YYYY/MM

For Action ADD

[S_ON_STU_SHSM_Cert_C]Date_Completed

CERTIFICATION_HOURS

SHSM Certification Hours. Format = 999.99

For Action ADD

[S_ON_STU_SHSM_Cert_C]Certification_Hours

Data Element

Description

[Table]FieldName

SHSM_COURSE

Note: The SHSM Course Segment is not reported as of June 2019

This is the outer tag for SHSM Course.

The SHSM Course values and/or tags provided for submission periods prior to March 2009 will be ignored.

n/a

ACTION

This is the action associated with this submission.

Value: "ADD" "DELETE"

The combinations of elements MINISTRY_DFND_CRS (including INSTITUTION_TYPE for Dual Credit Course) or LOCAL_DEV_CRS (mutually exclusive), DATE_COMPLETED, EARNED_CREDIT_VALUE, FINAL_MARK and COURSE_DELIVERY_TYPE or CREDIT_TYPE (mutually exclusive) are used to uniquely identify the SHSM Courses.

Note: For "DELETE" action, if both COURSE_DELIVERY_TYPE and CREDIT_TYPE are not provided, delete the SHSM Course record that matches MINISTRY_DFND_CRS (including INSTITUTION_TYPE for Dual Credit Course) or LOCAL_DEV_CRS, DATE_COMPLETED, EARNED_CREDIT_VALUE, FINAL_MARK, and has null value for both COURSE_DELIVERY_TYPE and CREDIT_TYPE.

n/a

MINISTRY_DFND_CRS

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

The combination of element MINISTRY_DFND_CRS and INSTITUTION_TYPE is used to identify the Dual Credit Course.

Note: Ended course code should be considered as valid for SHSM course submission as long as it meets rule SHSM Course #5 (MSHSMR005) requirements.

PS Business rules:

Course_Type must be M

For Action ADD [Courses]Alt_Course_Number when [S_ON_CRS_X]Course_Type = M or is null

For Action DELETE

[ON_SHSM_COURSES]Ministry_Dfnd_Crs

INSTITUTION_TYPE

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

The combination of element MINISTRY_DFND_CRS and INSTITUTION_TYPE is used to identify the Dual Credit Course

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

Note: Ended institution type code should be considered as valid for SHSM course submission.

For Action ADD, [S_ON_CRS_X]Institution custom field

For Action DELETE, [ON_SHSM_COURSES]Institution_Type

LOCAL_DEV_CRS

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

Note: Ended course code should be considered as valid for SHSM course submission as long as it meets rule SHSM Course #5 (MSHSMR005) requirements.

PS Business rules:

If COURSE_TYPE = L then pull ALT_COURSE_NUMBER

For Action ADD

[Courses]Alt_Course_Number when [S_ON_CRS_X]Course_Type = L

For Action DELETE

[ON_SHSM_COURSES]Local_Dev_Crs

COURSE_DELIVERY_TYPE

Only COURSE_DELIVERY_TYPE or CREDIT_TYPE can have a value but not both at the same time (mutually exclusive).

For "ADD" actions, if both delivery type and credit type are undefined in the database, COURSE_DELIVERY_TYPE is set to "1" and CREDIT_TYPE to empty.

Note: Ended course delivery type should be considered as valid for SHSM course submission

For Action ADD

when [S_ON_CC_X]Withdrawal_Type is null

[S_ON_SGR_X]Delivery_Type, if not null; otherwise, [S_ON_SEC_X]Delivery_Type

For Action DELETE

[ON_SHSM_COURSES]Course_Delivery_Type

'9' (Continuing Education) if undefined.

CREDIT_TYPE

Only COURSE_DELIVERY_TYPE or CREDIT_TYPE can have a value but not both at the same time (mutually exclusive).

For "ADD" actions, if both delivery type and credit type are undefined in the database, COURSE_DELIVERY_TYPE is set to "1" and CREDIT_TYPE to empty

Note: Ended credit type should be considered as valid for SHSM course submission.

For Action ADD

[S_ON_SGR_X]Credit_Type

For Action DELETE

[ON_SHSM_COURSES]Credit_Type

DATE_COMPLETED

The date when the course was completed.

Format = yyyy/mm/dd

For Action ADD

IF course exists in ON_SHSM_CRS_ENROLS with matching Ministry_Dfnd_Crs, Institution_Type, Local_Dev_Crs, Course_Delivery_Type, Earned_credit_value, and Final Mark AND Course_End is NOT NULL then:

• [On_SHSM_Crs_Enrols]Course_End;

Otherwise:

• if [S_ON_SGR_X]Credit_Date is defined, use that value

• if [S_ON_SGR_X]Credit_Date is undefined and there is an associated CC record, use the calendar date immediately prior to[CC]DateLeft

• if [S_ON_SGR_X]Credit_Date is undefined and there is no associated CC record and [StoredGrades]TermId is defined (i.e. non-zero), use [Terms]LastDay for the associated term

For Action DELETE

[ON_SHSM_COURSES]Date_Completed

EARNED_CREDIT_VALUE

Earned Credit Value of the course.

For Action ADD

[StoredGrades]EarnedCrHrs

trimmed and formatted as 00.00

For Action DELETE

[ON_SHSM_COURSES]Earned_Credit_Value

FINAL_MARK

Final Mark of the course.

For Action ADD

[StoredGrades]Grade

trimmed and formatted as 000

For Action DELETE

[ON_SHSM_COURSES]Final_Mark