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 |
---|---|---|
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 |
---|---|---|---|
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? |
---|---|
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? |
---|---|
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: |
---|---|
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?
|
---|---|
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. |
---|---|
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? |
---|---|
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?
|
---|---|
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.
|
---|---|
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.
|
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.
|
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 |
|
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) | |
Slate Field Name | Other - Military Veteran (app_veteran / bit), Other - Military Veteran Status (app_veteran_status) |
Slate Field ID | See above. |
Notes |
|
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) | |
Slate Field Name | Other - Military Veteran |
Slate Field ID | app_veteran |
Notes |
|
Visa Status/Information
CASPA
Question Text (from application) | What type of Visa? |
---|---|
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? |
---|---|
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? |
---|---|
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)?
|
---|---|
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 |