SAA_SCRTY_AAVW2 (SQL View)	Index Back
Advisement Report Prompt Table Advisement report prompt table which combines Security VIEW for advisement reports per Institution and validating student's career against careers attached to a report type.

SAA_SCRTY_AAVW2

(SQL View)

Advisement Report Prompt Table

Advisement report prompt table which combines Security VIEW for advisement reports per Institution and validating student's career against careers attached to a report type.

SELECT B.OPRID , A.INSTITUTION , A.TSCRPT_TYPE , A.DESCR , B.ACCESS_CD FROM PS_SAA_RPT_TYP_TBL A , PS_SAA_SCRTY_AARPT B WHERE B.INSTITUTION = A.INSTITUTION AND (B.TSCRPT_TYPE = A.TSCRPT_TYPE OR B.TSCRPT_TYPE= 'ALL') AND B.ACCESS_CD = 'Y' AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_SAA_RPT_TYP_TBL A1 WHERE A1.INSTITUTION = A.INSTITUTION AND A1.TSCRPT_TYPE = A.TSCRPT_TYPE AND A1.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Prompt Table: OPRDEFN2

2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Prompt Table: SCRTY_TBL_INST

3 TSCRPT_TYPE Character(5) VARCHAR2(5) NOT NULL Transcript Type
Prompt Table: TRANSCRIPT_TYPE

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

5 ACCESS_CD Character(1) VARCHAR2(1) NOT NULL Access Code
N=No Access
Y=Read/Write Access
Default Value: Y

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: OPRDEFN2
2	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Prompt Table: SCRTY_TBL_INST
3	TSCRPT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Transcript Type Prompt Table: TRANSCRIPT_TYPE
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	ACCESS_CD	Character(1)	VARCHAR2(1) NOT NULL	Access Code N=No Access Y=Read/Write Access Default Value: Y