SAA_MRPTRQSTADD

(SQL View)
 Index Back

Multiple Report Request Add

Add Search record for Request Multiple Academic Advisement Reports.

SELECT D.OPRID , A.REPORT_REQUEST_NBR , C.INSTITUTION , C.TSCRPT_TYPE FROM PS_SAA_RPTRQST_HDR A , PS_SAA_RPTRQST_DTL B , PS_SAA_RPT_RQST C , PS_SAA_SCRTY_AARPT D WHERE A.REPORT_REQUEST_NBR = B.REPORT_REQUEST_NBR AND B.EMPLID = C.EMPLID AND B.ANALYSIS_DB_SEQ = C.ANALYSIS_DB_SEQ AND C.INSTITUTION = D.INSTITUTION AND (D.TSCRPT_TYPE = 'ALL' OR D.TSCRPT_TYPE = C.TSCRPT_TYPE)

  • Parent record: STDNT_CAREER

    • # 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.

    Prompt Table: PSOPRDEFN

    2 REPORT_REQUEST_NBR Character(9) VARCHAR2(9) NOT NULL Report Request Nbr
    3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

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

    Default Value: OPR_DEF_TBL_CS.SAA_TSCRPT_TYPE

    Prompt Table: SAA_MRPT_TYP_VW