RPM_BO_CACHE_D1

(SQL Table)
Index Back

Dynamic BO_ID

Table that has Portfolio Dynamic BO_ID Cache

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TIMEFRAME_PERIOD Character(32) VARCHAR2(32) NOT NULL Time Frame
2 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
3 ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Role Type ID
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.