CCCApply Standard Application SuperGlue Data Mappings - Banner
The tables below pertain to the CCCApply Standard & Noncredit Applications.
On This Page:
Standard Data Fields Table Mapping - Banner
For more details, see the CCCApply Standard & Noncredit Application data dictionary.
College Adaptor Payload Name | CCC Field Name | Banner DB Staging Table | Banner Field Name | Notes |
|---|---|---|---|---|
raceAIANOtherDescription | race_aian_other_description | SZRAPLY | RACE_AIAN_OTHER_DESCRIPTION | SG 4.10 |
studentDepsUnder18 | student_deps_under18 | SZRAPLY | STU_DEPS_UNDER_18 | SG 4.10 |
studentDeps18Over | student_deps_18over | SZRAPLY | STU_DEPS_18_OVER | SG 4.10 |
idmeConfirmationTimestamp | idme_confirmation_timestamp | SZRAPLY | IDME_CONFIRMATION_TSTMP | SG v.4.9 |
idmeOptinTimestamp | idme_optin_timestamp | SZRAPLY | IDME_OPTIN_TSTMP | SG v.4.9 |
idmeWorkflowStatus | idme_workflow_status | SZRAPLY | IDME_WORKFLOW_STATUS | SG v.4.9 |
verificationOptinTimestamp | verification_optin_timestamp | SZRAPLY | VERIFICATION_OPTIN_TIMESTAMP | SG v5.3.0 |
verificationConfirmationTimestamp | verification_confirmation_timestamp | SZRAPLY | VERIFICATION_CONFIRMATION_TIMESTAMP | SG v5.3.0 |
verificationWorkflowStatus | verification_workflow_status | SZRAPLY | VERIFICATION_WORKFLOW_STATUS | SG v5.3.0 |
verificationSourceIdentity | verification_source_identity | SZRAPLY | VERIFICATION_SOURCE_IDENTITY | SG v5.3.0 |
studentParent | student_parent | SZRAPLY | STUDENT_PARENT | SG v.4.7 |
acceptedTerms | accepted_terms | SZRAPLY | ACCEPTED_TERMS | SG v.4.6 |
acceptedTermsTimestamp | accepted_terms_timestamp | SZRAPLY | ACCEPTED_TERMS_TSTMP | SG v.4.6 |
ipAddressAtAccountCreation | ip_address_at_account_creation | SZRAPLY | IP_ADDR_ACCT_CREATE | SG v.4.7 |
ipAddressAtAppCreation | ip_address_at_app_creation | SZRAPLY | IP_ADDR_APP_CREATE | SG v.4.7 |
mailingAddressValidationOverride | mailing_address_validation_override | SZRAPLY | MAIL_ADDR_VALIDATION_OVR | SG v.4.7 |
phoneType | phone_type | SZRAPLY | PHONE_TYPE | SG v.4.7 |
appId | app_id | SZRAPLY | APP_ID |
|
cccId | ccc_id | SZRAPLY | CCC_ID |
|
status | status | SZRAPLY | STATUS |
|
collegeId | college_id | SZRAPLY | COLLEGE_ID |
|
termId | term_id | SZRAPLY | TERM_ID | NOT USED |
majorId | major_id | SZRAPLY | MAJOR_ID | NOT USED |
intendedMajor | intended_major | SZRAPLY | INTENDED_MAJOR |
|
eduGoal | edu_goal | SZRAPLY | EDU_GOAL |
|
highestEduLevel | highest_edu_level | SZRAPLY | HIGHEST_EDU_LEVEL |
|
consentIndicator | consent_indicator | SZRAPLY | CONSENT_INDICATOR |
|
appLang | app_lang | SZRAPLY | APP_LANG |
|
ackFinAid | ack_fin_aid | SZRAPLY | ACK_FIN_AID |
|
finAidRef | fin_aid_ref | SZRAPLY | FIN_AID_REF |
|
confirmation | confirmation | SZRAPLY | CONFIRMATION |
|
supPageCode | sup_page_code | SZRAPLY | SUP_PAGE_CODE |
|
lastPage | last_page | SZRAPLY | LAST_PAGE |
|
streetaddress1 | streetaddress1 | SZRAPLY | STREETADDRESS1 |
|
streetaddress2 | streetaddress2 | SZRAPLY | STREETADDRESS2 |
|
city | city | SZRAPLY | CITY |
|
postalcode | postalcode | SZRAPLY | POSTALCODE |
|
state | state | SZRAPLY | STATE |
|
nonusaprovince | nonusaprovince | SZRAPLY | NONUSAPROVINCE |
|
country | country | SZRAPLY | COUNTRY |
|
nonUsAddress | non_us_address | SZRAPLY | NON_US_ADDRESS |
|
SZRAPLY |
| |||
permStreetaddress1 | perm_streetaddress1 | SZRAPLY | PERM_STREETADDRESS1 |
|
permStreetaddress2 | perm_streetaddress2 | SZRAPLY | PERM_STREETADDRESS2 |
|
permCity | perm_city | SZRAPLY | PERM_CITY |
|
permPostalcode | perm_postalcode | SZRAPLY | PERM_POSTALCODE |
|
permState | perm_state | SZRAPLY | PERM_STATE |
|
permNonusaprovince | perm_nonusaprovince | SZRAPLY | PERM_NONUSAPROVINCE |
|
permCountry | perm_country | SZRAPLY | PERM_COUNTRY |
|
addressSame | address_same | SZRAPLY | ADDRESS_SAME |
|
mainphone | mainphone | SZRAPLY | MAINPHONE |
|
mainphoneExt | mainphone_ext | SZRAPLY | MAINPHONE_EXT | NO LONGER USED |
mainphoneAuthText | mainphone_auth_text | SZRAPLY | MAINPHONE_AUTH_TEXT | NO LONGER USED |
secondphone | secondphone | SZRAPLY | SECONDPHONE | NO LONGER USED |
secondphoneExt | secondphone_ext | SZRAPLY | SECONDPHONE_EXT | NO LONGER USED |
secondphoneAuthText | secondphone_auth_text | SZRAPLY | SECONDPHONE_AUTH_TEXT | NO LONGER USED |
enrollStatus | enroll_status | SZRAPLY | ENROLL_STATUS |
|
hsEduLevel | hs_edu_level | SZRAPLY | HS_EDU_LEVEL |
|
hsCompDate | hs_comp_date | SZRAPLY | HS_COMP_DATE |
|
higherEduLevel | higher_edu_level | SZRAPLY | HIGHER_EDU_LEVEL |
|
higherCompDate | higher_comp_date | SZRAPLY | HIGHER_COMP_DATE |
|
hsNotAttended | hs_not_attended | SZRAPLY | HS_NOT_ATTENDED |
|
cahsGraduated | cahs_graduated | SZRAPLY | CAHS_GRADUATED |
|