RAD_AUD_RECMNDS (SQL Table)	Index Back
Audit for Recommendation Advisor Audit table for Recommendations that the user has seen - the top 5 are saved from each recommendation set.

RAD_AUD_RECMNDS

(SQL Table)

Audit for Recommendation

Advisor Audit table for Recommendations that the user has seen - the top 5 are saved from each recommendation set.

# 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_SEQNO Number(3,0) SMALLINT NOT NULL Advisor Recommendation Sequence Number

4 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number

5 RAD_SCORE Signed Number(6,0) DECIMAL(5) NOT NULL Score

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_SEQNO	Number(3,0)	SMALLINT NOT NULL	Advisor Recommendation Sequence Number
4	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
5	RAD_SCORE	Signed Number(6,0)	DECIMAL(5) NOT NULL	Score
6	RAD_REC_OBJECT	Long Character(1000)	VARCHAR2(1000)	Advisor Recommendation Object includes object keys and scores