CCCApply Standard SuperGlue Data Mappings for Colleague
- Patricia Donohue
- Kasey Crosby
The following tables contain data field table mappings for the CCCApply Standard and Noncredit Applications.
On This Page:
Standard & Noncredit Application Data Fields Table Mappings
More details can be found in the CCCApply Standard Application section on the Data Dictionaries page.
College Adaptor Payload Field | CCCApply Application Field | Colleague Table | Colleague Field Name | Notes |
|---|---|---|---|---|
raceAIANOtherDescription | race_aian_other_description | XCTC.CCC.APPLY.APPL | XCTC.CA.RACE.AIAN.OTHER.DESC | SG v.4.10 |
studentDeps18Over | student_deps_18over | XCTC.CCC.APPLY.APPL | XCTC.CA.STUDENT.DEPS.18OVER | SG v.4.10 |
studentDepsUnder18 | student_deps_under18 | XCTC.CCC.APPLY.APPL | XCTC.CA.STUDENT.DEPS.UNDER18 | SG v.4.10 |
idmeConfirmationTimestamp | idme_confirmation_timestamp | XCTC.CCC.APPLY.APPL | XCTC.CA.IDME.CONFIRMED.DATE | SG v.4.9.0 |
idmeOptinTimestamp | idme_optin_timestamp | XCTC.CCC.APPLY.APPL | XCTC.CA.IDME.OPTIN.DATE | SG v.4.9.0 |
idmeWorkflowStatus | idme_workflow_status | XCTC.CCC.APPLY.APPL | XCTC.CA.IDME.WORKFLOW.STATUS | SG v.4.9.0 |
studentParent | student_parent | XCTC_CCC_APPLY_APPL | XCTC.CA.STUDENT.PARENT |
|
acceptedTerms | accepted_terms | XCTC_CCC_APPLY_APPL | XCTC.CA.ACCEPTED.TERMS |
|
acceptedTermsTimestamp | accepted_terms_timestamp | XCTC_CCC_APPLY_APPL | XCTC.CA.ACCEPTED.TERMS.DATE |
|
ipAddressAtAccountCreation | ip_address_at_account_creation | XCTC_CCC_APPLY_APPL | XCTC.CA.IP.ADDRESS.ACCT.CRTD |
|
ipAddressAtAppCreation | ip_address_at_app_creation | XCTC_CCC_APPLY_APPL | XCTC.CA.IP.ADDRESS.APPL.CRTD |
|
mailingAddressValidationOverride | mailing_address_validation_override | XCTC_CCC_APPLY_APPL | XCTC.CA.MA.ADDRESS.VALID.O |
|
phoneType | phone_type | XCTC_CCC_APPLY_APPL | XCTC.CA.MAINPHONE.TYPE |
|
appId | app_id | XCTC_CCC_APPLY_APPL | XCTC_CA_APP_ID |
|
cccId | ccc_id | XCTC_CCC_APPLY_APPL | XCTC_CA_CCC_ID |
|
status | status | XCTC_CCC_APPLY_APPL | XCTC_CA_STATUS |
|
collegeId | college_id | XCTC_CCC_APPLY_APPL | XCTC_CA_COLLEGE_ID |
|
termId | term_id | XCTC_CCC_APPLY_APPL | XCTC_CA_TERM_ID |
|
majorId | major_id | XCTC_CCC_APPLY_APPL | XCTC_CA_MAJOR_ID |
|
intendedMajor | intended_major | XCTC_CCC_APPLY_APPL | XCTC_CA_INTENDED_MAJOR |
|
eduGoal | edu_goal | XCTC_CCC_APPLY_APPL | XCTC_CA_EDU_GOAL |
|
highestEduLevel | highest_edu_level | XCTC_CCC_APPLY_APPL | XCTC_CA_HIGHEST_EDU_LEVEL |
|
consentIndicator | consent_indicator | XCTC_CCC_APPLY_APPL | XCTC_CA_CONSENT_INDICATOR |
|
appLang | app_lang | XCTC_CCC_APPLY_APPL | XCTC_CA_APP_LANG |
|
ackFinAid | ack_fin_aid | XCTC_CCC_APPLY_APPL | XCTC_CA_ACK_FIN_AID |
|
finAidRef | fin_aid_ref | XCTC_CCC_APPLY_APPL | XCTC_CA_FIN_AID_REF |
|
confirmation | confirmation | XCTC_CCC_APPLY_APPL | XCTC_CA_CONFIRMATION |
|
supPageCode | sup_page_code | XCTC_CCC_APPLY_APPL | XCTC_CA_SUP_PAGE_CODE |
|
lastPage | last_page | XCTC_CCC_APPLY_APPL | XCTC_CA_LAST_PAGE |
|
streetaddress1 | streetaddress1 | XCTC_CCC_APPLY_APPL | XCTC_CA_STREETADDRESS1 |
|
streetaddress2 | streetaddress2 | XCTC_CCC_APPLY_APPL | XCTC_CA_STREETADDRESS2 |
|
city | city | XCTC_CCC_APPLY_APPL | XCTC_CA_CITY |
|
postalcode | postalcode | XCTC_CCC_APPLY_APPL | XCTC_CA_POSTALCODE |
|
state | state | XCTC_CCC_APPLY_APPL | XCTC_CA_STATE |
|
nonusaprovince | nonusaprovince | XCTC_CCC_APPLY_APPL | XCTC_CA_NONUSAPROVINCE |
|
country | country | XCTC_CCC_APPLY_APPL | XCTC_CA_COUNTRY |
|
nonUsAddress | non_us_address | XCTC_CCC_APPLY_APPL | XCTC_CA_NON_US_ADDRESS |
|
XCTC_CCC_APPLY_APPL | XCTC_CA_EMAIL |
| ||
permStreetaddress1 | perm_streetaddress1 | XCTC_CCC_APPLY_APPL | XCTC_CA_PERM_STREETADDRESS1 |
|
permStreetaddress2 | perm_streetaddress2 | XCTC_CCC_APPLY_APPL | XCTC_CA_PERM_STREETADDRESS2 |
|
permCity | perm_city | XCTC_CCC_APPLY_APPL | XCTC_CA_PERM_CITY |
|
permPostalcode | perm_postalcode | XCTC_CCC_APPLY_APPL | XCTC_CA_PERM_POSTALCODE |
|
permState | perm_state | XCTC_CCC_APPLY_APPL | XCTC_CA_PERM_STATE |
|
permNonusaprovince | perm_nonusaprovince | XCTC_CCC_APPLY_APPL | XCTC_CA_PERM_NONUSAPROVINCE |
|
permCountry | perm_country | XCTC_CCC_APPLY_APPL | XCTC_CA_PERM_COUNTRY |
|
addressSame | address_same | XCTC_CCC_APPLY_APPL | XCTC_CA_ADDRESS_SAME |
|
mainphone | mainphone | XCTC_CCC_APPLY_APPL | XCTC_CA_MAINPHONE |
|
mainphoneExt | mainphone_ext | XCTC_CCC_APPLY_APPL | XCTC_CA_MAINPHONE_EXT |
|
mainphoneAuthText | mainphone_auth_text | XCTC_CCC_APPLY_APPL | XCTC_CA_MAINPHONE_AUTH_TEXT |
|
secondphone | secondphone | XCTC_CCC_APPLY_APPL | XCTC_CA_SECONDPHONE |
|
secondphoneExt | secondphone_ext | XCTC_CCC_APPLY_APPL | XCTC_CA_SECONDPHONE_EXT |
|
secondphoneAuthText | secondphone_auth_text | XCTC_CCC_APPLY_APPL | XCTC_CA_SECONDPHONE_AUTH_TEX |
|
enrollStatus | enroll_status | XCTC_CCC_APPLY_APPL | XCTC_CA_ENROLL_STATUS |
|
hsEduLevel | hs_edu_level | XCTC_CCC_APPLY_APPL | XCTC_CA_HS_EDU_LEVEL |
|
hsCompDate | hs_comp_date | XCTC_CCC_APPLY_APPL | XCTC_CA_HS_COMP_DATE |
|
higherEduLevel | higher_edu_level | XCTC_CCC_APPLY_APPL | XCTC_CA_HIGHER_EDU_LEVEL |
|
higherCompDate | higher_comp_date | XCTC_CCC_APPLY_APPL | XCTC_CA_HIGHER_COMP_DATE |
|
hsNotAttended | hs_not_attended | XCTC_CCC_APPLY_APPL | XCTC_CA_HS_NOT_ATTENDED |
|
cahsGraduated | cahs_graduated | XCTC_CCC_APPLY_APPL | XCTC_CA_CAHS_GRADUATED |
|
cahs3year | cahs_3year | XCTC_CCC_APPLY_APPL | XCTC_CA_CAHS_3_YEAR |
|
hsName | hs_name | XCTC_CCC_APPLY_APPL | XCTC_CA_HS_NAME |
|
hsCity | hs_city | XCTC_CCC_APPLY_APPL | XCTC_CA_HS_CITY |
|
hsState | hs_state | XCTC_CCC_APPLY_APPL | XCTC_CA_HS_STATE |
|
hsCountry | hs_country | XCTC_CCC_APPLY_APPL | XCTC_CA_HS_COUNTRY |
|
hsCds | hs_cds | XCTC_CCC_APPLY_APPL | XCTC_CA_HS_CDS |
|
hsCeeb | hs_ceeb | XCTC_CCC_APPLY_APPL | XCTC_CA_HS_CEEB |
|
hsNotListed | hs_not_listed | XCTC_CCC_APPLY_APPL | XCTC_CA_HS_NOT_LISTED |
|
homeSchooled | home_schooled | XCTC_CCC_APPLY_APPL | XCTC_CA_HOME_SCHOOLED |
|
collegeCount | college_count | XCTC_CCC_APPLY_APPL | XCTC_CA_COLLEGE_COUNT |
|
hsAttendance | hs_attendance | XCTC_CCC_APPLY_APPL | XCTC_CA_HS_ATTENDANCE |
|
coenrollConfirm | coenroll_confirm | XCTC_CCC_APPLY_APPL | XCTC_CA_COENROLL_CONFIRM |
|
gender | gender | XCTC_CCC_APPLY_APPL | XCTC_CA_GENDER |
|
pgFirstname | pg_firstname | XCTC_CCC_APPLY_APPL | XCTC_CA_PG_FIRSTNAME |
|
pgLastname | pg_lastname | XCTC_CCC_APPLY_APPL | XCTC_CA_PG_LASTNAME |
|
pgRel | pg_rel | XCTC_CCC_APPLY_APPL | XCTC_CA_PG_REL |
|
pg1Edu | pg1_edu | XCTC_CCC_APPLY_APPL | XCTC_CA_PG1_EDU |
|
pg2Edu | pg2_edu | XCTC_CCC_APPLY_APPL | XCTC_CA_PG2_EDU |
|
pgEduMis | pg_edu_mis | XCTC_CCC_APPLY_APPL | XCTC_CA_PG_EDU_MIS |
|
under19Ind | under19_ind | XCTC_CCC_APPLY_APPL | XCTC_CA_UNDER19_IND |
|
dependentStatus | dependent_status | XCTC_CCC_APPLY_APPL | XCTC_CA_DEPENDENT_STATUS |
|
raceEthnic | race_ethnic | XCTC_CCC_APPLY_APPL | XCTC_CA_RACE_ETHNIC |
|
hispanic | hispanic | XCTC_CCC_APPLY_APPL | XCTC_CA_HISPANIC |
|
raceGroup | race_group | XCTC_CCC_APPLY_APPL | XCTC_CA_RACE_GROUP |
|
raceEthnicFull | race_ethnic_full | XCTC_CCC_APPLY_APPL | XCTC_CA_RACE_ETHNIC_FULL |
|
ssn | ssn | XCTC_CCC_APPLY_APPL | XCTC_CA_SSN |
|
birthdate | birthdate | XCTC_CCC_APPLY_APPL | XCTC_CA_BIRTHDATE |
|
firstname | firstname | XCTC_CCC_APPLY_APPL | XCTC_CA_FIRSTNAME |
|
middlename | middlename | XCTC_CCC_APPLY_APPL | XCTC_CA_MIDDLENAME |
|
lastname | lastname | XCTC_CCC_APPLY_APPL | XCTC_CA_LASTNAME |
|
suffix | suffix | XCTC_CCC_APPLY_APPL | XCTC_CA_SUFFIX |
|
otherfirstname | otherfirstname | XCTC_CCC_APPLY_APPL | XCTC_CA_OTHERFIRSTNAME |
|
othermiddlename | othermiddlename | XCTC_CCC_APPLY_APPL | XCTC_CA_OTHERMIDDLENAME |
|
otherlastname | otherlastname | XCTC_CCC_APPLY_APPL | XCTC_CA_OTHERLASTNAME |
|
citizenshipStatus | citizenship_status | XCTC_CCC_APPLY_APPL | XCTC_CA_CITIZENSHIP_STATUS |
|
alienRegNumber | alien_reg_number | XCTC_CCC_APPLY_APPL | XCTC_CA_ALIEN_REG_NUMBER |
|
visaType | visa_type | XCTC_CCC_APPLY_APPL | XCTC_CA_VISA_TYPE |
|
noDocuments | no_documents | XCTC_CCC_APPLY_APPL | XCTC_CA_NO_DOCUMENTS |
|
alienRegIssueDate | alien_reg_issue_date | XCTC_CCC_APPLY_APPL | XCTC_CA_ALIEN_REG_ISSUE_DATE |
|
alienRegExpireDate | alien_reg_expire_date | XCTC_CCC_APPLY_APPL | XCTC_CA_ALIEN_REG_EXPIRE_DAT |
|
alienRegNoExpire | alien_reg_no_e |