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: HR.PER_WPM_APPRAISAL_SUMMARY#

Source

View Text - Preformatted


select WPM_APPRAISAL_SUMMARY_ID WPM_APPRAISAL_SUMMARY_ID, PLAN_ID PLAN_ID, SUPERVISOR_PERSON_ID SUPERVISOR_PERSON_ID, SUPERVISOR_NAME SUPERVISOR_NAME, LEVEL_1_ID LEVEL_1_ID, LEVEL_1_NAME LEVEL_1_NAME, LEVEL_1_DIRECT_COUNT LEVEL_1_DIRECT_COUNT, LEVEL_1_TOTAL_COUNT LEVEL_1_TOTAL_COUNT, LEVEL_2_ID LEVEL_2_ID, LEVEL_2_NAME LEVEL_2_NAME, LEVEL_2_DIRECT_COUNT LEVEL_2_DIRECT_COUNT, LEVEL_2_TOTAL_COUNT LEVEL_2_TOTAL_COUNT, LEVEL_3_ID LEVEL_3_ID, LEVEL_3_NAME LEVEL_3_NAME, LEVEL_3_DIRECT_COUNT LEVEL_3_DIRECT_COUNT, LEVEL_3_TOTAL_COUNT LEVEL_3_TOTAL_COUNT, LEVEL_4_ID LEVEL_4_ID, LEVEL_4_NAME LEVEL_4_NAME, LEVEL_4_DIRECT_COUNT LEVEL_4_DIRECT_COUNT, LEVEL_4_TOTAL_COUNT LEVEL_4_TOTAL_COUNT, LEVEL_5_ID LEVEL_5_ID, LEVEL_5_NAME LEVEL_5_NAME, LEVEL_5_DIRECT_COUNT LEVEL_5_DIRECT_COUNT, LEVEL_5_TOTAL_COUNT LEVEL_5_TOTAL_COUNT, LEVEL_6_ID LEVEL_6_ID, LEVEL_6_NAME LEVEL_6_NAME, LEVEL_6_DIRECT_COUNT LEVEL_6_DIRECT_COUNT, LEVEL_6_TOTAL_COUNT LEVEL_6_TOTAL_COUNT, LEVEL_7_ID LEVEL_7_ID, LEVEL_7_NAME LEVEL_7_NAME, LEVEL_7_DIRECT_COUNT LEVEL_7_DIRECT_COUNT, LEVEL_7_TOTAL_COUNT LEVEL_7_TOTAL_COUNT, LEVEL_8_ID LEVEL_8_ID, LEVEL_8_NAME LEVEL_8_NAME, LEVEL_8_DIRECT_COUNT LEVEL_8_DIRECT_COUNT, LEVEL_8_TOTAL_COUNT LEVEL_8_TOTAL_COUNT, LEVEL_9_ID LEVEL_9_ID, LEVEL_9_NAME LEVEL_9_NAME, LEVEL_9_DIRECT_COUNT LEVEL_9_DIRECT_COUNT, LEVEL_9_TOTAL_COUNT LEVEL_9_TOTAL_COUNT, LEVEL_10_ID LEVEL_10_ID, LEVEL_10_NAME LEVEL_10_NAME, LEVEL_10_DIRECT_COUNT LEVEL_10_DIRECT_COUNT, LEVEL_10_TOTAL_COUNT LEVEL_10_TOTAL_COUNT, LEVEL_11_ID LEVEL_11_ID, LEVEL_11_NAME LEVEL_11_NAME, LEVEL_11_DIRECT_COUNT LEVEL_11_DIRECT_COUNT, LEVEL_11_TOTAL_COUNT LEVEL_11_TOTAL_COUNT, LEVEL_12_ID LEVEL_12_ID, LEVEL_12_NAME LEVEL_12_NAME, LEVEL_12_DIRECT_COUNT LEVEL_12_DIRECT_COUNT, LEVEL_12_TOTAL_COUNT LEVEL_12_TOTAL_COUNT, LEVEL_13_ID LEVEL_13_ID, LEVEL_13_NAME LEVEL_13_NAME, LEVEL_13_DIRECT_COUNT LEVEL_13_DIRECT_COUNT, LEVEL_13_TOTAL_COUNT LEVEL_13_TOTAL_COUNT, LEVEL_14_ID LEVEL_14_ID, LEVEL_14_NAME LEVEL_14_NAME, LEVEL_14_DIRECT_COUNT LEVEL_14_DIRECT_COUNT, LEVEL_14_TOTAL_COUNT LEVEL_14_TOTAL_COUNT, LEVEL_15_ID LEVEL_15_ID, LEVEL_15_NAME LEVEL_15_NAME, LEVEL_15_DIRECT_COUNT LEVEL_15_DIRECT_COUNT, LEVEL_15_TOTAL_COUNT LEVEL_15_TOTAL_COUNT, LEVEL_16_ID LEVEL_16_ID, LEVEL_16_NAME LEVEL_16_NAME, LEVEL_16_DIRECT_COUNT LEVEL_16_DIRECT_COUNT, LEVEL_16_TOTAL_COUNT LEVEL_16_TOTAL_COUNT, LEVEL_17_ID LEVEL_17_ID, LEVEL_17_NAME LEVEL_17_NAME, LEVEL_17_DIRECT_COUNT LEVEL_17_DIRECT_COUNT, LEVEL_17_TOTAL_COUNT LEVEL_17_TOTAL_COUNT, LEVEL_18_ID LEVEL_18_ID, LEVEL_18_NAME LEVEL_18_NAME, LEVEL_18_DIRECT_COUNT LEVEL_18_DIRECT_COUNT, LEVEL_18_TOTAL_COUNT LEVEL_18_TOTAL_COUNT, LEVEL_19_ID LEVEL_19_ID, LEVEL_19_NAME LEVEL_19_NAME, LEVEL_19_DIRECT_COUNT LEVEL_19_DIRECT_COUNT, LEVEL_19_TOTAL_COUNT LEVEL_19_TOTAL_COUNT, LEVEL_20_ID LEVEL_20_ID, LEVEL_20_NAME LEVEL_20_NAME, LEVEL_20_DIRECT_COUNT LEVEL_20_DIRECT_COUNT, LEVEL_20_TOTAL_COUNT LEVEL_20_TOTAL_COUNT, NORATING_DIRECT_COUNT NORATING_DIRECT_COUNT, NORATING_TOTAL_COUNT NORATING_TOTAL_COUNT, APPRAISAL_PERIOD_ID APPRAISAL_PERIOD_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE from "HR"."PER_WPM_APPRAISAL_SUMMARY"

View Text - HTML Formatted

SELECT WPM_APPRAISAL_SUMMARY_ID WPM_APPRAISAL_SUMMARY_ID
, PLAN_ID PLAN_ID
, SUPERVISOR_PERSON_ID SUPERVISOR_PERSON_ID
, SUPERVISOR_NAME SUPERVISOR_NAME
, LEVEL_1_ID LEVEL_1_ID
, LEVEL_1_NAME LEVEL_1_NAME
, LEVEL_1_DIRECT_COUNT LEVEL_1_DIRECT_COUNT
, LEVEL_1_TOTAL_COUNT LEVEL_1_TOTAL_COUNT
, LEVEL_2_ID LEVEL_2_ID
, LEVEL_2_NAME LEVEL_2_NAME
, LEVEL_2_DIRECT_COUNT LEVEL_2_DIRECT_COUNT
, LEVEL_2_TOTAL_COUNT LEVEL_2_TOTAL_COUNT
, LEVEL_3_ID LEVEL_3_ID
, LEVEL_3_NAME LEVEL_3_NAME
, LEVEL_3_DIRECT_COUNT LEVEL_3_DIRECT_COUNT
, LEVEL_3_TOTAL_COUNT LEVEL_3_TOTAL_COUNT
, LEVEL_4_ID LEVEL_4_ID
, LEVEL_4_NAME LEVEL_4_NAME
, LEVEL_4_DIRECT_COUNT LEVEL_4_DIRECT_COUNT
, LEVEL_4_TOTAL_COUNT LEVEL_4_TOTAL_COUNT
, LEVEL_5_ID LEVEL_5_ID
, LEVEL_5_NAME LEVEL_5_NAME
, LEVEL_5_DIRECT_COUNT LEVEL_5_DIRECT_COUNT
, LEVEL_5_TOTAL_COUNT LEVEL_5_TOTAL_COUNT
, LEVEL_6_ID LEVEL_6_ID
, LEVEL_6_NAME LEVEL_6_NAME
, LEVEL_6_DIRECT_COUNT LEVEL_6_DIRECT_COUNT
, LEVEL_6_TOTAL_COUNT LEVEL_6_TOTAL_COUNT
, LEVEL_7_ID LEVEL_7_ID
, LEVEL_7_NAME LEVEL_7_NAME
, LEVEL_7_DIRECT_COUNT LEVEL_7_DIRECT_COUNT
, LEVEL_7_TOTAL_COUNT LEVEL_7_TOTAL_COUNT
, LEVEL_8_ID LEVEL_8_ID
, LEVEL_8_NAME LEVEL_8_NAME
, LEVEL_8_DIRECT_COUNT LEVEL_8_DIRECT_COUNT
, LEVEL_8_TOTAL_COUNT LEVEL_8_TOTAL_COUNT
, LEVEL_9_ID LEVEL_9_ID
, LEVEL_9_NAME LEVEL_9_NAME
, LEVEL_9_DIRECT_COUNT LEVEL_9_DIRECT_COUNT
, LEVEL_9_TOTAL_COUNT LEVEL_9_TOTAL_COUNT
, LEVEL_10_ID LEVEL_10_ID
, LEVEL_10_NAME LEVEL_10_NAME
, LEVEL_10_DIRECT_COUNT LEVEL_10_DIRECT_COUNT
, LEVEL_10_TOTAL_COUNT LEVEL_10_TOTAL_COUNT
, LEVEL_11_ID LEVEL_11_ID
, LEVEL_11_NAME LEVEL_11_NAME
, LEVEL_11_DIRECT_COUNT LEVEL_11_DIRECT_COUNT
, LEVEL_11_TOTAL_COUNT LEVEL_11_TOTAL_COUNT
, LEVEL_12_ID LEVEL_12_ID
, LEVEL_12_NAME LEVEL_12_NAME
, LEVEL_12_DIRECT_COUNT LEVEL_12_DIRECT_COUNT
, LEVEL_12_TOTAL_COUNT LEVEL_12_TOTAL_COUNT
, LEVEL_13_ID LEVEL_13_ID
, LEVEL_13_NAME LEVEL_13_NAME
, LEVEL_13_DIRECT_COUNT LEVEL_13_DIRECT_COUNT
, LEVEL_13_TOTAL_COUNT LEVEL_13_TOTAL_COUNT
, LEVEL_14_ID LEVEL_14_ID
, LEVEL_14_NAME LEVEL_14_NAME
, LEVEL_14_DIRECT_COUNT LEVEL_14_DIRECT_COUNT
, LEVEL_14_TOTAL_COUNT LEVEL_14_TOTAL_COUNT
, LEVEL_15_ID LEVEL_15_ID
, LEVEL_15_NAME LEVEL_15_NAME
, LEVEL_15_DIRECT_COUNT LEVEL_15_DIRECT_COUNT
, LEVEL_15_TOTAL_COUNT LEVEL_15_TOTAL_COUNT
, LEVEL_16_ID LEVEL_16_ID
, LEVEL_16_NAME LEVEL_16_NAME
, LEVEL_16_DIRECT_COUNT LEVEL_16_DIRECT_COUNT
, LEVEL_16_TOTAL_COUNT LEVEL_16_TOTAL_COUNT
, LEVEL_17_ID LEVEL_17_ID
, LEVEL_17_NAME LEVEL_17_NAME
, LEVEL_17_DIRECT_COUNT LEVEL_17_DIRECT_COUNT
, LEVEL_17_TOTAL_COUNT LEVEL_17_TOTAL_COUNT
, LEVEL_18_ID LEVEL_18_ID
, LEVEL_18_NAME LEVEL_18_NAME
, LEVEL_18_DIRECT_COUNT LEVEL_18_DIRECT_COUNT
, LEVEL_18_TOTAL_COUNT LEVEL_18_TOTAL_COUNT
, LEVEL_19_ID LEVEL_19_ID
, LEVEL_19_NAME LEVEL_19_NAME
, LEVEL_19_DIRECT_COUNT LEVEL_19_DIRECT_COUNT
, LEVEL_19_TOTAL_COUNT LEVEL_19_TOTAL_COUNT
, LEVEL_20_ID LEVEL_20_ID
, LEVEL_20_NAME LEVEL_20_NAME
, LEVEL_20_DIRECT_COUNT LEVEL_20_DIRECT_COUNT
, LEVEL_20_TOTAL_COUNT LEVEL_20_TOTAL_COUNT
, NORATING_DIRECT_COUNT NORATING_DIRECT_COUNT
, NORATING_TOTAL_COUNT NORATING_TOTAL_COUNT
, APPRAISAL_PERIOD_ID APPRAISAL_PERIOD_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
FROM "HR"."PER_WPM_APPRAISAL_SUMMARY"