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

TABLE: BSC.BSC_KPI_COMMENTS

Object Details
Object Name: BSC_KPI_COMMENTS
Object Type: TABLE
Owner: BSC
FND Design Data: TableBSC.BSC_KPI_COMMENTS
Subobject Name:
Status: VALID


BSC_KPI_COMMENTS stores information about user comments per indicator. User can comment on this indicator on specific year, sepecific periodicity and specific period.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BSC_KPI_COMMENTS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOMMENT_ID
BSC_KPI_COMMENTS_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINDICATOR
ColumnLAST_UPDATE_DATE
ColumnLAST_UPDATED_BY
Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Yes Indicator code
YEAR NUMBER (5)
Year
PERIODICITY_ID NUMBER (5)
Periodicity identifier
PERIOD_ID NUMBER (5)
Period identifier
TREND_FLAG NUMBER (3)
Performance quality
COMMENT_TEXT VARCHAR2 (4000)
User's comment body
COMMENT_TYPE NUMBER (3) Yes Comment's type
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard Who column
COMMENT_SUBJECT VARCHAR2 (1000)
Subject's comment body
COMMENT_ID NUMBER
Yes Comment Identifier
COLOR_FLAG NUMBER (3)
Color Flag for Assessment
Query Text

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


SELECT INDICATOR
,      YEAR
,      PERIODICITY_ID
,      PERIOD_ID
,      TREND_FLAG
,      COMMENT_TEXT
,      COMMENT_TYPE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      COMMENT_SUBJECT
,      COMMENT_ID
,      COLOR_FLAG
FROM BSC.BSC_KPI_COMMENTS;

Dependencies

[top of page]

BSC.BSC_KPI_COMMENTS does not reference any database object

BSC.BSC_KPI_COMMENTS is referenced by following:

SchemaAPPS
SynonymBSC_KPI_COMMENTS