SSR_ACTIDRELRVW(SQL View) |
Index Back |
---|---|
Resit Activity related data vw |
SELECT A.INSTITUTION , B.SSR_ACTIVITY_ID , A.ACAD_ORG , A.ACAD_CAREER , B.CRSE_ID , B.STRM , B.SSR_PERIOD_ID , B.SSR_AC_EXAM_ONLY , A.CRSE_OFFER_NBR , A.SUBJECT , A.CATALOG_NBR FROM PS_SSR_ACT_XREF B , PS_CRSE_OFFER A WHERE B.SSR_AC_CONTENT_TP <> '1000' AND A.CRSE_ID = B.CRSE_ID AND A.CRSE_OFFER_NBR = B.CRSE_OFFER_NBR AND A.INSTITUTION = ( SELECT INSTITUTION FROM PS_SSR_ACTIVITY WHERE SSR_ACTIVITY_ID = B.SSR_ACTIVITY_ID) AND ((A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_CRSE_OFFER WHERE CRSE_ID = A.CRSE_ID AND INSTITUTION = A.INSTITUTION AND EFFDT <= ( SELECT TERM_BEGIN_DT FROM PS_TERM_TBL WHERE STRM = B.STRM AND INSTITUTION = A.INSTITUTION AND ACAD_CAREER = A.ACAD_CAREER) ) AND B.SSR_AC_EXAM_ONLY = 'N') OR (A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_CRSE_OFFER WHERE CRSE_ID = A.CRSE_ID AND INSTITUTION = A.INSTITUTION AND EFFDT <= ( SELECT SSR_PRD_START_DT FROM PS_SSR_PERIOD_TBL WHERE SSR_PERIOD_ID = B.SSR_PERIOD_ID AND INSTITUTION = A.INSTITUTION) AND 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 | SSR_ACTIVITY_ID | Character(11) | VARCHAR2(11) NOT NULL | Academic Activity ID |
3 | ACAD_ORG | Character(10) | VARCHAR2(10) NOT NULL | Academic Organization |
4 | ACAD_CAREER | Character(4) | VARCHAR2(4) NOT NULL |
Academic Career
BAC=Bachelor (NLD) BBL=Vocational Coaching (NLD) BOL=Vocational Training (NLD) BUSN=Graduate Business CNED=Continuing Education CRED=Semester Credit EDU=Education (NLD) EXED=Extended Education GRAD=Graduate LAW=Law MEDS=Medical School NONA=Non Award PGRD=Postgraduate RSCH=Research TECH=Technical UENG=Undergraduate Engineering UGRD=Undergraduate VAVO=Advanced General Educ. (NLD) VETM=Veterinary Medicine |
5 | CRSE_ID | Character(6) | VARCHAR2(6) NOT NULL | Course ID |
6 | SSR_AC_CONTENT_TP | Character(20) | VARCHAR2(20) NOT NULL | Academic Content Type |
7 | STRM | Character(4) | VARCHAR2(4) NOT NULL | Term |
8 | SSR_PERIOD_ID | Character(12) | VARCHAR2(12) NOT NULL | Academic Period ID |
9 | SSR_AC_EXAM_ONLY | Character(1) | VARCHAR2(1) NOT NULL | Exam Only Course |
10 | SUBJECT | Character(8) | VARCHAR2(8) NOT NULL | Subject Area |
11 | CATALOG_NBR | Character(10) | VARCHAR2(10) NOT NULL | Catalog Nbr |