DBA Data[Home] [Help] [Dependency Information]

TABLE: CSI.CSI_COUNTER_USAGE_FORECAST

Object Details
Object Name: CSI_COUNTER_USAGE_FORECAST
Object Type: TABLE
Owner: CSI
FND Design Data: TableCSI.CSI_COUNTER_USAGE_FORECAST
Subobject Name:
Status: VALID


CSI_COUNTER_USAGE_FORECASE holds the usage rate and use past readings information associated to the counter instance. All of the information here are used for usage forecasting purposes.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CSI_COUNTER_USAGE_FORECAST_U01 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINSTANCE_FORECAST_ID
Columns
Name Datatype Length Mandatory Comments
INSTANCE_FORECAST_ID NUMBER
Yes Internally generated primary key
COUNTER_ID NUMBER
Yes Counter identifier
USAGE_RATE NUMBER
Yes Usage rate
USE_PAST_READING NUMBER

Use past reading
ACTIVE_START_DATE DATE

Activation start date
ACTIVE_END_DATE DATE

Activation end date
OBJECT_VERSION_NUMBER NUMBER
Yes Object version number
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO Column
CREATION_DATE DATE
Yes Standard WHO Column
CREATED_BY NUMBER (15) Yes Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INSTANCE_FORECAST_ID
,      COUNTER_ID
,      USAGE_RATE
,      USE_PAST_READING
,      ACTIVE_START_DATE
,      ACTIVE_END_DATE
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM CSI.CSI_COUNTER_USAGE_FORECAST;

Dependencies

[top of page]

CSI.CSI_COUNTER_USAGE_FORECAST does not reference any database object

CSI.CSI_COUNTER_USAGE_FORECAST is referenced by following:

SchemaCSI
ViewCSI_COUNTER_USAGE_FORECAST#