SSRACMITMOLNGVW

(SQL View)
 Index Back

Content Types - Language

Activity Content Definition Content Types (Activity Definition) - related language record for SSR_ACM_ITMOVVW.

SELECT I.SSR_AC_CONTX_TYPE ,I.SSR_AC_CONTENT_TP ,L.LANGUAGE_CD ,L.DESCR FROM PS_SSR_AC_ITEMTYPE I , PS_SSR_AC_ITYPELNG L WHERE I.SSR_AC_CONTX_TYPE = L.SSR_AC_CONTX_TYPE AND I.SSR_AC_CONTENT_TP = L.SSR_AC_CONTENT_TP AND I.SSR_CONTEXT_ACTIVE = 'Y' AND I.SSR_AC_STRUCT_UPD = 'Y'

  • Related Language Record for SSR_ACM_ITMOVVW

  • Parent record: SSR_AC_CONTEXT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SSR_AC_CONTX_TYPE Character(4) VARCHAR2(4) NOT NULL Academic Content Context Type
    CRSE=Coursework

    Default Value: CRSE

    2 SSR_AC_CONTENT_TP Character(20) VARCHAR2(20) NOT NULL Academic Content Type
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description