SAA_RPT_CRSA_VW (SQL View)	Index Back
Analysis DB Courses Available This view is used to retrieve and hold course display select line data to be used in creating a hard copy report in academic advising.

SAA_RPT_CRSA_VW

(SQL View)

Analysis DB Courses Available

This view is used to retrieve and hold course display select line data to be used in creating a hard copy report in academic advising.

SELECT A.EMPLID , A.ANALYSIS_DB_SEQ , A.SAA_CAREER_RPT , A.SAA_ENTRY_SEQ , A.SAA_COURSE_SEQ , A.RPT_DATE , A.TSCRPT_TYPE , A.SAA_RPT_IDENTIFIER , A.COURSE_LIST , A.EFFDT , A.R_COURSE_SEQUENCE , A.RQRMNT_GROUP , A.RQ_GRP_LINE_NBR , A.REQUIREMENT , A.RQ_LINE_NBR , A.SUBJECT , A.CATALOG_NBR , A.CRSE_ID , A.CRS_TOPIC_ID , ' ' , A.RQMNT_DESIGNTN , ' ' , A.DESCR , B.SAA_WHERE_CLAUSE FROM PS_SAA_ADB_CRSEAVL A , PS_CLST_DETL_TBL B WHERE A.COURSE_LIST = B.COURSE_LIST AND A.EFFDT = B.EFFDT AND A.R_COURSE_SEQUENCE = B.R_COURSE_SEQUENCE

Parent record: SAA_ADB_RESULTS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PEOPLE_SRCH

2 ANALYSIS_DB_SEQ Number(4,0) SMALLINT NOT NULL Analysis DB Sequence

3 SAA_CAREER_RPT Character(4) VARCHAR2(4) NOT NULL This field is used in academic advisement as a key to the results tables.
Prompt Table: ACAD_CAR_TBL

4 SAA_ENTRY_SEQ Number(4,0) SMALLINT NOT NULL This field is used in Academic Advisement to track the position of the output in the report.

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

6 RPT_DATE Date(10) DATE NOT NULL Report Date

7 TSCRPT_TYPE Character(5) VARCHAR2(5) NOT NULL Transcript Type

8 SAA_RPT_IDENTIFIER Character(10) VARCHAR2(10) NOT NULL This field is used to identify a specific run of Academic Advisement Reports within a report type.

9 COURSE_LIST Character(9) VARCHAR2(9) NOT NULL Course List

10 EFFDT Date(10) DATE Effective Date

11 R_COURSE_SEQUENCE Number(7,0) INTEGER NOT NULL Course Sequence

12 RQRMNT_GROUP Character(6) VARCHAR2(6) NOT NULL Requirement Group
Prompt Table: RQ_GRP_TBL

13 RQ_GRP_LINE_NBR Character(4) VARCHAR2(4) NOT NULL Group Line Nbr

14 REQUIREMENT Character(9) VARCHAR2(9) NOT NULL Academic Requirement
Prompt Table: RQ_MAIN_TBL

15 RQ_LINE_NBR Character(4) VARCHAR2(4) NOT NULL Line Nbr

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

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

18 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID

19 CRS_TOPIC_ID Number(3,0) SMALLINT NOT NULL Course Topic ID

20 SAA_TOPIC_DESCR Character(30) VARCHAR2(30) NOT NULL This field is used in advising report views for displaying the description of the topic.

21 RQMNT_DESIGNTN Character(4) VARCHAR2(4) NOT NULL This field is used to track the Requirement Designation attached to a course in Student Records. This field is also used for tracking information through Academic Advisement.

22 ITEM_R_STATUS Character(4) VARCHAR2(4) NOT NULL Item Status
COMP=Complete
EXMP=Exempted
FAIL=Fail

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

24 SAA_WHERE_DETAIL Long Character CLOB This field will contain the individual where clause for course list details to be passed to the academic advisement reporting routines to aid in displaying only the courses a student needs to see when trying to find courses from the advisement reports.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PEOPLE_SRCH
2	ANALYSIS_DB_SEQ	Number(4,0)	SMALLINT NOT NULL	Analysis DB Sequence
3	SAA_CAREER_RPT	Character(4)	VARCHAR2(4) NOT NULL	This field is used in academic advisement as a key to the results tables. Prompt Table: ACAD_CAR_TBL
4	SAA_ENTRY_SEQ	Number(4,0)	SMALLINT NOT NULL	This field is used in Academic Advisement to track the position of the output in the report.
5	SAA_COURSE_SEQ	Number(3,0)	SMALLINT NOT NULL	This field is used in the table SAA_ADB_CRSEUSE to track multiple occurances of a course at the same entry sequence position in the table.
6	RPT_DATE	Date(10)	DATE NOT NULL	Report Date
7	TSCRPT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Transcript Type
8	SAA_RPT_IDENTIFIER	Character(10)	VARCHAR2(10) NOT NULL	This field is used to identify a specific run of Academic Advisement Reports within a report type.
9	COURSE_LIST	Character(9)	VARCHAR2(9) NOT NULL	Course List
10	EFFDT	Date(10)	DATE	Effective Date
11	R_COURSE_SEQUENCE	Number(7,0)	INTEGER NOT NULL	Course Sequence
12	RQRMNT_GROUP	Character(6)	VARCHAR2(6) NOT NULL	Requirement Group Prompt Table: RQ_GRP_TBL
13	RQ_GRP_LINE_NBR	Character(4)	VARCHAR2(4) NOT NULL	Group Line Nbr
14	REQUIREMENT	Character(9)	VARCHAR2(9) NOT NULL	Academic Requirement Prompt Table: RQ_MAIN_TBL
15	RQ_LINE_NBR	Character(4)	VARCHAR2(4) NOT NULL	Line Nbr
16	SUBJECT	Character(8)	VARCHAR2(8) NOT NULL	Subject Area
17	CATALOG_NBR	Character(10)	VARCHAR2(10) NOT NULL	Catalog Nbr
18	CRSE_ID	Character(6)	VARCHAR2(6) NOT NULL	Course ID
19	CRS_TOPIC_ID	Number(3,0)	SMALLINT NOT NULL	Course Topic ID
20	SAA_TOPIC_DESCR	Character(30)	VARCHAR2(30) NOT NULL	This field is used in advising report views for displaying the description of the topic.
21	RQMNT_DESIGNTN	Character(4)	VARCHAR2(4) NOT NULL	This field is used to track the Requirement Designation attached to a course in Student Records. This field is also used for tracking information through Academic Advisement.
22	ITEM_R_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Item Status COMP=Complete EXMP=Exempted FAIL=Fail
23	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
24	SAA_WHERE_DETAIL	Long Character	CLOB	This field will contain the individual where clause for course list details to be passed to the academic advisement reporting routines to aid in displaying only the courses a student needs to see when trying to find courses from the advisement reports.