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 | 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 |
|---|---|---|---|---|
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 |
|
suppYesno12 | supp_yesno_12 | SZRAPLY | suppYesno12 |
|
suppYesno13 | supp_yesno_13 | SZRAPLY | suppYesno13 |
|
suppYesno14 | supp_yesno_14 | SZRAPLY | suppYesno14 |
|
suppYesno15 | supp_yesno_15 | SZRAPLY | suppYesno15 |
|
suppYesno16 | supp_yesno_16 | SZRAPLY | suppYesno16 |
|
suppYesno17 | supp_yesno_17 | SZRAPLY | suppYesno17 |
|
suppYesno18 | supp_yesno_18 | SZRAPLY | suppYesno18 |
|
suppYesno19 | supp_yesno_19 | SZRAPLY | suppYesno19 |
|
suppYesno20 | supp_yesno_20 | SZRAPLY | suppYesno20 |
|
suppYesno21 | supp_yesno_21 | SZRAPLY | suppYesno21 |
|
suppYesno22 | supp_yesno_22 | SZRAPLY | suppYesno22 |
|
suppYesno23 | supp_yesno_23 | SZRAPLY | suppYesno23 |
|
suppYesno24 | supp_yesno_24 | SZRAPLY | suppYesno24 |
|
suppYesno25 | supp_yesno_25 | SZRAPLY | suppYesno25 |
|
suppYesno26 | supp_yesno_26 | SZRAPLY | suppYesno26 |
|
suppYesno27 | supp_yesno_27 | SZRAPLY | suppYesno27 |
|
suppYesno28 | supp_yesno_28 | SZRAPLY | suppYesno28 |
|
suppYesno29 | supp_yesno_29 | SZRAPLY | suppYesno29 |
|
suppYesno30 | supp_yesno_30 | SZRAPLY | suppYesno30 |
|
suppMenu01 | supp_menu_01 | SZRAPLY | suppMenu01 |
|
suppMenu02 | supp_menu_02 | SZRAPLY | suppMenu02 |
|
suppMenu03 | supp_menu_03 | SZRAPLY | suppMenu03 |
|
suppMenu04 | supp_menu_04 | SZRAPLY | suppMenu04 |
|
suppMenu05 | supp_menu_05 | SZRAPLY | suppMenu05 |
|
suppMenu06 | supp_menu_06 | SZRAPLY | suppMenu06 |
|
suppMenu07 | supp_menu_07 | SZRAPLY | suppMenu07 |
|
suppMenu08 | supp_menu_08 | SZRAPLY | suppMenu08 |
|
suppMenu09 | supp_menu_09 | SZRAPLY | suppMenu09 |
|
suppMenu10 | supp_menu_10 | SZRAPLY | suppMenu10 |
|
suppMenu11 | supp_menu_11 | SZRAPLY | suppMenu11 |
|
suppMenu12 | supp_menu_12 | SZRAPLY | suppMenu12 |
|
suppMenu13 | supp_menu_13 | SZRAPLY | suppMenu13 |
|
suppMenu14 | supp_menu_14 | SZRAPLY | suppMenu14 |
|
suppMenu15 | supp_menu_15 | SZRAPLY | suppMenu15 |
|
suppMenu16 | supp_menu_16 | SZRAPLY | suppMenu16 |
|
suppMenu17 | supp_menu_17 | SZRAPLY | suppMenu17 |
|
suppMenu18 | supp_menu_18 | SZRAPLY | suppMenu18 |
|
suppMenu19 | supp_menu_19 | SZRAPLY | suppMenu19 |
|
suppMenu20 | supp_menu_20 | SZRAPLY | suppMenu20 |
|
suppMenu21 | supp_menu_21 | SZRAPLY | suppMenu21 |
|
suppMenu22 | supp_menu_22 | SZRAPLY | suppMenu22 |
|
suppMenu23 | supp_menu_23 | SZRAPLY | suppMenu23 |
|
suppMenu24 | supp_menu_24 | SZRAPLY | suppMenu24 |
|
suppMenu25 | supp_menu_25 | SZRAPLY | suppMenu25 |
|
suppMenu26 | supp_menu_26 | SZRAPLY | suppMenu26 |
|
suppMenu27 | supp_menu_27 | SZRAPLY | suppMenu27 |
|
suppMenu28 | supp_menu_28 | SZRAPLY | suppMenu28 |
|
suppMenu29 | supp_menu_29 | SZRAPLY | suppMenu29 |
|
suppMenu30 | supp_menu_30 | SZRAPLY | suppMenu30 |
|
suppDate01 | supp_date_01 | SZRAPLY | suppDate01 |
|
suppDate02 | supp_date_02 | SZRAPLY | suppDate02 |
|
suppDate03 | supp_date_03 | SZRAPLY | suppDate03 |
|
suppDate04 | supp_date_04 | SZRAPLY | suppDate04 |
|
suppDate05 | supp_date_05 | SZRAPLY | suppDate05 |
|
suppState01 | supp_state_01 | SZRAPLY | suppState01 |
|
suppState02 | supp_state_02 | SZRAPLY | suppState02 |
|
suppState03 | supp_state_03 | SZRAPLY | suppState03 |
|
suppState04 | supp_state_04 | SZRAPLY | suppState04 |
|
suppState05 | supp_state_05 | SZRAPLY | suppState05 |
|
suppCountry01 | supp_country_01 | SZRAPLY | suppCountry01 |
|
suppCountry02 | supp_country_02 | SZRAPLY | suppCountry02 |
|
suppCountry03 | supp_country_03 | SZRAPLY | suppCountry03 |
|
suppCountry04 | supp_country_04 | SZRAPLY | suppCountry04 |
|
suppCountry05 | supp_country_05 | SZRAPLY | suppCountry05 |
|
suppPhonenumber01 | supp_phonenumber_01 | SZRAPLY | suppPhonenumber01 |
|
suppPhonenumber02 | supp_phonenumber_02 | SZRAPLY | suppPhonenumber02 |
|
suppPhonenumber03 | supp_phonenumber_03 | SZRAPLY | suppPhonenumber03 |
|
suppPhonenumber04 | supp_phonenumber_04 | SZRAPLY | suppPhonenumber04 |
|
suppPhonenumber05 | supp_phonenumber_05 | SZRAPLY | suppPhonenumber05 |
|
suppSecret01 | supp_secret_01 | SZRAPLY | suppSecret01 |
|
suppSecret02 | supp_secret_02 | SZRAPLY | suppSecret02 |
|
suppSecret03 | supp_secret_03 | SZRAPLY | suppSecret03 |
|
suppSecret04 | supp_secret_04 | SZRAPLY | suppSecret04 |
|
suppSecret05 | supp_secret_05 | SZRAPLY | suppSecret05 |
|