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