SSRACTROTLNGVW2

(SQL View)
 Index Back

Activity Root View - Language

Activity Root View (related langauge record for SSR_ACT_ROOTVW2).

SELECT R.SSR_ACTIVITY_ID ,R.INSTITUTION ,L.LANGUAGE_CD ,L.DESCR50 FROM PS_SSR_ACT_ROOTEXT R , PS_SSR_AC_REG_HDR H , PS_SSR_AC_RHDR_LNG L WHERE R.SSR_AC_CONTENT_ID = H.SSR_AC_CONTENT_ID AND R.INSTITUTION = H.INSTITUTION AND R.SSR_AC_EFFDT = H.EFFDT AND L.SSR_AC_CONTENT_ID = H.SSR_AC_CONTENT_ID AND L.INSTITUTION = H.INSTITUTION AND L.EFFDT = H.EFFDT

  • Related Language Record for SSR_ACT_ROOTVW2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SSR_ACTY_ID_SRCH Character(11) VARCHAR2(11) NOT NULL Academic Activity ID
    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50