Page Comparison

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

...

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

...

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

...

Versions Compared

Old Version 4

New Version 5

Key