SSR_AC_ACTLDESC

(SQL View)
 Index Back

Prompt Table

Prompt Table, Root Activities with Anon Grading set to active

SELECT A.INSTITUTION , A.SSR_ACTIVITY_ID , C.LANGUAGE_CD , C.DESCR50 FROM PS_SSR_ACTIVITY A , PS_SSR_AC_REG_HDR B , PS_SSR_AC_RHDR_LNG C WHERE A.SSR_AC_CONTENT_ID = B.SSR_AC_CONTENT_ID AND A.INSTITUTION = B.INSTITUTION AND A.SSR_AC_CONTENT_TP = '1000' AND %CurrentDateIn BETWEEN B.EFFDT AND B.END_EFFDT AND B.EFF_STATUS = 'A' AND EXISTS ( SELECT 'X' FROM PS_SSR_ACMCONT_ITM WHERE SSR_BLIND_GRADED = 'Y' AND SSR_ACTIVITY_ID = A.SSR_ACTIVITY_ID) AND A.SSR_AC_CONTENT_ID = C.SSR_AC_CONTENT_ID AND A.INSTITUTION = C.INSTITUTION

  • Related Language Record for SSR_AC_ACT_DESC

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