SAA_PURGE_AET

#	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
5	TSCRPT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Transcript Type Prompt Table: TRANSCRIPT_TYPE
6	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
7	REQUEST_DT_FROM	Date(10)	DATE	Request Date From
8	REQUEST_DT_TO	Date(10)	DATE	Request Date To
9	REP_REQ_NBR_FROM	Character(9)	VARCHAR2(9) NOT NULL	Report Request Number Prompt Table: SA_REQUEST_HDR
10	REP_REQ_NBR_TO	Character(9)	VARCHAR2(9) NOT NULL	Report Request Nbr To Prompt Table: SA_REQUEST_HDR
11	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
12	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.
13	RPT_DATE	Date(10)	DATE	Report Date
14	RPT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	This field is the type of Academic Advisement report and is used by the tables in the Analysis Database. This field is reserved for use by SA. SPC=Special Report STD=Standard Report
15	ANALYSIS_DB_SEQ	Number(4,0)	SMALLINT NOT NULL	Analysis DB Sequence
16	SAA_ANAL_DB_SEQ_CH	Character(4)	VARCHAR2(4) NOT NULL	This field is used for converting the analysis database sequence number to a character string to be used as a parameter in a message.
17	FIRST_TIME	Character(1)	VARCHAR2(1) NOT NULL	First time through process Y/N Table Edit Default Value: Y
18	SAA_TSCRPT_PURGE	Character(1)	VARCHAR2(1) NOT NULL	This field is used in academic advisement to track if the transcript request and results tables need to be purged when the analysis database is purged. Y/N Table Edit
19	SAA_RQST_PURGE	Character(1)	VARCHAR2(1) NOT NULL	This field is used in academic advisement to track if the report request and request logs need to be purged when the report results are purged.
20	SAA_PURGE_ALL	Character(1)	VARCHAR2(1) NOT NULL	This field is used as a flag to purge all records in the tables in the analysis database N=Select Results to Purge Y=Purge All Results
21	SAA_OPRID	Character(30)	VARCHAR2(30) NOT NULL	This field is used for processing a second oprid field in academic advisement.
22	REPORT_REQUEST_NBR	Character(9)	VARCHAR2(9) NOT NULL	Report Request Nbr
23	REQUEST_SEQ_NBR	Number(5,0)	INTEGER NOT NULL	Request Seq Nbr
24	REPORT_NUMBER	Number(2,0)	SMALLINT NOT NULL	Report Number
25	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
26	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
27	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
28	MSG_SEVERITY	Character(1)	VARCHAR2(1) NOT NULL	Message Severity C=Cancel E=Error M=Message W=Warning
29	SA_MESSAGE_PARM	Character(30)	VARCHAR2(30) NOT NULL	Message Parameter Text
30	SAA_DATE	Date(10)	DATE	This field is used in the application engine program to purge the analysis database
31	SAA_TIME	Time(15)	TIMESTAMP	This field is used by the application engine process to purge the analysis database.
32	SAA_TABLENAME	Character(20)	VARCHAR2(20) NOT NULL	This field contains the name of the table being purged in the academic advisement purge process.
33	SAA_ROW_COUNT	Number(10,0)	DECIMAL(10) NOT NULL	This field is a row counter used by academic advisement.
34	SAA_TOTAL_ROWS	Number(10,0)	DECIMAL(10) NOT NULL	This field is a row counter used by academic advisement.
35	WHERE_CLAUSE1	Character(254)	VARCHAR2(254) NOT NULL	Where Clause
36	SAA_WHERE_CLAUSE	Long Character	CLOB	This field contains the where clause used in different processes in academic advisement.
37	WHERE_LONG	Long Character	CLOB	Where Clause