SAA_RPT_CAR_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_CAR_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 , C.DESCR , A.SAA_RPT_DTTM_STAMP , B.CAR_REQ_TERM , D.DESCR , ' ' , E.ITEM_R_STATUS , ' ' FROM PS_SAA_ADB_REPORT A , PS_SAA_ADB_WHATIF B , PS_ACAD_CAR_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.CAR_REQ_TERM AND C.INSTITUTION = A.INSTITUTION AND C.ACAD_CAREER = A.SAA_CAREER_RPT AND C.EFFDT = ( SELECT MAX (C1.EFFDT) FROM PS_ACAD_CAR_TBL C1 WHERE C1.INSTITUTION = C.INSTITUTION AND C1.ACAD_CAREER = C.ACAD_CAREER AND C1.EFFDT <= D.TERM_BEGIN_DT AND C1.EFF_STATUS = 'A') AND A.EMPLID = E.EMPLID AND A.ANALYSIS_DB_SEQ = E.ANALYSIS_DB_SEQ AND A.SAA_CAREER_RPT = E.SAA_CAREER_RPT AND A.SAA_CAREER_RPT = E.ACAD_CAREER AND E.ENTRY_R_TYPE = 'KEYCAR'

# 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 SAA_CAREER_DESCR Character(50) VARCHAR2(50) NOT NULL This field is used in the views for reporting to display the career description in the report.

5 SAA_RPT_DTTM_STAMP DateTime(26) TIMESTAMP This field is used to track the date time stamp of when an advising report was processed.

6 CAR_REQ_TERM Character(4) VARCHAR2(4) NOT NULL Career requirement term used for AA.

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

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

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

10 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	SAA_CAREER_DESCR	Character(50)	VARCHAR2(50) NOT NULL	This field is used in the views for reporting to display the career description in the report.
5	SAA_RPT_DTTM_STAMP	DateTime(26)	TIMESTAMP	This field is used to track the date time stamp of when an advising report was processed.
6	CAR_REQ_TERM	Character(4)	VARCHAR2(4) NOT NULL	Career requirement term used for AA.
7	SAA_TERM_DESCR	Character(30)	VARCHAR2(30) NOT NULL	This field is used in the advising report views to display the short term description.
8	SAA_DESCR80	Character(80)	VARCHAR2(80) NOT NULL	This field is used to display information in the new student view for academic advisement reports.
9	ITEM_R_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Item Status COMP=Complete EXMP=Exempted FAIL=Fail
10	SAA_STATUS_DESCR	Character(30)	VARCHAR2(30) NOT NULL	This field is used in advising report views for displaying the description of the status.