RPM_SG_CACHE_D1

(SQL Table)
Index Back

Portfolio Segmen Group Cache

This table contains data for each metric for segment group in SmartViews

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TIMEFRAME_PERIOD Character(32) VARCHAR2(32) NOT NULL Time Frame
2 RPM_RA_SETID Character(5) VARCHAR2(5) NOT NULL Setid for use in mobile sales
3 RA_SEGMENT_GRP_ID Character(15) VARCHAR2(15) NOT NULL Marketing Segment Group Key ID field
4 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
5 RSP_GOAL_ID Character(10) VARCHAR2(10) NOT NULL This field is used as a key on the Goal Setup table (RSP_GOAL) and is auto generated on save.
6 RPM_ACTUAL1 Signed Number(19,2) DECIMAL(17,2) NOT NULL Portfolio Manager Actual Value
7 STATUS_CODE Number(5,0) INTEGER NOT NULL Status Code
8 LAST_DTTM_UPDATE DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.