SSR_GR_CPY_INVW

(SQL View)
 Index Back

Inst & Prog Configuration View

Insitutiont & Program Configuration View

SELECT DISTINCT i.INSTITUTION , i.EFFDT , i.EFF_STATUS , t.DESCR FROM PS_SSR_GRADOP_INST i , PS_INSTITUTION_TBL t WHERE t.INSTITUTION = i.INSTITUTION AND t.EFFDT = ( SELECT MAX(t2.EFFDT) FROM PS_INSTITUTION_TBL t2 WHERE t2.INSTITUTION = t.INSTITUTION AND t2.EFFDT <= i.EFFDT) AND t.EFF_STATUS = 'A' UNION ALL SELECT DISTINCT a.INSTITUTION , a.EFFDT , a.EFF_STATUS , x.DESCR FROM PS_SSR_GRADOP_PGM a , PS_INSTITUTION_TBL x WHERE x.INSTITUTION = a.INSTITUTION AND x.EFFDT = ( SELECT MAX(x2.EFFDT) FROM PS_INSTITUTION_TBL x2 WHERE x2.INSTITUTION = x.INSTITUTION AND x2.EFFDT <= a.EFFDT) AND x.EFF_STATUS = 'A' AND a.INSTITUTION not in (SELECT i2.INSTITUTION FROM PS_SSR_GRADOP_INST i2 , PS_INSTITUTION_TBL t3 WHERE t3.INSTITUTION = i2.INSTITUTION AND t3.EFFDT = ( SELECT MAX(t4.EFFDT) FROM PS_INSTITUTION_TBL t4 WHERE t4.INSTITUTION = t3.INSTITUTION AND t4.EFFDT <= i2.EFFDT) AND t3.EFF_STATUS = 'A')

  • Related Language Record: SSR_GR_CPY_INLN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    2 EFFDT Date(10) DATE NOT NULL Effective Date
    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description