Versions Compared

Old Version 2

changes.mady.by.user Amanda Mason

Saved on

compared with

New Version 3

changes.mady.by.user Amanda Mason

Saved on

Key

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

JIRA: 

Jira Legacy
serverSystem JIRA
serverIda79f1fc5-1ea0-3960-95ec-ad67852870f1
keyOPENAPPLY-7049


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
Data Type: string
  • 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:
lists both "Character" and "String"
  • 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