SSRACTROTLNGVW3

(SQL View)
 Index Back

Activity Root View - Language

Activity Root View (related langauge record for SSR_ACT_ROOTVW3).

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

  • Related Language Record for SSR_ACT_ROOTVW3

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    2 SSR_ACT_ID_ROOT Character(11) VARCHAR2(11) NOT NULL Course Root Activity ID

    Prompt Table: SSR_ACT_ROOTVW2

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50