SchemaSpy Analysis of odyssey_test._quest - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Wed Feb 19 10:30 EST 2014 |
| ||||||
|
odyssey_test._quest contains 793 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|
std_term_program_plus | action_date | date | 13 | √ | null | ||
std_service_indicator | active_term | quest_term_id | 2147483647 | √ | null | ||
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_term_program_plus | admit_term_id | quest_term_id | 2147483647 | √ | null | ||
std_term_course_demand | apply_ng_grade | bool | 1 | √ | null | ||
std_term_program_plus | approved_load | quest_load | 2147483647 | √ | null | ||
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_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_student | birthdate | date | 13 | √ | null | ||
off_instruct_section_meet_plus | building_id | int4 | 10 | √ | 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 | ||
std_term_program_plus | campus_code | text | 2147483647 | √ | null | ||
std_term_course_demand | campus_optional | quest_option | 2147483647 | √ | null | ||
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 | ||
std_program_milestone | career_code | quest_career | 2147483647 | √ | null | ||
std_program_plan_milestone | career_code | quest_career | 2147483647 | √ | null | ||
std_term_plan_plus | career_code | quest_career | 2147483647 | √ | null | ||
off_course_section_complete | catalog | text | 2147483647 | √ | null | ||
off_course_section_plus | catalog | text | 2147483647 | √ | null | ||
std_address | city | text | 2147483647 | √ | null | ||
off_course_section_complete | class_id | int4 | 10 | √ | null | ||
off_course_section_plus | class_id | int4 | 10 | √ | null | ||
std_program_milestone | comments | text | 2147483647 | √ | null | ||
std_program_plan_milestone | comments | text | 2147483647 | √ | null | ||
std_transfer_credit_school | comments | text | 2147483647 | √ | null | ||
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 | ||
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_short_code | text | 2147483647 | √ | null | ||
off_course_section_complete | course_active | bool | 1 | √ | null | ||
off_course_section_complete | course_add_consent | quest_consent | 2147483647 | √ | null | ||
off_course_section_complete | course_ap_units | numeric | 5,2 | √ | null | ||
off_course_section_complete | course_as_of | date | 13 | √ | null | ||
off_course_section_plus | course_as_of | date | 13 | √ | null | ||
cal_course | course_description | text | 2147483647 | √ | null | ||
cal_course_history | course_description | text | 2147483647 | √ | null | ||
off_course_section_complete | course_description | text | 2147483647 | √ | null | ||
off_course_section_complete | course_drop_consent | quest_consent | 2147483647 | √ | null | ||
std_term_course | course_grade | text | 2147483647 | √ | null | ||
off_course_section_complete | course_id | quest_course_id | 2147483647 | √ | null | ||
off_course_section_plus | course_id | quest_course_id | 2147483647 | √ | null | ||
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_complete | course_section_enrol_total | int4 | 10 | √ | null | ||
off_course_section_plus | course_section_enrol_total | int4 | 10 | √ | null | ||
off_course_section_complete | course_section_room_capacity | int4 | 10 | √ | null | ||
off_course_section_plus | course_section_room_capacity | int4 | 10 | √ | null | ||
off_course_section_complete | course_short_title | text | 2147483647 | √ | null | ||
off_course_section_complete | course_take_units | numeric | 5,2 | √ | null | ||
off_course_section_complete | course_title | text | 2147483647 | √ | null | ||
std_term_program_plus | data_from_adm_appl | bool | 1 | √ | 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_plan | degree_code | text | 2147483647 | √ | null | ||
pps_plan_history | degree_code | text | 2147483647 | √ | null | ||
std_term_plan_plus | degree_code | text | 2147483647 | √ | null | ||
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 | ||
pps_degree | degree_level | text | 2147483647 | √ | null | ||
pps_degree_history | degree_level | text | 2147483647 | √ | null | ||
std_term_course_demand | demand_as_of | timestamp | 29,6 | √ | null | ||
pps_service_indicator_impact | description | text | 2147483647 | √ | null | ||
pps_service_indicator_reason | description | text | 2147483647 | √ | null | ||
std_term_section | drop_date | date | 13 | √ | null | ||
std_student | text | 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 | ||
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_plus | facility_active | bool | 1 | √ | null | ||
off_instruct_section_meet_plus | facility_as_of | date | 13 | √ | null | ||
off_instruct_section_meet | facility_id | text | 2147483647 | √ | null | ||
off_instruct_section_meet_plus | facility_id | text | 2147483647 | √ | null | ||
off_instruct_section_meet_plus | facility_partition | int4 | 10 | √ | null | ||
uw_room | facility_partition | int4 | 10 | √ | null | ||
off_instruct_section_meet_plus | facility_type_code | text | 2147483647 | √ | null | ||
std_name | first_name | text | 2147483647 | √ | null | ||
std_name_preferred | first_name | text | 2147483647 | √ | null | ||
std_name_primary | first_name | text | 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 | ||
off_instruct_section_instructor_plus | givennames | text | 2147483647 | √ | null | ||
std_term_plan_gpa | gpa | numeric | 8,3 | √ | null | ||
std_term_subplan_gpa | gpa | numeric | 8,3 | √ | null | ||
std_term_plan_gpa | gpa_date | date | 13 | √ | null | ||
std_term_subplan_gpa | gpa_date | date | 13 | √ | null | ||
std_term_course | grade_category | text | 2147483647 | √ | null | ||
std_term_course | grade_submission_date | date | 13 | √ | null | ||
off_course_section_complete | group_code | text | 2147483647 | √ | null | ||
off_course_section_plus | group_code | text | 2147483647 | √ | null | ||
uw_unit | group_code | text | 2147483647 | √ | null | ||
uw_unit_history | group_code | text | 2147483647 | √ | null | ||
std_term_course_demand | instruction_mode | quest_instruction_mode | 2147483647 | √ | null | ||
std_term_course_demand | instruction_mode_optional | quest_option | 2147483647 | √ | null | ||
off_instruct_section_instructor_plus | instructor_role_code | text | 2147483647 | √ | null | ||
off_course_section_complete | label_schedule_print | bool | 1 | √ | null | ||
off_course_section_plus | label_schedule_print | bool | 1 | √ | null | ||
off_course_section_complete | label_seq | int4 | 10 | √ | null | ||
off_course_section_plus | label_seq | int4 | 10 | √ | 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_term | last_date_attended | date | 13 | √ | null | ||
std_term_section | last_drop | timestamp | 29,6 | √ | null | ||
std_term_section | last_enrolment_change | timestamp | 29,6 | √ | null | ||
std_name | last_name | text | 2147483647 | √ | null | ||
std_name_preferred | last_name | text | 2147483647 | √ | null | ||
std_name_primary | last_name | text | 2147483647 | √ | null | ||
std_term_section | last_update | timestamp | 29,6 | √ | null | ||
std_term_course_demand | location | text | 2147483647 | √ | null | ||
off_instruct_section_meet_plus | location_code | text | 2147483647 | √ | null | ||
off_instruct_section_meet_plus | meet_dates | daterange | 2147483647 | √ | null | ||
off_instruct_section_meet_plus | meet_days | bit | 7 | √ | null | ||
off_instruct_section_meet_plus | meet_id | int4 | 10 | √ | null | ||
off_instruct_section_meet_plus | meet_times | timerange | 2147483647 | √ | null | ||
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_title | text | 2147483647 | √ | null | ||
std_program_plan_milestone | milestone_title | text | 2147483647 | √ | null | ||
std_name_preferred | name_as_of | date | 13 | √ | null | ||
std_name_primary | name_as_of | date | 13 | √ | null | ||
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_preferred | name_type_code | text | 2147483647 | √ | null | ||
std_name_primary | name_type_code | text | 2147483647 | √ | null | ||
off_course_section_note | note_id | int4 | 10 | √ | null | ||
off_course_section_note | note_text | text | 2147483647 | √ | null | ||
std_term_section | permission_number | int4 | 10 | √ | null | ||
std_term_plan_plus | plan_active | bool | 1 | √ | null | ||
std_term_plan_plus | plan_as_of | date | 13 | √ | null | ||
std_term_plan_plus | plan_code | text | 2147483647 | √ | null | ||
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 | ||
std_term_plan_plus | plan_position | int4 | 10 | √ | null | ||
std_term_plan_plus | plan_short_title | text | 2147483647 | √ | null | ||
std_term_plan_plus | plan_title | text | 2147483647 | √ | null | ||
std_term_plan_plus | plan_transcript_description | text | 2147483647 | √ | null | ||
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_course_demand | priority | int4 | 10 | √ | null | ||
std_term_program_plus | program_action | text | 2147483647 | √ | null | ||
std_term_program_plus | program_as_of | date | 13 | √ | null | ||
pps_plan | program_code | text | 2147483647 | √ | null | ||
pps_plan_history | program_code | text | 2147483647 | √ | null | ||
std_term_plan_plus | program_code | text | 2147483647 | √ | null | ||
std_term_program_plus | program_code | text | 2147483647 | √ | null | ||
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 | ||
std_term_program_plus | program_sequence | int4 | 10 | √ | null | ||
std_term_program_plus | program_short_title | text | 2147483647 | √ | null | ||
std_term_program_plus | program_status | text | 2147483647 | √ | null | ||
std_term_program_plus | program_title | text | 2147483647 | √ | null | ||
std_term | projected_level | text | 2147483647 | √ | null | ||
std_address | prov | text | 2147483647 | √ | null | ||
std_term | registration_status | quest_registration_status | 2147483647 | √ | null | ||
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 | ||
std_plan_history | requirement_term_id | quest_term_id | 2147483647 | √ | null | ||
std_program_history | requirement_term_id | quest_term_id | 2147483647 | √ | null | ||
std_term_plan_plus | requirement_term_id | quest_term_id | 2147483647 | √ | null | ||
std_term_program_plus | requirement_term_id | quest_term_id | 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 | ||
std_term_section | reserve_id | int4 | 10 | √ | null | ||
off_instruct_section_meet_plus | room_capacity | int4 | 10 | √ | null | ||
off_instruct_section_meet_plus | room_code | text | 2147483647 | √ | null | ||
off_instruct_section_meet_plus | room_description | text | 2147483647 | √ | null | ||
update_notification | run_id | int4 | 10 | √ | null | The run_id, if any, this notification contributes to making ready | |
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 | |
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_complete | section_code | text | 2147483647 | √ | null | ||
off_course_section_plus | section_code | text | 2147483647 | √ | null | ||
off_instruct_section | section_combined_type | quest_combined_type | 2147483647 | √ | null | ||
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_complete | section_enrol_status | quest_course_enrol_status | 2147483647 | √ | null | ||
off_course_section_plus | section_enrol_status | quest_course_enrol_status | 2147483647 | √ | null | ||
off_course_section_complete | section_id | int4 | 10 | √ | null | ||
off_course_section_plus | section_id | int4 | 10 | √ | null | ||
off_instruct_section_instructor_plus | section_id | int4 | 10 | √ | null | ||
off_instruct_section_meet_plus | section_id | int4 | 10 | √ | null | ||
off_course_section_note | section_note_id | int4 | 10 | √ | null | ||
off_course_section_complete | section_schedule_print | bool | 1 | √ | null | ||
off_course_section_plus | section_schedule_print | bool | 1 | √ | null | ||
off_instruct_section | section_status | quest_section_status | 2147483647 | √ | null | The status of the section | |
off_course_section_complete | session_code | quest_session | 2147483647 | √ | null | ||
off_course_section_plus | session_code | quest_session | 2147483647 | √ | null | ||
std_term | standing_action_date | date | 13 | √ | null | ||
std_term | standing_code | text | 2147483647 | √ | null | ||
std_term | standing_program_code | text | 2147483647 | √ | null | ||
std_term | standing_status | quest_standing_status | 2147483647 | √ | null | ||
std_term | study_agreement | text | 2147483647 | √ | null | ||
off_course_section_complete | subject_code | text | 2147483647 | √ | null | ||
off_course_section_plus | subject_code | text | 2147483647 | √ | null | ||
pps_subplan | subplan_diploma_description | text | 2147483647 | √ | null | ||
pps_subplan_history | subplan_diploma_description | text | 2147483647 | √ | null | ||
off_instruct_section_instructor_plus | surname | text | 2147483647 | √ | null | ||
pps_service_indicator_impact | term_category | text | 2147483647 | √ | null | ||
uw_term | term_exam_dates | daterange | 2147483647 | √ | null | ||
off_course_section_complete | term_id | quest_term_id | 2147483647 | √ | null | ||
off_course_section_plus | term_id | quest_term_id | 2147483647 | √ | null | ||
off_instruct_section_instructor_plus | term_id | quest_term_id | 2147483647 | √ | null | ||
off_instruct_section_meet_plus | term_id | quest_term_id | 2147483647 | √ | null | ||
std_term_plan_plus | term_id | quest_term_id | 2147483647 | √ | null | ||
std_term_program_plus | term_id | quest_term_id | 2147483647 | √ | null | ||
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 | ||
off_course_section_complete | topic_short_title | text | 2147483647 | √ | null | ||
off_course_section_plus | topic_short_title | text | 2147483647 | √ | null | ||
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 | ||
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_transfer_credit_school | transferred_grade_points | numeric | 9,3 | √ | null | ||
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 | ||
std_term_plan_plus | unit_code | text | 2147483647 | √ | null | ||
uw_room | unit_code | text | 2147483647 | √ | null | ||
std_transfer_credit_school | units_attempted | numeric | 5,2 | √ | null | ||
std_transfer_credit_detail | units_taken | numeric | 5,2 | √ | null | ||
std_transfer_credit_school | units_transferred | numeric | 8,3 | √ | null | ||
off_instruct_section_instructor | userid | text | 2147483647 | √ | null | ||
off_instruct_section_instructor_plus | userid | text | 2147483647 | √ | null | ||
std_student | userid | quest_userid | 2147483647 | √ | null | ||
std_name_preferred | uw_id | quest_uw_id | 2147483647 | √ | null | ||
std_name_primary | uw_id | quest_uw_id | 2147483647 | √ | null | ||
std_term_plan_plus | uw_id | quest_uw_id | 2147483647 | √ | null | ||
std_term_program_plus | uw_id | quest_uw_id | 2147483647 | √ | null | ||
std_term_course | valid_attempt | bool | 1 | √ | null | ||
std_term | withdraw_date | date | 13 | √ | null | ||
std_term | withdraw_reason | text | 2147483647 | √ | null | ||
std_student | wlu_id | text | 2147483647 | √ | null | ||
std_program_history | action_date | date | 13 | ||||
std_term_program | action_date | date | 13 | ||||
std_service_indicator | active_date | date | 13 | ||||
std_term | actual_load | text | 2147483647 | ||||
std_term_section | add_date | date | 13 | ||||
std_address | address_type | text | 2147483647 | ||||
std_program_history | admit_term_id | quest_term_id | 2147483647 | ||||
std_term_program | admit_term_id | quest_term_id | 2147483647 | ||||
std_program_history | approved_load | quest_load | 2147483647 | ||||
std_term | approved_load | text | 2147483647 | ||||
std_term_program | approved_load | quest_load | 2147483647 | ||||
std_transfer_credit_detail | articulation_term | quest_term_id | 2147483647 | ||||
off_association | association_id | int4 | 10 | ||||
uw_room | building_id | int4 | 10 | ||||
uw_campus | campus_active | bool | 1 | ||||
uw_campus_history | campus_active | bool | 1 | ||||
uw_campus | campus_as_of | date | 13 | ||||
uw_campus_history | campus_as_of | date | 13 | ||||
off_instruct_section | campus_code | text | 2147483647 | ||||
std_program_history | campus_code | text | 2147483647 | ||||
std_term_program | campus_code | text | 2147483647 | ||||
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 | career_code | quest_career | 2147483647 | ||||
cal_course_label_history | career_code | quest_career | 2147483647 | ||||
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_subplan_history | career_code | quest_career | 2147483647 | ||||
std_term | career_code | quest_career | 2147483647 | ||||
std_term_course_demand | career_code | quest_career | 2147483647 | ||||
std_transfer_credit_detail | career_code | quest_career | 2147483647 | ||||
std_transfer_credit_school | career_code | quest_career | 2147483647 | ||||
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 | ||||
cal_course_label | catalog | text | 2147483647 | ||||
cal_course_label_history | catalog | text | 2147483647 | ||||
off_course | class_id | int4 | 10 | ||||
off_course_section | class_id | int4 | 10 | ||||
off_course_section_note | class_id | int4 | 10 | ||||
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_degree | completion_term_id | quest_term_id | 2147483647 | ||||
off_association | component_code | text | 2147483647 | ||||
off_course_section | component_code | text | 2147483647 | ||||
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_name | text | 2147483647 | ||||
cal_course | course_active | bool | 1 | ||||
cal_course_history | course_active | bool | 1 | ||||
cal_course | course_add_consent | quest_consent | 2147483647 | ||||
cal_course_history | course_add_consent | quest_consent | 2147483647 | ||||
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 | ||||
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 | ||||
cal_course | course_drop_consent | quest_consent | 2147483647 | ||||
cal_course_history | course_drop_consent | quest_consent | 2147483647 | ||||
std_transfer_credit_detail | course_grade | text | 2147483647 | ||||
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 | ||||
std_term_course | course_id | quest_course_id | 2147483647 | ||||
std_term_section | course_id | quest_course_id | 2147483647 | ||||
std_transfer_credit_detail | course_id | int4 | 10 | ||||
off_course_section | course_section_enrol_limit | int4 | 10 | ||||
off_course_section | course_section_enrol_total | int4 | 10 | ||||
off_course_section | course_section_room_capacity | int4 | 10 | ||||
cal_course | course_short_title | text | 2147483647 | ||||
cal_course_history | course_short_title | text | 2147483647 | ||||
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 | ||||
cal_course | course_title | text | 2147483647 | ||||
cal_course_history | course_title | text | 2147483647 | ||||
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_grade_points | numeric | 9,3 | ||||
std_term_units | cum_resident_terms | numeric | 6,3 | ||||
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_program_history | data_from_adm_appl | bool | 1 | ||||
std_term_program | data_from_adm_appl | bool | 1 | ||||
pps_degree | degree_active | bool | 1 | ||||
pps_degree_history | degree_active | bool | 1 | ||||
pps_degree | degree_as_of | date | 13 | ||||
pps_degree_history | degree_as_of | date | 13 | ||||
pps_degree | degree_code | text | 2147483647 | ||||
pps_degree_history | degree_code | text | 2147483647 | ||||
std_degree | degree_code | text | 2147483647 | ||||
std_degree | degree_conferral_date | date | 13 | ||||
pps_degree | degree_full_title | text | 2147483647 | ||||
pps_degree_history | degree_full_title | text | 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 | ||||
pps_degree | degree_internal | bool | 1 | ||||
pps_degree_history | degree_internal | bool | 1 | ||||
std_degree | degree_revoked | bool | 1 | ||||
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_degree | degree_years | int4 | 10 | ||||
pps_degree_history | degree_years | int4 | 10 | ||||
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 | ||||
std_term_section | enrolment_status | quest_student_enrol_status | 2147483647 | ||||
uw_room | facility_active | bool | 1 | ||||
uw_room | facility_as_of | date | 13 | ||||
uw_room | facility_id | text | 2147483647 | ||||
uw_room | facility_type_code | text | 2147483647 | ||||
std_term | form_of_study | text | 2147483647 | ||||
std_program_milestone | formal_description | text | 2147483647 | ||||
std_program_plan_milestone | formal_description | text | 2147483647 | ||||
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_transfer_credit_detail | grade_category | text | 2147483647 | ||||
std_term_course | grade_points | numeric | 9,3 | ||||
std_term_course | grading_basis | text | 2147483647 | ||||
std_transfer_credit_detail | grading_basis | text | 2147483647 | ||||
uw_group | group_active | bool | 1 | ||||
uw_group_history | group_active | bool | 1 | ||||
uw_group | group_as_of | date | 13 | ||||
uw_group_history | group_as_of | date | 13 | ||||
cal_course_label | group_code | text | 2147483647 | ||||
cal_course_label_history | group_code | text | 2147483647 | ||||
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_group | group_quest_name | text | 2147483647 | ||||
uw_group_history | group_quest_name | text | 2147483647 | ||||
std_degree_honour | honours_award_date | date | 13 | ||||
std_degree_honour | honours_code | text | 2147483647 | ||||
std_degree_honour | honours_id | int4 | 10 | ||||
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 | ||||
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 | ||||
off_instruct_section | instruction_mode_code | quest_instruction_mode | 2147483647 | ||||
off_instruct_section_instructor | instructor_role_code | text | 2147483647 | ||||
cal_course_label | label_schedule_print | bool | 1 | ||||
cal_course_label_history | label_schedule_print | bool | 1 | ||||
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 | ||||
std_term_course | label_seq | int4 | 10 | ||||
std_transfer_credit_detail | label_seq | int4 | 10 | ||||
pps_program | level_load_rule_code | text | 2147483647 | ||||
pps_program_history | level_load_rule_code | text | 2147483647 | ||||
uw_location | location_active | bool | 1 | ||||
uw_location_history | location_active | bool | 1 | ||||
uw_location | location_as_of | date | 13 | ||||
uw_location_history | location_as_of | date | 13 | ||||
off_instruct_section | location_code | text | 2147483647 | ||||
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_term_units | max_nogpa_unit_load | numeric | 5,2 | ||||
std_term_units | max_total_unit_load | numeric | 5,2 | ||||
off_instruct_section_meet | meet_dates | daterange | 2147483647 | ||||
off_instruct_section_meet | meet_days | bit | 7 | ||||
off_instruct_section_meet | meet_id | int4 | 10 | ||||
off_instruct_section_meet | meet_times | timerange | 2147483647 | ||||
std_program_milestone | milestone_code | text | 2147483647 | ||||
std_program_plan_milestone | milestone_code | text | 2147483647 | ||||
std_program_milestone | milestone_complete | quest_completion_code | 2147483647 | ||||
std_program_plan_milestone | milestone_complete | quest_completion_code | 2147483647 | ||||
std_program_milestone | milestone_id | int4 | 10 | ||||
std_program_plan_milestone | milestone_id | int4 | 10 | ||||
std_transfer_credit_school | model_status | text | 2147483647 | ||||
std_name | name_as_of | date | 13 | ||||
std_name | name_type_code | text | 2147483647 | ||||
off_default_note | note_active | bool | 1 | ||||
off_default_note_history | note_active | bool | 1 | ||||
off_default_note | note_as_of | date | 13 | ||||
off_default_note_history | note_as_of | date | 13 | ||||
off_default_note | note_description | text | 2147483647 | ||||
off_default_note_history | note_description | text | 2147483647 | ||||
off_default_note | note_id | int4 | 10 | ||||
off_default_note_history | note_id | int4 | 10 | ||||
off_default_note | note_text | text | 2147483647 | ||||
off_default_note_history | note_text | text | 2147483647 | ||||
update_notification | notification_id | serial | 10 | √ | nextval('_quest.update_notification_notification_id_seq'::regclass) | ||
update_notification | notification_time | timestamp | 29,6 | now() | When the notification was recorded | ||
std_term_units | override_max_units | bool | 1 | ||||
std_photo | photo_as_of | date | 13 | When this photo was loaded | |||
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 | |||
pps_plan | plan_active | bool | 1 | ||||
pps_plan_history | plan_active | bool | 1 | ||||
pps_plan | plan_as_of | date | 13 | ||||
pps_plan_history | plan_as_of | date | 13 | ||||
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_subplan | plan_code | text | 2147483647 | ||||
std_term_subplan_gpa | plan_code | text | 2147483647 | ||||
std_transfer_credit_school | plan_code | text | 2147483647 | ||||
std_degree_plan | plan_position | int4 | 10 | ||||
std_plan_history | plan_position | int4 | 10 | ||||
std_term_plan | plan_position | int4 | 10 | ||||
pps_plan | plan_short_title | text | 2147483647 | ||||
pps_plan_history | plan_short_title | text | 2147483647 | ||||
pps_plan | plan_title | text | 2147483647 | ||||
pps_plan_history | plan_title | text | 2147483647 | ||||
pps_plan | plan_transcript_description | text | 2147483647 | ||||
pps_plan_history | plan_transcript_description | text | 2147483647 | ||||
pps_plan | plan_type_code | text | 2147483647 | ||||
pps_plan_history | plan_type_code | text | 2147483647 | ||||
pps_service_indicator | positive_indicator | bool | 1 | ||||
std_term | primary_program_code | text | 2147483647 | ||||
std_student | privacy_flag | bool | 1 | ||||
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 | ||||
update_notification | process_id | int4 | 10 | The Quest process ID of the notification | |||
std_program_history | program_action | text | 2147483647 | ||||
std_term_program | program_action | text | 2147483647 | ||||
pps_program | program_active | bool | 1 | ||||
pps_program_history | program_active | bool | 1 | ||||
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 | ||||
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_program | program_code | text | 2147483647 | ||||
std_transfer_credit_school | program_code | text | 2147483647 | ||||
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 | ||||
pps_program | program_short_title | text | 2147483647 | ||||
pps_program_history | program_short_title | text | 2147483647 | ||||
std_program_history | program_status | text | 2147483647 | ||||
std_term_program | program_status | text | 2147483647 | ||||
pps_program | program_title | text | 2147483647 | ||||
pps_program_history | program_title | text | 2147483647 | ||||
pps_service_indicator_reason | reason | text | 2147483647 | ||||
pps_service_indicator_reason | reason_as_of | date | 13 | ||||
std_subplan_history | requirement_term_id | quest_term_id | 2147483647 | ||||
std_term_plan | requirement_term_id | quest_term_id | 2147483647 | ||||
std_term_program | requirement_term_id | quest_term_id | 2147483647 | ||||
std_term_subplan | requirement_term_id | quest_term_id | 2147483647 | ||||
cal_requisite | requisite_active | bool | 1 | ||||
cal_requisite_history | requisite_active | bool | 1 | ||||
cal_requisite | requisite_as_of | date | 13 | ||||
cal_requisite_history | requisite_as_of | date | 13 | ||||
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_id | int4 | 10 | ||||
cal_requisite_history | requisite_id | int4 | 10 | ||||
off_course_section_reserve | requisite_id | int4 | 10 | ||||
cal_requisite | requisite_short_description | text | 2147483647 | ||||
cal_requisite_history | requisite_short_description | text | 2147483647 | ||||
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 | ||||
off_course_section_reserve | reserve_start_date | date | 13 | ||||
std_term_units | reset_cum_stats | bool | 1 | ||||
std_term_units | resident_terms_adjustment | numeric | 6,3 | ||||
std_term_units | resident_terms_credited | numeric | 6,3 | ||||
uw_room | room_capacity | int4 | 10 | ||||
uw_room | room_code | text | 2147483647 | ||||
uw_room | room_description | text | 2147483647 | ||||
update_run | run_created | timestamp | 29,6 | now() | When this run was created | ||
update_run | run_id | serial | 10 | √ | nextval('_quest.update_run_run_id_seq'::regclass) | ||
update_run_notification | run_id | int4 | 10 | ||||
std_transfer_credit_school | school_type | text | 2147483647 | ||||
off_course_section | section_add_consent | quest_consent | 2147483647 | ||||
off_course_section | section_code | text | 2147483647 | ||||
off_course_section | section_drop_consent | quest_consent | 2147483647 | ||||
off_course_section | section_enrol_status | quest_course_enrol_status | 2147483647 | ||||
off_instruct_section | section_enrolment | bool | 1 | Whether the section is an enrolment (primary) section | |||
off_course_section | section_id | int4 | 10 | ||||
off_instruct_section | section_id | int4 | 10 | ||||
off_instruct_section_instructor | section_id | int4 | 10 | ||||
off_instruct_section_meet | section_id | int4 | 10 | ||||
off_course_section | section_schedule_print | bool | 1 | ||||
std_transfer_credit_detail | seq_num | int4 | 10 | ||||
pps_service_indicator_impact | service_impact_as_of | date | 13 | ||||
pps_service_indicator_impact | service_impact_code | text | 2147483647 | ||||
pps_service_indicator | service_indicator_as_of | date | 13 | ||||
std_service_indicator | service_indicator_as_of | timestamp | 29,6 | ||||
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 | ||||
off_association | session_code | quest_session | 2147483647 | ||||
off_course_section | session_code | quest_session | 2147483647 | ||||
off_instruct_section | session_code | quest_session | 2147483647 | The session of the section | |||
std_student | sex | quest_sex | 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 | ||||
pps_standing | standing_description | text | 2147483647 | ||||
pps_standing | standing_short_description | text | 2147483647 | ||||
pps_standing | standing_status_code | quest_standing_status | 2147483647 | ||||
cal_subject | subject_active | bool | 1 | ||||
cal_subject_history | subject_active | bool | 1 | ||||
cal_subject | subject_as_of | date | 13 | ||||
cal_subject_history | subject_as_of | date | 13 | ||||
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 | ||||
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_active | bool | 1 | ||||
pps_subplan_history | subplan_active | bool | 1 | ||||
pps_subplan | subplan_as_of | date | 13 | ||||
pps_subplan_history | subplan_as_of | date | 13 | ||||
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_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 | ||||
pps_subplan | subplan_type | quest_subplan_type | 2147483647 | ||||
pps_subplan_history | subplan_type | quest_subplan_type | 2147483647 | ||||
std_term_units | term_academic_units_attempted | numeric | 8,3 | ||||
std_term_units | term_academic_units_passed | numeric | 8,3 | ||||
uw_term | term_class_dates | daterange | 2147483647 | ||||
uw_term | term_dates | daterange | 2147483647 | ||||
std_term | term_gpa | numeric | 8,3 | ||||
std_term_units | term_grade_points | numeric | 9,3 | ||||
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_note | term_id | quest_term_id | 2147483647 | ||||
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_meet | term_id | quest_term_id | 2147483647 | ||||
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_program | term_id | quest_term_id | 2147483647 | ||||
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_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 | ||||
pps_service_indicator | title | text | 2147483647 | ||||
cal_course_topic | topic_seq | int4 | 10 | ||||
cal_course_topic_history | topic_seq | int4 | 10 | ||||
cal_course_topic | topic_short_title | text | 2147483647 | ||||
cal_course_topic_history | topic_short_title | text | 2147483647 | ||||
cal_course_topic | topic_title | text | 2147483647 | ||||
cal_course_topic_history | topic_title | text | 2147483647 | ||||
std_transfer_credit_detail | transfer_group | int4 | 10 | ||||
std_transfer_credit_school | transfer_group | int4 | 10 | ||||
std_term_units | transferred_grade_points | numeric | 9,3 | ||||
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 | ||||
uw_unit | unit_active | bool | 1 | ||||
uw_unit_history | unit_active | bool | 1 | ||||
uw_unit | unit_as_of | date | 13 | ||||
uw_unit_history | unit_as_of | date | 13 | ||||
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 | ||||
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 | ||||
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 | ||||
std_term_course | units_attempted | numeric | 5,2 | ||||
std_term_course | units_attempted_code | quest_completion_code | 2147483647 | ||||
std_transfer_credit_detail | units_attempted_code | quest_completion_code | 2147483647 | ||||
std_term_course | units_earned | numeric | 5,2 | ||||
std_term_course | units_for_progress | numeric | 5,2 | ||||
std_transfer_credit_detail | units_transferred | numeric | 8,3 | ||||
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_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_program | uw_id | quest_uw_id | 2147483647 | ||||
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_transfer_credit_detail | valid_attempt | bool | 1 | ||||
std_term | withdraw_code | quest_withdraw_code | 2147483647 |