Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

The tables below pertain to the latest CCCApply Standard & Noncredit Application version. For more information, see CCCApply Release Notes & Data Dictionaries.

On This Page:

Standard Data Fields Table Mapping - MSQL

For field specifications, see the CCCApply Standard & Noncredit Application data dictionary.

College Adaptor Payload Name

CCC Field Name

DB Staging Table

Notes

studentParent

student_parent

SG v.4.7

acceptedTerms

accepted_terms

SG v.4.6

acceptedTermsTimestamp

accepted_terms_timestamp

SG v.4.6

ipAddressAtAccountCreation

ip_address_at_account_creation

SG v.4.7

ipAddressAtAppCreation

ip_address_at_app_creation

SG v.4.7

mailingAddressValidationOverride

mailing_address_validation_override

SG v.4.7

phoneType

phone_type

SG v.4.7

appId

app_id

cccId

ccc_id

status

status

collegeId

college_id

termId

term_id

NOT USED

majorId

major_id

NOT USED

intendedMajor

intended_major

eduGoal

edu_goal

highestEduLevel

highest_edu_level

consentIndicator

consent_indicator

appLang

app_lang

ackFinAid

ack_fin_aid

finAidRef

fin_aid_ref

confirmation

confirmation

supPageCode

sup_page_code

lastPage

last_page

streetaddress1

streetaddress1

streetaddress2

streetaddress2

city

city

postalcode

postalcode

state

state

nonusaprovince

nonusaprovince

country

country

nonUsAddress

non_us_address

email

email

permStreetaddress1

perm_streetaddress1

permStreetaddress2

perm_streetaddress2

permCity

perm_city

permPostalcode

perm_postalcode

permState

perm_state

permNonusaprovince

perm_nonusaprovince

permCountry

perm_country

addressSame

address_same

mainphone

mainphone

mainphoneExt

mainphone_ext

NO LONGER USED

mainphoneAuthText

mainphone_auth_text

NO LONGER USED

secondphone

secondphone

NO LONGER USED

secondphoneExt

secondphone_ext

NO LONGER USED

secondphoneAuthText

secondphone_auth_text

NO LONGER USED

enrollStatus

enroll_status

hsEduLevel

hs_edu_level

hsCompDate

hs_comp_date

higherEduLevel

higher_edu_level

higherCompDate

higher_comp_date

hsNotAttended

hs_not_attended

cahsGraduated

cahs_graduated

cahs3year

cahs_3year

hsName

hs_name

hsCity

hs_city

hsState

hs_state

hsCountry

hs_country

hsCds

hs_cds

hsCeeb

hs_ceeb

hsNotListed

hs_not_listed

homeSchooled

home_schooled

collegeCount

college_count

hsAttendance

hs_attendance

coenrollConfirm

coenroll_confirm

gender

gender

pgFirstname

pg_firstname

pgLastname

pg_lastname

pgRel

pg_rel

pg1Edu

pg1_edu

pg2Edu

pg2_edu

pgEduMis

pg_edu_mis

under19Ind

under19_ind

dependentStatus

dependent_status

raceEthnic

race_ethnic

hispanic

hispanic

raceGroup

race_group

raceEthnicFull

race_ethnic_full

ssn

ssn

birthdate

birthdate

firstname

firstname

middlename

middlename

lastname

lastname

suffix

suffix

otherfirstname

otherfirstname

othermiddlename

othermiddlename

otherlastname

otherlastname

citizenshipStatus

citizenship_status

alienRegNumber

alien_reg_number

visaType

visa_type

noDocuments

no_documents

alienRegIssueDate

alien_reg_issue_date

alienRegExpireDate

alien_reg_expire_date

alienRegNoExpire

alien_reg_no_expire

militaryStatus

military_status

militaryDischargeDate

military_discharge_date

militaryHomeState

military_home_state

militaryHomeCountry

military_home_country

militaryCaStationed

military_ca_stationed

militaryLegalResidence

military_legal_residence

caRes2Years

ca_res_2_years

caDateCurrent

ca_date_current

caNotArrived

ca_not_arrived

caCollegeEmployee

ca_college_employee

caSchoolEmployee

ca_school_employee

caSeasonalAg

ca_seasonal_ag

caFosterYouth

ca_foster_youth

caOutsideTax

ca_outside_tax

caOutsideTaxYear

ca_outside_tax_year

caOutsideVoted

ca_outside_voted

caOutsideVotedYear

ca_outside_voted_year

caOutsideCollege

ca_outside_college

caOutsideCollegeYear

ca_outside_college_year

caOutsideLawsuit

ca_outside_lawsuit

caOutsideLawsuitYear

ca_outside_lawsuit_year

resStatus

res_status

resStatusChange

res_status_change

resPrevDate

res_prev_date

admIneligible

adm_ineligible

eligAb540

elig_ab540

resAreaA

res_area_a

resAreaB

res_area_b

resAreaC

res_area_c

resAreaD

res_area_d

experience

experience

recommend

recommend

comments

comments

comfortableEnglish

comfortable_english

financialAssistance

financial_assistance

tanfSsiGa

tanf_ssi_ga

fosterYouths

foster_youths

athleticIntercollegiate

athletic_intercollegiate

athleticIntramural

athletic_intramural

athleticNotInterested

athletic_not_interested

academicCounseling

academic_counseling

basicSkills

basic_skills

calworks

calworks

careerPlanning

career_planning

childCare

child_care

counselingPersonal

counseling_personal

dsps

dsps

eops

eops

esl

esl

healthServices

health_services

housingInfo

housing_info

employmentAssistance

employment_assistance

onlineClasses

online_classes

reentryProgram

reentry_program

scholarshipInfo

scholarship_info

studentGovernment

student_government

testingAssessment

testing_assessment

transferInfo

transfer_info

tutoringServices

tutoring_services

veteransServices

veterans_services

integrityFg01

integrity_fg_01

integrityFg02

integrity_fg_02

integrityFg03

integrity_fg_03

integrityFg04

integrity_fg_04

integrityFg11

integrity_fg_11

integrityFg47

integrity_fg_47

integrityFg48

integrity_fg_48

integrityFg49

integrity_fg_49

integrityFg50

integrity_fg_50

integrityFg51

integrity_fg_51

integrityFg52

integrity_fg_52

integrityFg53

integrity_fg_53

integrityFg54

integrity_fg_54

integrityFg55

integrity_fg_55

integrityFg56

integrity_fg_56

integrityFg57

integrity_fg_57

integrityFg58

integrity_fg_58

integrityFg59

integrity_fg_59

integrityFg60

integrity_fg_60

integrityFg61

integrity_fg_61

integrityFg62

integrity_fg_62

integrityFg63

integrity_fg_63

integrityFg70

integrity_fg_70

integrityFg80

integrity_fg_80

col1Ceeb

col1_ceeb

col1Cds

col1_cds

col1NotListed

col1_not_listed

col1Name

col1_name

col1City

col1_city

col1State

col1_state

col1Country

col1_country

col1StartDate

col1_start_date

col1EndDate

col1_end_date

col1DegreeDate

col1_degree_date

col1DegreeObtained

col1_degree_obtained

col2Ceeb

col2_ceeb

col2Cds

col2_cds

col2NotListed

col2_not_listed

col2Name

col2_name

col2City

col2_city

col2State

col2_state

col2Country

col2_country

col2StartDate

col2_start_date

col2EndDate

col2_end_date

col2DegreeDate

col2_degree_date

col2DegreeObtained

col2_degree_obtained

col3Ceeb

col3_ceeb

col3Cds

col3_cds

col3NotListed

col3_not_listed

col3Name

col3_name

col3City

col3_city

col3State

col3_state

col3Country

col3_country

col3StartDate

col3_start_date

col3EndDate

col3_end_date

col3DegreeDate

col3_degree_date

col3DegreeObtained

col3_degree_obtained

col4Ceeb

col4_ceeb

col4Cds

col4_cds

col4NotListed

col4_not_listed

col4Name

col4_name

col4City

col4_city

col4State

col4_state

col4Country

col4_country

col4StartDate

col4_start_date

col4EndDate

col4_end_date

col4DegreeDate

col4_degree_date

col4DegreeObtained

col4_degree_obtained

collegeName

college_name

districtName

district_name

termCode

term_code

termDescription

term_description

majorCode

major_code

majorDescription

major_description

tstmpSubmit

tstmp_submit

tstmpCreate

tstmp_create

tstmpUpdate

tstmp_update

ssnDisplay

ssn_display

fosterYouthStatus

foster_youth_status

fosterYouthPreference

foster_youth_preference

fosterYouthMis

foster_youth_mis

fosterYouthPriority

foster_youth_priority

tstmpDownload

tstmp_download

addressValidation

address_validation

zip4

zip4

permAddressValidation

perm_address_validation

permZip4

perm_zip4

dischargeType

discharge_type

collegeExpelledSummary

college_expelled_summary

col1ExpelledStatus

col1_expelled_status

col2ExpelledStatus

col2_expelled_status

col3ExpelledStatus

col3_expelled_status

col4ExpelledStatus

col4_expelled_status

integrityFlags

integrity_flags

rdd

rdd

ssnType

ssn_type

militaryStationedCaEd

military_stationed_ca_ed

integrityFg65

integrity_fg_65

integrityFg64

integrity_fg_64

ipAddress

ip_address

campaign1

campaign1

campaign2

campaign2

campaign3

campaign3

orientation

orientation

transgender

transgender

ssnException

ssn_exception

integrityFg71

integrity_fg_71

preferredFirstname

preferred_firstname

preferredMiddlename

preferred_middlename

preferredLastname

preferred_lastname

preferredName

preferred_name

ssnNo

ssn_no

completedEleventhGrade

completed_eleventh_grade

NO LONGER USED

gradePointAverage

grade_point_average

highestEnglishCourse

highest_english_course

highestEnglishGrade

highest_english_grade

highestMathCourseTaken

highest_math_course_taken

highestMathTakenGrade

highest_math_taken_grade

highestMathCoursePassed

highest_math_course_passed

highestMathPassedGrade

highest_math_passed_grade

integrityFg30

integrity_fg_30

hsCdsFull

hs_cds_full

col1CdsFull

col1_cds_full

col2CdsFull

col2_cds_full

col3CdsFull

col3_cds_full

col4CdsFull

col4_cds_full

ssid

ssid

noPermAddressHomeless

no_perm_address_homeless

noMailingAddressHomeless

no_mailing_address_homeless

termStart

term_start

termEnd

term_end

homelessYouth

homeless_youth

integrityFg40

integrity_fg_40

cipCode

cip_code

majorCategory

major_category

mainphoneintl

mainphoneintl

No Longer Used

secondphoneintl

secondphoneintl

No Longer Used

nonCredit

non_credit

integrityFg81

integrity_fg_81

highestGradeCompleted

highest_grade_completed

emailVerified

email_verified

SG v.4.7

emailVerifiedTimestamp

email_verified_timestamp

SG v.4.7

mainphoneVerified

phone_verified

SG v.4.7

mainphoneVerifiedTimestamp

phone_verified_timestamp

SG v.4.7

preferredMethodOfContact

preferred_contact_method

SG v.4.7

addressValidationOverride

address_validation_override

SG v.4.7

addressValidationOverrideTimestamp

address_validation_override_timestamp

SG v.4.7

Supplemental Questions Data Fields Mappings - MSQL

The table below pertains to the Supplemental Questions fields for the CCCApply Standard/Noncredit Application. For more information, see the Working With Supplemental Questions User Guide.

College Adaptor Payload Name

CCC Field Name

DB Staging Table

Field Name

Notes

appId

app_id

APP_ID

suppText01

supp_text_01

SUPP_TEXT_01

suppText02

supp_text_02

SUPP_TEXT_02

suppText03

supp_text_03

SUPP_TEXT_03

suppText04

supp_text_04

SUPP_TEXT_04

suppText05

supp_text_05

SUPP_TEXT_05

suppText06

supp_text_06

SUPP_TEXT_06

suppText07

supp_text_07

SUPP_TEXT_07

suppText08

supp_text_08

SUPP_TEXT_08

suppText09

supp_text_09

SUPP_TEXT_09

suppText10

supp_text_10

SUPP_TEXT_10

suppText11

supp_text_11

SUPP_TEXT_11

suppText12

supp_text_12

SUPP_TEXT_12

suppText13

supp_text_13

SUPP_TEXT_13

suppText14

supp_text_14

SUPP_TEXT_14

suppText15

supp_text_15

SUPP_TEXT_15

suppText16

supp_text_16

SUPP_TEXT_16

suppText17

supp_text_17

SUPP_TEXT_17

suppText18

supp_text_18

SUPP_TEXT_18

suppText19

supp_text_19

SUPP_TEXT_19

suppText20

supp_text_20

SUPP_TEXT_20

suppCheck01

supp_check_01

SUPP_CHECK_01

suppCheck02

supp_check_02

SUPP_CHECK_02

suppCheck03

supp_check_03

SUPP_CHECK_03

suppCheck04

supp_check_04

SUPP_CHECK_04

suppCheck05

supp_check_05

SUPP_CHECK_05

suppCheck06

supp_check_06

SUPP_CHECK_06

suppCheck07

supp_check_07

SUPP_CHECK_07

suppCheck08

supp_check_08

SUPP_CHECK_08

suppCheck09

supp_check_09

SUPP_CHECK_09

suppCheck10

supp_check_10

SUPP_CHECK_10

suppCheck11

supp_check_11

SUPP_CHECK_11

suppCheck12

supp_check_12

SUPP_CHECK_12

suppCheck13

supp_check_13

SUPP_CHECK_13

suppCheck14

supp_check_14

SUPP_CHECK_14

suppCheck15

supp_check_15

SUPP_CHECK_15

suppCheck16

supp_check_16

SUPP_CHECK_16

suppCheck17

supp_check_17

SUPP_CHECK_17

suppCheck18

supp_check_18

SUPP_CHECK_18

suppCheck19

supp_check_19

SUPP_CHECK_19

suppCheck20

supp_check_20

SUPP_CHECK_20

suppCheck21

supp_check_21

SUPP_CHECK_21

suppCheck22

supp_check_22

SUPP_CHECK_22

suppCheck23

supp_check_23

SUPP_CHECK_23

suppCheck24

supp_check_24

SUPP_CHECK_24

suppCheck25

supp_check_25

SUPP_CHECK_25

suppCheck26

supp_check_26

SUPP_CHECK_26

suppCheck27

supp_check_27

SUPP_CHECK_27

suppCheck28

supp_check_28

SUPP_CHECK_28

suppCheck29

supp_check_29

SUPP_CHECK_29

suppCheck30

supp_check_30

SUPP_CHECK_30

suppCheck31

supp_check_31

SUPP_CHECK_31

suppCheck32

supp_check_32

SUPP_CHECK_32

suppCheck33

supp_check_33

SUPP_CHECK_33

suppCheck34

supp_check_34

SUPP_CHECK_34

suppCheck35

supp_check_35

SUPP_CHECK_35

suppCheck36

supp_check_36

SUPP_CHECK_36

suppCheck37

supp_check_37

SUPP_CHECK_37

suppCheck38

supp_check_38

SUPP_CHECK_38

suppCheck39

supp_check_39

SUPP_CHECK_39

suppCheck40

supp_check_40

SUPP_CHECK_40

suppCheck41

supp_check_41

SUPP_CHECK_41

suppCheck42

supp_check_42

SUPP_CHECK_42

suppCheck43

supp_check_43

SUPP_CHECK_43

suppCheck44

supp_check_44

SUPP_CHECK_44

suppCheck45

supp_check_45

SUPP_CHECK_45

suppCheck46

supp_check_46

SUPP_CHECK_46

suppCheck47

supp_check_47

SUPP_CHECK_47

suppCheck48

supp_check_48

SUPP_CHECK_48

suppCheck49

supp_check_49

SUPP_CHECK_49

suppCheck50

supp_check_50

SUPP_CHECK_50

suppYesno01

supp_yesno_01

SUPP_YESNO_01

suppYesno02

supp_yesno_02

SUPP_YESNO_02

suppYesno03

supp_yesno_03

SUPP_YESNO_03

suppYesno04

supp_yesno_04

SUPP_YESNO_04

suppYesno05

supp_yesno_05

SUPP_YESNO_05

suppYesno06

supp_yesno_06

SUPP_YESNO_06

suppYesno07

supp_yesno_07

SUPP_YESNO_07

suppYesno08

supp_yesno_08

SUPP_YESNO_08

suppYesno09

supp_yesno_09

SUPP_YESNO_09

suppYesno10

supp_yesno_10

SUPP_YESNO_10

suppYesno11

supp_yesno_11

SUPP_YESNO_11

suppYesno12

supp_yesno_12

SUPP_YESNO_12

suppYesno13

supp_yesno_13

SUPP_YESNO_13

suppYesno14

supp_yesno_14

SUPP_YESNO_14

suppYesno15

supp_yesno_15

SUPP_YESNO_15

suppYesno16

supp_yesno_16

SUPP_YESNO_16

suppYesno17

supp_yesno_17

SUPP_YESNO_17

suppYesno18

supp_yesno_18

SUPP_YESNO_18

suppYesno19

supp_yesno_19

SUPP_YESNO_19

suppYesno20

supp_yesno_20

SUPP_YESNO_20

suppYesno21

supp_yesno_21

SUPP_YESNO_21

suppYesno22

supp_yesno_22

SUPP_YESNO_22

suppYesno23

supp_yesno_23

SUPP_YESNO_23

suppYesno24

supp_yesno_24

SUPP_YESNO_24

suppYesno25

supp_yesno_25

SUPP_YESNO_25

suppYesno26

supp_yesno_26

SUPP_YESNO_26

suppYesno27

supp_yesno_27

SUPP_YESNO_27

suppYesno28

supp_yesno_28

SUPP_YESNO_28

suppYesno29

supp_yesno_29

SUPP_YESNO_29

suppYesno30

supp_yesno_30

SUPP_YESNO_30

suppMenu01

supp_menu_01

SUPP_MENU_01

suppMenu02

supp_menu_02

SUPP_MENU_02

suppMenu03

supp_menu_03

SUPP_MENU_03

suppMenu04

supp_menu_04

SUPP_MENU_04

suppMenu05

supp_menu_05

SUPP_MENU_05

suppMenu06

supp_menu_06

SUPP_MENU_06

suppMenu07

supp_menu_07

SUPP_MENU_07

suppMenu08

supp_menu_08

SUPP_MENU_08

suppMenu09

supp_menu_09

SUPP_MENU_09

suppMenu10

supp_menu_10

SUPP_MENU_10

suppMenu11

supp_menu_11

SUPP_MENU_11

suppMenu12

supp_menu_12

SUPP_MENU_12

suppMenu13

supp_menu_13

SUPP_MENU_13

suppMenu14

supp_menu_14

SUPP_MENU_14

suppMenu15

supp_menu_15

SUPP_MENU_15

suppMenu16

supp_menu_16

SUPP_MENU_16

suppMenu17

supp_menu_17

SUPP_MENU_17

suppMenu18

supp_menu_18

SUPP_MENU_18

suppMenu19

supp_menu_19

SUPP_MENU_19

suppMenu20

supp_menu_20

SUPP_MENU_20

suppMenu21

supp_menu_21

SUPP_MENU_21

suppMenu22

supp_menu_22

SUPP_MENU_22

suppMenu23

supp_menu_23

SUPP_MENU_23

suppMenu24

supp_menu_24

SUPP_MENU_24

suppMenu25

supp_menu_25

SUPP_MENU_25

suppMenu26

supp_menu_26

SUPP_MENU_26

suppMenu27

supp_menu_27

SUPP_MENU_27

suppMenu28

supp_menu_28

SUPP_MENU_28

suppMenu29

supp_menu_29

SUPP_MENU_29

suppMenu30

supp_menu_30

SUPP_MENU_30

suppDate01

supp_date_01

SUPP_DATE_01

suppDate02

supp_date_02

SUPP_DATE_02

suppDate03

supp_date_03

SUPP_DATE_03

suppDate04

supp_date_04

SUPP_DATE_04

suppDate05

supp_date_05

SUPP_DATE_05

suppState01

supp_state_01

SUPP_STATE_01

suppState02

supp_state_02

SUPP_STATE_02

suppState03

supp_state_03

SUPP_STATE_03

suppState04

supp_state_04

SUPP_STATE_04

suppState05

supp_state_05

SUPP_STATE_05

suppCountry01

supp_country_01

SUPP_COUNTRY_01

suppCountry02

supp_country_02

SUPP_COUNTRY_02

suppCountry03

supp_country_03

SUPP_COUNTRY_03

suppCountry04

supp_country_04

SUPP_COUNTRY_04

suppCountry05

supp_country_05

SUPP_COUNTRY_05

suppPhonenumber01

supp_phonenumber_01

SUPP_PHONENUMBER_01

suppPhonenumber02

supp_phonenumber_02

SUPP_PHONENUMBER_02

suppPhonenumber03

supp_phonenumber_03

SUPP_PHONENUMBER_03

suppPhonenumber04

supp_phonenumber_04

SUPP_PHONENUMBER_04

suppPhonenumber05

supp_phonenumber_05

SUPP_PHONENUMBER_05

suppSecret01

supp_secret_01

SUPP_SECRET_01

suppSecret02

supp_secret_02

SUPP_SECRET_02

suppSecret03

supp_secret_03

SUPP_SECRET_03

suppSecret04

supp_secret_04

SUPP_SECRET_04

suppSecret05

supp_secret_05

SUPP_SECRET_05


  • No labels