SSR_APTSYT_PRVW

(SQL View)
 Index Back

APT Sync Search View for Prog


SELECT DISTINCT t.acad_prog , p.descr FROM PS_SSR_APT_SYN_TRK t ,ps_acad_prog_tbl p WHERE p.institution = t.institution AND p.acad_prog = t.acad_prog AND p.effdt = ( SELECT MAX(p2.effdt) FROM ps_acad_prog_tbl p2 WHERE p2.institution = p.institution AND p2.acad_prog = p.acad_prog AND p2.effdt <= %CurrentDateIn) AND p.eff_status = 'A'

  • Related Language Record: SSR_APTSYT_PRVL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

    Prompt Table: ACAD_PROG_TBL

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