check_course_combined_section_meet

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

strm

varchar

√

null

sctn_combined_id

varchar

√

null

class_mtg_nbr

float8

17,17

√

null

class_nbr_1

float8

17,17

√

null

class_nbr_2

float8

17,17

√

null

Table contained 0 rows

View Definition

WITH sctn AS (
         SELECT ps_class_tbl.crse_id,
            ps_class_tbl.crse_offer_nbr,
            ps_class_tbl.strm,
            ps_class_tbl.session_code,
            ps_class_tbl.class_section,
            ps_class_tbl.class_nbr,
            ps_class_tbl.institution,
            ps_class_tbl.acad_group,
            ps_class_tbl.subject,
            ps_class_tbl.catalog_nbr,
            ps_class_tbl.acad_career,
            ps_class_tbl.descr,
            ps_class_tbl.ssr_component,
            ps_class_tbl.enrl_stat,
            ps_class_tbl.class_stat,
            ps_class_tbl.class_type,
            ps_class_tbl.associated_class,
            ps_class_tbl.auto_enroll_sect_1,
            ps_class_tbl.auto_enroll_sect_2,
            ps_class_tbl.schedule_print,
            ps_class_tbl.consent,
            ps_class_tbl.enrl_cap,
            ps_class_tbl.enrl_tot,
            ps_class_tbl.crs_topic_id,
            ps_class_tbl.acad_org,
            ps_class_tbl.campus,
            ps_class_tbl.location,
            ps_class_tbl.instruction_mode,
            ps_class_tbl.room_cap_request,
            ps_class_tbl.ssr_drop_consent,
            ps_sctn_cmbnd.institution,
            ps_sctn_cmbnd.sctn_combined_id,
            ps_class_mtg_pat.class_mtg_nbr,
            ps_class_mtg_pat.facility_id,
            ps_class_mtg_pat.meeting_time_start,
            ps_class_mtg_pat.meeting_time_end,
            ps_class_mtg_pat.mon,
            ps_class_mtg_pat.tues,
            ps_class_mtg_pat.wed,
            ps_class_mtg_pat.thurs,
            ps_class_mtg_pat.fri,
            ps_class_mtg_pat.sat,
            ps_class_mtg_pat.sun,
            ps_class_mtg_pat.start_dt,
            ps_class_mtg_pat.end_dt,
            ps_class_mtg_pat.stnd_mtg_pat
           FROM ((_quest_corr.ps_class_tbl
             JOIN _quest_corr.ps_sctn_cmbnd USING (strm, session_code, class_nbr))
             JOIN _quest_corr.ps_class_mtg_pat USING (crse_id, crse_offer_nbr, strm, session_code, class_section))
        )
 SELECT s1.strm,
    s1.sctn_combined_id,
    s1.class_mtg_nbr,
    s1.class_nbr AS class_nbr_1,
    s2.class_nbr AS class_nbr_2
   FROM (sctn s1(crse_id, crse_offer_nbr, strm, session_code, class_section, class_nbr, institution, acad_group, subject, catalog_nbr, acad_career, descr, ssr_component, enrl_stat, class_stat, class_type, associated_class, auto_enroll_sect_1, auto_enroll_sect_2, schedule_print, consent, enrl_cap, enrl_tot, crs_topic_id, acad_org, campus, location, instruction_mode, room_cap_request, ssr_drop_consent, institution_1, sctn_combined_id, class_mtg_nbr, facility_id, meeting_time_start, meeting_time_end, mon, tues, wed, thurs, fri, sat, sun, start_dt, end_dt, stnd_mtg_pat)
     JOIN sctn s2(crse_id, crse_offer_nbr, strm, session_code, class_section, class_nbr, institution, acad_group, subject, catalog_nbr, acad_career, descr, ssr_component, enrl_stat, class_stat, class_type, associated_class, auto_enroll_sect_1, auto_enroll_sect_2, schedule_print, consent, enrl_cap, enrl_tot, crs_topic_id, acad_org, campus, location, instruction_mode, room_cap_request, ssr_drop_consent, institution_1, sctn_combined_id, class_mtg_nbr, facility_id, meeting_time_start, meeting_time_end, mon, tues, wed, thurs, fri, sat, sun, start_dt, end_dt, stnd_mtg_pat) USING (strm, sctn_combined_id, class_mtg_nbr))
  WHERE ((s1.class_nbr < s2.class_nbr) AND ((((((((((((((s1.facility_id)::text IS DISTINCT FROM (s2.facility_id)::text) OR (s1.meeting_time_start IS DISTINCT FROM s2.meeting_time_start)) OR (s1.meeting_time_end IS DISTINCT FROM s2.meeting_time_end)) OR ((s1.mon)::text IS DISTINCT FROM (s2.mon)::text)) OR ((s1.tues)::text IS DISTINCT FROM (s2.tues)::text)) OR ((s1.wed)::text IS DISTINCT FROM (s2.wed)::text)) OR ((s1.thurs)::text IS DISTINCT FROM (s2.thurs)::text)) OR ((s1.fri)::text IS DISTINCT FROM (s2.fri)::text)) OR ((s1.sat)::text IS DISTINCT FROM (s2.sat)::text)) OR ((s1.sun)::text IS DISTINCT FROM (s2.sun)::text)) OR (s1.start_dt IS DISTINCT FROM s2.start_dt)) OR (s1.end_dt IS DISTINCT FROM s2.end_dt)) OR ((s1.stnd_mtg_pat)::text IS DISTINCT FROM (s2.stnd_mtg_pat)::text)))
  ORDER BY s1.strm, s1.sctn_combined_id, s1.class_mtg_nbr; WITH sctn AS (
         SELECT ps_class_tbl.crse_id,
            ps_class_tbl.crse_offer_nbr,
            ps_class_tbl.strm,
            ps_class_tbl.session_code,
            ps_class_tbl.class_section,
            ps_class_tbl.class_nbr,
            ps_class_tbl.institution,
            ps_class_tbl.acad_group,
            ps_class_tbl.subject,
            ps_class_tbl.catalog_nbr,
            ps_class_tbl.acad_career,
            ps_class_tbl.descr,
            ps_class_tbl.ssr_component,
            ps_class_tbl.enrl_stat,
            ps_class_tbl.class_stat,
            ps_class_tbl.class_type,
            ps_class_tbl.associated_class,
            ps_class_tbl.auto_enroll_sect_1,
            ps_class_tbl.auto_enroll_sect_2,
            ps_class_tbl.schedule_print,
            ps_class_tbl.consent,
            ps_class_tbl.enrl_cap,
            ps_class_tbl.enrl_tot,
            ps_class_tbl.crs_topic_id,
            ps_class_tbl.acad_org,
            ps_class_tbl.campus,
            ps_class_tbl.location,
            ps_class_tbl.instruction_mode,
            ps_class_tbl.room_cap_request,
            ps_class_tbl.ssr_drop_consent,
            ps_sctn_cmbnd.institution,
            ps_sctn_cmbnd.sctn_combined_id,
            ps_class_mtg_pat.class_mtg_nbr,
            ps_class_mtg_pat.facility_id,
            ps_class_mtg_pat.meeting_time_start,
            ps_class_mtg_pat.meeting_time_end,
            ps_class_mtg_pat.mon,
            ps_class_mtg_pat.tues,
            ps_class_mtg_pat.wed,
            ps_class_mtg_pat.thurs,
            ps_class_mtg_pat.fri,
            ps_class_mtg_pat.sat,
            ps_class_mtg_pat.sun,
            ps_class_mtg_pat.start_dt,
            ps_class_mtg_pat.end_dt,
            ps_class_mtg_pat.stnd_mtg_pat
           FROM ((_quest_raw.ps_class_tbl
             JOIN _quest_raw.ps_sctn_cmbnd USING (strm, session_code, class_nbr))
             JOIN _quest_raw.ps_class_mtg_pat USING (crse_id, crse_offer_nbr, strm, session_code, class_section))
        )
 SELECT s1.strm,
    s1.sctn_combined_id,
    s1.class_mtg_nbr,
    s1.class_nbr AS class_nbr_1,
    s2.class_nbr AS class_nbr_2
   FROM (sctn s1(crse_id, crse_offer_nbr, strm, session_code, class_section, class_nbr, institution, acad_group, subject, catalog_nbr, acad_career, descr, ssr_component, enrl_stat, class_stat, class_type, associated_class, auto_enroll_sect_1, auto_enroll_sect_2, schedule_print, consent, enrl_cap, enrl_tot, crs_topic_id, acad_org, campus, location, instruction_mode, room_cap_request, ssr_drop_consent, institution_1, sctn_combined_id, class_mtg_nbr, facility_id, meeting_time_start, meeting_time_end, mon, tues, wed, thurs, fri, sat, sun, start_dt, end_dt, stnd_mtg_pat)
     JOIN sctn s2(crse_id, crse_offer_nbr, strm, session_code, class_section, class_nbr, institution, acad_group, subject, catalog_nbr, acad_career, descr, ssr_component, enrl_stat, class_stat, class_type, associated_class, auto_enroll_sect_1, auto_enroll_sect_2, schedule_print, consent, enrl_cap, enrl_tot, crs_topic_id, acad_org, campus, location, instruction_mode, room_cap_request, ssr_drop_consent, institution_1, sctn_combined_id, class_mtg_nbr, facility_id, meeting_time_start, meeting_time_end, mon, tues, wed, thurs, fri, sat, sun, start_dt, end_dt, stnd_mtg_pat) USING (strm, sctn_combined_id, class_mtg_nbr))
  WHERE ((s1.class_nbr < s2.class_nbr) AND ((((((((((((((s1.facility_id)::text IS DISTINCT FROM (s2.facility_id)::text) OR (s1.meeting_time_start IS DISTINCT FROM s2.meeting_time_start)) OR (s1.meeting_time_end IS DISTINCT FROM s2.meeting_time_end)) OR ((s1.mon)::text IS DISTINCT FROM (s2.mon)::text)) OR ((s1.tues)::text IS DISTINCT FROM (s2.tues)::text)) OR ((s1.wed)::text IS DISTINCT FROM (s2.wed)::text)) OR ((s1.thurs)::text IS DISTINCT FROM (s2.thurs)::text)) OR ((s1.fri)::text IS DISTINCT FROM (s2.fri)::text)) OR ((s1.sat)::text IS DISTINCT FROM (s2.sat)::text)) OR ((s1.sun)::text IS DISTINCT FROM (s2.sun)::text)) OR (s1.start_dt IS DISTINCT FROM s2.start_dt)) OR (s1.end_dt IS DISTINCT FROM s2.end_dt)) OR ((s1.stnd_mtg_pat)::text IS DISTINCT FROM (s2.stnd_mtg_pat)::text)))
  ORDER BY s1.strm, s1.sctn_combined_id, s1.class_mtg_nbr;

check_course_combined_section_meet

Description

Columns

View Definition

Possibly Referenced Tables/Views