SSR_REQS_CRS_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.

SSR_REQS_CRS_VW

(SQL View)

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.EMPLID , A.ACAD_CAREER , A.SSR_REQS_TYPE , A.SSR_ENTRY_SEQ , A.SSR_COURSE_SEQ , A.TERM_TAKEN , A.SSR_CLASS_NBR , A.UNT_TAKEN , A.UNT_EARNED , A.CRSE_GRADE_OFF , A.SUBJECT , A.CATALOG_NBR , A.DESCR , ' ' , ' ' , %DateNull , %DateNull FROM PS_SSR_REQS_CRSEU A

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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 SSR_REQS_TYPE Character(1) VARCHAR2(1) NOT NULL Requisite Record Type
E=Enrollment
P=Post Enrollment

7 SSR_ENTRY_SEQ Number(4,0) SMALLINT NOT NULL This field is used in requisite checking to track the position of the results in the processing.

8 SSR_COURSE_SEQ Number(3,0) SMALLINT NOT NULL This field is used in the table SSR_REQCK_CRSEU to track multiple occurances of a course at the same entry sequence position in the table.

9 TERM_TAKEN Character(4) VARCHAR2(4) NOT NULL Term Taken

10 SSR_CLASS_NBR Number(5,0) INTEGER NOT NULL This field is used in the requisite results tables as the class number value of the field in the records. The CLASS_NBR field in those tables will be part of the key tied back to the STDNT_ENRL record.

11 UNT_TAKEN Number(6,2) DECIMAL(5,2) NOT NULL Units Taken

12 UNT_EARNED Number(6,2) DECIMAL(5,2) NOT NULL Units Earned

13 CRSE_GRADE_OFF Character(3) VARCHAR2(3) NOT NULL Official Grade

14 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area

15 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr

16 DESCR Character(30) VARCHAR2(30) NOT NULL Description

17 SSR_TERM_DESCR Character(30) VARCHAR2(30) NOT NULL This field is used transcript report tables to display the term description.

18 DESCR20 Character(20) VARCHAR2(20) NOT NULL Description

19 OEE_START_DT Date(10) DATE This is a date used for picking a start date for OEE rosters.

20 OEE_END_DT Date(10) DATE End Date

#	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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
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	SSR_REQS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Requisite Record Type E=Enrollment P=Post Enrollment
7	SSR_ENTRY_SEQ	Number(4,0)	SMALLINT NOT NULL	This field is used in requisite checking to track the position of the results in the processing.
8	SSR_COURSE_SEQ	Number(3,0)	SMALLINT NOT NULL	This field is used in the table SSR_REQCK_CRSEU to track multiple occurances of a course at the same entry sequence position in the table.
9	TERM_TAKEN	Character(4)	VARCHAR2(4) NOT NULL	Term Taken
10	SSR_CLASS_NBR	Number(5,0)	INTEGER NOT NULL	This field is used in the requisite results tables as the class number value of the field in the records. The CLASS_NBR field in those tables will be part of the key tied back to the STDNT_ENRL record.
11	UNT_TAKEN	Number(6,2)	DECIMAL(5,2) NOT NULL	Units Taken
12	UNT_EARNED	Number(6,2)	DECIMAL(5,2) NOT NULL	Units Earned
13	CRSE_GRADE_OFF	Character(3)	VARCHAR2(3) NOT NULL	Official Grade
14	SUBJECT	Character(8)	VARCHAR2(8) NOT NULL	Subject Area
15	CATALOG_NBR	Character(10)	VARCHAR2(10) NOT NULL	Catalog Nbr
16	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
17	SSR_TERM_DESCR	Character(30)	VARCHAR2(30) NOT NULL	This field is used transcript report tables to display the term description.
18	DESCR20	Character(20)	VARCHAR2(20) NOT NULL	Description
19	OEE_START_DT	Date(10)	DATE	This is a date used for picking a start date for OEE rosters.
20	OEE_END_DT	Date(10)	DATE	End Date