CCCApply International SuperGlue Data Mappings - Banner
- Patricia Donohue
The tables below pertain to the CCCApply International application.
Contents
International Data Fields Table Mapping - Banner
For more details, see the CCCApply International Application data dictionary.
College Adaptor Payload Field | CCC Field Name | Banner DB Staging Table | Banner Field Name | VERSION Release |
|---|---|---|---|---|
appId | app_id | SZRINTL | APP_ID |
|
cccId | ccc_id | SZRINTL | CCC_ID |
|
collegeId | college_id | SZRINTL | COLLEGE_ID |
|
addressVerified | address_verified | SZRINTL | ADDRESS_VERIFIED |
|
agentPhoneExt | agent_phone_ext | SZRINTL | AGENT_PHONE_EXT |
|
agentPhoneNumber | agent_phone_number | SZRINTL | AGENT_PHONE_NUMBER |
|
altNonUsPhoneAuthTxt | alt_non_us_phone_auth_txt | SZRINTL | ALT_NON_US_PHONE_AUTH_TXT |
|
altNonUsPhoneExt | alt_non_us_phone_ext | SZRINTL | ALT_NON_US_PHONE_EXT |
|
altNonUsPhoneNumber | alt_non_us_phone_number | SZRINTL | ALT_NON_US_PHONE_NUMBER |
|
appLang | app_lang | SZRINTL | APP_LANG |
|
authorizeAgentInfoRelease | authorize_agent_info_release | SZRINTL | AUTHORIZE_AGENT_INFO_RELEASE |
|
birthdate | birthdate | SZRINTL | BIRTH_DATE |
|
campaign1 | campaign1 | SZRINTL | CAMPAIGN1 |
|
coenrollConfirm | coenroll_confirm | SZRINTL | COENROLL_CONFIRM |
|
campaign2 | campaign2 | SZRINTL | CAMPAIGN2 |
|
campaign3 | campaign3 | SZRINTL | CAMPAIGN3 |
|
citizenshipStatus | citizenship_status | SZRINTL | CITIZENSHIP_STATUS |
|
city | city | SZRINTL | CITY |
|
col1Cds | col1_cds | SZRINTL | COL1_CDS |
|
col1CdsFull | col1_cds_full | SZRINTL | COL1_CDS_FULL |
|
col1Ceeb | col1_ceeb | SZRINTL | COL1_CEEB |
|
col1City | col1_city | SZRINTL | COL1_CITY |
|
col1CollegeAttendedId | col1_college_attended_id | SZRINTL | COL1_COLLEGE_ATTENDED_ID |
|
col1Country | col1_country | SZRINTL | COL1_COUNTRY |
|
col1DegreeDate | col1_degree_date | SZRINTL | COL1_DEGREE_DATE |
|
col1DegreeObtained | col1_degree_obtained | SZRINTL | COL1_DEGREE_OBTAINED |
|
col1EndDate | col1_end_date | SZRINTL | COL1_END_DATE |
|
col1ExpelledStatus | col1_expelled_status | SZRINTL | COL1_EXPELLED_STATUS |
|
col1Major | col1_major | SZRINTL | COL1_MAJOR |
|
col1Name | col1_name | SZRINTL | COL1_NAME |
|
col1NonUsProvince | col1_non_us_province | SZRINTL | COL1_NON_US_PROVINCE |
|
col1NotListed | col1_not_listed | SZRINTL | COL1_NOT_LISTED |
|
col1PrimaryInstructionLanguage | col1_primary_instruction_language | SZRINTL | COL1_PRIMARY_INSTR_LANG |
|
col1StartDate | col1_start_date | SZRINTL | COL1_START_DATE |
|
col1State | col1_state | SZRINTL | COL1_STATE |
|
col2Cds | col2_cds | SZRINTL | COL2_CDS |
|
col2CdsFull | col2_cds_full | SZRINTL | COL2_CDS_FULL |
|
col2Ceeb | col2_ceeb | SZRINTL | COL2_CEEB |
|
col2City | col2_city | SZRINTL | COL2_CITY |
|
col2CollegeAttendedId | col2_college_attended_id | SZRINTL | COL2_COLLEGE_ATTENDED_ID |
|
col2Country | col2_country | SZRINTL | COL2_COUNTRY |
|
col2DegreeDate | col2_degree_date | SZRINTL | COL2_DEGREE_DATE |
|
col2DegreeObtained | col2_degree_obtained | SZRINTL | COL2_DEGREE_OBTAINED |
|
col2EndDate | col2_end_date | SZRINTL | COL2_END_DATE |
|
col2ExpelledStatus | col2_expelled_status | SZRINTL | COL2_EXPELLED_STATUS |
|
col2Major | col2_major | SZRINTL | COL2_MAJOR |
|
col2Name | col2_name | SZRINTL | COL2_NAME |
|
col2NonUsProvince | col2_non_us_province | SZRINTL | COL2_NON_US_PROVINCE |
|
col2NotListed | col2_not_listed | SZRINTL | COL2_NOT_LISTED |
|
col2PrimaryInstructionLanguage | col2_primary_instruction_language | SZRINTL | COL2_PRIMARY_INSTR_LANG |
|
col2StartDate | col2_start_date | SZRINTL | COL2_START_DATE |
|
col2State | col2_state | SZRINTL | COL2_STATE |
|
col3Cds | col3_cds | SZRINTL | COL3_CDS |
|
col3CdsFull | col3_cds_full | SZRINTL | COL3_CDS_FULL |
|
col3Ceeb | col3_ceeb | SZRINTL | COL3_CEEB |
|
col3City | col3_city | SZRINTL | COL3_CITY |
|
col3CollegeAttendedId | col3_college_attended_id | SZRINTL | COL3_COLLEGE_ATTENDED_ID |
|
col3Country | col3_country | SZRINTL | COL3_COUNTRY |
|
col3DegreeDate | col3_degree_date | SZRINTL | COL3_DEGREE_DATE |
|
col3DegreeObtained | col3_degree_obtained | SZRINTL | COL3_DEGREE_OBTAINED |
|
col3EndDate | col3_end_date | SZRINTL | COL3_END_DATE |
|
col3ExpelledStatus | col3_expelled_status | SZRINTL | COL3_EXPELLED_STATUS |
|
col3Major | col3_major | SZRINTL | COL3_MAJOR |
|
col3Name | col3_name | SZRINTL | COL3_NAME |
|
col3NonUsProvince | col3_non_us_province | SZRINTL | COL3_NON_US_PROVINCE |
|
col3NotListed | col3_not_listed | SZRINTL | COL3_NOT_LISTED |
|
col3PrimaryInstructionLanguage | col3_primary_instruction_language | SZRINTL | COL3_PRIMARY_INSTR_LANG |
|
col3StartDate | col3_start_date | SZRINTL | COL3_START_DATE |
|
col3State | col3_state | SZRINTL | COL3_STATE |
|
col4Cds | col4_cds | SZRINTL | COL4_CDS |
|
col4CdsFull | col4_cds_full | SXRINTL | COL4_CDS_FULL |
|
col4Ceeb | col4_ceeb | SZRINTL | COL4_CEEB |
|
col4City | col4_city | SZRINTL | COL4_CITY |
|
col4CollegeAttendedId | col4_college_attended_id | SZRINTL | COL4_COLLEGE_ATTENDED_ID |
|
col4Country | col4_country | SZRINTL | COL4_COUNTRY |
|
col4DegreeDate | col4_degree_date | SZRINTL | COL4_DEGREE_DATE |
|
col4DegreeObtained | col4_degree_obtained | SZRINTL | COL4_DEGREE_OBTAINED |
|
col4EndDate | col4_end_date | SZRINTL | COL4_END_DATE |
|
col4ExpelledStatus | col4_expelled_status | SZRINTL | COL4_EXPELLED_STATUS |
|
col4Major | col4_major | SZRINTL | COL4_MAJOR |
|
col4Name | col4_name | SZRINTL | COL4_NAME |
|
col4NonUsProvince | col4_non_us_province | SZRINTL | COL4_NON_US_PROVINCE |
|
col4NotListed | col4_not_listed | SZRINTL | COL4_NOT_LISTED |
|
col4PrimaryInstructionLanguage | col4_primary_instruction_language | SZRINTL | COL4_PRIMARY_INSTR_LANG |
|
col4StartDate | col4_start_date | SZRINTL | COL4_START_DATE |
|
col4State | col4_state | SZRINTL | COL4_STATE |
|
collegeCompDate | college_comp_date | SZRINTL | COLLEGE_COMP_DATE |
|
collegeCount | college_count | SZRINTL | COLLEGE_COUNT |
|
collegeEduLevel | college_edu_level | SZRINTL | COLLEGE_EDU_LEVEL |
|
collegeExpelledSummary | college_expelled_summary | SZRINTL | COLLEGE_EXPELLED_SUMMARY |
|
collegeName | college_name | SZRINTL | COLLEGE_NAME |
|
company | company | SZRINTL | CURR_MAILNG_CITY |
|
confirmation | confirmation | SZRINTL | CURR_MAILNG_COUNTRY |
|
consent | consent | SZRINTL | CURR_MAILNG_NON_US_ADDRESS |
|
contact | contact | SZRINTL | CURR_MAILNG_NON_US_POSTAL_CODE |
|
country | country | SZRINTL | CURR_MAILNG_NON_US_PROVINCE |
|
countryOfBirth | country_of_birth | SZRINTL | COUNTRY_OF_BIRTH |
|
countryOfCitizenship | country_of_citizenship | SZRINTL | COUNTRY_OF_CITIZENSHIP |
|
cryptokeyid | cryptokeyid |
| ||
currentMailingAddressOutsideUs | current_mailing_address_outside_us | SZRINTL | CURR_MAILNG_ADDR_OUTSIDE_US |
|
currentMailingAddressVerified | current_mailing_address_verified | SZRINTL | CURR_MAILNG_ADDR_VERIFIED |
|
currentMailingCity | current_mailing_city | SZRINTL | CURR_MAILNG_CITY |
|
currentMailingCountry | current_mailing_country | SZRINTL | CURR_MAILNG_COUNTRY |
|
currentMailingNonUsAddress | current_mailing_non_us_address | SZRINTL | CURR_MAILNG_NON_US_ADDRESS |
|
currentMailingNonUsPostalCode | current_mailing_non_us_postal_code | SZRINTL | CURR_MAILNG_NON_US_POSTAL_CODE |
|
currentMailingNonUsProvince | current_mailing_non_us_province | SZRINTL | CURR_MAILNG_NON_US_PROVINCE |
|
currentMailingSameAsPermanent | current_mailing_same_as_permanent | SZRINTL | CURR_MAILNG_SAME_AS_PERMANENT |
|
currentMailingState | current_mailing_state | SZRINTL | CURR_MAILNG_STATE |
|
currentMailingStreet1 | current_mailing_street_1 | SZRINTL | CURR_MAILNG_STREET_1 |
|
currentMailingStreet2 | current_mailing_street_2 | SZRINTL | CURR_MAILNG_STREET_2 |
|
currentMailingZipCode | current_mailing_zip_code | SZRINTL | CURR_MAILNG_ZIP_CODE |
|
dep1CountryOfBirth | dep1_country_of_birth | SZRINTL | DEP1_COUNTRY_OF_BIRTH |
|
dep1DateOfBirth | dep1_date_of_birth | SZRINTL | DEP1_DATE_OF_BIRTH |
|
dep1DependentId | dep1_dependent_id | SZRINTL | DEP1_DEPENDENT_ID |
|
dep1FirstName | dep1_first_name | SZRINTL | DEP1_FIRST_NAME |
|
dep1Gender | dep1_gender | SZRINTL | DEP1_GENDER |
|
dep1LastName | dep1_last_name | SZRINTL | DEP1_LAST_NAME |
|
dep1NoFirstName | dep1_no_first_name | SZRINTL | DEP1_NO_FIRST_NAME |
|
dep1Relationship | dep1_relationship | SZRINTL | DEP1_RELATIONSHIP |
|
dep10CountryOfBirth | dep10_country_of_birth | SZRINTL | DEP10_COUNTRY_OF_BIRTH |
|
dep10DateOfBirth | dep10_date_of_birth | SZRINTL | DEP10_DATE_OF_BIRTH |
|
dep10DependentId | dep10_dependent_id | SZRINTL | DEP10_DEPENDENT_ID |
|
dep10FirstName | dep10_first_name | SZRINTL | DEP10_FIRST_NAME |
|
dep10Gender | dep10_gender | SZRINTL | DEP10_GENDER |
|
dep10LastName | dep10_last_name | SZRINTL | DEP10_LAST_NAME |
|
dep10NoFirstName | dep10_no_first_name | SZRINTL | DEP10_NO_FIRST_NAME |
|
dep10Relationship | dep10_relationship | SZRINTL | DEP10_RELATIONSHIP |
|
dep2CountryOfBirth | dep2_country_of_birth | SZRINTL | DEP2_COUNTRY_OF_BIRTH |
|
dep2DateOfBirth | dep2_date_of_birth | SZRINTL | DEP2_DATE_OF_BIRTH |
|
dep2DependentId | dep2_dependent_id | SZRINTL | DEP2_DEPENDENT_ID |
|
dep2FirstName | dep2_first_name | SZRINTL | DEP2_FIRST_NAME |
|
dep2Gender | dep2_gender | SZRINTL | DEP2_GENDER |
|
dep2LastName | dep2_last_name | SZRINTL | DEP2_LAST_NAME |
|
dep2NoFirstName | dep2_no_first_name | SZRINTL | DEP2_NO_FIRST_NAME |
|
dep2Relationship | dep2_relationship | SZRINTL | DEP2_RELATIONSHIP |
|
dep3CountryOfBirth | dep3_country_of_birth | SZRINTL | DEP3_COUNTRY_OF_BIRTH |
|
dep3DateOfBirth | dep3_date_of_birth | SZRINTL | DEP3_DATE_OF_BIRTH |
|
dep3DependentId | dep3_dependent_id | SZRINTL | DEP3_DEPENDENT_ID |
|
dep3FirstName | dep3_first_name | SZRINTL | DEP3_FIRST_NAME |
|
dep3Gender | dep3_gender | SZRINTL | DEP3_GENDER |
|
dep3LastName | dep3_last_name | SZRINTL | DEP3_LAST_NAME |
|
dep3NoFirstName | dep3_no_first_name | SZRINTL | DEP3_NO_FIRST_NAME |
|
dep3Relationship | dep3_relationship | SZRINTL | DEP3_RELATIONSHIP |
|
dep4CountryOfBirth | dep4_country_of_birth | SZRINTL | DEP4_COUNTRY_OF_BIRTH |
|
dep4DateOfBirth | dep4_date_of_birth | SZRINTL | DEP4_DATE_OF_BIRTH |
|
dep4DependentId | dep4_dependent_id | SZRINTL | DEP4_DEPENDENT_ID |
|
dep4FirstName | dep4_first_name | SZRINTL | DEP4_FIRST_NAME |
|
dep4Gender | dep4_gender | SZRINTL | DEP4_GENDER |
|
dep4LastName | dep4_last_name | SZRINTL | DEP4_LAST_NAME |
|
dep4NoFirstName | dep4_no_first_name | SZRINTL | DEP4_NO_FIRST_NAME |
|
dep4Relationship | dep4_relationship | SZRINTL | DEP4_RELATIONSHIP |
|
dep5CountryOfBirth | dep5_country_of_birth | SZRINTL | DEP5_COUNTRY_OF_BIRTH |
|
dep5DateOfBirth | dep5_date_of_birth | SZRINTL | DEP5_DATE_OF_BIRTH |
|
dep5DependentId | dep5_dependent_id | SZRINTL | DEP5_DEPENDENT_ID |
|
dep5FirstName | dep5_first_name | SZRINTL | DEP5_FIRST_NAME |
|
dep5Gender | dep5_gender | SZRINTL | DEP5_GENDER |
|
dep5LastName | dep5_last_name | SZRINTL | DEP5_LAST_NAME |
|
dep5NoFirstName | dep5_no_first_name | SZRINTL | DEP5_NO_FIRST_NAME |
|
dep5Relationship | dep5_relationship | SZRINTL | DEP5_RELATIONSHIP |
|
dep6CountryOfBirth | dep6_country_of_birth | SZRINTL | DEP6_COUNTRY_OF_BIRTH |
|
dep6DateOfBirth | dep6_date_of_birth | SZRINTL | DEP6_DATE_OF_BIRTH |
|
dep6DependentId | dep6_dependent_id | SZRINTL | DEP6_DEPENDENT_ID |
|
dep6FirstName | dep6_first_name | SZRINTL | DEP6_FIRST_NAME |
|
dep6Gender | dep6_gender | SZRINTL | DEP6_GENDER |
|
dep6LastName | dep6_last_name | SZRINTL | DEP6_LAST_NAME |
|
dep6NoFirstName | dep6_no_first_name | SZRINTL | DEP6_NO_FIRST_NAME |
|
dep6Relationship | dep6_relationship | SZRINTL | DEP6_RELATIONSHIP |
|
dep7CountryOfBirth | dep7_country_of_birth | SZRINTL | DEP7_COUNTRY_OF_BIRTH |
|
dep7DateOfBirth | dep7_date_of_birth | SZRINTL | DEP7_DATE_OF_BIRTH |
|
dep7DependentId | dep7_dependent_id | SZRINTL | DEP7_DEPENDENT_ID |
|
dep7FirstName | dep7_first_name | SZRINTL | DEP7_FIRST_NAME |
|
dep7Gender | dep7_gender | SZRINTL | DEP7_GENDER |
|
dep7LastName | dep7_last_name | SZRINTL | DEP7_LAST_NAME |
|
dep7NoFirstName | dep7_no_first_name | SZRINTL | DEP7_NO_FIRST_NAME |
|
dep7Relationship | dep7_relationship | SZRINTL | DEP7_RELATIONSHIP |
|
dep8CountryOfBirth | dep8_country_of_birth | SZRINTL | DEP8_COUNTRY_OF_BIRTH |
|
dep8DateOfBirth | dep8_date_of_birth | SZRINTL | DEP8_DATE_OF_BIRTH |
|
dep8DependentId | dep8_dependent_id | SZRINTL | DEP8_DEPENDENT_ID |
|
dep8FirstName | dep8_first_name | SZRINTL | DEP8_FIRST_NAME |
|
dep8Gender | dep8_gender | SZRINTL | DEP8_GENDER |
|
dep8LastName | dep8_last_name | SZRINTL | DEP8_LAST_NAME |
|
dep8NoFirstName | dep8_no_first_name | SZRINTL | DEP8_NO_FIRST_NAME |
|
dep8Relationship | dep8_relationship | SZRINTL | DEP8_RELATIONSHIP |
|
dep9CountryOfBirth | dep9_country_of_birth | SZRINTL | DEP9_COUNTRY_OF_BIRTH |
|
dep9DateOfBirth | dep9_date_of_birth | SZRINTL | DEP9_DATE_OF_BIRTH |
|
dep9DependentId | dep9_dependent_id | SZRINTL | DEP9_DEPENDENT_ID |
|
dep9FirstName | dep9_first_name | SZRINTL | DEP9_FIRST_NAME |
|
dep9Gender | dep9_gender | SZRINTL | DEP9_GENDER |
|
dep9LastName | dep9_last_name | SZRINTL | DEP9_LAST_NAME |
|
dep9NoFirstName | dep9_no_first_name | SZRINTL | DEP9_NO_FIRST_NAME |
|
dep9Relationship | dep9_relationship | SZRINTL | DEP9_RELATIONSHIP |
|
educationalGoal | educational_goal | SZRINTL | EDUCATIONAL_GOAL |
|
SZRINTL |
| |||
emergencyContactAddressVerified | emergency_contact_address_verified | SZRINTL | EMER_CONT_ADDR_VERIFIED |
|
emergencyContactCity | emergency_contact_city | SZRINTL | EMER_CONT_CITY |
|
emergencyContactCountry | emergency_contact_country | SZRINTL | EMER_CONT_COUNTRY |
|
emergencyContactEmail | emergency_contact_email | SZRINTL | EMER_CONT_EMAIL |
|
emergencyContactFirstName | emergency_contact_first_name | SZRINTL | EMER_CONT_FIRST_NAME |
|
emergencyContactLastName | emergency_contact_last_name | SZRINTL | EMER_CONT_LAST_NAME |
|
emergencyContactNoFirstName | emergency_contact_no_first_name | SZRINTL | EMER_CONT_NO_FIRST_NAME |
|
emergencyContactNonUsAddress | emergency_contact_non_us_address | SZRINTL | EMER_CONT_NON_US_ADDRESS |
|
emergencyContactNonUsPostalCode | emergency_contact_non_us_postal_code | SZRINTL | EMER_CONT_NON_US_POSTAL_CODE |
|
emergencyContactNonUsProvince | emergency_contact_non_us_province | SZRINTL | EMER_CONT_NON_US_PROVINCE |
|
emergencyContactPhoneAuthTxt | emergency_contact_phone_auth_txt | SZRINTL | EMER_CONT_PHONE_AUTH_TXT |
|
emergencyContactPhoneExt | emergency_contact_phone_ext | SZRINTL | EMER_CONT_PHONE_EXT |
|
emergencyContactPhoneNumber | emergency_contact_phone_number | SZRINTL | EMER_CONT_PHONE_NUMBER |
|
emergencyContactRelationship | emergency_contact_relationship | SZRINTL | EMER_CONT_RELATIONSHIP |
|
emergencyContactState | emergency_contact_state | SZRINTL | EMER_CONT_STATE |
|
emergencyContactStreet1 | emergency_contact_street_1 | SZRINTL | EMER_CONT_STREET_1 |
|
emergencyContactStreet2 | emergency_contact_street_2 | SZRINTL | EMER_CONT_STREET_2 |
|
emergencyContactZipCode | emergency_contact_zip_code | SZRINTL | EMER_CONT_ZIP_CODE |
|
engMonthsStudied | eng_months_studied | SZRINTL |