CFNC UAT / Field Mappings
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:
- If there are errors:
- Review Integration Errors - Troubleshooting (CFNC)
- If needed, reach out in Basecamp for assistance.
- If the record is successful:
- Proceed to validate the data in Element
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 Field | CFNC Field ID | Element Field | Element Slug | Element Area |
|---|---|---|---|---|
| CFNC Id | cfncUserId | CFNC ID | user-identities-cfncid | Identities |
| NC Student Id (escholar Id) | ncStudentNumber | NC Student Number ID | user-identities-ncstudentnumberid | Identities |
| RCN ID | rcnNumber | RCN ID | user-identities-rcnid | Identities |
| First name | studentNameFirst | First Name | user-first-name | Person Data |
| Middle name | studentNameMiddle | Middle Name | user-middle-name | Person Data |
| Last name | studentNameLast | Last Name | user-last-name | Person Data |
| Prefix | studentNamePrefix | Name Prefix | user-suffix-name | Person Data |
| Suffix | studentNameSuffix | Name Suffix | user-prefix-name | Person Data |
| Preferred first name | studentNamePreferredFirstName | Preferred First Name | user-preferred-name | Person Data |
| Former last name | studentPreviousName1Last | Former Last Name(s) | user-former-last-name | Person Data |
| Former last name 2 (if first doesn't exist) | studentPreviousName2Last | Former Last Name(s) | user-former-last-name | Person Data |
| SSN | socialSecurityNumber | Social Security # | user-ssn | Person Data |
| Date of Brith | dateOfBirth | Date of Birth | user-dob | Person Data |
| Gender | sex | Gender | user-gender | Person Data |
| Primary Language | firstLanguage | Primary Language | user-citizenship-native-language | Person Data |
| Races | uncRace | Your Race | user-race-categories | Person Data |
| Hispanic/Latino | uncynAreYouHispanicOrLatino | Are you Hispanic/Latino? | user-race-hispanic | Person Data |
| Homeless indicator | homelessIndividual | CFNC - Homlesssness | user-custom-{SUBDOM}-homeless-individual | Custom Fields |
| Foster care | fosterCare | CFNC - Foster Care | user-custom-{SUBDOM}-fostercare-youth | Custom Fields |
| Migrant farmworker | migrantFarmworker | CFNC - Migrant or Farmworerk | user-custom-{SUBDOM}-migrant-farmworker | Custom Fields |
| Citizenship status | ncccCitizenship | Citizenship Status | user-citizenship-us-status | Person Data |
| Immigration status | immigrationStatus | CFNC - Immigration Status | user-custom-{SUBDOM}-immigrationStatus | Custom Fields |
| Country of citizenship | countryOfCitizenship | Country of Citizenship | user-citizenship-country | Person Data |
| Visa type | ncccVisaType | Visa Type | user-citizenship-visa-type | Person Data |
| Permanent resident number | permanentResidentNumber | Permanent Resident Number | user-citizenship-permanent-resident-number | Person Data |
| Home phone | phonePermanentAddress | Home Phone | user-phone-home-country-code | user-phone-home-number | Person Data |
| Cell phone | phoneCell | Cell Phone | user-phone-cell-country-code | user-phone-cell-number | Person Data |
| Text mesage opt-in flags 3 | authorizeText3 | Opt in for SMS | user-sms-updates | Person Data |
| Permanent Address Street | permanentAddressStreet | Home - Street 1 | user-addresses-home-street1 | Person Data |
| Permanent Address City | permanentAddressCity | Home - City | user-addresses-home-city | Person Data |
| Permanent Address State | permanentAddressState | Home - State | user-addresses-home-state | Person Data |
| Permanent Address Zip Code | permanentAddressZipCode | Home - Zip | user-addresses-home-zip | Person Data |
| Permanent Address Country | permanentAddressCountry | Home - Country | user-addresses-home-country | Person Data |
| Country of Residence | ncccCountyOfResidence | Home - County | user-addresses-home-county | Person Data |
| Mailing Address Street | mailingAddressStreet | Mailing - Street 1 | user-addresses-mailing-street1 | Person Data |
| Mailing Address City | mailingAddressCity | Mailing - City | user-addresses-mailing-city | Person Data |
| Mailing Address State | mailingAddressState | Mailing - State | user-addresses-mailing-state | Person Data |
| Mailing Address Zip Code | mailingAddressZipCode | Mailing - Zip | user-addresses-mailing-zip | Person Data |
| Mailing Address Country | mailingAddressCountry | Mailing - Country | user-addresses-mailing-country | Person Data |
| emailAddress | user-email-address | Person Data | ||
| Emergency Contact 1 Name | ncccEmerContactName | Emergency Contact - First Name | Emergency Contact - Last Name | user-emergency-contacts-first-name-* | user-emergency-contacts-last-name-* | Emergency Contacts |
| Emergency Contact 1 Phone | phoneEmergencyContact | Emergency Contact - Cell Number | user-emergency-contacts-cell-phone-number-* | Emergency Contacts |
| Emergency Contact 1 Relationship | ncccEmerRelationship | Emergency Contact - Relationship Description | user-emergency-contacts-relationship-* | Emergency Contacts |
| Emergency Contact 1 Primary | ncccMissingPersonContact | Emergency Contact - Is Primary? | user-emergency-contacts-is-primary-* | Emergency Contacts |
| Emergency Contact 2 Name | ncccEmerContactName2 | Emergency Contact 2 - First Name | Emergency Contact 2 - Last Name | user-emergency-contacts-first-name-* | user-emergency-contacts-last-name-* | Emergency Contacts |
| Emergency Contact 2 Phone | phoneEmergencyContact2 | Emergency Contact 2 - Cell Number | user-emergency-contacts-cell-phone-number-* | Emergency Contacts |
| Emergency Contact 2 Relationship | ncccEmerRelationship2 | Emergency Contact 2 - Relationship Description | user-emergency-contacts-relationship-* | Emergency Contacts |
| Emergency Contact 2 Primary | ncccMissingPersonContact2 | Emergency Contact 2 - Is Primary? | user-emergency-contacts-is-primary-* | Emergency Contacts |
| High School Name | highSch1EnrolledName | School - Name | user-education-schools-name-* | Schools |
| High School CEEB | highSch1EnrolledCEEB | School - CEEB | user-education-schools-ceeb-* | Schools |
| High School Country | highSch1AddressCountry | School - Country | user-education-schools-country-* | Schools |
| High School Graduation Status | ncccHighSchoolGraduate | School - Graduate | user-education-schools-graduate-* | Schools |
| High School Graduation Date | nccchsDate | School - End Date | user-education-schools-end-* | Schools |
| High School Start Date (derived) | (derived 4 years prior to end) | School - Start Date | user-education-schools-start-* | Schools |
| College 1 Name | collegeEnrolled1Name | School - Name | user-education-schools-name-* | Schools |
| College 1 CEEB | collegeEnrolled1CEEB | School - CEEB | user-education-schools-ceeb-* | Schools |
| College 1 Country | college1AddressCountry | School - Country | user-education-schools-country-* | Schools |
| College 1 Date From | collegeEnrolled1DateFrom | School - Start Date | user-education-schools-start-* | Schools |
| College 1 Date To | collegeEnrolled1DateTo | School - End Date | user-education-schools-end-* | Schools |
| College 2 Name | collegeEnrolled2Name | School - Name | user-education-schools-name-* | Schools |
| College 2 CEEB | collegeEnrolled2CEEB | School - CEEB | user-education-schools-ceeb-* | Schools |
| College 2 Country | college2AddressCountry | School - Country | user-education-schools-country-* | Schools |
| College 2 Date From | collegeEnrolled2DateFrom | School - Start Date | user-education-schools-start-* | Schools |
| College 2 Date To | collegeEnrolled2DateTo | School - End Date | user-education-schools-end-* | Schools |
| Student Educational Level | studentHighestEducationalLvl | Student Education Level | user-custom-{SUBDOM}-student-edu-level | Custom Fields |
| Father Educational Level | parent1EducationLevel | Parent 1 Education Level | user-custom-{SUBDOM}-parent1-edu-level | Custom Fields |
| Mother Educational Level | parent2EducationLevel | Parent 2 Education Level | user-custom-{SUBDOM}-parent2-edu-level | Custom Fields |
| Educational Goal | educationGoals | Education Goal | user-custom-{SUBDOM}-education-goal | Custom Fields |
| Employment Status | ncccEmploymentStatus | Employment Status | user-custom-{SUBDOM}-employment-status | Custom Fields |
| Veteran | ynVeteran | Military Service | user-custom-{SUBDOM}-military-service | Custom Fields |
| Current branch of service | currentBranchOfService | Branch of Service | user-custom-{SUBDOM}-service-branch | Custom Fields |
| Active duty station | ncccActiveDutyStation | Duty Station | user-custom-{SUBDOM}-duty-station | Custom Fields |
| Home of record | ncccActiveHomeOfRecord | Military Home of Record | user-custom-{SUBDOM}-home-record | Custom Fields |
| Dependent - active military | dependentActiveMilitary | Military Dependent | user-custom-{SUBDOM}-dependent-type | Custom Fields |
| Dependent - educational benefits | dependentEdBenefits | Military Benefits | user-custom-{SUBDOM}-va-bene-type | Custom Fields |
| Dependent - duty station | ncccMilDepDutyStation | Military Sponsor's Duty Station | user-custom-{SUBDOM}-military-sponsor-duty | Custom Fields |
| Application Id | id | (not imported directly into Element, but used for other processes) | ||
| Major | majorCode | Major | user-applications-major-* | Applications |
| Major | majorsCT | Major | user-applications-major-* | Applications |
| Major | majorsCTEStudy | Major | user-applications-major-* | Applications |
| Major | majorsCIHS | Major | user-applications-major-* | Applications |
| Term | enrollmentTerm | Term | user-applications-term-* | Applications |
| Student Type | ncccEntranceStatus | Student Type | user-applications-student-type-* | Applications |
| App Type | cfnc_app_type | (used for internal logic) | ||
| Registered at | started | App Started | user-applications-registered-at-* | Applications |
| Submitted at | completed | App Submitted | user-applications-submitted-time-* | Applications |
| Applying for financial aid | ynApplyingForFinancialAid | CFNC - Applying for Financial Aid | user-custom-{SUBDOM}-apply-for-financial-aid | Custom Fields |
| Enrollment status | enrollmentStatus | Academic Load | user-education-academic-load | Person Data |
| Suspended/Expelled Flag | ynSuspendedExpelled | CFNC - Expelled or Suspended | user-custom-{SUBDOM}-expelled-or-suspended | Custom Fields |
| Suspension/Expulsion reason | ncccsExpelledReason | CFNC - Expelled or Suspended Reason | user-custom-{SUBDOM}-ncccsExpelledReason | Custom 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 Field | Element Slug | Element Area | Colleague Field | Colleague Screen |
|---|---|---|---|---|
| NC Student Number ID | user-identities-ncstudentnumberid | Identities | XNC.HS.STU.ID | XNCA |
| RCN ID | user-identities-rcnid | Identities | XRDS.RES.CERT.NO | XRDS |
| First Name | user-first-name | Person Data | FIRST.NAME | BIRTH.NAME.FIRST | PERSON.CHOSEN.FIRST.NAME | NAME.HISTORY.FIRST.NAME | NAE |
| Middle Name | user-middle-name | Person Data | MIDDLE.NAME | BIRTH.NAME.MIDDLE | PERSON.CHOSEN.MIDDLE.NAME | NAME.HISTORY.MIDDLE.NAME | NAE |
| Last Name | user-last-name | Person Data | LAST.NAME | BIRTH.NAME.LAST | PERSON.CHOSEN.LAST.NAME | NAME.HISTORY.LAST.NAME | NAE |
| Name Prefix | user-suffix-name | Person Data | PREFIX | NAE |
| Name Suffix | user-prefix-name | Person Data | SUFFIX | NAE |
| Preferred First Name | user-preferred-name | Person Data | FIRST.NAME | PERSON.CHOSEN.FIRST.NAME | NAE |
| Former Last Name(s) | user-former-last-name | Person Data | BIRTH.NAME.LAST | NAE |
| Former Last Name(s) | user-former-last-name | Person Data | BIRTH.NAME.LAST | NAE |
| Social Security # | user-ssn | Person Data | SSN | NAE |
| Date of Birth | user-dob | Person Data | BIRTH.DATE | NAE |
| Gender | user-gender | Person Data | GENDER | NAE |
| Primary Language | user-citizenship-native-language | Person Data | PERSON.PRIMARY.LANGUAGE | NAE |
| Your Race | user-race-categories | Person Data | PER.RACES | NAE |
| Are you Hispanic/Latino? | user-race-hispanic | Person Data | PER.ETHNICS | NAE |
| CFNC - Homlesssness | user-custom-{SUBDOM}-homeless-individual | Custom Fields | XNC.HOMELESS.INDIVIDUAL | XNC3 |
| CFNC - Foster Care | user-custom-{SUBDOM}-fostercare-youth | Custom Fields | XNC.FOSTER.CARE.YOUTH | XNC3 |
| CFNC - Migrant or Farmworerk | user-custom-{SUBDOM}-migrant-farmworker | Custom Fields | XNC.MIGRANT.FARMWORKER | XNC3 |
| Citizenship Status | user-citizenship-us-status | Person Data | FPER.ALIEN.STATUS | FPER |
| CFNC - Immigration Status | user-custom-{SUBDOM}-immigrationStatus | Custom Fields | FPER | |
| Country of Citizenship | user-citizenship-country | Person Data | CITIZENSHIP | FPER |
| Visa Type | user-citizenship-visa-type | Person Data | VISA.TYPE | FPER |
| Permanent Resident Number | user-citizenship-permanent-resident-number | Person Data | ALIEN.ID | FPER |
| Home Phone | user-phone-home-country-code | user-phone-home-number | Person Data | PERSONAL.PHONE.NUMBER & PERSONAL.PHONE.TYPE | NAE |
| Cell Phone | user-phone-cell-country-code | user-phone-cell-number | Person Data | PERSONAL.PHONE.NUMBER & PERSONAL.PHONE.TYPE | NAE |
| Home - Street 1 | user-addresses-home-street1 | Person Data | ADDRESS.LINES | NAE/ADDR |
| Home - City | user-addresses-home-city | Person Data | CITY | NAE/ADDR |
| Home - State | user-addresses-home-state | Person Data | STATE | RESIDENCE.STATE | NAE/ADDR |
| Home - Zip | user-addresses-home-zip | Person Data | ZIP | NAE/ADDR |
| Home - Country | user-addresses-home-country | Person Data | COUNTRY | NAE/ADDR |
| Home - County | user-addresses-home-county | Person Data | COUNTY | RESIDENCE.COUNTY | NAE/ADDR |
| Mailing - Street 1 | user-addresses-mailing-street1 | Person Data | ADDRESS.LINES | NAE/ADDR |
| Mailing - City | user-addresses-mailing-city | Person Data | CITY | NAE/ADDR |
| Mailing - State | user-addresses-mailing-state | Person Data | STATE | NAE/ADDR |
| Mailing - Zip | user-addresses-mailing-zip | Person Data | ZIP | NAE/ADDR |
| Mailing - Country | user-addresses-mailing-country | Person Data | COUNTRY | NAE/ADDR |
| user-email-address | Person Data | PERSON.EMAIL.ADDRESSES & PERSON.EMAIL.TYPES | NAE | |
| Emergency Contact - First Name | Emergency Contact - Last Name | user-emergency-contacts-first-name-* | user-emergency-contacts-last-name-* | Emergency Contacts | EMER.NAME | EMPC |
| Emergency Contact - Cell Number | user-emergency-contacts-cell-phone-number-* | Emergency Contacts | EMER.DAYTIME.PHONE | EMPC |
| Emergency Contact - Relationship Description | user-emergency-contacts-relationship-* | Emergency Contacts | EMER.RELATIONSHIP | EMPC |
| 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 Name | user-emergency-contacts-first-name-* | user-emergency-contacts-last-name-* | Emergency Contacts | EMER.NAME | EMPC |
| Emergency Contact 2 - Cell Number | user-emergency-contacts-cell-phone-number-* | Emergency Contacts | EMER.DAYTIME.PHONE | EMPC |
| Emergency Contact 2 - Relationship Description | user-emergency-contacts-relationship-* | Emergency Contacts | EMER.RELATIONSHIP | EMPC |
| Emergency Contact 2 - Is Primary? | user-emergency-contacts-is-primary-* | Emergency Contacts | (Sets the contact as a Missing Person contact if true) | EMPC |
| School - CEEB | user-education-schools-ceeb-* | Schools | INSTA.INSTITUTIONS.ID | IASU |
| School - End Date | user-education-schools-end-* | Schools | INSTA.END.DATES | IASU |
| School - Start Date | user-education-schools-start-* | Schools | INSTA.START.DATES | IASU |
| School - Graduatation Date | user-education-schools-graduate_date-* | Schools | INSTA.INTG.HS.GRAD.DATE | IASU |
| School - GPA | user-education-schools-gpa-* | Schools | INSTA.EXT.GPA | IASU |
| School - CEEB | user-education-schools-ceeb-* | Schools | INSTA.INSTITUTIONS.ID | IASU |
| School - Start Date | user-education-schools-start-* | Schools | INSTA.END.DATES | IASU |
| School - End Date | user-education-schools-end-* | Schools | INSTA.START.DATES | IASU |
| School - Graduatation Date | user-education-schools-graduate_date-* | Schools | INSTA.INTG.HS.GRAD.DATE | IASU |
| School - GPA | user-education-schools-gpa-* | Schools | INSTA.EXT.GPA | IASU |
| School - CEEB | user-education-schools-ceeb-* | Schools | INSTA.INSTITUTIONS.ID | IASU |
| School - Start Date | user-education-schools-start-* | Schools | INSTA.END.DATES | IASU |
| School - End Date | user-education-schools-end-* | Schools | INSTA.START.DATES | IASU |
| School - Graduatation Date | user-education-schools-graduate_date-* | Schools | INSTA.INTG.HS.GRAD.DATE | IASU |
| School - GPA | user-education-schools-gpa-* | Schools | INSTA.EXT.GPA | IASU |
| Student Education Level | user-custom-{SUBDOM}-student-edu-level | Custom Fields | XNC.EDUCATIONAL.LEVEL | XNCA |
| Parent 1 Education Level | user-custom-{SUBDOM}-parent1-edu-level | Custom Fields | XNC.PARENT1.EDUCATION.LEVEL | XNC3 |
| Parent 2 Education Level | user-custom-{SUBDOM}-parent2-edu-level | Custom Fields | XNC.PARENT2.EDUCATION.LEVEL | XNC3 |
| Education Goal | user-custom-{SUBDOM}-education-goal | Custom Fields | APP.ORIG.EDUC.GOAL | APPN/SHAP |
| Employment Status | user-custom-{SUBDOM}-employment-status | Custom Fields | PERSON.OVRL.EMP.STAT | XNCA/EMPL |
| Military Service | user-custom-{SUBDOM}-military-service | Custom Fields | XNC.VETERAN.STATUS | XNCA |
| Branch of Service | user-custom-{SUBDOM}-service-branch | Custom Fields | XNC.ACTIVE.DUTY.BRANCH | XNCA |
| Military Dependent | user-custom-{SUBDOM}-dependent-type | Custom Fields | XNC.ACTIVE.DUTY.DEPEND | XNCA |
| Registration Id | user-applications-registration-id-* | Applications | APPL.NO | |
| Major | user-applications-major-* | Applications | APPL.ACAD.PROGRAM | APPN/SHAP |
| Major | user-applications-major-* | Applications | APPL.ACAD.PROGRAM | APPN/SHAP |
| Major | user-applications-major-* | Applications | APPL.ACAD.PROGRAM | APPN/SHAP |
| Major | user-applications-major-* | Applications | APPL.ACAD.PROGRAM | APPN/SHAP |
| Term | user-applications-term-* | Applications | APPL.START.TERM | APPN/SHAP |
| Student Type | user-applications-student-type-* | Applications | APPL.SADMIT.STATUS | APPN/SHAP |
| App Submitted | user-applications-submitted-time-* | Applications | APPL.STATUS.DATE | APPN/SHAP |
| Degree | user-applications-degree-* | Applications | EXTERNAL.ACAD.CREDS.ID | |
| Campus | user-applications-campus-* | Applications | APPL.LOCATIONS | APPN/SHAP |
| Academic Load | user-education-academic-load | Person Data | APPL.STUDENT.LOAD.INTENT | APPN/SHAP |
| CFNC - Expelled or Suspended | user-custom-{SUBDOM}-expelled-or-suspended | Custom Fields | XNC.EXPELLED.SUSPENDED | XNCA |