Database Properties
Database Type: PostgreSQL - 9.5.15
Schema _quest_raw
Quest Data: Raw Quest table contents
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| manual_convert_citizenship | 0 | 1 | 2 | 30 | Table | A conversion between Quest citizenship status description and an available citizenship status |
| manual_term_exam_dates | 0 | 0 | 3 | 18 | Table | The final examination period dates for a term as published in the Calendar |
| manual_missing_userid | 0 | 0 | 2 | 12 | Table | A userid which is missing from the ps_uw_oper_data_in Quest table |
| manual_date_holiday | 0 | 1 | 2 | 154 | Table | A date on which the University is closed due to a holiday |
| manual_date_class_weekday_override | 0 | 0 | 2 | 67 | Table | Override the regular schedule of class days |
| manual_citizenship_status | 3 | 0 | 2 | 26 | Table | A possible citizenship status |
| manual_unit_group | 0 | 0 | 3 | 95 | Table | The manually maintained containing group for an academic organization history record |
| manual_iso_639_3_language | 1 | 0 | 8 | 7849 | Table | |
| manual_quest_language_conversion | 0 | 1 | 2 | 163 | Table | |
| manual_date_holiday_type | 1 | 0 | 2 | 11 | Table | A name that may be applied to a declared University holiday |
| ps_adm_appl_sbplan | 0 | 0 | 9 | 0 | View | Oracle table SYSADM.PS_ADM_APPL_SBPLAN |
| ps_country_tbl | 0 | 0 | 4 | 0 | View | Oracle table SYSADM.PS_COUNTRY_TBL |
| ps_location_tbl | 0 | 0 | 6 | 0 | View | Oracle table SYSADM.PS_LOCATION_TBL |
| ps_citizenship | 0 | 0 | 4 | 0 | View | Oracle table SYSADM.PS_CITIZENSHIP |
| ps_uw_stdnt_ext | 0 | 0 | 13 | 0 | View | Oracle table SYSADM.PS_UW_STDNT_EXT |
| ps_uw_acadpln_stat | 0 | 0 | 12 | 0 | View | Oracle table SYSADM.PS_UW_ACADPLN_STAT |
| ps_crse_offer | 0 | 0 | 12 | 0 | View | Oracle table SYSADM.PS_CRSE_OFFER |
| ps_sctn_cmbnd_tbl | 0 | 0 | 12 | 0 | View | Oracle table SYSADM.PS_SCTN_CMBND_TBL |
| check_ps_adm_appl_plan | 0 | 0 | 9 | 0 | View | Orphan rows of ps_adm_appl_plan |
| ps_adm_appl_data | 0 | 0 | 15 | 0 | View | Oracle table SYSADM.PS_ADM_APPL_DATA |
| check_std_transfer_credit_detail_term | 0 | 0 | 26 | 0 | View | Rows of ps_trns_crse_dtl which do not correspond to a ps_stdnt_car_term row |
| ps_mlstn_atmpt | 0 | 0 | 10 | 0 | View | Oracle table SYSADM.PS_MLSTN_ATMPT |
| ps_uw_cem_demand_p | 0 | 0 | 5 | 0 | View | Oracle table SYSADM.PS_UW_CEM_DEMAND_P |
| check_valid_subplans | 0 | 0 | 8 | 0 | View | Check for invalid plan-subplan combinations. |
| check_course_topic_exist | 0 | 0 | 31 | 0 | View | Class sections with non-existent topics |
| check_course_label_duplicate | 0 | 0 | 6 | 0 | View | Duplicate offerings: more than one ps_crse_offer record simultaneously effective for the same subject/catalog |
| check_std_term_course_transcript_note | 0 | 0 | 7 | 0 | View | Transcript notes on non-enrolment sections |
| iads_refreshinfo | 0 | 0 | 5 | 0 | View | MS SQL data update records |
| ps_srvc_ind_data | 0 | 0 | 7 | 0 | View | Oracle table SYSADM.PS_SRVC_IND_DATA |
| ps_tscrpt_text | 0 | 0 | 8 | 0 | View | Oracle table SYSADM.PS_TSCRPT_TEXT |
| ps_uw_coop_term | 0 | 0 | 6 | 0 | View | Oracle table SYSADM.PS_UW_COOP_TERM |
| ps_acad_degr_spln | 0 | 0 | 4 | 0 | View | Oracle table SYSADM.PS_ACAD_DEGR_SPLN |
| ps_stdnt_response | 0 | 0 | 7 | 0 | View | Oracle table SYSADM.PS_STDNT_RESPONSE |
| ps_uw_acstdng_rule | 0 | 0 | 8 | 0 | View | Oracle table SYSADM.PS_UW_ACSTDNG_RULE |
| ps_sess_time_perod | 0 | 0 | 6 | 0 | View | Oracle table SYSADM.PS_SESS_TIME_PEROD |
| ps_degree_tbl | 0 | 0 | 9 | 0 | View | Oracle table SYSADM.PS_DEGREE_TBL |
| check_acad_subplan_history | 0 | 0 | 8 | 0 | View | |
| check_course_section | 0 | 0 | 30 | 0 | View | Duplicate sections: more than one ps_class_tbl for the same strm/class_nbr |
| ps_instruct_mode | 0 | 0 | 6 | 0 | View | Oracle table SYSADM.PS_INSTRUCT_MODE |
| check_tscrpt_text_loc | 0 | 0 | 10 | 0 | View | Records with null terms. Currently excluded from our DB. |
| ps_trns_crse_dtl | 0 | 0 | 26 | 0 | View | Oracle table SYSADM.PS_TRNS_CRSE_DTL |
| ps_uw_oper_data_in | 0 | 0 | 3 | 0 | View | Oracle table SYSADM.PS_UW_OPER_DATA_IN |
| psxlatitem | 0 | 0 | 9 | 0 | View | Oracle table SYSADM.PSXLATITEM |
| ps_residency_off | 0 | 0 | 5 | 0 | View | Oracle table SYSADM.PS_RESIDENCY_OFF |
| ps_crse_component | 0 | 0 | 4 | 0 | View | Oracle table SYSADM.PS_CRSE_COMPONENT |
| ps_class_assoc | 0 | 0 | 11 | 0 | View | Oracle table SYSADM.PS_CLASS_ASSOC |
| ps_class_notes_tbl | 0 | 0 | 6 | 0 | View | Oracle table SYSADM.PS_CLASS_NOTES_TBL |
| check_acad_prog_plan | 0 | 0 | 18 | 0 | View | Students in programs without a corresponding effective-dated plan |
| check_cal_section_topic | 0 | 0 | 30 | 0 | View | Course sections which have a non-existent topic assigned |
| ps_uw_grd_supr_asn | 0 | 0 | 7 | 0 | View | Oracle table SYSADM.PS_UW_GRD_SUPR_ASN |
| ps_ext_acad_data | 0 | 0 | 7 | 0 | View | Oracle table SYSADM.PS_EXT_ACAD_DATA |
| ps_ext_org_tbl_adm | 0 | 0 | 12 | 0 | View | Oracle table SYSADM.PS_EXT_ORG_TBL_ADM |
| ps_ext_course | 0 | 0 | 29 | 0 | View | Oracle table SYSADM.PS_EXT_COURSE |
| check_acad_degr_subplan | 0 | 0 | 4 | 0 | View | Check for subplans listed in degrees that are not listed in subplan table. |
| ps_acad_degr | 0 | 0 | 8 | 0 | View | Oracle table SYSADM.PS_ACAD_DEGR |
| ps_pers_data_effdt | 0 | 0 | 3 | 0 | View | Oracle table SYSADM.PS_PERS_DATA_EFFDT |
| check_ps_adm_appl_prog | 0 | 0 | 16 | 0 | View | Orphan rows of ps_adm_appl_prog |
| check_cal_section_related | 0 | 0 | 30 | 0 | View | Course sections referring to non-existent auto enroll sections |
| ps_acad_plan | 0 | 0 | 9 | 0 | View | Oracle table SYSADM.PS_ACAD_PLAN |
| ps_acad_prog | 0 | 0 | 18 | 0 | View | Oracle table SYSADM.PS_ACAD_PROG |
| ps_sa_test_tbl | 0 | 0 | 5 | 0 | View | Oracle table SYSADM.PS_SA_TEST_TBL |
| ps_class_rsrv_grp | 0 | 0 | 7 | 0 | View | Oracle table SYSADM.PS_CLASS_RSRV_GRP |
| ps_class_instr | 0 | 0 | 9 | 0 | View | Oracle table SYSADM.PS_CLASS_INSTR |
| ps_ouac_ex_org_tbl | 0 | 0 | 3 | 0 | View | Oracle table SYSADM.PS_OUAC_EX_ORG_TBL |
| check_course_combined_section_meet | 0 | 0 | 5 | 0 | View | Combined sections with different individual sections having different meets |
| ps_erly_fa_ctg_tbl | 0 | 0 | 5 | 0 | View | Oracle table SYSADM.PS_ERLY_FA_CTG_TBL |
| check_acad_plan_history | 0 | 0 | 9 | 0 | View | Check for records in ps_acad_subplan that are missing corresponding records in ps_acad_plan. |
| check_degree_career | 0 | 0 | 9 | 0 | View | Degrees which cannot be identified as to which career they go with |
| ps_chklst_item_tbl | 0 | 0 | 3 | 0 | View | Oracle table SYSADM.PS_CHKLST_ITEM_TBL |
| ps_class_notes | 0 | 0 | 8 | 0 | View | Oracle table SYSADM.PS_CLASS_NOTES |
| check_gpa | 0 | 0 | 5 | 0 | View | |
| ps_adm_appl_cmp | 0 | 0 | 9 | 0 | View | Oracle table SYSADM.PS_ADM_APPL_CMP |
| ps_degr_honors_tbl | 0 | 0 | 10 | 0 | View | Oracle table SYSADM.PS_DEGR_HONORS_TBL |
| check_std_term_section_reserve | 0 | 0 | 4 | 0 | View | Student class enrolments which refer to a nonexistent reservation cap |
| ps_early_fa_catgs | 0 | 0 | 10 | 0 | View | Oracle table SYSADM.PS_EARLY_FA_CATGS |
| ps_tscrpt_note_tbl | 0 | 0 | 6 | 0 | View | Oracle table SYSADM.PS_TSCRPT_NOTE_TBL |
| check_std_term_section_career_term | 0 | 0 | 34 | 0 | View | Student class section enrolments for which the student does not have a ps_stdnt_car_term row |
| ps_acad_plan_tbl | 0 | 0 | 15 | 0 | View | Oracle table SYSADM.PS_ACAD_PLAN_TBL |
| ps_bldg_tbl | 0 | 0 | 5 | 0 | View | Oracle table SYSADM.PS_BLDG_TBL |
| ps_person | 0 | 0 | 3 | 0 | View | Oracle table SYSADM.PS_PERSON |
| ps_stdnt_grps_hist | 0 | 0 | 6 | 0 | View | Oracle table SYSADM.PS_STDNT_GRPS_HIST |
| ps_service_impact | 0 | 0 | 6 | 0 | View | Oracle table SYSADM.PS_SERVICE_IMPACT |
| check_course_offer | 0 | 0 | 12 | 0 | View | Course offers that do not match up with a catalog update |
| ps_acad_subplan | 0 | 0 | 8 | 0 | View | Oracle table SYSADM.PS_ACAD_SUBPLAN |
| ps_rq_grp_tbl | 0 | 0 | 7 | 0 | View | Oracle table SYSADM.PS_RQ_GRP_TBL |
| ps_personal_phone | 0 | 0 | 6 | 0 | View | Oracle table SYSADM.PS_PERSONAL_PHONE |
| all_ind_columns | 0 | 0 | 9 | 0 | View | Oracle table SYS.ALL_IND_COLUMNS |
| ps_acad_org_tbl | 0 | 0 | 8 | 0 | View | Oracle table SYSADM.PS_ACAD_ORG_TBL |
| ps_addresses | 0 | 0 | 12 | 0 | View | Oracle table SYSADM.PS_ADDRESSES |
| ps_names | 0 | 0 | 10 | 0 | View | Oracle table SYSADM.PS_NAMES |
| ps_acad_stdng_actn | 0 | 0 | 10 | 0 | View | Oracle table SYSADM.PS_ACAD_STDNG_ACTN |
| ps_org_location | 0 | 0 | 16 | 0 | View | Oracle table SYSADM.PS_ORG_LOCATION |
| check_plan_degree | 0 | 0 | 15 | 0 | View | Academic plans associated with a non-existent degree |
| ps_comment_cde_tbl | 0 | 0 | 5 | 0 | View | Oracle table SYSADM.PS_COMMENT_CDE_TBL |
| ps_study_agrm_tbl | 0 | 0 | 6 | 0 | View | Oracle table SYSADM.PS_STUDY_AGRM_TBL |
| ps_crse_offer_as_of | 0 | 0 | 5 | 0 | View | Correct effective date to use for a course in a term |
| ps_trns_crse_sch | 0 | 0 | 19 | 0 | View | Oracle table SYSADM.PS_TRNS_CRSE_SCH |
| ps_acad_plan_owner | 0 | 0 | 5 | 0 | View | Oracle table SYSADM.PS_ACAD_PLAN_OWNER |
| check_std_term_section_career | 0 | 0 | 3 | 0 | View | Student/term combinations in which the student is registered in sections under multiple careers |
| ps_ouac_appl_data | 0 | 0 | 10 | 0 | View | Oracle table SYSADM.PS_OUAC_APPL_DATA |
| ps_srvc_ind_cd_tbl | 0 | 0 | 8 | 0 | View | Oracle table SYSADM.PS_SRVC_IND_CD_TBL |
| ps_uw_ouac_data | 0 | 0 | 11 | 0 | View | Oracle table SYSADM.PS_UW_OUAC_DATA |
| ps_ext_summ_tp_tbl | 0 | 0 | 5 | 0 | View | Oracle table SYSADM.PS_EXT_SUMM_TP_TBL |
| ps_uw_student_rank | 0 | 0 | 10 | 0 | View | Oracle table SYSADM.PS_UW_STUDENT_RANK |
| ps_class_tbl | 0 | 0 | 30 | 0 | View | Oracle table SYSADM.PS_CLASS_TBL |
| ps_stdnt_group_tbl | 0 | 0 | 6 | 0 | View | Oracle table SYSADM.PS_STDNT_GROUP_TBL |
| ps_class_mtg_pat | 0 | 0 | 19 | 0 | View | Oracle table SYSADM.PS_CLASS_MTG_PAT |
| all_indexes | 0 | 0 | 58 | 0 | View | Oracle table SYS.ALL_INDEXES |
| ps_adm_appl_eval | 0 | 0 | 11 | 0 | View | Oracle table SYSADM.PS_ADM_APPL_EVAL |
| ps_person_checklst | 0 | 0 | 3 | 0 | View | Oracle table SYSADM.PS_PERSON_CHECKLST |
| ps_tscrpt_text_loc | 0 | 0 | 10 | 0 | View | Oracle table SYSADM.PS_TSCRPT_TEXT_LOC |
| check_course_topic | 0 | 0 | 6 | 0 | View | Course topics that do not match up with a catalog update |
| check_ps_adm_appl_sbplan | 0 | 0 | 9 | 0 | View | Orphan rows of ps_adm_appl_sbplan |
| ps_stdnt_enrl | 0 | 0 | 34 | 0 | View | Oracle table SYSADM.PS_STDNT_ENRL |
| ps_campus_tbl | 0 | 0 | 7 | 0 | View | Oracle table SYSADM.PS_CAMPUS_TBL |
| ps_ext_degree | 0 | 0 | 10 | 0 | View | Oracle table SYSADM.PS_EXT_DEGREE |
| ps_srvc_in_rsn_tbl | 0 | 0 | 7 | 0 | View | Oracle table SYSADM.PS_SRVC_IN_RSN_TBL |
| ps_ext_org_tbl | 0 | 0 | 9 | 0 | View | Oracle table SYSADM.PS_EXT_ORG_TBL |
| ps_subject_tbl | 0 | 0 | 8 | 0 | View | Oracle table SYSADM.PS_SUBJECT_TBL |
| check_milestone_nbr | 0 | 0 | 15 | 0 | View | Student milestones with a number not divisible by 10 |
| ps_acad_degr_hons | 0 | 0 | 5 | 0 | View | Oracle table SYSADM.PS_ACAD_DEGR_HONS |
| ps_prog_rsn_tbl | 0 | 0 | 9 | 0 | View | Oracle table SYSADM.PS_PROG_RSN_TBL |
| check_degree_student_career | 0 | 0 | 6 | 0 | View | Student degree plans for which the career differs from the degree career |
| ps_prog_action_tbl | 0 | 0 | 5 | 0 | View | Oracle table SYSADM.PS_PROG_ACTION_TBL |
| ps_stdnt_car_term | 0 | 0 | 55 | 0 | View | Oracle table SYSADM.PS_STDNT_CAR_TERM |
| ps_adm_appl_plan | 0 | 0 | 9 | 0 | View | Oracle table SYSADM.PS_ADM_APPL_PLAN |
| check_std_term_section | 0 | 0 | 34 | 0 | View | Student class enrolments in non-existent classes |
| ps_uw_adm_ap_sbpln | 0 | 0 | 9 | 0 | View | Oracle table SYSADM.PS_UW_ADM_AP_SBPLN |
| ps_person_chk_item | 0 | 0 | 5 | 0 | View | Oracle table SYSADM.PS_PERSON_CHK_ITEM |
| ps_citizen_sts_convert | 0 | 1 | 4 | 0 | View | ps_citizen_sts_tbl with converted citizenship codes |
| ps_stdnt_advr_hist | 0 | 0 | 9 | 0 | View | Oracle table SYSADM.PS_STDNT_ADVR_HIST |
| ps_stdnt_car_mlstn | 0 | 0 | 15 | 0 | View | Oracle table SYSADM.PS_STDNT_CAR_MLSTN |
| check_citizen_status_conversion | 0 | 1 | 4 | 0 | View | Citizenship statuses with no converted citizenship_code |
| check_cal_section_note | 0 | 0 | 8 | 0 | View | Section notes in which the text indicates there is no note, but the numeric reference is not empty |
| ps_acad_degr_plan | 0 | 0 | 6 | 0 | View | Oracle table SYSADM.PS_ACAD_DEGR_PLAN |
| check_missing_cem_section | 0 | 0 | 16 | 0 | View | Student pre-registrations not corresponding to a course section |
| check_ps_uw_grd_supr_asn_multiple_subplan | 0 | 0 | 6 | 0 | View | |
| check_std_term_section_session | 0 | 0 | 34 | 0 | View | Student class section enrolments in which the session code does not match the session code of the class section |
| all_tab_columns | 0 | 0 | 36 | 0 | View | Oracle table SYS.ALL_TAB_COLUMNS |
| check_milestone_nbr_duplicate | 0 | 0 | 4 | 0 | View | Student milestones with a duplicate number |
| ps_acad_subpln_tbl | 0 | 0 | 12 | 0 | View | Oracle table SYSADM.PS_ACAD_SUBPLN_TBL |
| check_service_indicator_null_date | 0 | 0 | 7 | 0 | View | Student service indicators with NULL active date |
| ps_accomp_tbl | 0 | 0 | 2 | 0 | View | Oracle table SYSADM.PS_ACCOMP_TBL |
| ps_uw_genl_mat | 0 | 0 | 5 | 0 | View | Oracle table SYSADM.PS_UW_GENL_MAT |
| ps_email_addresses | 0 | 0 | 3 | 0 | View | Oracle table SYSADM.PS_EMAIL_ADDRESSES |
| is_columns | 0 | 0 | 5 | 0 | View | MS SQL information schema columns |
| check_facility_unit | 0 | 0 | 15 | 0 | View | Facilities where being open for general assignment is not equivalent to not being owned by an academic unit |
| check_course_combined_section_status | 0 | 0 | 6 | 0 | View | Combined sections with different individual sections having different status |
| ps_ext_acad_sum | 0 | 0 | 6 | 0 | View | Oracle table SYSADM.PS_EXT_ACAD_SUM |
| check_course_section_combined | 0 | 0 | 5 | 0 | View | Duplicate combined sections: more than one ps_sctn_cmbnd for the same strm/class_nbr |
| check_student_citizen_status | 0 | 0 | 4 | 0 | View | |
| ps_class_rsrv_cap | 0 | 0 | 9 | 0 | View | Oracle table SYSADM.PS_CLASS_RSRV_CAP |
| check_std_term_section_grade | 0 | 0 | 34 | 0 | View | Student registration in non-enrolment sections with grade information |
| check_country_duplicate_code | 0 | 0 | 2 | 0 | View | Duplicate 2-letter country codes |
| ps_sa_test_cmp_tbl | 0 | 0 | 5 | 0 | View | Oracle table SYSADM.PS_SA_TEST_CMP_TBL |
| ps_acad_stactn_tbl | 0 | 0 | 9 | 0 | View | Oracle table SYSADM.PS_ACAD_STACTN_TBL |
| ps_adm_appl_prog | 0 | 0 | 16 | 0 | View | Oracle table SYSADM.PS_ADM_APPL_PROG |
| ps_stdnt_test_comp | 0 | 0 | 8 | 0 | View | Oracle table SYSADM.PS_STDNT_TEST_COMP |
| check_std_term_course_units | 0 | 0 | 34 | 0 | View | Student course enrolments with differing units taken and units earned |
| check_cal_association | 0 | 0 | 11 | 0 | View | Courses in cal_association without a corresponding entry in course |
| ps_stdnt_spcl_gpa | 0 | 0 | 11 | 0 | View | Oracle table SYSADM.PS_STDNT_SPCL_GPA |
| ps_acad_calses_tbl | 0 | 0 | 13 | 0 | View | Oracle table SYSADM.PS_ACAD_CALSES_TBL |
| ps_ouac_appl_prog | 0 | 0 | 8 | 0 | View | Oracle table SYSADM.PS_OUAC_APPL_PROG |
| check_cal_section_combined | 0 | 0 | 5 | 0 | View | Course sections participating in a non-existent combined section |
| ps_class_tbl_as_of | 0 | 0 | 31 | 0 | View | ps_class_tbl augmented with the course effective date assumed to be effective for the class section (most recent effective date as of the beginning of the term) |
| ps_acad_group_tbl | 0 | 0 | 6 | 0 | View | Oracle table SYSADM.PS_ACAD_GROUP_TBL |
| check_cal_section | 0 | 0 | 30 | 0 | View | Course sections whose class type or session does not match their section number or with invalid section number |
| ps_citizen_sts_tbl | 0 | 0 | 4 | 0 | View | Oracle table SYSADM.PS_CITIZEN_STS_TBL |
| ps_honor_award_tbl | 0 | 0 | 10 | 0 | View | Oracle table SYSADM.PS_HONOR_AWARD_TBL |
| ps_sctn_cmbnd | 0 | 0 | 5 | 0 | View | Oracle table SYSADM.PS_SCTN_CMBND |
| check_citizen_status_country | 0 | 0 | 4 | 0 | View | Student citizenship status with nonexistent status |
| ps_stdnt_enrl_note | 0 | 0 | 7 | 0 | View | Oracle table SYSADM.PS_STDNT_ENRL_NOTE |
| ps_var_data_admp | 0 | 0 | 5 | 0 | View | Oracle table SYSADM.PS_VAR_DATA_ADMP |
| ps_crse_topics | 0 | 0 | 6 | 0 | View | Oracle table SYSADM.PS_CRSE_TOPICS |
| check_session_dates | 0 | 0 | 5 | 0 | View | Sessions with inconsistent dates |
| ps_accomplishments | 0 | 0 | 2 | 0 | View | Oracle table SYSADM.PS_ACCOMPLISHMENTS |
| check_student_term_plan_01 | 0 | 0 | 9 | 0 | View | Plan codes in ps_acad_plan without a corresponding entry in ps_acad_plan_tbl |
| ps_facility_tbl | 0 | 0 | 15 | 0 | View | Oracle table SYSADM.PS_FACILITY_TBL |
| ps_session_tbl | 0 | 0 | 15 | 0 | View | Oracle table SYSADM.PS_SESSION_TBL |
| ps_external_system | 0 | 0 | 4 | 0 | View | Oracle table SYSADM.PS_EXTERNAL_SYSTEM |
| ps_person_sa | 0 | 0 | 2 | 0 | View | Oracle table SYSADM.PS_PERSON_SA |
| ps_crse_catalog | 0 | 0 | 10 | 0 | View | Oracle table SYSADM.PS_CRSE_CATALOG |
| check_student_term_plan_02 | 0 | 0 | 9 | 0 | View | Students with a degree listed in ps_acad_plan but not listed in ps_acad_degr |
| is_tables | 0 | 0 | 4 | 0 | View | MS SQL information schema tables |
| ps_adm_comments | 0 | 0 | 8 | 0 | View | Oracle table SYSADM.PS_ADM_COMMENTS |
| check_term_class_dates | 0 | 0 | 2 | 0 | View | Recent terms with inconsistent class dates |
| ps_uw_prir_wkexp_v | 0 | 0 | 7 | 0 | View | Oracle table SYSADM.PS_UW_PRIR_WKEXP_V |
| check_course_label_exist | 0 | 0 | 31 | 0 | View | Class sections with non-existent labels |
| ps_term_tbl | 0 | 0 | 9 | 0 | View | Oracle table SYSADM.PS_TERM_TBL |
| ps_uw_cem_demand | 0 | 0 | 16 | 0 | View | Oracle table SYSADM.PS_UW_CEM_DEMAND |
| check_ps_uw_grd_supr_asn | 0 | 0 | 7 | 0 | View | Orphan rows of ps_uw_grd_supr_asn |
| ps_acad_prog_tbl | 0 | 0 | 11 | 0 | View | Oracle table SYSADM.PS_ACAD_PROG_TBL |
| ps_honor_award_cs | 0 | 0 | 11 | 0 | View | Oracle table SYSADM.PS_HONOR_AWARD_CS |
| ps_ext_subject_tbl | 0 | 0 | 5 | 0 | View | Oracle table SYSADM.PS_EXT_SUBJECT_TBL |
| ps_genl_materials | 0 | 0 | 18 | 0 | View | Oracle table SYSADM.PS_GENL_MATERIALS |