CCCApply International SuperGlue Data Mappings for Colleague
Content Links
International Data Fields Table Mappings - Colleague
More details can be found in the International Application section on the Data Dictionaries page
College Adaptor Payload Field | CCC Apply International Application Field | Colleague Table | Colleague Field Name | VERSION Release |
|---|---|---|---|---|
appId | app_id | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_APP_ID |
|
cccId | ccc_id | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_CCC_ID |
|
collegeId | college_id | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COLLEGE_ID |
|
acceptedTerms | accepted_terms | XCTC_CCC_APPLY_INTL_APPL | XCTC.CA.ACCEPTED.TERMS |
|
acceptedTermsTimestamp | accepted_terms_timestamp | XCTC_CCC_APPLY_INTL_APPL | XCTC.CA.ACCEPTED.TERMS.DATE |
|
addressVerified | address_verified | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_ADDRESS_VERIFIED |
|
agentPhoneExt | agent_phone_ext | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_AGENT_PHONE_EXT |
|
agentPhoneNumber | agent_phone_number | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_AGENT_PHONE_NUMBER |
|
altNonUsPhoneAuthTxt | alt_non_us_phone_auth_txt | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_ALT_NON_US_PH_ATH_TXT |
|
altNonUsPhoneExt | alt_non_us_phone_ext | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_ALT_NON_US_PHONE_EXT |
|
altNonUsPhoneNumber | alt_non_us_phone_number | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_ALT_NON_US_PHONE |
|
appLang | app_lang | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_APP_LANG |
|
authorizeAgentInfoRelease | authorize_agent_info_release | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_AUTH_AGT_INFO_RELEASE |
|
birthdate | birthdate | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_BIRTHDATE |
|
campaign1 | campaign1 | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_CAMPAIGN1 |
|
campaign2 | campaign2 | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_CAMPAIGN2 |
|
campaign3 | campaign3 | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_CAMPAIGN3 |
|
citizenshipStatus | citizenship_status | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_CITIZENSHIP_STATUS |
|
city | city | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_CITY |
|
coenrollConfirm | coenroll_confirm | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COENROLL_CONFIRM |
|
col1Cds | col1_cds | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL1_CDS |
|
col1CdsFull | col1_cds_full | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL1_CDS_FULL |
|
col1Ceeb | col1_ceeb | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL1_CEEB |
|
col1City | col1_city | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL1_CITY |
|
col1CollegeAttendedId | col1_college_attended_id | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL1_COLLEGE_ATT_ID |
|
col1Country | col1_country | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL1_COUNTRY |
|
col1DegreeDate | col1_degree_date | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL1_DEGREE_DATE |
|
col1DegreeObtained | col1_degree_obtained | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL1_DEGREE_OBTAINED |
|
col1EndDate | col1_end_date | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL1_END_DATE |
|
col1ExpelledStatus | col1_expelled_status | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL1_EXPELLED_STATUS |
|
col1Major | col1_major | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL1_MAJOR |
|
col1Name | col1_name | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL1_NAME |
|
col1NonUsProvince | col1_non_us_province | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL1_NON_US_PROVINCE |
|
col1NotListed | col1_not_listed | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL1_NOT_LISTED |
|
col1PrimaryInstructionLanguage | col1_primary_instruction_language | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL1_PRI_INST_LANG |
|
col1StartDate | col1_start_date | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL1_START_DATE |
|
col1State | col1_state | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL1_STATE |
|
col2Cds | col2_cds | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL2_CDS |
|
col2CdsFull | col2_cds_full |
|
|
|
col2Ceeb | col2_ceeb | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL2_CEEB |
|
col2City | col2_city | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL2_CITY |
|
col2CollegeAttendedId | col2_college_attended_id | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL2_COLLEGE_ATT_ID |
|
col2Country | col2_country | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL2_COUNTRY |
|
col2DegreeDate | col2_degree_date | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL2_DEGREE_DATE |
|
col2DegreeObtained | col2_degree_obtained | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL2_DEGREE_OBTAINED |
|
col2EndDate | col2_end_date | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL2_END_DATE |
|
col2ExpelledStatus | col2_expelled_status | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL2_EXPELLED_STATUS |
|
col2Major | col2_major | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL2_MAJOR |
|
col2Name | col2_name | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL2_NAME |
|
col2NonUsProvince | col2_non_us_province | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL2_NON_US_PROVINCE |
|
col2NotListed | col2_not_listed | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL2_NOT_LISTED |
|
col2PrimaryInstructionLanguage | col2_primary_instruction_language | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL2_PRI_INST_LANG |
|
col2StartDate | col2_start_date | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL2_START_DATE |
|
col2State | col2_state | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL2_STATE |
|
col3Cds | col3_cds | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL3_CDS |
|
col3CdsFull | col3_cds_full |
|
|
|
col3Ceeb | col3_ceeb | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL3_CEEB |
|
col3City | col3_city | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL3_CITY |
|
col3CollegeAttendedId | col3_college_attended_id | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL3_COL_ATT_ID |
|
col3Country | col3_country | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL3_COUNTRY |
|
col3DegreeDate | col3_degree_date | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL3_DEGREE_DATE |
|
col3DegreeObtained | col3_degree_obtained | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL3_DEGREE_OBTAINED |
|
col3EndDate | col3_end_date | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL3_END_DATE |
|
col3ExpelledStatus | col3_expelled_status | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL3_EXPELLED_STATUS |
|
col3Major | col3_major | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL3_MAJOR |
|
col3Name | col3_name | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL3_NAME |
|
col3NonUsProvince | col3_non_us_province | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL3_NON_US_PROVINCE |
|
col3NotListed | col3_not_listed | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL3_NOT_LISTED |
|
col3PrimaryInstructionLanguage | col3_primary_instruction_language | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL3_PRI_INST_LANG |
|
col3StartDate | col3_start_date | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL3_START_DATE |
|
col3State | col3_state | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL3_STATE |
|
col4Cds | col4_cds | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL4_CDS |
|
col4CdsFull | col4_cds_full |
|
|
|
col4Ceeb | col4_ceeb | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL4_CEEB |
|
col4City | col4_city | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL4_CITY |
|
col4CollegeAttendedId | col4_college_attended_id | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL4_COLL_ATT_ID |
|
col4Country | col4_country | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL4_COUNTRY |
|
col4DegreeDate | col4_degree_date | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL4_DEGREE_DATE |
|
col4DegreeObtained | col4_degree_obtained | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL4_DEGREE_OBTAINED |
|
col4EndDate | col4_end_date | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL4_END_DATE |
|
col4ExpelledStatus | col4_expelled_status | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL4_EXPELLED_STATUS |
|
col4Major | col4_major | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL4_MAJOR |
|
col4Name | col4_name | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL4_NAME |
|
col4NonUsProvince | col4_non_us_province | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL4_NON_US_PROVINCE |
|
col4NotListed | col4_not_listed | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL4_NOT_LISTED |
|
col4PrimaryInstructionLanguage | col4_primary_instruction_language | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL4_PRI_INST_LANG |
|
col4StartDate | col4_start_date | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL4_START_DATE |
|
col4State | col4_state | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COL4_STATE |
|
collegeCompDate | college_comp_date | XCTC_CCC_APPLY_INTL_APPL | XCTC_I_COLLEGE_COMP_DATE |
|