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 |