SSR_IAM_EONFOVW

(SQL View)
 Index Back

Anon Grading run control view


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 , A.SSR_AC_EXAM_ONLY , A.DESCR50_1 , A.CRSE_ID , A.CRSE_OFFER_NBR , A.STRM , A.SSR_PERIOD_ID , A.ANONYMOUS_FLG , CASE WHEN A.ANONYMOUS_FLG = 'Y' THEN 'Replace' ELSE 'New' END , CASE WHEN A.SSR_IAM_RESIT_FLAG = 'Y' THEN 'Yes' ELSE 'No' END FROM PS_SSR_IAMCRSNFOVW A WHERE A.SSR_AC_EXAM_ONLY = 'Y' UNION SELECT B.INSTITUTION , B.EMPLID , B.SSR_ACTIVITY_ID , B.SSR_ACT_ID_SEQ_NBR , B.SSR_ACT_ID_ROOT , B.SSR_IAM_RESIT_FLAG , B.SSR_AC_EXAM_ONLY , B.DESCR50_1 , B.CRSE_ID , B.CRSE_OFFER_NBR , B.STRM , B.SSR_PERIOD_ID , B.ANONYMOUS_FLG , CASE WHEN B.ANONYMOUS_FLG = 'Y' THEN 'Replace' ELSE 'New' END , CASE WHEN B.SSR_IAM_RESIT_FLAG = 'Y' THEN 'Yes' ELSE 'No' END FROM PS_SSR_IAMACTNFOVW B WHERE B.SSR_AC_EXAM_ONLY = 'Y'

# 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
14 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
15 DESCRSHORT1 Character(10) VARCHAR2(10) NOT NULL Descr Short One