OCAS has developed a system to allow boards to monitor and administer applicant high school transcript requests for students. Currently the feature only includes past or inactive students (those that have graduated or left high school). All currently active students should still be sent via the current OCAS/OUAC transmission process. This feature is known as the Electronic Transcript Management System (eTMS). The eTMS file is generated in an XML format, and provides all of the same data that is in the typical OCAS/OUAC extract file, with a few additional fields.
Although the Maplewood application can be run from the school or board level, the Maplewood default is to allow access at the Board level only. If you would like your schools to have direct access to this application, please seek approval from OCAS first, then send a request into Maplewood to have this change made.
Within the Maplewood OCAS/OUAC application, each submission period will only indicate the MONTH that the file is due. This is to ensure that schools are using the latest documentation given to them from the respective parties, and not relying on Maplewood due dates for submission deadlines.
Courses with a Note of A or M (for Alternate or Modified Expectations - i.e. no credit) must have a Course Status of "X". A Course Status of X is defined as Not applicable (N/A) (The student is taking or has completed a non-credit course.)
Changes for the 2013/14 submission cycle: New field called Home school Indicator has been added to the submission file. This field will be populated based on the Main School Holder of the OSR field. If this field has 'This School' selected then Maplewood will send 'Y' (for yes) in the file. Note: As with other areas within this program, Maplewood will only be looking at current status and will not be looking at residency internal transfers. OCAS and Dropped Courses: Previously If a student drops a class, and adds another one where the 7th character of the course code was unique, the course was sent as a drop.
OCAS/OUAC only collects the first 6 characters of the course code - therefore OCAS validation picked the courses up as duplicates (because they have the same 6 character code and same completion date). Maplewood has modified the program to only look at the first 6 characters when determining whether to send a class as a drop or not. Note: If classes have different course types (or class end dates) then the drop will still be sent.
The pilot system allows users to:
Advantages of the eTMS system
Advantages to applicants
–Less time and cost vs. requesting transcripts in person and sending to OCAS or colleges of choice
Advantages to OCAS
–Reduced paper handling and data entry costs
Advantages for colleges
–Faster admission decisions
–Reduced data entry
–Trusted grade information
Advantages to the boards
–New revenue source
–Savings in transcript paper, toner, envelopes, and postage
–Improved security
Advantage to SIS Vendor
–Happy clients
Here is how it works:
Peace of mind knowing that eTMS uses the Industry Standard
Some Background:
The average number of requests that come into the board is approximately 5 to 15 a day (could be as little as 1 a day or 2 a week depending on time of year) - with the highest volume being the month of January and February 1st. So this by no means will occupy the users whole day. Although similar to the OnSIS process, it may require more attention during the peak time (January/February).
The current processing/service fee that the 4 pilot boards are using is $20.00 - but this is determined by each board, and therefore can be changed on a board by board basis. There is a monthly reconciliation with the Board (and OCAS). When responding to a transcript request, Board users are required to select the appropriate action and then click the Submit button.
The list and descriptions of acknowledgements are highlighted below (note: With any action, the board still gets paid).
Upload data file to OCAS: File created via Maplewood is uploaded to the OCAS eTMS system.
Transcript Image Sent to OCAS: Indicates that the transcript is only available in a hard copy format and is being sent to OCAS.
Student Not Found: Indicates that the student for whom the transcript was requested could not be identified On Financial Hold: Indicates that the transcript cannot be produced at the requested time due to a financial or other hold at the board.
No Academic Data: Indicates that the request could not be fulfilled because although the student was found on the institution’s SIS, there was no academic data to send (i.e. Student pre-registered only).
Each Transcript file transmitted to OCAS must contain one Transcript Header (TH) record and at least one transcript grade record (TG). Values will be separated with a pipe | character.
OCAS will accept one single file layout as detailed below. If the file doesn’t match this layout, a “FILE ERROR will be set in the system and the transcript will not be processed. File Format Transcript Header
|
PESC |
OCAS DATABASE |
|
|
Maplewood | |||
|
Page Defined in PESC Standard |
Type in PESC Standard |
Required(Yes or No) |
Required atOCAS |
Default Value at OCAS if required |
TMS Field Name |
XML Mapping |
|
|
100 |
A (6) |
Y |
Y |
No Default Value Permitted |
School BSID |
Student. AcademicRecord. AcademicSession. School. ESIS |
File, School Setup, Schools, School Number |
| 32 | A (12) | Y | Y | No Default Value Permitted | Secondary School Student Number | Student. Person. SchoolAssigned PersonID |
Students, Select Student, Biographics, Name, Student Number |
| 53 | A (9) | N | Y | All Zeros 000000000 |
Ministry Identification Number (MIN) | Student. AcademicRecord. UserDefined Extension. MIN |
Students, Select Student, Enrolment, MIN |
| 32 |
I (9) |
Y |
Y |
All Zeros 000000000 |
Ontario Education Number (OEN) | Student. Person. AgencyAssignedID | Students, Select Student, Enrolment, OEN |
|
38 |
A (30) |
Y |
Y | No Default Value Permitted | Legal Surname | Student. Person. Name. LastName |
Students, Select Student, Biographics Name, Legal Surname. If Legal surname is blank, |
|
38 |
A (15) |
Y |
Y |
All Spaces |
Legal First Given Name |
Student. Person. |
Students, Select Student, Biographics, Name, Given Name |
|
38 |
A (15) |
N |
N |
No Default Value Permitted |
Legal Second Given Name & Initial |
Student. Person. |
Students, Select Student, Biographics, Name, Middle Name |
|
2 |
A (15)
|
Y |
Y |
No Default Value Permitted |
Reference Number |
Transmission Data. RequestTrackingID |
As it appears in the request file (from OCAS) for the student |
|
32 |
I (9) |
Y |
Y |
No Default Value Permitted |
OCAS Application Number |
Student. Person. RecipientAssignedID |
As it appears in the request file (from OCAS) for the student |
|
6 |
A (70) |
Y |
Y |
No Default Value Permitted | Board Name | TransmissionData. Source. Organization. OrganizationName |
File, School Setup, Central Office Information, Board Info.(tab), Board Name |
|
6 |
A (8) |
Y |
Y |
No Default Value Permitted |
Board BSID |
TransmissionData. Source. |
File, School Setup, Central Office Information, Board Info.(tab), Board Number |
|
100 |
A (70) |
Y
|
Y |
No Default Value Permitted |
School Name |
Student. AcademicRecord. AcademicSession. School. OrganizationName |
Home School of the student |
|
35 |
DATE |
Y |
Y |
No Default Value Permitted |
Birth Date |
Student. Person. |
Students, Select Student, Biographics, Birth date |
|
50 |
A (1) |
Y |
Y |
No Default Value Permitted |
Gender Code |
Student. Person. Gender. GenderCode |
Students, Select Student, Biographics, Gender |
|
121 |
A (1) |
N |
Y |
No Default Value Permitted | Grad Status Code | Student. AcademicRecord. AcademicSession. AcademicAward. AcademicAward Level |
Students, Select Student, History, Area of Requirements “0 = Not known “1 = OSSD already achieved under OS:IS. “2 = Will achieve OSSD under OS:IS by the start of September of the current academic year. “3 = No the student has not already achieved their OSSD and No the student will not achieve their OSSD by start of September of the current “4 = OSSD already achieved under OSS “5 = Will achieve OSSD under OSS by the start of September of the current academic year |
|
98 |
DATE |
N |
Y |
No Default Value Permitted |
Date of Entry |
Student. AcademicRecord. AcademicSession. AcademicSession |
Students, Select Student, Enrolment, Entry to this school |
|
98 |
DATE |
N |
N |
OSSD Issue Date |
Student. AcademicRecord. AcademicSession. AcademicSession |
Students, Select Student, History, First Diploma Date | |
|
53 |
I |
N |
Y |
0 |
Community Involvement |
Student. AcademicRecord. UserDefined Extension. Community Involvement |
Students, Select Student, Ontario Report Card Details (StuInfo DB), Community Involvement
“0 = Not Reported |
|
53 |
A |
N |
Y |
0 |
Literacy Test |
Student. AcademicRecord. UserDefined Extension. LiteracyTest |
Students, Select Student, Ontario Report Card Details (StuInfo DB), Literacy Test
“0 = Not completed/Reported “E = Successfully completed in English (1) “F = Successfully completed in French (2) “X = Not applicable (N/A) (3) |
|
125 |
A (50) |
N |
N |
Specialized Program |
Student. AcademicRecord. AcademicSession. AcademicAward. Academic AwardProgram. Academic ProgramName |
Students, Select Student, History,Area of Requirements
If Business or Technical is selected. or Students, Select Student, History, High Skills Major |
|
|
121 |
A (80)
|
N |
N |
No Default Value Permitted | Graduate Diploma Name | Student. AcademicRecord. AcademicSession. AcademicAward. AcademicAwardTitle | Students, Select Student, History, First Diploma |
|
2 |
DATE |
Y |
Y |
No Default Value Permitted |
Date Transcript Issued |
TransmissionData. CreatedDateTime |
The date (YYYY/MM/DD) the electronic transcript file was extracted/created |
| 130 | DECIMAL (5) | N | Y | No Default Value Permitted | Total number of credits | Student. AcademicRecord. AcademicSession. AcademicAward. Academic AwardProgram. Program Summary. GPA. CreditHoursEarned |
Students, Select Student, History, Total number of Credits earned |
|
130 |
DECIMAL (5) |
N |
Y |
No Default Value Permitted |
Total number of compulsory credits | Student. AcademicRecord. AcademicSession. AcademicAward. Academic AwardProgram. ProgramSummary. GPA. TotalQualityPoints |
Students, Select Student, History, Total number of compulsory credits earned |
|
14 |
A (60) |
Y
|
Y |
No Default Value Permitted | Contact first and last name | TransmissionData. Source. Organization. Contacts. Phone. NoteMessage |
File, School Setup, Central Office Information, Board Info.(tab), Maplewood Support Information, Contact |
|
14 |
A (11) |
Y |
Y |
No Default Value Permitted |
Contact phone number |
TransmissionData. Source. Organization. Contacts. Phone. PhoneNumber |
File, School Setup, Central Office Information, Board Info.(tab), Maplewood Support Information, Phone |
|
2 |
A (1) [T, P] |
Y |
Y |
No Default Value Permitted | Transmission Type | TransmissionData. Document ProcessCode |
T = Test P = Production |
Grades Data
|
PESC |
OCAS DATABASE |
|
|
Maplewood | |||
|
Page Defined in PESC Standard |
Type in PESC Standard |
Required(Yes or No) |
Required at OCAS |
Default Value at OCAS if required |
TMS Field Name |
XML Mapping |
|
|
176 |
A (6) |
N |
Y |
No Default Value Permitted |
Course Code |
Student. AcademicRecord. Course. Course |
Student, Select Student, History, Course Code |
|
176 |
DATE |
N |
Y |
No Default Value Permitted |
Course Completion Date |
Student. AcademicRecord. Course. CourseEndDate |
Student, Select Student, History, Completion date |
|
176 |
A (80) |
N |
Y |
No Default Value Permitted |
Course Title |
Student. AcademicRecord. Course. CourseTitle |
Student, Select Student, History, Course Titlae |
|
176 |
A |
N |
Y |
No Default Value Permitted |
Course Grade/Level |
Student. AcademicRecord. Course. CourseCreditLevel |
Student, Select Student, History, Course code - 4th character of code
|
|
|
A |
N |
Y |
Blank |
Course Status |
Student. AcademicRecord. Course. CourseAcademic |
Send R for Repeat, W for Withdrawn otherwise leave blank |
|
176 |
A |
N |
Y |
D |
Course Delivery |
Student. AcademicRecord. Course. CourseInstructionSite |
cross reference course code with code file - Delivery “D = Day, N = Night |
|
|
N/A |
N/A |
Y |
R |
Course Type |
Student. AcademicRecord. Course. UserDefined |
cross reference course code with code file - Course Type O = Co-op Out of School I = Co-op In SchoolOtherwise send R for Regular |
|
176 |
A (3) |
N |
Y |
No Default Value Permitted |
Course Percentage Grade |
Student. AcademicRecord. Course. CourseAcademic |
Student, Select Student, History, Mark |
|
176 |
A |
N |
Y |
No Default Value Permitted |
Course Grade Type |
Student. AcademicRecord. Course. CourseCreditUnits |
All Course Grade types will be sent as F for Final (as we are pulling all information from the transcript. |
|
176 |
I (4) |
N |
Y |
No Default Value Permitted |
Course Credits Achieved |
Student. AcademicRecord. Course. CourseCreditEarned |
Student, Select Student, History, Credit Value |
|
|
4 |
N/A |
N |
Blank |
Compulsory |
Student. AcademicRecord. Course. UserDefined |
Student, Select Student, History, Compulsory (Y/N) Flag |
|
176 |
A (3) |
N |
Y |
No Default Value Permitted |
Language of Instruction |
Student. AcademicRecord. Course. Language |
cross reference course code with code file - Language |
|
|
A (1) [C, Blank] |
N/A |
N |
Blank |
Course Note 1 |
Student. AcademicRecord. Course. UserDefined |
cross reference ourse code with code file - if Course Type is out of school co-op then send 'C' otherwise send blank. |
|
|
A (1) |
N/A |
N |
Blank |
Course Note 2 |
Student. AcademicRecord. Course. UserDefined |
cross reference course code with code file - if Language of instruction is French, then send 'F' otherwise send Blank. |
|
|
A (1) |
N/A |
N |
Blank |
Course Note 3 |
Student. AcademicRecord. Course. UserDefined |
cross reference course code with code file - OST Notes If Modified program is selected, then send 'M', otherwise send blank. |
|
|
A (1) |
N/A |
N |
Blank |
Course Note 4 |
Student. AcademicRecord. Course. UserDefined |
cross reference course code with code file - OST Notes If Interdisciplinary |
|
|
A (1) |
N/A |
N |
Blank |
Course Note 5 |
Student. AcademicRecord. Course. UserDefined |
cross reference course code with code file - OST Notes If Special Indicator is selected then send 'S' otherwise send blank |
|
|
A (1) |
N/A |
N |
Blank |
Course Note 6 |
Student. AcademicRecord. Course. UserDefined |
cross reference course code with code file - OST Notes If Alternative Expections is selected then send 'A' D = French otherwise send blank |
|
176 |
I (6) |
N |
Y |
No Default Value Permitted |
Course School BSID |
Student. AcademicRecord. Course. CourseOverride |
Maplewood does not currently store this field - we currently send the school's (in which the student is enrolled) BSID in this field (will be added to Enterprise) |