Field Mappings

The following table lists names of fields in entity records from which information is imported into CampusNexus Engage. These mappings apply to the Campus Management managed solution and it's recommended not to edit or delete these mappings.

Engage Entity name External field names Engage Schema name (Internal)
Display name: Contact ACT-VirtualField-EthnContactenatedReplace mshied_race_
Schema name: contact Ph_CtryCde These fields contribute to setting a value in the ACT-VirtualField-FullPhone field. For more information, see the integration mapping record.
  Phone
  ACT-VirtualField-FullPhone Values will be imported into one of the following fields based on whether the number being imported is a mobile number, a home number or any other number.
  Ph_Type
  ACT-VirtualField-mobilephone mobilephone
  ACT-VirtualField-telephone1 telephone1
  ACT-VirtualField-telephone3 telephone3
  DOB birthdate
  Email emailaddress1
  F_Name firstname
  Gender gendercode
  L_Name middlename
  M_Initial lastname
  Contact Type mshied_contacttype
  Source Category cmc_sourcecategoryid
  Source Method cmc_sourcemethodid
  Created Source cmc_sourceofrecord
  Ethn_HispLat mshied_ethnicgroup
Display name: Address Zip

  1. Values of the Postal, Zip, and Zip4 fields are received from the source file.

  2. The ACT-VirtualField-ZipPlus4 concatenates values in the Zip and Zip4 fields.

  3. The ACT-VirtualField-Zip4-HasAnyValue field verifies if the Zip4 field has a value. If it does, the value is stored in the cache.

  4. Logic in the ACT-VirtualField-ZipCode field evaluates the ACT-VirtualField-Zip4-HasAnyValue field. If it’s successful, the value of the ACT-VirtualField-ZipPlus4 field is considered. Otherwise, the value of the Zip field is considered in the ACT-VirtualField-ZipCode field.

  5. If a value is available in the ACT-VirtualField-ZipCode field, it is passed to ACT-VirtualField-postalcode, otherwise the value of the Postal field is passed into ACT-VirtualField-postalcode, which is synced with the postalcode field in CampusNexus Engage.
Schema name: customeraddress Zip4
  ACT-VirtualField-ZipPlus4
  ACT-VirtualField-Zip4-HasAnyValue
  ACT-VirtualField-ZipCode
  Postal
  ACT-VirtualField-postalcode postalcode
  Prov Values in the Prov and State fields are concatenated and passed to the ACT-VirtualField-cmc_stateprovince, after which the value is passed into the cmc_state field.
  State
  ACT-VirtualField-cmc_stateprovince cmc_state
  Address1 line1
  Address2 line2
  City city
  Country_Code cmc_countryregion
  County_Name county
  Address Type addresstypecode
  Mail Type mshied_mailtype
  Created Source cmc_sourceofrecord
  parentidtype parentidtype
  ACT_2020_2021-VirtualField-Contact.Address.1-HasAnyValue This record determines if any of the mapped contact addresses have any value in the source file.
  ACT_2020_2021-VirtualField-Contact.Address.1-IsValidRecord isValidRecord

This record is used to determine if the address records will be imported (created/updated) or not.
Display Name: Area of Interest Major mshied_areaofinterestid
Schema Name: mshied_areaofinterest ACT_2020_2021-VirtualField-Contact.AreaOfInterest.1-HasAnyValue This record determines if any of the mapped Area of Interest fields has any value in the source file.
  ACT_2020_2021-VirtualField-Contact.AreaOfInterest.1-IsValidRecord isValidRecord

This record is used to determine if the Area Of Interest record will be imported (created/updated) or not.
Display name: Previous Education HS_Code mshied_schoolnameid
Schema name: mshied_previouseducatio HS_GPA_Calc mshied_gpa
  HS_GradeLev mshied_educationlevelid
  Created Source cmc_sourceofrecord
  ACT_2020_2021-VirtualField-Contact.PreviousEducation.1-HasAnyValue This record determines if any of the mapped Previous Education fields has any value in the source file.
  ACT_2020_2021-VirtualField-Contact.PreviousEducation.1-IsValidRecord isValidRecord

This record is used to determine if the Previous Education record will be imported (created/updated) or not.
Display name: Test Score Composite mshied_actcomposite
Schema name: mshied_testscore ELA mshied_actela
  Eng mshied_actenglish
  Mth mshied_actmath
  Rdg mshied_actreading
  Sci mshied_actscience
  STEM mshied_actstem
  Test_Dte mshied_testdate
  Writing mshied_actwriting
  Test Type mshied_testtypeid
  Created Source cmc_sourceofrecord
  Test Source mshied_testsource
  ACT_2020_2021-VirtualField-Contact.TestScore.1-HasAnyValue This record determines if any of the mapped Test Score fields has any value in the source file.
  ACT_2020_2021-VirtualField-Contact.TestScore.1-IsValidRecord isValidRecord

This record determines if the Test Score record will be imported (created/updated) or not.
Entity Name External Field Name Internal Field Name
Display  Name: Address Address Type addresstypecode
Schema name: customeraddress Mail Type mshied_mailtype
  Created Source cmc_sourceofrecord
  City-9 city
  Country Code-58 cmc_countryregion
  State or Province-10 cmc_state
  Street Address - Line 1-7 line1
  Street Address - Line 2-8 line2
  Zip Code-11 postalcode
  parentidtype parentidtype
  GMAT-VirtualField-Contact.Address.1-HasAnyValue  
  GMAT-VirtualField-Contact.Address.1-IsValidRecord isValidRecord
Display name: Contact Contact Type mshied_contacttype
Schema name: contact Source Category cmc_sourcecategoryid
  Source Method cmc_sourcemethodid
  Created Source cmc_sourceofrecord
  Citizenship Code-55 mshied_citizenship
  Date of Birth-5 birthdate
  E-mail Address-12 emailaddress1
  First Name-2 firstname
  Gender-4 gendercode
  Last Name-1 lastname
  Middle Name-3 middlename
  Telephone Number-6 telephone1
Display Name: Test Score Test Type1 mshied_testtypeid
Schema Name: mshied_testscore Test Type2 mshied_testtypeid
  Test Type3 mshied_testtypeid
  Created Source cmc_sourceofrecord
  Test Source mshied_testsource
  Created Source cmc_sourceofrecord
  Test Source mshied_testsource
  Created Source cmc_sourceofrecord
  Test Source mshied_testsource
  Administration Date-27 mshied_testdate
  Analytical Writing Converted Score-36 mshied_gmatanalyticalwriting
  IR Converted Score-37 mshied_gmatintegratedreasoning
  Quantitative Converted Score-34 mshied_gmatquantitativereasoning
  Total Converted Score-35 mshied_gmattotal
  Verbal Converted Score-33 mshied_gmatverbalreasoning
  Administration Date-39 mshied_testdate
  Analytical Writing Converted Score-48 mshied_gmatanalyticalwriting
  IR Converted Score-49 mshied_gmatintegratedreasoning
  Quantitative Converted Score-46 mshied_gmatquantitativereasoning
  Total Converted Score-47 mshied_gmattotal
  Verbal Converted Score-45 mshied_gmatverbalreasoning
  Administration Date-15 mshied_testdate
  Analytical Writing Converted Score-24 mshied_gmatanalyticalwriting
  IR Converted Score-25 mshied_gmatintegratedreasoning
  Quantitative Converted Score-22 mshied_gmatquantitativereasoning
  Total Converted Score-23 mshied_gmattotal
  Verbal Converted Score-21 mshied_gmatverbalreasoning
  GMAT-VirtualField-Contact.TestScore.1-HasAnyValue  
  GMAT-VirtualField-Contact.TestScore.1-IsValidRecord isValidRecord
  GMAT-VirtualField-Contact.TestScore.2-HasAnyValue  
  GMAT-VirtualField-Contact.TestScore.2-IsValidRecord isValidRecord
  GMAT-VirtualField-Contact.TestScore.3-HasAnyValue  
  GMAT-VirtualField-Contact.TestScore.3-IsValidRecord isValidRecord
Entity Name External Field Name Internal Field Name
Display name: Contact Contact Type mshied_contacttype
Schema name: contact Created Source cmc_sourceofrecord
  Date of Birth birthdate
  E-mail Address emailaddress1
  Examinee Last Name lastname
  First Name firstname
  Gender gendercode
  Middle Initial middlename
  Source Category cmc_sourcecategoryid
  Source Method cmc_sourcemethodid
  Telephone Number telephone1
Display  Name: Address Address Line 1 line1
Schema name: customeraddress Address Line 2 line2
  Address Line 3 line3
  Address Type addresstypecode
  City city
  Created Source cmc_sourceofrecord
  GRE-VirtualField-cmc_country cmc_countryregion
  Country G1 G1 - These fields contribute to setting a value in the cmc_countryregion field. For more information, see integration mapping records of these fields.
  ISO Country Code G1  
  State/Province cmc_state
  ZIP/Postal Code postalcode
  GRE-VirtualField-Contact.Address.1-HasAnyValue G2 G2 This record determines if any of the mapped address fields has any value in the source file
  GRE-VirtualField-Contact.Address.1-IsValidRecord G3 IsValidRecord G3

This record is used to determine if the Address record will be imported (created/updated) or not.
  Mail Type mshied_mailtype
  parentidtype parentidtype
Display Name: Test Score Created Source cmc_sourceofrecord
Schema Name: mshied_testscore GRE-VirtualField-mshied_greanalyticalreasoning-Score Type (3) mshied_greanalyticalreasoning
  Scaled Score (3) G2 G2 - These fields contribute to setting a value in the mshied_greanalyticalreasoning field. For more information, see integration mapping records of these fields.
  Score Type (3) G2  
  GRE_VirtualField-Replace-Scaled Score (3) G2  
  GRE-VirtualField-mshied_grequantitativereasoning-Score Type (2) mshied_grequantitativereasoning
  Scaled Score (2) G3 G3 - These fields contribute to setting a value in the mshied_grequantitativereasoning field. For more information, see integration mapping records of these fields.
  Score Type (2) G3  
  GRE-VirtualField-mshied_greverbalreasoning-Score Type (1) mshied_greverbalreasoning
  Scaled Score (1) G4 G4 - These fields contribute to setting a value in the mshied_greverbalreasoning field. For more information, see integration mapping records of these fields.
  Score Type (1) G4  
  GRE-VirtualField-Contact.TestScore.1-HasAnyValue G5 G5 This record determines if any of the mapped Test Score fields has any value in the source file
  GRE-VirtualField-Contact.TestScore.1-IsNotSubjectScoreRecord G6 G6 This record determines if the current Test Score Record is a Subject Score.
  GRE-VirtualField-Contact.TestScore.1-IsValidRecord G7 IsValidRecord G7

This record is used to determine if the Test Score record will be imported (created/updated) or not.
  Scaled Score (4) Not used at present.
  Scaled Score (5) Not used at present.
  Scaled Score (6) Not used at present.
  Scaled Score (7) Not used at present.
  Score Type (4) Not used at present.
  Score Type (5) Not used at present.
  Score Type (6) Not used at present.
  Score Type (7) Not used at present.
  Test Date mshied_testdate
  Test Name Not used at present.
  Test Source mshied_testsource
  Test Type mshied_testtypeid
Entity Name External Field Name Internal Field Name
Display name: Contact candidateEmail emailaddress1
Schema name: contact Contact Type mshied_contacttype
  Created Source cmc_sourceofrecord
  dateOfBirth birthdate
  familyName lastname
  firstName firstname
  gender gendercode
  Source Category cmc_sourcecategoryid
  Source Method cmc_sourcemethodid
  telephone telephone
Display  Name: Address Address Type addresstypecode
Schema name: customeraddress addressLine1 line1
  addressLine2 line2
  addressLine3 line3
  Created Source cmc_sourceofrecord
  IELTS-VirtualField-cmc_country cmc_countryregion
  country I1 I1 - These fields contribute to setting a value in the cmc_countryregion field. For more information, see integration mapping records of these fields.
  countryCode I1  
  IELTS-VirtualField-Contact.Address.1-HasAnyValue I2 I2 This record determines if any of the mapped address fields has any value in the source file
  IELTS-VirtualField-Contact.Address.1-IsValidRecord I3 IsValidRecord I3

This record is used to determine if the Address record will be imported (created/updated) or not.
  Mail Type mshied_mailtype
  parentidtype parentidtype
  postcode postalcode
  region cmc_state
  town city
Display Name: Test Score centreNumber mshied_testlocation
Schema Name: mshied_testscore Created Source cmc_sourceofrecord
  listeningScore mshied_ieltslistening
  overallBandScore mshied_ieltsoverallbandscore
  readingScore mshied_ieltsreading
  speakingScore mshied_ieltsspeakingscore
  Test Source mshied_testsource
  Test Type mshied_testtypeid
  testDate mshied_testdate
  writingScore mshied_ieltswriting
  IELTS-VirtualField-Contact.TestScore.1-HasAnyValue I1 I1 This record determines if any of the mapped Test Score fields has any value in the source file
  IELTS-VirtualField-Contact.TestScore.1-IsValidRecord I2 IsValidRecord I2

This record is used to determine if the Test Score record will be imported (created/updated) or not.
Not used at present. trfNumber Not used at present.
  postalAddress Not used at present.
  addressLine4 Not used at present.
  photo_data Not used at present.
  photo_mediaType Not used at present.
  downloadDate Not used at present.
  candidateNumber Not used at present.
  module Not used at present.
Entity Name External Field Name Internal Field Name
Display name: Contact Contact Type mshied_contacttype
Schema name: contact Created Source cmc_sourceofrecord
  Date_Of_Birth birthdate
  Email Address emailaddress1
  First_Name firstname
  Gender gendercode
  IBT_rPDT_ID_Number mshied_nationalidentifier
  Last_Name lastname
  Middle_Name middlename
  Source Category cmc_sourcecategoryid
  Source Method cmc_sourcemethodid
  TOEFL-VirtualField-mshied_countryofbirth mshied_countryofbirth
  Native_Country_Code T1 T1 - These fields contribute to setting a value in the mshied_countryofbirth field. For more information, see integration mapping records of these fields.
  Native_Country_Name T1  
Display  Name: Address Address Type addresstypecode
Schema name: customeraddress Address_ City city
  Address_ Postal_Code postalcode
  Address_ State_Province cmc_state
  Address_Line_1 line1
  Address_Line_2 line2
  Address_Line_3 line3
  Created Source cmc_sourceofrecord
  TOEFL-VirtualField-cmc_country cmc_countryregion
  Address_ Country_Code T2 T2 - These fields contribute to setting a value in the cmc_countryregion field. For more information, see integration mapping records of these fields.
  Address_ Country_Name T2  
  TOEFL-VirtualField-Contact.Address.1-HasAnyValue T3 T3 This record determines if any of the mapped address fields has any value in the source file
  TOEFL-VirtualField-Contact.Address.1-IsValidRecord T4 IsValidRecord T4

This record is used to determine if the Address record will be imported (created/updated) or not.
  Mail Type mshied_mailtype
  parentidtype parentidtype
Display Name: Test Score Administration_Date mshied_testdate
Schema Name: mshied_testscore Created Source cmc_sourceofrecord
  IBT_Listening mshied_toefllisteningsection
  IBT_Reading mshied_toeflreadingsection
  IBT_Speaking mshied_toeflspeakingsection
  IBT_Total_Score mshied_toefltotalscore
  IBT_Writing mshied_toeflwritingsection
  Test Source mshied_testsource
  Test Type mshied_testtypeid
  TOEFL-VirtualField-mshied_testlocation mshied_testlocation
  Test Center Code T3 T3 - These fields contribute to setting a value in the mshied_testlocation field. For more information, see integration mapping records of these fields.
  Test Center Country T3  
  TOEFL-VirtualField-Contact.TestScore.1-HasAnyValue T4 T4 This record determines if any of the mapped Test Score fields has any value in the source file
  TOEFL-VirtualField-Contact.TestScore.1-IsValidRecord T5 IsValidRecord T5

This record is used to determine if the Test Score record will be imported (created/updated) or not.
Entity Name External Field Name Internal Field Name
Display name: Contact BIRTH_DATE birthdate
Schema name: contact Contact Type mshied_contacttype
  Created Source cmc_sourceofrecord
  EMAIL emailaddress1
  NAME_FIRST firstname
  NAME_LAST lastname
  NAME_MI middlename
  PHONE telephone2
  SAT-VirtualField-MultiselectOptionSet-Race S1 mshied_race_
  SAT-VirtualField-ReplaceConcatenated-Race S1 S1 - These fields contribute to setting a value in the mshied_race_ field. For more information, see integration mapping records of these fields.
  SAT-VirtualField-Concatenate-Race S1  
  RACE_ETH_AFRICANAMERICAN S1  
  RACE_ETH_ASIAN S1  
  RACE_ETH_CUBAN S1  
  RACE_ETH_HAWAIIAN_PI S1  
  RACE_ETH_INDIAN_ALASKAN S1  
  RACE_ETH_MEXICAN S1  
  RACE_ETH_OTHER S1  
  RACE_ETH_PUERTORICAN S1  
  RACE_ETH_WHITE S1  
  SAT-VirtualField-ethnicgroup mshied_ethnicgroup
  RACE_ETH_HISP_LAT S2 S2 - These fields contribute to setting a value in the mshied_ethnicgroup field. For more information, see integration mapping records of these fields.
  RACE_ETH_NON_HISP_LAT S2  
  SEX gendercode
  SOCIAL_SECURITY mshied_nationalidentifier
  Source Category cmc_sourcecategoryid
  Source Method cmc_sourcemethodid
Display  Name: Address Address Type addresstypecode
Schema name: customeraddress ADDRESS_CITY city
  ADDRESS_COUNTRY cmc_countryregion
  ADDRESS_COUNTY county
  ADDRESS_LINE1 line1
  ADDRESS_LINE2 line2
  ADDRESS_ZIP postalcode
  Created Source cmc_sourceofrecord
  SAT-VirtualField-cmc_stateprovince cmc_state
  ADDRESS_PROVINCE S3 S3 - These fields contribute to setting a value in the cmc_state field. For more information, see integration mapping records of these fields.
  ADDRESS_STATE S3  
  SAT-VirtualField-Contact.Address.1-HasAnyValue S4 S4 This record determines if any of the mapped address fields has any value in the source file
  SAT-VirtualField-Contact.Address.1-IsValidRecord S5 IsValidRecord S5

This record is used to determine if the Address record will be imported (created/updated) or not.
  Mail Type mshied_mailtype
  parentidtype parentidtype
Display Name: Test Score ADMIN2_SAT_DATE mshied_testdate
Schema Name: mshied_testscore ADMIN2_SAT_EBRW mshied_satevidencebasedreadingandwritingsection
  ADMIN2_SAT_ESSAY_ANALYSIS mshied_satessayanalysis
  ADMIN2_SAT_ESSAY_READING mshied_satessayreading
  ADMIN2_SAT_ESSAY_WRITING mshied_satessaywriting
  ADMIN2_SAT_MATH_SECTION mshied_satmathsection
  ADMIN2_SAT_TOTAL mshied_sattotalscore
  ADMIN3_SAT_DATE mshied_testdate
  ADMIN3_SAT_EBRW mshied_satevidencebasedreadingandwritingsection
  ADMIN3_SAT_ESSAY_ANALYSIS mshied_satessayanalysis
  ADMIN3_SAT_ESSAY_READING mshied_satessayreading
  ADMIN3_SAT_ESSAY_WRITING mshied_satessaywriting
  ADMIN3_SAT_MATH_SECTION mshied_satmathsection
  ADMIN3_SAT_TOTAL mshied_sattotalscore
  ADMIN4_SAT_DATE mshied_testdate
  ADMIN4_SAT_EBRW mshied_satevidencebasedreadingandwritingsection
  ADMIN4_SAT_ESSAY_ANALYSIS mshied_satessayanalysis
  ADMIN4_SAT_ESSAY_READING mshied_satessayreading
  ADMIN4_SAT_ESSAY_WRITING mshied_satessaywriting
  ADMIN4_SAT_MATH_SECTION mshied_satmathsection
  ADMIN4_SAT_TOTAL mshied_sattotalscore
  ADMIN5_SAT_DATE mshied_testdate
  ADMIN5_SAT_EBRW mshied_satevidencebasedreadingandwritingsection
  ADMIN5_SAT_ESSAY_ANALYSIS mshied_satessayanalysis
  ADMIN5_SAT_ESSAY_READING mshied_satessayreading
  ADMIN5_SAT_ESSAY_WRITING mshied_satessaywriting
  ADMIN5_SAT_MATH_SECTION mshied_satmathsection
  ADMIN5_SAT_TOTAL mshied_sattotalscore
  ADMIN6_SAT_DATE mshied_testdate
  ADMIN6_SAT_EBRW mshied_satevidencebasedreadingandwritingsection
  ADMIN6_SAT_ESSAY_ANALYSIS mshied_satessayanalysis
  ADMIN6_SAT_ESSAY_READING mshied_satessayreading
  ADMIN6_SAT_ESSAY_WRITING mshied_satessaywriting
  ADMIN6_SAT_MATH_SECTION mshied_satmathsection
  ADMIN6_SAT_TOTAL mshied_sattotalscore
  Created Source cmc_sourceofrecord
  Created Source cmc_sourceofrecord
  Created Source cmc_sourceofrecord
  Created Source cmc_sourceofrecord
  Created Source cmc_sourceofrecord
  Created Source cmc_sourceofrecord
  LATEST_SAT_DATE mshied_testdate
  LATEST_SAT_EBRW mshied_satevidencebasedreadingandwritingsection
  LATEST_SAT_ESSAY_ANALYSIS mshied_satessayanalysis
  LATEST_SAT_ESSAY_READING mshied_satessayreading
  LATEST_SAT_ESSAY_WRITING mshied_satessaywriting
  LATEST_SAT_MATH_SECTION mshied_satmathsection
  LATEST_SAT_TOTAL mshied_sattotalscore
  Test Source mshied_testsource
  Test Source mshied_testsource
  Test Source mshied_testsource
  Test Source mshied_testsource
  Test Source mshied_testsource
  Test Source 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
  SAT-VirtualField-Contact.TestScore.1-HasAnyValue S6 S6 This record determines if any of the mapped Test Score fields has any value in the source file
  SAT-VirtualField-Contact.TestScore.1-IsValidRecord S7 IsValidRecord S7

This record is used to determine if the Test Score record will be imported (created/updated) or not.
  SAT-VirtualField-Contact.TestScore.2-HasAnyValue S6 S6 This record determines if any of the mapped Test Score fields has any value in the source file
  SAT-VirtualField-Contact.TestScore.2-IsValidRecord S7 IsValidRecord S7

This record is used to determine if the Test Score record will be imported (created/updated) or not.
  SAT-VirtualField-Contact.TestScore.3-HasAnyValue S6 S6 This record determines if any of the mapped Test Score fields has any value in the source file
  SAT-VirtualField-Contact.TestScore.3-IsValidRecord S7 IsValidRecord S7

This record is used to determine if the Test Score record will be imported (created/updated) or not.
  SAT-VirtualField-Contact.TestScore.4-HasAnyValue S6 S6 This record determines if any of the mapped Test Score fields has any value in the source file
  SAT-VirtualField-Contact.TestScore.4-IsValidRecord S7 IsValidRecord S7

This record is used to determine if the Test Score record will be imported (created/updated) or not.
  SAT-VirtualField-Contact.TestScore.5-HasAnyValue S6 S6 This record determines if any of the mapped Test Score fields has any value in the source file
  SAT-VirtualField-Contact.TestScore.5-IsValidRecord S7 IsValidRecord S7

This record is used to determine if the Test Score record will be imported (created/updated) or not.
  SAT-VirtualField-Contact.TestScore.6-HasAnyValue S6 S6 This record determines if any of the mapped Test Score fields has any value in the source file
  SAT-VirtualField-Contact.TestScore.6-IsValidRecord S7 IsValidRecord S7 This record is used to determine if the Test Score record will be imported (created/updated) or not.
Display Name: Extra Curricular Participant ACTIVITY1 mshied_extracurricularactivityid
Schema Name: mshied_extracurricularparticipants Created Source cmc_sourceofrecord
  ACTIVITY2 mshied_extracurricularactivityid
  Created Source cmc_sourceofrecord
  ACTIVITY3 mshied_extracurricularactivityid
  Created Source cmc_sourceofrecord
  ACTIVITY4 mshied_extracurricularactivityid
  Created Source cmc_sourceofrecord
  ACTIVITY5 mshied_extracurricularactivityid
  Created Source cmc_sourceofrecord
  ACTIVITY6 mshied_extracurricularactivityid
  Created Source cmc_sourceofrecord
  ACTIVITY7 mshied_extracurricularactivityid
  Created Source cmc_sourceofrecord
  ACTIVITY8 mshied_extracurricularactivityid
  Created Source cmc_sourceofrecord
  ACTIVITY9 mshied_extracurricularactivityid
  Created Source cmc_sourceofrecord
  ACTIVITY10 mshied_extracurricularactivityid
  Created Source cmc_sourceofrecord
  SPORT1 mshied_extracurricularactivityid
  Created Source cmc_sourceofrecord
  SPORT2 mshied_extracurricularactivityid
  Created Source cmc_sourceofrecord
  SPORT3 mshied_extracurricularactivityid
  Created Source cmc_sourceofrecord
  SPORT4 mshied_extracurricularactivityid
  Created Source cmc_sourceofrecord
  SPORT5 mshied_extracurricularactivityid
  Created Source cmc_sourceofrecord
  SPORT6 mshied_extracurricularactivityid
  Created Source cmc_sourceofrecord
  SAT-VirtualField-Contact.ExtraCurricularParticipant.1-HasAnyValue S8 S8 This record determines if any of the mapped ExtraCurricular Participant fields has any value in the source file
  SAT-VirtualField-Contact.ExtraCurricularParticipant.1-IsValidRecord S9 IsValidRecord S9

This record is used to determine if the ExtraCurricular Participant record will be imported (created/updated) or not.
  SAT-VirtualField-Contact.ExtraCurricularParticipant.2-HasAnyValue S8 S8 This record determines if any of the mapped ExtraCurricular Participant fields has any value in the source file
  SAT-VirtualField-Contact.ExtraCurricularParticipant.2-IsValidRecord S9 IsValidRecord S9

This record is used to determine if the ExtraCurricular Participant record will be imported (created/updated) or not.
  SAT-VirtualField-Contact.ExtraCurricularParticipant.3-HasAnyValue S8 S8 This record determines if any of the mapped ExtraCurricular Participant fields has any value in the source file
  SAT-VirtualField-Contact.ExtraCurricularParticipant.3-IsValidRecord S9 IsValidRecord S9

This record is used to determine if the ExtraCurricular Participant record will be imported (created/updated) or not.
  SAT-VirtualField-Contact.ExtraCurricularParticipant.4-HasAnyValue S8 S8 This record determines if any of the mapped ExtraCurricular Participant fields has any value in the source file
  SAT-VirtualField-Contact.ExtraCurricularParticipant.4-IsValidRecord S9 IsValidRecord S9

This record is used to determine if the ExtraCurricular Participant record will be imported (created/updated) or not.
  SAT-VirtualField-Contact.ExtraCurricularParticipant.5-HasAnyValue S8 S8 This record determines if any of the mapped ExtraCurricular Participant fields has any value in the source file
  SAT-VirtualField-Contact.ExtraCurricularParticipant.5-IsValidRecord S9 IsValidRecord S9

This record is used to determine if the ExtraCurricular Participant record will be imported (created/updated) or not.
  SAT-VirtualField-Contact.ExtraCurricularParticipant.6-HasAnyValue S8 S8 This record determines if any of the mapped ExtraCurricular Participant fields has any value in the source file
  SAT-VirtualField-Contact.ExtraCurricularParticipant.6-IsValidRecord S9 IsValidRecord S9

This record is used to determine if the ExtraCurricular Participant record will be imported (created/updated) or not.
  SAT-VirtualField-Contact.ExtraCurricularParticipant.7-HasAnyValue S8 S8 This record determines if any of the mapped ExtraCurricular Participant fields has any value in the source file
  SAT-VirtualField-Contact.ExtraCurricularParticipant.7-IsValidRecord S9 IsValidRecord S9

This record is used to determine if the ExtraCurricular Participant record will be imported (created/updated) or not.
  SAT-VirtualField-Contact.ExtraCurricularParticipant.8-HasAnyValue S8 S8 This record determines if any of the mapped ExtraCurricular Participant fields has any value in the source file
  SAT-VirtualField-Contact.ExtraCurricularParticipant.8-IsValidRecord S9 IsValidRecord S9

This record is used to determine if the ExtraCurricular Participant record will be imported (created/updated) or not.
  SAT-VirtualField-Contact.ExtraCurricularParticipant.9-HasAnyValue S8 S8 This record determines if any of the mapped ExtraCurricular Participant fields has any value in the source file
  SAT-VirtualField-Contact.ExtraCurricularParticipant.9-IsValidRecord S9 IsValidRecord S9

This record is used to determine if the ExtraCurricular Participant record will be imported (created/updated) or not.
  SAT-VirtualField-Contact.ExtraCurricularParticipant.10-HasAnyValue S8 S8 This record determines if any of the mapped ExtraCurricular Participant fields has any value in the source file
  SAT-VirtualField-Contact.ExtraCurricularParticipant.10-IsValidRecord S9 IsValidRecord S9

This record is used to determine if the ExtraCurricular Participant record will be imported (created/updated) or not.
  SAT-VirtualField-Contact.ExtraCurricularParticipant.11-HasAnyValue S8 S9 This record determines if any of the mapped ExtraCurricular Participant fields has any value in the source file
  SAT-VirtualField-Contact.ExtraCurricularParticipant.11-IsValidRecord S9 IsValidRecord S9

This record is used to determine if the ExtraCurricular Participant record will be imported (created/updated) or not.
  SAT-VirtualField-Contact.ExtraCurricularParticipant.12-HasAnyValue S8 S8 This record determines if any of the mapped ExtraCurricular Participant fields has any value in the source file
  SAT-VirtualField-Contact.ExtraCurricularParticipant.12-IsValidRecord S9 IsValidRecord S9

This record is used to determine if the ExtraCurricular Participant record will be imported (created/updated) or not.
  SAT-VirtualField-Contact.ExtraCurricularParticipant.13-HasAnyValue S8 S8 This record determines if any of the mapped ExtraCurricular Participant fields has any value in the source file
  SAT-VirtualField-Contact.ExtraCurricularParticipant.13-IsValidRecord S9 IsValidRecord S9

This record is used to determine if the ExtraCurricular Participant record will be imported (created/updated) or not.
  SAT-VirtualField-Contact.ExtraCurricularParticipant.14-HasAnyValue S8 S8 This record determines if any of the mapped ExtraCurricular Participant fields has any value in the source file
  SAT-VirtualField-Contact.ExtraCurricularParticipant.14-IsValidRecord S9 IsValidRecord S9

This record is used to determine if the ExtraCurricular Participant record will be imported (created/updated) or not.
  SAT-VirtualField-Contact.ExtraCurricularParticipant.15-HasAnyValue S8 S8 This record determines if any of the mapped ExtraCurricular Participant fields has any value in the source file
  SAT-VirtualField-Contact.ExtraCurricularParticipant.15-IsValidRecord S9 IsValidRecord S9

This record is used to determine if the ExtraCurricular Participant record will be imported (created/updated) or not.
  SAT-VirtualField-Contact.ExtraCurricularParticipant.16-HasAnyValue S8 S8 This record determines if any of the mapped ExtraCurricular Participant fields has any value in the source file
  SAT-VirtualField-Contact.ExtraCurricularParticipant.16-IsValidRecord S9 IsValidRecord S9

This record is used to determine if the ExtraCurricular Participant record will be imported (created/updated) or not.
Entity Name External Field Name Internal Field Name
mshied_academicperiod Code mshied_code
  End Date mshied_enddate
  EntityType EntityType
  External Identifier mshied_externalidentifier
  Externalidentifier mshied_externalidentifier
  ExternalSourceSystem mshied_externalsourcesystem
  Name mshied_name
  Start Date mshied_startdate
  External Source System mshied_externalsourcesystem
mshied_areaofinterest Code mshied_code
  EntityType EntityType
  External Identifier mshied_externalidentifier
  Externalidentifier mshied_externalidentifier
  ExternalSourceSystem mshied_externalidentifier
  Name mshied_name
  External Source System mshied_externalsourcesystem
mshied_areaofstudy Code mshied_code
  EntityType EntityType
  External Identifier mshied_externalidentifier
  Externalidentifier mshied_externalidentifier
  ExternalSourceSystem mshied_externalsourcesystem
  Minimum Required GPA mshied_minimumrequiredgpa
  Name mshied_name
  Program Type mshied_programtypeid
  Required Credits mshied_requiredcredits
  External Source System mshied_externalsourcesystem
mshied_course Academic Level mshied_academiclevel
  Code mshied_code
  Course Name mshied_name
  Course Number mshied_coursenumber
  End Date mshied_enddate
  EntityType EntityType
  External Identifier mshied_externalidentifier
  Externalidentifier mshied_externalidentifier
  ExternalSourceSystem mshied_externalsourcesystem
  Prerequisites mshied_prerequisites
  Section mshied_section
  Start Date mshied_startdate
  Subject mshied_subject
  External Source System mshied_externalsourcesystem
mshied_coursesection Academic Period mshied_academicperiodid
  Campus mshied_campusid
  Course mshied_courseid
  Course Day Time mshied_coursedaytime
  Course Section Name mshied_name
  EntityType EntityType
  External Identifier mshied_externalidentifier
  Externalidentifier mshied_externalidentifier
  ExternalSourceSystem mshied_externalsourcesystem
  Instructor mshied_instructorid
  Location mshied_location
  Prerequisites mshied_prerequisites
  External Source System mshied_externalsourcesystem
mshied_program Code mshied_code
  EntityType EntityType
  External Identifier mshied_externalidentifier
  Externalidentifier mshied_externalidentifier
  ExternalSourceSystem mshied_externalsourcesystem
  Program Name mshied_name
  External Source System mshied_externalsourcesystem
mshied_programversion Code mshied_code
  EntityType EntityType
  External Identifier mshied_externalidentifier
  Externalidentifier mshied_externalidentifier
  ExternalSourceSystem mshied_externalsourcesystem
  Program mshied_programid
  Program Level mshied_programlevelid
  Program Version Name mshied_name
  External Source System mshied_externalsourcesystem
mshied_programversiondetail Code mshied_code
  EntityType EntityType
  Expected Graduation Date mshied_expectedgraduationdate
  External Identifier mshied_externalidentifier
  Externalidentifier mshied_externalidentifier
  ExternalSourceSystem mshied_externalsourcesystem
  Midpoint Date mshied_midpointdate
  Must Graduate Before mshied_mustgraduatebefore
  Program Version mshied_programversionid
  Program Version Detail Name mshied_name
  Start Date mshied_startdate
  External Source System mshied_externalsourcesystem