SAA_ADB_CRSEAVL (SQL Table)	Index Back
Analysis DB Courses Available This table contains the list of courses that can be used to satisfy a requirement in the Academic Advisement Analysis Database. These are the values that are shown in the display select line.

SAA_ADB_CRSEAVL

(SQL Table)

Analysis DB Courses Available

This table contains the list of courses that can be used to satisfy a requirement in the Academic Advisement Analysis Database. These are the values that are shown in the display select line.

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

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

22 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	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.
21	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
22	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.