SAA_RPT_CRSL_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_CRSL_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 EMPLID , ANALYSIS_DB_SEQ , SAA_CAREER_RPT , SAA_ENTRY_SEQ , SAA_COURSE_SEQ , RPT_DATE , TSCRPT_TYPE , SAA_RPT_IDENTIFIER , NULL FROM PS_SAA_ADB_CRSEAVL

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 SAA_DESCRLONG Long Character CLOB This field is used to display information in the new student view for academic 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	SAA_DESCRLONG	Long Character	CLOB	This field is used to display information in the new student view for academic advisement reports.