SSR_BC_UNAUD_VW

(SQL View)
 Index Back

Browse Catalog Units Audit

Browse Catalog Units Audit

SELECT A.CRSE_ID , A.EFFDT , A.CRSE_OFFER_NBR , B.UNITS_MINIMUM , B.UNITS_MAXIMUM , C.DESCR FROM PS_SSR_OFFR_AUD_ES A , PS_SSR_CAT_AUD_ES B , PS_SSR_BCFCT_UNTS C WHERE A.CRSE_ID = B.CRSE_ID AND A.EFFDT = B.EFFDT AND (((B.UNITS_MINIMUM = B.UNITS_MAXIMUM) AND (B.UNITS_MINIMUM >= C.UNITS_MINIMUM AND B.UNITS_MINIMUM <= C.UNITS_MAXIMUM)) OR ((B.UNITS_MINIMUM <> B.UNITS_MAXIMUM AND ((B.UNITS_MINIMUM BETWEEN C.UNITS_MINIMUM AND C.UNITS_MAXIMUM) OR (B.UNITS_MAXIMUM BETWEEN C.UNITS_MINIMUM AND C.UNITS_MAXIMUM) OR (C.UNITS_MINIMUM BETWEEN B.UNITS_MINIMUM AND B.UNITS_MAXIMUM) OR (C.UNITS_MAXIMUM BETWEEN B.UNITS_MINIMUM AND B.UNITS_MAXIMUM))))) AND C.EFFDT = ( SELECT MAX(C_ED.EFFDT) FROM PS_SSR_BCFCT_UNTS C_ED WHERE C_ED.EFFDT <= %CurrentDateIn)

  • Related Language Record: SSR_BC_UNITS_VL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
    4 UNITS_MINIMUM Number(6,2) DECIMAL(5,2) NOT NULL Minimum Units
    5 UNITS_MAXIMUM Number(6,2) DECIMAL(5,2) NOT NULL Maximum Units
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description