SAA_RPTRQSTSRCH (SQL View)	Index Back
Advisement Request Search This record is the search view for the new advisement report request component.

SAA_RPTRQSTSRCH

(SQL View)

Advisement Request Search

This record is the search view for the new advisement report request component.

SELECT B.OPRID , A.EMPLID , A.INSTITUTION , A.TSCRPT_TYPE , A.RPT_DATE , A.ANALYSIS_DB_SEQ , A.SAA_RPT_IDENTIFIER , A.OPRID , A.SAA_PROCESSED_DATE , A.SAA_PROCESSING_CD 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_EMPRPTTP_VW

5 RPT_DATE Date(10) DATE Report Date
Default Value: %Date

6 ANALYSIS_DB_SEQ Number(4,0) SMALLINT NOT NULL Report Sequence

7 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

8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

9 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

10 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

#	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_EMPRPTTP_VW
5	RPT_DATE	Date(10)	DATE	Report Date Default Value: %Date
6	ANALYSIS_DB_SEQ	Number(4,0)	SMALLINT NOT NULL	Report Sequence
7	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
8	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
9	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
10	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