SSR_IAMCRSNFOVW

(SQL View)
 Index Back

Courses using AnonID


SELECT A.INSTITUTION , A.EMPLID , A.SSR_ACTIVITY_ID , A.SSR_ACT_ID_SEQ_NBR , A.SSR_ACT_ID_ROOT , A.SSR_IAM_RESIT_FLAG , E.SSR_AC_EXAM_ONLY , D.DESCR50 , E.CRSE_ID , E.CRSE_OFFER_NBR , E.STRM , E.SSR_PERIOD_ID , CASE WHEN ( SELECT COUNT(SSR_ANONYMOUS_ID) FROM PS_SSR_IAM_ANON_ID F WHERE A.SSR_ACTIVITY_ID = F.SSR_ACTIVITY_ID AND A.EMPLID = F.EMPLID AND A.SSR_ACT_ID_SEQ_NBR = F.SSR_ACT_ID_SEQ_NBR) > 0 THEN 'Y' ELSE 'N' END WITH_ANON_ID FROM PS_SSR_IAM A , PS_SSR_ACTIVITY B, PS_SSR_ACMCONT_ITM D, PS_SSR_ACT_XREF E WHERE A.SSR_ACTIVITY_ID = D.SSR_ACTIVITY_ID AND D.SSR_BLIND_GRADED = 'Y' AND A.INSTITUTION = D.INSTITUTION AND A.SSR_ACT_ID_ROOT = B.SSR_ACTIVITY_ID AND A.INSTITUTION = B.INSTITUTION AND A.SSR_ACTIVITY_ID = A.SSR_ACT_ID_ROOT AND A.SSR_ACT_ID_ROOT = E.SSR_ACTIVITY_ID AND E.SSR_AC_CONTENT_TP = '1000'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 SSR_ACTIVITY_ID Character(11) VARCHAR2(11) NOT NULL Academic Activity ID
4 SSR_ACT_ID_SEQ_NBR Number(4,0) SMALLINT NOT NULL Activity ID Sequence Number
5 SSR_ACT_ID_ROOT Character(11) VARCHAR2(11) NOT NULL Course Root Activity ID
6 SSR_IAM_RESIT_FLAG Character(1) VARCHAR2(1) NOT NULL Resit
7 SSR_AC_EXAM_ONLY Character(1) VARCHAR2(1) NOT NULL Exam Only Course
8 DESCR50_1 Character(50) VARCHAR2(50) NOT NULL Description of length 50
9 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
10 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
11 STRM Character(4) VARCHAR2(4) NOT NULL Term
12 SSR_PERIOD_ID Character(12) VARCHAR2(12) NOT NULL Academic Period ID

Prompt Table: SSR_PERIOD_TBL

13 ANONYMOUS_FLG Character(1) VARCHAR2(1) NOT NULL Anonymous