Reference the CC Promise Grant Application (BOG) Data Dictionary for field definitions, located here: Data Dictionaries
As a best practice, we recommend creating two sets of Promise Grant (BOG) download files (e.g., Format Definition XML, Job XML) - one for the Pilot environment and one for the Production environment. Find information on setting up download files and using the Download Client in the Download Client User Guide.
Database field name and — data type (length) | Comments |
ccc_id — character varying (8) NOT Null |
|
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 (4) | This field is downloadable and refers to the highest year of the BOG Academic Year Ex. "term_code" = 2016 for the BOG Academic Year of 2015-2016 This is the same as the Enrollment Term in XAP |
year_description — character varying (100) | This is the BOG year description (i.e. Fall 2015 through Summer 2016) |
determined_residentca — character (1) |
|
determined_ab540_eligible — character (1) |
|
determined_non_res_exempt — character (1) |
|
determined_homeless - character (1) | New April 2017 |
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) |
|
no_perm_address_homeless - boolean | New April 2017 |
no_mailing_address_homeless - boolean | New April 2017 |
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_method_d - 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_download — timestamp with time zone |
|