Field Mappings - Common App Integration
The following table lists names of fields in Common App from which information is imported into Anthology Reach. These mappings apply to the Campus Management managed solution and cannot be edited or deleted.
| Entity | Common App Field Name | Anthology Reach Field Name |
|---|---|---|
| Display name: Address | Permanent address - State | cmc_state |
| Schema name: customeraddress | Permanent address - City | city |
| Permanent address - Zip | postalcode | |
| Permanent address - Country | cmc_countryregion | |
| Permanent address - Address1 | line1 | |
| Permanent address - Address2 | line2 | |
| Permanent address - Address3 | line3 | |
| Address Type Address1 | addresstypecode | |
| Created Source Address1 | cmc_sourceofrecord | |
| Created Source PreviousEducation1 | cmc_sourceofrecord | |
| Mail Type | mshied_mailtype | |
| parentidtype | parentidtype | |
| CommonAppFY-VirtualField-Contact.Address.1-HasAnyValue C1 | C1 This record determines if any of the mapped Address fields has any value in the source file | |
| CommonAppFY-VirtualField-Contact.Address.1-IsValidRecord C2 | IsValidRecord C2 This record is used to determine if the Address record will be imported (created/updated) or not. | |
| Display name: Application | Created Source | cmc_sourceofrecord |
| Schema name: cmc_application | Application Status | cmc_applicationstatus |
| Application Period | cmc_applicationperiodid | |
| Program Version | cmc_programversionid | |
| Program | cmc_programid | |
| Display name: Application Registration | Service End Date 1 | cmc_serviceenddate |
| Schema name: cmc_applicationregistration | Service Start Date 1 | cmc_servicestartdate |
| FERPA Waiver | cmc_ferpawaiver | |
| Parents marital status | cmc_parentsmaritalstatus | |
| Permanent home | cmc_permanenthome | |
| Military branch 1 | cmc_militarybranch | |
| School discipline | cmc_schooldiscipline | |
| Application Created Date | createdon | |
| Application Export Date | cmc_commonappexportdate | |
| Application Submit Date | cmc_submitteddate | |
| Created Source ApplicationRegistration1 | cmc_sourceofrecord | |
| Application Registration Status | cmc_applicationstatus | |
| Application Definition Version | cmc_applicationdefinitionversionid | |
| Application Submitted | cmc_applicationsubmitted | |
| CommonAppFY-VirtualField-Contact.ApplicationRegistration.1-HasAnyValue C1 | C1 This record determines if any of the mapped Application Registration fields has any value in the source file | |
| CommonAppFY-VirtualField-Contact.ApplicationRegistration.1-IsValidRecord C2 | IsValidRecord C2 This record is used to determine if the Application Registration record will be imported (created/updated) or not. | |
| Display name: Area of Interest | Career Interests | mshied_areaofinterestid |
| Schema name: mshied_areaofinterest | CommonAppFY-VirtualField-Contact.AreaofInterest.1-HasAnyValue C1 | C1 This record determines if any of the mapped Area of Interest fields has any value in the source file |
| CommonAppFY-VirtualField-Contact.AreaofInterest.1-IsValidRecord C2 | IsValidRecord C2 This record is used to determine if the Area of Interest record will be imported (created/updated) or not. | |
| Display name: Contact | Alien Registration Number | cmc_usalienregistrationnumber |
| Schema name: contact | Alternate phone available | These records determine what is Alternate Phone Number(Home/Mobile) |
| Alternate phone number | ||
| VirtualField-Contact-Alternate phone number Home | ||
| VirtualField-Contact-Alternate phone number Mobile | ||
| Preferred phone | These records determine what is Preferred Phone Number(Home/Mobile) | |
| Preferred phone number | ||
| VirtualField-Contact-Preferred phone number Home | ||
| VirtualField-Contact-Preferred phone number Mobile | ||
| VirtualField-Contact-HomePhoneNumber | home2 Taking input from Alternate and Preferred Phone Number | |
| VirtualField-Contact-MobileNumber | Mobilephone Taking input from Alternate and Preferred Phone Number | |
| ARN Expiration date | cmc_usarnexpirationdate | |
| Background | mshied_race_ | |
| Citizenship status | mshied_citizenshipstatus | |
| Citizenships | mshied_citizenship | |
| Common App ID | cmc_commonappid | |
| Contact Type Contact | mshied_contacttype | |
| Contact Type LegalGuardian1 | mshied_contacttype | |
| Contact Type Parent1 | mshied_contacttype | |
| Contact Type Parent2 | mshied_contacttype | |
| Contact Type Sibling1 | mshied_contacttype | |
| Contact Type Sibling2 | mshied_contacttype | |
| Contact Type Sibling3 | mshied_contacttype | |
| Contact Type Sibling4 | mshied_contacttype | |
| Contact Type Sibling5 | mshied_contacttype | |
| Created Source Contact | cmc_sourceofrecord | |
| Created Source LegalGuardian1 | cmc_sourceofrecord | |
| Created Source LegalGuardian1 | cmc_sourceofrecord | |
| Created Source Parent1 | cmc_sourceofrecord | |
| Created Source Parent1 | cmc_sourceofrecord | |
| Created Source Parent2 | cmc_sourceofrecord | |
| Created Source Parent2 | cmc_sourceofrecord | |
| Created Source Sibling1 | cmc_sourceofrecord | |
| Created Source Sibling2 | cmc_sourceofrecord | |
| Created Source Sibling3 | cmc_sourceofrecord | |
| Created Source Sibling4 | cmc_sourceofrecord | |
| Created Source Sibling5 | cmc_sourceofrecord | |
| Date issued | cmc_visadateissued | |
| Date of birth | birthdate | |
| Email Address | emailaddress1 | |
| First name | firstname | |
| Hispanic Latino | mshied_ethnicgroup | |
| Last name | lastname | |
| Legal Guardian Email | emailaddress1 | |
| Legal Guardian First Name | firstname | |
| Legal Guardian Last Name | lastname | |
| Legal Guardian Phone | telephone2 | |
| Legal Guardian suffix | suffix | |
| Middle name | middlename | |
| Parent 1 Email | emailaddress1 | |
| Parent 1 First Name | firstname | |
| Parent 1 Last Name | lastname | |
| Parent 1 Living | mshied_isdeceased | |
| Parent 1 Phone | telephone2 | |
| Parent 1 suffix | suffix | |
| Parent 2 Email | emailaddress1 | |
| Parent 2 First Name | firstname | |
| Parent 2 Last Name | lastname | |
| Parent 2 Living | mshied_isdeceased | |
| Parent 2 Phone | telephone2 | |
| Parent 2 suffix | suffix | |
| Preferred name | cmc_preferredname | |
| Religious preference | cmc_religiouspreference | |
| Sex | gendercode | |
| Sibling 1 education level | cmc_educationlevelid | |
| Sibling 1 First Name | firstname | |
| Sibling 1 Last Name | lastname | |
| Sibling 2 education level | cmc_educationlevelid | |
| Sibling 2 First Name | firstname | |
| Sibling 2 Last Name | lastname | |
| Sibling 3 education level | cmc_educationlevelid | |
| Sibling 3 First Name | firstname | |
| Sibling 3 Last Name | lastname | |
| Sibling 4 education level | cmc_educationlevelid | |
| Sibling 4 First Name | firstname | |
| Sibling 4 Last Name | lastname | |
| Sibling 5 First Name | firstname | |
| Sibling 5 Last Name | lastname | |
| Source Category | cmc_sourcecategoryid | |
| Source Category LegalGuardian1 | cmc_sourcecategoryid | |
| Source Category Parent1 | cmc_sourcecategoryid | |
| Source Category Parent2 | cmc_sourcecategoryid | |
| Source Category Sibling1 | cmc_sourcecategoryid | |
| Source Category Sibling2 | cmc_sourcecategoryid | |
| Source Category Sibling3 | cmc_sourcecategoryid | |
| Source Category Sibling4 | cmc_sourcecategoryid | |
| Source Category Sibling5 | cmc_sourcecategoryid | |
| Source Method | cmc_sourcemethodid | |
| Source Method Contact | cmc_sourcemethodid | |
| Source Method LegalGuardian1 | cmc_sourcemethodid | |
| Source Method Parent1 | cmc_sourcemethodid | |
| Source Method Parent2 | cmc_sourcemethodid | |
| Source Method Sibling2 | cmc_sourcemethodid | |
| Source Method Sibling3 | cmc_sourcemethodid | |
| Source Method Sibling4 | cmc_sourcemethodid | |
| Source Method Sibling5 | cmc_sourcemethodid | |
| SSN | mshied_nationalidentifier | |
| Submitted First Gen | mshied_firstgeneration | |
| Suffix | suffix | |
| U.S. Armed Forces status | cmc_usarmedforcesstatus | |
| Visa number | cmc_visanumber | |
| Visa other | cmc_visaothertype | |
| Visa type | cmc_visatype | |
| Display name: Experience | ExperienceType LegalGuardian1 | cmc_experiencetype |
| Schema name: cmc_experience | ExperienceType Parent1 | cmc_experiencetype |
| ExperienceType Parent2 | cmc_experiencetype | |
| Legal Guardian Employer University - CeebCode | cmc_organizationid | |
| Legal Guardian Occupation | cmc_occupation | |
| Legal Guardian Position | cmc_experiencetitle | |
| Parent 1 Employer University - CeebCode | cmc_organizationid | |
| Parent 1 Occupation | cmc_occupation | |
| Parent 1 Position | cmc_experiencetitle | |
| Parent 2 Employer University - CeebCode | cmc_organizationid | |
| Parent 2 Occupation | cmc_occupation | |
| Parent 2 Position | cmc_experiencetitle | |
| CommonAppFY-VirtualField-Contact.Parent.1.Experience.1-HasAnyValue C1 | C1 This record determines if any of the mapped Parent 1 Experience fields has any value in the source file | |
| CommonAppFY-VirtualField-Parent 1 Employer University - CeebCode-HasAnyValue C2 | C2 To specify if Parent1 Ceeb Code Has Any Value in Source File | |
| CommonAppFY-VirtualField-Contact.Parent.1.Experience.1-IsValidRecord C3 | IsValidRecord C3 This record is used to determine if the Parent 1 Experience record will be imported (created/updated) or not. | |
| CommonAppFY-VirtualField-Contact.Parent.2.Experience.1-HasAnyValue C1 | C1 This record determines if any of the mapped Parent 2 Experience fields has any value in the source file | |
| CommonAppFY-VirtualField-Parent 2 Employer University - CeebCode-HasAnyValue C2 | C2 To specify if Parent2 Ceeb Code Has Any Value in Source File | |
| CommonAppFY-VirtualField-Contact.Parent.2.Experience.1-IsValidRecord C3 | IsValidRecord C3 This record is used to determine if the Parent 2 Experience record will be imported (created/updated) or not. | |
| CommonAppFY-VirtualField-Contact.LegalGuardian.1.Experience.1-HasAnyValue C1 | C1 This record determines if any of the mapped Legal Guardian Experience fields has any value in the source file | |
| CommonAppFY-VirtualField-Legal Guardian Employer University-HasAnyValue C2 | C2 To specify if Legal Guardian Ceeb Code Has Any Value in Source File | |
| CommonAppFY-VirtualField-Contact.LegalGuardian.1.Experience.1-IsValidRecord C3 | IsValidRecord C3 This record is used to determine if the Legal Guardian Experience record will be imported (created/updated) or not. | |
| Display name: Extra Curricular Participant | Activity 1 continue in college | cmc_continueincollege |
| Schema name: mshied_extracurricularparticipant | Activity 1 Honors | cmc_positionsheld |
| Activity 1 Sport-team | mshied_extracurricularactivityid | |
| Activity 1 type | cmc_activitytype | |
| Activity 10 continue in college | cmc_continueincollege | |
| Activity 10 Honors | cmc_positionsheld | |
| Activity 10 Sport-team | mshied_extracurricularactivityid | |
| Activity 10 type | cmc_activitytype | |
| Activity 2 continue in college | cmc_continueincollege | |
| Activity 2 Honors | cmc_positionsheld | |
| Activity 2 Sport-team | mshied_extracurricularactivityid | |
| Activity 2 type | cmc_activitytype | |
| Activity 3 continue in college | cmc_continueincollege | |
| Activity 3 Honors | cmc_positionsheld | |
| Activity 3 Sport-team | mshied_extracurricularactivityid | |
| Activity 3 type | cmc_activitytype | |
| Activity 4 continue in college | cmc_continueincollege | |
| Activity 4 Honors | cmc_positionsheld | |
| Activity 4 Sport-team | mshied_extracurricularactivityid | |
| Activity 4 type | cmc_activitytype | |
| Activity 5 continue in college | cmc_continueincollege | |
| Activity 5 Honors | cmc_positionsheld | |
| Activity 5 Sport-team | mshied_extracurricularactivityid | |
| Activity 5 type | cmc_activitytype | |
| Activity 6 continue in college | cmc_continueincollege | |
| Activity 6 Honors | cmc_positionsheld | |
| Activity 6 Sport-team | mshied_extracurricularactivityid | |
| Activity 6 type | cmc_activitytype | |
| Activity 7 continue in college | cmc_continueincollege | |
| Activity 7 Honors | cmc_positionsheld | |
| Activity 7 Sport-team | mshied_extracurricularactivityid | |
| Activity 7 type | cmc_activitytype | |
| Activity 8 continue in college | cmc_continueincollege | |
| Activity 8 Honors | cmc_positionsheld | |
| Activity 8 Sport-team | mshied_extracurricularactivityid | |
| Activity 8 type | cmc_activitytype | |
| Activity 9 continue in college | cmc_continueincollege | |
| Activity 9 Honors | cmc_positionsheld | |
| Activity 9 Sport-team | mshied_extracurricularactivityid | |
| Activity 9 type | cmc_activitytype | |
| Source Of Record Activity1 | cmc_sourceofrecord | |
| Source Of Record Activity10 | cmc_sourceofrecord | |
| Source Of Record Activity2 | cmc_sourceofrecord | |
| Source Of Record Activity3 | cmc_sourceofrecord | |
| Source Of Record Activity4 | cmc_sourceofrecord | |
| Source Of Record Activity5 | cmc_sourceofrecord | |
| Source Of Record Activity6 | cmc_sourceofrecord | |
| Source Of Record Activity7 | cmc_sourceofrecord | |
| Source Of Record Activity8 | cmc_sourceofrecord | |
| Source Of Record Activity9 | cmc_sourceofrecord | |
| CommonAppFY-VirtualField-Contact.ExtraCurricularParticipant.1-HasAnyValue C1 | C1 This record determines if any of the mapped Extra Curricular Participant fields has any value in the source file | |
| CommonAppFY-VirtualField-Contact.ExtraCurricularParticipant.1-IsValidRecord C2 | IsValidRecord C2 This record is used to determine if the Extra Curricular Participant record will be imported (created/updated) or not. | |
| CommonAppFY-VirtualField-Contact.ExtraCurricularParticipant.2-HasAnyValue C1 | C1 This record determines if any of the mapped Extra Curricular Participant fields has any value in the source file | |
| CommonAppFY-VirtualField-Contact.ExtraCurricularParticipant.2-IsValidRecord C2 | IsValidRecord C2 This record is used to determine if the Extra Curricular Participant record will be imported (created/updated) or not. | |
| CommonAppFY-VirtualField-Contact.ExtraCurricularParticipant.3-HasAnyValue C1 | C1 This record determines if any of the mapped Extra Curricular Participant fields has any value in the source file | |
| CommonAppFY-VirtualField-Contact.ExtraCurricularParticipant.3-IsValidRecord C2 | IsValidRecord C2 This record is used to determine if the Extra Curricular Participant record will be imported (created/updated) or not. | |
| CommonAppFY-VirtualField-Contact.ExtraCurricularParticipant.4-HasAnyValue C1 | C1 This record determines if any of the mapped Extra Curricular Participant fields has any value in the source file | |
| CommonAppFY-VirtualField-Contact.ExtraCurricularParticipant.4-IsValidRecord C2 | IsValidRecord C2 This record is used to determine if the Extra Curricular Participant record will be imported (created/updated) or not. | |
| CommonAppFY-VirtualField-Contact.ExtraCurricularParticipant.5-HasAnyValue C1 | C1 This record determines if any of the mapped Extra Curricular Participant fields has any value in the source file | |
| CommonAppFY-VirtualField-Contact.ExtraCurricularParticipant.5-IsValidRecord C2 | IsValidRecord C2 This record is used to determine if the Extra Curricular Participant record will be imported (created/updated) or not. | |
| CommonAppFY-VirtualField-Contact.ExtraCurricularParticipant.6-HasAnyValue C1 | C1 This record determines if any of the mapped Extra Curricular Participant fields has any value in the source file | |
| CommonAppFY-VirtualField-Contact.ExtraCurricularParticipant.6-IsValidRecord C2 | IsValidRecord C2 This record is used to determine if the Extra Curricular Participant record will be imported (created/updated) or not. | |
| CommonAppFY-VirtualField-Contact.ExtraCurricularParticipant.7-HasAnyValue C1 | C1 This record determines if any of the mapped Extra Curricular Participant fields has any value in the source file | |
| CommonAppFY-VirtualField-Contact.ExtraCurricularParticipant.7-IsValidRecord C2 | IsValidRecord C2 This record is used to determine if the Extra Curricular Participant record will be imported (created/updated) or not. | |
| CommonAppFY-VirtualField-Contact.ExtraCurricularParticipant.8-HasAnyValue C1 | C1 This record determines if any of the mapped Extra Curricular Participant fields has any value in the source file | |
| CommonAppFY-VirtualField-Contact.ExtraCurricularParticipant.8-IsValidRecord C2 | IsValidRecord C2 This record is used to determine if the Extra Curricular Participant record will be imported (created/updated) or not. | |
| CommonAppFY-VirtualField-Contact.ExtraCurricularParticipant.9-HasAnyValue C1 | C1 This record determines if any of the mapped Extra Curricular Participant fields has any value in the source file | |
| CommonAppFY-VirtualField-Contact.ExtraCurricularParticipant.9-IsValidRecord C2 | IsValidRecord C2 This record is used to determine if the Extra Curricular Participant record will be imported (created/updated) or not. | |
| CommonAppFY-VirtualField-Contact.ExtraCurricularParticipant.10-HasAnyValue C1 | C1 This record determines if any of the mapped Extra Curricular Participant fields has any value in the source file | |
| CommonAppFY-VirtualField-Contact.ExtraCurricularParticipant.10-IsValidRecord C2 | IsValidRecord C2 This record is used to determine if the Extra Curricular Participant record will be imported (created/updated) or not. | |
| Display name: Previous Education | Cumulative GPA | mshied_gpa |
| Schema name: mshied_previouseducation | GPA Scale | cmc_gpascale |
| Grade Level | mshied_educationlevelid | |
| School lookup - CeebCode | mshied_schoolnameid | |
| CommonAppFY-VirtualField-Contact.PreviousEducation.1-HasAnyValue C1 | C1 This record determines if any of the mapped Extra Curricular Participant fields has any value in the source file | |
| CommonAppFY-VirtualField-Contact.PreviousEducation.1-IsValidRecord C2 | IsValidRecord C2 This record is used to determine if the Extra Curricular Participant record will be imported (created/updated) or not. | |
| Display name: Test Scores | ACT Composite date | mshied_testdate |
| Schema name: mshied_testscore | ACT Composite Score | mshied_actcomposite |
| Created Source TestScore1 | cmc_sourceofrecord | |
| Created Source TestScore2 | cmc_sourceofrecord | |
| Created Source TestScore3 | cmc_sourceofrecord | |
| Created Source TestScore4 | cmc_sourceofrecord | |
| Created Source TestScore5 | cmc_sourceofrecord | |
| Created Source TestScore6 | cmc_sourceofrecord | |
| SAT as of 3-2016 Math date | mshied_testdate | |
| SAT as of 3-2016 Math Score | mshied_satmathsection | |
| SAT as of 3-2016 RW date | mshied_testdate | |
| SAT as of 3-2016 RW Score | mshied_satevidencebasedreadingandwritingsection | |
| SAT CR Date | mshied_testdate | |
| SAT CR Score | cmc_oldsatcriticalreading | |
| SAT Math date | mshied_testdate | |
| SAT Math Score | cmc_oldsatmathematics | |
| Test Source1 | mshied_testsource | |
| Test Source2 | mshied_testsource | |
| Test Source3 | mshied_testsource | |
| Test Source4 | mshied_testsource | |
| Test Source5 | mshied_testsource | |
| Test Source6 | mshied_testsource | |
| Test Type1 | mshied_testtypeid | |
| Test Type2 | mshied_testtypeid | |
| Test Type3 | mshied_testtypeid | |
| Test Type4 | mshied_testtypeid | |
| Test Type5 | mshied_testtypeid | |
| Test Type6 | mshied_testtypeid | |
| TOEFL iBT Total Date | mshied_testdate | |
| TOEFL iBT Total Score | mshied_toefltotalscore | |
| CommonAppFY-VirtualField-Contact.TestScore.1-HasAnyValue C1 | C1 This record determines if any of the mapped Test Score fields has any value in the source file | |
| CommonAppFY-VirtualField-Contact.TestScore.1-IsValidRecord C2 | IsValidRecord C2 This record is used to determine if the Test Score record will be imported (created/updated) or not. | |
| CommonAppFY-VirtualField-Contact.TestScore.2-HasAnyValue C1 | C1 This record determines if any of the mapped Test Score fields has any value in the source file | |
| CommonAppFY-VirtualField-Contact.TestScore.2-IsValidRecord C2 | IsValidRecord C2 This record is used to determine if the Test Score record will be imported (created/updated) or not. | |
| CommonAppFY-VirtualField-Contact.TestScore.3-HasAnyValue C1 | C1 This record determines if any of the mapped Test Score fields has any value in the source file | |
| CommonAppFY-VirtualField-Contact.TestScore.3-IsValidRecord C2 | IsValidRecord C2 This record is used to determine if the Test Score record will be imported (created/updated) or not. | |
| CommonAppFY-VirtualField-Contact.TestScore.4-HasAnyValue C1 | C1 This record determines if any of the mapped Test Score fields has any value in the source file | |
| CommonAppFY-VirtualField-Contact.TestScore.4-IsValidRecord C2 | IsValidRecord C2 This record is used to determine if the Test Score record will be imported (created/updated) or not. | |
| CommonAppFY-VirtualField-Contact.TestScore.5-HasAnyValue C1 | C1 This record determines if any of the mapped Test Score fields has any value in the source file | |
| CommonAppFY-VirtualField-Contact.TestScore.5-IsValidRecord C2 | IsValidRecord C2 This record is used to determine if the Test Score record will be imported (created/updated) or not. | |
| CommonAppFY-VirtualField-Contact.TestScore.6-HasAnyValue C1 | C1 This record determines if any of the mapped Test Score fields has any value in the source file | |
| CommonAppFY-VirtualField-Contact.TestScore.6-IsValidRecord C2 | IsValidRecord C2 This record is used to determine if the Test Score record will be imported (created/updated) or not. |
