RB_CLA_PROD_ITM

(SQL Table)
Index Back

Product EPM record

Product EPM record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

Default Value: OPR_DEF_TBL_RB.SETID

Prompt Table: SP_SETID_NONVW

2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

Default Value: NEXT

3 RB_EPM_DATA_ID Character(30) VARCHAR2(30) NOT NULL EMP DATA TYPE ID eg. KPI_ID / MODEL_ID
4 RESOLVED_VALUE Signed Number(26,6) DECIMAL(24,6) NOT NULL Contains a number which is the value for the KPI/Object for the current Scenario, Fiscal Year and Accounting Period.
5 DEFINITION Character(1) VARCHAR2(1) NOT NULL View Definition
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
7 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
8 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
9 DIMENSIONS Character(1) VARCHAR2(1) NOT NULL Dimensions
10 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
11 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
12 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
13 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
14 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
15 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time