SSR_APTSYT_PRVL

(SQL View)
 Index Back

APT Sync Search View for Prog


SELECT DISTINCT t.acad_prog , pl.language_cd , pl.descr FROM PS_SSR_APT_SYN_TRK t ,ps_acad_prog_tbl p ,ps_acad_prog_lang pl WHERE p.institution = t.institution AND p.acad_prog = t.acad_prog AND p.institution = pl.institution AND p.acad_prog = pl.acad_prog AND p.effdt = pl.effdt 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 for SSR_APTSYT_PRVW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description