RB_CLAF_EPM_KPI

(SQL Table)
Index Back

CLA: EPM KPI Record

Common Application record for CLA EPM KPI.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 KPI_ID Character(10) VARCHAR2(10) NOT NULL KPI ID
2 OBJ_ID Character(20) VARCHAR2(20) NOT NULL Dimension
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 PF_OBJECT_TYPE Character(20) VARCHAR2(20) NOT NULL Unique Identifier for an Object Type.
5 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.
6 PCT_OF_TARGET Signed Number(8,2) DECIMAL(6,2) NOT NULL is the Percent that the Actual Value of the KPI/Object is of it's Target Value.
7 ASSESS_DESCR Character(30) VARCHAR2(30) NOT NULL ASSESS_DESCR
8 CURRENT_TARGET Signed Number(26,6) DECIMAL(24,6) NOT NULL Current Target