SSR_SCRTYTS2_VW (SQL View)	Index Back
OprID Inst / Transcript Typ VW Security VIEW for Transcript Types per Institution

SSR_SCRTYTS2_VW

(SQL View)

OprID Inst / Transcript Typ VW

Security VIEW for Transcript Types per Institution

SELECT B.OPRID ,A.INSTITUTION ,A.TSCRPT_TYPE ,B.ACCESS_CD FROM PS_SSR_TSCRPT_TYPE A , PS_SSR_SCRTY_TSRPT B WHERE B.ACCESS_CD = 'Y' AND B.INSTITUTION = A.INSTITUTION AND (B.TSCRPT_TYPE = A.TSCRPT_TYPE OR B.TSCRPT_TYPE= 'ALL') AND A.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_SSR_TSCRPT_TYPE C WHERE A.INSTITUTION =C.INSTITUTION AND A.TSCRPT_TYPE = C.TSCRPT_TYPE AND C.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: SSR_TSCRPT_TYPE

4 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: SSR_TSCRPT_TYPE
4	ACCESS_CD	Character(1)	VARCHAR2(1) NOT NULL	Access Code N=No Access Y=Read/Write Access Default Value: Y