...
Field | Current DB Value | BOG Data Dictionary Value | Notes |
---|---|---|---|
app_id | bigint NOT NULL DEFAULT nextval('bog_application_app_id_seq'::regclass) |
| |
ccc_id | character varying(8) NOT NULL |
The format of the ccc_id is: Positions 4 – 7: 0001 thru 9999 (Sequentially assigned beginning with 0001 for each value in positions 1-3) Position 8: For future expansion if all values become exhausted. Note: In positions 1-3, “I” and “O” are not used to avoid confusion with “0” and “1”. | |
confirmation_number | character varying(25) |
| |
status | character(1) |
Blank – In progress I = Initially written to submitted table D= Downloaded by college Blank – In progress I = Initially written to submitted table D= Downloaded by college | |
app_lang | character(2) |
| |
college_id | character(3) |
| |
year_code | bigint |
| |
year_description | character varying(100) |
| |
determined_residentca | character(1) |
| |
determined_ab540_eligible | character(1) |
| |
determined_non_res_exempt | |||
lastname | |||
firstname | |||
middlename | |||
mainphone | |||
mainphone_ext | |||
mainphone_auth_text | |||
non_us_address | |||
streetaddress1 | |||
streetaddress2 | |||
city | |||
state | |||
province | |||
country | |||
postalcode | |||
ssn | |||
ssn_hash | |||
ssn_type | |||
student_college_id | |||
birthdate | |||
marital_status | |||
reg_dom_partner | |||
born_before_23_year | |||
married_or_rdp | |||
us_veteran | |||
dependents | |||
parents_deceased | |||
emancipated_minor | |||
legal_guardianship | |||
homeless_youth_school | |||
homeless_youth_hud | |||
homeless_youth_other | |||
dependent_on_parent_taxes | |||
living_with_parents | |||
dependency_status | |||
cert_veteran_affairs | |||
cert_national_guard | |||
elig_medal_honor | |||
elig_sept_11 | |||
elig_police_fire | |||
tanf_calworks | |||
ssi_ssp | |||
general_assistance character | |||
parents_assistance character | |||
dep_number_household | |||
ind_number_household | |||
dep_gross_income | |||
ind_gross_income | |||
dep_other_income | |||
ind_other_income | |||
dep_total_income | |||
ind_total_income | |||
elig_method_a | |||
elig_method_b | |||
elig_bogfw | |||
confirmation_parent_guardian | |||
parent_guardian_name | |||
ack_fin_aid | |||
confirmation_applicant | |||
last_page | |||
ssn_last4 | |||
tstmp_submit | |||
tstmp_create | |||
tstmp_update | |||
tstmp_download | |||
term_code | |||
cryptokeyid integer | |||
ip_address | |||
campaign1 | |||
campaign2 | |||
campaign3 | |||
ssn_exception | |||
college_name | |||
preferred_firstname | |||
preferred_middlename | |||
preferred_lastname | |||
preferred_name | |||
ssn_no | |||
no_perm_address_homeless | |||
no_mailing_address_homeless | |||
determined_homeless | |||
elig_method_d | |||
mainphoneintl |
...