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.

[Home] [Help]

VIEW: PA.PA_PERF_KPA_SUMMARY#

Source

View Text - Preformatted


select KPA_SUMMARY_ID KPA_SUMMARY_ID, OBJECT_TYPE OBJECT_TYPE, OBJECT_ID OBJECT_ID, DATE_CHECKED DATE_CHECKED, CURRENT_FLAG CURRENT_FLAG, PERF_STATUS_CODE PERF_STATUS_CODE, KPA1_CODE KPA1_CODE, KPA1_INDICATOR KPA1_INDICATOR, KPA1_SCORE KPA1_SCORE, KPA1_THRES_FROM KPA1_THRES_FROM, KPA1_THRES_TO KPA1_THRES_TO, KPA2_CODE KPA2_CODE, KPA2_INDICATOR KPA2_INDICATOR, KPA2_SCORE KPA2_SCORE, KPA2_THRES_FROM KPA2_THRES_FROM, KPA2_THRES_TO KPA2_THRES_TO, KPA3_CODE KPA3_CODE, KPA3_INDICATOR KPA3_INDICATOR, KPA3_SCORE KPA3_SCORE, KPA3_THRES_FROM KPA3_THRES_FROM, KPA3_THRES_TO KPA3_THRES_TO, KPA4_CODE KPA4_CODE, KPA4_INDICATOR KPA4_INDICATOR, KPA4_SCORE KPA4_SCORE, KPA4_THRES_FROM KPA4_THRES_FROM, KPA4_THRES_TO KPA4_THRES_TO, KPA5_CODE KPA5_CODE, KPA5_INDICATOR KPA5_INDICATOR, KPA5_SCORE KPA5_SCORE, KPA5_THRES_FROM KPA5_THRES_FROM, KPA5_THRES_TO KPA5_THRES_TO, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "PA"."PA_PERF_KPA_SUMMARY"

View Text - HTML Formatted

SELECT KPA_SUMMARY_ID KPA_SUMMARY_ID
, OBJECT_TYPE OBJECT_TYPE
, OBJECT_ID OBJECT_ID
, DATE_CHECKED DATE_CHECKED
, CURRENT_FLAG CURRENT_FLAG
, PERF_STATUS_CODE PERF_STATUS_CODE
, KPA1_CODE KPA1_CODE
, KPA1_INDICATOR KPA1_INDICATOR
, KPA1_SCORE KPA1_SCORE
, KPA1_THRES_FROM KPA1_THRES_FROM
, KPA1_THRES_TO KPA1_THRES_TO
, KPA2_CODE KPA2_CODE
, KPA2_INDICATOR KPA2_INDICATOR
, KPA2_SCORE KPA2_SCORE
, KPA2_THRES_FROM KPA2_THRES_FROM
, KPA2_THRES_TO KPA2_THRES_TO
, KPA3_CODE KPA3_CODE
, KPA3_INDICATOR KPA3_INDICATOR
, KPA3_SCORE KPA3_SCORE
, KPA3_THRES_FROM KPA3_THRES_FROM
, KPA3_THRES_TO KPA3_THRES_TO
, KPA4_CODE KPA4_CODE
, KPA4_INDICATOR KPA4_INDICATOR
, KPA4_SCORE KPA4_SCORE
, KPA4_THRES_FROM KPA4_THRES_FROM
, KPA4_THRES_TO KPA4_THRES_TO
, KPA5_CODE KPA5_CODE
, KPA5_INDICATOR KPA5_INDICATOR
, KPA5_SCORE KPA5_SCORE
, KPA5_THRES_FROM KPA5_THRES_FROM
, KPA5_THRES_TO KPA5_THRES_TO
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "PA"."PA_PERF_KPA_SUMMARY"