JIRA: - OPENAPPLY-7049Getting 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 |