SAA_RPT_CRSX_VW (SQL View)	Index Back
Advising Report Courses Used This view is used to retrieve and hold courses used in the results to be used in creating a hard copy report in academic advising. This view is used to hold courses excluded from a specific requirement.

SAA_RPT_CRSX_VW

(SQL View)

Advising Report Courses Used

This view is used to retrieve and hold courses used in the results to be used in creating a hard copy report in academic advising. This view is used to hold courses excluded from a specific requirement.

SELECT A.EMPLID , A.ANALYSIS_DB_SEQ , A.SAA_CAREER_RPT , A.SAA_ENTRY_SEQ , A.SAA_COURSE_SEQ , A.CRSE_TAG , A.RPT_DATE , A.TSCRPT_TYPE , A.SAA_RPT_IDENTIFIER , A.RQRMNT_GROUP , A.RQ_GRP_LINE_NBR , A.REQUIREMENT , A.RQ_LINE_NBR , A.SEL_PROCESS_TYPE , A.SEL_MODE , B.CRSE_ID , B.SUBJECT , B.CATALOG_NBR , B.SAA_CRS_TTL_DESCR , B.STRM , B.SAA_TERM_DESCRSHRT , B.CRSE_GRADE_OFF , B.REPEAT_CODE , B.SAA_REPEAT_DESCR , B.CRS_TOPIC_ID , B.SAA_TOPIC_DESCR , B.RQMNT_DESIGNTN , B.SAA_RQ_DESGN_DESCR , A.IN_PROGRESS_GRD , A.UNT_TAKEN , A.UNT_EARNED , A.CRSE_COUNT , A.RQ_AA_OVERRIDE , A.ASOF_DATE , A.DIRCT_TYPE , A.SAA_DISPLAY_OPTION , A.SAA_OPRID_NAME , A.OPRID , A.DESCR254A FROM PS_SAA_ADB_CRSEUSE A , PS_SAA_RPT_CRSE_VW B WHERE A.EMPLID = B.EMPLID AND A.ANALYSIS_DB_SEQ = B.ANALYSIS_DB_SEQ AND A.SAA_CAREER_RPT = B.SAA_CAREER_RPT AND A.CRSE_TAG = B.CRSE_TAG

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 CRSE_TAG Character(4) VARCHAR2(4) NOT NULL Course Tag

7 RPT_DATE Date(10) DATE NOT NULL Report Date

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

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

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

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

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

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

14 SEL_PROCESS_TYPE Character(3) VARCHAR2(3) NOT NULL Selection process type

15 SEL_MODE Character(1) VARCHAR2(1) NOT NULL Selection Mode

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

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

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

19 SAA_CRS_TTL_DESCR Character(30) VARCHAR2(30) NOT NULL This field is used in advising report views for displaying the description of the course.

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

21 SAA_TERM_DESCRSHRT Character(10) VARCHAR2(10) NOT NULL This field is used in the advising report views to display the short term description.

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

23 REPEAT_CODE Character(4) VARCHAR2(4) NOT NULL Repeat Code
NTEA=No Taking Exam/Assessment

24 SAA_REPEAT_DESCR Character(30) VARCHAR2(30) NOT NULL This field is used in advising report views for displaying the description of the repeat code.

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

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

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

28 SAA_RQ_DESGN_DESCR Character(30) VARCHAR2(30) NOT NULL This field is used in advising report views for displaying the description of the requirement designation code.

29 IN_PROGRESS_GRD Character(1) VARCHAR2(1) NOT NULL In Progress Grade
Y/N Table Edit

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

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

32 CRSE_COUNT Number(5,2) DECIMAL(4,2) NOT NULL Course Count

33 RQ_AA_OVERRIDE Character(9) VARCHAR2(9) NOT NULL Advisement Override

34 ASOF_DATE Date(10) DATE This field is used all over campus solutions to hold the value of an as of date to be used in different processing.

35 DIRCT_TYPE Character(1) VARCHAR2(1) NOT NULL Course directive type
S=Substitute
X=Exclude

36 SAA_DISPLAY_OPTION Character(1) VARCHAR2(1) NOT NULL This field will control if items will print/display in Academic Advisement Reports
N=Display Name
O=Display Operator
X=Do Not Display

37 SAA_OPRID_NAME Character(50) VARCHAR2(50) NOT NULL This field is used to display the name of the oprid when requesting advising reports.

38 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

39 SAA_OVRD_DESCR254 Character(254) VARCHAR2(254) NOT NULL This field is used by the analysis database results views and displays the description to display from an override.

#	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	CRSE_TAG	Character(4)	VARCHAR2(4) NOT NULL	Course Tag
7	RPT_DATE	Date(10)	DATE NOT NULL	Report Date
8	TSCRPT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Transcript Type
9	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.
10	RQRMNT_GROUP	Character(6)	VARCHAR2(6) NOT NULL	Requirement Group Prompt Table: RQ_GRP_TBL
11	RQ_GRP_LINE_NBR	Character(4)	VARCHAR2(4) NOT NULL	Group Line Nbr
12	REQUIREMENT	Character(9)	VARCHAR2(9) NOT NULL	Academic Requirement Prompt Table: RQ_MAIN_TBL
13	RQ_LINE_NBR	Character(4)	VARCHAR2(4) NOT NULL	Line Nbr
14	SEL_PROCESS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Selection process type
15	SEL_MODE	Character(1)	VARCHAR2(1) NOT NULL	Selection Mode
16	CRSE_ID	Character(6)	VARCHAR2(6) NOT NULL	Course ID
17	SUBJECT	Character(8)	VARCHAR2(8) NOT NULL	Subject Area
18	CATALOG_NBR	Character(10)	VARCHAR2(10) NOT NULL	Catalog Nbr
19	SAA_CRS_TTL_DESCR	Character(30)	VARCHAR2(30) NOT NULL	This field is used in advising report views for displaying the description of the course.
20	STRM	Character(4)	VARCHAR2(4) NOT NULL	Term
21	SAA_TERM_DESCRSHRT	Character(10)	VARCHAR2(10) NOT NULL	This field is used in the advising report views to display the short term description.
22	CRSE_GRADE_OFF	Character(3)	VARCHAR2(3) NOT NULL	Official Grade
23	REPEAT_CODE	Character(4)	VARCHAR2(4) NOT NULL	Repeat Code NTEA=No Taking Exam/Assessment
24	SAA_REPEAT_DESCR	Character(30)	VARCHAR2(30) NOT NULL	This field is used in advising report views for displaying the description of the repeat code.
25	CRS_TOPIC_ID	Number(3,0)	SMALLINT NOT NULL	Course Topic ID
26	SAA_TOPIC_DESCR	Character(30)	VARCHAR2(30) NOT NULL	This field is used in advising report views for displaying the description of the topic.
27	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.
28	SAA_RQ_DESGN_DESCR	Character(30)	VARCHAR2(30) NOT NULL	This field is used in advising report views for displaying the description of the requirement designation code.
29	IN_PROGRESS_GRD	Character(1)	VARCHAR2(1) NOT NULL	In Progress Grade Y/N Table Edit
30	UNT_TAKEN	Number(6,2)	DECIMAL(5,2) NOT NULL	Units Taken
31	UNT_EARNED	Number(6,2)	DECIMAL(5,2) NOT NULL	Units Earned
32	CRSE_COUNT	Number(5,2)	DECIMAL(4,2) NOT NULL	Course Count
33	RQ_AA_OVERRIDE	Character(9)	VARCHAR2(9) NOT NULL	Advisement Override
34	ASOF_DATE	Date(10)	DATE	This field is used all over campus solutions to hold the value of an as of date to be used in different processing.
35	DIRCT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Course directive type S=Substitute X=Exclude
36	SAA_DISPLAY_OPTION	Character(1)	VARCHAR2(1) NOT NULL	This field will control if items will print/display in Academic Advisement Reports N=Display Name O=Display Operator X=Do Not Display
37	SAA_OPRID_NAME	Character(50)	VARCHAR2(50) NOT NULL	This field is used to display the name of the oprid when requesting advising reports.
38	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
39	SAA_OVRD_DESCR254	Character(254)	VARCHAR2(254) NOT NULL	This field is used by the analysis database results views and displays the description to display from an override.