CCCApply Standard Application SuperGlue Data Mappings - MS SQL
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 - MS SQL
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 |
verificationOptinTimestamp | verification_optin_timestamp | SG v5.3.0 | Date with UTC Time |
| SZRAPLY | verificationOptinTimestamp |
verificationConfirmationTimestamp | verification_source_identity | SG v5.3.0 | Date with UTC Time |
| SZRAPLY | verificationConfirmationTimestamp |
verificationWorkflowStatus | verification_workflow_status | SG v5.3.0 | Text |
| SZRAPLY | verificationWorkflowStatus |
verificationSourceIdentity | verification_source_identity | SG v5.3.0 | Text |
| SZRAPLY | verificationSourceIdentity |
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 |
appType | app_type | SG 5.3.0 | character |
| SZRAPLY | appType |
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 |
|