CCCApply International SuperGlue Data Mappings - Banner

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

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  

 

email

email

SZRINTL

EMAIL

 

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