Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
The tables below pertain to the latest CCCApply Standard & Noncredit Application version. For more information, see CCCApplyRelease Notes& Data Dictionaries. |
...
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 |
---|
academic_counseling
academicCounseling
raceAIANOtherDescription | race_aian_other_description | SG v.4.10 | Text | 1024 | SZRAPLY |
academicCounseling
accepted_terms
acceptedTerms
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 |
acceptedTermsTimestamp
v SG 4.6 | date timestamp | 255 | SZRAPLY | acceptedTermsTimestamp |
ackFinAid | ack_fin_aid |
ackFinAid
boolean | SZRAPLY | ackFinAid | ||
addressSame | address_same |
addressSame
boolean | SZRAPLY | addressSame | ||
addressValidation | address_validation |
addressValidation
character | 1 | SZRAPLY | addressValidation | |
addressValidationOverride | address_validation_override |
boolean | 1 | SZRAPLY | addressValidationOverride | ||
addressValidationOverrideTimestamp | address_validation_override_timestamp |
addressValidationOverrideTimestamp
date timestamp | 255 | SZRAPLY | addressValidationOverrideTimestamp | |
admIneligible | adm_ineligible |
admIneligible
smallint | SZRAPLY | admIneligible | ||
alienRegExpireDate | alien_reg_expire_date |
alienRegExpireDate
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 |
appId
bigint | SZRAPLY | appId | ||
appLang | app_lang |
appLang
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 |
basicSkills
boolean | SZRAPLY | basicSkills | ||||
birthdate | birthdate | date | SZRAPLY | birthdate | ||
caCollegeEmployee | ca_college_employee |
caCollegeEmployee
boolean | SZRAPLY | caCollegeEmployee | ||
caDateCurrent | ca_date_current |
date | SZRAPLY | caDateCurrent | |||
caFosterYouth | ca_foster_youth |
caFosterYouth
boolean | SZRAPLY | caFosterYouth | ||
caNotArrived | ca_not_arrived |
boolean | SZRAPLY | caNotArrived | |||
caOutsideCollege | ca_outside_college |
caOutsideCollege
boolean | SZRAPLY | caOutsideCollege | ||
caOutsideCollegeYear | ca_outside_college_year |
caOutsideCollegeYear
date | SZRAPLY | caOutsideCollegeYear | ||
caOutsideLawsuit | ca_outside_lawsuit |
caOutsideLawsuit
boolean | SZRAPLY | caOutsideLawsuit | ||
caOutsideLawsuitYear | ca_outside_lawsuit_year |
caOutsideLawsuitYear
date | SZRAPLY | caOutsideLawsuitYear | ||
caOutsideTax | ca_outside_tax |
boolean | SZRAPLY | caOutsideTax | |||
caOutsideTaxYear | ca_outside_tax_year |
caOutsideTaxYear
date | SZRAPLY | caOutsideTaxYear | ||
caOutsideVoted | ca_outside_voted |
caOutsideVoted
boolean | SZRAPLY | caOutsideVoted | ||
caOutsideVotedYear | ca_outside_voted_year |
caOutsideVotedYear
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 |
cahs3year
boolean | SZRAPLY | cahs3year | ||
cahsGraduated | cahs_graduated |
cahsGraduated
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 |
N/A
NOT USED | bigint | N/A | N/A | |
careerPlanning | career_planning |
careerPlanning
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 |
childCare
boolean | SZRAPLY | childCare | ||
cipCode | cip_code |
cipCode
character | 6 | SZRAPLY | cipCode | |
citizenshipStatus | citizenship_status |
citizenshipStatus
character | 1 | SZRAPLY | citizenshipStatus | |||
city | city | character varying | 50 | SZRAPLY | city | |
coenrollConfirm | coenroll_confirm |
coenrollConfirm
boolean | SZRAPLY | coenrollConfirm | ||
col1Cds | col1_cds |
character | 6 | SZRAPLY | col1Cds | ||
col1CdsFull | col1_cds_full |
col1CdsFull
Character varying | 14 | SZRAPLY | col1CdsFull | |
col1Ceeb | col1_ceeb |
col1Ceeb
character | 7 | SZRAPLY | col1Ceeb | |
col1City | col1_city |
col1City
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 |
col1EndDate
date | SZRAPLY | col1EndDate | ||
col1ExpelledStatus | col1_expelled_status |
col1ExpelledStatus
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 |
col1State
character varying | 30 | SZRAPLY | col1State | |
col2Cds | col2_cds |
col2Cds
character | 6 | SZRAPLY | col2Cds | |
col2CdsFull | col2_cds_full |
Character varying | 14 | SZRAPLY | col2CdsFull | ||
col2Ceeb | col2_ceeb |
col2Ceeb
character | 7 | SZRAPLY | col2Ceeb | |
col2City | col2_city |
character varying | 20 | SZRAPLY | col2City | ||
col2Country | col2_country |
col2Country
character | 2 | SZRAPLY | col2Country | |
col2DegreeDate | col2_degree_date |
col2DegreeDate
date | SZRAPLY | col2DegreeDate | ||
col2DegreeObtained | col2_degree_obtained |
col2DegreeObtained
character | 1 | SZRAPLY | col2DegreeObtained | |
col2EndDate | col2_end_date |
col2EndDate
date | SZRAPLY | col2EndDate | ||
col2ExpelledStatus | col2_expelled_status |
boolean | SZRAPLY | col2ExpelledStatus | |||
col2Name | col2_name |
col2Name
character varying | 30 | SZRAPLY | col2Name | |
col2NotListed | col2_not_listed |
col2NotListed
boolean | SZRAPLY | col2NotListed | ||
col2StartDate | col2_start_date |
col2StartDate
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 |
col3Ceeb
character | 7 | SZRAPLY | col3Ceeb | |
col3City | col3_city |
col3City
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 |
col3EndDate
date | SZRAPLY | col3EndDate | ||
col3ExpelledStatus | col3_expelled_status |
col3ExpelledStatus
boolean | SZRAPLY | col3ExpelledStatus | ||
col3Name | col3_name |
character varying | 30 | SZRAPLY | col3Name | ||
col3NotListed | col3_not_listed |
col3NotListed
boolean | SZRAPLY | col3NotListed | ||
col3StartDate | col3_start_date |
date | SZRAPLY | col3StartDate | |||
col3State | col3_state |
col3State
character varying | 30 | SZRAPLY | col3State | |
col4Cds | col4_cds |
col4Cds
character | 6 | SZRAPLY | col4Cds | |
col4CdsFull | col4_cds_full |
col4CdsFull
Character varying | 14 | SZRAPLY | col4CdsFull | |
col4Ceeb | col4_ceeb |
col4Ceeb
character | 7 | SZRAPLY | col4Ceeb | |
col4City | col4_city |
character varying | 20 | SZRAPLY | col4City | ||
col4Country | col4_country |
col4Country
character | 2 | SZRAPLY | col4Country | |
col4DegreeDate | col4_degree_date |
col4DegreeDate
date | SZRAPLY | col4DegreeDate | ||
col4DegreeObtained | col4_degree_obtained |
col4DegreeObtained
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 |
col4NotListed
boolean | SZRAPLY | col4NotListed | ||
col4StartDate | col4_start_date |
col4StartDate
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 |
collegeId
character | 3 | SZRAPLY | collegeId | |
collegeName | college_name |
collegeName
character varying | 50 | SZRAPLY | collegeName | |
comfortableEnglish | comfortable_english |
boolean | SZRAPLY | comfortableEnglish | ||||
comments | comments | text | 50 | SZRAPLY | comments | |
completedEleventhGrade | completed_eleventh_grade |
completedEleventhGrade
NO LONGER USED | boolean | SZRAPLY | completedEleventhGrade | |||
confirmation | confirmation | character varying | 30 | SZRAPLY | confirmation | |
consentIndicator | consent_indicator |
boolean | SZRAPLY | consentIndicator | |||
counselingPersonal | counseling_personal |
counselingPersonal
boolean | SZRAPLY | counselingPersonal | ||||
country | country | character | 2 | SZRAPLY | country |
cryptokeyid
N/A | cryptokeyid | RESTRICTED USE | integer | N/A | N/A | |
dependentStatus | dependent_status |
dependentStatus
character | 1 | SZRAPLY | dependentStatus | |
dischargeType | discharge_type |
dischargeType
character varying | 1 | SZRAPLY | dischargeType | |
districtName | district_name |
character varying | 50 | SZRAPLY | districtName | |||
dsps | dsps | boolean | SZRAPLY | dsps | ||
eduGoal | edu_goal |
eduGoal
character | 1 | SZRAPLY | eduGoal | |
eligAb540 | elig_ab540 |
eligAb540
boolean | SZRAPLY | eligAb540 | ||||
character varying | 254 | SZRAPLY | ||||
emailVerified | email_verified |
emailVerified
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 |
esignature
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 |
finAidRef
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 |
fosterYouthPriority
boolean | SZRAPLY | fosterYouthPriority | ||
fosterYouthStatus | foster_youth_status |
fosterYouthStatus
character | 1 | SZRAPLY | fosterYouthStatus | |
fosterYouths | foster_youths |
NO LONGER IN USE | boolean | SZRAPLY | fosterYouths | ||
fraudScore | fraud_score |
fraudScore
double precision | SZRAPLY | fraudScore | ||
fraudStatus | fraud_status |
integer | SZRAPLY | fraudStatus | ||||
gender | gender | character | 1 | SZRAPLY | gender | |
gradePointAverage | grade_point_average |
gradePointAverage
Alphanumeric | 5 | SZRAPLY | gradePointAverage | |
healthServices | health_services |
healthServices
boolean | SZRAPLY | healthServices | ||
higherCompDate | higher_comp_date |
higherCompDate
date | SZRAPLY | higherCompDate | ||
higherEduLevel | higher_edu_level |
higherEduLevel
character | 1 | SZRAPLY | higherEduLevel | |
highestEduLevel | highest_edu_level |
character | 5 | SZRAPLY | highestEduLevel | ||
highestEnglishCourse | highest_english_course |
highestEnglishCourse
Integer | SZRAPLY | highestEnglishCourse | ||
highestEnglishGrade | highest_english_grade |
highestEnglishGrade
Character varying | 2 | SZRAPLY | highestEnglishGrade | |
highestGradeCompleted | highest_grade_completed |
highestGradeCompleted
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 |
highestMathTakenGrade
Character varying | 2 | SZRAPLY | highestMathTakenGrade | |||
hispanic | hispanic | boolean | SZRAPLY | hispanic | ||
homelessYouth | homeless_youth |
homelessYouth
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 |
hsCds
character | 6 | SZRAPLY | hsCds | |
hsCdsFull | hs_cds_full |
hsCdsFull
Character varying | 14 | SZRAPLY | hsCdsFull | |
hsCeeb | hs_ceeb |
character | 7 | SZRAPLY | hsCeeb | ||
hsCity | hs_city |
hsCity
character varying | 20 | SZRAPLY | hsCity | |
hsCompDate | hs_comp_date |
date | SZRAPLY | hsCompDate | |||
hsCountry | hs_country |
hsCountry
character | 2 | SZRAPLY | hsCountry | |
hsEduLevel | hs_edu_level |
hsEduLevel
character | 1 | SZRAPLY | hsEduLevel | |
hsName | hs_name |
hsName
character varying | 30 | SZRAPLY | hsName | |
hsNotAttended | hs_not_attended |
hsNotAttended
boolean | SZRAPLY | hsNotAttended | ||
hsNotListed | hs_not_listed |
boolean | SZRAPLY | hsNotListed | |||
hsState | hs_state |
hsState
character | 2 | SZRAPLY | hsState | |
integrityFg01 | integrity_fg_01 |
integrityFg01
boolean | SZRAPLY | integrityFg01 | ||
integrityFg02 | integrity_fg_02 |
integrityFg02
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 |
integrityFg30
Boolean | SZRAPLY | integrityFg30 | ||
integrityFg40 | Integrity_fg_40 |
integrityFg40
boolean | SZRAPLY | integrityFg40 | ||
N/A | Integrity_fg_41 |
boolean | N/A | N/A | |||
integrityFg47 | integrity_fg_47 |
boolean | SZRAPLY | integrityFg47 | |||
integrityFg48 | integrity_fg_48 |
integrityFg48
boolean | SZRAPLY | integrityFg48 | ||
integrityFg49 | integrity_fg_49 |
integrityFg49
boolean | SZRAPLY | integrityFg49 | ||
integrityFg50 | integrity_fg_50 |
boolean | SZRAPLY | integrityFg50 | |||
integrityFg51 | integrity_fg_51 |
integrityFg51
boolean | SZRAPLY | integrityFg51 | ||
integrityFg52 | integrity_fg_52 |
boolean | SZRAPLY | integrityFg52 | |||
integrityFg53 | integrity_fg_53 |
integrityFg53
boolean | SZRAPLY | integrityFg53 | ||
integrityFg54 | integrity_fg_54 |
integrityFg54
boolean | SZRAPLY | integrityFg54 | ||
integrityFg55 | integrity_fg_55 |
integrityFg55
boolean | SZRAPLY | integrityFg55 | ||
integrityFg56 | integrity_fg_56 |
integrityFg56
boolean | SZRAPLY | integrityFg56 | ||
integrityFg57 | integrity_fg_57 |
boolean | SZRAPLY | integrityFg57 | |||
integrityFg58 | integrity_fg_58 |
integrityFg58
boolean | SZRAPLY | integrityFg58 | ||
integrityFg59 | integrity_fg_59 |
integrityFg59
boolean | SZRAPLY | integrityFg59 | ||
integrityFg60 | integrity_fg_60 |
integrityFg60
boolean | SZRAPLY | integrityFg60 | ||
integrityFg61 | integrity_fg_61 |
boolean | SZRAPLY |
integrityFg61 | |
integrityFg62 | integrity_fg_62 |
boolean | SZRAPLY | integrityFg62 | |||
integrityFg63 | integrity_fg_63 |
integrityFg63
boolean | SZRAPLY | integrityFg63 | ||
integrityFg64 | integrity_fg_64 |
integrityFg64
boolean | SZRAPLY | integrityFg64 | ||
integrityFg65 | integrity_fg_65 |
integrityFg65
boolean | SZRAPLY | integrityFg65 | ||
integrityFg70 | integrity_fg_70 |
integrityFg70
boolean | SZRAPLY | integrityFg70 | ||
integrityFg71 | integrity_fg_71 |
boolean | SZRAPLY | integrityFg71 | |||
integrityFg80 | integrity_fg_80 |
integrityFg80
boolean | SZRAPLY | integrityFg80 | ||
integrityFg81 | Integrity_fg_81 |
integrityFg81
boolean | SZRAPLY | integrityFg81 | ||
integrityFlags | integrity_flags |
integrityFlags
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 |
ipAddressAtAppCreation
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 |
mailingAddressValidationOverride
v SG 4.6 | boolean | SZRAPLY | mailingAddressValidationOverride | |||
mainphone | mainphone | character varying | 19 | SZRAPLY | mainphone | |
mainphoneAuthText | mainphone_auth_text |
mainphoneAuthText
NO LONGER IN USE | boolean | SZRAPLY | mainphoneAuthText | |
mainphoneExt | mainphone_ext |
mainphoneExt
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 |
majorId
SYSTEM USE ONLY | bigint | SZRAPLY | majorId | |||
middlename | middlename | character varying | 50 | SZRAPLY | middlename | |
militaryCaStationed | military_ca_stationed |
militaryCaStationed
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 |
militaryLegalResidence
character | 2 | SZRAPLY | militaryLegalResidence | |
militaryStationedCaEd | military_stationed_ca_ed |
militaryStationedCaEd
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 |
noDocuments
boolean | SZRAPLY | noDocuments | ||
noMailingAddressHomeless | no_mailing_address_homeless |
noMailingAddressHomeless
boolean | SZRAPLY | noMailingAddressHomeless | ||
noPermAddressHomeless | no_perm_address_homeless |
noPermAddressHomeless
boolean | SZRAPLY | noPermAddressHomeless | ||
nonCredit | non_credit |
nonCredit
boolean | SZRAPLY | nonCredit | ||
nonUsAddress | non_us_address |
boolean | SZRAPLY | nonUsAddress | ||||
nonusaprovince | nonusaprovince | character varying | 30 | SZRAPLY | nonusaprovince | |
onlineClasses | online_classes |
onlineClasses
boolean | SZRAPLY | onlineClasses | ||||
orientation | orientation | RESTRICTED USE | byte | 1 | SZRAPLY | orientation |
N/A | orientation_encrypted |
N/A
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 |
permNonusaprovince
character varying | 30 | SZRAPLY | permNonusaprovince | |
permPostalcode | perm_postalcode |
permPostalcode
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 |
permZip4
character | 4 | SZRAPLY | permZip4 | |
pgEduMis | pg_edu_mis |
pgEduMis
character | 2 | SZRAPLY | pgEduMis | |
pgFirstname | pg_firstname |
character varying | 20 | SZRAPLY | pgFirstname | ||
pgLastname | pg_lastname |
pgLastname
character varying | 25 | SZRAPLY | pgLastname | |
pgRel | pg_rel |
character | 1 | SZRAPLY | pgRel | ||
pg1Edu | pg1_edu |
pg1Edu
character | 1 | SZRAPLY | pg1Edu | |
pg2Edu | pg2_edu |
pg2Edu
character | 1 | SZRAPLY | pg2Edu | |
phoneType | phone_type |
phoneType
v SG 4.6 | varchar | 10 | SZRAPLY | phoneType |
phoneVerified | phone_verified |
phoneVerified
Boolean | SZRAPLY | phoneVerified | ||
phoneVerifiedTimestamp | phone_verified_timestamp |
timestamp with time zone | SZRAPLY | phoneVerifiedTimestamp | ||||
postalcode | postalcode | character varying | 20 | SZRAPLY | postalcode | |
preferredMethodOfContact | preferred_contact_method |
preferredMethodOfContact
VarChar | 10 | SZRAPLY | preferredMethodOfContact | |
preferredFirstname | preferred_firstname |
preferredFirstname
Text string | 50 | SZRAPLY | preferredFirstname | |
preferredLastname | preferred_lastname |
preferredLastname
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 |
raceEthnicFull
text | 805 | SZRAPLY | raceEthnicFull | |
raceGroup | race_group |
raceGroup
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 |
resAreaC
smallint | SZRAPLY | resAreaC | ||
resAreaD | res_area_d |
resAreaD
smallint | SZRAPLY | resAreaD | ||
resPrevDate | res_prev_date |
date | SZRAPLY | resPrevDate | |||
resStatus | res_status |
resStatus
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 |
scholarshipInfo
boolean | SZRAPLY | scholarshipInfo | ||
secondphoneAuthText | secondphone_auth_text |
secondphoneAuthText
NO LONGER IN USE | boolean | SZRAPLY | secondphoneAuthText | |
secondphoneExt | secondphone_ext |
secondphoneExt
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 |
ssnDisplay
character varying | 11 | SZRAPLY | ssnDisplay | |
ssnException | ssn_exception |
ssnException
boolean | SZRAPLY | ssnException | ||
ssnNo | ssn_no |
ssnNo
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 |
studentParent
SG 4.7 | boolean | SZRAPLY | studentParent | |||
suffix | suffix | character varying | 3 | SZRAPLY | suffix | |
supPageCode | sup_page_code |
supPageCode
NO LONGER IN USE | character varying | 30 | SZRAPLY | supPageCode |
tanfSsiGa | tanf_ssi_ga |
boolean | SZRAPLY | tanfSsiGa | |||
termCode | term_code |
termCode
character varying | 15 | SZRAPLY | termCode | |
termDescription | term_description |
character varying | 100 | SZRAPLY | termDescription | ||
termId | term_id |
termId
SYSTEM USE ONLY | bigint | SZRAPLY | termId | |
termEnd | term_end |
termEnd
date | 13 | SZRAPLY | termEnd | |
termStart | term_start |
termStart
date | 13 | SZRAPLY | termStart | |
testingAssessment | testing_assessment |
testingAssessment
boolean | SZRAPLY | testingAssessment | ||
transferInfo | transfer_info |
boolean | SZRAPLY | transferInfo | ||||
transgender | transgender | RESTRICTED USE | Byte | 1 | SZRAPLY | transgender |
N/A | transgender_encrypted |
N/A
RESTRICTED USE | N/A | N/A | ||
tstmpCreate | tstmp_create |
tstmpCreate
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 |
tutoringServices
boolean | SZRAPLY | tutoringServices | ||
under19Ind | under19_ind |
under19Ind
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 |