SAA_RPT_ERROR (SQL Table)	Index Back
AA Report Request Error Log This table contains the audit trail and error log produced by an Academic Advisement report.

SAA_RPT_ERROR

(SQL Table)

AA Report Request Error Log

This table contains the audit trail and error log produced by an Academic Advisement report.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PEOPLE_SRCH

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

3 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

4 RPT_DATE Date(10) DATE NOT NULL Report Date

5 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

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.

7 TSCRPT_TYPE Character(5) VARCHAR2(5) NOT NULL Transcript Type
Prompt Table: SAA_SCRTY_AA_VW

8 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

9 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

10 MSG_SEVERITY Character(1) VARCHAR2(1) NOT NULL Message Severity
C=Cancel
E=Error
M=Message
W=Warning

11 SAA_MSG_PARM_CNT Number(3,0) SMALLINT NOT NULL This field contains the number of parameters in the message log record.

12 SAA_MESSAGE_PARM01 Character(30) VARCHAR2(30) NOT NULL This field is used to pass parameters into a message saved in the message catalog.

13 SAA_MESSAGE_PARM02 Character(30) VARCHAR2(30) NOT NULL This field is used to pass parameters into a message saved in the message catalog.

14 SAA_MESSAGE_PARM03 Character(30) VARCHAR2(30) NOT NULL This field is used to pass parameters into a message saved in the message catalog.

15 SAA_MESSAGE_PARM04 Character(30) VARCHAR2(30) NOT NULL This field is used to pass parameters into a message saved in the message catalog.

16 SAA_MESSAGE_PARM05 Character(30) VARCHAR2(30) NOT NULL This field is used to pass parameters into a message saved in the message catalog.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PEOPLE_SRCH
2	ANALYSIS_DB_SEQ	Number(4,0)	SMALLINT NOT NULL	Analysis DB Sequence
3	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
4	RPT_DATE	Date(10)	DATE NOT NULL	Report Date
5	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
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.
7	TSCRPT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Transcript Type Prompt Table: SAA_SCRTY_AA_VW
8	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
9	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
10	MSG_SEVERITY	Character(1)	VARCHAR2(1) NOT NULL	Message Severity C=Cancel E=Error M=Message W=Warning
11	SAA_MSG_PARM_CNT	Number(3,0)	SMALLINT NOT NULL	This field contains the number of parameters in the message log record.
12	SAA_MESSAGE_PARM01	Character(30)	VARCHAR2(30) NOT NULL	This field is used to pass parameters into a message saved in the message catalog.
13	SAA_MESSAGE_PARM02	Character(30)	VARCHAR2(30) NOT NULL	This field is used to pass parameters into a message saved in the message catalog.
14	SAA_MESSAGE_PARM03	Character(30)	VARCHAR2(30) NOT NULL	This field is used to pass parameters into a message saved in the message catalog.
15	SAA_MESSAGE_PARM04	Character(30)	VARCHAR2(30) NOT NULL	This field is used to pass parameters into a message saved in the message catalog.
16	SAA_MESSAGE_PARM05	Character(30)	VARCHAR2(30) NOT NULL	This field is used to pass parameters into a message saved in the message catalog.