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 |
|---|---|---|---|---|
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 |
|