Reference the OpenCCCBog_specifications.doc for field definitions.
Database field name and type | Comments |
ccc_id character varying(8) NOT Null | New field – not in XAP |
confirmation_number character varying(25) |
|
status character(1) |
|
app_lang character(2) |
|
college_id character(3) | MIS code of the college being applied to |
year_code bigint | Used internally only - not a downloadable field |
term_code character varying(5) | This is the same as the Enrollment Term in XAP |
year_description character varying(100) | This is the year description |
determined_residentca character(1) |
|
determined_ab540_eligible character(1) |
|
determined_non_res_exempt character(1) |
|
lastname character varying(50) |
|
firstname character varying(50) |
|
middlename character varying(50) |
|
mainphone character varying(14) |
|
mainphone_ext character varying(4) |
|
mainphone_auth_text boolean |
|
email character varying(128) |
|
non_us_address boolean |
|
streetaddress1 character varying(50) |
|
streetaddress2 character varying(50) |
|
city character varying(50) |
|
state character varying(2) |
|
province character varying(30) |
|
country character varying(2) |
|
postalcode character varying(20) |
|
ssn text |
|
student_college_id character varying(20) |
|
birthdate date |
|
marital_status character(1) |
|
reg_dom_partner character(1) |
|
born_before_23_year character(1) |
|
married_or_rdp character(1) |
|
us_veteran character(1) |
|
dependents character(1) |
|
parents_deceased character(1) |
|
emancipated_minor character(1) |
|
legal_guardianship character(1) |
|
homeless_youth_school character(1) |
|
homeless_youth_hud character(1) |
|
homeless_youth_other character(1) |
|
dependent_on_parent_taxes character(1) |
|
living_with_parents character(1) |
|
dependency_status character(1) |
|
cert_veteran_affairs character(1) |
|
cert_national_guard character(1) |
|
elig_medal_honor character(1) |
|
elig_sept_11 character(1) |
|
elig_police_fire character(1) |
|
tanf_calworks character(1) |
|
ssi_ssp character(1) |
|
general_assistance character(1) |
|
parents_assistance character(1) |
|
dep_number_household integer |
|
ind_number_household integer |
|
dep_gross_income integer |
|
ind_gross_income integer |
|
dep_other_income integer |
|
ind_other_income integer |
|
dep_total_income integer |
|
ind_total_income integer |
|
elig_method_a boolean |
|
elig_method_b boolean |
|
elig_bogfw character(1) |
|
confirmation_parent_guardian boolean |
|
parent_guardian_name character varying(60) |
|
ack_fin_aid boolean DEFAULT false |
|
confirmation_applicant boolean DEFAULT false |
|
last_page character varying(25) |
|
ssn_last4 character(4) |
|
tstmp_submit timestamp with time zone | Submission date and time |
tstmp_create timestamp with time zone |
|
tstmp_update timestamp with time zone |
|
tstmp_download timestamp with time zone |
|