SSR_AC_ACT_DESC

(SQL View)
 Index Back

Prompt Table

Prompt Table, Root Activities with Anon Grading set to active

SELECT A.INSTITUTION , A.SSR_ACTIVITY_ID , B.DESCR50 FROM PS_SSR_ACTIVITY A , PS_SSR_AC_REG_HDR B 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)

  • Related Language Record: SSR_AC_ACTLDESC

    • # 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 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50