OCAS Electronic Transcript Management System (eTMS)

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,
then send Surname.

38

A (15)

Y

Y

All Spaces

Legal First Given Name

Student. Person.
Name. FirstName

Students, Select Student,
Biographics, Name, Given Name

38

A (15)

N

N

No Default Value Permitted

Legal Second Given Name & Initial

Student. Person.
Name. MiddleName

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.
 Organization. ESIS

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.
 Birth. Birthdate

Students, Select Student,
 Biographics, Birth date

50

A (1)
[M, F,  blank]

Y

Y

No Default Value Permitted

Gender Code

Student. Person. Gender. GenderCode

Students, Select Student,
Biographics, Gender

121

A (1)
[0, 1, 2, 3, 4, 5]

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
 academic year.

“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
Detail. SessionBeginDate

Students, Select Student,
Enrolment, Entry to this school 

98

DATE

N

N

 

OSSD Issue Date

Student. AcademicRecord. AcademicSession. AcademicSession
Detail. SessionEnd
Date

Students, Select Student, History, First Diploma Date

53

I
[0, 1, 2, 3]

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
“1 = Yes (Completed)
“2 = No (Not completed)
“3 = N/A (Not applicable

53

A
[0, E, F, X]

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)

OSSD
OSHGD
SSGD
OSSC
C of A
C of E 
C of T>

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
Number

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
[9, 10, 11, 12, 13, 1, 2, 3, 4, 5, NA]

N

Y

No Default Value Permitted

Course Grade/Level

Student. AcademicRecord. Course. CourseCreditLevel

Student, Select Student, History, Course code -
4th character of code
1 = 9
2 = 10
3 = 11
4 = 12
A = 1
B = 2
C = 3
D = 4
E = 5
all others
send NA

 

A
[R, W, Blank]

N

Y

Blank

Course Status

Student. AcademicRecord. Course. CourseAcademic
GradeStatusCode

Send R  for Repeat,
W for Withdrawn
otherwise leave blank

176

A
[D, N, S, C, O]

N

Y

D

Course Delivery

Student. AcademicRecord. Course. CourseInstructionSite

cross reference
course code with
code file -  Delivery

“D = Day, N = Night
S = Summer
C = Correspondence
O = Other

 

N/A

N/A

Y

R

Course Type

Student. AcademicRecord. Course. UserDefined
Extension.
CourseType

cross reference
course code with
code file - Course Type

O = Co-op Out of School

I = Co-op In School

Otherwise send R for Regular

176

A (3)

N

Y

No Default Value Permitted

Course Percentage Grade

Student. AcademicRecord. Course. CourseAcademic
Grade

Student, Select Student, History, Mark

176

A
[P, C, M, F]

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
Extension.
Compulsory

Student, Select Student, History, Compulsory
(Y/N) Flag

176

A (3)
[ENG, FRE, OTH]

N

Y

No Default Value Permitted

Language of Instruction

Student. AcademicRecord. Course. Language
OfInstruction. LanguageCode

cross reference
course code with
code file - Language

 

A (1)

[C, Blank]

N/A

N

Blank

Course Note 1

Student. AcademicRecord. Course. UserDefined
Extension. CourseNote1

cross reference
ourse code with
code file - if Course
Type is out of school
co-op then send 'C' otherwise send blank.

 

A (1)
[F, Blank]

N/A

N

Blank

Course Note 2

Student. AcademicRecord. Course. UserDefined
Extension. CourseNote2

cross reference
course code with
code file - if Language
 of instruction is French, then send 'F' otherwise send Blank.

 

A (1)
[M, Blank]

N/A

N

Blank

Course Note 3

Student. AcademicRecord. Course. UserDefined
Extension. CourseNote3

cross reference
course code with
code file - OST Notes

If Modified program is selected, then send 'M', otherwise send blank.

 

A (1)
[I, Blank]

N/A

N

Blank

Course Note 4

Student. AcademicRecord. Course. UserDefined
Extension. CourseNote4

cross reference
course code with
code file - OST Notes

If Interdisciplinary
Studies is selected
hen send 'I' otherwise
send blankan>

 

A (1)
[S, Blank]

N/A

N

Blank

Course Note 5

Student. AcademicRecord. Course. UserDefined
Extension. CourseNote5

cross reference
course code with
code file - OST Notes

If Special Indicator is selected then send 'S' otherwise send blank

 

A (1)
[A, D, Blank]

N/A

N

Blank

Course Note 6

Student. AcademicRecord. Course. UserDefined
Extension. CourseNote6

cross reference
course code with
code file - OST
Notes If Alternative Expections is
selected then send 'A'

D = French
equivalent of “A

otherwise send blank

176

I (6)

N

Y

No Default Value Permitted

Course School BSID

Student. AcademicRecord. Course. CourseOverride
School. ESIS

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)