SSR_APT_SYN_TVL

(SQL View)
 Index Back

SELECT r.institution , il.language_cd , il.descr FROM PS_SSR_APT_SYN_TRM r ,ps_institution_tbl i ,ps_institution_lng il WHERE i.institution = r.institution AND i.institution = il.institution AND i.effdt = il.effdt AND %EffdtCheck(institution_tbl i2, i, %CurrentDateIn) AND i.eff_status = 'A'

  • Related Language Record for SSR_APT_SYN_TVW

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

    Prompt Table: SSR_APT_SYN_TVW

    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description