SchemaSpy Analysis of odyssey_test._quest - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Wed Feb 19 10:30 EST 2014
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

odyssey_test._quest contains 793 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
off_instruct_section_meet meet_days bit 7
off_instruct_section_meet_plus meet_days bit 7  √  null
std_term_course_demand apply_ng_grade bool 1  √  null
uw_campus campus_active bool 1
uw_campus_history campus_active bool 1
cal_course course_active bool 1
cal_course_history course_active bool 1
off_course_section_complete course_active bool 1  √  null
std_program_history data_from_adm_appl bool 1
std_term_program data_from_adm_appl bool 1
std_term_program_plus data_from_adm_appl bool 1  √  null
pps_degree degree_active bool 1
pps_degree_history degree_active bool 1
pps_degree degree_internal bool 1
pps_degree_history degree_internal bool 1
std_degree degree_revoked bool 1
pps_service_indicator display_in_self_serve bool 1
std_term_course earn_credit bool 1
std_transfer_credit_detail earn_credit bool 1
std_term eligible_to_enrol bool 1
off_instruct_section_meet_plus facility_active bool 1  √  null
uw_room facility_active bool 1
uw_group group_active bool 1
uw_group_history group_active bool 1
std_term_course include_in_gpa bool 1
std_transfer_credit_detail include_in_gpa bool 1
std_transfer_credit_school include_in_gpa bool 1
cal_course_label label_schedule_print bool 1
cal_course_label_history label_schedule_print bool 1
off_course_section_complete label_schedule_print bool 1  √  null
off_course_section_plus label_schedule_print bool 1  √  null
uw_location location_active bool 1
uw_location_history location_active bool 1
off_default_note note_active bool 1
off_default_note_history note_active bool 1
std_term_units override_max_units bool 1
pps_plan plan_active bool 1
pps_plan_history plan_active bool 1
std_term_plan_plus plan_active bool 1  √  null
pps_service_indicator positive_indicator bool 1
std_student privacy_flag bool 1
pps_program program_active bool 1
pps_program_history program_active bool 1
cal_requisite requisite_active bool 1
cal_requisite_history requisite_active bool 1
std_term_units reset_cum_stats bool 1
off_instruct_section section_enrolment bool 1 Whether the section is an enrolment (primary) section
off_course_section section_schedule_print bool 1
off_course_section_complete section_schedule_print bool 1  √  null
off_course_section_plus section_schedule_print bool 1  √  null
cal_subject subject_active bool 1
cal_subject_history subject_active bool 1
pps_subplan subplan_active bool 1
pps_subplan_history subplan_active bool 1
uw_unit unit_active bool 1
uw_unit_history unit_active bool 1
std_term_course valid_attempt bool 1  √  null
std_transfer_credit_detail valid_attempt bool 1
std_photo photo_original bytea 2147483647 The original photo supplied by WatCard
std_photo photo_standard bytea 2147483647 The photo re-sized to a standard size
std_program_history action_date date 13
std_term_program action_date date 13
std_term_program_plus action_date date 13  √  null
std_service_indicator active_date date 13
std_term_section add_date date 13
std_student birthdate date 13  √  null
uw_campus campus_as_of date 13
uw_campus_history campus_as_of date 13
cal_course course_as_of date 13
cal_course_history course_as_of date 13
cal_course_label course_as_of date 13
cal_course_label_history course_as_of date 13
cal_course_topic course_as_of date 13
cal_course_topic_history course_as_of date 13
off_course_as_of course_as_of date 13
off_course_section_complete course_as_of date 13  √  null
off_course_section_plus course_as_of date 13  √  null
std_program_milestone date_completed date 13  √  null
std_program_plan_milestone date_completed date 13  √  null
std_student deathdate date 13  √  null
pps_degree degree_as_of date 13
pps_degree_history degree_as_of date 13
std_degree degree_conferral_date date 13
std_term_section drop_date date 13  √  null
off_instruct_section_meet_plus facility_as_of date 13  √  null
uw_room facility_as_of date 13
std_term_plan_gpa gpa_date date 13  √  null
std_term_subplan_gpa gpa_date date 13  √  null
std_term_course grade_submission_date date 13  √  null
uw_group group_as_of date 13
uw_group_history group_as_of date 13
std_degree_honour honours_award_date date 13
std_term last_date_attended date 13  √  null
uw_location location_as_of date 13
uw_location_history location_as_of date 13
std_name name_as_of date 13
std_name_preferred name_as_of date 13  √  null
std_name_primary name_as_of date 13  √  null
off_default_note note_as_of date 13
off_default_note_history note_as_of date 13
std_photo photo_as_of date 13 When this photo was loaded
pps_plan plan_as_of date 13
pps_plan_history plan_as_of date 13
std_term_plan_plus plan_as_of date 13  √  null
pps_program program_as_of date 13
pps_program_history program_as_of date 13
std_plan_history program_as_of date 13
std_program_history program_as_of date 13
std_subplan_history program_as_of date 13
std_term_program program_as_of date 13
std_term_program_plus program_as_of date 13  √  null
pps_service_indicator_reason reason_as_of date 13
cal_requisite requisite_as_of date 13
cal_requisite_history requisite_as_of date 13
off_course_section_reserve reserve_start_date date 13
pps_service_indicator_impact service_impact_as_of date 13
pps_service_indicator service_indicator_as_of date 13
std_term standing_action_date date 13  √  null
cal_subject subject_as_of date 13
cal_subject_history subject_as_of date 13
pps_subplan subplan_as_of date 13
pps_subplan_history subplan_as_of date 13
uw_unit unit_as_of date 13
uw_unit_history unit_as_of date 13
std_term withdraw_date date 13  √  null
off_instruct_section_meet meet_dates daterange 2147483647
off_instruct_section_meet_plus meet_dates daterange 2147483647  √  null
uw_term term_class_dates daterange 2147483647
uw_term term_dates daterange 2147483647
uw_term term_exam_dates daterange 2147483647  √  null
off_association association_id int4 10
off_course_section association_id int4 10  √  null
off_course_section_complete association_id int4 10  √  null
off_course_section_plus association_id int4 10  √  null
off_instruct_section_meet_plus building_id int4 10  √  null
uw_room building_id int4 10
std_degree_plan career_num int4 10
std_plan_history career_num int4 10
std_program_history career_num int4 10
std_subplan_history career_num int4 10
std_term career_num int4 10
off_course class_id int4 10
off_course_section class_id int4 10
off_course_section_complete class_id int4 10  √  null
off_course_section_note class_id int4 10
off_course_section_plus class_id int4 10  √  null
off_course_section_reserve class_id int4 10
std_term_course class_id int4 10
std_term_course_demand class_id int4 10
std_term_section class_id int4 10
std_transfer_credit_detail course_id int4 10
off_course_section course_section_enrol_limit int4 10
off_course_section_complete course_section_enrol_limit int4 10  √  null
off_course_section_plus course_section_enrol_limit int4 10  √  null
off_course_section course_section_enrol_total int4 10
off_course_section_complete course_section_enrol_total int4 10  √  null
off_course_section_plus course_section_enrol_total int4 10  √  null
off_course_section course_section_room_capacity int4 10
off_course_section_complete course_section_room_capacity int4 10  √  null
off_course_section_plus course_section_room_capacity int4 10  √  null
pps_degree degree_years int4 10
pps_degree_history degree_years int4 10
off_instruct_section_meet_plus facility_partition int4 10  √  null
uw_room facility_partition int4 10  √  null
std_degree_honour honours_id int4 10
off_instruct_section instruct_section_capacity_request int4 10
off_instruct_section instruct_section_enrol_limit int4 10
off_instruct_section instruct_section_enrol_total int4 10
cal_course_label label_seq int4 10
cal_course_label_history label_seq int4 10
off_association label_seq int4 10
off_course label_seq int4 10
off_course_section label_seq int4 10
off_course_section_complete label_seq int4 10  √  null
off_course_section_plus label_seq int4 10  √  null
std_term_course label_seq int4 10
std_transfer_credit_detail label_seq int4 10
off_instruct_section_meet meet_id int4 10
off_instruct_section_meet_plus meet_id int4 10  √  null
std_program_milestone milestone_id int4 10
std_program_plan_milestone milestone_id int4 10
off_course_section_note note_id int4 10  √  null
off_default_note note_id int4 10
off_default_note_history note_id int4 10
std_term_section permission_number int4 10  √  null
std_degree_plan plan_position int4 10
std_plan_history plan_position int4 10
std_term_plan plan_position int4 10
std_term_plan_plus plan_position int4 10  √  null
std_term_course_demand priority int4 10  √  null
update_notification process_id int4 10 The Quest process ID of the notification
std_plan_history program_sequence int4 10
std_program_history program_sequence int4 10
std_subplan_history program_sequence int4 10
std_term_program program_sequence int4 10
std_term_program_plus program_sequence int4 10  √  null
cal_requisite requisite_id int4 10
cal_requisite_history requisite_id int4 10
off_course_section_reserve requisite_id int4 10
off_course_section_reserve reserve_enrol_limit int4 10
off_course_section_reserve reserve_enrol_total int4 10
off_course_section_reserve reserve_id int4 10
std_term_section reserve_id int4 10  √  null
off_instruct_section_meet_plus room_capacity int4 10  √  null
uw_room room_capacity int4 10
update_notification run_id int4 10  √  null The run_id, if any, this notification contributes to making ready
update_run_notification run_id int4 10
off_course_section section_id int4 10
off_course_section_complete section_id int4 10  √  null
off_course_section_plus section_id int4 10  √  null
off_instruct_section section_id int4 10
off_instruct_section_instructor section_id int4 10
off_instruct_section_instructor_plus section_id int4 10  √  null
off_instruct_section_meet section_id int4 10
off_instruct_section_meet_plus section_id int4 10  √  null
off_course_section_note section_note_id int4 10  √  null
std_transfer_credit_detail seq_num int4 10
cal_course_topic topic_seq int4 10
cal_course_topic_history topic_seq int4 10
off_course_section topic_seq int4 10  √  null
off_course_section_complete topic_seq int4 10  √  null
off_course_section_plus topic_seq int4 10  √  null
std_transfer_credit_detail transfer_group int4 10
std_transfer_credit_school transfer_group int4 10
cal_course course_ap_units numeric 5,2
cal_course_history course_ap_units numeric 5,2
off_association course_ap_units numeric 5,2
off_course_section_complete course_ap_units numeric 5,2  √  null
cal_course course_take_units numeric 5,2
cal_course_history course_take_units numeric 5,2
off_association course_take_units numeric 5,2
off_course_section_complete course_take_units numeric 5,2  √  null
std_term_units max_nogpa_unit_load numeric 5,2
std_term_units max_total_unit_load numeric 5,2
std_term_course units_attempted numeric 5,2
std_transfer_credit_school units_attempted numeric 5,2  √  null
std_term_course units_earned numeric 5,2
std_term_course units_for_progress numeric 5,2
std_transfer_credit_detail units_taken numeric 5,2  √  null
std_term_units cum_resident_terms numeric 6,3
std_term_units resident_terms_adjustment numeric 6,3
std_term_units resident_terms_credited numeric 6,3
std_term_units cum_academic_units_attempted numeric 8,3
std_term_units cum_academic_units_passed numeric 8,3 Does not include transfer credits.
std_term_units cum_units_attempted_in_gpa numeric 8,3
std_term_units cum_units_attempted_not_in_gpa numeric 8,3
std_term_units cum_units_audited numeric 8,3
std_term_units cum_units_in_progress_not_towards_gpa numeric 8,3
std_term_units cum_units_in_progress_towards_gpa numeric 8,3
std_term_units cum_units_passed_in_gpa numeric 8,3
std_term_units cum_units_passed_not_in_gpa numeric 8,3
std_term_units cum_units_total numeric 8,3
std_term_units cum_units_transferred numeric 8,3
std_term cumulative_gpa numeric 8,3
std_term_plan_gpa gpa numeric 8,3  √  null
std_term_subplan_gpa gpa numeric 8,3  √  null
std_term_units term_academic_units_attempted numeric 8,3
std_term_units term_academic_units_passed numeric 8,3
std_term term_gpa numeric 8,3
std_term_units term_units_attempted_in_gpa numeric 8,3
std_term_units term_units_attempted_not_in_gpa numeric 8,3 Includes non-academic (PD) courses.
std_term_units term_units_audited numeric 8,3
std_term_units term_units_in_progress_not_towards_gpa numeric 8,3
std_term_units term_units_in_progress_towards_gpa numeric 8,3
std_term_units term_units_passed_in_gpa numeric 8,3
std_term_units term_units_passed_not_in_gpa numeric 8,3
std_term_units term_units_total numeric 8,3
std_term_units term_units_transferred numeric 8,3
std_transfer_credit_school transfer_units_attempted_not_towards_gpa numeric 8,3  √  null
std_transfer_credit_school transfer_units_attempted_towards_gpa numeric 8,3  √  null
std_transfer_credit_school transfer_units_passed_not_toward_gpa numeric 8,3  √  null
std_transfer_credit_school transfer_units_passed_toward_gpa numeric 8,3  √  null
std_transfer_credit_school transferred_gpa numeric 8,3  √  null
std_term_units transferred_units_attempted_not_towards_gpa numeric 8,3
std_term_units transferred_units_attempted_towards_gpa numeric 8,3
std_term_units transferred_units_passed_in_gpa numeric 8,3
std_term_units transferred_units_passed_not_in_gpa numeric 8,3
std_transfer_credit_detail units_transferred numeric 8,3
std_transfer_credit_school units_transferred numeric 8,3  √  null
std_term_units cum_grade_points numeric 9,3
std_term_course grade_points numeric 9,3
std_term_units term_grade_points numeric 9,3
std_term_units transferred_grade_points numeric 9,3
std_transfer_credit_school transferred_grade_points numeric 9,3  √  null
cal_course_label career_code quest_career 2147483647
cal_course_label_history career_code quest_career 2147483647
off_course_section_complete career_code quest_career 2147483647  √  null
off_course_section_plus career_code quest_career 2147483647  √  null
pps_plan career_code quest_career 2147483647  √  null
pps_plan_history career_code quest_career 2147483647  √  null
pps_program career_code quest_career 2147483647
pps_program_history career_code quest_career 2147483647
std_degree career_code quest_career 2147483647
std_degree_plan career_code quest_career 2147483647
std_plan_history career_code quest_career 2147483647
std_program_history career_code quest_career 2147483647
std_program_milestone career_code quest_career 2147483647  √  null
std_program_plan_milestone career_code quest_career 2147483647  √  null
std_subplan_history career_code quest_career 2147483647
std_term career_code quest_career 2147483647
std_term_course_demand career_code quest_career 2147483647
std_term_plan_plus career_code quest_career 2147483647  √  null
std_transfer_credit_detail career_code quest_career 2147483647
std_transfer_credit_school career_code quest_career 2147483647
off_instruct_section section_combined_type quest_combined_type 2147483647  √  null
std_program_milestone milestone_complete quest_completion_code 2147483647
std_program_plan_milestone milestone_complete quest_completion_code 2147483647
std_term_course units_attempted_code quest_completion_code 2147483647
std_transfer_credit_detail units_attempted_code quest_completion_code 2147483647
cal_course course_add_consent quest_consent 2147483647
cal_course_history course_add_consent quest_consent 2147483647
off_course_section_complete course_add_consent quest_consent 2147483647  √  null
cal_course course_drop_consent quest_consent 2147483647
cal_course_history course_drop_consent quest_consent 2147483647
off_course_section_complete course_drop_consent quest_consent 2147483647  √  null
off_course_section section_add_consent quest_consent 2147483647
off_course_section_complete section_add_consent quest_consent 2147483647  √  null
off_course_section_plus section_add_consent quest_consent 2147483647  √  null
off_course_section section_drop_consent quest_consent 2147483647
off_course_section_complete section_drop_consent quest_consent 2147483647  √  null
off_course_section_plus section_drop_consent quest_consent 2147483647  √  null
off_course_section section_enrol_status quest_course_enrol_status 2147483647
off_course_section_complete section_enrol_status quest_course_enrol_status 2147483647  √  null
off_course_section_plus section_enrol_status quest_course_enrol_status 2147483647  √  null
cal_course course_id quest_course_id 2147483647
cal_course_history course_id quest_course_id 2147483647
cal_course_label course_id quest_course_id 2147483647
cal_course_label_history course_id quest_course_id 2147483647
cal_course_topic course_id quest_course_id 2147483647
cal_course_topic_history course_id quest_course_id 2147483647
off_association course_id quest_course_id 2147483647
off_course course_id quest_course_id 2147483647
off_course_as_of course_id quest_course_id 2147483647
off_course_section course_id quest_course_id 2147483647
off_course_section_complete course_id quest_course_id 2147483647  √  null
off_course_section_plus course_id quest_course_id 2147483647  √  null
std_term_course course_id quest_course_id 2147483647
std_term_section course_id quest_course_id 2147483647
std_degree degree_id quest_degree_id 2147483647
std_degree_honour degree_id quest_degree_id 2147483647
std_degree_plan degree_id quest_degree_id 2147483647
std_degree_subplan degree_id quest_degree_id 2147483647
std_plan_history degree_id quest_degree_id 2147483647  √  null
std_term_plan degree_id quest_degree_id 2147483647  √  null
std_term_plan_plus degree_id quest_degree_id 2147483647  √  null
std_term_course_demand instruction_mode quest_instruction_mode 2147483647  √  null
off_instruct_section instruction_mode_code quest_instruction_mode 2147483647
std_program_history approved_load quest_load 2147483647
std_term_program approved_load quest_load 2147483647
std_term_program_plus approved_load quest_load 2147483647  √  null
std_term_course_demand campus_optional quest_option 2147483647  √  null
std_term_course_demand instruction_mode_optional quest_option 2147483647  √  null
std_term registration_status quest_registration_status 2147483647  √  null
cal_course_label requisite_id quest_requisite_id 2147483647  √  null
cal_course_label_history requisite_id quest_requisite_id 2147483647  √  null
off_course_section_complete requisite_id quest_requisite_id 2147483647  √  null
off_course_section_plus requisite_id quest_requisite_id 2147483647  √  null
off_instruct_section section_status quest_section_status 2147483647  √  null The status of the section
off_association session_code quest_session 2147483647
off_course_section session_code quest_session 2147483647
off_course_section_complete session_code quest_session 2147483647  √  null
off_course_section_plus session_code quest_session 2147483647  √  null
off_instruct_section session_code quest_session 2147483647 The session of the section
std_student sex quest_sex 2147483647
std_term standing_status quest_standing_status 2147483647  √  null
pps_standing standing_status_code quest_standing_status 2147483647
std_term_section enrolment_status quest_student_enrol_status 2147483647
pps_subplan subplan_type quest_subplan_type 2147483647
pps_subplan_history subplan_type quest_subplan_type 2147483647
std_service_indicator active_term quest_term_id 2147483647  √  null
std_program_history admit_term_id quest_term_id 2147483647
std_term_program admit_term_id quest_term_id 2147483647
std_term_program_plus admit_term_id quest_term_id 2147483647  √  null
std_transfer_credit_detail articulation_term quest_term_id 2147483647
std_degree completion_term_id quest_term_id 2147483647
std_program_history completion_term_id quest_term_id 2147483647  √  null
std_term_program completion_term_id quest_term_id 2147483647  √  null
std_term_program_plus completion_term_id quest_term_id 2147483647  √  null
std_program_history expected_grad_term_id quest_term_id 2147483647  √  null
std_term_program expected_grad_term_id quest_term_id 2147483647  √  null
std_term_program_plus expected_grad_term_id quest_term_id 2147483647  √  null
pps_plan first_valid_term_id quest_term_id 2147483647  √  null
pps_plan_history first_valid_term_id quest_term_id 2147483647  √  null
pps_program first_valid_term_id quest_term_id 2147483647  √  null
pps_program_history first_valid_term_id quest_term_id 2147483647  √  null
pps_subplan first_valid_term_id quest_term_id 2147483647  √  null
pps_subplan_history first_valid_term_id quest_term_id 2147483647  √  null
std_term_plan_plus first_valid_term_id quest_term_id 2147483647  √  null
pps_plan last_admit_term_id quest_term_id 2147483647  √  null
pps_plan_history last_admit_term_id quest_term_id 2147483647  √  null
pps_subplan last_admit_term_id quest_term_id 2147483647  √  null
pps_subplan_history last_admit_term_id quest_term_id 2147483647  √  null
std_term_plan_plus last_admit_term_id quest_term_id 2147483647  √  null
std_plan_history requirement_term_id quest_term_id 2147483647  √  null
std_program_history requirement_term_id quest_term_id 2147483647  √  null
std_subplan_history requirement_term_id quest_term_id 2147483647
std_term_plan requirement_term_id quest_term_id 2147483647
std_term_plan_plus requirement_term_id quest_term_id 2147483647  √  null
std_term_program requirement_term_id quest_term_id 2147483647
std_term_program_plus requirement_term_id quest_term_id 2147483647  √  null
std_term_subplan requirement_term_id quest_term_id 2147483647
off_association term_id quest_term_id 2147483647
off_course term_id quest_term_id 2147483647
off_course_as_of term_id quest_term_id 2147483647
off_course_section term_id quest_term_id 2147483647
off_course_section_complete term_id quest_term_id 2147483647  √  null
off_course_section_note term_id quest_term_id 2147483647
off_course_section_plus term_id quest_term_id 2147483647  √  null
off_course_section_reserve term_id quest_term_id 2147483647
off_instruct_section term_id quest_term_id 2147483647
off_instruct_section_instructor term_id quest_term_id 2147483647
off_instruct_section_instructor_plus term_id quest_term_id 2147483647  √  null
off_instruct_section_meet term_id quest_term_id 2147483647
off_instruct_section_meet_plus term_id quest_term_id 2147483647  √  null
std_term term_id quest_term_id 2147483647
std_term_course term_id quest_term_id 2147483647
std_term_course_demand term_id quest_term_id 2147483647
std_term_plan term_id quest_term_id 2147483647
std_term_plan_gpa term_id quest_term_id 2147483647
std_term_plan_plus term_id quest_term_id 2147483647  √  null
std_term_program term_id quest_term_id 2147483647
std_term_program_plus term_id quest_term_id 2147483647  √  null
std_term_section term_id quest_term_id 2147483647
std_term_subplan term_id quest_term_id 2147483647
std_term_subplan_gpa term_id quest_term_id 2147483647
std_term_units term_id quest_term_id 2147483647
uw_term term_id quest_term_id 2147483647
std_student userid quest_userid 2147483647  √  null
off_instruct_section_instructor uw_id quest_uw_id 2147483647
std_address uw_id quest_uw_id 2147483647
std_degree uw_id quest_uw_id 2147483647
std_degree_honour uw_id quest_uw_id 2147483647
std_degree_plan uw_id quest_uw_id 2147483647
std_degree_subplan uw_id quest_uw_id 2147483647
std_name uw_id quest_uw_id 2147483647
std_name_preferred uw_id quest_uw_id 2147483647  √  null
std_name_primary uw_id quest_uw_id 2147483647  √  null
std_photo uw_id quest_uw_id 2147483647
std_plan_history uw_id quest_uw_id 2147483647
std_program_history uw_id quest_uw_id 2147483647
std_program_milestone uw_id quest_uw_id 2147483647
std_program_plan_milestone uw_id quest_uw_id 2147483647
std_service_indicator uw_id quest_uw_id 2147483647
std_student uw_id quest_uw_id 2147483647
std_subplan_history uw_id quest_uw_id 2147483647
std_term uw_id quest_uw_id 2147483647
std_term_course uw_id quest_uw_id 2147483647
std_term_course_demand uw_id quest_uw_id 2147483647
std_term_plan uw_id quest_uw_id 2147483647
std_term_plan_gpa uw_id quest_uw_id 2147483647
std_term_plan_plus uw_id quest_uw_id 2147483647  √  null
std_term_program uw_id quest_uw_id 2147483647
std_term_program_plus uw_id quest_uw_id 2147483647  √  null
std_term_section uw_id quest_uw_id 2147483647
std_term_subplan uw_id quest_uw_id 2147483647
std_term_subplan_gpa uw_id quest_uw_id 2147483647
std_term_units uw_id quest_uw_id 2147483647
std_transfer_credit_detail uw_id quest_uw_id 2147483647
std_transfer_credit_school uw_id quest_uw_id 2147483647
std_term withdraw_code quest_withdraw_code 2147483647
update_notification notification_id serial 10  √  nextval('_quest.update_notification_notification_id_seq'::regclass)
update_run run_id serial 10  √  nextval('_quest.update_run_run_id_seq'::regclass)
std_term actual_load text 2147483647
std_address address1 text 2147483647  √  null
std_address address2 text 2147483647  √  null
std_address address3 text 2147483647  √  null
std_address address4 text 2147483647  √  null
std_address address_type text 2147483647
std_term approved_load text 2147483647
off_course_section auto_enroll_1_section_code text 2147483647  √  null
off_course_section_complete auto_enroll_1_section_code text 2147483647  √  null
off_course_section_plus auto_enroll_1_section_code text 2147483647  √  null
off_course_section auto_enroll_2_section_code text 2147483647  √  null
off_course_section_complete auto_enroll_2_section_code text 2147483647  √  null
off_course_section_plus auto_enroll_2_section_code text 2147483647  √  null
std_term_course_demand campus text 2147483647  √  null
cal_course_label campus_code text 2147483647  √  null
cal_course_label_history campus_code text 2147483647  √  null
off_course_section_complete campus_code text 2147483647  √  null
off_course_section_plus campus_code text 2147483647  √  null
off_instruct_section campus_code text 2147483647
std_program_history campus_code text 2147483647
std_term_program campus_code text 2147483647
std_term_program_plus campus_code text 2147483647  √  null
uw_campus campus_code text 2147483647
uw_campus_history campus_code text 2147483647
uw_unit campus_code text 2147483647
uw_unit_history campus_code text 2147483647
uw_campus campus_description text 2147483647
uw_campus_history campus_description text 2147483647
uw_campus campus_short_description text 2147483647
uw_campus_history campus_short_description text 2147483647
cal_course_label catalog text 2147483647
cal_course_label_history catalog text 2147483647
off_course_section_complete catalog text 2147483647  √  null
off_course_section_plus catalog text 2147483647  √  null
std_address city text 2147483647  √  null
std_program_milestone comments text 2147483647  √  null
std_program_plan_milestone comments text 2147483647  √  null
std_transfer_credit_school comments text 2147483647  √  null
off_association component_code text 2147483647
off_course_section component_code text 2147483647
off_course_section_complete component_code text 2147483647  √  null
off_course_section_plus component_code text 2147483647  √  null
std_term coop_term_type_code text 2147483647  √  null
std_term coop_workterm_status text 2147483647  √  null
std_address country text 2147483647  √  null
uw_country country_code text 2147483647
uw_location country_code text 2147483647
uw_location_history country_code text 2147483647
uw_country country_name text 2147483647
uw_country country_short_code text 2147483647  √  null
uw_country country_short_name text 2147483647
cal_course course_description text 2147483647  √  null
cal_course_history course_description text 2147483647  √  null
off_course_section_complete course_description text 2147483647  √  null
std_term_course course_grade text 2147483647  √  null
std_transfer_credit_detail course_grade text 2147483647
cal_course course_short_title text 2147483647
cal_course_history course_short_title text 2147483647
off_course_section_complete course_short_title text 2147483647  √  null
cal_course course_title text 2147483647
cal_course_history course_title text 2147483647
off_course_section_complete course_title text 2147483647  √  null
pps_degree degree_code text 2147483647
pps_degree_history degree_code text 2147483647
pps_plan degree_code text 2147483647  √  null
pps_plan_history degree_code text 2147483647  √  null
std_degree degree_code text 2147483647
std_term_plan_plus degree_code text 2147483647  √  null
pps_degree degree_full_title text 2147483647
pps_degree_history degree_full_title text 2147483647
pps_degree degree_level text 2147483647  √  null
pps_degree_history degree_level text 2147483647  √  null
pps_degree degree_short_title text 2147483647
pps_degree_history degree_short_title text 2147483647
pps_degree degree_title text 2147483647
pps_degree_history degree_title text 2147483647
pps_service_indicator_impact description text 2147483647  √  null
pps_service_indicator_reason description text 2147483647  √  null
std_student email text 2147483647  √  null
std_transfer_credit_detail external_catalog text 2147483647  √  null
std_transfer_credit_detail external_descr text 2147483647  √  null
std_transfer_credit_detail external_grade text 2147483647  √  null
std_transfer_credit_detail external_subject text 2147483647  √  null
std_transfer_credit_detail external_term text 2147483647  √  null
off_instruct_section_meet facility_id text 2147483647  √  null
off_instruct_section_meet_plus facility_id text 2147483647  √  null
uw_room facility_id text 2147483647
off_instruct_section_meet_plus facility_type_code text 2147483647  √  null
uw_room facility_type_code text 2147483647
std_name first_name text 2147483647  √  null
std_name_preferred first_name text 2147483647  √  null
std_name_primary first_name text 2147483647  √  null
std_term form_of_study text 2147483647
std_program_milestone formal_description text 2147483647
std_program_plan_milestone formal_description text 2147483647
off_instruct_section_instructor_plus givennames text 2147483647  √  null
std_term_plan_gpa gpa_type_code text 2147483647
std_term_subplan_gpa gpa_type_code text 2147483647
off_association grade_basis_code text 2147483647
std_term_course grade_category text 2147483647  √  null
std_transfer_credit_detail grade_category text 2147483647
std_term_course grading_basis text 2147483647
std_transfer_credit_detail grading_basis text 2147483647
cal_course_label group_code text 2147483647
cal_course_label_history group_code text 2147483647
off_course_section_complete group_code text 2147483647  √  null
off_course_section_plus group_code text 2147483647  √  null
pps_program group_code text 2147483647
pps_program_history group_code text 2147483647
uw_group group_code text 2147483647
uw_group_history group_code text 2147483647
uw_unit group_code text 2147483647  √  null
uw_unit_history group_code text 2147483647  √  null
uw_group group_quest_name text 2147483647
uw_group_history group_quest_name text 2147483647
std_degree_honour honours_code text 2147483647
off_instruct_section_instructor instructor_role_code text 2147483647
off_instruct_section_instructor_plus instructor_role_code text 2147483647  √  null
std_name last_name text 2147483647  √  null
std_name_preferred last_name text 2147483647  √  null
std_name_primary last_name text 2147483647  √  null
pps_program level_load_rule_code text 2147483647
pps_program_history level_load_rule_code text 2147483647
std_term_course_demand location text 2147483647  √  null
off_instruct_section location_code text 2147483647
off_instruct_section_meet_plus location_code text 2147483647  √  null
uw_campus location_code text 2147483647
uw_campus_history location_code text 2147483647
uw_location location_code text 2147483647
uw_location_history location_code text 2147483647
uw_room location_code text 2147483647
uw_location location_quest_description text 2147483647
uw_location_history location_quest_description text 2147483647
std_name middle_name text 2147483647  √  null
std_name_preferred middle_name text 2147483647  √  null
std_name_primary middle_name text 2147483647  √  null
std_program_milestone milestone_code text 2147483647
std_program_plan_milestone milestone_code text 2147483647
std_program_milestone milestone_title text 2147483647  √  null
std_program_plan_milestone milestone_title text 2147483647  √  null
std_transfer_credit_school model_status text 2147483647
std_name name_title text 2147483647  √  null
std_name_preferred name_title text 2147483647  √  null
std_name_primary name_title text 2147483647  √  null
std_name name_type_code text 2147483647
std_name_preferred name_type_code text 2147483647  √  null
std_name_primary name_type_code text 2147483647  √  null
off_default_note note_description text 2147483647
off_default_note_history note_description text 2147483647
off_course_section_note note_text text 2147483647  √  null
off_default_note note_text text 2147483647
off_default_note_history note_text text 2147483647
pps_plan plan_code text 2147483647
pps_plan_history plan_code text 2147483647
pps_subplan plan_code text 2147483647
pps_subplan_history plan_code text 2147483647
std_degree_plan plan_code text 2147483647
std_degree_subplan plan_code text 2147483647
std_plan_history plan_code text 2147483647
std_program_plan_milestone plan_code text 2147483647
std_subplan_history plan_code text 2147483647
std_term_plan plan_code text 2147483647
std_term_plan_gpa plan_code text 2147483647
std_term_plan_plus plan_code text 2147483647  √  null
std_term_subplan plan_code text 2147483647
std_term_subplan_gpa plan_code text 2147483647
std_transfer_credit_school plan_code text 2147483647
pps_plan plan_comment text 2147483647  √  null
pps_plan_history plan_comment text 2147483647  √  null
std_term_plan_plus plan_comment text 2147483647  √  null
pps_plan plan_diploma_description text 2147483647  √  null
pps_plan_history plan_diploma_description text 2147483647  √  null
std_term_plan_plus plan_diploma_description text 2147483647  √  null
pps_plan plan_short_title text 2147483647
pps_plan_history plan_short_title text 2147483647
std_term_plan_plus plan_short_title text 2147483647  √  null
pps_plan plan_title text 2147483647
pps_plan_history plan_title text 2147483647
std_term_plan_plus plan_title text 2147483647  √  null
pps_plan plan_transcript_description text 2147483647
pps_plan_history plan_transcript_description text 2147483647
std_term_plan_plus plan_transcript_description text 2147483647  √  null
pps_plan plan_type_code text 2147483647
pps_plan_history plan_type_code text 2147483647
std_term_plan_plus plan_type_code text 2147483647  √  null
std_address postal text 2147483647  √  null
off_association primary_component_code text 2147483647  √  null
std_term primary_program_code text 2147483647
update_notification process_code text 2147483647 The Quest process code of the notification
update_process process_code text 2147483647
update_run_notification process_code text 2147483647
update_process process_description text 2147483647
std_program_history program_action text 2147483647
std_term_program program_action text 2147483647
std_term_program_plus program_action text 2147483647  √  null
pps_plan program_code text 2147483647  √  null
pps_plan_history program_code text 2147483647  √  null
pps_program program_code text 2147483647
pps_program_history program_code text 2147483647
std_program_history program_code text 2147483647
std_program_milestone program_code text 2147483647
std_program_plan_milestone program_code text 2147483647
std_term_plan_plus program_code text 2147483647  √  null
std_term_program program_code text 2147483647
std_term_program_plus program_code text 2147483647  √  null
std_transfer_credit_school program_code text 2147483647
std_program_history program_reason text 2147483647  √  null
std_term_program program_reason text 2147483647  √  null
std_term_program_plus program_reason text 2147483647  √  null
pps_program program_short_title text 2147483647
pps_program_history program_short_title text 2147483647
std_term_program_plus program_short_title text 2147483647  √  null
std_program_history program_status text 2147483647
std_term_program program_status text 2147483647
std_term_program_plus program_status text 2147483647  √  null
pps_program program_title text 2147483647
pps_program_history program_title text 2147483647
std_term_program_plus program_title text 2147483647  √  null
std_term projected_level text 2147483647  √  null
std_address prov text 2147483647  √  null
pps_service_indicator_reason reason text 2147483647
off_association requirement_designation text 2147483647  √  null
std_term_course requirement_designation text 2147483647  √  null
std_transfer_credit_detail requirement_designation text 2147483647  √  null
std_term_course requirement_designation_grade text 2147483647  √  null
cal_requisite requisite_brief_description text 2147483647
cal_requisite_history requisite_brief_description text 2147483647
cal_requisite requisite_description text 2147483647
cal_requisite_history requisite_description text 2147483647
cal_requisite requisite_short_description text 2147483647
cal_requisite_history requisite_short_description text 2147483647
off_instruct_section_meet_plus room_code text 2147483647  √  null
uw_room room_code text 2147483647
off_instruct_section_meet_plus room_description text 2147483647  √  null
uw_room room_description text 2147483647
std_transfer_credit_school school_type text 2147483647
off_course_section section_code text 2147483647
off_course_section_complete section_code text 2147483647  √  null
off_course_section_plus section_code text 2147483647  √  null
pps_service_indicator_impact service_impact_code text 2147483647
pps_service_indicator service_indicator_code text 2147483647
pps_service_indicator_impact service_indicator_code text 2147483647
pps_service_indicator_reason service_indicator_code text 2147483647
std_service_indicator service_indicator_code text 2147483647
pps_service_indicator_reason service_indicator_reason text 2147483647
std_service_indicator service_indicator_reason text 2147483647
std_program_milestone short_description text 2147483647
std_program_plan_milestone short_description text 2147483647
pps_service_indicator_reason short_reason text 2147483647
pps_service_indicator short_title text 2147483647
std_transfer_credit_school source_school_name text 2147483647
pps_standing standing_brief_description text 2147483647
pps_standing standing_code text 2147483647
std_term standing_code text 2147483647  √  null
pps_standing standing_description text 2147483647
std_term standing_program_code text 2147483647  √  null
pps_standing standing_short_description text 2147483647
std_term study_agreement text 2147483647  √  null
cal_course_label subject_code text 2147483647
cal_course_label_history subject_code text 2147483647
cal_subject subject_code text 2147483647
cal_subject_history subject_code text 2147483647
off_course_section_complete subject_code text 2147483647  √  null
off_course_section_plus subject_code text 2147483647  √  null
cal_subject subject_description text 2147483647
cal_subject_history subject_description text 2147483647
cal_subject subject_short_description text 2147483647
cal_subject_history subject_short_description text 2147483647
pps_subplan subplan_code text 2147483647
pps_subplan_history subplan_code text 2147483647
std_degree_subplan subplan_code text 2147483647
std_subplan_history subplan_code text 2147483647
std_term_subplan subplan_code text 2147483647
std_term_subplan_gpa subplan_code text 2147483647
pps_subplan subplan_diploma_description text 2147483647  √  null
pps_subplan_history subplan_diploma_description text 2147483647  √  null
pps_subplan subplan_short_title text 2147483647
pps_subplan_history subplan_short_title text 2147483647
pps_subplan subplan_title text 2147483647
pps_subplan_history subplan_title text 2147483647
pps_subplan subplan_transcript_description text 2147483647
pps_subplan_history subplan_transcript_description text 2147483647
off_instruct_section_instructor_plus surname text 2147483647  √  null
pps_service_indicator_impact term_category text 2147483647  √  null
pps_service_indicator title text 2147483647
cal_course_topic topic_short_title text 2147483647
cal_course_topic_history topic_short_title text 2147483647
off_course_section_complete topic_short_title text 2147483647  √  null
off_course_section_plus topic_short_title text 2147483647  √  null
cal_course_topic topic_title text 2147483647
cal_course_topic_history topic_title text 2147483647
off_course_section_complete topic_title text 2147483647  √  null
off_course_section_plus topic_title text 2147483647  √  null
std_term_course transcript_note text 2147483647  √  null
std_term transcript_text text 2147483647  √  null
cal_course_label unit_code text 2147483647
cal_course_label_history unit_code text 2147483647
cal_subject unit_code text 2147483647
cal_subject_history unit_code text 2147483647
off_course_section_complete unit_code text 2147483647  √  null
off_course_section_plus unit_code text 2147483647  √  null
off_instruct_section_meet_plus unit_code text 2147483647  √  null
pps_plan unit_code text 2147483647
pps_plan_history unit_code text 2147483647
pps_program unit_code text 2147483647
pps_program_history unit_code text 2147483647
std_term_plan_plus unit_code text 2147483647  √  null
uw_room unit_code text 2147483647  √  null
uw_unit unit_code text 2147483647
uw_unit_history unit_code text 2147483647
uw_unit unit_description text 2147483647
uw_unit_history unit_description text 2147483647
uw_unit unit_full_description text 2147483647
uw_unit_history unit_full_description text 2147483647
uw_unit unit_short_description text 2147483647
uw_unit_history unit_short_description text 2147483647
off_instruct_section_instructor userid text 2147483647  √  null
off_instruct_section_instructor_plus userid text 2147483647  √  null
std_term withdraw_reason text 2147483647  √  null
std_student wlu_id text 2147483647  √  null
off_instruct_section_meet meet_times timerange 2147483647
off_instruct_section_meet_plus meet_times timerange 2147483647  √  null
std_term_course_demand demand_as_of timestamp 29,6  √  null
std_term_section last_drop timestamp 29,6  √  null
std_term_section last_enrolment_change timestamp 29,6  √  null
std_term_section last_update timestamp 29,6  √  null
update_notification notification_time timestamp 29,6 now() When the notification was recorded
update_run run_created timestamp 29,6 now() When this run was created
update_run run_loaded timestamp 29,6  √  null When the data update process for this run finished
update_run run_ready timestamp 29,6  √  null When the final notification for this run was received
std_service_indicator service_indicator_as_of timestamp 29,6