adm_appl_program_financial_aid_history


Description

A financial aid application as of a date

Columns

Column Type Size Nulls Auto Default Children Parents Comments
uw_id "_quest"."quest_uw_id" 2147483647 null
adm_appl_program.uw_id adm_appl_program_financial_aid_history_uw_id_fkeyR
appl_id "_quest"."quest_appl_id" 2147483647 null
adm_appl_program.appl_id adm_appl_program_financial_aid_history_uw_id_fkeyR
program_order int4 10 null
adm_appl_program.program_order adm_appl_program_financial_aid_history_uw_id_fkeyR
aid_category_code text 2147483647 null
aid_as_of date 13 null
aid_sequence int4 10 null
aid_amount numeric 8,2 null

The amount of the financial aid application
aid_status_code text 2147483647 null
uw_aid_status.aid_status_code adm_appl_program_financial_aid_history_aid_status_code_fkeyR

The status of the financial aid application

Table contained 278704 rows

Indexes

Constraint Name Type Sort Column(s)
adm_appl_program_financial_aid_history_pkey Primary key Asc/Asc/Asc/Asc/Asc/Asc uw_id + appl_id + program_order + aid_category_code + aid_as_of + aid_sequence

Relationships

Close relationships within degrees of separation