SSR_GR_CPY_INLN

(SQL View)
 Index Back

Rel Lang for SSR_GR_CPY_INVW


SELECT i.INSTITUTION , l.LANGUAGE_CD , i.EFFDT , l.DESCR FROM PS_SSR_GRADOP_INST i , PS_INSTITUTION_TBL t , PS_INSTITUTION_LNG l 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' AND l.INSTITUTION = t.INSTITUTION AND l.EFFDT = t.EFFDT UNION ALL SELECT a.INSTITUTION , z.LANGUAGE_CD , a.EFFDT , z.DESCR FROM PS_SSR_GRADOP_PGM a , PS_INSTITUTION_TBL x , PS_INSTITUTION_LNG z 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 z.INSTITUTION = x.INSTITUTION AND z.EFFDT = x.EFFDT 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 for SSR_GR_CPY_INVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EFFDT Date(10) DATE NOT NULL Effective Date
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description