CCCApply Standard Application SuperGlue Data Mappings - MSQL
- Patricia Donohue
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 |
|---|---|---|---|---|---|---|
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 |
| character varying | 254 | SZRAPLY | |||
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 |