SSR_ANIDGENVW

(SQL View)
Index Back

AnonRun Control Preview


SELECT A.INSTITUTION , A.EMPLID , AA.NAME_DISPLAY , 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 , AC.SUBJECT , AC.CATALOG_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 , PS_HCR_PERSON_NM_I AA , PS_CRSE_OFFER AC WHERE A.EMPLID= AA.EMPLID AND AC.CRSE_ID =A.CRSE_ID AND AC.CRSE_OFFER_NBR = A.CRSE_OFFER_NBR UNION SELECT B.INSTITUTION , B.EMPLID , BB.NAME_DISPLAY , 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 , BC.SUBJECT , BC.CATALOG_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 , PS_HCR_PERSON_NM_I BB , PS_CRSE_OFFER BC WHERE B.EMPLID= BB.EMPLID AND BC.CRSE_ID = B.CRSE_ID AND BC.CRSE_OFFER_NBR = B.CRSE_OFFER_NBR

# 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 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
4 SSR_ACTIVITY_ID Character(11) VARCHAR2(11) NOT NULL Academic Activity ID
5 SSR_ACT_ID_SEQ_NBR Number(4,0) SMALLINT NOT NULL Activity ID Sequence Number
6 SSR_ACT_ID_ROOT Character(11) VARCHAR2(11) NOT NULL Course Root Activity ID
7 SSR_IAM_RESIT_FLAG Character(1) VARCHAR2(1) NOT NULL Resit
8 SSR_AC_EXAM_ONLY Character(1) VARCHAR2(1) NOT NULL Exam Only Course
9 DESCR50_1 Character(50) VARCHAR2(50) NOT NULL Description of length 50
10 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
11 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
12 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area
13 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
14 STRM Character(4) VARCHAR2(4) NOT NULL Term
15 SSR_PERIOD_ID Character(12) VARCHAR2(12) NOT NULL Academic Period ID

Prompt Table: SSR_PERIOD_TBL

16 ANONYMOUS_FLG Character(1) VARCHAR2(1) NOT NULL Anonymous
17 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
18 DESCRSHORT1 Character(10) VARCHAR2(10) NOT NULL Descr Short One