JIRA: OPENAPPLY-7049 - Getting issue details... STATUS
| Field | Current DB Value | BOG Data Dictionary Value |
|---|---|---|
| app_id | bigint NOT NULL DEFAULT nextval('bog_application_app_id_seq'::regclass) |
|
| ccc_id | character varying(8) NOT NULL |
|
| confirmation_number | character varying(25) |
|
| status | ||
| app_lang | ||
| college_id | ||
| year_code | ||
| year_description | ||
| determined_residentca | ||
| determined_ab540_eligible | ||
| 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 |