check_ps_uw_grd_supr_asn

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

emplid

varchar

√

null

acad_prog

varchar

√

null

acad_plan

varchar

√

null

acad_sub_plan

varchar

√

null

effdt

timestamp

√

null

uw_grd_supr_nbr

float8

17,17

√

null

uw_supr_emplid

varchar

√

null

Table contained 0 rows

View Definition

SELECT pugsa.emplid,
    pugsa.acad_prog,
    pugsa.acad_plan,
    pugsa.acad_sub_plan,
    pugsa.effdt,
    pugsa.uw_grd_supr_nbr,
    pugsa.uw_supr_emplid
   FROM (((_quest_corr.ps_uw_grd_supr_asn pugsa
     LEFT JOIN _quest_corr.ps_acad_prog_tbl apt USING (acad_prog))
     LEFT JOIN _quest_corr.ps_acad_plan_tbl apl USING (acad_plan))
     LEFT JOIN _quest_corr.ps_acad_subpln_tbl ast USING (acad_plan, acad_sub_plan))
  WHERE ((apt.* IS NULL) OR (apl.* IS NULL) OR (((pugsa.acad_sub_plan)::text <> ' '::text) AND (ast.* IS NULL))); SELECT pugsa.emplid,
    pugsa.acad_prog,
    pugsa.acad_plan,
    pugsa.acad_sub_plan,
    pugsa.effdt,
    pugsa.uw_grd_supr_nbr,
    pugsa.uw_supr_emplid
   FROM (((_quest_raw.ps_uw_grd_supr_asn pugsa
     LEFT JOIN _quest_raw.ps_acad_prog_tbl apt USING (acad_prog))
     LEFT JOIN _quest_raw.ps_acad_plan_tbl apl USING (acad_plan))
     LEFT JOIN _quest_raw.ps_acad_subpln_tbl ast USING (acad_plan, acad_sub_plan))
  WHERE ((apt.* IS NULL) OR (apl.* IS NULL) OR (((pugsa.acad_sub_plan)::text <> ' '::text) AND (ast.* IS NULL)));

Description

Columns

View Definition

Possibly Referenced Tables/Views