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_TRANSACTIONS

Object Details

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

This table records performance transaction data.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_PERF_TRANSACTIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERF_TXN_ID
PA_PERF_KPA_TRANS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERF_TXN_OBJ_TYPE PERF_TXN_OBJ_ID MEASURE_ID CURRENT_FLAG
PA_PERF_KPA_TRANS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERF_TXN_OBJ_TYPE PERF_TXN_OBJ_ID INCLUDED_IN_SCORING
PA_PERF_KPA_TRANS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERF_TXN_OBJ_TYPE PERF_TXN_OBJ_ID KPA_CODE INCLUDED_IN_SCORING
PA_PERF_KPA_TRANS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	KPA_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
PERF_TXN_ID	NUMBER	(15)	Yes	Performance transaction identifier.
PERF_TXN_OBJ_TYPE	VARCHAR2	(30)	Yes	Performance transaction object type.
PERF_TXN_OBJ_ID	NUMBER	(15)	Yes	Performance transaction object identifier.
OBJECT_RULE_ID	NUMBER	(15)	Yes	Performance rule and object association identifier.
RELATED_OBJ_TYPE	VARCHAR2	(30)		Performance transaction related object type.
RELATED_OBJ_ID	NUMBER	(15)		Performance transaction related object identifier.
RULE_ID	NUMBER	(15)	Yes	Performance rule identifier.
PROJECT_ID	NUMBER	(15)		Project identifier.
KPA_CODE	VARCHAR2	(30)	Yes	Key Performance Area Code.
MEASURE_ID	NUMBER	(15)	Yes	Custom measure identifier .
MEASURE_VALUE	NUMBER	(15)		Current measure value.
PERIOD_NAME	VARCHAR2	(15)		Period Name.
INDICATOR_CODE	VARCHAR2	(30)		Indicator Lookup Code
THRESHOLD_FROM	NUMBER	(15)		Threshold From Value
THRESHOLD_TO	NUMBER	(15)		Threshold To Value
WEIGHTING	NUMBER	(15)		Threshold Weighting.
PRECISION	NUMBER	(10)		Precision.
PERIOD_TYPE	VARCHAR2	(30)		Calendar type. Valid values are GL and PA..
CURRENCY_TYPE	VARCHAR2	(30)		Currency Type.
MEASURE_FORMAT	VARCHAR2	(30)		Measure Format.
PROGRAM_ID	NUMBER	(15)		Exception engine concurrent program request identifier.
DATE_CHECKED	DATE		Yes	Date when the transaction occurs .
EXCEPTION_FLAG	VARCHAR2	(1)		Exception flag.
CURRENT_FLAG	VARCHAR2	(1)		Current flag.
INCLUDED_IN_SCORING	VARCHAR2	(1)		Included in Scoring flag.
RECORD_VERSION_NUMBER	NUMBER	(15)	Yes	Number used for record locking in self service applications
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 PERF_TXN_ID
,      PERF_TXN_OBJ_TYPE
,      PERF_TXN_OBJ_ID
,      OBJECT_RULE_ID
,      RELATED_OBJ_TYPE
,      RELATED_OBJ_ID
,      RULE_ID
,      PROJECT_ID
,      KPA_CODE
,      MEASURE_ID
,      MEASURE_VALUE
,      PERIOD_NAME
,      INDICATOR_CODE
,      THRESHOLD_FROM
,      THRESHOLD_TO
,      WEIGHTING
,      PRECISION
,      PERIOD_TYPE
,      CURRENCY_TYPE
,      MEASURE_FORMAT
,      PROGRAM_ID
,      DATE_CHECKED
,      EXCEPTION_FLAG
,      CURRENT_FLAG
,      INCLUDED_IN_SCORING
,      RECORD_VERSION_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM PA.PA_PERF_TRANSACTIONS;

Dependencies

[top of page]

PA.PA_PERF_TRANSACTIONS does not reference any database object

PA.PA_PERF_TRANSACTIONS is referenced by following:

PA: PA_PERF_TRANSACTIONS#