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

SAA_RPT_HDR_VW

(SQL View)

Advising Report Header 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 , C.SAA_CAREER_RPT , D.NAME_DISPLAY , D.NAME , A.RPT_DATE , A.INSTITUTION , A.TSCRPT_TYPE , B.DESCRFORMAL , A.OPRID , ' ' , C.RPT_DATE , A.ASOF_DATE , A.WHAT_IF_FL , ' ' , A.SAA_RPT_IDENTIFIER FROM PS_SAA_RPT_RQST A , PS_SAA_RPT_TYP_TBL B , PS_SAA_ADB_REPORT C , PS_SCC_PRI_NAME_VW D WHERE A.INSTITUTION = B.INSTITUTION AND A.TSCRPT_TYPE = B.TSCRPT_TYPE AND B.EFFDT = ( SELECT MAX (B1.EFFDT) FROM PS_SAA_RPT_TYP_TBL B1 WHERE B.INSTITUTION = B1.INSTITUTION AND B.TSCRPT_TYPE = B1.TSCRPT_TYPE AND B1.EFFDT <= A.RPT_DATE) AND A.EMPLID = C.EMPLID AND A.ANALYSIS_DB_SEQ = C.ANALYSIS_DB_SEQ AND A.EMPLID = D.EMPLID

# 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 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country

5 SAA_SORT_NAME Character(50) VARCHAR2(50) NOT NULL This field is used to put names in for sorting for AA printing.

6 RPT_DATE Date(10) DATE Report Date

7 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

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

9 DESCRFORMAL Character(50) VARCHAR2(50) NOT NULL Formal Description field

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

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

12 SAA_PROCESSED_DATE Date(10) DATE This field is used in Academic Advisement to track when a report request has been processed.

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

14 WHAT_IF_FL Character(1) VARCHAR2(1) NOT NULL Use Career Simulation

15 SAA_RPT_WHIF_DESCR Character(50) VARCHAR2(50) NOT NULL This field is used in the views for reporting to display the what-if notification in the header of the report.

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

#	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	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
5	SAA_SORT_NAME	Character(50)	VARCHAR2(50) NOT NULL	This field is used to put names in for sorting for AA printing.
6	RPT_DATE	Date(10)	DATE	Report Date
7	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
8	TSCRPT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Transcript Type
9	DESCRFORMAL	Character(50)	VARCHAR2(50) NOT NULL	Formal Description field
10	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
11	SAA_OPRID_NAME	Character(50)	VARCHAR2(50) NOT NULL	This field is used to display the name of the oprid when requesting advising reports.
12	SAA_PROCESSED_DATE	Date(10)	DATE	This field is used in Academic Advisement to track when a report request has been processed.
13	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.
14	WHAT_IF_FL	Character(1)	VARCHAR2(1) NOT NULL	Use Career Simulation
15	SAA_RPT_WHIF_DESCR	Character(50)	VARCHAR2(50) NOT NULL	This field is used in the views for reporting to display the what-if notification in the header of the report.
16	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.