Skip to main content

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 the API Reference [UAT | PROD].

ApplicantType

Code
agentManaged
collegeManaged
directApplicant

ApplicationCycle

Year
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
2026
2027

ApplicationAssessmentStatus

Code
Complete
Incomplete

ApplicationAssessmentTestCodeStatus

Code
Complete
NotComplete
InProgress
NotApplicable

ApplicationEnglishProficiency

Code
Completed
InProgressTest
InProgressStudyProgram
EnrollEnglishPlus
EnrollEnglishOnly
EnglishFirstLanguage
NotApplicable

ApplicationState

Code
Review
Draft
Incomplete
Closed
Resubmitted

BasisOfAdmissionReason

CodeDescription
applicantnotindicatedApplicant has not indicated.
applicantwillnothaveosscApplicant will not have an OSSC by the first day of classes.
applicantwillbesecondaryschoolgraduateunderossApplicant 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.
applicantwillnothaveossdApplicant will not have an OSSD by the first day of classes.
applicantwillbesecondaryschoolgraduateunderosscApplicant 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.
applicantwillbesecondaryschoolgraduateunderosisApplicant 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.

CanadianStatus

Code
none
refugee
study
visa
other (Deprecated)

Country and Province

Download Country and Province CSV

EducationAssessmentIntakeType

Code
Normal
English
ProgramRecommendation

EducationCredentialStatus

Code
Completed
InProgress
NotCompleted

EducationCredentialType

CodeDescription
secondary-diploma
secondary-other
university-degreeUniversity Credential (any) - Blocked from selection in portal going forward
university-master
university-bachelor
university-doctorate
university-universitydegree
university-other
college-diplomaCollege Credential (any) - Blocked from selection in portal going forward
college-other
college-certificate
college-degree
college-finaldiploma
college-graduatecertificate
college-advanceddiploma
english-certificate

EffectiveIntakeAvailabilityStatus

CodeDescription
inheritinherits the status of the intake
closedcloses the intake (overriding the intakes status)
waitlistedwaitlist the intake (overriding the intakes status)
unavailablehides the intake from visibility

EntryLevelType

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

FutureProgramType

Code
none
all
some

Gender

Code
male
female
other

GradeSourceType

CodeDescription
studentregistrationStudent Registration.
studentacademichistoryStudent Academic History.
otherOther.
notdefinedNot Defined.

IntakeAvailabilityStatus

Code
open
closed
waitlisted

IntakeDeliveryOption

Code
fulltime
parttime

IntakeDeliveryType

Code
hybrid
inperson
online

IntakeLengthType

Code
academicyears
consecutivesemesters
halfsemester
months
semesters
unknown
weeks
years
yearsonly

InternationalProgramType

Code
Normal
Esl
Eap

InternshipType

Code
required
optional
notavailable
unpaidplacement
requiredinternship
industryplacement
fieldplacement

Languages

Iso6392_1PsisCodeIso6392_2LanguageActiveHide
ab999abkAbkhazian10
aa999aarAfar10
af999afrAfrikaans10
ak999akaAkan10
sq999sqiAlbanian10
am73amhAmharic10
ar69araArabic10
an999argAragonese10
hy19hyeArmenian10
as999asmAssamese10
av999avaAvaric10
ae999aveAvestan10
ay999aymAymara10
az999azeAzerbaijani10
bm999bamBambara10
ba999bakBashkir10
eu999eusBasque10
be26belBelarusian10
bn48benBengali10
bh999berBihari languages10
bi999bisBislama10
nb999nobBokm†l10
bs999bosBosnian10
br999breBreton10
bg27bulBulgarian10
my999myaBurmese10
ca999catCatalan; Valencian10
km63khmCentral Khmer10
ch999chaChamorro10
ce999cheChechen10
ny999nyaChichewa; Chewa; Nyanja10
zh60zhoChinese10
cu999chuChurch Slavic; Old Slavonic; Church Slavonic; Old Bulgarian; Old Church Slavonic10
cv999chvChuvash10
kw999corCornish10
co999cosCorsican10
cr87creCree10
hr29hrvCroatian10
cs32cesCzech10
da6danDanish10
dv999divDivehi; Dhivehi; Maldivian10
nl3nldDutch; Flemish10
dz999dzoDzongkha10
en1engEnglish10
eo999epoEsperanto10
et79estEstonian10
ee999eweEwe10
fo999faoFaroese10
fj999fijFijian10
fl999filFilipino10
fi80finFinnish10
fr2fraFrench10
ff999fulFulah10
gd20glaGaelic; Scottish Gaelic10
gl999glgGalician10
lg999lugGanda10
ka999katGeorgian10
de11deuGerman10
el18ellGreek10
gn999grnGuarani10
gu42gujGujarati10
ht999hatHaitian; Haitian Creole10
ha999hauHausa10
he70hebHebrew10
hz999herHerero10
hi46hinHindi10
ho999hmoHiri Motu10
hu81hunHungarian10
is7islIcelandic10
io999idoIdo10
ig999iboIgbo10
id999indIndonesian10
ia999inaInterlingua (International Auxiliary Language Association)10
ie999ileInterlingue; Occidental10
iu117ikuInuktitut10
ik999ipkInupiaq10
ga999gleIrish10
it16itaItalian10
ja56jpnJapanese10
jv999javJavanese10
kl999kalKalaallisut; Greenlandic10
kn54kanKannada10
kr999kauKanuri10
ks999kasKashmiri10
kk999kazKazakh10
ki999kikKikuyu; Gikuyu10
rw999kinKinyarwanda10
ky999kirKirghiz; Kyrgyz10
kv999komKomi10
kg999konKongo10
ko57korKorean10
kj999kuaKuanyama; Kwanyama10
ku38kurKurdish10
lo59laoLao10
la999latLatin10
lv23lavLatvian10
li999limLimburgan; Limburger; Limburgish10
ln999linLingala10
lt24litLithuanian10
lu999lubLuba-Katanga10
lb999ltzLuxembourgish; Letzeburgesch10
mk33mkdMacedonian10
mg999mlgMalagasy10
ms66msaMalay10
ml51malMalayalam10
mt71mltMaltese10
gv999glvManx10
mi999mriMaori10
mr43marMarathi10
mh999mahMarshallese10
mn999monMongolian10
na999nauNauru10
nv999navNavajo; Navaho10
nd999ndeNdebele10
nr999nblNdebele10
ng999ndoNdonga10
ne999nepNepali10
se999smeNorthern Sami10
no8norNorwegian10
nn999nnoNorwegian Nynorsk; Nynorsk10
oc999ociOccitan (post 1500); Proven‡al10
oj88ojiOjibwa10
or999oriOriya10
om999ormOromo10
os999ossOssetian; Ossetic10
pi999pliPali10
pa40panPanjabi; Punjabi10
fa39fasPersian10
pl34polPolish10
pt13porPortuguese10
ps49pusPushto; Pashto10
qu999queQuechua10
ro15ronRomanian; Moldavian; Moldovan10
rm999rohRomansh10
rn999runRundi10
ru25rusRussian10
sm999smoSamoan10
sg999sagSango10
sa999sanSanskrit10
sc999srdSardinian10
sr30srpSerbian10
sn999snaShona10
ii999iiiSichuan Yi; Nuosu10
sd41sndSindhi10
si45sinSinhala; Sinhalese10
sk36slkSlovak10
sl31slvSlovenian10
so74somSomali10
st999sotSotho10
es14spaSpanish; Castilian10
su999sunSundanese10
sw82swaSwahili10
ss999sswSwati10
sv9sweSwedish10
tl67tglTagalog10
ty999tahTahitian10
tg999tgkTajik10
ta52tamTamil10
tt999tatTatar10
te53telTelugu10
th58thaThai10
bo61bodTibetan10
ti75tirTigrinya10
to999tonTonga (Tonga Islands)10
ts999tsoTsonga10
tn999tsnTswana10
tr77turTurkish10
tk999tukTurkmen10
tw86twiTwi10
ug999uigUighur; Uyghur10
uk35ukrUkrainian10
ur47urdUrdu10
uz999uzbUzbek10
ve999venVenda10
vi62vieVietnamese10
vo999volVolapk10
wa999wlnWalloon10
cy21cymWelsh10
fy5fryWestern Frisian10
wo999wolWolof10
xh999xhoXhosa10
yi10yidYiddish10
yo999yorYoruba10
za999zhaZhuang; Chuang10
zu999zulZulu10

LevelAchievedType

Code
1year
2years
3years
4years
5years
notavailable

LevelOfCompletenessCollegeType

Code
notavailable
1yearincomplete
2yearsincomplete
3yearsincomplete
4yearsincomplete
5yearsormoreincomplete
2yeardiploma
3yeardiploma
1yearinprogress
2yearsinprogress
3yearsinprogress
4yearsinprogress
5yearsormoreinprogress
1yearofstudy
2yearsofstudy
3yearsofstudy
4yearsofstudy
5ormoreyearsofstudy
applieddegree
inprogress

LevelOfCompletenessPostDegreePostDiplomaType

Code
notavailable
1yearpostdiploma
2yearpostdiploma
3yearpostdiploma
4yearpostdiploma
5yearpostdiploma
1yearpostdegree
2yearpostdegree
3yearpostdegree
4yearpostdegree
5yearpostdegree

LevelOfCompletenessPostSecondaryUniversityType

Code
notavailable
1yearincomplete
2yearsincomplete
3yearsincomplete
4yearsincomplete
5yearsormoreincomplete
3yeardegree
4yeardegree
mastersdegree
doctoratephddegree
otherdegree
1yearinprogress
2yearsinprogress
3yearsinprogress
4yearsinprogress
5yearsormoreinprogress
1yearofstudy
2yearsofstudy
3yearsofstudy
4yearsofstudy
5ormoreyearsofstudy
inprogress

LevelOfCompletenessSecondaryType

CodeDescription
notavailableNot Available.
intermediatedivisionIntermediate Division.
seniordivisionSenior Division.
ossdOSSD.

LevelOfStudyType

Code
apprenticeship
collaborative
degree
postDiploma
postSecondary
unknown

NamePrefix

Code
mr
mrs
ms
miss
dr
mx

NameSuffix

Code
jr
sr
i
ii
iii
iv
v
vi
vii
viii
ix
x

OfferConditionType

Code
engproficiency
providehighschooltranscript
provideuniversitytranscript
eapcomplete
eslcomplete
escpathway
highschoolcomplete
collegeprogramcomplete
universitycomplete
resume
portfolio
ieltstestresultform
affidavit
provisionalorofficialgraduationcertificate
studypermitorirccletter
other

OfferDeclineReasons

Code
accepted-offer-of-another-institution-in-another-country
accepted-offer-of-another-canadian-institution
financial-problem
family-problem
pgwp-eligibility
other

OfferDeferralState

Code
Request
Approved
Denied
InProgress

OfferRefundState

Code
Request
Approved
Denied
InProgress

OfferRevokeType

Code
campuschange
deadline
intakenotavailable
intakesuspended
nopayment
noshow
noseats
novisa
pgwpeligibility
programchange
programpurge
visadelayed
transfer
other

OfferState

Code
PreAdmitted
PreAdmitAccepted
Sent
Accepted
Paid
PreRegistered
Withdrawn
Revoked
Declined
RefundRequested
DeferralRequested

PhoneType

Code
home
mobile
other

ProgramCategoryType

Code
agricultureAnimalRelatedPractices
artsCulture
businessFinanceAdministration
careerPreparation
computersTelecommunications
culinaryHospitalityRecreationTourism
educationCommunitySocialServices
energyEnvironmentalNaturalResources
engineeringTechnology
fireJusticeSecurity
healthFoodMedical
media
professionsTrades
transportationLogistics

ProgramCredentialType

Code
advanceddiploma
certificate
degree
diploma
graduatecertificate
other
programcertificate
universitybacheloreducation
universitycertificate
universitydiploma
universitygraduatedegree
universityundergraduatedegree

ProgramDecisionState

Code
Declined
None
Offer
PreAdmitted
Waitlisted

ProgramDeclineReason

CodeDescription
admissionrequirementDoes not Meet Admissions Requirements
alternateofferAlternate Offer Issued for Another Program
alternatedecisionDecision made on Another Program Selection
cleanupAdministrative Purge/End of Cycle Clean-up
intakefullProgram Full, Unable to process further applications
programsuspendedProgram Suspended
programcancelledProgram Cancelled
otherstring (min 1, max 100)

ProgramLengthType

Code
consecutivesemesters
yearsonly
semesters
months
academicyears
years
halfsemester
unknown
weeks

ProgramMajor

Description
Anthropology
Ancient Studies
Biology
Child and Family Studies
Classical Studies
Computer Science
Corrections
Criminal Justice Studies
Criminology
Data Science
Economics
English Studies
Environment and Physical Geography
Environmental Biology and Technology
Environmental Geography
Gender Equality and Social Justice
Geography
History
Indigenous Studies
Indigenous Studies (double major only)
Legal Studies and Administration
Mathematics
Philosophy
Policing
Political Science
Psychology
Religions and Culture
Social Welfare and Social Development
Sociology
Undeclared

ProgramMasterType

Code
research-paper
thesis-based

ProgramRecommendationReason

Code
deferral-request
alternate-offer
other
future-program-consideration

ProgramTeachingSubject

Description
Business Studies - General
English
First Nations, Metis and Inuit Studies
French as a Second Language
Geography
Health and Physical Education
History
Indigenous Languages: Anishnaabemwin
Mathematics
Music - Instrumental
Science - Biology
Science - Chemistry
Science - General
Science - Physics
Social Sciences - General
Visual Arts

ReceiptType

Code
Deposit
Tuition

RuleApplicableTo

Code
only
allexcept

SchoolType

Code
secondary
college
university
english

ScreeningStatus

Code
NotScreened
InitialScreeningComplete *
SecondaryScreeningComplete *
ThirdScreeningComplete *
FourthScreeningComplete *
Screened
ScreeningFailed

Note: InitialScreeningComplete, SecondaryScreeningComplete, ThirdScreeningComplete and FourthScreeningComplete are only available when the multiLevelScreening feature is turned on for your college. Screened (date) is only supplied when ScreeningStatus == Screened

SupportingDocumentType

CategoryCode
credential-collegearticulationapproval
credential-collegediploma
credential-collegeintlcredentialassessment
credential-collegeproofofenglishasmediumofinstruction
credential-collegeproofofenrollment
credential-collegeprovisionalcertificate
credential-collegetranscript
credential-collegeworldeducationservice
credential-englishenglishcertificate
credential-englishenglishfinaltranscript
credential-englishenglishletterofenrollment
credential-secondaryadvancedcertificatesecondaryeducation
credential-secondaryarticulationapproval
credential-secondarycaribbeanadvancedproficiencyexamination
credential-secondarycaribbeanexaminationcouncil
credential-secondarycertificatematurityexamination
credential-secondarycertificatesecondaryeducation
credential-secondarydiploma
credential-secondarygcsecertificate
credential-secondaryhighschoolgraduatecertificateandtranscript
credential-secondaryincompletetranscript
credential-secondaryinternationalbaccalaureate
credential-secondaryintlcredentialassessment
credential-secondarymaturitycertificate
credential-secondarynationalexaminationcertificate
credential-secondarynationaluniversityentranceexamination
credential-secondarynecoexamcertificate
credential-secondarynecoscratchcardinfo
credential-secondaryproofofenglishasmediumofinstruction
credential-secondarysecondaryeducationexamination
credential-secondarysecondaryhigherschoolmarksheet
credential-secondarysecondaryschoolleavingcertificate
credential-secondarysecondaryschoolmarksheet
credential-secondaryseniorexamcertificate
credential-secondarytranscript
credential-secondaryworldeducationservice
credential-universityarticulationapproval
credential-universitydegree
credential-universityintlcredentialassessment
credential-universityproofofenglishasmediumofinstruction
credential-universityprovisionalcertificate
credential-universitytranscript
credential-universityworldeducationservice
identificationbirthcertificate
identificationcitizenshippapers
identificationconventionrefugee
identificationmarriagecertificate
identificationpassport
identificationpr
otheraccessibilitydocuments
otheranalysisofsocialissue
otherchildstudiespathway
othercoursesummaryform
othercprfirstaid
otherdepositproof
otheremploymentletter
otherequitydeclaration
otherfrenchproficiency
otherimmunization
otherlettersofreference
otherlocationranking
othernursingregistration
otherpolicecheck
otherportfolio
otherpreclearancehealth
otherproofmastersthesis
otherresume
othersamplewrittenwork
otherstatementintent
otherstatementinterest
proficiencytestresults
visaapprovalinprinciple
visaapprovalletter
visacoopworkpermit
visacustodianshipdeclarationform
visaforeignworkerworkpermit
visaprovincialattestationletter
visastudypermit
visavisitor

[Note:] depositproof (Deposit proof of payment) now is linked to the offer so an OfferUpdated event is generated and it will be included in your OfferDetails [UAT | PROD] model.

TermCode

Each application cycle will have the following 3 codes corresponding to to each year. A code + year combo gives us a unique way to represent the time an intake is being offered.

Code
fall
winter
spring

TestSubType

Code
listening
reading
writing
speaking

TestType

Code
cael
cambridge
cefr
duolingo
eap
eps
ielts
itep
melab
met
plte
toefl
other

WithdrawType

Code
academicSuspensionCancelled
acceptedAnotherOffer
campusChangeRequest
financial
health
languageDifficulty
notabletomeetconditionsofOffer
pgwpeligibility
programChangeRequest
transfer
visadeclined
visadelayed
other