Reference the OpenCCCBog_specifications.doc for field definitions.
Database field name and and — data type (length) | Comments |
ccc_id 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 — character (1) |
|
elig_medal_honor— character (1) |
|
elig_sept_11 character — 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 |
|