SAA_MRPT_TYP_LV

(SQL View)
 Index Back

AA Multi Report Security View

Related Language View

SELECT B.LANGUAGE_CD , A.OPRID , A.INSTITUTION , B.TSCRPT_TYPE , B.DESCR FROM PS_SAA_SCRTY_AARPT A , PS_SAA_RPT_TYP_LNG 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_LNG B1 WHERE B.INSTITUTION = B1.INSTITUTION AND B.TSCRPT_TYPE = B1.TSCRPT_TYPE AND B1.EFFDT <= %CurrentDateIn) AND NOT EXISTS( SELECT 'X' FROM PS_SAA_RPT_TYP_TBL B2 WHERE B2.INSTITUTION = B.INSTITUTION AND B2.TSCRPT_TYPE = B.TSCRPT_TYPE AND B2.SAA_INCL_WHIF_INFO = 'N')

  • Related Language Record for SAA_MRPT_TYP_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    2 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.
    3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    4 TSCRPT_TYPE Character(5) VARCHAR2(5) NOT NULL Transcript Type
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description