SSR_APTSYM_INVW

(SQL View)
 Index Back

APT Sync Search View for Inst


SELECT DISTINCT r.institution , i.descr FROM ps_ssr_aptsyrq_dtl r ,ps_institution_tbl i WHERE i.institution = r.institution AND i.effdt = ( SELECT MAX(i2.effdt) FROM ps_institution_tbl i2 WHERE i2.institution = i.institution AND i2.effdt <= %CurrentDateIn) AND i.eff_status = 'A' UNION SELECT DISTINCT t.institution , i.descr FROM PS_SSR_APT_SYN_TRK t ,ps_institution_tbl i WHERE i.institution = t.institution AND i.effdt = ( SELECT MAX(i2.effdt) FROM ps_institution_tbl i2 WHERE i2.institution = i.institution AND i2.effdt <= %CurrentDateIn) AND i.eff_status = 'A'

  • Related Language Record: SSR_APTSYM_INVL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description