CAS API Crosswalk / Field Mapping

This page was created to contain notes/documentation for the CAS API and Slate integration that are related to complex data translations between the two databases. It is under construction.

Overview

There are two different types of fields within the CAS/Liaison universe.

CAS-specific fields/prompts vary, based on the profession/governing body involved, but are asked of all applicants, no matter which school(s) they are applying to.

Program-specific fields and their prompts are developed by individual schools and are only asked of applicants to that specific program.

Although there is value in coordinating the Standard fields across instances from an admin perspective, end user business process can be the primary factor in deciding how the data will be presented in Slate. That having been said, the core demographic and program data fields that will be used for standardized reporting must be available in and reportable from within Slate.

Technical Details on how Mapping works between Slate and SIS

Chart Template

Question Text (from application)

 

Question Location

 

Property Name (API)

 

Slate Field Name

 

Slate Field ID

 

Notes

 

 

Race & Ethnicity

This section was written based off the configurations in TUP, and may not be accurate to other Slate systems. Needs review.

In the CAS application, race and ethnicity (hispanic) is collected using a series of bit fields for each possible racial/ethnicity category. These fields are available in the Personal Information > Race and Ethnicity (persInfo.raceAndEthn) categories in the application file produced by the API.

In WebAdMIT this data is similarly configured, where there is one field for each race/ethnicity category and the associated value will be either Yes, No, or Null.

In Slate, race and ethnicity are stored in (at least) 4 fields, summarized below.

Field Name

Type

Sample Value

Field Name

Type

Sample Value

Race

Multiple Value

Asian - Chinese

Race - Other

Free Text

Panamanian

Hispanic

Bit

Yes

Hispanic Origin

Multiple Value

Mexican or Chicano

IPEDS Race and Ethnicity Category

Single Value

Foreign National

When importing data from CAS sources into Slate, this difference is resolved by converting any field that has a Yes value into the equivalent prompt-list value for the available races/ethnicities in Slate.

CAS/Liaison to Slate Crosswalk Table

WebAdMIT

CAS API Application File

Slate Field

Slate Value

WebAdMIT

CAS API Application File

Slate Field

Slate Value

race_hispanic

persInfo.raceAndEthn.ethn.hispanicLatino

Hispanic

Yes/No/Null

race_hispanic_yes_no_blank

persInfo.raceAndEthn.ethn.hispanicLatino

Hispanic

 

race_cuban

persInfo.raceAndEthn.ethn.isCuban

Hispanic Origin

Cuban

race_mexican

persInfo.raceAndEthn.ethn.isMexican

Hispanic Origin

Mexican or Chicano

race_puerto_rican

persInfo.raceAndEthn.ethn.isPuertoRican

Hispanic Origin

Puerto Rican

race_south_american

persInfo.raceAndEthn.ethn.isSouthAmerican

Hispanic Origin

Other Hispanic, Latino, or of Spanish origin

race_other_spanish

persInfo.raceAndEthn.ethn.other

Hispanic Origin

Other Hispanic, Latino, or of Spanish origin

race_other_spanish_name

persInfo.raceAndEthn.ethn.otherEthnicity

 

 

race_american_indian

persInfo.raceAndEthn.race.isAmericanIndian

Race

American Indian or Alaska Native

race_indian_tribe_name

persInfo.raceAndEthn.race.americanIndianTribeName

 

 

race_asian

persInfo.raceAndEthn.race.isAsian

Race

Asian

race_asian_indian

persInfo.raceAndEthn.race.isAsianIndian

Race

Asian - India 

race_cambodian

persInfo.raceAndEthn.race.isCambodian

Race

Asian - Other Southeast Asia

race_chinese

persInfo.raceAndEthn.race.isChinese

Race

Asian - China

race_filipino

persInfo.raceAndEthn.race.isFilipino

Race

Asian - Philippines

race_japanese

persInfo.raceAndEthn.race.isJapanese

Race

Asian - Japan

race_korean

persInfo.raceAndEthn.race.isKorean

Race

Asian - Korea

race_malaysian

persInfo.raceAndEthn.race.isMalaysian

Race

Asian

race_pakistani

persInfo.raceAndEthn.race.isPakistani

Race

Asian - Pakistan

race_vietnamese

persInfo.raceAndEthn.race.isVietnamese

Race

Asian - Vietnam

race_other_asian

persInfo.raceAndEthn.race.otherAsian

Race

Asian

race_other_asian_name

 

 

 

race_black

persInfo.raceAndEthn.race.isAfricanAmerican

Race

Black or African American

race_pacific_islander

persInfo.raceAndEthn.race.isPacificIslander

Race

Native Hawaiian or Other Pacific

race_guamanian

persInfo.raceAndEthn.race.isGuamanian

Race

Native Hawaiian or Other Pacific Islander - Guam

race_hawaiian

persInfo.raceAndEthn.race.isHawaiian

Race

Native Hawaiian or Other Pacific Islander - Hawaii

race_samoan

persInfo.raceAndEthn.race.isSamoan

Race

Native Hawaiian or Other Pacific Islander - Samoa

race_other_pacific_islander

persInfo.raceAndEthn.race.isOtherPacificIslander

Race

Native Hawaiian or Other Pacific

race_other_pacific_islander_name

 

 

 

race_white

persInfo.raceAndEthn.race.isWhite

Race

White

Example Translation

In CAS/WebAdMIT:

  • persInfo.raceAndEthn.ethn.hispanicLatino = Yes

  • persInfo.raceAndEthn.ethn.isMexican = Yes

  • persInfo.raceAndEthn.race.isKorean = Yes

  • persInfo.raceAndEthn.race.isWhite = Yes

In Slate:

  • Hispanic = Yes

  • Hispanic Origin = Mexican or Chicano

  • Race = Asian - Korean, White

IPEDS Race and Ethnicity Category

After race and ethnicity data are imported into Slate, Slate has rules/automations that run to calculate the value for the “IPEDS Race and Ethnicity Category” field. These rules follow the guidelines for data reporting https://nces.ed.gov/ipeds/report-your-data/race-ethnicity-collecting-data-for-reporting-purposes

First the rule checks to see if the record has a citizenship value of Foreign National; if true, it adds “Foreign National” as the value.

If not true, it checks to see if the record has no value for Race and Hispanic; if true, it adds “Unknown race and ethnicity” as the value.

If not true, it checks to see if the record has “yes” as the value for Hispanic; if true, it adds “Hispanic” as the value.

If not true, it runs through each of the remaining race categories to add American Indian or Alaska Native, Asian, Black or African American, Native Hawaiian or Pacific Islander, and White, so long as no other race values exist.

Lastly, the records that have more than one top-level “category” of race are assigned “Two or More Races.” This is to ensure that a student who has Race = Asian, Asian - Chinese is categorized as “Asian,” but a student who has Race = Asian, White is categorized as “Two or More Races.”

Sex, Gender & Pronouns

CASPA

Question Text (from application)

What is your legal sex? image-20240815-134717.png

Question Location

Personal Information > Biographic Information > Sex

Property Name (API)

persInfo.biogInfo.prof.gender

Slate Field Name

App - CAS/Liaison Legal Sex/Gender

Slate Field ID

cas_legal_sex

Notes

This is also currently mapped to the system field for ‘sex’ in the Application source format until a new solution for providing gender information in SIS feed is found.

This is the only gender value that comes over in the In Progress CAS file, so unsubmitted applications for CASPA will only have this gender marker.

Question Text (from application)

What is your current Gender Identity? image-20240815-134424.png

Question Location

Personal Information > Biographic Information > Gender Identity

Property Name (API)

genderIdentity

Slate Field Name

App - CAS/Liaison Gender Identity

Slate Field ID

cas_gender_identity

Notes

If the student selects “prefer to self describe” they are able to enter an answer in a free-text field.

Question Text (from application)

Please specify your self-described gender: image-20240815-134628.png

Question Location

Personal Information > Biographic Information > Gender Identity

Property Name (API)

genderIdentityDescrip

Slate Field Name

Other - Other Gender Identity

Slate Field ID

gender_other

Notes

Students only fill out this option if they elect to “self describe” in the drop-down menu of gender identity options.

SOPHAS

Question Text (from application)

While we understand that your sex may not necessarily be binary, this information is required for reporting purposes to the U.S. Federal Government using these values only. What is your sex?

image-20240815-131829.png

Question Location

Personal Information > Biographic Information > Sex

Property Name (API)

persInfo.biogInfo.prof.gender

Slate Field Name

App - CAS/Liaison Legal Sex/Gender

Slate Field ID

cas_legal_sex

Notes

This is also currently mapped to the system field for ‘sex’ in the Application source format until a new solution for providing gender information in SIS feed is found.

Question Text (from application)

If you would like the opportunity, we invite you to share your gender identity.image-20240815-131901.png

Question Location

Personal Information > Biographic Information > Gender Identity

Property Name (API)

genderIdentityDescrip

Slate Field Name

Other - Other Gender Identity

Slate Field ID

gender_other

Notes

SOPHAS only provides an open-text field for a response if a student wants to share their gender identity.

 

 

PTCAS

Question Text (from application)

What biological sex were you assigned at birth, such as on an original birth certificate? image-20241114-205917.png

Question Location

Personal Information > Biographic Information > Legal Sex

Property Name (API)

persInfo.biogInfo.prof.gender

Slate Field Name

App - CAS/Liaison Legal Sex/Gender

Slate Field ID

cas_legal_sex

Notes

This is also currently mapped to the system field for ‘sex’ in the Application source format until a new solution for providing gender information in SIS feed is found.

Question Text (from application)

How do you describe your current gender identity?

image-20240618-203352.png

 

Question Location

Personal Information > Biographic Information > Gender Identity

Property Name (API)

genderIdentity

Slate Field Name

App - CAS/Liaison Gender Identity

Slate Field ID

cas_gender_identity

Notes

 

Question Text (from application)

Please select the set of pronouns you prefer others use when referring to you.

 

image-20240829-164428.png

 

Question Location

Personal Information > Biographic Information > Pronouns

Property Name (API)

persInfo.biogInfo.prof.XXXXX

Slate Field Name

App -

Slate Field ID

 

Notes

 

VMCAS

VMCAS Application Instructions

Question Text (from app)

What is your legal sex?

Question Location

Personal Information>Biographic Information>Legal Sex

Property Name (API)

persInfo.biogInfo.prof.gender

Slate Field Name

App - VMCAS: CAS/Liaison Legal Sex

Slate Field ID

cas_legal_sex

Notes

Although this field exists across all CAS instances, the available prompt values are different between professions. Note that this is an application scoped field; the core person-scoped sex field within Slate which feeds SIS was not directly mapped for the 2024-2025 cycle, but this data was put into a CAS Gender Marker field as a holding pen; will eventually be mapped to the new gender identity field in Slate. [still unclear how this will get to SIS]…

Question Text (from app)

How do you describe your current gender identity?

 

 

Question Location

Personal Information>Biographic Information>Gender Identity

Property Name (API)

genderIdentity

Slate Field Name

App - VMCAS: CAS/Liaison Gender Identity

Slate Field ID

cas_gender_identity

Notes

Prompt field, as well as free text option for those who select ‘prefer to self describe’. Like marker, was mapped to a newly created field; may not flow to SIS for some time.

Socioeconomic Indicators (HRSA)

Economic Disadvantage

Question Text (from application)

To determine if you come from an economically disadvantaged background, you are asked to compare your parental family's size of household (number of exemptions listed on parent's Federal 1040 income tax forms) and adjusted gross income against the chart provided in the link below. The chart is based on 200 percent of Federal low-income poverty guidelines. You should use your parent's most recent tax forms regardless of age. Your parent's family income falls within the table's guidelines and you are considered to have met the criteria for economically disadvantaged. (Select Yes or No)

Question Location

Personal Information > Other Information > Background Information

Property Name (API)

persInfo.otheInfo.econDisa0.meetsCriteria

Slate Field Name

Family Income - HRSA Family Income (Bit)

Slate Field ID

app_phpd_hrsa_famincome

Notes

 

CASPA

Question Text (from application)

Have you or members of your immediate family ever used federal or state assistance programs?

Question Location

Personal Information > Environmental Factors > Family Situation

Property Name (API)

persInfo.enviFact.famiSitu.federalStateAssistancePrograms

Slate Field Name

Financial Assistance - HRSA Indicators

Slate Field ID

app_phpd_hrsa

Notes

This is a stand alone question in CASPA but is imported to Slate as one of the HRSA indicator prompts. There is a very similar prompt that CASPA does include in the area where the other HRSA answers/Background Information prompts are, but since both questions are asked in the application, I made a new prompt.

Question Text (from application)

What was the income level of your family during the majority of your life from birth to age eighteen?

Question Location

Personal Information > Environmental Factors > Family Situation

Property Name (API)

persInfo.enviFact.famiSitu.incomeLevelHousehold

Slate Field Name

Financial Assistance - HRSA Family Income (Value)

Slate Field ID

app_phpd_hrsa_income

Notes

 

Question Text (from application)

Did you have paid employment prior to age eighteen?

Question Location

Personal Information > Environmental Factors > Family Situation

Property Name (API)

persInfo.enviFact.famiSitu.paidEmploymentPriorAgeEighteen

Slate Field Name

Financial Assistance - HRSA Indicators

Slate Field ID

app_phpd_hrsa

Notes

This is a stand alone question in CASPA but is imported to Slate as one of the HRSA indicator prompts.

Question Text (from application)

Were you able to contribute to the overall family income (as opposed to working primarily for your own discretionary spending money)?

Question Location

Personal Information > Environmental Factors > Family Situation

Property Name (API)

persInfo.enviFact.famiSitu.contributeOverallFamilyIncome

Slate Field Name

Financial Assistance - HRSA Indicators

Slate Field ID

app_phpd_hrsa

Notes

This is a stand alone question in CASPA but is imported to Slate as one of the HRSA indicator prompts.

Question Text (from application)

Check if any of the following apply to you:

I graduated from a high school from which a low percentage of seniors receive a high school diploma.

I graduated from a high school at which many of the enrolled students are eligible for free or reduced price lunches.

I am from a family that receives public assistance (e.g. Aid to Families with Dependent Children, food stamps, Medicaid, public housing) or I receive public assistance.

I am from a family that lives in an area that is designated as a Health Professional Shortage Area or a Medically Underserved Area.

I participated in an academic enrichment program funded in whole or in part by the Health Careers Opportunity Program.

I am a high-school drop-out who received AHS diploma or GED.

I am from a school district where 50% or less of graduates go to college or where college education is not encouraged.

I am the first generation in my family to attend college(neither my mother nor my father attended college).

English is not my primary language.

Question Location

Personal Information > Other Information > Background Information

Property Name (API)

persInfo.otheInfo.sociEconIndi0.indicator, persInfo.otheInfo.sociEconIndi1.indicator, etc. out to Indi8

Slate Field Name

Financial Assistance - HRSA Indicators

Slate Field ID

app_phpd_hrsa

Notes

This is the original (OG) HRSA indicator list, CASPA labels it as “Background Information.” The API exports this information as a flat file and only includes a property name and value if the student selects that category.

Question Text (from application)

What is the type of geographic area where you were raised?

Question Location

Personal Information > Other Information > Background Information

Property Name (API)

persInfo.otheInfo.econDisa0.geographicAreaRaised

Slate Field Name

Financial Assistance - HRSA Geographic Area

Slate Field ID

app_phpd_hrsa_geoarea

Notes

 

PTCAS

SOPHAS

VMCAS

Military Status

 

CASPA

Question Text (from application)

What is your U.S. Armed Forces Status?

 

Question Location

Personal Information > Military History

Property Name (API)

persInfo.otheInfo.miliStat0.currentMilitaryStatus

Slate Field Name

Other - Military Veteran (app_veteran / bit),

Other - Military Veteran Status (app_veteran_status)

Slate Field ID

See above.

Notes

This question is asked first; if the answer is currently serving or previously served, the rest of the military history questions are asked.

  • current dependent: app_veteran = No | app_veteran_status = Military Dependent

  • none: app_veteran = No | app_veteran_status = Not a member of the military

  • Currently serving or previously served are not mapped to either field.

 

Question Text (from application)

Anticipated status at the time you enroll

 

 

Question Location

Personal Information > Military History

Property Name (API)

persInfo.otheInfo.miliStat0.MilitaryStatus

Slate Field Name

Other - Military Veteran (app_veteran / bit),

Other - Military Veteran Status (app_veteran_status)

Slate Field ID

See above.

Notes

Only asked if answer to current status is currently or previously served.

  • Veteran of US Armed Forces: app_veteran = Yes | app_veteran_status = Veteran

  • On active duty US Military: app_veteran_status = Full-time Active Duty

  • US Reserves or National Guard: app_veteran_status = Member of Reserve or National Guard

PTCAS

Question Text (from application)

Indicate your anticipated United States Military status at the time you enroll.

 

 

Question Location

Personal Information > Other Information

Property Name (API)

persInfo.otheInfo.miliStat0.militaryStatus

Slate Field Name

Other - Military Veteran (app_veteran / bit),

Other - Military Veteran Status (app_veteran_status)

Slate Field ID

See above

Notes

  • On Active Duty app_veteran_status = Full Time Active Duty | app_veteran = NULL

  • Veteran app_veteran_status = Veteran | app_veteran = Yes

  • Member of Reserve or National Guard app_veteran_status = Member of Reserve or National Guard | app_veteran = NULL

  • Military Dependent app_veteran_status = Military Dependent | app_veteran = No

  • Other app_veteran_status = NULL | app_veteran = NULL

  • Not a member of the military app_veteran_status = Not a member of the military | app_veteran = No

SOPHAS

Question Text (from application)

Indicate your anticipated United States Military status at the time you enroll

Question Location

Other Information > Military Status

Property Name (API)

persInfo.otheInfo.miliStat0.militaryStatus

Slate Field Name

Other - Military Veteran (app_veteran / bit),

Other - Military Veteran Status (app_veteran_status)

Slate Field ID

See above.

Notes

  • On Active Duty app_veteran_status = Full Time Active Duty | app_veteran = NULL

  • Veteran app_veteran_status = Veteran | app_veteran = Yes

  • Member of Reserve or National Guard app_veteran_status = Member of Reserve or National Guard | app_veteran = NULL

  • Military Dependent app_veteran_status = Military Dependent | app_veteran = No

  • Other app_veteran_status = NULL | app_veteran = NULL

  • Not a member of the military app_veteran_status = Not a member of the military | app_veteran = No

VMCAS

Question Text (from application)

Indicate your anticipated United States Military status at the time you enroll

Question Location

Other Information > Military Status

Property Name (API)

persInfo.otheInfo.miliStat0.militaryStatus

Slate Field Name

Other - Military Veteran

Slate Field ID

app_veteran

Notes

 

Visa Status/Information

CASPA

Question Text (from application)

What type of Visa? image-20240906-185902.png

Question Location

Personal Information > Citizenship Information > Visa Information

Property Name (API)

persInfo.citiInfo.visaInfo.visaTypeId

Slate Field Name

Personal Details - Visa

Slate Field ID

visa

Notes

Only application that asks a separate question about DACA. Otherwise uses the exact same format as other CAS applications. Can only answer these questions if you have a non-US citizenship and then answer ‘yes’ for Do you have a U.S. Visa?

PTCAS

Question Text (from application)

What type of Visa? image-20240906-193659.png

Question Location

Personal Information > Citizenship Information > Visa Information

Property Name (API)

persInfo.citiInfo.visaInfo.visaTypeId

Slate Field Name

Personal Details - Visa

Slate Field ID

visa

Notes

Can only answer these questions if you have a non-US citizenship and then answer ‘yes’ for Do you have a U.S. Visa?

SOPHAS

Question Text (from application)

What type of Visa? image-20240906-194539.png

Question Location

Personal Information > Citizenship Information > Visa Information

Property Name (API)

persInfo.citiInfo.visaInfo.visaTypeId

Slate Field Name

Personal Details - Visa

Slate Field ID

visa

Notes

Can only answer these questions if you have a non-US citizenship and then answer ‘yes’ for Do you have a U.S. Visa?

First Generation

CASPA

Question Text (from application)

Check if any of the following apply to you:

[…]

I am the first generation in my family to attend college (neither my mother nor my father attended college).

Question Location

Personal Information > Other Information > Background Information

Property Name (API)

 

Slate Field Name

 

Slate Field ID

 

Notes

Only asked in the “HRSA” checklist

PTCAS

Question Text (from application)

Are you the first generation in your family to attend college (e.g. neither your mother or father attended college)? image-20240906-193839.png

 

Question Location

Personal Information > Economic/Educational/Environmental Factors > Family Situation

Property Name (API)

 

Slate Field Name

 

Slate Field ID

 

Notes

Asked as an independent question (all socioeconomic questions asked as individual questions, not a “HRSA” checklist)

SOPHAS

Question Text (from application)

Are you the first member of your immediate family to complete an undergraduate degree?

Question Location

Personal Information > Other Information > First Generation Student

Property Name (API)

 

Slate Field Name

 

Slate Field ID

 

Notes

 

Question Text (from application)

Are you the first member of your immediate family to pursue a graduate degree?

Question Location

Personal Information > Other Information > First Generation Student

Property Name (API)

 

Slate Field Name

 

Slate Field ID

 

Notes

 

Question Text (from application)

Check if any of the following apply to you:

[…]

I am the first generation in my family to attend college(neither my mother nor my father attended college).

Question Location

Personal Information > Other Information > Background Information

Property Name (API)

 

Slate Field Name

 

Slate Field ID

 

Notes

SOPHAS has a “HRSA” checklist and this is one factor in it, however they also ask the question as a 2 separate questions in a different section (one for grad and one for undergrad).

CAS-Calculated GPAs

CASPA

Question Text (from application)

N/A

Question Location

N/A

Property Name (WebAdMIT)

Overall Science Total GPA

Slate Field Name

#3 CAS Calculated GPA (Application) > Overall Science Total GPA

Slate Field ID

 

Notes

Type = Year

Question Text (from application)

N/A

Question Location

N/A

Property Name (WebAdMIT)

Overall Total GPA

Slate Field Name

#1 CAS Calculated GPA (Application) >Prerequisite GPA (Program Entry)

Slate Field ID

 

Notes

Type = Prerequisite

Question Text (from application)

N/A

Question Location

N/A

Property Name (WebAdMIT)

Prerequisite Required Courses GPA

Slate Field Name

#2 CAS Calculated GPA (Application) > Overall Science Total GPA

Slate Field ID

 

Notes

Type = Subject

PTCAS

Question Text (from application)

N/A

Question Location

N/A

Property Name (WebAdMIT)

Graduate Total GPA

Slate Field Name

#3 CAS Calculated GPA (Application) > Graduate GPA

Slate Field ID

 

Notes

Type = Year

Question Text (from application)

N/A

Question Location

N/A

Property Name (WebAdMIT)

Cumulative Undergraduate Total GPA

Slate Field Name

#2 CAS Calculated GPA (Application) > Cumulative Undergraduate GPA

Slate Field ID

 

Notes

Type = Year

Question Text (from application)

N/A

Question Location

N/A

Property Name (WebAdMIT)

Overall Total GPA

Slate Field Name

#1 CAS Calculated GPA (Application) > Overall Total GPA

Slate Field ID

 

Notes

Type = Year

Question Text (from application)

N/A

Question Location

N/A

Property Name (WebAdMIT)

Science GPA

Slate Field Name

#6 CAS Calculated GPA (Application) > Overall Science Total GPA

Slate Field ID

 

Notes

Type = Subject

Question Text (from application)

N/A

Question Location

N/A

Property Name (WebAdMIT)

Science and Math GPA

Slate Field Name

#5 CAS Calculated GPA (Application) > Science and Math GPA

Slate Field ID

 

Notes

Type = Subject

Question Text (from application)

N/A

Question Location

N/A

Property Name (WebAdMIT)

Prereq GPA - Program Selected GPA

Slate Field Name

#4 CAS Calculated GPA (Application) > Prerequisite GPA (Program Entry)

Slate Field ID

 

Notes

Type = Prerequisite