CCCApply Standard SuperGlue Data Mappings for Colleague
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 |
verificationOptinTimestamp | verification_optin_timestamp | XCTC.CCC.APPLY.APPL | XCTC.SD.VERIF.OPTIN.TIME | SG 5.3.0 |
verificationConfirmationTimestamp | verification_confirmation_timestamp | XCTC.CCC.APPLY.APPL | XCTC.SD.VERIF.CONFRM.TIME | SG 5.3.0 |
verificationWorkflowStatus | verification_workflow_status | XCTC.CCC.APPLY.APPL | XCTC.SD.VERIF.WF.STATUS | SG 5.3.0 |
verificationSourceIdentity | verification_source_identity | XCTC.CCC.APPLY.APPL | XCTC.SD.VERIF.SRC.IDENT | SG 5.3.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 |
|
appType | app_type | XCTC.CCC.APPLY.APPL | XCTC.CA.APP.TYPE | SG 5.3.0 |
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 |