Skip to main content
Liaison

Application Data Mapping in Slate Source Formats

Before you can begin mapping the data from the application to Slate, you'll need to import the standard Source Formats for CAS application data and documents from the Library. For more information, see below and visit the Materials Source Format and Application Source Format sections of the Slate Knowledge Base.

Unique identifiers for matching

Create three new fields and set them as "unique for merging". These should already exist in your Slate instance upon importing the standard Source Formats for CAS application data and documents. The standard Source Formats map CAS IDs into these fields to ensure proper person- and application-scoped matching for incoming CAS application data and documents.

  • Person scope: "CAS/Liaison Person ID"
  • Application scope: "CAS/Liaison Application ID"
  • School scope: "CAS/Liaison School ID"

Program Information

The values set in the CAS program properties when configuring your CAS programs are valuable for properly coding incoming applications to the right major, degree, start term, delivery, and more. Different schools use these CAS program properties in different ways, making it impossible to pre-map most of these properties. You'll most certainly want to review the program properties available against your CAS program configuration strategy to determine which properties to map.

You can find the CAS program properties when remapping your Source Format by entering the following search term: "progMate.progSele0.". The section below lists the most commonly mapped of these program properties.

CAS Custom Questions Specific to Your Programs

If you've configured custom questions to ask applicants to your CAS programs, you'll need to map those. There's such a great variety of custom questions asked that it isn't possible to pre-map these questions for import into Slate. By default, the CAS custom questions will have headers containing the ID of the custom question itself. One of the values delivered is the question text itself, so you can use that to determine which ID goes with which question.

You can find the custom questions when remapping your Source Format by entering the following search term:
"progMate.progSele0.custQues"

  • Generally, you'll want to map the "answerText" column, as that will contain the applicant's response.
  • Alternatively, you may want to map the "exportCode" column. You should only map this field if you've configured Export Codes for your custom questions in CAS. When configuring custom questions in your CAS programs, certain question types (multiple choice, drop down) present the option to define Export Codes for the response options you make available for applicants to select. These Export Codes are a useful tool for making value mappings easier. For example, if you asked a question, "What's your t-shirt size?", you might have 3 response options with the associated Export Codes: "Small" - "S", "Medium" - "M", "Large" - "L".
Internal Question Labels

With the Internal Question Label feature, you can define a short, easy-to-understand, and sticky label to any custom questions you create in the Program Materials (Fourth Quadrant) section. As you create custom questions in the Configuration Portal, you'll have the option to add an Internal Question Label. Whatever value you type into that field will be delivered as the column header in the file delivered by the CAS API to Slate. For example, if a custom question asks, "What is your favorite color?", you could assign an Internal Question Label of "favorite_color", and applicants' responses to that question would be delivered to Slate by the CAS API with "favorite_color" as the column header. This field is optional, so only add labels to those fields you plan to load into Slate.

When creating Internal Question Labels, consider the following:

  • Keep the Internal Question Label short: Slate limits headers to 60 characters.
  • Make sure the Internal Question Label is descriptive: other people should have a good idea of what information it contains, so avoid acronyms and abbreviations.

A powerful feature of the Internal Question Label is that it sticks with a custom question across environments (from prelaunch to production) and cycles (from a past cycle to a future cycle). That means that you can define Internal Question Labels in the prelaunch environment, configure your Slate Source Format mappings, test your integration, and confidently turn it on in the production environment with no additional mapping work required. Furthermore, when cycle rollover time comes along, if you keep your questions the same, you won't need to do any new mapping work to accommodate the new cycle's application data because the questions will continue to be delivered with the same Internal Question Label.
 
Export Codes, if defined, will be delivered in a column with the word "_code" appended to the header. For example, if a question has the internal question label "favorite_color", the Export Code would be delivered in a column with the header "favorite_color_code". You can choose whether to map the Export Code or the answer text.

Commonly Used Fields

There are some commonly used fields that are used differently across institutions. Because of the variety of uses, it isn't possible to pre-map these fields. It will be necessary for you to map any of these fields that you want to load to Slate.

Program Details

Field

Description

progMate.progSele.name

Name of the program applied to.

progMate.progSele.startTerm

Entry term for the program applied to (e.g. "Fall".)

progMate.progSele.academicYear

Start year for program applied to.

progMate.progSele.submissionStatus

 

 

Submission status for the application. Possible values:

  • "In Progress" = started
  • "Received" = submitted
  • "Complete" = all requirements met

progMate.progSele.createdDate

Date when the applicant first started the application to the program.

progMate.progSele.submittedDate

Date when the application was submitted: applicant clicks Submit and pays the fee.

progMate.progSele.completionDate

Date when the application became complete: all requirements received (including transcripts, letters of recommendation, etc.)

progMate.progSele.programId

ID for the program applied to.

 Additional Visa and US Residency Information

You can find Additional Visa and US Residency information when remapping your source format in the following fields:

Field

Description

persInfo.citiInfo.citiDeta.citizenshipStatus

The citizenship Status

persInfo.citiInfo.citiDeta.countryOfCitizenshipISOCode2

The country Of Citizenship ISO Code2

persInfo.citiInfo.citiDeta.otherCountryOfCitizenshipISOCode2

The other Country Of Citizenship ISO Code2

persInfo.citiInfo.visaInfo.visaType

The visa Type

persInfo.citiInfo.visaInfo.issueCountry

The issue Country

persInfo.citiInfo.resiInfo.state

The residence state name

persInfo.citiInfo.resiInfo.lengthOfStay

The length Of Stay

persInfo.citiInfo.resiInfo.lengthOfStayInUS

The length Of Stay US

Race / Ethnicity

Field Name

Description

persInfo.raceAndEthn.race.isAmericanIndian

A flag that indicates if the applicant is American Indian

persInfo.raceAndEthn.race.americanIndianTribeName

The American Indian Tribe Name

persInfo.raceAndEthn.race.isAsian

A flag that indicates if the applicant is Asian

persInfo.raceAndEthn.race.isAsianIndian

A flag that indicates if the applicant is Asian Indian

persInfo.raceAndEthn.race.isCambodian

A flag that indicates if the applicant is Cambodian

persInfo.raceAndEthn.race.isChinese

A flag that indicates if the applicant is Chinese

persInfo.raceAndEthn.race.isFilipino

A flag that indicates if the applicant is Filipino

persInfo.raceAndEthn.race.isJapanese

A flag that indicates if the applicant is Japanese

persInfo.raceAndEthn.race.isKorean

A flag that indicates if the applicant is Korean

persInfo.raceAndEthn.race.isMalaysian

A flag that indicates if the applicant is Malaysian

persInfo.raceAndEthn.race.isPakistani

A flag that indicates if the applicant is Pakistani

persInfo.raceAndEthn.race.isVietnamese

A flag that indicates if the applicant is Vietnamese

persInfo.raceAndEthn.race.otherAsian

A flag that indicates if the applicant is other Asian

persInfo.raceAndEthn.race.isAfricanAmerican

A flag that indicates if the applicant is African American

persInfo.raceAndEthn.race.isPacificIslander

A flag that indicates if the applicant is Pacific Islander

persInfo.raceAndEthn.race.isGuamanian

A flag that indicates if the applicant is Guamanian

persInfo.raceAndEthn.race.isHawaiian

A flag that indicates if the applicant is Hawaiian

persInfo.raceAndEthn.race.isSamoan

A flag that indicates if the applicant is Samoan

persInfo.raceAndEthn.race.isOtherPacificIslander

A flag that indicates if the applicant is Other Pacific Islander

persInfo.raceAndEthn.race.isWhite

A flag that indicates if the applicant is White

persInfo.raceAndEthn.ethn.hispanicLatino

A flag that indicates if the applicant is Hispanic Latino

persInfo.raceAndEthn.ethn.isCuban

A flag that indicates if the applicant is Cuban

persInfo.raceAndEthn.ethn.isMexican

A flag that indicates if the applicant is Mexican

persInfo.raceAndEthn.ethn.isPuertoRican

A flag that indicates if the applicant is Puerto Rican

persInfo.raceAndEthn.ethn.isSouthAmerican

A flag that indicates if the applicant is South American

persInfo.raceAndEthn.ethn.other

A flag that indicates if the applicant has another ethnicity

persInfo.raceAndEthn.ethn.otherEthnicity

The other Ethnicity

Military Status

Field Name

Description

persInfo.otheInfo.miliStat.militaryStatus

The military Status

persInfo.otheInfo.miliStat.armedForces

The armed Forces

persInfo.otheInfo.miliStat.serviceBegan

The service Began

persInfo.otheInfo.miliStat.isStillServing

A flag that indicates if Still Serving

persInfo.otheInfo.miliStat.serviceEnded

The service Ended

Professional Experience: Employment, Internships, Leadership

Field Name

Description

suppInfo.expe.expe.type

The experience type

suppInfo.expe.expe.status

The experience status

suppInfo.expe.expe.startDate

The experience start Date

suppInfo.expe.expe.endDate

The experience end Date

suppInfo.expe.expe.jobTitle

The job Title

suppInfo.expe.expe.jobResponsibilities

The job Responsibilities

suppInfo.expe.expe.organizationName

The organization Name

suppInfo.expe.expe.okToContact

A flag that indicates if it's ok To Contact

suppInfo.expe.expe.avgWeeklyHrs

The average Weekly Hrs

suppInfo.expe.expe.numOfWeeks

The number Of Weeks

suppInfo.expe.expe.totalHrs

The total Hrs

suppInfo.expe.expe.supervisorFirstName

The supervisor First Name

suppInfo.expe.expe.supervisorLastName

The supervisor Last Name

suppInfo.expe.expe.supervisorJobTitle

The supervisor Job Title

suppInfo.expe.expe.supervisorEmail

The supervisor Email

suppInfo.expe.expe.supervisorPhone

The supervisor Phone

suppInfo.expe.expe.organizationAddress1

The organization Address1

suppInfo.expe.expe.organizationAddress2

The organization Address2

suppInfo.expe.expe.organizationCity

The organization City

suppInfo.expe.expe.organizationState

The organization State

suppInfo.expe.expe.organizationZip

The organization Zip code

suppInfo.expe.expe.organizationCountry

The organization Country

suppInfo.expe.expe.isCurrent

A flag that indicates if the experience is Current

suppInfo.expe.expe.compensated

A flag that indicates if the experience is compensated

suppInfo.expe.expe.receivedAcademicCredit

A flag that indicates if received Academic Credit

suppInfo.expe.expe.volunteer

A flag that indicates if volunteer

Achievements, Honors, and Awards

Field Name

Description

suppInfo.achi.achi.type

The achievement type

suppInfo.achi.achi.name

The achievement name

suppInfo.achi.achi.description

The achievements description

suppInfo.achi.achi.issuedBy

The achievement issued By

suppInfo.achi.achi.issuedDate

The achievement issued Date

 

For more information, also see the Slate Knowledge Base.

  • Was this article helpful?