pps_plan_type


Description

A possible plan type which may be associated with a plan

Columns

Column Type Size Nulls Auto Default Children Parents Comments
plan_type_code text 2147483647 null
pps_plan.plan_type_code pps_plan_plan_type_code_fkeyR
pps_plan_history.plan_type_code pps_plan_history_plan_type_code_fkeyR
std_term_plan_plus.plan_type_code Implied ConstraintR
plan_type_as_of date 13 null
plan_type_active bool 1 null
plan_type_description text 2147483647 null
pt_coop bool 1 null
pt_joint bool 1 null
pt_cost_recovery bool 1 null
pt_honors bool 1 null
qualification_type_code text 2147483647 null
pps_qualification_type.qualification_type_code pps_plan_type_qualification_type_code_fkeyR
program_type_code text 2147483647 √ null
pps_program_type.program_type_code pps_plan_type_program_type_code_fkeyR
degree_level_code text 2147483647 √ null
pps_degree_level.degree_level_code pps_plan_type_degree_level_code_fkeyR
mtcu_level_code text 2147483647 √ null
pps_mtcu_level.mtcu_level_code pps_plan_type_mtcu_level_code_fkeyR

Table contained 105 rows

Indexes

Constraint Name Type Sort Column(s)
pps_plan_type_pkey Primary key Asc plan_type_code

Relationships

Close relationships within degrees of separation