CCCApply Standard Application SuperGlue Data Mappings - Banner

The tables below pertain to the CCCApply Standard & Noncredit Applications.

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

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
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
email	email	SZRAPLY	EMAIL
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
cahs3year	cahs_3year	SZRAPLY	CAHS_3YEAR
hsName	hs_name	SZRAPLY	HS_NAME
hsCity	hs_city	SZRAPLY	HS_CITY
hsState	hs_state	SZRAPLY	HS_STATE
hsCountry	hs_country	SZRAPLY	HS_COUNTRY
hsCds	hs_cds	SZRAPLY	HS_CDS
hsCeeb	hs_ceeb	SZRAPLY	HS_CEEB
hsNotListed	hs_not_listed	SZRAPLY	HS_NOT_LISTED
homeSchooled	home_schooled	SZRAPLY	HOME_SCHOOLED
collegeCount	college_count	SZRAPLY	COLLEGE_COUNT
hsAttendance	hs_attendance	SZRAPLY	HS_ATTENDANCE
coenrollConfirm	coenroll_confirm	SZRAPLY	COENROLL_CONFIRM
gender	gender	SZRAPLY	GENDER
pgFirstname	pg_firstname	SZRAPLY	PG_FIRSTNAME
pgLastname	pg_lastname	SZRAPLY	PG_LASTNAME
pgRel	pg_rel	SZRAPLY	PG_REL
pg1Edu	pg1_edu	SZRAPLY	PG1_EDU
pg2Edu	pg2_edu	SZRAPLY	PG2_EDU
pgEduMis	pg_edu_mis	SZRAPLY	PG_EDU_MIS
under19Ind	under19_ind	SZRAPLY	UNDER19_IND
dependentStatus	dependent_status	SZRAPLY	DEPENDENT_STATUS
raceEthnic	race_ethnic	SZRAPLY	RACE_ETHNIC
hispanic	hispanic	SZRAPLY	HISPANIC
raceGroup	race_group	SZRAPLY	RACE_GROUP
raceEthnicFull	race_ethnic_full	SZRAPLY	RACE_ETHNIC_FULL
ssn	ssn	SZRAPLY	SSN
birthdate	birthdate	SZRAPLY	BIRTHDATE
firstname	firstname	SZRAPLY	FIRSTNAME
middlename	middlename	SZRAPLY	MIDDLENAME
lastname	lastname	SZRAPLY	LASTNAME
suffix	suffix	SZRAPLY	SUFFIX
otherfirstname	otherfirstname	SZRAPLY	OTHERFIRSTNAME
othermiddlename	othermiddlename	SZRAPLY	OTHERMIDDLENAME
otherlastname	otherlastname	SZRAPLY	OTHERLASTNAME
citizenshipStatus	citizenship_status	SZRAPLY	CITIZENSHIP_STATUS
alienRegNumber	alien_reg_number	SZRAPLY	ALIEN_REG_NUMBER
visaType	visa_type	SZRAPLY	VISA_TYPE
noDocuments	no_documents	SZRAPLY	NO_DOCUMENTS
alienRegIssueDate	alien_reg_issue_date	SZRAPLY	ALIEN_REG_ISSUE_DATE
alienRegExpireDate	alien_reg_expire_date	SZRAPLY	ALIEN_REG_EXPIRE_DATE
alienRegNoExpire	alien_reg_no_expire	SZRAPLY	ALIEN_REG_NO_EXPIRE
militaryStatus	military_status	SZRAPLY	MILITARY_STATUS
militaryDischargeDate	military_discharge_date	SZRAPLY	MILITARY_DISCHARGE_DATE
militaryHomeState	military_home_state	SZRAPLY	MILITARY_HOME_STATE
militaryHomeCountry	military_home_country	SZRAPLY	MILITARY_HOME_COUNTRY
militaryCaStationed	military_ca_stationed	SZRAPLY	MILITARY_CA_STATIONED
militaryLegalResidence	military_legal_residence	SZRAPLY	MILITARY_LEGAL_RESIDENCE
caRes2Years	ca_res_2_years	SZRAPLY	CA_RES_2_YEARS
caDateCurrent	ca_date_current	SZRAPLY	CA_DATE_CURRENT
caNotArrived	ca_not_arrived	SZRAPLY	CA_NOT_ARRIVED
caCollegeEmployee	ca_college_employee	SZRAPLY	CA_COLLEGE_EMPLOYEE
caSchoolEmployee	ca_school_employee	SZRAPLY	CA_SCHOOL_EMPLOYEE
caSeasonalAg	ca_seasonal_ag	SZRAPLY	CA_SEASONAL_AG
caFosterYouth	ca_foster_youth	SZRAPLY	CA_FOSTER_YOUTH
caOutsideTax	ca_outside_tax	SZRAPLY	CA_OUTSIDE_TAX
caOutsideTaxYear	ca_outside_tax_year	SZRAPLY	CA_OUTSIDE_TAX_YEAR
caOutsideVoted	ca_outside_voted	SZRAPLY	CA_OUTSIDE_VOTED
caOutsideVotedYear	ca_outside_voted_year	SZRAPLY	CA_OUTSIDE_VOTED_YEAR
caOutsideCollege	ca_outside_college	SZRAPLY	CA_OUTSIDE_COLLEGE
caOutsideCollegeYear	ca_outside_college_year	SZRAPLY	CA_OUTSIDE_COLLEGE_YEAR
caOutsideLawsuit	ca_outside_lawsuit	SZRAPLY	CA_OUTSIDE_LAWSUIT
caOutsideLawsuitYear	ca_outside_lawsuit_year	SZRAPLY	CA_OUTSIDE_LAWSUIT_YEAR
resStatus	res_status	SZRAPLY	RES_STATUS
resStatusChange	res_status_change	SZRAPLY	RES_STATUS_CHANGE
resPrevDate	res_prev_date	SZRAPLY	RES_PREV_DATE
admIneligible	adm_ineligible	SZRAPLY	ADM_INELIGIBLE
eligAb540	elig_ab540	SZRAPLY	ELIG_AB540
resAreaA	res_area_a	SZRAPLY	RES_AREA_A
resAreaB	res_area_b	SZRAPLY	RES_AREA_B
resAreaC	res_area_c	SZRAPLY	RES_AREA_C
resAreaD	res_area_d	SZRAPLY	RES_AREA_D
experience	experience	SZRAPLY	EXPERIENCE
recommend	recommend	SZRAPLY	RECOMMEND
comments	comments	SZRAPLY	COMMENTS
comfortableEnglish	comfortable_english	SZRAPLY	COMFORTABLE_ENGLISH
financialAssistance	financial_assistance	SZRAPLY	FINANCIAL_ASSISTANCE
tanfSsiGa	tanf_ssi_ga	SZRAPLY	TANF_SSI_GA
fosterYouths	foster_youths	SZRAPLY	FOSTER_YOUTHS
athleticIntercollegiate	athletic_intercollegiate	SZRAPLY	ATHLETIC_INTERCOLLEGIATE
athleticIntramural	athletic_intramural	SZRAPLY	ATHLETIC_INTRAMURAL
athleticNotInterested	athletic_not_interested	SZRAPLY	ATHLETIC_NOT_INTERESTED
academicCounseling	academic_counseling	SZRAPLY	ACADEMIC_COUNSELING
basicSkills	basic_skills	SZRAPLY	BASIC_SKILLS
calworks	calworks	SZRAPLY	CALWORKS
careerPlanning	career_planning	SZRAPLY	CAREER_PLANNING
childCare	child_care	SZRAPLY	CHILD_CARE
counselingPersonal	counseling_personal	SZRAPLY	COUNSELING_PERSONAL
dsps	dsps	SZRAPLY	DSPS
eops	eops	SZRAPLY	EOPS
esl	esl	SZRAPLY	ESL
healthServices	health_services	SZRAPLY	HEALTH_SERVICES
housingInfo	housing_info	SZRAPLY	HOUSING_INFO
employmentAssistance	employment_assistance	SZRAPLY	EMPLOYMENT_ASSISTANCE
onlineClasses	online_classes	SZRAPLY	ONLINE_CLASSES
reentryProgram	reentry_program	SZRAPLY	REENTRY_PROGRAM
scholarshipInfo	scholarship_info	SZRAPLY	SCHOLARSHIP_INFO
studentGovernment	student_government	SZRAPLY	STUDENT_GOVERNMENT
testingAssessment	testing_assessment	SZRAPLY	TESTING_ASSESSMENT
transferInfo	transfer_info	SZRAPLY	TRANSFER_INFO
tutoringServices	tutoring_services	SZRAPLY	TUTORING_SERVICES
veteransServices	veterans_services	SZRAPLY	VETERANS_SERVICES
integrityFg01	integrity_fg_01	SZRAPLY	INTEGRITY_FG_01
integrityFg02	integrity_fg_02	SZRAPLY	INTEGRITY_FG_02
integrityFg03	integrity_fg_03	SZRAPLY	INTEGRITY_FG_03
integrityFg04	integrity_fg_04	SZRAPLY	INTEGRITY_FG_04
integrityFg11	integrity_fg_11	SZRAPLY	INTEGRITY_FG_11
integrityFg47	integrity_fg_47	SZRAPLY	INTEGRITY_FG_47
integrityFg48	integrity_fg_48	SZRAPLY	INTEGRITY_FG_48
integrityFg49	integrity_fg_49	SZRAPLY	INTEGRITY_FG_49
integrityFg50	integrity_fg_50	SZRAPLY	INTEGRITY_FG_50
integrityFg51	integrity_fg_51	SZRAPLY	INTEGRITY_FG_51
integrityFg52	integrity_fg_52	SZRAPLY	INTEGRITY_FG_52
integrityFg53	integrity_fg_53	SZRAPLY	INTEGRITY_FG_53
integrityFg54	integrity_fg_54	SZRAPLY	INTEGRITY_FG_54
integrityFg55	integrity_fg_55	SZRAPLY	INTEGRITY_FG_55
integrityFg56	integrity_fg_56	SZRAPLY	INTEGRITY_FG_56
integrityFg57	integrity_fg_57	SZRAPLY	INTEGRITY_FG_57
integrityFg58	integrity_fg_58	SZRAPLY	INTEGRITY_FG_58
integrityFg59	integrity_fg_59	SZRAPLY	INTEGRITY_FG_59
integrityFg60	integrity_fg_60	SZRAPLY	INTEGRITY_FG_60
integrityFg61	integrity_fg_61	SZRAPLY	INTEGRITY_FG_61
integrityFg62	integrity_fg_62	SZRAPLY	INTEGRITY_FG_62
integrityFg63	integrity_fg_63	SZRAPLY	INTEGRITY_FG_63
integrityFg70	integrity_fg_70	SZRAPLY	INTEGRITY_FG_70
integrityFg80	integrity_fg_80	SZRAPLY	INTEGRITY_FG_80
col1Ceeb	col1_ceeb	SZRAPLY	COL1_CEEB
col1Cds	col1_cds	SZRAPLY	COL1_CDS
col1NotListed	col1_not_listed	SZRAPLY	COL1_NOT_LISTED
col1Name	col1_name	SZRAPLY	COL1_NAME
col1City	col1_city	SZRAPLY	COL1_CITY
col1State	col1_state	SZRAPLY	COL1_STATE
col1Country	col1_country	SZRAPLY	COL1_COUNTRY
col1StartDate	col1_start_date	SZRAPLY	COL1_START_DATE
col1EndDate	col1_end_date	SZRAPLY	COL1_END_DATE
col1DegreeDate	col1_degree_date	SZRAPLY	COL1_DEGREE_DATE
col1DegreeObtained	col1_degree_obtained	SZRAPLY	COL1_DEGREE_OBTAINED
col2Ceeb	col2_ceeb	SZRAPLY	COL2_CEEB
col2Cds	col2_cds	SZRAPLY	COL2_CDS
col2NotListed	col2_not_listed	SZRAPLY	COL2_NOT_LISTED
col2Name	col2_name	SZRAPLY	COL2_NAME
col2City	col2_city	SZRAPLY	COL2_CITY
col2State	col2_state	SZRAPLY	COL2_STATE
col2Country	col2_country	SZRAPLY	COL2_COUNTRY
col2StartDate	col2_start_date	SZRAPLY	COL2_START_DATE
col2EndDate	col2_end_date	SZRAPLY	COL2_END_DATE
col2DegreeDate	col2_degree_date	SZRAPLY	COL2_DEGREE_DATE
col2DegreeObtained	col2_degree_obtained	SZRAPLY	COL2_DEGREE_OBTAINED
col3Ceeb	col3_ceeb	SZRAPLY	COL3_CEEB
col3Cds	col3_cds	SZRAPLY	COL3_CDS
col3NotListed	col3_not_listed	SZRAPLY	COL3_NOT_LISTED
col3Name	col3_name	SZRAPLY	COL3_NAME
col3City	col3_city	SZRAPLY	COL3_CITY
col3State	col3_state	SZRAPLY	COL3_STATE
col3Country	col3_country	SZRAPLY	COL3_COUNTRY
col3StartDate	col3_start_date	SZRAPLY	COL3_START_DATE
col3EndDate	col3_end_date	SZRAPLY	COL3_END_DATE
col3DegreeDate	col3_degree_date	SZRAPLY	COL3_DEGREE_DATE
col3DegreeObtained	col3_degree_obtained	SZRAPLY	COL3_DEGREE_OBTAINED
col4Ceeb	col4_ceeb	SZRAPLY	COL4_CEEB
col4Cds	col4_cds	SZRAPLY	COL4_CDS
col4NotListed	col4_not_listed	SZRAPLY	COL4_NOT_LISTED
col4Name	col4_name	SZRAPLY	COL4_NAME
col4City	col4_city	SZRAPLY	COL4_CITY
col4State	col4_state	SZRAPLY	COL4_STATE
col4Country	col4_country	SZRAPLY	COL4_COUNTRY
col4StartDate	col4_start_date	SZRAPLY	COL4_START_DATE
col4EndDate	col4_end_date	SZRAPLY	COL4_END_DATE
col4DegreeDate	col4_degree_date	SZRAPLY	COL4_DEGREE_DATE
col4DegreeObtained	col4_degree_obtained	SZRAPLY	COL4_DEGREE_OBTAINED
collegeName	college_name	SZRAPLY	COLLEGE_NAME
districtName	district_name	SZRAPLY	DISTRICT_NAME
termCode	term_code	SZRAPLY	TERM_CODE
termDescription	term_description	SZRAPLY	TERM_DESCRIPTION
majorCode	major_code	SZRAPLY	MAJOR_CODE
majorDescription	major_description	SZRAPLY	MAJOR_DESCRIPTION
tstmpSubmit	tstmp_submit	SZRAPLY	TSTMP_SUBMIT
tstmpCreate	tstmp_create	SZRAPLY	TSTMP_CREATE
tstmpUpdate	tstmp_update	SZRAPLY	TSTMP_UPDATE
ssnDisplay	ssn_display	SZRAPLY	SSN_DISPLAY
fosterYouthStatus	foster_youth_status	SZRAPLY	FOSTER_YOUTH_STATUS
fosterYouthPreference	foster_youth_preference	SZRAPLY	FOSTER_YOUTH_PREFERENCE
fosterYouthMis	foster_youth_mis	SZRAPLY	FOSTER_YOUTH_MIS
fosterYouthPriority	foster_youth_priority	SZRAPLY	FOSTER_YOUTH_PRIORITY
tstmpDownload	tstmp_download	SZRAPLY	TSTMP_DOWNLOAD
addressValidation	address_validation	SZRAPLY	ADDRESS_VALIDATION
zip4	zip4	SZRAPLY	ZIP4
permAddressValidation	perm_address_validation	SZRAPLY	PERM_ADDRESS_VALIDATION
permZip4	perm_zip4	SZRAPLY	PERM_ZIP4
dischargeType	discharge_type	SZRAPLY	DISCHARGE_TYPE
collegeExpelledSummary	college_expelled_summary	SZRAPLY	COLLEGE_EXPELLED_SUMMARY
col1ExpelledStatus	col1_expelled_status	SZRAPLY	COL1_EXPELLED_STATUS
col2ExpelledStatus	col2_expelled_status	SZRAPLY	COL2_EXPELLED_STATUS
col3ExpelledStatus	col3_expelled_status	SZRAPLY	COL3_EXPELLED_STATUS
col4ExpelledStatus	col4_expelled_status	SZRAPLY	COL4_EXPELLED_STATUS
integrityFlags	integrity_flags	SZRAPLY	INTEGRITY_FLAGS
rdd	rdd	SZRAPLY	RDD
ssnType	ssn_type	SZRAPLY	SSN_TYPE
militaryStationedCaEd	military_stationed_ca_ed	SZRAPLY	MILITARY_STATIONED_CA_ED
integrityFg65	integrity_fg_65	SZRAPLY	INTEGRITY_FG_65
integrityFg64	integrity_fg_64	SZRAPLY	INTEGRITY_FG_64
ipAddress	ip_address	SZRAPLY	IP_ADDRESS
campaign1	campaign1	SZRAPLY	CAMPAIGN1
campaign2	campaign2	SZRAPLY	CAMPAIGN2
campaign3	campaign3	SZRAPLY	CAMPAIGN3
orientation	orientation	SZRAPLY	ORIENTATION_ENCRYPTED
transgender	transgender	SZRAPLY	TRANSGENDER_ENCRYPTED
ssnException	ssn_exception	SZRAPLY	SSN_EXCEPTION
integrityFg71	integrity_fg_71	SZRAPLY	INTEGRITY_FG_71
preferredFirstname	preferred_firstname	SZRAPLY	PREFERRED_FIRSTNAME
preferredMiddlename	preferred_middlename	SZRAPLY	PREFERRED_MIDDLENAME
preferredLastname	preferred_lastname	SZRAPLY	PREFERRED_LASTNAME
preferredName	preferred_name	SZRAPLY	PREFERRED_NAME
ssnNo	ssn_no	SZRAPLY	SSN_NO
completedEleventhGrade	completed_eleventh_grade	SZRAPLY	COMPLETED_ELEVENTH_GRADE	NO LONGER USED
gradePointAverage	grade_point_average	SZRAPLY	GRADE_POINT_AVERAGE
highestEnglishCourse	highest_english_course	SZRAPLY	HIGHEST_ENGLISH_COURSE
highestEnglishGrade	highest_english_grade	SZRAPLY	HIGHEST_ENGLISH_GRADE
highestMathCourseTaken	highest_math_course_taken	SZRAPLY	HIGHEST_MATH_COURSE_TAKEN
highestMathTakenGrade	highest_math_taken_grade	SZRAPLY	HIGHEST_MATH_TAKEN_GRADE
highestMathCoursePassed	highest_math_course_passed	SZRAPLY	HIGHEST_MATH_COURSE_PASSED
highestMathPassedGrade	highest_math_passed_grade	SZRAPLY	HIGHEST_MATH_PASSED_GRADE
integrityFg30	integrity_fg_30	SZRAPLY	INTEGRITY_FG_30
hsCdsFull	hs_cds_full	SZRAPLY	HS_CDS_FULL
col1CdsFull	col1_cds_full	SZRAPLY	COL1_CDS_FULL
col2CdsFull	col2_cds_full	SZRAPLY	COL2_CDS_FULL
col3CdsFull	col3_cds_full	SZRAPLY	COL3_CDS_FULL
col4CdsFull	col4_cds_full	SZRAPLY	NOCOL4_CDS_FULL
ssid	ssid	SZRAPLY	SSID
noPermAddressHomeless	no_perm_address_homeless	SZRAPLY	NO_PERM_ADDRESS_HOMELESS
noMailingAddressHomeless	no_mailing_address_homeless	SZRAPLY	NO_MAILING_ADDRESS_HOMELESS
termStart	term_start	SZRAPLY	TERM_START
termEnd	term_end	SZRAPLY	TERM_END
homelessYouth	homeless_youth	SZRAPLY	HOMELESS_YOUTH
integrityFg40	integrity_fg_40	SZRAPLY	INTEGRITY_FG_40
cipCode	cip_code	SZRAPLY	CIP_CODE
majorCategory	major_category	SZRAPLY	MAJOR_CATEGORY
mainphoneintl	mainphoneintl	SZRAPLY	MAINPHONEINTL	No Longer Used
secondphoneintl	secondphoneintl	SZRAPLY	SECONDPHONEINTL	No Longer Used
nonCredit	non_credit	SZRAPLY	NON_CREDIT
integrityFg81	integrity_fg_81	SZRAPLY	INTEGRITY_FG_81
highestGradeCompleted	highest_grade_completed	SZRAPLY	HIGHEST_GRADE_COMPLETED
emailVerified	email_verified	SZRAPLY	EMAIL_VERIFIED	SG v.4.7
emailVerifiedTimestamp	email_verified_timestamp	SZRAPLY	EMAIL_VERIFIED_TSTMP	SG v.4.7
mainphoneVerified	phone_verified	SZRAPLY	PHONE_VERIFIED	SG v.4.7
mainphoneVerifiedTimestamp	phone_verified_timestamp	SZRAPLY	PHONE_VERIFIED_TSTMP	SG v.4.7
preferredMethodOfContact	preferred_contact_method	SZRAPLY	PREF_CONTACT_METHOD	SG v.4.7
addressValidationOverride	address_validation_override	SZRAPLY	ADDRESS_VAL_OVERRIDE	SG v.4.7
addressValidationOverrideTimestamp	address_validation_override_timestamp	SZRAPLY	ADDRESS_VAL_OVER_TSTMP	SG v.4.7

Supplemental Questions Data Fields Mappings - Banner

The table below pertains to the Supplemental Questions for the Standard/Noncredit Application

College Adaptor Payload Name	CCC Field Name	Banner DB Staging Table	Banner Field Name	Explanation

College Adaptor Payload Name	CCC Field Name	Banner DB Staging Table	Banner Field Name	Explanation
appId	app_id	SZRAPLY	APP_ID	See here
suppText01	supp_text_01	SZRAPLY	SUPP_TEXT_01	See here
suppText02	supp_text_02	SZRAPLY	SUPP_TEXT_02	See here
suppText03	supp_text_03	SZRAPLY	SUPP_TEXT_03	See here
suppText04	supp_text_04	SZRAPLY	SUPP_TEXT_04	See here
suppText05	supp_text_05	SZRAPLY	SUPP_TEXT_05	See here
suppText06	supp_text_06	SZRAPLY	SUPP_TEXT_06	See here
suppText07	supp_text_07	SZRAPLY	SUPP_TEXT_07	See here
suppText08	supp_text_08	SZRAPLY	SUPP_TEXT_08	See here
suppText09	supp_text_09	SZRAPLY	SUPP_TEXT_09	See here
suppText10	supp_text_10	SZRAPLY	SUPP_TEXT_10	See here
suppText11	supp_text_11	SZRAPLY	SUPP_TEXT_11	See here
suppText12	supp_text_12	SZRAPLY	SUPP_TEXT_12	See here
suppText13	supp_text_13	SZRAPLY	SUPP_TEXT_13	See here
suppText14	supp_text_14	SZRAPLY	SUPP_TEXT_14	See here
suppText15	supp_text_15	SZRAPLY	SUPP_TEXT_15	See here
suppText16	supp_text_16	SZRAPLY	SUPP_TEXT_16	See here
suppText17	supp_text_17	SZRAPLY	SUPP_TEXT_17	See here
suppText18	supp_text_18	SZRAPLY	SUPP_TEXT_18	See here
suppText19	supp_text_19	SZRAPLY	SUPP_TEXT_19	See here
suppText20	supp_text_20	SZRAPLY	SUPP_TEXT_20	See here
suppCheck01	supp_check_01	SZRAPLY	SUPP_CHECK_01	See here
suppCheck02	supp_check_02	SZRAPLY	SUPP_CHECK_02	See here
suppCheck03	supp_check_03	SZRAPLY	SUPP_CHECK_03	See here
suppCheck04	supp_check_04	SZRAPLY	SUPP_CHECK_04	See here
suppCheck05	supp_check_05	SZRAPLY	SUPP_CHECK_05	See here
suppCheck06	supp_check_06	SZRAPLY	SUPP_CHECK_06	See here
suppCheck07	supp_check_07	SZRAPLY	SUPP_CHECK_07	See here
suppCheck08	supp_check_08	SZRAPLY	SUPP_CHECK_08	See here
suppCheck09	supp_check_09	SZRAPLY	SUPP_CHECK_09	See here
suppCheck10	supp_check_10	SZRAPLY	SUPP_CHECK_10	See here
suppCheck11	supp_check_11	SZRAPLY	SUPP_CHECK_11	See here
suppCheck12	supp_check_12	SZRAPLY	SUPP_CHECK_12	See here
suppCheck13	supp_check_13	SZRAPLY	SUPP_CHECK_13	See here
suppCheck14	supp_check_14	SZRAPLY	SUPP_CHECK_14	See here
suppCheck15	supp_check_15	SZRAPLY	SUPP_CHECK_15	See here
suppCheck16	supp_check_16	SZRAPLY	SUPP_CHECK_16	See here
suppCheck17	supp_check_17	SZRAPLY	SUPP_CHECK_17	See here
suppCheck18	supp_check_18	SZRAPLY	SUPP_CHECK_18	See here
suppCheck19	supp_check_19	SZRAPLY	SUPP_CHECK_19	See here
suppCheck20	supp_check_20	SZRAPLY	SUPP_CHECK_20	See here
suppCheck21	supp_check_21	SZRAPLY	SUPP_CHECK_21	See here
suppCheck22	supp_check_22	SZRAPLY	SUPP_CHECK_22	See here
suppCheck23	supp_check_23	SZRAPLY	SUPP_CHECK_23	See here
suppCheck24	supp_check_24	SZRAPLY	SUPP_CHECK_24	See here
suppCheck25	supp_check_25	SZRAPLY	SUPP_CHECK_25	See here
suppCheck26	supp_check_26	SZRAPLY	SUPP_CHECK_26	See here
suppCheck27	supp_check_27	SZRAPLY	SUPP_CHECK_27	See here
suppCheck28	supp_check_28	SZRAPLY	SUPP_CHECK_28	See here
suppCheck29	supp_check_29	SZRAPLY	SUPP_CHECK_29	See here
suppCheck30	supp_check_30	SZRAPLY	SUPP_CHECK_30	See here
suppCheck31	supp_check_31	SZRAPLY	SUPP_CHECK_31	See here
suppCheck32	supp_check_32	SZRAPLY	SUPP_CHECK_32	See here
suppCheck33	supp_check_33	SZRAPLY	SUPP_CHECK_33	See here
suppCheck34	supp_check_34	SZRAPLY	SUPP_CHECK_34	See here
suppCheck35	supp_check_35	SZRAPLY	SUPP_CHECK_35	See here
suppCheck36	supp_check_36	SZRAPLY	SUPP_CHECK_36	See here
suppCheck37	supp_check_37	SZRAPLY	SUPP_CHECK_37	See here
suppCheck38	supp_check_38	SZRAPLY	SUPP_CHECK_38	See here
suppCheck39	supp_check_39	SZRAPLY	SUPP_CHECK_39	See here
suppCheck40	supp_check_40	SZRAPLY	SUPP_CHECK_40	See here
suppCheck41	supp_check_41	SZRAPLY	SUPP_CHECK_41	See here
suppCheck42	supp_check_42	SZRAPLY	SUPP_CHECK_42	See here
suppCheck43	supp_check_43	SZRAPLY	SUPP_CHECK_43	See here
suppCheck44	supp_check_44	SZRAPLY	SUPP_CHECK_44	See here
suppCheck45	supp_check_45	SZRAPLY	SUPP_CHECK_45	See here
suppCheck46	supp_check_46	SZRAPLY	SUPP_CHECK_46	See here
suppCheck47	supp_check_47	SZRAPLY	SUPP_CHECK_47	See here
suppCheck48	supp_check_48	SZRAPLY	SUPP_CHECK_48	See here
suppCheck49	supp_check_49	SZRAPLY	SUPP_CHECK_49	See here
suppCheck50	supp_check_50	SZRAPLY	SUPP_CHECK_50	See here
suppYesno01	supp_yesno_01	SZRAPLY	SUPP_YESNO_01	See here
suppYesno02	supp_yesno_02	SZRAPLY	SUPP_YESNO_02	See here
suppYesno03	supp_yesno_03	SZRAPLY	SUPP_YESNO_03	See here
suppYesno04	supp_yesno_04	SZRAPLY	SUPP_YESNO_04	See here
suppYesno05	supp_yesno_05	SZRAPLY	SUPP_YESNO_05	See here
suppYesno06	supp_yesno_06	SZRAPLY	SUPP_YESNO_06	See here
suppYesno07	supp_yesno_07	SZRAPLY	SUPP_YESNO_07	See here
suppYesno08	supp_yesno_08	SZRAPLY	SUPP_YESNO_08	See here
suppYesno09	supp_yesno_09	SZRAPLY	SUPP_YESNO_09	See here
suppYesno10	supp_yesno_10	SZRAPLY	SUPP_YESNO_10	See here
suppYesno11	supp_yesno_11	SZRAPLY	SUPP_YESNO_11	See here
suppYesno12	supp_yesno_12	SZRAPLY	SUPP_YESNO_12	See here
suppYesno13	supp_yesno_13	SZRAPLY	SUPP_YESNO_13	See here
suppYesno14	supp_yesno_14	SZRAPLY	SUPP_YESNO_14	See here
suppYesno15	supp_yesno_15	SZRAPLY	SUPP_YESNO_15	See here
suppYesno16	supp_yesno_16	SZRAPLY	SUPP_YESNO_16	See here
suppYesno17	supp_yesno_17	SZRAPLY	SUPP_YESNO_17	See here
suppYesno18	supp_yesno_18	SZRAPLY	SUPP_YESNO_18	See here
suppYesno19	supp_yesno_19	SZRAPLY	SUPP_YESNO_19	See here
suppYesno20	supp_yesno_20	SZRAPLY	SUPP_YESNO_20	See here
suppYesno21	supp_yesno_21	SZRAPLY	SUPP_YESNO_21	See here
suppYesno22	supp_yesno_22	SZRAPLY	SUPP_YESNO_22	See here
suppYesno23	supp_yesno_23	SZRAPLY	SUPP_YESNO_23	See here
suppYesno24	supp_yesno_24	SZRAPLY	SUPP_YESNO_24	See here
suppYesno25	supp_yesno_25	SZRAPLY	SUPP_YESNO_25	See here
suppYesno26	supp_yesno_26	SZRAPLY	SUPP_YESNO_26	See here
suppYesno27	supp_yesno_27	SZRAPLY	SUPP_YESNO_27	See here
suppYesno28	supp_yesno_28	SZRAPLY	SUPP_YESNO_28	See here
suppYesno29	supp_yesno_29	SZRAPLY	SUPP_YESNO_29	See here
suppYesno30	supp_yesno_30	SZRAPLY	SUPP_YESNO_30	See here
suppMenu01	supp_menu_01	SZRAPLY	SUPP_MENU_01	See here
suppMenu02	supp_menu_02	SZRAPLY	SUPP_MENU_02	See here
suppMenu03	supp_menu_03	SZRAPLY	SUPP_MENU_03	See here
suppMenu04	supp_menu_04	SZRAPLY	SUPP_MENU_04	See here
suppMenu05	supp_menu_05	SZRAPLY	SUPP_MENU_05	See here
suppMenu06	supp_menu_06	SZRAPLY	SUPP_MENU_06	See here
suppMenu07	supp_menu_07	SZRAPLY	SUPP_MENU_07	See here
suppMenu08	supp_menu_08	SZRAPLY	SUPP_MENU_08	See here
suppMenu09	supp_menu_09	SZRAPLY	SUPP_MENU_09	See here
suppMenu10	supp_menu_10	SZRAPLY	SUPP_MENU_10	See here
suppMenu11	supp_menu_11	SZRAPLY	SUPP_MENU_11	See here
suppMenu12	supp_menu_12	SZRAPLY	SUPP_MENU_12	See here
suppMenu13	supp_menu_13	SZRAPLY	SUPP_MENU_13	See here
suppMenu14	supp_menu_14	SZRAPLY	SUPP_MENU_14	See here
suppMenu15	supp_menu_15	SZRAPLY	SUPP_MENU_15	See here
suppMenu16	supp_menu_16	SZRAPLY	SUPP_MENU_16	See here
suppMenu17	supp_menu_17	SZRAPLY	SUPP_MENU_17	See here
suppMenu18	supp_menu_18	SZRAPLY	SUPP_MENU_18	See here
suppMenu19	supp_menu_19	SZRAPLY	SUPP_MENU_19	See here
suppMenu20	supp_menu_20	SZRAPLY	SUPP_MENU_20	See here
suppMenu21	supp_menu_21	SZRAPLY	SUPP_MENU_21	See here
suppMenu22	supp_menu_22	SZRAPLY	SUPP_MENU_22	See here
suppMenu23	supp_menu_23	SZRAPLY	SUPP_MENU_23	See here
suppMenu24	supp_menu_24	SZRAPLY	SUPP_MENU_24	See here
suppMenu25	supp_menu_25	SZRAPLY	SUPP_MENU_25	See here
suppMenu26	supp_menu_26	SZRAPLY	SUPP_MENU_26	See here
suppMenu27	supp_menu_27	SZRAPLY	SUPP_MENU_27	See here
suppMenu28	supp_menu_28	SZRAPLY	SUPP_MENU_28	See here
suppMenu29	supp_menu_29	SZRAPLY	SUPP_MENU_29	See here
suppMenu30	supp_menu_30	SZRAPLY	SUPP_MENU_30	See here
suppDate01	supp_date_01	SZRAPLY	SUPP_DATE_01	See here
suppDate02	supp_date_02	SZRAPLY	SUPP_DATE_02	See here
suppDate03	supp_date_03	SZRAPLY	SUPP_DATE_03	See here
suppDate04	supp_date_04	SZRAPLY	SUPP_DATE_04	See here
suppDate05	supp_date_05	SZRAPLY	SUPP_DATE_05	See here
suppState01	supp_state_01	SZRAPLY	SUPP_STATE_01	See here
suppState02	supp_state_02	SZRAPLY	SUPP_STATE_02	See here
suppState03	supp_state_03	SZRAPLY	SUPP_STATE_03	See here
suppState04	supp_state_04	SZRAPLY	SUPP_STATE_04	See here
suppState05	supp_state_05	SZRAPLY	SUPP_STATE_05	See here
suppCountry01	supp_country_01	SZRAPLY	SUPP_COUNTRY_01	See here
suppCountry02	supp_country_02	SZRAPLY	SUPP_COUNTRY_02	See here
suppCountry03	supp_country_03	SZRAPLY	SUPP_COUNTRY_03	See here
suppCountry04	supp_country_04	SZRAPLY	SUPP_COUNTRY_04	See here
suppCountry05	supp_country_05	SZRAPLY	SUPP_COUNTRY_05	See here
suppPhonenumber01	supp_phonenumber_01	SZRAPLY	SUPP_PHONENUMBER_01	See here
suppPhonenumber02	supp_phonenumber_02	SZRAPLY	SUPP_PHONENUMBER_02	See here
suppPhonenumber03	supp_phonenumber_03	SZRAPLY	SUPP_PHONENUMBER_03	See here
suppPhonenumber04	supp_phonenumber_04	SZRAPLY	SUPP_PHONENUMBER_04	See here
suppPhonenumber05	supp_phonenumber_05	SZRAPLY	SUPP_PHONENUMBER_05	See here
suppSecret01	supp_secret_01	SZRAPLY	SUPP_SECRET_01	See here
suppSecret02	supp_secret_02	SZRAPLY	SUPP_SECRET_02	See here
suppSecret03	supp_secret_03	SZRAPLY	SUPP_SECRET_03	See here
suppSecret04	supp_secret_04	SZRAPLY	SUPP_SECRET_04	See here
suppSecret05	supp_secret_05	SZRAPLY	SUPP_SECRET_05	See here

CCCApply Public Documentation

CCCApply Standard Application SuperGlue Data Mappings - Banner

On This Page:

Standard Data Fields Table Mapping - Banner

Supplemental Questions Data Fields Mappings - Banner