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