SAA_EMPRPTTP_VW (SQL View)	Index Back
Report Type View This view is to pick up all valid report types for a specific student.

SAA_EMPRPTTP_VW

(SQL View)

Report Type View

This view is to pick up all valid report types for a specific student.

SELECT DISTINCT B.OPRID , A.EMPLID , A.INSTITUTION , A.TSCRPT_TYPE FROM PS_SAA_RPT_RQST A , PS_SAA_SCRTY_AARPT B WHERE A.INSTITUTION = B.INSTITUTION AND (B.TSCRPT_TYPE = 'ALL' OR B.TSCRPT_TYPE = A.TSCRPT_TYPE)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SSR_OPRID Character(30) VARCHAR2(30) NOT NULL This field is the UPPERCASE of OPRID. This field is needed to improve performance when searching the transcript request component. This field just be changes to Mixed case if the installation allows for Mixed-Case Operator IDs.

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

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

4 TSCRPT_TYPE Character(5) VARCHAR2(5) NOT NULL Report Type

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SSR_OPRID	Character(30)	VARCHAR2(30) NOT NULL	This field is the UPPERCASE of OPRID. This field is needed to improve performance when searching the transcript request component. This field just be changes to Mixed case if the installation allows for Mixed-Case Operator IDs.
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
4	TSCRPT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Report Type