SSR_AC_ACTRDESC

(SQL View)
Index Back

Resit Activities prompt table


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 %CurrentDateIn BETWEEN B.EFFDT AND B.END_EFFDT AND B.EFF_STATUS = 'A' AND EXISTS ( SELECT 'X' FROM PS_SSR_IAM WHERE INSTITUTION = A.INSTITUTION AND SSR_ACTIVITY_ID= A.SSR_ACTIVITY_ID AND SSR_IAM_ACT_STATUS = 'SR' ) AND EXISTS ( SELECT 'X' FROM ps_ssr_acmcont_itm WHERE ssr_activity_id = A.ssr_activity_id AND ssr_blind_graded = 'Y')

# 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