[Home] [Help] [Dependency Information]
Object Name: | OKI_PERF_MEASURES |
---|---|
Object Type: | TABLE |
Owner: | OKI |
FND Design Data: | OKI.OKI_PERF_MEASURES |
Subobject Name: | |
Status: | VALID |
This table holds the data for Key Performance Indicator values for any given period.
It is maintained by the Load Performance Measures, Contracts Intelligence concurrent manager job.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKI_PERF_MEASURES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PERIOD_NAME
PERIOD_SET_NAME AUTHORING_ORG_ID KPI_CODE SCS_CODE |
OKI_PERF_MEASURES_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | The internal identifier for the row. | |
PERIOD_NAME | VARCHAR2 | (15) | Yes | The name from General Ledger for the period of this information. |
PERIOD_SET_NAME | VARCHAR2 | (15) | Yes | The name of the General Ledger period set used to determine valid periods. |
PERIOD_TYPE | VARCHAR2 | (15) | The type of General Ledger period used for this information. | |
AUTHORING_ORG_ID | NUMBER | The internal identifier of the operating unit in which the contract was authored. | ||
AUTHORING_ORG_NAME | VARCHAR2 | (240) | The name of the operating unit in which the contract was authored. | |
KPI_CODE | VARCHAR2 | (30) | Yes | A code specifying the Key Performance Indicator. |
KPI_VALUE | NUMBER | The value of the Key Performance Indicator. | ||
SCS_CODE | VARCHAR2 | (30) | The category (sub-class) code for the contract. | |
REQUEST_ID | NUMBER | (15) | Concurrent Manager audit column. | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Manager audit column. | |
PROGRAM_ID | NUMBER | (15) | Concurrent Manager audit column. | |
PROGRAM_UPDATE_DATE | DATE | Concurrent Manager audit column. | ||
SECURITY_GROUP_ID | NUMBER | Used for application hosting. |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, PERIOD_NAME
, PERIOD_SET_NAME
, PERIOD_TYPE
, AUTHORING_ORG_ID
, AUTHORING_ORG_NAME
, KPI_CODE
, KPI_VALUE
, SCS_CODE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, SECURITY_GROUP_ID
FROM OKI.OKI_PERF_MEASURES;
OKI.OKI_PERF_MEASURES does not reference any database object
OKI.OKI_PERF_MEASURES is referenced by following:
|
|
|