Element451Integrations Guide

CFNC UAT / Field Mappings

Updated Article

To test the CFNC integration, you will need to work with your integration specialist to have them bring in records from CFNC for you to review.  Once live, the integration happens on a schedule, but for testing, it must be done manually.

Because CFNC is used by both four year institutions and community colleges, the exact fields that are mapped can vary.  The mapping below is for Community Colleges, but a four year institution will be similiar for the common fields and we can work with you to bring in other non-common ones.

Additionally, for community college schools, there are typically several different types of applications (Traditional Undergraduate, CCP, CIHS, etc).  Testing should happen for each group of records you intend to bring over into Element.  We recommend fully testing one type of application before moving onto the next type of applications.  Work with your integration specialists to make sure all use cases are covered.


CFNC→Element#

Preparation#

We recommend finding a listing of 5-10 records in CFNC that have a variety of data on them to best represent the different types of scenarios you may get (for example, domestic vs. international, different programs, etc).  For each record you want to have synced over to Element, you will need to note the student’s name and their UserApplication number.  You should provide the listing to your integration specialist using the following format:

  • {Student’s Name} | UserApplication/#######-A

Requesting a Sync#

Once you have the listing of records that should be synced into Element (and in the correct format), notify your integration specialist and provide the listing to them.  They will work to import the applications into Element for you (this includes the application data and the preview PDF of the application).  Transcripts are typically not imported as a part of testing, but can be done if requested.

Reviewing the Sync Result#

After each sync, check the Integration Log:


Validate Data in Element#

Once a record has synced successfully:

  • Review the record in Element
  • Compare values using the Field Mappings section
  • Validate:
    • CFNC fields
    • Corresponding Element451 fields (slugs)

The Field Mappings reflect the standard integration configuration for our community colleges. If your implementation includes additional customizations, use this as a baseline and add any additional validation checks as needed.


Community College CFNC → Element Field Mappings#

CFNC FieldCFNC Field IDElement FieldElement SlugElement Area
CFNC IdcfncUserIdCFNC IDuser-identities-cfncidIdentities
NC Student Id (escholar Id)ncStudentNumberNC Student Number IDuser-identities-ncstudentnumberidIdentities
RCN IDrcnNumberRCN IDuser-identities-rcnidIdentities
First namestudentNameFirstFirst Nameuser-first-namePerson Data
Middle namestudentNameMiddleMiddle Nameuser-middle-namePerson Data
Last namestudentNameLastLast Nameuser-last-namePerson Data
PrefixstudentNamePrefixName Prefixuser-suffix-namePerson Data
SuffixstudentNameSuffixName Suffixuser-prefix-namePerson Data
Preferred first namestudentNamePreferredFirstNamePreferred First Nameuser-preferred-namePerson Data
Former last namestudentPreviousName1LastFormer Last Name(s)user-former-last-namePerson Data
Former last name 2 (if first doesn't exist)studentPreviousName2LastFormer Last Name(s)user-former-last-namePerson Data
SSNsocialSecurityNumberSocial Security #user-ssnPerson Data
Date of BrithdateOfBirthDate of Birthuser-dobPerson Data
GendersexGenderuser-genderPerson Data
Primary LanguagefirstLanguagePrimary Languageuser-citizenship-native-languagePerson Data
RacesuncRaceYour Raceuser-race-categoriesPerson Data
Hispanic/LatinouncynAreYouHispanicOrLatinoAre you Hispanic/Latino?user-race-hispanicPerson Data
Homeless indicatorhomelessIndividualCFNC - Homlesssnessuser-custom-{SUBDOM}-homeless-individualCustom Fields
Foster carefosterCareCFNC - Foster Careuser-custom-{SUBDOM}-fostercare-youthCustom Fields
Migrant farmworkermigrantFarmworkerCFNC - Migrant or Farmworerkuser-custom-{SUBDOM}-migrant-farmworkerCustom Fields
Citizenship statusncccCitizenshipCitizenship Statususer-citizenship-us-statusPerson Data
Immigration statusimmigrationStatusCFNC - Immigration Statususer-custom-{SUBDOM}-immigrationStatusCustom Fields
Country of citizenshipcountryOfCitizenshipCountry of Citizenshipuser-citizenship-countryPerson Data
Visa typencccVisaTypeVisa Typeuser-citizenship-visa-typePerson Data
Permanent resident numberpermanentResidentNumberPermanent Resident Numberuser-citizenship-permanent-resident-numberPerson Data
Home phonephonePermanentAddressHome Phoneuser-phone-home-country-code | user-phone-home-numberPerson Data
Cell phonephoneCellCell Phoneuser-phone-cell-country-code | user-phone-cell-numberPerson Data
Text mesage opt-in flags 3authorizeText3Opt in for SMSuser-sms-updatesPerson Data
Permanent Address StreetpermanentAddressStreetHome - Street 1user-addresses-home-street1Person Data
Permanent Address CitypermanentAddressCityHome - Cityuser-addresses-home-cityPerson Data
Permanent Address StatepermanentAddressStateHome - Stateuser-addresses-home-statePerson Data
Permanent Address Zip CodepermanentAddressZipCodeHome - Zipuser-addresses-home-zipPerson Data
Permanent Address CountrypermanentAddressCountryHome - Countryuser-addresses-home-countryPerson Data
Country of ResidencencccCountyOfResidenceHome - Countyuser-addresses-home-countyPerson Data
Mailing Address StreetmailingAddressStreetMailing - Street 1user-addresses-mailing-street1Person Data
Mailing Address CitymailingAddressCityMailing - Cityuser-addresses-mailing-cityPerson Data
Mailing Address StatemailingAddressStateMailing - Stateuser-addresses-mailing-statePerson Data
Mailing Address Zip CodemailingAddressZipCodeMailing - Zipuser-addresses-mailing-zipPerson Data
Mailing Address CountrymailingAddressCountryMailing - Countryuser-addresses-mailing-countryPerson Data
EmailemailAddressEmailuser-email-addressPerson Data
Emergency Contact 1 NamencccEmerContactNameEmergency Contact - First Name | Emergency Contact - Last Nameuser-emergency-contacts-first-name-* | user-emergency-contacts-last-name-*Emergency Contacts
Emergency Contact 1 PhonephoneEmergencyContactEmergency Contact - Cell Numberuser-emergency-contacts-cell-phone-number-*Emergency Contacts
Emergency Contact 1 RelationshipncccEmerRelationshipEmergency Contact - Relationship Descriptionuser-emergency-contacts-relationship-*Emergency Contacts
Emergency Contact 1 PrimaryncccMissingPersonContactEmergency Contact - Is Primary?user-emergency-contacts-is-primary-*Emergency Contacts
Emergency Contact 2 NamencccEmerContactName2Emergency Contact 2 - First Name | Emergency Contact 2 - Last Nameuser-emergency-contacts-first-name-* | user-emergency-contacts-last-name-*Emergency Contacts
Emergency Contact 2 PhonephoneEmergencyContact2Emergency Contact 2 - Cell Numberuser-emergency-contacts-cell-phone-number-*Emergency Contacts
Emergency Contact 2 RelationshipncccEmerRelationship2Emergency Contact 2 - Relationship Descriptionuser-emergency-contacts-relationship-*Emergency Contacts
Emergency Contact 2 PrimaryncccMissingPersonContact2Emergency Contact 2 - Is Primary?user-emergency-contacts-is-primary-*Emergency Contacts
High School NamehighSch1EnrolledNameSchool - Nameuser-education-schools-name-*Schools
High School CEEBhighSch1EnrolledCEEBSchool - CEEBuser-education-schools-ceeb-*Schools
High School CountryhighSch1AddressCountrySchool - Countryuser-education-schools-country-*Schools
High School Graduation StatusncccHighSchoolGraduateSchool - Graduateuser-education-schools-graduate-*Schools
High School Graduation DatenccchsDateSchool - End Dateuser-education-schools-end-*Schools
High School Start Date (derived)(derived 4 years prior to end)School - Start Dateuser-education-schools-start-*Schools
College 1 NamecollegeEnrolled1NameSchool - Nameuser-education-schools-name-*Schools
College 1 CEEBcollegeEnrolled1CEEBSchool - CEEBuser-education-schools-ceeb-*Schools
College 1 Countrycollege1AddressCountrySchool - Countryuser-education-schools-country-*Schools
College 1 Date FromcollegeEnrolled1DateFromSchool - Start Dateuser-education-schools-start-*Schools
College 1 Date TocollegeEnrolled1DateToSchool - End Dateuser-education-schools-end-*Schools
College 2 NamecollegeEnrolled2NameSchool - Nameuser-education-schools-name-*Schools
College 2 CEEBcollegeEnrolled2CEEBSchool - CEEBuser-education-schools-ceeb-*Schools
College 2 Countrycollege2AddressCountrySchool - Countryuser-education-schools-country-*Schools
College 2 Date FromcollegeEnrolled2DateFromSchool - Start Dateuser-education-schools-start-*Schools
College 2 Date TocollegeEnrolled2DateToSchool - End Dateuser-education-schools-end-*Schools
Student Educational LevelstudentHighestEducationalLvlStudent Education Leveluser-custom-{SUBDOM}-student-edu-levelCustom Fields
Father Educational Levelparent1EducationLevelParent 1 Education Leveluser-custom-{SUBDOM}-parent1-edu-levelCustom Fields
Mother Educational Levelparent2EducationLevelParent 2 Education Leveluser-custom-{SUBDOM}-parent2-edu-levelCustom Fields
Educational GoaleducationGoalsEducation Goaluser-custom-{SUBDOM}-education-goalCustom Fields
Employment StatusncccEmploymentStatusEmployment Statususer-custom-{SUBDOM}-employment-statusCustom Fields
VeteranynVeteranMilitary Serviceuser-custom-{SUBDOM}-military-serviceCustom Fields
Current branch of servicecurrentBranchOfServiceBranch of Serviceuser-custom-{SUBDOM}-service-branchCustom Fields
Active duty stationncccActiveDutyStationDuty Stationuser-custom-{SUBDOM}-duty-stationCustom Fields
Home of recordncccActiveHomeOfRecordMilitary Home of Recorduser-custom-{SUBDOM}-home-recordCustom Fields
Dependent - active militarydependentActiveMilitaryMilitary Dependentuser-custom-{SUBDOM}-dependent-typeCustom Fields
Dependent - educational benefitsdependentEdBenefitsMilitary Benefitsuser-custom-{SUBDOM}-va-bene-typeCustom Fields
Dependent - duty stationncccMilDepDutyStationMilitary Sponsor's Duty Stationuser-custom-{SUBDOM}-military-sponsor-dutyCustom Fields
Application Idid(not imported directly into Element, but used for other processes)
MajormajorCodeMajoruser-applications-major-*Applications
MajormajorsCTMajoruser-applications-major-*Applications
MajormajorsCTEStudyMajoruser-applications-major-*Applications
MajormajorsCIHSMajoruser-applications-major-*Applications
TermenrollmentTermTermuser-applications-term-*Applications
Student TypencccEntranceStatusStudent Typeuser-applications-student-type-*Applications
App Typecfnc_app_type(used for internal logic)
Registered atstartedApp Starteduser-applications-registered-at-*Applications
Submitted atcompletedApp Submitteduser-applications-submitted-time-*Applications
Applying for financial aidynApplyingForFinancialAidCFNC - Applying for Financial Aiduser-custom-{SUBDOM}-apply-for-financial-aidCustom Fields
Enrollment statusenrollmentStatusAcademic Loaduser-education-academic-loadPerson Data
Suspended/Expelled FlagynSuspendedExpelledCFNC - Expelled or Suspendeduser-custom-{SUBDOM}-expelled-or-suspendedCustom Fields
Suspension/Expulsion reasonncccsExpelledReasonCFNC - Expelled or Suspended Reasonuser-custom-{SUBDOM}-ncccsExpelledReasonCustom Fields

Validating Data in Colleague#

Below you can find the mapping of the Element fields above and where they should be going in Colleague.  Please note this should be reviewed in conjunction with the field mappings/UAT from the Colleague integration: Colleague UAT / Field Mappings

Community College Element → Colleague Field Mappings#

Element FieldElement SlugElement AreaColleague FieldColleague Screen
NC Student Number IDuser-identities-ncstudentnumberidIdentitiesXNC.HS.STU.IDXNCA
RCN IDuser-identities-rcnidIdentitiesXRDS.RES.CERT.NOXRDS
First Nameuser-first-namePerson DataFIRST.NAME | BIRTH.NAME.FIRST | PERSON.CHOSEN.FIRST.NAME | NAME.HISTORY.FIRST.NAMENAE
Middle Nameuser-middle-namePerson DataMIDDLE.NAME | BIRTH.NAME.MIDDLE | PERSON.CHOSEN.MIDDLE.NAME | NAME.HISTORY.MIDDLE.NAMENAE
Last Nameuser-last-namePerson DataLAST.NAME | BIRTH.NAME.LAST | PERSON.CHOSEN.LAST.NAME | NAME.HISTORY.LAST.NAMENAE
Name Prefixuser-suffix-namePerson DataPREFIXNAE
Name Suffixuser-prefix-namePerson DataSUFFIXNAE
Preferred First Nameuser-preferred-namePerson DataFIRST.NAME | PERSON.CHOSEN.FIRST.NAMENAE
Former Last Name(s)user-former-last-namePerson DataBIRTH.NAME.LASTNAE
Former Last Name(s)user-former-last-namePerson DataBIRTH.NAME.LASTNAE
Social Security #user-ssnPerson DataSSNNAE
Date of Birthuser-dobPerson DataBIRTH.DATENAE
Genderuser-genderPerson DataGENDERNAE
Primary Languageuser-citizenship-native-languagePerson DataPERSON.PRIMARY.LANGUAGENAE
Your Raceuser-race-categoriesPerson DataPER.RACESNAE
Are you Hispanic/Latino?user-race-hispanicPerson DataPER.ETHNICSNAE
CFNC - Homlesssnessuser-custom-{SUBDOM}-homeless-individualCustom FieldsXNC.HOMELESS.INDIVIDUALXNC3
CFNC - Foster Careuser-custom-{SUBDOM}-fostercare-youthCustom FieldsXNC.FOSTER.CARE.YOUTHXNC3
CFNC - Migrant or Farmworerkuser-custom-{SUBDOM}-migrant-farmworkerCustom FieldsXNC.MIGRANT.FARMWORKERXNC3
Citizenship Statususer-citizenship-us-statusPerson DataFPER.ALIEN.STATUSFPER
CFNC - Immigration Statususer-custom-{SUBDOM}-immigrationStatusCustom FieldsFPER
Country of Citizenshipuser-citizenship-countryPerson DataCITIZENSHIPFPER
Visa Typeuser-citizenship-visa-typePerson DataVISA.TYPEFPER
Permanent Resident Numberuser-citizenship-permanent-resident-numberPerson DataALIEN.IDFPER
Home Phoneuser-phone-home-country-code | user-phone-home-numberPerson DataPERSONAL.PHONE.NUMBER & PERSONAL.PHONE.TYPENAE
Cell Phoneuser-phone-cell-country-code | user-phone-cell-numberPerson DataPERSONAL.PHONE.NUMBER & PERSONAL.PHONE.TYPENAE
Home - Street 1user-addresses-home-street1Person DataADDRESS.LINESNAE/ADDR
Home - Cityuser-addresses-home-cityPerson DataCITYNAE/ADDR
Home - Stateuser-addresses-home-statePerson DataSTATE | RESIDENCE.STATENAE/ADDR
Home - Zipuser-addresses-home-zipPerson DataZIPNAE/ADDR
Home - Countryuser-addresses-home-countryPerson DataCOUNTRYNAE/ADDR
Home - Countyuser-addresses-home-countyPerson DataCOUNTY | RESIDENCE.COUNTYNAE/ADDR
Mailing - Street 1user-addresses-mailing-street1Person DataADDRESS.LINESNAE/ADDR
Mailing - Cityuser-addresses-mailing-cityPerson DataCITYNAE/ADDR
Mailing - Stateuser-addresses-mailing-statePerson DataSTATENAE/ADDR
Mailing - Zipuser-addresses-mailing-zipPerson DataZIPNAE/ADDR
Mailing - Countryuser-addresses-mailing-countryPerson DataCOUNTRYNAE/ADDR
Emailuser-email-addressPerson DataPERSON.EMAIL.ADDRESSES & PERSON.EMAIL.TYPESNAE
Emergency Contact - First Name | Emergency Contact - Last Nameuser-emergency-contacts-first-name-* | user-emergency-contacts-last-name-*Emergency ContactsEMER.NAMEEMPC
Emergency Contact - Cell Numberuser-emergency-contacts-cell-phone-number-*Emergency ContactsEMER.DAYTIME.PHONEEMPC
Emergency Contact - Relationship Descriptionuser-emergency-contacts-relationship-*Emergency ContactsEMER.RELATIONSHIPEMPC
Emergency Contact - Is Primary?user-emergency-contacts-is-primary-*Emergency Contacts(Sets the contact as a Missing Person contact if true)EMPC
Emergency Contact 2 - First Name | Emergency Contact 2 - Last Nameuser-emergency-contacts-first-name-* | user-emergency-contacts-last-name-*Emergency ContactsEMER.NAMEEMPC
Emergency Contact 2 - Cell Numberuser-emergency-contacts-cell-phone-number-*Emergency ContactsEMER.DAYTIME.PHONEEMPC
Emergency Contact 2 - Relationship Descriptionuser-emergency-contacts-relationship-*Emergency ContactsEMER.RELATIONSHIPEMPC
Emergency Contact 2 - Is Primary?user-emergency-contacts-is-primary-*Emergency Contacts(Sets the contact as a Missing Person contact if true)EMPC
School - CEEBuser-education-schools-ceeb-*SchoolsINSTA.INSTITUTIONS.IDIASU
School - End Dateuser-education-schools-end-*SchoolsINSTA.END.DATESIASU
School - Start Dateuser-education-schools-start-*SchoolsINSTA.START.DATESIASU
School - Graduatation Dateuser-education-schools-graduate_date-*SchoolsINSTA.INTG.HS.GRAD.DATEIASU
School - GPAuser-education-schools-gpa-*SchoolsINSTA.EXT.GPAIASU
School - CEEBuser-education-schools-ceeb-*SchoolsINSTA.INSTITUTIONS.IDIASU
School - Start Dateuser-education-schools-start-*SchoolsINSTA.END.DATESIASU
School - End Dateuser-education-schools-end-*SchoolsINSTA.START.DATESIASU
School - Graduatation Dateuser-education-schools-graduate_date-*SchoolsINSTA.INTG.HS.GRAD.DATEIASU
School - GPAuser-education-schools-gpa-*SchoolsINSTA.EXT.GPAIASU
School - CEEBuser-education-schools-ceeb-*SchoolsINSTA.INSTITUTIONS.IDIASU
School - Start Dateuser-education-schools-start-*SchoolsINSTA.END.DATESIASU
School - End Dateuser-education-schools-end-*SchoolsINSTA.START.DATESIASU
School - Graduatation Dateuser-education-schools-graduate_date-*SchoolsINSTA.INTG.HS.GRAD.DATEIASU
School - GPAuser-education-schools-gpa-*SchoolsINSTA.EXT.GPAIASU
Student Education Leveluser-custom-{SUBDOM}-student-edu-levelCustom FieldsXNC.EDUCATIONAL.LEVELXNCA
Parent 1 Education Leveluser-custom-{SUBDOM}-parent1-edu-levelCustom FieldsXNC.PARENT1.EDUCATION.LEVELXNC3
Parent 2 Education Leveluser-custom-{SUBDOM}-parent2-edu-levelCustom FieldsXNC.PARENT2.EDUCATION.LEVELXNC3
Education Goaluser-custom-{SUBDOM}-education-goalCustom FieldsAPP.ORIG.EDUC.GOALAPPN/SHAP
Employment Statususer-custom-{SUBDOM}-employment-statusCustom FieldsPERSON.OVRL.EMP.STATXNCA/EMPL
Military Serviceuser-custom-{SUBDOM}-military-serviceCustom FieldsXNC.VETERAN.STATUSXNCA
Branch of Serviceuser-custom-{SUBDOM}-service-branchCustom FieldsXNC.ACTIVE.DUTY.BRANCHXNCA
Military Dependentuser-custom-{SUBDOM}-dependent-typeCustom FieldsXNC.ACTIVE.DUTY.DEPENDXNCA
Registration Iduser-applications-registration-id-*ApplicationsAPPL.NO
Majoruser-applications-major-*ApplicationsAPPL.ACAD.PROGRAMAPPN/SHAP
Majoruser-applications-major-*ApplicationsAPPL.ACAD.PROGRAMAPPN/SHAP
Majoruser-applications-major-*ApplicationsAPPL.ACAD.PROGRAMAPPN/SHAP
Majoruser-applications-major-*ApplicationsAPPL.ACAD.PROGRAMAPPN/SHAP
Termuser-applications-term-*ApplicationsAPPL.START.TERMAPPN/SHAP
Student Typeuser-applications-student-type-*ApplicationsAPPL.SADMIT.STATUSAPPN/SHAP
App Submitteduser-applications-submitted-time-*ApplicationsAPPL.STATUS.DATEAPPN/SHAP
Degreeuser-applications-degree-*ApplicationsEXTERNAL.ACAD.CREDS.ID
Campususer-applications-campus-*ApplicationsAPPL.LOCATIONSAPPN/SHAP
Academic Loaduser-education-academic-loadPerson DataAPPL.STUDENT.LOAD.INTENTAPPN/SHAP
CFNC - Expelled or Suspendeduser-custom-{SUBDOM}-expelled-or-suspendedCustom FieldsXNC.EXPELLED.SUSPENDEDXNCA