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

College Adaptor Payload Name

CCC Field Name

Banner DB Staging Table

Banner Field Name

Notes

idmeConfirmationTimestamp

idme_confirmation_timestamp

SZRAPLY

IDME_CONFIRMATION_TSTMP

SG v.4.9 PILOT

idmeOptinTimestamp

idme_optin_timestamp

SZRAPLY

IDME_OPTIN_TSTMP

SG v.4.9 PILOT

idmeWorkflowStatus

idme_workflow_status

SZRAPLY

IDME_WORKFLOW_STATUS

SG v.4.9 PILOT

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