SAA_RPTPRT_AET (SQL Table)	Index Back
Advisement Report Request This table is a state record used by the advisement report request batch generation process.

SAA_RPTPRT_AET

(SQL Table)

Advisement Report Request

This table is a state record used by the advisement report request batch generation process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

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

3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

4 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL

5 TSCRPT_TYPE Character(5) VARCHAR2(5) NOT NULL Transcript Type
Default Value: OPR_DEF_TBL_CS.SAA_TSCRPT_TYPE
Prompt Table: SAA_SCRTY_AAVW2

6 SAA_RPT_DT_FROM Date(10) DATE This field is used for selecting a from date to be used in a date range on the batch generation run control page.

7 SAA_RPT_DT_TO Date(10) DATE This field is used for selecting a to date to be used in a date range on the batch generation run control page.

8 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

9 SAA_TABLENAME Character(20) VARCHAR2(20) NOT NULL This field contains the name of the table being purged in the academic advisement purge process.

10 SAA_NEXT_SEQ_NBR Number(4,0) SMALLINT NOT NULL This field is used in Academic Advisement for creating the next analysis database sequence number.

11 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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

13 SAA_DATE Date(10) DATE This field is used in the application engine program to purge the analysis database

14 SAA_TIME Time(15) TIMESTAMP This field is used by the application engine process to purge the analysis database.

15 SAA_DATE_STR Character(10) VARCHAR2(10) NOT NULL This field is used to convert a date field to a string to be passed into the message log for application Engine processes

16 SAA_TIME_STR Character(15) VARCHAR2(15) NOT NULL This field is used to convert a time field to a string to be passed into the message log for application Engine processes

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL
5	TSCRPT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Transcript Type Default Value: OPR_DEF_TBL_CS.SAA_TSCRPT_TYPE Prompt Table: SAA_SCRTY_AAVW2
6	SAA_RPT_DT_FROM	Date(10)	DATE	This field is used for selecting a from date to be used in a date range on the batch generation run control page.
7	SAA_RPT_DT_TO	Date(10)	DATE	This field is used for selecting a to date to be used in a date range on the batch generation run control page.
8	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
9	SAA_TABLENAME	Character(20)	VARCHAR2(20) NOT NULL	This field contains the name of the table being purged in the academic advisement purge process.
10	SAA_NEXT_SEQ_NBR	Number(4,0)	SMALLINT NOT NULL	This field is used in Academic Advisement for creating the next analysis database sequence number.
11	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
12	ANALYSIS_DB_SEQ	Number(4,0)	SMALLINT NOT NULL	Analysis DB Sequence
13	SAA_DATE	Date(10)	DATE	This field is used in the application engine program to purge the analysis database
14	SAA_TIME	Time(15)	TIMESTAMP	This field is used by the application engine process to purge the analysis database.
15	SAA_DATE_STR	Character(10)	VARCHAR2(10) NOT NULL	This field is used to convert a date field to a string to be passed into the message log for application Engine processes
16	SAA_TIME_STR	Character(15)	VARCHAR2(15) NOT NULL	This field is used to convert a time field to a string to be passed into the message log for application Engine processes