Versions Compared

Old Version 4

changes.mady.by.user Amanda Mason

Saved on

compared with

New Version 5

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 Value
app_id

bigint

NOT NULL DEFAULT nextval('bog_application_app_id_seq'::regclass)

  • Data Type/Format: Bigint Bigint
  • Data Type from CC Promise Grant Application Downloadable Fields: bigint
  • Length: blank
  • Allows Null: No
  • Value: blank
ccc_id

character 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_number

character 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

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  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_exemptcharacter(1)
  • Data Type/Format: determined_non-res_exempt
  • Data Type from CC Promise Grant Application Downloadable Fields Table
  • Length:
  • Allows Null:
  • Value: 
lastname
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
firstname
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
middlename
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
mainphone
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
mainphone_ext
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
mainphone_auth_text
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
email
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
non_us_address
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
streetaddress1
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
streetaddress2
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
city
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
state
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
province
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
country
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
postalcode
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
ssn
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
ssn_hash
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
ssn_type
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
student_college_id
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
birthdate
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
marital_status
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
reg_dom_partner
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
born_before_23_year
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
married_or_rdp
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
us_veteran
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
dependents
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
parents_deceased
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
emancipated_minor
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
legal_guardianship
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
homeless_youth_school
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
homeless_youth_hud
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
homeless_youth_other
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
dependent_on_parent_taxes
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
living_with_parents
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
dependency_status
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
cert_veteran_affairs
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
cert_national_guard
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
elig_medal_honor
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
elig_sept_11
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
elig_police_fire
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
tanf_calworks
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
ssi_ssp
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
general_assistance character
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
parents_assistance character
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
dep_number_household
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
ind_number_household
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
dep_gross_income
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
ind_gross_income
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
dep_other_income
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
ind_other_income
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
dep_total_income
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
ind_total_income
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
elig_method_a
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
elig_method_b
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
elig_bogfw
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
confirmation_parent_guardian
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
parent_guardian_name
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
ack_fin_aid
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
confirmation_applicant
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
last_page
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
ssn_last4
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
tstmp_submit
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
tstmp_create
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
tstmp_update
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
tstmp_download
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
term_code
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
cryptokeyid integer
  • Data Type/Format: 
  • Data Type from CC Promise Grant Application Downloadable Fields Table:
  • Length:
  • Allows Null:
  • Value: 
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

...