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 |
|---|---|---|---|---|---|---|
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 |