eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: PA.PA_PERF_KPA_SUMMARY

Object Details

Object Name:	PA_PERF_KPA_SUMMARY
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_PERF_KPA_SUMMARY
Subobject Name:
Status:	VALID

This table records the exception summary for a given object across all KPAs.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_PERF_KPA_SUMMARY_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	KPA_SUMMARY_ID
PA_PERF_KPA_SUMMARY_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_TYPE OBJECT_ID CURRENT_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
KPA_SUMMARY_ID	NUMBER	(15)	Yes	Key performance area summary identifier
OBJECT_TYPE	VARCHAR2	(30)	Yes	Object type.
OBJECT_ID	NUMBER	(15)	Yes	Object identifier.
DATE_CHECKED	DATE		Yes	Date checked.
CURRENT_FLAG	VARCHAR2	(1)		Current indicator.
PERF_STATUS_CODE	VARCHAR2	(30)		Overall Performance Status Indicator.
KPA1_CODE	VARCHAR2	(30)		KPA1 lookup code.
KPA1_INDICATOR	VARCHAR2	(30)		KPA1 color indicator
KPA1_SCORE	NUMBER	(15)		KPA1 score
KPA1_THRES_FROM	NUMBER	(15)		KPA1 scoring threshold from value
KPA1_THRES_TO	NUMBER	(15)		KPA1 scoring threshold to value
KPA2_CODE	VARCHAR2	(30)		KPA2 lookup code.
KPA2_INDICATOR	VARCHAR2	(30)		KPA2 Color Indicator.
KPA2_SCORE	NUMBER	(15)		KPA2 Score.
KPA2_THRES_FROM	NUMBER	(15)		KPA2 Scoring Threshold From Value
KPA2_THRES_TO	NUMBER	(15)		KPA2 Scoring Threshold To Value
KPA3_CODE	VARCHAR2	(30)		KPA3 lookup code.
KPA3_INDICATOR	VARCHAR2	(30)		KPA3 Color Indicator.
KPA3_SCORE	NUMBER	(15)		KPA3 Score.
KPA3_THRES_FROM	NUMBER	(15)		KPA3 Scoring Threshold From Value
KPA3_THRES_TO	NUMBER	(15)		KPA3 Scoring Threshold To Value
KPA4_CODE	VARCHAR2	(30)		KPA4 lookup code.
KPA4_INDICATOR	VARCHAR2	(30)		KPA4 Color Indicator.
KPA4_SCORE	NUMBER	(15)		KPA4 Score.
KPA4_THRES_FROM	NUMBER	(15)		KPA4 Scoring Threshold From Value
KPA4_THRES_TO	NUMBER	(15)		KPA4 Scoring Threshold To Value
KPA5_CODE	VARCHAR2	(30)		KPA5 lookup code.
KPA5_INDICATOR	VARCHAR2	(30)		KPA5 Color Indicator.
KPA5_SCORE	NUMBER	(15)		KPA5 Score.
KPA5_THRES_FROM	NUMBER	(15)		KPA5 Scoring Threshold From Value
KPA5_THRES_TO	NUMBER	(15)		KPA5 Scoring Threshold To Value
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_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 KPA_SUMMARY_ID
,      OBJECT_TYPE
,      OBJECT_ID
,      DATE_CHECKED
,      CURRENT_FLAG
,      PERF_STATUS_CODE
,      KPA1_CODE
,      KPA1_INDICATOR
,      KPA1_SCORE
,      KPA1_THRES_FROM
,      KPA1_THRES_TO
,      KPA2_CODE
,      KPA2_INDICATOR
,      KPA2_SCORE
,      KPA2_THRES_FROM
,      KPA2_THRES_TO
,      KPA3_CODE
,      KPA3_INDICATOR
,      KPA3_SCORE
,      KPA3_THRES_FROM
,      KPA3_THRES_TO
,      KPA4_CODE
,      KPA4_INDICATOR
,      KPA4_SCORE
,      KPA4_THRES_FROM
,      KPA4_THRES_TO
,      KPA5_CODE
,      KPA5_INDICATOR
,      KPA5_SCORE
,      KPA5_THRES_FROM
,      KPA5_THRES_TO
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM PA.PA_PERF_KPA_SUMMARY;

Dependencies

[top of page]

PA.PA_PERF_KPA_SUMMARY does not reference any database object

PA.PA_PERF_KPA_SUMMARY is referenced by following:

PA: PA_PERF_KPA_SUMMARY#