SSR_AC_ITEMCLVW

(SQL View)
 Index Back

Activity Content Types

Activity Content Definition Content Types (Activity Definition).

SELECT I.SSR_AC_CONTX_TYPE ,I.SSR_AC_CONTENT_TP ,L.LANGUAGE_CD ,L.DESCR ,L.DESCR20 ,I.SSR_AC_ROOT ,I.SSR_ITEM_LVL 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_ROOT <> 'Y' AND I.SSR_AC_RESTRICTED <> 'Y'

  • Related Language Record for SSR_AC_ITEMCVW

  • 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_CONT_TPSH 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
    5 DESCR20 Character(20) VARCHAR2(20) NOT NULL Description
    6 SSR_AC_ROOT Character(1) VARCHAR2(1) NOT NULL Content Root

    Y/N Table Edit

    Default Value: N

    7 SSR_ITEM_LVL Number(4,0) SMALLINT NOT NULL Item Order