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