SSR_REQS_HDR_VW

(SQL View)
 Index Back

Post Requisite Report View

This view is used to hold the data used to create the xml data file for the post enrollment requisite check report. This view may not work correctly for selecting data as it is meant to be used in a file layout to create the xml report.

SELECT A.INSTITUTION ,A.STRM ,A.CLASS_NBR ,A.SUBJECT ,A.CATALOG_NBR ,A.SESSION_CODE ,A.CLASS_SECTION ,A.CRSE_ID ,A.CRSE_OFFER_NBR ,A.ACAD_ORG ,A.ACAD_GROUP ,A.CAMPUS ,A.CRS_TOPIC_ID ,A.SSR_COMPONENT ,A.ACAD_CAREER ,A.DESCR ,B.TERM_BEGIN_DT ,D.RQRMNT_GROUP ,C.USE_CATLG_RQS ,C.RQRMNT_GROUP ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' , 0 ,' ' ,' ' ,' ' FROM PS_CLASS_TBL A , PS_TERM_TBL B , PS_CLASS_ASSOC C , PS_CRSE_OFFER D WHERE B.INSTITUTION = A.INSTITUTION AND B.ACAD_CAREER = A.ACAD_CAREER AND B.STRM= A.STRM AND C.CRSE_ID = A.CRSE_ID AND C.CRSE_OFFER_NBR = A.CRSE_OFFER_NBR AND C.STRM = A.STRM AND C.SESSION_CODE = A.SESSION_CODE AND C.ASSOCIATED_CLASS = A.ASSOCIATED_CLASS AND D.CRSE_ID = A.CRSE_ID AND D.CRSE_OFFER_NBR = A.CRSE_OFFER_NBR AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_CRSE_OFFER D1 WHERE D1.CRSE_ID = D.CRSE_ID AND D1.CRSE_OFFER_NBR = D.CRSE_OFFER_NBR AND D1.EFFDT <= B.TERM_BEGIN_DT) AND A.CLASS_TYPE = 'E'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

2 STRM Character(4) VARCHAR2(4) NOT NULL Term

Default Value: OPR_DEF_TBL_CS.STRM

Prompt Table: TERM_VAL_TBL

3 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
4 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area

Default Value: OPR_DEF_TBL_CS.SUBJECT

Prompt Table: SUBJECT_TBL

5 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
6 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
7 CLASS_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section
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 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization
11 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group
12 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
13 CRS_TOPIC_ID Number(3,0) SMALLINT NOT NULL Course Topic ID
14 SSR_COMPONENT Character(3) VARCHAR2(3) NOT NULL Course Component.
CLN=Clinical
CON=Continuance
DIS=Discussion
FLD=Field Studies
IND=Independent Study
LAB=Laboratory
LEC=Lecture
PRA=Practicum
RSC=Research
SEM=Seminar
SUP=Supervision
THE=Thesis Research
TUT=Tutorial
15 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
16 DESCR Character(30) VARCHAR2(30) NOT NULL Description
17 TERM_BEGIN_DT Date(10) DATE Term Begin Date
18 RQRMNT_GROUP Character(6) VARCHAR2(6) NOT NULL Requirement Group
19 USE_CATLG_RQS Character(1) VARCHAR2(1) NOT NULL Also Use Catalog Requisite
20 SSR_RQRMNT_GRP2 Character(6) VARCHAR2(6) NOT NULL Requirement Group
21 SSR_ENRL_STATUS_WK Character(2) VARCHAR2(2) NOT NULL Student Enrollment Status
A=All
D=Dropped
E=Enrolled
W=Waiting
22 SSR_REQS_DSPLY_OPT Character(1) VARCHAR2(1) NOT NULL Select Display Option
C=Combined View
D=Detail View
S=Summary View
23 INST_DESCRFORMAL Character(50) VARCHAR2(50) NOT NULL Institution Formal Description
24 STRM_DESCR Character(30) VARCHAR2(30) NOT NULL Term Description
25 SSR_DESCR_SESSION Character(30) VARCHAR2(30) NOT NULL Session description used for the post enrollment requisite checking report.
26 SSR_TOPIC_DESCR Character(30) VARCHAR2(30) NOT NULL Course Topic
27 SSR_COMPONENTDESCR Character(30) VARCHAR2(30) NOT NULL This field is used to create the xml data file for the post enrollment requisite check report.
28 DESCR_CAREER Character(30) VARCHAR2(30) NOT NULL Description
29 SSR_TITLE_1 Character(100) VARCHAR2(100) NOT NULL This field contains the line 1 title for the post enrollment requisite check report.
30 SSR_TITLE_2 Character(100) VARCHAR2(100) NOT NULL This field contains the line 2 title for the post enrollment requisite check report.
31 COURSE_TITLE_LONG Character(100) VARCHAR2(100) NOT NULL Long Course Title
32 SSR_STDNT_CNT Number(4,0) SMALLINT NOT NULL This field contains the number of students in a class to be reported in the post enrollment requisite check report.
33 SSR_ENRL_REQ_LBL Character(100) VARCHAR2(100) NOT NULL This field contains the enrollment requirement label for the post enrollment requisite check report.
34 SSR_TITLE_DESCR Character(254) VARCHAR2(254) NOT NULL This field is used for holding the class title description used in the xml file for post enrollment requisite check reports.
35 SSR_NO_STDNT_DESCR Character(100) VARCHAR2(100) NOT NULL This field contains the no students to report message for the post enrollment requisite check report.