Promise Grant (BOG) Data Fields

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)

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)

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_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