SSR_ANON_MPREV

(SQL View)
Index Back

Anon Grading Manual select vw


SELECT A.INSTITUTION , B.STRM , A.EMPLID , F.NAME_DISPLAY , C.SUBJECT , C.CATALOG_NBR , E.DESCR , B.DESCR50_1 , A.SSR_ACTIVITY_ID , B.DESCRSHORT , B.DESCRSHORT1 , A.SSR_ACT_ORG_SQ_NBR , B.SSR_AC_EXAM_ONLY , C.ACAD_CAREER , C.ACAD_ORG FROM PS_SSR_IAM A , PS_SSR_IAMALLNFOVW B , PS_CRSE_OFFER C , PS_TERM_TBL D , PS_CRSE_CATALOG E , PS_HCR_PERSON_NM_I F WHERE a.EMPLID = B.EMPLID AND A.EMPLID = F.EMPLID AND A.INSTITUTION = B.INSTITUTION AND A.SSR_ACTIVITY_ID = B.SSR_ACTIVITY_ID AND A.SSR_ACT_ID_SEQ_NBR = B.SSR_ACT_ID_SEQ_NBR AND B.INSTITUTION = C.INSTITUTION AND C.CRSE_ID = B.CRSE_ID AND C.CRSE_OFFER_NBR = B.CRSE_OFFER_NBR AND C.EFFDT = ( SELECT MAX(EFFDT) FROM PS_CRSE_OFFER G WHERE G.CRSE_ID = C.CRSE_ID AND G.CRSE_OFFER_NBR = C.CRSE_OFFER_NBR AND G.EFFDT <= D.TERM_BEGIN_DT) AND D.INSTITUTION = B.INSTITUTION AND B.STRM = D.STRM AND C.CRSE_ID = E.CRSE_ID AND E.EFFDT = ( SELECT MAX( H.EFFDT) FROM PS_CRSE_CATALOG H WHERE H.CRSE_ID = C.CRSE_ID AND H.EFFDT <= C.EFFDT) AND D.ACAD_CAREER = C.ACAD_CAREER

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 STRM Character(4) VARCHAR2(4) NOT NULL Term
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
5 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area
6 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
7 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
8 DESCR50_1 Character(50) VARCHAR2(50) NOT NULL Description of length 50
9 SSR_ACTIVITY_ID Character(11) VARCHAR2(11) NOT NULL Academic Activity ID
10 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
11 DESCRSHORT1 Character(10) VARCHAR2(10) NOT NULL Descr Short One
12 SSR_ACT_ORG_SQ_NBR Number(4,0) SMALLINT NOT NULL Original Activity ID Seq NBR
13 SSR_AC_EXAM_ONLY Character(1) VARCHAR2(1) NOT NULL Exam Only Course
14 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
15 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization