check_course_combined_section_status

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

strm

varchar

√

null

sctn_combined_id

varchar

√

null

class_nbr_1

float8

17,17

√

null

class_stat_1

varchar

√

null

class_nbr_2

float8

17,17

√

null

class_stat_2

varchar

√

null

Table contained 0 rows

View Definition

WITH sctn AS (
         SELECT ps_class_tbl.strm,
            ps_class_tbl.class_nbr,
            ps_class_tbl.crse_id,
            ps_class_tbl.crse_offer_nbr,
            ps_class_tbl.session_code,
            ps_class_tbl.class_section,
            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.session_code,
            ps_sctn_cmbnd.sctn_combined_id
           FROM (_quest_corr.ps_class_tbl
             JOIN _quest_corr.ps_sctn_cmbnd USING (strm, class_nbr))
        )
 SELECT s1.strm,
    s1.sctn_combined_id,
    s1.class_nbr AS class_nbr_1,
    s1.class_stat AS class_stat_1,
    s2.class_nbr AS class_nbr_2,
    s2.class_stat AS class_stat_2
   FROM (sctn s1(strm, class_nbr, crse_id, crse_offer_nbr, session_code, class_section, 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, session_code_1, sctn_combined_id)
     JOIN sctn s2(strm, class_nbr, crse_id, crse_offer_nbr, session_code, class_section, 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, session_code_1, sctn_combined_id) USING (strm, sctn_combined_id))
  WHERE ((s1.class_nbr < s2.class_nbr) AND ((s1.class_stat)::text <> (s2.class_stat)::text))
  ORDER BY s1.strm, s1.sctn_combined_id; WITH sctn AS (
         SELECT ps_class_tbl.strm,
            ps_class_tbl.class_nbr,
            ps_class_tbl.crse_id,
            ps_class_tbl.crse_offer_nbr,
            ps_class_tbl.session_code,
            ps_class_tbl.class_section,
            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.session_code,
            ps_sctn_cmbnd.sctn_combined_id
           FROM (_quest_raw.ps_class_tbl
             JOIN _quest_raw.ps_sctn_cmbnd USING (strm, class_nbr))
        )
 SELECT s1.strm,
    s1.sctn_combined_id,
    s1.class_nbr AS class_nbr_1,
    s1.class_stat AS class_stat_1,
    s2.class_nbr AS class_nbr_2,
    s2.class_stat AS class_stat_2
   FROM (sctn s1(strm, class_nbr, crse_id, crse_offer_nbr, session_code, class_section, 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, session_code_1, sctn_combined_id)
     JOIN sctn s2(strm, class_nbr, crse_id, crse_offer_nbr, session_code, class_section, 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, session_code_1, sctn_combined_id) USING (strm, sctn_combined_id))
  WHERE ((s1.class_nbr < s2.class_nbr) AND ((s1.class_stat)::text <> (s2.class_stat)::text))
  ORDER BY s1.strm, s1.sctn_combined_id;

check_course_combined_section_status

Description

Columns

View Definition

Possibly Referenced Tables/Views