RAD_PRDCACHE

(SQL Table)
Index Back

RAD_PRDCACHE

The recommendation cache record specific to product catalog.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RAD_ADVISOR_ID Character(20) VARCHAR2(20) NOT NULL Advisor Dialog Guid - represents internally the Advisor dialog
2 RAD_VERSION_ID Character(20) VARCHAR2(20) NOT NULL Advisor Version Identifier - internally represents a version
3 RAD_MODEL_ID Character(20) VARCHAR2(20) NOT NULL Advisor Model ID - used to identify the Advisor Recommendation Model
4 RAD_SEGMENT_ID Character(20) VARCHAR2(20) NOT NULL Segment ID
5 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
6 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
7 RAD_SCORE Signed Number(6,0) DECIMAL(5) NOT NULL Score