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

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