SAA_MRPTRQSTSRH

(SQL View)
 Index Back

Multiple Report Request Search

Search record for Request Multiple Academic Advisement Reports.

SELECT A.REPORT_REQUEST_NBR , B.OPRID , A.INSTITUTION , A.TSCRPT_TYPE , A.RPT_DATE , A.SAA_RPT_IDENTIFIER , A.SAA_PROCESSED_DATE , A.SAA_PROCESSING_CD FROM PS_SAA_RPTRQST_HDR A , PS_SAA_SCRTY_AARPT B WHERE A.INSTITUTION = B.INSTITUTION AND (B.TSCRPT_TYPE = 'ALL' OR B.TSCRPT_TYPE = A.TSCRPT_TYPE) AND B.OPRID = A.OPRID

  • Parent record: STDNT_CAREER

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 REPORT_REQUEST_NBR Character(9) VARCHAR2(9) NOT NULL Report Request Nbr
    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.

    Prompt Table: PSOPRDEFN

    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

    5 RPT_DATE Date(10) DATE Report Date

    Default Value: %Date

    6 SAA_RPT_IDENTIFIER Character(10) VARCHAR2(10) NOT NULL This field is used to identify a specific run of Academic Advisement Reports within a report type.

    Prompt Table: SAA_IDENT_TBL

    7 SAA_PROCESSED_DATE Date(10) DATE This field is used in Academic Advisement to track when a report request has been processed.

    Default Value: %Date

    8 SAA_PROCESSING_CD Character(2) VARCHAR2(2) NOT NULL This field is used to track the status of an Academic Advisement Report as it is being generated.
    00=Completed Successfully
    10=Request Pending
    20=Request Processing
    30=Error Processing Request
    40=Request Canceled
    50=Report Results Purged

    Default Value: 10