SSR_STD_EXAM_VW(SQL View) |
Index Back |
|---|---|
HA EXAM SCHEDULE VIEWHA EXAM SCHEDULE VIEW |
| SELECT A.EMPLID ,B.STRM ,D.DESCR ,A.INSTITUTION ,A.ACAD_CAREER ,A.CLASS_NBR ,B.DESCR ,B.CRSE_ID ,B.CRSE_OFFER_NBR ,B.SESSION_CODE ,B.CLASS_SECTION ,B.SUBJECT ,E.DESCR ,B.CATALOG_NBR ,C.CLASS_EXAM_SEQ ,C.EXAM_TIME_CODE ,C.EXAM_DT ,C.EXAM_START_TIME ,C.EXAM_END_TIME ,C.FACILITY_ID ,C.CLASS_EXAM_TYPE ,C.COMBINED_EXAM FROM PS_STDNT_ENRL A , PS_CLASS_TBL B , PS_CLASS_EXAM C , PS_TERM_TBL D , PS_SUBJECT_TBL E WHERE A.STRM = B.STRM AND A.CLASS_NBR = B.CLASS_NBR AND A.INSTITUTION=B.INSTITUTION AND A.ENRL_STATUS_REASON IN ('ENRL','EWAT') AND B.CRSE_ID = C.CRSE_ID AND B.CRSE_OFFER_NBR = C.CRSE_OFFER_NBR AND B.STRM=C.STRM AND B.SESSION_CODE = C.SESSION_CODE AND B.CLASS_SECTION = C.CLASS_SECTION AND A.INSTITUTION = D.INSTITUTION AND A.ACAD_CAREER = D.ACAD_CAREER AND B.STRM = D.STRM AND A.INSTITUTION = E.INSTITUTION AND B.SUBJECT = E.SUBJECT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | STRM | Character(4) | VARCHAR2(4) NOT NULL | Term |
| 3 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 4 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 5 | 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 |
| 6 | CLASS_NBR | Number(5,0) | INTEGER NOT NULL | Class Nbr |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | CRSE_ID | Character(6) | VARCHAR2(6) NOT NULL | Course ID |
| 9 | CRSE_OFFER_NBR | Number(2,0) | SMALLINT NOT NULL | Course Offering Nbr |
| 10 | SESSION_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Session
1=Regular Academic Session 10W=10 Week 12W=Twelve Week 4W1=Four Week - First 4W2=Four Week - Second 4W3=Four Week - Third 4W4=Four Week - Fourth 6W1=Six Week - First 6W2=Six Week - Second 8W1=Eight Week - First 8W2=Eight Week - Second A11=Medical Period 1, 4 Weeks A12=Medical Period 1, 8 Weeks A13=Medical Pd 1, 12 Weeks A21=Medical Period 2, 4 Weeks A22=Medical Period 2, 8 Weeks A23=Medical Period 2, 12 Week FYR=Full Year MIN=Mini Session OEE=Open Entry/Open Exit SM1=Semester 1 SM2=Semester 2 |
| 11 | CLASS_SECTION | Character(4) | VARCHAR2(4) NOT NULL | Class Section |
| 12 | SUBJECT | Character(8) | VARCHAR2(8) NOT NULL | Subject Area |
| 13 | DESCR2 | Character(30) | VARCHAR2(30) NOT NULL | Descr2 |
| 14 | CATALOG_NBR | Character(10) | VARCHAR2(10) NOT NULL | Catalog Nbr |
| 15 | CLASS_EXAM_SEQ | Number(2,0) | SMALLINT NOT NULL | Class Exam Sequence Nbr |
| 16 | EXAM_TIME_CODE | Character(8) | VARCHAR2(8) NOT NULL | Exam Time Code |
| 17 | EXAM_DT | Date(10) | DATE | Exam Date |
| 18 | EXAM_START_TIME | Time(15) | TIMESTAMP | Exam Starting Time |
| 19 | EXAM_END_TIME | Time(15) | TIMESTAMP | Exam Ending Time |
| 20 | FACILITY_ID | Character(10) | VARCHAR2(10) NOT NULL | Facility ID |
| 21 | CLASS_EXAM_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Class Exam Type
FIN=Final Exam MAK=Makeup of Final Exam |
| 22 | COMBINED_EXAM | Character(1) | VARCHAR2(1) NOT NULL | Combined Exam |