adm_std_academic_degree


Description

A degree in progress or obtained from a previous institution by an applicant

Columns

Column Type Size Nulls Auto Default Children Parents Comments
uw_id "_quest"."quest_uw_id" 2147483647 null
adm_std_academic_attendance.uw_id adm_std_academic_degree_uw_id_fkeyR
ext_org_id "_quest"."quest_org_id" 2147483647 null
adm_std_academic_attendance.ext_org_id adm_std_academic_degree_uw_id_fkeyR
ext_career_code text 2147483647 null
adm_std_academic_attendance.ext_career_code adm_std_academic_degree_uw_id_fkeyR
ext_career_seq int4 10 null
adm_std_academic_attendance.ext_career_seq adm_std_academic_degree_uw_id_fkeyR
ext_degree_seq int4 10 null
degree_code text 2147483647 null
pps_degree.degree_code adm_std_academic_degree_degree_code_fkeyR

The type of degree
degree_date date 13 √ null
uw_date.date Implied ConstraintR

The date of the degree
degree_status_code text 2147483647 null
uw_ext_degree_status.degree_status_code adm_std_academic_degree_degree_status_code_fkeyR

The status of the degree
degree_specialization text 2147483647 √ null

The specialization or topic for the degree

Table contained 159342 rows

Indexes

Constraint Name Type Sort Column(s)
adm_std_academic_degree_pkey Primary key Asc/Asc/Asc/Asc/Asc uw_id + ext_org_id + ext_career_code + ext_career_seq + ext_degree_seq

Relationships

Close relationships within degrees of separation