[Home] [Help] [Dependency Information]
Object Name: | PA_PERF_KPA_SUMMARY_DET# |
---|---|
Object Type: | VIEW |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
KPA_SUMMARY_DET_ID | NUMBER | (15) | Yes | |
KPA_SUMMARY_ID | NUMBER | (15) | Yes | |
OBJECT_TYPE | VARCHAR2 | (30) | Yes | |
OBJECT_ID | NUMBER | (15) | Yes | |
KPA_CODE | VARCHAR2 | (30) | Yes | |
INDICATOR_CODE | VARCHAR2 | (30) | ||
COUNT | NUMBER | (15) | ||
SCORE | NUMBER | (15) | ||
RULE_ID | NUMBER | (15) | ||
IND1_COUNT | NUMBER | (15) | ||
IND1_SCORE | NUMBER | (15) | ||
IND2_COUNT | NUMBER | (15) | ||
IND2_SCORE | NUMBER | (15) | ||
IND3_COUNT | NUMBER | (15) | ||
IND3_SCORE | NUMBER | (15) | ||
IND4_COUNT | NUMBER | (15) | ||
IND4_SCORE | NUMBER | (15) | ||
IND5_COUNT | NUMBER | (15) | ||
IND5_SCORE | NUMBER | (15) | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT KPA_SUMMARY_DET_ID
, KPA_SUMMARY_ID
, OBJECT_TYPE
, OBJECT_ID
, KPA_CODE
, INDICATOR_CODE
, COUNT
, SCORE
, RULE_ID
, IND1_COUNT
, IND1_SCORE
, IND2_COUNT
, IND2_SCORE
, IND3_COUNT
, IND3_SCORE
, IND4_COUNT
, IND4_SCORE
, IND5_COUNT
, IND5_SCORE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM PA.PA_PERF_KPA_SUMMARY_DET#;
|
|
|