Versions Compared

Old Version 3

changes.mady.by.user Amanda Mason

Saved on

compared with

New Version 4

changes.mady.by.user Amanda Mason

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

FieldCurrent DB ValueBOG Data Dictionary ValueNotes
app_idbigint NOT NULL DEFAULT nextval('bog_application_app_id_seq'::regclass)
  • Data Type/Format: Bigint
  • Data Type from CC Promise Grant Application Downloadable Fields: bigint
  • Length: blank
  • Allows Null: No
  • Value: blank
ccc_idcharacter varying(8) NOT NULL
  • Format, Length: Character varying(8)
  • Data Type from CC Promise Grant Application Downloadable Fields: String
  • Length: 8
  • Allows Null: No. This is a system assigned field and is not entered by the user.
  • Value:

The format of the ccc_id is:
Positions 1 - 3: AAA thru ZZZ (Sequentially assigned beginning with AAA)

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_numbercharacter varying(25)
  • Data Type/Format: Character
  • Data Type from CC Promise Grant Application Downloadable Fields: String
  • Length: 25
  • Allows Null: blank
  • Value: blank
statuscharacter(1)
  • Data Type/Format: Character(1)
  • Data Type from CC Promise Grant Application Downloadable Fields Table: String
  • Length: 1
  • Allows Null: blank
  • Value

Blank – In progress

I = Initially written to submitted table

D= Downloaded by college

Per page 21 in the notes of the data dictionary:

Blank – In progress

I = Initially written to submitted table

D= Downloaded by college

app_langcharacter(2)
  • Format/Length: bpchar, 2
  • Data Type from CC Promise Grant Application Downloadable Fields Table: String
  • Length: 2
  • Allows Null: blank
  • Value:

    es –Spanish

    en –English

college_idcharacter(3)
  • Data Type/Format: Character(3)
  • Data Type from CC Promise Grant Application Downloadable Fields Table: String
  • Length: 3
  • Allows Null: blank
  • Value: blank
year_codebigint
  • Data Type/Format: Character varying(15)
  • Data Type from CC Promise Grant Application Downloadable Fields Table: Blank
  • Length: blank
  • Allows Null: blank
  • Value: blank


year_descriptioncharacter varying(100)
  • Data Type/Format: Character varying(15)
  • Data Type from CC Promise Grant Application Downloadable Fields Table: String
  • Length: 100
  • Allows Null: blank
  • Value: blank
determined_residentcacharacter(1)
  • Data Type/Format: Yes/No 1
  • Data Type from CC Promise Grant Application Downloadable Fields Table: String
  • Length: 1
  • Allows Null: blank

  • Value:

    1 - Yes/Sí [internal default]

    0 - No

determined_ab540_eligiblecharacter(1)
  • Data Type/Format: Yes/No 1
  • Data Type from CC Promise Grant Application Downloadable Fields Table: String
  • Length: 1
  • Allows Null: blank
  • Value: 

    1 - Yes/Sí [internal default]

    0 – No

determined_non_res_exempt

lastname

firstname

middlename

mainphone

mainphone_ext

mainphone_auth_text

email

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

...