# |
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
|