Reference the OpenCCCBog_specifications.doc for field definitions.
Database field name and typethe CC Promise Grant Application (BOG) Data Dictionary for field definitions, located here: Data Dictionaries
Note |
---|
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 |
— 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
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 |
tstmp_update timestamp with time zone
— timestamp with time zone | |
tstmp_download |
— timestamp |
with |
time |
zone |