check_std_term_section_reserve

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

emplid

varchar

√

null

strm

varchar

√

null

class_nbr

float8

17,17

√

null

rsrv_cap_nbr

float8

17,17

√

null

Table contained 0 rows

View Definition

SELECT pse.emplid,
    pse.strm,
    pse.class_nbr,
    pse.rsrv_cap_nbr
   FROM ((( SELECT ps_stdnt_enrl.emplid,
            ps_stdnt_enrl.strm,
            ps_stdnt_enrl.class_nbr,
            ps_stdnt_enrl.rsrv_cap_nbr
           FROM _quest_corr.ps_stdnt_enrl) pse
     JOIN _quest_corr.ps_class_tbl USING (strm, class_nbr))
     LEFT JOIN _quest_corr.ps_class_rsrv_cap pcrc USING (crse_id, crse_offer_nbr, strm, session_code, class_section, rsrv_cap_nbr))
  WHERE ((pse.rsrv_cap_nbr <> (0)::double precision) AND (pcrc.* IS NULL)); SELECT pse.emplid,
    pse.strm,
    pse.class_nbr,
    pse.rsrv_cap_nbr
   FROM ((( SELECT ps_stdnt_enrl.emplid,
            ps_stdnt_enrl.strm,
            ps_stdnt_enrl.class_nbr,
            ps_stdnt_enrl.rsrv_cap_nbr
           FROM _quest_raw.ps_stdnt_enrl) pse
     JOIN _quest_raw.ps_class_tbl USING (strm, class_nbr))
     LEFT JOIN _quest_raw.ps_class_rsrv_cap pcrc USING (crse_id, crse_offer_nbr, strm, session_code, class_section, rsrv_cap_nbr))
  WHERE ((pse.rsrv_cap_nbr <> (0)::double precision) AND (pcrc.* IS NULL));

check_std_term_section_reserve

Description

Columns

View Definition

Possibly Referenced Tables/Views