SAA_RPTRQSTADD

(SQL View)
 Index Back

Advisement Request Search

This search record is used to add a new advisement report request.

SELECT B.OPRID , A.EMPLID , A.INSTITUTION , A.TSCRPT_TYPE , A.ANALYSIS_DB_SEQ 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)

  • 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: STDNT_SRCH

    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_SCRTY_TP_VW

    5 ANALYSIS_DB_SEQ Number(4,0) SMALLINT NOT NULL Analysis DB Sequence