CCCApply Standard Application SuperGlue Data Mappings - Banner

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

Contents

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

Explanation

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

 

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