SAA_MRPT_TYP_VW

(SQL View)
 Index Back

AA Multi Report Security View

This view is used by Request Multiple AA Reports. It picks only the correct report types, what-if report types, for which an oprid has been authorized.

SELECT A.OPRID , A.INSTITUTION , B.TSCRPT_TYPE , B.DESCR FROM PS_SAA_SCRTY_AARPT A , PS_SAA_RPT_TYP_TBL B WHERE A.INSTITUTION = B.INSTITUTION AND (A.TSCRPT_TYPE = 'ALL' OR 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 <= %CurrentDateIn) AND B.SAA_INCL_WHIF_INFO = 'N'

  • Related Language Record: SAA_MRPT_TYP_LV

    • # 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 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    3 TSCRPT_TYPE Character(5) VARCHAR2(5) NOT NULL Transcript Type
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description