Coltrane Reference

The following information is provided to help ease the transition from Coltrane to the Domestic on Demand API.

Event Mapping

Events types in Domestic on Demand and their older Coltrane code.

Event Type	Coltrane Tx
ApplicationSubmitted	ACI
ApplicationWithdrawn	ACW
ApplicationPending	ACN
ApplicationResubmitted	ACR or ACP
ApplicationUpdated	ACU
ApplicantProfileUpdated	ACU
ApplicantDeceased	ACX
OntarioAcademicDataAdded, InternationalAcademicDataAdded	ACU
OntarioAcademicDataDeleted, InternationalAcademicDataDeleted	ACU
OntarioAcademicDataUpdated, InternationalAcademicDataUpdated	ACU
ProgramChoiceAdded	CCI
ProgramChoiceDeleted	CCD
ProgramChoiceUpdated	CCU
OfferAccepted	CCY
OfferDeclined	CCN
EducationAdded	ECI
EducationUpdated	ECU
EducationDeleted	ECD
SupportingDocumentAdded	SCI
SupportingDocumentUpdated	SCU
SupportingDocumentDeleted	SCD
ApplicantProficiencyAdded, ApplicantProficiencySubScoreAdded	TCI
ApplicantProficiencyUpdated, ApplicantProficiencySubScoreUpdated	TCU
ApplicantProficiencyDeleted, ApplicantProficiencySubScoreDeleted	TCD
ApplicantCredentialAdded, CourseAdded	GCI
ApplicantCredentialUpdated, CourseUpdated	GCU
ApplicantCredentialDeleted, CourseDeleted	GCD
ApplicantCredentialAdded, CourseAdded	ICI
ApplicantCredentialUpdated, CourseUpdated	ICU
ApplicantCredentialDeleted, CourseDeleted	ICD
None	NC*

Mapping of Coltrane Transaction Records

The following tables can be used for reference to understand where certain types of data from the XML Coltrane file can be found in the Domestic on Demand models.

AC Transaction Element Mapping

\Application\ApplicantIdentitification

Coltrane XML Element	Domestic on Demand Model	Attribute	Comments
ApplicationNumber	application	number
AccountNumber	application.applicant	number

\Application\Applicant\ApplicationInformation

Coltrane XML Element	Domestic on Demand Model	Attribute	Comments
DateApplicationReceived	application	submitted
BasisOfAdmission	application	basisOfAdmissionCode	Note new lookup values
CurrentStudent	application	currentStudent
MethodOfApplication	-	-	Deprecated
GradeStatus	-	-	Deprecated

\Application\Applicant\Demographic

Coltrane XML Element	Domestic on Demand Model	Attribute	Comments
Title	application.applicant.legalName	prefix	Note new lookup values
FirstName	application.applicant.legalName	firstName
LastName	application.applicant.legalName	lastName
SecondName	application.applicant.legalName	middleNames	join array of strings in order to put in single field
PreviousLastName	application.applicant.formerNames	lastName	select first item in array of ApplicantNames
PreferredName	application.applicant.casualNames	firstName	select first item in array of ApplicantNames
Gender	application.applicant	gender	Note new lookup values
BirthDate	application.applicant	dateOfBirth
StatusInCanada	application.applicant	canadianStatus
CountryOfCitizen	application.applicant	primaryCitizenshipCountry
CountryOfBirth	application.applicant	countryOfBirth
AboriginalPersonIndicator	application.applicant	indigenousPersonIndicator	Note new type
Aboriginal	application.applicant	indigenousPersonDeclaration
AboriginalPersonStatus	application.applicant	indigenousPersonDescription
MotherTongue	application.applicant	primaryLanguage
LanguageOfCorrespondence	application.applicant	languageOfCorrespondence
SponsorAgency	application.applicant	sponsorAgency
FirstGeneration	application.applicant	firstGeneration	Note new type

\Application\Applicant\Address

Coltrane XML Element	Domestic on Demand Model	Attribute	Comments
AddressStreet	application.applicant.mailingAddress	street
City	application.applicant.mailingAddress	city
ProvinceState	application.applicant.mailingAddress	province
CountryCode	application.applicant.mailingAddress	country
CountryName	application.applicant.mailingAddress	-	Deprecated
PostalCode	application.applicant.mailingAddress	postalCode

\Application\Applicant\Email

Coltrane XML Element	Domestic on Demand Model	Attribute	Comments
EmailAddress	application.applicant	emailAddress

\Application\Applicant\Phones

Coltrane XML Element	Domestic on Demand Model	Attribute	Comments
PrimaryPhone\Phone	application.applicant.phones	number	Use "type" to distinguish between home and mobile phones
PrimaryPhone\AreaCode	-	-	Area code is now joined with number
CellPhone\Phone	application.applicant.phones	number	Use "type" to distinguish between home and mobile phones
CellPhone\AreaCode	-	-	Area code is now joined with number

\Application\Applicant\OntarioAcademicData

Coltrane XML Element	Domestic on Demand Model	Attribute	Comments
OEN	application.applicant.ontarioAcademicData	oen
OENValid	application.applicant.ontarioAcademicData	oenValid
OENValidDate	application.applicant.ontarioAcademicData	oenValidDate
MidentCode	application.applicant.ontarioAcademicData	midentCode
OSSDToBeAchieved	application.applicant.ontarioAcademicData	ossdToBeAchieved
OSSDIssueDate	application.applicant.ontarioAcademicData	ossdIssueDate
CommunityInvolvement	application.applicant.ontarioAcademicData	communityInvolvement
SSLiteracyTest	application.applicant.ontarioAcademicData	ssLiteracyTest
OSSCToBeAchieved	application.applicant.ontarioAcademicData	osscToBeAchieved
OSSCIssueDate	application.applicant.ontarioAcademicData	osscIssueDate
SHSMCode	application.applicant.ontarioAcademicData	shsmCode
GEDCompletionDate	application.applicant.ontarioAcademicData	gedCompletionDate

\Application\Applicant\InternationalAcademicData

Coltrane XML Element	Domestic on Demand Model	Attribute	Comments
SecondarySchoolEvaluation	application.applicant.internationalAcademicData	secondarySchoolEvaluation
EvaluationGraduationDate	application.applicant.internationalAcademicData	evaluationGraduationDate

CC Transaction Element Mapping

\Application\ProgramChoice

Coltrane XML Element	Domestic on Demand Model	Attribute	Comments
Program	application.programChoices	programCode
CampusCode	application.programChoices	campusCode
Semester	application.programChoices	semester
ChoiceNumber	application.programChoices	choiceNumber
FullPartTime	application.programChoices	delivery	Note new lookup values
StartDate	application.programChoices	startDate
DateDecisionReceived	application.programChoices	dateDecisionReceived	Only populated when an offer has been accepted.  New field "effectiveDate" will contain the date the program choice was added to the application.
PreviousAttendedYear	application.programChoices	previousAttendedYear
PreviousAppliedYear	application.programChoices	previousAppliedYear

The following fields were not present in the Coltrane model and have been added to the Domestic on Demand model

Domestic on Demand Model	Attribute
application.programChoices	effectiveDate
application.programChoices	intakeId
application.programChoices	intakeSisIdentifier
application.programChoices	offerId
application.programChoices	offerSisIdentifier
application.programChoices	decision

EC Transaction Element Mapping

\Application\Credentials\SelfDeclaredEducation

Coltrane XML Element	Domestic on Demand Model	Attribute	Comments
InstitutionCode	application.applicant.educationDeclarations	schoolCode
InstitutionName	application.applicant.educationDeclarations	schoolName
City	application.applicant.educationDeclarations	city
ProvinceState	application.applicant.educationDeclarations	province
CountryCode	application.applicant.educationDeclarations	country
StartDate	application.applicant.educationDeclarations	startDate
EndDate	application.applicant.educationDeclarations	completionDate
ProgramName	application.applicant.educationDeclarations	programName
LevelAchieved	application.applicant.educationDeclarations	levelAchieved	Note new lookup values
CredentialCode	application.applicant.educationDeclarations	credentialCode	Note new lookup values
LegalFirstName	application.applicant.educationDeclarations	attendanceFirstName
LegalLastName	application.applicant.educationDeclarations	attendanceLastName
EducationSequenceNumber	-	-	Deprecated

The following fields were not present in the Coltrane model and have been added to the Domestic on Demand model

Domestic on Demand Model	Attribute
application.applicant.educationDeclarations	credentialDescription
application.applicant.educationDeclarations	levelOfStudy
application.applicant.educationDeclarations	lastGradeCompleted

SC Transaction Element Mapping

\Application\Credentials\SupportingDocuments

Coltrane XML Element	Domestic on Demand Model	Attribute	Comments
DocumentCode	application.applicant.supportingDocuments	type	Note new lookup values
KeyDate	application.applicant.supportingDocuments	dateReceived
OriginalCopy	application.applicant.supportingDocuments	original
OfficialNonOfficial	application.applicant.supportingDocuments	official
IssuingAgency	application.applicant.supportingDocuments	issuingAgencyCode
ExpiryDate	application.applicant.supportingDocuments	expiryDate
Level	application.applicant.supportingDocuments	level
DocumentNumber	application.applicant.supportingDocuments	documentNumber
IssueDate	application.applicant.supportingDocuments	issueDate
DriverLicenceClass	application.applicant.supportingDocuments	driversLicenseClass
DriverLicenceTemporaryOrPermanent	application.applicant.supportingDocuments	driversLicenseTemporary
InstitutionCode	application.applicant.supportingDocuments	schoolCode
InstitutionName	application.applicant.supportingDocuments	schoolName
InstitutionTypeCode	application.applicant.supportingDocuments	schoolType	Note new lookup values
CountryCode	application.applicant.supportingDocuments	country
ProvinceState	application.applicant.supportingDocuments	province
GraduationDate	application.applicant.supportingDocuments	graduationDate
DocumentStatus	-	-	Deprecated
InstitutionAccreditation	-	-	Deprecated
InstitutionSequenceNumber	-	-	Deprecated
ProgramName	-	-	Deprecated
LevelAchieved	-	-	Deprecated
CredentialCode	-	-	Deprecated
ImmigrationLandingDate	-	-	Deprecated
ImmigrationLandingSignature	-	-	Deprecated
DocumentLink	-	-	Deprecated

The following fields were not present in the Coltrane model and have been added to the Domestic on Demand model

Domestic on Demand Model	Attribute
application.applicant.supportingDocuments	city
application.applicant.supportingDocuments	fileName
application.applicant.supportingDocuments	mimeType

GC Transaction Element Mapping

\Application\Credentials\OntarioHighSchoolGrades

Coltrane XML Element	Domestic on Demand Model	Attribute	Comments
CourseCode	application.applicant.credentials.courses	courseCode
CreditValue	application.applicant.credentials.courses	creditValue
CompletionDate	application.applicant.credentials.courses	completionDate
Grade	application.applicant.credentials.courses	grade
GradeType	application.applicant.credentials.courses	gradeType
CourseDelivery	application.applicant.credentials.courses	courseDelivery
CourseType	application.applicant.credentials.courses	courseType
CourseStatus	application.applicant.credentials.courses	courseStatus
MidentCode	application.applicant.credentials.courses	midentCode
Note\NoteType	application.applicant.credentials.courses	notes
EditException	-	-	Deprecated
CourseSource	-	-	Deprecated

IC Transaction Element Mapping

\Application\Credentials\InternationalGrades

Coltrane XML Element	Domestic on Demand Model	Attribute	Comments
CourseCode	application.applicant.credentials.courses	courseCode	International grades distinguished by identifying institution in parent credential
CreditValue	application.applicant.credentials.courses	creditValue	International grades distinguished by identifying institution in parent credential
CompletionDate	application.applicant.credentials.courses	completionDate	International grades distinguished by identifying institution in parent credential
Grade	application.applicant.credentials.courses	grade	International grades distinguished by identifying institution in parent credential

TC Transaction Element Mapping

\Application\Credentials\CredentialTestScores

Coltrane XML Element	Domestic on Demand Model	Attribute	Comments
TestCode	application.applicant.proficiencies	type
TestDate	application.applicant.proficiencies	completionDate
NormingGroup	application.applicant.proficiencies	normingGroup
SubTestCode	application.applicant.proficiencies.subScores	type
NumberCorrect	application.applicant.proficiencies.subScores	score
Percentile	application.applicant.proficiencies.subScores	percentile
NumberOfItems	-	-	Deprecated
GradeEquivalent	-	-	Deprecated
StanineCode	-	-	Deprecated
TestCentreCode	-	-	Deprecated
TestCentre	-	-	Deprecated

The following fields were not present in the Coltrane model and have been added to the Domestic on Demand model

Domestic on Demand Model	Attribute
application.applicant.proficiencies	city
application.applicant.proficiencies	province
application.applicant.proficiencies	country

Applicant Experience and Data Exchange Scenarios

The following two timelines describe the impact to applicant experience and the timing of various data exchange in Coltrane and Domestic on Demand.

Coltrane Only Experience

Coltrane and DoD Hybrid Experience