SAA_RPT_PROG_VW (SQL View)	Index Back
Advising Report Career View This view is used to retrieve and hold data to be used in creating a hard copy report in academic advising.

SAA_RPT_PROG_VW

(SQL View)

Advising Report Career View

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

SELECT A.EMPLID , A.ANALYSIS_DB_SEQ , A.SAA_CAREER_RPT , B.ACAD_PROG , B.STDNT_CAR_NBR , C.DESCR , B.ACAD_PROG_TERM , D.DESCR , ' ' , E.ITEM_R_STATUS , ' ' FROM PS_SAA_ADB_REPORT A , PS_SAA_ADB_WHATIF B , PS_ACAD_PROG_TBL C , PS_TERM_TBL D , PS_SAA_ADB_RESULTS E WHERE A.EMPLID = B.EMPLID AND A.ANALYSIS_DB_SEQ = B.ANALYSIS_DB_SEQ AND A.SAA_CAREER_RPT = B.ACAD_CAREER AND B.ACAD_PROG <> ' ' AND B.ACAD_PLAN = ' ' AND D.INSTITUTION = A.INSTITUTION AND D.ACAD_CAREER = A.SAA_CAREER_RPT AND D.STRM = B.ACAD_PROG_TERM AND C.INSTITUTION = A.INSTITUTION AND C.ACAD_PROG = B.ACAD_PROG AND C.EFFDT = ( SELECT MAX (C1.EFFDT) FROM PS_ACAD_PROG_TBL C1 WHERE C1.INSTITUTION = C.INSTITUTION AND C1.ACAD_PROG = C.ACAD_PROG AND C1.EFFDT <= D.TERM_BEGIN_DT AND C1.EFF_STATUS = 'A') AND B.EMPLID = E.EMPLID AND B.ANALYSIS_DB_SEQ = E.ANALYSIS_DB_SEQ AND B.SAA_CAREER_RPT = E.SAA_CAREER_RPT AND B.ACAD_PROG = E.ACAD_PROG AND E.ENTRY_R_TYPE = 'KEYPRG'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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.

4 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

5 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr

6 SAA_PROG_DESCR Character(50) VARCHAR2(50) NOT NULL This field is used in the views for reporting to display the program description in the report.

7 ACAD_PROG_TERM Character(4) VARCHAR2(4) NOT NULL Academic program term

8 SAA_TERM_DESCR Character(30) VARCHAR2(30) NOT NULL This field is used in the advising report views to display the short term description.

9 SAA_DESCR80 Character(80) VARCHAR2(80) NOT NULL This field is used to display information in the new student view for academic advisement reports.

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

11 SAA_STATUS_DESCR Character(30) VARCHAR2(30) NOT NULL This field is used in advising report views for displaying the description of the status.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
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.
4	ACAD_PROG	Character(5)	VARCHAR2(5) NOT NULL	Academic Program
5	STDNT_CAR_NBR	Number(3,0)	SMALLINT NOT NULL	Student Career Nbr
6	SAA_PROG_DESCR	Character(50)	VARCHAR2(50) NOT NULL	This field is used in the views for reporting to display the program description in the report.
7	ACAD_PROG_TERM	Character(4)	VARCHAR2(4) NOT NULL	Academic program term
8	SAA_TERM_DESCR	Character(30)	VARCHAR2(30) NOT NULL	This field is used in the advising report views to display the short term description.
9	SAA_DESCR80	Character(80)	VARCHAR2(80) NOT NULL	This field is used to display information in the new student view for academic advisement reports.
10	ITEM_R_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Item Status COMP=Complete EXMP=Exempted FAIL=Fail
11	SAA_STATUS_DESCR	Character(30)	VARCHAR2(30) NOT NULL	This field is used in advising report views for displaying the description of the status.