uw_term


Description

An academic term

Columns

Column Type Size Nulls Auto Default Children Parents Comments
term_id "_quest"."quest_term_id" 2147483647 null
ro_load_term.term_id ro_load_term_term_id_fkeyR
ta_term_unit.term_id ta_term_unit_term_id_fkeyR
teaching_admin_term.term_id teaching_admin_term_term_id_fkeyR
offer_course_term.term_id offer_course_term_term_id_fkeyR
adm_appl_program.admit_term_id adm_appl_program_admit_term_id_fkeyR
adm_appl_program_history.admit_term_id adm_appl_program_history_admit_term_id_fkeyR
off_course_as_of.term_id off_course_as_of_term_id_fkeyR
off_course_section_complete.term_id Implied ConstraintR
off_course_section_plus.term_id Implied ConstraintR
off_instruct_section.term_id off_instruct_section_term_id_fkeyR
off_instruct_section_instructor_plus.term_id Implied ConstraintR
off_instruct_section_meet_plus.term_id Implied ConstraintR
pps_plan.first_valid_term_id pps_plan_first_valid_term_id_fkeyR
pps_plan.last_admit_term_id pps_plan_last_admit_term_id_fkeyR
pps_plan_history.first_valid_term_id pps_plan_history_first_valid_term_id_fkeyR
pps_plan_history.last_admit_term_id pps_plan_history_last_admit_term_id_fkeyR
pps_program.first_valid_term_id pps_program_first_valid_term_id_fkeyR
pps_program_history.first_valid_term_id pps_program_history_first_valid_term_id_fkeyR
pps_subplan.first_valid_term_id pps_subplan_first_valid_term_id_fkeyR
pps_subplan.last_admit_term_id pps_subplan_last_admit_term_id_fkeyR
pps_subplan_history.first_valid_term_id pps_subplan_history_first_valid_term_id_fkeyR
pps_subplan_history.last_admit_term_id pps_subplan_history_last_admit_term_id_fkeyR
std_degree.completion_term_id Implied ConstraintR
std_degree_plus.completion_term_id Implied ConstraintR
std_plan_history.requirement_term_id Implied ConstraintR
std_program_history.admit_term_id std_program_history_admit_term_id_fkeyR
std_program_history.completion_term_id std_program_history_completion_term_id_fkeyR
std_program_history.expected_grad_term_id std_program_history_expected_grad_term_id_fkeyR
std_program_history.requirement_term_id std_program_history_requirement_term_id_fkeyR
std_service_indicator.active_term std_service_indicator_active_term_fkeyR
std_subplan_history.requirement_term_id Implied ConstraintR
std_term.term_id std_term_term_id_fkeyR
std_term_award.term_id std_term_award_term_id_fkeyR
std_term_course_plus.term_id Implied ConstraintR
std_term_course_section.term_id Implied ConstraintR
std_term_grad_supervision.term_id Implied ConstraintR
std_term_plan.requirement_term_id Implied ConstraintR
std_term_plan_plus.first_valid_term_id Implied ConstraintR
std_term_plan_plus.last_admit_term_id Implied ConstraintR
std_term_plan_plus.requirement_term_id Implied ConstraintR
std_term_plan_plus.term_id Implied ConstraintR
std_term_program.admit_term_id std_term_program_admit_term_id_fkeyR
std_term_program.completion_term_id std_term_program_completion_term_id_fkeyR
std_term_program.expected_grad_term_id std_term_program_expected_grad_term_id_fkeyR
std_term_program.requirement_term_id std_term_program_requirement_term_id_fkeyR
std_term_program_history.request_term_id Implied ConstraintR
std_term_program_history.term_id Implied ConstraintR
std_term_program_plus.admit_term_id Implied ConstraintR
std_term_program_plus.completion_term_id Implied ConstraintR
std_term_program_plus.expected_grad_term_id Implied ConstraintR
std_term_program_plus.requirement_term_id Implied ConstraintR
std_term_program_plus.term_id Implied ConstraintR
std_term_subplan.requirement_term_id Implied ConstraintR
std_transfer_credit_detail_plus.term_id Implied ConstraintR
uw_date.term_id uw_date_term_id_fkeyR
term_dates daterange 2147483647 null

The range of dates covered by the term
term_class_dates daterange 2147483647 null

The range of dates designated for classes for the term
term_exam_dates daterange 2147483647 √ null

The range of dates designated for final examinations for the term, or NULL if the examination period has not been published yet
term_calendar_year int4 10 null

The calendar year during which the term falls
term_academic_year int4 10 null

The academic year during which the term falls
term_fiscal_year int4 10 null

The fiscal year during which the term falls

Table contained 202 rows

Indexes

Constraint Name Type Sort Column(s)
uw_term_pkey Primary key Asc term_id

Relationships

Close relationships within degrees of separation