Lookups

The following is a complete list of all lookups defined in models used by Events. This is for reference only. For context of when each lookup type is used, see Event Data Models.

The following lookups are available for download from the OCAS.ca site https://www.ocas.ca/support/college-partners/extract-files

• Ontario High Schools
• Ontario High School Boards
• Ontario High School Course Codes

Agency

Code	Description
01	Government Of Canada
02	Province Of Ontario
03	Province Of Quebec
04	Canadian Red Cross Society
05	St. John Ambulance
06	Heart And Stroke Foundation Of Ontario
07	Heart And Stroke Foundation Of Quebec
08	Canadian Heart Foundation
09	Royal Life Saving Society Canada
10	Vital Signs
11	Fire Department
12	Other

ApplicationStates

Code	Description
Review	Active
Draft	New Apply
Withdrawn	Withdrawn
PendingPayment	Pending Payment

BasisOfAdmissionReason

Code	Description	Former Coltrane Code
applicantnotindicated	Applicant has not indicated	0
applicantwillbesecondaryschoolgraduateunderosis	Applicant is or will be a secondary school graduate (achieved an OSSD under OS:IS) by the first day of college (i.e., the start date to which they are applying)	1
applicantwillnothaveossd	The applicant will not have an OSSD by the first day of classes	2
applicantwillbesecondaryschoolgraduateundeross	Applicant is or will be a secondary school graduate (achieved an OSSD under OSS) by the first day of college (i.e., the start date to which they are applying)	3
applicantwillnothaveossc	The applicant will not have an OSSC by the first day of classes	4
applicantwillbesecondaryschoolgraduateunderossc	Applicant is or will be a secondary school graduate (achieved an OSSC under OSS) by the first day of college (i.e., the start date to which they are applying)	5

CanadianStatus

Code	Description	Former Coltrane Code
unknown	Unknown	0
canadianCitizen	Canadian Citizen	1
aboriginalAncestry	Aboriginal Ancestry	2
permanentResident	Permanent Resident Or Landed Immigrant	3
study	Study Permit/Student Visa	4
visa	In Canada On The Authority Of Another Visa	5
attendingOffShoreSchool	Attending an Off-Shore School	6
refugee	Refugee Status	7
conventionRefugee	Convention Refugee (Protected Person)	8
other	Other	9

CollegeCodes

Code	Description
ALFR	Collège D'Alfred
ALGO	Algonquin
BORE	Boréal
CAMB	Cambrian
CANA	Canadore
CENT	Centennial
CONF	Confederation
CONS	Conestoga
DURH	Durham
FANS	Fanshawe
GBTC	George Brown
GEOR	Georgian
HUMB	Humber
KEMP	Kemptville
LACI	La Cité
LACS	Collège Des Grands Lacs
LAMB	Lambton
LOYT	Loyalist
MICH	Michener
MOHA	Mohawk
NIAG	Niagara
NORT	Northern
NPAR	Niagara Parks School of Horticulture
RIDG	Ridgetown
SAUL	Sault
SENE	Seneca
SHER	Sheridan
SLAW	St. Lawrence
SSFL	Fleming
STCL	St. Clair

CommunityInvolvementType

Code	Description
1	Yes
2	No
3	Not applicable (N/A)
4	Not reported

Country

Code	Description
41004	Afghanistan
23248	Aland Islands
24008	Albania
33012	Algeria
51016	American Samoa
24020	Andorra
34024	Angola
13660	Anguilla
61010	Antarctica
13028	Antigua And Barbuda
14032	Argentina
41051	Armenia
13533	Aruba
51036	Australia
21040	Austria
41031	Azerbaijan
13044	Bahamas
41048	Bahrain
44050	Bangladesh
13052	Barbados
22112	Belarus
21056	Belgium
12084	Belize
31204	Benin
13060	Bermuda
44064	Bhutan
14068	Bolivia
13535	Bonaire, Saint Eustatius and Saba
24070	Bosnia - Herzegovina
35072	Botswana
61074	Bouvet Island
14076	Brazil
44086	British Indian Ocean Territory
43096	Brunei Darussalam
22100	Bulgaria
31854	Burkina Faso
32108	Burundi
43116	Cambodia
34120	Cameroon
11124	Canada
31132	Cape Verde
13136	Cayman Islands
34140	Central African Republic
34148	Chad
14152	Chile
42156	China
51162	Christmas Island
51166	Cocos (Keeling) Islands
14170	Colombia
32174	Comoros
34178	Congo
34180	Congo, Democratic Republic Of The
51184	Cook Islands
12188	Costa Rica
31384	Côte D'Ivoire
24191	Croatia
13192	Cuba
13531	Curaçao
41196	Cyprus
22203	Czech Republic
23208	Denmark
32262	Djibouti
13212	Dominica
13214	Dominican Republic
14218	Ecuador
33818	Egypt
12222	El Salvador
23826	England
34226	Equatorial Guinea
32232	Eritrea
22233	Estonia
32231	Ethiopia
23234	Faeroe Islands
14238	Falkland Islands (Malvinas)
51242	Fiji
23246	Finland
21250	France
14254	French Guiana
51258	French Polynesia
61260	French Southern Territories
34266	Gabon
31270	Gambia
41268	Georgia
21276	Germany
31288	Ghana
24292	Gibraltar
24300	Greece
11304	Greenland
13308	Grenada
13312	Guadeloupe
51316	Guam
12320	Guatemala
23831	Guernsey
31324	Guinea
31624	Guinea-Bissau
14328	Guyana
13332	Haiti
61334	Heard Island And Mcdonald Islands
12340	Honduras
42344	Hong Kong
22348	Hungary
23352	Iceland
44356	India
43360	Indonesia
41364	Iran
41368	Iraq
23372	Ireland, Republic Of (Eire)
23833	Isle Of Man
41376	Israel
24380	Italy
13388	Jamaica
42392	Japan
23832	Jersey
41400	Jordan
41398	Kazakhstan
32404	Kenya
51296	Kiribati
42408	Korea, North
42410	Korea, South
24983	Kosovo
41414	Kuwait
41417	Kyrgyzstan
43418	Laos
22428	Latvia
41422	Lebanon
35426	Lesotho
31430	Liberia
33434	Libya
21438	Liechtenstein
22440	Lithuania
21442	Luxembourg
42446	Macao
24807	Macedonia (Fyrom)
32450	Madagascar
32454	Malawi
43458	Malaysia
44462	Maldives
31466	Mali
24470	Malta
51584	Marshall Islands
13474	Martinique
31478	Mauritania
32480	Mauritius
32175	Mayotte
12484	Mexico
51583	Micronesia, Federated States Of
22498	Moldova, Republic Of
21492	Monaco
42496	Mongolia
24499	Montenegro
13500	Montserrat
33504	Morocco
32508	Mozambique
43104	Myanmar
35516	Namibia
51520	Nauru
44524	Nepal
21528	Netherlands
13530	Netherlands Antilles
51540	New Caledonia
51554	New Zealand
12558	Nicaragua
31562	Niger
31566	Nigeria
51570	Niue
51574	Norfolk Island
23826	Northern Ireland
51580	Northern Mariana Islands
23578	Norway
41512	Oman
44586	Pakistan
51585	Palau
41275	Palestinian Territory Occupied
12591	Panama
51598	Papua New Guinea
14600	Paraguay
14604	Peru
43608	Philippines
51612	Pitcairn
22616	Poland
24620	Portugal
13630	Puerto Rico
41634	Qatar
32638	Reunion
22642	Romania
22643	Russian Federation
32646	Rwanda
13652	Saint Barthelemy
13663	Saint Martin
51882	Samoa
24674	San Marino
34678	Sao Tome & Principe
41682	Saudi Arabia
23826	Scotland
31686	Senegal
24688	Serbia
24891	Serbia and Montenegro
32690	Seychelles
31694	Sierra Leone
43702	Singapore
13534	Sint Maarten (Dutch part)
22703	Slovakia
24705	Slovenia
51090	Solomon Islands
32706	Somalia
35710	South Africa
14239	South Georgia And The Southern Sandwich Islands
24724	Spain
44144	Sri Lanka
31654	St Helena
13659	St Kitts And Nevis
13662	St Lucia
11666	St Pierre And Miquelon
13670	St Vincent And The Grenadines
33736	Sudan
14740	Suriname
23744	Svalbard And Jan Mayen Island
35748	Swaziland
23752	Sweden
21756	Switzerland
41760	Syria
42158	Taiwan
41762	Tajikistan
32834	Tanzania, United Republic Of
43764	Thailand
43626	Timor-Leste
31768	Togo
51772	Tokelau
51776	Tonga
13780	Trinidad And Tobago
33788	Tunisia
41792	Turkey
41795	Turkmenistan
13796	Turks And Caicos Islands
51798	Tuvalu
32800	Uganda
22804	Ukraine
41784	United Arab Emirates
23826	United Kingdom
11840	United States
51581	United States Minor Outlying Islands
14858	Uruguay
41860	Uzbekistan
51548	Vanuatu
24336	Vatican City State
14862	Venezuela
43868	Viet Nam
13850	Virgin Island (U.S)
13092	Virgin Islands, British
23826	Wales
51876	Wallis And Futuna
33732	Western Sahara
41886	Yemen
32894	Zambia
32716	Zimbabwe

CourseCode

A five- or six-character code representing the equivalent Ontario course taken by an applicant. The format for the course codes is structured as close to the Ontario course codes as possible. Always present.

First 3 Characters

The Ministry list of common course codes can be used to validate the first three characters.

Code	Course
ADA	Dramatic Arts
AMU	Music
ASM	Media Arts
ATC	Dance
AVI	Visual Arts
BAC	Accounting
BDZ	Entrepreneurship
BMZ	Marketing
BTZ	Information and Communication Technology (applied to Business)
BUS	Business Studies
CGU	Geography
CHY	History
CHA	American (US) History
CLN	Legal Studies
CPZ	Political Science
ECZ	Economics
ENG	English
EBT	Business English
ESL	English as a second language
FRA	Français
FSF	French as a second language
FSL	French as a second language
HFA	Food and Nutrition
HSZ	Social Science / Humanities
HRT	World Religions
HZZ	Philosophy
ICS	Computer Studies
LVL	Latin
LVG	Ancient Greek
LYZ	All Other International Languages
MAT	Mathematics
MCV	Calculus and Vectors
MCT	Technical Mathematics
MDM	Statistics / Data Management
MTB	Business Mathematics
MBZ	Business Mathematics
MCZ	Business Mathematics
OTH	Other
PPL	Physical Education and Healthy Living
PPZ	Health
PSZ	Kinesiology
SNC	General Science
SBI	Biology
SPH	Physics
SCH	Chemistry
SVN	Environmental Science
SEZ	Geology / Earth Sciences
TZZ	Technological Studies – General
ZOO	Zoology
ZZZ	Other doesn’t fit into any of above categories

4th Character

The fourth character indicates the grade of a course as follows:

• 1 (Grade 9)
• 2 (Grade 10)
• 3 (Grade 11)
• 4 (Grade 12)
• 0 (OAC)
• K for College
• U for University
• P for other post-secondary level course

For courses in ESL, it indicates the level of a course, as follows:

• A (Level 1)
• B (Level 2)
• C (Level 3)
• D (Level 4)
• E (Level 5)

5th Character

The fifth character indicates the type of course, as follows:

• D (academic)
• P (applied)
• O (open)
• E (workplace preparation)
• C (college preparation)
• U (university preparation)
• M (college/ university preparation)
• T (college delivered dual credit)

Transfer courses are indicated as follows:

• H (academic)
• J (applied)
• K (university preparation)
• L (college/university preparation)
• Q or R (college preparation)
• S (workplace preparation)

Locally developed courses are indicated as follows:

• 1 (academic)
• 2 (applied)
• 3 (open)
• 4 (compulsory English, math or science)
• 5 (workplace preparation)
• 6 (college preparation)
• 7 (university preparation)
• 8 (college/university preparation)

Courses that are OAC level equivalents will be coded as such following the course code (i.e., ENGOAC).

For students who began secondary school between 1984-1985 and 1999-2000, the fifth character indicates the level of difficulty of a course, as follows:

• Courses based on ministry curriculum guidelines:
  • A (advanced)
  • B (basic)
  • G (general)
• Non-guideline courses:
  • X (advanced)
  • Y (basic)
  • Z (general)

6th Character (optional)

The sixth character is set aside for an individual secondary school or board to use. The values in this position are extremely varied (i.e., not suitable for editing).

Other notes

Course codes beginning with K indicate courses consisting of alternative expectations, which do not lead to credits. These codes are structured somewhat differently: the fourth character indicates the year of attendance in secondary school (A for the first year, B for the second, etc.) and the fifth character, N, indicates a non-credit course.

QEV is the code for credits received in the Grade 9 program from 1993-1994 to 1998-1999 (a total of 8 credits, including the compulsory credits). PLE is the code for equivalent credits granted for previous learning outside Ontario or in a non-inspected private school in Ontario.

The codes indicating credits granted to mature students who re-entered secondary school before September 2003 are as follows:

• QEE (equivalent-education credit)
• QAP (apprenticeship-training credit)
• QMA (maturity-allowance credit)
• QSE (credit for course work completed outside Ontario)

OCAS has a MET course code file available to the colleges. This file contains the course codes and titles.

CourseDelivery

Code	Description
C	Correspondence
D	Day
N	Night
O	Other
S	Summer

CourseNote

Code	Description
A	Alternative expectations, which do not lead to a credit
B	Credit count adjusted, combined courses exceed maximum credit value
C	Cooperative education
F	French immersion
H	Specialist High Skills major
I	Interdisciplinary studies
M	Modified curriculum expectations that do not lead to a credit
P	Course taken at a Ministry inspected Ontario private school
S	Special indicator noting that the student’s performance in a Grade 11 or 12 course or an OAC was affected by extraordinary circumstances
T	Team-taught dual credit course
X	Substitution for a compulsory credit course

CourseStatusType

Code	Description
R	Repeated
W	Withdrawn
X	No Credit

CourseType

Code	Description
I	Co-Op In School
O	Co-Op Out of School
R	Regular

Disability

Code	Description
nodisability	No, I do not have a disability or impairment
neurological	Yes, I have a neurodevelopmental disorder, intellectual, cognitive, and/or learning disability and/or impairment (e.g., Autism, ADHD, etc.)
physical	Yes, I have a physical disability and/or impairment (e.g., mobility, dexterity, etc.)
sensory	Yes, I have a sensory disability and/or impairment (e.g., deaf, deafened, hard of hearing, vision, etc.)
mental	Yes, I have a mental health illness or disability (e.g., schizophrenia, bipolar, generalized anxiety disorder, depression, etc.)
selfreported	Yes, I have another disability and/or impairment (e.g., chronic medical condition, speech impairment, etc.)
notreported	Prefer not to answer

EthnicGroup

Code	Description
arab	Arab
black	Black (e.g., African, African-Canadian/American, Afro-Caribbean, Afro-Latinx, etc.)
caribbean	Caribbean (e.g., Antiguan, Bahamian, Barbadian, Bermudan, Carib, Cuban Dominican, Grenadian, Guadeloupean, Haitian, Jamaican, Kittitian/Nevisian, Martinican, Montserratian, Puerto Rican, St. Lucian, Trinidadian/Tobagonian, Vincentian/Grenadian, West Indian, etc.)
chinese	Chinese (including Mainland China, Hong Kong, Macau, and Taiwan)
filipinx	Filipino/a/x
indigenousnoncanada	Indigenous outside of Canada (e.g., Nahualt, Maya, Quechua, Aymara, Mapuche, etc.)
indocarribean	Indo-Caribbean, Indo-African, Indo-Fijian
japanese	Japanese
korean	Korean
latinx	Latino/a/x (e.g., Arawak, Argentinian, Belizean, Bolivian, Brazilian, Chilean, Colombian, Costa Rican, Ecuadorian, Guatemalan, Guyanese, Hispanic, Honduran, Maya, Mexican, Nicaraguan, Panamanian, Paraguayan, Peruvian, Salvadorean, Uruguayan, Venezuelan, etc.)
northafrican	North African (e.g., Egyptian, Libyan)
indigenouscanada	North American Indigenous (e.g., First Nations, Inuit, Métis)
oceania	Oceania (e.g., Australian, New Zealander, Pacific Islands)
southasian	South Asian (e.g., Bangladeshi, Pakistani, Indian, Sri Lankan, Punjabi)
southeastasian	Southeast Asian (e.g., Cambodian, Malaysian, Thai, Vietnamese)
westasian	West Asian & Middle East (e.g., Afghani, Armenian, Iranian, Iraqi, Israeli, Jordanian, Lebanese, Palestinian, Syrian, Yemeni)
white	White (e.g., British Isles, French, Western European, Northern European, Eastern European, Southern European, White-Canadian/American/Australian/South African)
multiracial	Multiracial/ethnic (with at least one parent in a non-White group above)
selfreported	I would like to specify an ethno-racial identity not listed above
notreported	Prefer not to answer

EducationCredentialStatus

Code	Description
Completed	The student is no longer attending this institution
InProgress	The student is currently enrolled at this institution

EntryLevelType

Code	Label
01	Level 1
02	Level 2
03	Level 3
04	Level 4
05	Level 5
06	Level 6
07	Level 7
08	Level 8
09	Level 9
10	Level 10
11	Level 11
12	Level 12
20	Advanced Entry
21	Degree Completion

Gender

Code	Description	Former Coltrane Code
female	Female	F
male	Male	M
other	Another Gender Identity	U

GradeType

Code	Description
C	Current
F	Final
M	Midterm
P	Projected
S	Not Available

IndigenousPersonDeclarationType

Code	Description
1100	First Nation + Inuit
1010	First Nation + Métis
1001	First Nation + Other
0110	Inuit + Métis
0101	Inuit + Other
0011	Métis + Other
1110	First Nation + Inuit + Métis
1101	First Nation + Inuit + Other
1011	First Nation + Métis + Other
0111	Inuit + Métis + Other
1111	First Nation + Inuit + Métis + Other
1000	First Nation
0100	Inuit
0010	Métis
0001	Other

IntakeDeliveryOption

Code	Description	Former Coltrane and OCFile Code
fulltime	Full Time	F
parttime	Part Time	P

Language

Code	Description
116	Aboriginal Languages, N.I.E.
85	African Languages, N.I.E.
94	Algonquian Languages, N.I.E.
93	Algonquin
73	Amharic
69	Arabic
19	Armenian
65	Asiatic Languages, N.I.E
102	Athapaskan Languages, N.I.E.
118	Attikamek
64	Austro-Asiatic Languages
83	Bantu Languages, N.I.E.
48	Bengali
89	Blackfoot
27	Bulgarian
26	Byelorussian
97	Carrier
22	Celtic Languages, N.I.E.
98	Chilcotin
60	Chinese
95	Chipewyan
87	Cree
122	Creoles
29	Croatian
32	Czech
113	Dakota/Sioux
6	Danish
120	Dene
99	Dogrib
55	Dravidian Languages, N.I.E.
3	Dutch
1	English
124	English & French
125	English And Non-Official Language(s)
127	English, French And Non-Official Language(s)
79	Estonian
80	Finnish
4	Flemish
2	French
126	French And Non-Official Language(s)
5	Frisian
20	Gaelic Languages
11	German
12	Germanic Languages, N.I.E.
109	Gitksan
18	Greek
42	Gujarati
112	Haida
70	Hebrew
46	Hindi
81	Hungarian
7	Icelandic
50	Indo-Iranian Languages, N.I.E.
117	Inuktitut
104	Iroquoian Languages, N.I.E.
16	Italian
56	Japanese
54	Kannada
63	Khmer (Cambodian)
44	Konkani
57	Korean
38	Kurdish
101	Kutchin-Gwich In (Loucheux)
115	Kutenai
59	Lao
23	Latvian (Lettish)
24	Lithuanian
33	Macedonian
51	Malayalam
66	Malay-Bahasa
68	Malayo-Polynesian
90	Malecite
71	Maltese
43	Marathi
91	Micmac
103	Mohawk
92	Montagnais-Naskapi
84	Niger-Congo Languages, N.I.E.
121	Nishga
110	Nootka
100	North Slave (Hare)
8	Norwegian
76	Not Applicable (Inst. Residents)
88	Ojibway
119	Oji-Cree
123	Other Languages, N.I.E.
49	Pashto
39	Persian (Farsi)
34	Polish
13	Portuguese
40	Punjabi
17	Romance Languages, N.I.E.
15	Romanian
25	Russian
107	Salish Languages, N.I.E.
72	Semitic Languages, N.I.E.
30	Serbian
28	Serbo-Croatian
105	Shuswap
41	Sindhi
45	Sinhalese
61	Sino-Tibetan
37	Slavic Languages, N.I.E.
36	Slovak
31	Slovenian
74	Somali
96	South Slave
14	Spanish
82	Swahili
9	Swedish
67	Tagalog (Pilipino)
52	Tamil
53	Telugu
58	Thai
106	Thompson (Ntlakapamux)
75	Tigringa
114	Tlingit
108	Tsimshian
78	Turkic Languages, N.I.E.
77	Turkish
86	Twi
35	Ukrainian
999	Unknown
47	Urdu
62	Vietnamese
111	Wakashan Languages, N.I.E.
21	Welsh
10	Yiddish

LevelAchievedType

Code	Description	Former Coltrane Code
1year	1 year	1
2year	2 years	2
3year	3 years	3
4year	4 years	4
5year	5 years	5
notavailable	Unknown	0

LevelOfStudyType

Code	Description
GR	Graduate
OT	Corresponding / Continuing / Open
UG	Undergraduate
UN	Unknown

LiteracyTest

Code	Description
B	Both
E	English
F	French
N	Not Reported
X	Not Applicable (N/A)

MilitaryConnection

Code	Description
yes	Yes
no	No
notreported	Prefer not to answer

NamePrefix

Code	Description	Former Coltrane Code
undeclared	Undeclared	0
mr	Mr	1
ms	Ms	2
mrs	Mrs	3
miss	Miss	4

NormingGroup

Code	Description
ANA	Anesthesiologist's Assistant
ANT	Anesthesia Technician
ART	Art Therapist
ATT	Athletic Trainer
AUD	Audiologist
BBT	Blood Bank Technology Specialist
CAT	Cardiovascular Technologist
CLA	Clinical Assistant
CLS	Clinical Laboratory Scientist
CLT	Clinical Laboratory Technician
COM	Cosmetologist
CST	Central Service Technician
CTT	Computerized Tomography Technician
CYO	Cytotechnologist
CYT	Cytogenic Technologist
DDA	Developmental Disabilities Aide
DEA	Dental Assistant
DIE	Dietitian
DIT	Dietetic Technician
DLT	Dental Laboratory Technician
DMS	Diagnostic Molecular Scientist
DMT	Dance/Movement Therapist
DSU	Diagnostic Medical Sonographer/Ultrasound Technician
DTH	Dental Hygienist
ELE	Electroneurodiagnostic Technican
ELT	Electroencephalographic Technician
EMT	Emergency Medical Technician
EXP	Exercise Physiologist
EXS	Exercise Scientist
GET	Geriatric Technician
HHC	Home Health Care Aide
HIA	Health Information Administrator
HIS	Histologic Technician
HIT	Health Information Technician
HST	Histotechnologist
KIN	Kinesiologist
LVT	Low Vision Therapist
MAM	Mammographer
MAT	Massage Therapist
MDO	Medical Dosimetrist
MDT	Movement/Dance Therapist
MEA	Medical Assistant
MEC	Medical Coder
MED	Medical Transcriptionist
MEI	Medical Illustrator
MEL	Medical Librarian
MET	Medical Technologist
MHT	Medical Health Technician
MLT	Medical Laboratory Technician
MOA	Medical Office Assistant
MRI	Magnetic Resonance Imaging Technician
MUT	Music Therapist
NMT	Nuclear Medicine Technologist
NUA	Nurse Assistant
NUP	Nurse Practitioner
NUT	Nutritionist
OCT	Occupational Therapist
ODO	Ophthalmic Dispensing Optician
OMS	Orientation And Mobility Specialist
OMT	Ophthalmic Medical Technician
OPA	Ophthalmic Assistant
ORP	Orthotist/Prosthetist
ORT	Operating Room Technician
OTA	Occupational Therapy Assistant
OTH	Orthoptist
OTT	Orthopedics Technologist
PAA	Pathologist Assistant
PAR	Paramedic
PCT	Patient Care Technician
PER	Perfusionist
PFT	Personal Fitness Trainer
PHA	Physician Assistant
PHL	Phlebotomist
PHT	Physical Therapist
PHY	Pharmacy Technician
POT	Polysomnographic Technologist
PRO	Prosthetist/Orthotist
PST	Psychiatric Technician
PTA	Physical Therapist Assistant
PVN	Practical/Vocational Nurse
RAD	Radiographer
RAT	Radiation Therapist
RDT	Renal Dialysis Technician
REC	Recreation Therapy Technician
REH	Rehabilitation Teacher
REN	Registered Nurse
RET	Respiratory Therapist
RTT	Respiratory Therapy Technician
SAP	Student Affairs Practitioner
SLP	Speech And Language Pathologist
SUA	Surgical Assistant
SUT	Surgical Technologist
TRS	Therapeutic Recreation Specialist
UTD	Ultrasound Technician/Diagnostic Medical Sonographer
VET	Veterinary Technologist
VPN	Vocational/Practical Nurse

OenStatus

Code	Description
00	Not Available
03	No Match
04	Valid

OfferState

Code	Description	Former OCFile Code
Sent	Active: offer active and available for the applicant to select within the rules established for date fields (activation & expiry date).	A
Deleted	Deleted: offer deleted by college (i.e. issued in error) and not available for the applicant to view or select. Offer that has been issued in error and is being withdrawn	D
Revoked	Revoked: valid offer that has been withdrawn by college is visible to applicant but is not available for the applicant to select.	R
Suspended	Program Suspended: offer withdrawn by college due to the program being cancelled. Viewable but not selectable by applicant.	S

PhoneType

Code	Description
home	Home Phone
mobile	Mobile Phone

ProgramChoiceDecision

Code	Description
accepted	Applicant has accepted an offer for this choice
declined	Applicant has declined an offer for this choice
nodecision	Applicant has not received an offer or has not decided on an offer for this choice

ProgramCredentialType

Code	Description	Former Coltrane Code
nocredential	No Credential Received or Unknown	00
certificate	Certificate	02
diploma	Diploma	03
degree	Degree	04
other	Other	96
advanceddiploma	Advanced Diploma	X5
graduatecertificate	Graduate Certificate	X6

ProgramLengthType

Code	Description
unknown	Unknown
weeks	Weeks
months	Months
halfsemester	Half-Semesters
semesters	Semesters
consecutivesemesters	Semesters (Consecutive)
academicyears	Academic Years (Periods Of 8 Months)
years	Years (Periods Of 12 Months)

ProvinceState

Code	Description	Country
AB	Alberta	Canada
BC	British Columbia	Canada
MB	Manitoba	Canada
NB	New Brunswick	Canada
NL	Newfoundland	Canada
NT	Northwest Territories	Canada
NS	Nova Scotia	Canada
NU	Nunavut Territory	Canada
ON	Ontario	Canada
PE	Prince Edward Island	Canada
QC	Quebec	Canada
SK	Saskatchewan	Canada
YT	Yukon Territories	Canada
AL	Alabama	United States
AK	Alaska	United States
AS	America Samoa	United States
AZ	Arizona	United States
AR	Arkansas	United States
CA	California	United States
CO	Colorado	United States
CT	Connecticut	United States
DE	Delaware	United States
DC	District Of Columbia	United States
FL	Florida	United States
GA	Georgia	United States
GU	Guam	United States
HI	Hawaii	United States
ID	Idaho	United States
IL	Illinois	United States
IN	Indiana	United States
IA	Iowa	United States
KS	Kansas	United States
KY	Kentucky	United States
LA	Louisiana	United States
ME	Maine	United States
MD	Maryland	United States
MA	Massachusetts	United States
MI	Michigan	United States
MN	Minnesota	United States
MS	Mississippi	United States
MO	Missouri	United States
MT	Montana	United States
NE	Nebraska	United States
NV	Nevada	United States
NH	New Hampshire	United States
NJ	New Jersey	United States
NM	New Mexico	United States
NY	New York	United States
NC	North Carolina	United States
ND	North Dakota	United States
MP	Northern Mariana Islands	United States
OH	Ohio	United States
OK	Oklahoma	United States
OR	Oregon	United States
PA	Pennsylvania	United States
PR	Puerto Rico	United States
RI	Rhode Island	United States
SC	South Carolina	United States
SD	South Dakota	United States
TN	Tennessee	United States
TX	Texas	United States
UT	Utah	United States
VT	Vermont	United States
VA	Virginia	United States
WA	Washington	United States
WV	West Virginia	United States
WI	Wisconsin	United States
WY	Wyoming	United States

Religion

Code	Description
buddhist	Buddhist
christian	Christian
hindu	Hindu
indigenous	Indigenous
jewish	Jewish
muslim	Muslim
sikh	Sikh
noreligion	No religion
selfreported	Another religion or spiritual self-identity
notreported	Prefer not to answer

SchoolType

Code	Description	Former Coltrane Code
secondary	Secondary School (High School)	S
college	College (Post-Secondary)	P
university	University (Post-Secondary)	P

SecondarySchoolEvaluationType

Code	Description
01	Intermediate Division
02	Senior Division
03	OSSD

SexualOrientation

Code	Description
asexual	Asexual
bisexual	Bisexual
gay	Gay
lesbian	Lesbian
pansexual	Pansexual
queer	Queer
questioning	Questioning
heterosexual	Heterosexual
twospirit	Two-Spirit
selfreported	Another orientation
notreported	Prefer not to answer

ShsmCode

Code	Description
AGC	Agriculture
ART	Arts And Culture
AVA	Aviation and Aerospace
BSN	Business
CSE	Community Safety And Emergency Services
CTR	Construction
ENG	Energy
ENV	Environment
FPR	Food Processing
FRT	Forestry
HCL	Horticulture And Landscaping
HLW	Health And Wellness
HST	Hospitality And Tourism
ICT	Information And Communications Technology
MNF	Manufacturing
MNG	Mining
NPR	Non-Profit
SPT	Sports
TRS	Transportation

SponsorshipAgency

Code	Description
0	No Sponsorship
1	Colleges and Institutes Canada (CICan)
2	Canadian Bureau of International Education (CBIE)
3	Global Affairs Canada
4	Indigenous and Northern Affairs Canada
5	Veterans Affairs Canada
6	Ministry of Children, Community and Social Services
7	Transitions
8	Vocational Rehab
9	Wsib Work Transition Program
10	World University Service of Canada (WUSC)
11	Employment and Social Development Canada (ESDC)
12	Agency Sponsored Second Career
13	Crown Ward
99	Other

SupportingDocumentType

Code	Description	Former Coltrane Code
transcriptcollege	College Transcript	02
transcriptuniversity	University Transcript	03
diplomasecondary	Diploma-Secondary School	05
canadianstatus	Canadian Status Document – Other	08
miscellaneous	Miscellaneous Certificates	09
resume	Resumes	10
certification	Certification	12
lettersofreference	Letters Of Recommendation/Experience	13
driverslicense	Driver’s Licenses	15
evaluationreport	Evaluation Letters	16
academicupgrade	Academic Upgrade Documents	17
studentletter	Student Letters/Copy	18
transcriptunknown	Other Transcript	19
schoolletter	School Letter/Copy	20
proofofenrollment	Proof Of Registration-Academic	23
aviation	Aviation Documents	24
coursedescription	Course Descriptions	25
sponsorship	Sponsorship Document	26
military	Military Documents	27
legal	Legal Documents	28
transcript	Out-of-Province Secondary School Transcript	32
transcriptossofficial	Non Standard Official Ontario Secondary Transcript	33
transcriptossunofficial	Non Standard Unofficial Ontario Secondary Transcript	34
firstaidcertificate	First Aid Certificates	36
cprfirstaid	CPR Certificates	37
recordoflanding	Record of Landing	38
immigrantvisa	Immigrant Visa	39
visitor	Canadian Immigration Record and Visa	40
canadianimmigrationidrecord	Canadian Immigration Identification Record	41
studentauthorization	Student Authorization	42
canadianimmigrationidcard	Canadian Immigration Identification Card	43
canadianpassport	Passport – Canadian	44
canadiancitizenshipcertificate	Certificate of Canadian Citizenship	45
employmentletter	Employment Authorization	46
unevaluatedinternational	Unevaluated Int'L	48
passport	Passport-Int'L	49
diplomapostsecondary	Diploma – Post-Secondary	50
englishproficiencyresults	English Proficiency Results E.G. IELTS	51
postsecondarycertificate	Certificate – Post-Secondary	60
birthcertificate	Int'L Birth Certificate	65
degree	Degree	70
pr	Permanent Resident Card	76
conventionrefugee	Refugee Letter (CIC Canada)	77

TestSubType

TestCode	SubTestCode	Description
ged	01	Writing Skills
ged	02	Social Studies
ged	03	Science
ged	04	Interpreting Literature and Arts
ged	05	Mathematics
gtb	01	Total
hoa	01	Verbal
hoa	02	Arithmetic
hoa	03	Nonverbal
hoa	04	Academic Aptitude
hoa	05	Spelling
hoa	06	Reading Comprehension
hoa	07	Information In The Natural Science
hoa	08	Vocational Adjustment Index
ibt	01	Listening
ibt	02	Reading
ibt	03	Speaking
ibt	04	Test Score
ibt	05	Writing
tfl	01	Section 1
tfl	02	Section 2
tfl	03	Section 3
tfl	04	Total Score
tfl	05	Test Of Written English
tlc	01	Section 1
tlc	02	Section 2
tlc	03	Section 3
tlc	04	Total Score
tlc	05	Test Of Written English

TestType

Code	Description
ged	GED - General Educational Development
hoa	PSB/HOAE Occupations Aptitude Examination
ibt	TOEFL - Test of English as a Foreign Language - Internet
tfl	TOEFL - Test of English as a Foreign Language - Paper
tlc	TOEFL - Test of English as a Foreign Language - Computer