CCCApply Standard Application SuperGlue Data Mappings - MSQL

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.

Apply: College Adaptor Element

Apply Data Element

System

Type

Length

MS SQL TABLE

MS SQL FIELD NAME

Apply: College Adaptor Element

Apply Data Element

System

Type

Length

MS SQL TABLE

MS SQL FIELD NAME

raceAIANOtherDescription

race_aian_other_description

SG v.4.10

Text

1024

SZRAPLY

raceAIANOtherDescription

studentDepsUnder18

student_deps_under18

SG v.4.10

Single Digit Number

1

SZRAPLY

studentDepsUnder18

studentDeps18Over

student_deps_18over

SG v.4.10

Single Digit Number

1

SZRAPLY

studentDeps18Over

idmeConfirmationTimestamp

idme_confirmation_timestamp

SG v.4.9

Date with UTC Time

 

SZRAPLY

idmeConfirmationTimestamp

idmeOptinTimestamp

idme_optin_timestamp

SG v.4.9

Date with UTC Time

 

SZRAPLY

idmeOptinTimestamp

idmeWorkflowStatus

idme_workflow_status

SG v.4.9

Text

Varchar 50

SZRAPLY

idmeWorkflowStatus

academicCounseling

academic_counseling

 

boolean

 

SZRAPLY

academicCounseling

acceptedTerms

accepted_terms

v SG 4.6

Boolean

 

SZRAPLY

acceptedTerms

acceptedTermsTimestamp

accepted_terms_timestamp

v SG 4.6

date timestamp

255

SZRAPLY

acceptedTermsTimestamp

ackFinAid

ack_fin_aid

 

boolean

 

SZRAPLY

ackFinAid

addressSame

address_same

 

boolean

 

SZRAPLY

addressSame

addressValidation

address_validation

 

character

1

SZRAPLY

addressValidation

addressValidationOverride

address_validation_override

 

boolean

1

SZRAPLY

addressValidationOverride

addressValidationOverrideTimestamp

address_validation_override_timestamp

 

date timestamp

255

SZRAPLY

addressValidationOverrideTimestamp

admIneligible

adm_ineligible

 

smallint

 

SZRAPLY

admIneligible

alienRegExpireDate

alien_reg_expire_date

 

date

 

SZRAPLY

alienRegExpireDate

alienRegIssueDate

alien_reg_issue_date

 

date

 

SZRAPLY

alienRegIssueDate

alienRegNoExpire

alien_reg_no_expire

 

boolean

 

SZRAPLY

alienRegNoExpire

alienRegNumber

alien_reg_number

 

Character varying

20

SZRAPLY

alienRegNumber

appId

app_id

 

bigint

 

SZRAPLY

appId

appLang

app_lang

 

character

2

SZRAPLY

appLang

athleticIntercollegiate

athletic_intercollegiate

 

boolean

 

SZRAPLY

athleticIntercollegiate

athleticIntramural

athletic_intramural

 

boolean

 

SZRAPLY

athleticIntramural

athleticNotInterested

athletic_not_interested

 

boolean

 

SZRAPLY

athleticNotInterested

basicSkills

basic_skills

 

boolean

 

SZRAPLY

basicSkills

birthdate

birthdate

 

date

 

SZRAPLY

birthdate

caCollegeEmployee

ca_college_employee

 

boolean

 

SZRAPLY

caCollegeEmployee

caDateCurrent

ca_date_current

 

date

 

SZRAPLY

caDateCurrent

caFosterYouth

ca_foster_youth

 

boolean

 

SZRAPLY

caFosterYouth

caNotArrived

ca_not_arrived

 

boolean

 

SZRAPLY

caNotArrived

caOutsideCollege

ca_outside_college

 

boolean

 

SZRAPLY

caOutsideCollege

caOutsideCollegeYear

ca_outside_college_year

 

date

 

SZRAPLY

caOutsideCollegeYear

caOutsideLawsuit

ca_outside_lawsuit

 

boolean

 

SZRAPLY

caOutsideLawsuit

caOutsideLawsuitYear

ca_outside_lawsuit_year

 

date

 

SZRAPLY

caOutsideLawsuitYear

caOutsideTax

ca_outside_tax

 

boolean

 

SZRAPLY

caOutsideTax

caOutsideTaxYear

ca_outside_tax_year

 

date

 

SZRAPLY

caOutsideTaxYear

caOutsideVoted

ca_outside_voted

 

boolean

 

SZRAPLY

caOutsideVoted

caOutsideVotedYear

ca_outside_voted_year

 

date

 

SZRAPLY

caOutsideVotedYear

caRes2Years

ca_res_2_years

 

boolean

 

SZRAPLY

caRes2Years

caSchoolEmployee

ca_school_employee

 

boolean

 

SZRAPLY

caSchoolEmployee

caSeasonalAg

ca_seasonal_ag

 

boolean

 

SZRAPLY

caSeasonalAg

cahs3year

cahs_3year

 

boolean

 

SZRAPLY

cahs3year

cahsGraduated

cahs_graduated

 

boolean

 

SZRAPLY

cahsGraduated

calworks

calworks

 

boolean

 

SZRAPLY

calworks

campaign1

campaign1

 

character varying

255

SZRAPLY

campaign1

campaign2

campaign2

 

character varying

255

SZRAPLY

campaign2

campaign3

campaign3

 

character varying

255

SZRAPLY

campaign3

N/A

cap_major_id

NOT USED

bigint

 

N/A

N/A

N/A

cap_term_id

NOT USED

bigint

 

N/A

N/A

careerPlanning

career_planning

 

boolean

 

SZRAPLY

careerPlanning

cccId

ccc_id

 

character varying

8

SZRAPLY

cccId

N/A

ccgi_token

RESTRICTED

character varying

256

N/A

N/A

childCare

child_care

 

boolean

 

SZRAPLY

childCare

cipCode

cip_code

 

character

6

SZRAPLY

cipCode

citizenshipStatus

citizenship_status

 

character

1

SZRAPLY

citizenshipStatus

city

city

 

character varying

50

SZRAPLY

city

coenrollConfirm

coenroll_confirm

 

boolean

 

SZRAPLY

coenrollConfirm

col1Cds

col1_cds

 

character

6

SZRAPLY

col1Cds

col1CdsFull

col1_cds_full

 

Character varying

14

SZRAPLY

col1CdsFull

col1Ceeb

col1_ceeb

 

character

7

SZRAPLY

col1Ceeb

col1City

col1_city

 

character varying

20

SZRAPLY

col1City

col1Country

col1_country

 

character

2

SZRAPLY

col1Country

col1DegreeDate

col1_degree_date

 

date

 

SZRAPLY

col1DegreeDate

col1DegreeObtained

col1_degree_obtained

 

character

1

SZRAPLY

col1DegreeObtained

col1EndDate

col1_end_date

 

date

 

SZRAPLY

col1EndDate

col1ExpelledStatus

col1_expelled_status

 

boolean

 

SZRAPLY

col1ExpelledStatus

col1Name

col1_name

 

character varying

30

SZRAPLY

col1Name

col1NotListed

col1_not_listed

 

boolean

 

SZRAPLY

col1NotListed

col1StartDate

col1_start_date

 

date

 

SZRAPLY

col1StartDate

col1State

col1_state

 

character varying

30

SZRAPLY

col1State

col2Cds

col2_cds

 

character

6

SZRAPLY

col2Cds

col2CdsFull

col2_cds_full

 

Character varying

14

SZRAPLY

col2CdsFull

col2Ceeb

col2_ceeb

 

character

7

SZRAPLY

col2Ceeb

col2City

col2_city

 

character varying

20

SZRAPLY

col2City

col2Country

col2_country

 

character

2

SZRAPLY

col2Country

col2DegreeDate

col2_degree_date

 

date

 

SZRAPLY

col2DegreeDate

col2DegreeObtained

col2_degree_obtained

 

character

1

SZRAPLY

col2DegreeObtained

col2EndDate

col2_end_date

 

date

 

SZRAPLY

col2EndDate

col2ExpelledStatus

col2_expelled_status

 

boolean

 

SZRAPLY

col2ExpelledStatus

col2Name

col2_name

 

character varying

30

SZRAPLY

col2Name

col2NotListed

col2_not_listed

 

boolean

 

SZRAPLY

col2NotListed

col2StartDate

col2_start_date

 

date

 

SZRAPLY

col2StartDate

col2State

col2_state

 

character varying

30

SZRAPLY

col2State

col3Cds

col3_cds

 

character

6

SZRAPLY

col3Cds

col3CdsFull

col3_cds_full

 

Character varying

14

SZRAPLY

col3CdsFull

col3Ceeb

col3_ceeb

 

character

7

SZRAPLY

col3Ceeb

col3City

col3_city

 

character varying

20

SZRAPLY

col3City

col3Country

col3_country

 

character

2

SZRAPLY

col3Country

col3DegreeDate

col3_degree_date

 

date

 

SZRAPLY

col3DegreeDate

col3DegreeObtained

col3_degree_obtained

 

character

1

SZRAPLY

col3DegreeObtained

col3EndDate

col3_end_date

 

date

 

SZRAPLY

col3EndDate

col3ExpelledStatus

col3_expelled_status

 

boolean

 

SZRAPLY

col3ExpelledStatus

col3Name

col3_name

 

character varying

30

SZRAPLY

col3Name

col3NotListed

col3_not_listed

 

boolean

 

SZRAPLY

col3NotListed

col3StartDate

col3_start_date

 

date

 

SZRAPLY

col3StartDate

col3State

col3_state

 

character varying

30

SZRAPLY

col3State

col4Cds

col4_cds

 

character

6

SZRAPLY

col4Cds

col4CdsFull

col4_cds_full

 

Character varying

14

SZRAPLY

col4CdsFull

col4Ceeb

col4_ceeb

 

character

7

SZRAPLY

col4Ceeb

col4City

col4_city

 

character varying

20

SZRAPLY

col4City

col4Country

col4_country

 

character

2

SZRAPLY

col4Country

col4DegreeDate

col4_degree_date

 

date

 

SZRAPLY

col4DegreeDate

col4DegreeObtained

col4_degree_obtained

 

character

1

SZRAPLY

col4DegreeObtained

col4EndDate

col4_end_date

 

date

 

SZRAPLY

col4EndDate

col4ExpelledStatus

col4_expelled_status

 

boolean

 

SZRAPLY

col4ExpelledStatus

col4Name

col4_name

 

character varying

30

SZRAPLY

col4Name

col4NotListed

col4_not_listed

 

boolean

 

SZRAPLY

col4NotListed

col4StartDate

col4_start_date

 

date

 

SZRAPLY

col4StartDate

col4State

col4_state

 

character varying

30

SZRAPLY

col4State

collegeCount

college_count

 

smallint

 

SZRAPLY

collegeCount

collegeExpelledSummary

college_expelled_summary

 

boolean

 

SZRAPLY

collegeExpelledSummary

collegeId

college_id

 

character

3

SZRAPLY

collegeId

collegeName

college_name

 

character varying

50

SZRAPLY

collegeName

comfortableEnglish

comfortable_english

 

boolean

 

SZRAPLY

comfortableEnglish

comments

comments

 

text

50

SZRAPLY

comments

completedEleventhGrade

completed_eleventh_grade

NO LONGER USED

boolean

 

SZRAPLY

completedEleventhGrade

confirmation

confirmation

 

character varying

30

SZRAPLY

confirmation

consentIndicator

consent_indicator

 

boolean

 

SZRAPLY

consentIndicator

counselingPersonal

counseling_personal

 

boolean

 

SZRAPLY

counselingPersonal

country

country

 

character

2

SZRAPLY

country

N/A

cryptokeyid

RESTRICTED USE

integer

 

N/A

N/A

dependentStatus

dependent_status

 

character

1

SZRAPLY

dependentStatus

dischargeType

discharge_type

 

character varying

1

SZRAPLY

dischargeType

districtName

district_name

 

character varying

50

SZRAPLY

districtName

dsps

dsps

 

boolean

 

SZRAPLY

dsps

eduGoal

edu_goal

 

character

1

SZRAPLY

eduGoal

eligAb540

elig_ab540

 

boolean

 

SZRAPLY

eligAb540

email

email

 

character varying

254

SZRAPLY

email

emailVerified

email_verified

 

boolean

 

SZRAPLY

emailVerified

emailVerifiedTimestamp

email_verified_timestamp

 

timestamp with time zone

255

SZRAPLY

emailVerifiedTimestamp

employmentAssistance

employment_assistance

 

boolean

 

SZRAPLY

employmentAssistance

enrollStatus

enroll_status

 

character

1

SZRAPLY

enrollStatus

eops

eops

 

boolean

 

SZRAPLY

eops

N/A

esignature

NO LONGER IN USE

boolean

 

N/A

N/A

esl

esl

 

boolean

 

SZRAPLY

esl

experience

experience

 

integer

1

SZRAPLY

experience

finAidRef

fin_aid_ref

 

boolean

 

SZRAPLY

finAidRef

financialAssistance

financial_assistance

 

boolean

 

SZRAPLY

financialAssistance

firstname

firstname

 

character varying

50

SZRAPLY

firstname

fosterYouthMis

foster_youth_mis

 

boolean

 

SZRAPLY

fosterYouthMis

fosterYouthPreference

foster_youth_preference

 

boolean

 

SZRAPLY

fosterYouthPreference

fosterYouthPriority

foster_youth_priority

 

boolean

 

SZRAPLY

fosterYouthPriority

fosterYouthStatus

foster_youth_status

 

character

1

SZRAPLY

fosterYouthStatus

fosterYouths

foster_youths

NO LONGER IN USE

boolean

 

SZRAPLY

fosterYouths

fraudScore

fraud_score

 

double precision

 

SZRAPLY

fraudScore

fraudStatus

fraud_status

 

integer

 

SZRAPLY

fraudStatus

gender

gender

 

character

1

SZRAPLY

gender

gradePointAverage

grade_point_average

 

Alphanumeric

5

SZRAPLY

gradePointAverage

healthServices

health_services

 

boolean

 

SZRAPLY

healthServices

higherCompDate

higher_comp_date

 

date

 

SZRAPLY

higherCompDate

higherEduLevel

higher_edu_level

 

character

1

SZRAPLY

higherEduLevel

highestEduLevel

highest_edu_level

 

character

5

SZRAPLY

highestEduLevel

highestEnglishCourse

highest_english_course

 

Integer

 

SZRAPLY

highestEnglishCourse

highestEnglishGrade

highest_english_grade

 

Character varying

2

SZRAPLY

highestEnglishGrade

highestGradeCompleted

highest_grade_completed

 

varchar

2

SZRAPLY

highestGradeCompleted

highestMathCoursePassed

highest_math_course_passed

 

Integer

 

SZRAPLY

highestMathCoursePassed

highestMathCourseTaken

highest_math_course_taken

 

Integer

 

SZRAPLY

highestMathCourseTaken

highestMathPassedGrade

highest_math_passed_grade

 

Character varying

2

SZRAPLY

highestMathPassedGrade

highestMathTakenGrade

highest_math_taken_grade

 

Character varying

2

SZRAPLY

highestMathTakenGrade

hispanic

hispanic

 

boolean

 

SZRAPLY

hispanic

homelessYouth

homeless_youth

 

boolean

 

SZRAPLY

homelessYouth

homeSchooled

home_schooled

NOT IN USE

Boolean

 

SZRAPLY

homeSchooled

housingInfo

housing_info

 

boolean

 

SZRAPLY

housingInfo

hsAttendance

hs_attendance

 

smallint

 

SZRAPLY

hsAttendance

hsCds

hs_cds

 

character

6

SZRAPLY

hsCds

hsCdsFull

hs_cds_full

 

Character varying

14

SZRAPLY

hsCdsFull

hsCeeb

hs_ceeb

 

character

7

SZRAPLY

hsCeeb

hsCity

hs_city

 

character varying

20

SZRAPLY

hsCity

hsCompDate

hs_comp_date

 

date

 

SZRAPLY

hsCompDate

hsCountry

hs_country

 

character

2

SZRAPLY

hsCountry

hsEduLevel

hs_edu_level

 

character

1

SZRAPLY

hsEduLevel

hsName

hs_name

 

character varying

30

SZRAPLY

hsName

hsNotAttended

hs_not_attended

 

boolean

 

SZRAPLY

hsNotAttended

hsNotListed

hs_not_listed

 

boolean

 

SZRAPLY

hsNotListed

hsState

hs_state

 

character

2

SZRAPLY

hsState

integrityFg01

integrity_fg_01

 

boolean

 

SZRAPLY

integrityFg01

integrityFg02

integrity_fg_02

 

boolean

 

SZRAPLY

integrityFg02

integrityFg03

integrity_fg_03

 

boolean

 

SZRAPLY

integrityFg03

integrityFg04

integrity_fg_04

 

boolean

 

SZRAPLY

integrityFg04

integrityFg11

integrity_fg_11

 

boolean

 

SZRAPLY

integrityFg11

integrityFg30

integrity_fg_30

 

Boolean

 

SZRAPLY

integrityFg30

integrityFg40

Integrity_fg_40

 

boolean

 

SZRAPLY

integrityFg40

N/A

Integrity_fg_41

 

boolean

 

N/A

N/A

integrityFg47

integrity_fg_47

 

boolean

 

SZRAPLY

integrityFg47

integrityFg48

integrity_fg_48

 

boolean

 

SZRAPLY

integrityFg48

integrityFg49

integrity_fg_49

 

boolean

 

SZRAPLY

integrityFg49

integrityFg50

integrity_fg_50

 

boolean

 

SZRAPLY

integrityFg50

integrityFg51

integrity_fg_51

 

boolean

 

SZRAPLY

integrityFg51

integrityFg52

integrity_fg_52

 

boolean

 

SZRAPLY

integrityFg52

integrityFg53

integrity_fg_53

 

boolean

 

SZRAPLY

integrityFg53

integrityFg54

integrity_fg_54

 

boolean

 

SZRAPLY

integrityFg54

integrityFg55

integrity_fg_55

 

boolean

 

SZRAPLY

integrityFg55

integrityFg56

integrity_fg_56

 

boolean

 

SZRAPLY

integrityFg56

integrityFg57

integrity_fg_57

 

boolean

 

SZRAPLY

integrityFg57

integrityFg58

integrity_fg_58

 

boolean

 

SZRAPLY

integrityFg58

integrityFg59

integrity_fg_59

 

boolean

 

SZRAPLY

integrityFg59

integrityFg60

integrity_fg_60

 

boolean

 

SZRAPLY

integrityFg60

integrityFg61

integrity_fg_61

 

boolean

 

SZRAPLY

integrityFg61

integrityFg62

integrity_fg_62

 

boolean

 

SZRAPLY

integrityFg62

integrityFg63

integrity_fg_63

 

boolean

 

SZRAPLY

integrityFg63

integrityFg64

integrity_fg_64

 

boolean

 

SZRAPLY

integrityFg64

integrityFg65

integrity_fg_65

 

boolean

 

SZRAPLY

integrityFg65

integrityFg70

integrity_fg_70

 

boolean

 

SZRAPLY

integrityFg70

integrityFg71

integrity_fg_71

 

boolean

 

SZRAPLY

integrityFg71

integrityFg80

integrity_fg_80

 

boolean

 

SZRAPLY

integrityFg80

integrityFg81

Integrity_fg_81

 

boolean

 

SZRAPLY

integrityFg81

integrityFlags

integrity_flags

 

character varying

255

SZRAPLY

integrityFlags

intendedMajor

intended_major

 

character varying

30

SZRAPLY

intendedMajor

ipAddress

ip_address

 

character varying

15

SZRAPLY

ipAddress

ipAddressAtAccountCreation

ip_address_at_account_creation

v SG 4.6

character varying

40

SZRAPLY

ipAddressAtAccountCreation

ipAddressAtAppCreation

ip_address_at_app_creation

v SG 4.6

character varying

40

SZRAPLY

ipAddressAtAppCreation

lastname

lastname

 

character varying

50

SZRAPLY

lastname

lastPage

last_page

 

character varying

25

SZRAPLY

lastPage

mailingAddressValidationOverride

mailing_address_validation_override

v SG 4.6

boolean

 

SZRAPLY

mailingAddressValidationOverride

mainphone

mainphone

 

character varying

19

SZRAPLY

mainphone

mainphoneAuthText

mainphone_auth_text

NO LONGER IN USE

boolean

 

SZRAPLY

mainphoneAuthText

mainphoneExt

mainphone_ext

NO LONGER IN USE

character varying

4

SZRAPLY

mainphoneExt

mainphoneintl

mainphoneintl

NO LONGER IN USE

character varying

25

SZRAPLY

mainphoneintl

majorCategory

major_category

 

character varying

100

SZRAPLY

majorCategory

majorCode

major_code

 

character varying

30

SZRAPLY

majorCode

majorDescription

major_description

 

character varying

100

SZRAPLY

majorDescription

majorId

major_id

SYSTEM USE ONLY

bigint

 

SZRAPLY

majorId

middlename

middlename

 

character varying

50

SZRAPLY

middlename

militaryCaStationed

military_ca_stationed

 

boolean

 

SZRAPLY

militaryCaStationed

militaryDischargeDate

military_discharge_date

 

date

 

SZRAPLY

militaryDischargeDate

militaryHomeCountry

military_home_country

 

character

2

SZRAPLY

militaryHomeCountry

militaryHomeState

military_home_state

 

character

2

SZRAPLY

militaryHomeState

militaryLegalResidence

military_legal_residence

 

character

2

SZRAPLY

militaryLegalResidence

militaryStationedCaEd

military_stationed_ca_ed

 

boolean

 

SZRAPLY

militaryStationedCaEd

militaryStatus

military_status

 

character

1

SZRAPLY

militaryStatus

N/A

military_veteran_consent

RESTRICTED USE

boolean

 

N/A

N/A

noDocuments

no_documents

 

boolean

 

SZRAPLY

noDocuments

noMailingAddressHomeless

no_mailing_address_homeless

 

boolean

 

SZRAPLY

noMailingAddressHomeless

noPermAddressHomeless

no_perm_address_homeless

 

boolean

 

SZRAPLY

noPermAddressHomeless

nonCredit

non_credit

 

boolean

 

SZRAPLY

nonCredit

nonUsAddress

non_us_address

 

boolean

 

SZRAPLY

nonUsAddress

nonusaprovince

nonusaprovince

 

character varying

30

SZRAPLY

nonusaprovince

onlineClasses

online_classes

 

boolean

 

SZRAPLY

onlineClasses

orientation

orientation

RESTRICTED USE

byte

1

SZRAPLY

orientation

N/A

orientation_encrypted

RESTRICTED USE

text

 

N/A

N/A

otherfirstname

otherfirstname

 

character varying

50

SZRAPLY

otherfirstname

otherlastname

otherlastname

 

character varying

50

SZRAPLY

otherlastname

othermiddlename

othermiddlename

 

character varying

50

SZRAPLY

othermiddlename

permAddressValidation

perm_address_validation

 

character

1

SZRAPLY

permAddressValidation

permCity

perm_city

 

character varying

50

SZRAPLY

permCity

permCountry

perm_country

 

character

2

SZRAPLY

permCountry

permNonusaprovince

perm_nonusaprovince

 

character varying

30

SZRAPLY

permNonusaprovince

permPostalcode

perm_postalcode

 

character varying

20

SZRAPLY

permPostalcode

permState

perm_state

 

character

2

SZRAPLY

permState

permStreetaddress1

perm_streetaddress1

 

character varying

50

SZRAPLY

permStreetaddress1

permStreetaddress2

perm_streetaddress2

 

character varying

50

SZRAPLY

permStreetaddress2

permZip4

perm_zip4

 

character

4

SZRAPLY

permZip4

pgEduMis

pg_edu_mis

 

character

2

SZRAPLY

pgEduMis

pgFirstname

pg_firstname

 

character varying

20

SZRAPLY

pgFirstname

pgLastname

pg_lastname

 

character varying

25

SZRAPLY

pgLastname

pgRel

pg_rel

 

character

1

SZRAPLY

pgRel

pg1Edu

pg1_edu

 

character

1

SZRAPLY

pg1Edu

pg2Edu

pg2_edu

 

character

1

SZRAPLY

pg2Edu

phoneType

phone_type

v SG 4.6

varchar

10

SZRAPLY

phoneType

phoneVerified

phone_verified

 

Boolean

 

SZRAPLY

phoneVerified

phoneVerifiedTimestamp

phone_verified_timestamp

 

timestamp with time zone

 

SZRAPLY

phoneVerifiedTimestamp

postalcode

postalcode

 

character varying

20

SZRAPLY

postalcode

preferredMethodOfContact

preferred_contact_method

 

VarChar

10

SZRAPLY

preferredMethodOfContact

preferredFirstname

preferred_firstname

 

Text string

50

SZRAPLY

preferredFirstname

preferredLastname

preferred_lastname

NO LONGER IN USE

character varying

50

SZRAPLY

preferredLastname

preferredMiddlename

preferred_middlename

NO LONGER IN USE

character varying

50

SZRAPLY

preferredMiddlename

preferredName

preferred_name

NO LONGER IN USE

boolean

1

SZRAPLY

preferredName

raceEthnic

race_ethnic

 

text

 

SZRAPLY

raceEthnic

raceEthnicFull

race_ethnic_full

 

text

805

SZRAPLY

raceEthnicFull

raceGroup

race_group

 

text

 

SZRAPLY

raceGroup

rdd

rdd

 

date

 

SZRAPLY

rdd

recommend

recommend

 

integer

1

SZRAPLY

recommend

reentryProgram

reentry_program

 

boolean

 

SZRAPLY

reentryProgram

resAreaA

res_area_a

 

smallint

 

SZRAPLY

resAreaA

resAreaB

res_area_b

 

smallint

 

SZRAPLY

resAreaB

resAreaC

res_area_c

 

smallint

 

SZRAPLY

resAreaC

resAreaD

res_area_d

 

smallint

 

SZRAPLY

resAreaD

resPrevDate

res_prev_date

 

date

 

SZRAPLY

resPrevDate

resStatus

res_status

 

character

1

SZRAPLY

resStatus

resStatusChange

res_status_change

 

boolean

 

SZRAPLY

resStatusChange

N/A

salt

SYSTEM USE ONLY

text

 

N/A

N/A

scholarshipInfo

scholarship_info

 

boolean

 

SZRAPLY

scholarshipInfo

secondphoneAuthText

secondphone_auth_text

NO LONGER IN USE

boolean

 

SZRAPLY

secondphoneAuthText

secondphoneExt

secondphone_ext

NO LONGER IN USE

character varying

4

SZRAPLY

secondphoneExt

secondphone

secondphone

NO LONGER IN USE

character varying

14

SZRAPLY

secondphone

secondphoneintl

secondphoneintl

NO LONGER IN USE

character varying

25

SZRAPLY

secondphoneintl

 

signature

 

text

 

SZRAPLY

N/A

sisReceipt

sis_receipt

 

boolean

 

SZRAPLY

sisReceipt

ssid

ssid

 

character varying

10

SZRAPLY

ssid

ssn

ssn

RESTRICTED USE

text

11

SZRAPLY

ssn

ssnDisplay

ssn_display

 

character varying

11

SZRAPLY

ssnDisplay

ssnException

ssn_exception

 

boolean

 

SZRAPLY

ssnException

ssnNo

ssn_no

 

character

 

SZRAPLY

ssnNo

ssnType

ssn_type

 

character

1

SZRAPLY

ssnType

state

state

 

character

2

SZRAPLY

state

status

status

 

character

1

SZRAPLY

status

streetaddress1

streetaddress1

 

character varying

50

SZRAPLY

streetaddress1

streetaddress2

streetaddress2

 

character varying

50

SZRAPLY

streetaddress2

studentGovernment

student_government

 

boolean

 

SZRAPLY

studentGovernment

studentParent

student_parent

SG 4.7

boolean

 

SZRAPLY

studentParent

suffix

suffix

 

character varying

3

SZRAPLY

suffix

supPageCode

sup_page_code

NO LONGER IN USE

character varying

30

SZRAPLY

supPageCode

tanfSsiGa

tanf_ssi_ga

 

boolean

 

SZRAPLY

tanfSsiGa

termCode

term_code

 

character varying

15

SZRAPLY

termCode

termDescription

term_description

 

character varying

100

SZRAPLY

termDescription

termId

term_id

SYSTEM USE ONLY

bigint

 

SZRAPLY

termId

termEnd

term_end

 

date

13

SZRAPLY

termEnd

termStart

term_start

 

date

13

SZRAPLY

termStart

testingAssessment

testing_assessment

 

boolean

 

SZRAPLY

testingAssessment

transferInfo

transfer_info

 

boolean

 

SZRAPLY

transferInfo

transgender

transgender

RESTRICTED USE

Byte

1

SZRAPLY

transgender

N/A

transgender_encrypted

RESTRICTED USE

 

 

N/A

N/A

tstmpCreate

tstmp_create

 

timestamp with time zone

 

SZRAPLY

tstmpCreate

tstmpDownload

tstmp_download

 

timestamp with time zone

 

SZRAPLY

tstmpDownload

tstmpSubmit

tstmp_submit

 

timestamp with time zone

 

SZRAPLY

tstmpSubmit

tstmpUpdate

tstmp_update

 

timestamp with time zone

 

SZRAPLY

tstmpUpdate

tutoringServices

tutoring_services

 

boolean

 

SZRAPLY

tutoringServices

under19Ind

under19_ind

 

boolean

 

SZRAPLY

under19Ind

veteransServices

veterans_services

 

boolean

 

SZRAPLY

veteransServices

visaType

visa_type

 

alphanumeric

2

SZRAPLY

visaType

zip4

zip4

 

character

4

SZRAPLY

zip4

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

College Adaptor Payload Name

Notes

College Adaptor Payload Name

CCC Field Name

DB Staging Table

College Adaptor Payload Name

Notes

appId

app_id

SZRAPLY

appId

 

suppText01

supp_text_01

SZRAPLY

suppText01

 

suppText02

supp_text_02

SZRAPLY

suppText02

 

suppText03

supp_text_03

SZRAPLY

suppText03

 

suppText04

supp_text_04

SZRAPLY

suppText04

 

suppText05

supp_text_05

SZRAPLY

suppText05

 

suppText06

supp_text_06

SZRAPLY

suppText06

 

suppText07

supp_text_07

SZRAPLY

suppText07

 

suppText08

supp_text_08

SZRAPLY

suppText08

 

suppText09

supp_text_09

SZRAPLY

suppText09

 

suppText10

supp_text_10

SZRAPLY

suppText10

 

suppText11

supp_text_11

SZRAPLY

suppText11

 

suppText12

supp_text_12

SZRAPLY

suppText12

 

suppText13

supp_text_13

SZRAPLY

suppText13

 

suppText14

supp_text_14

SZRAPLY

suppText14

 

suppText15

supp_text_15

SZRAPLY

suppText15

 

suppText16

supp_text_16

SZRAPLY

suppText16

 

suppText17

supp_text_17

SZRAPLY

suppText17

 

suppText18

supp_text_18

SZRAPLY

suppText18

 

suppText19

supp_text_19

SZRAPLY

suppText19

 

suppText20

supp_text_20

SZRAPLY

suppText20

 

suppCheck01

supp_check_01

SZRAPLY

suppCheck01

 

suppCheck02

supp_check_02

SZRAPLY

suppCheck02

 

suppCheck03

supp_check_03

SZRAPLY

suppCheck03

 

suppCheck04

supp_check_04

SZRAPLY

suppCheck04

 

suppCheck05

supp_check_05

SZRAPLY

suppCheck05

 

suppCheck06

supp_check_06

SZRAPLY

suppCheck06

 

suppCheck07

supp_check_07

SZRAPLY

suppCheck07

 

suppCheck08

supp_check_08

SZRAPLY

suppCheck08

 

suppCheck09

supp_check_09

SZRAPLY

suppCheck09

 

suppCheck10

supp_check_10

SZRAPLY

suppCheck10

 

suppCheck11

supp_check_11

SZRAPLY

suppCheck11

 

suppCheck12

supp_check_12

SZRAPLY

suppCheck12

 

suppCheck13

supp_check_13

SZRAPLY

suppCheck13

 

suppCheck14

supp_check_14

SZRAPLY

suppCheck14

 

suppCheck15

supp_check_15

SZRAPLY

suppCheck15

 

suppCheck16

supp_check_16

SZRAPLY

suppCheck16

 

suppCheck17

supp_check_17

SZRAPLY

suppCheck17

 

suppCheck18

supp_check_18

SZRAPLY

suppCheck18

 

suppCheck19

supp_check_19

SZRAPLY

suppCheck19

 

suppCheck20

supp_check_20

SZRAPLY

suppCheck20

 

suppCheck21

supp_check_21

SZRAPLY

suppCheck21

 

suppCheck22

supp_check_22

SZRAPLY

suppCheck22

 

suppCheck23

supp_check_23

SZRAPLY

suppCheck23

 

suppCheck24

supp_check_24

SZRAPLY

suppCheck24

 

suppCheck25

supp_check_25

SZRAPLY

suppCheck25

 

suppCheck26

supp_check_26

SZRAPLY

suppCheck26

 

suppCheck27

supp_check_27

SZRAPLY

suppCheck27

 

suppCheck28

supp_check_28

SZRAPLY

suppCheck28

 

suppCheck29

supp_check_29

SZRAPLY

suppCheck29

 

suppCheck30

supp_check_30

SZRAPLY

suppCheck30

 

suppCheck31

supp_check_31

SZRAPLY

suppCheck31

 

suppCheck32

supp_check_32

SZRAPLY

suppCheck32

 

suppCheck33

supp_check_33

SZRAPLY

suppCheck33

 

suppCheck34

supp_check_34

SZRAPLY

suppCheck34

 

suppCheck35

supp_check_35

SZRAPLY

suppCheck35

 

suppCheck36

supp_check_36

SZRAPLY

suppCheck36

 

suppCheck37

supp_check_37

SZRAPLY

suppCheck37

 

suppCheck38

supp_check_38

SZRAPLY

suppCheck38

 

suppCheck39

supp_check_39

SZRAPLY

suppCheck39

 

suppCheck40

supp_check_40

SZRAPLY

suppCheck40

 

suppCheck41

supp_check_41

SZRAPLY

suppCheck41

 

suppCheck42

supp_check_42

SZRAPLY

suppCheck42

 

suppCheck43

supp_check_43

SZRAPLY

suppCheck43

 

suppCheck44

supp_check_44

SZRAPLY

suppCheck44

 

suppCheck45

supp_check_45

SZRAPLY

suppCheck45

 

suppCheck46

supp_check_46

SZRAPLY

suppCheck46

 

suppCheck47

supp_check_47

SZRAPLY

suppCheck47

 

suppCheck48

supp_check_48

SZRAPLY

suppCheck48

 

suppCheck49

supp_check_49

SZRAPLY

suppCheck49

 

suppCheck50

supp_check_50

SZRAPLY

suppCheck50

 

suppYesno01

supp_yesno_01

SZRAPLY

suppYesno01

 

suppYesno02

supp_yesno_02

SZRAPLY

suppYesno02

 

suppYesno03

supp_yesno_03

SZRAPLY

suppYesno03

 

suppYesno04

supp_yesno_04

SZRAPLY

suppYesno04

 

suppYesno05

supp_yesno_05

SZRAPLY

suppYesno05

 

suppYesno06

supp_yesno_06

SZRAPLY

suppYesno06

 

suppYesno07

supp_yesno_07

SZRAPLY

suppYesno07

 

suppYesno08

supp_yesno_08

SZRAPLY

suppYesno08

 

suppYesno09

supp_yesno_09

SZRAPLY

suppYesno09

 

suppYesno10

supp_yesno_10

SZRAPLY

suppYesno10

 

suppYesno11

supp_yesno_11

SZRAPLY

suppYesno11