RAD_AUD_DETAILS (SQL Table)	Index Back
Audit Record For Advisor Advisor Audit record for recommended objects the user has drilled into asking for more details

RAD_AUD_DETAILS

(SQL Table)

Audit Record For Advisor

Advisor Audit record for recommended objects the user has drilled into asking for more details

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RAD_SESSION_ID Character(20) VARCHAR2(20) NOT NULL User Session Identifier

2 RAD_SAVED_BY Character(1) VARCHAR2(1) NOT NULL Saved By
1=User Saved
2=System Saved

3 RAD_REC_ATTR_NAME Character(30) VARCHAR2(30) NOT NULL Attribute Name

4 RAD_REC_SEQNO Number(3,0) SMALLINT NOT NULL Advisor Recommendation Sequence Number
Default Value: 0

5 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
Default Value: 0

6 RAD_REC_OBJECT Long Character(1000) VARCHAR2(1000) Advisor Recommendation Object includes object keys and scores

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RAD_SESSION_ID	Character(20)	VARCHAR2(20) NOT NULL	User Session Identifier
2	RAD_SAVED_BY	Character(1)	VARCHAR2(1) NOT NULL	Saved By 1=User Saved 2=System Saved
3	RAD_REC_ATTR_NAME	Character(30)	VARCHAR2(30) NOT NULL	Attribute Name
4	RAD_REC_SEQNO	Number(3,0)	SMALLINT NOT NULL	Advisor Recommendation Sequence Number Default Value: 0
5	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number Default Value: 0
6	RAD_REC_OBJECT	Long Character(1000)	VARCHAR2(1000)	Advisor Recommendation Object includes object keys and scores