[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PER_WPM_APPRAISAL_SUMMARY |
|---|---|
| Object Type: | TABLE |
| Owner: | HR |
| Subobject Name: | |
| Status: | VALID |
Manager-wise appraisal summary for a Worforce Performance Management Plan.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| WPM_APPRAISAL_SUMMARY_ID | NUMBER | (15) | Yes | Sequence generated primary key |
| PLAN_ID | NUMBER | (15) | Yes | Foreign key to PER_PERF_MGMT_PLANS, stores the reference to the Performance Management Plan |
| SUPERVISOR_PERSON_ID | NUMBER | (15) | Yes | Foreign Key to PER_ALL_PEOPLE_F, stores the supervisor for whom the summary is calculated |
| SUPERVISOR_NAME | VARCHAR2 | (240) | Yes | Name of the supervisor |
| LEVEL_1_ID | NUMBER | (15) | Foreign Key to PER_RATING_LEVELS, stores the rating level for which the summary is reported | |
| LEVEL_1_NAME | VARCHAR2 | (80) | Rating Level Name | |
| LEVEL_1_DIRECT_COUNT | NUMBER | (15) | Number of directs who were awarded this rating | |
| LEVEL_1_TOTAL_COUNT | NUMBER | (15) | Number of total employees who were awarded this rating under the current supervisor | |
| LEVEL_2_ID | NUMBER | (15) | Foreign Key to PER_RATING_LEVELS, stores the rating level for which the summary is reported | |
| LEVEL_2_NAME | VARCHAR2 | (80) | Rating level name | |
| LEVEL_2_DIRECT_COUNT | NUMBER | (15) | Number of directs who were awarded this rating | |
| LEVEL_2_TOTAL_COUNT | NUMBER | (15) | Number of total employees who were awarded this rating under the current supervisor | |
| LEVEL_3_ID | NUMBER | (15) | Foreign Key to PER_RATING_LEVELS, stores the rating level for which the summary is reported | |
| LEVEL_3_NAME | VARCHAR2 | (80) | Rating level name | |
| LEVEL_3_DIRECT_COUNT | NUMBER | (15) | Number of directs who were awarded this rating | |
| LEVEL_3_TOTAL_COUNT | NUMBER | (15) | Number of total employees who were awarded this rating under the current supervisor | |
| LEVEL_4_ID | NUMBER | (15) | Foreign Key to PER_RATING_LEVELS, stores the rating level for which the summary is reported | |
| LEVEL_4_NAME | VARCHAR2 | (80) | Rating level name | |
| LEVEL_4_DIRECT_COUNT | NUMBER | (15) | Number of directs who were awarded this rating | |
| LEVEL_4_TOTAL_COUNT | NUMBER | (15) | Number of total employees who were awarded this rating under the current supervisor | |
| LEVEL_5_ID | NUMBER | (15) | Foreign Key to PER_RATING_LEVELS, stores the rating level for which the summary is reported | |
| LEVEL_5_NAME | VARCHAR2 | (80) | Rating level name | |
| LEVEL_5_DIRECT_COUNT | NUMBER | (15) | Number of directs who were awarded this rating | |
| LEVEL_5_TOTAL_COUNT | NUMBER | (15) | Number of total employees who were awarded this rating under the current supervisor | |
| LEVEL_6_ID | NUMBER | (15) | Foreign Key to PER_RATING_LEVELS, stores the rating level for which the summary is reported | |
| LEVEL_6_NAME | VARCHAR2 | (80) | Rating level name | |
| LEVEL_6_DIRECT_COUNT | NUMBER | (15) | Number of directs who were awarded this rating | |
| LEVEL_6_TOTAL_COUNT | NUMBER | (15) | Number of total employees who were awarded this rating under the current supervisor | |
| LEVEL_7_ID | NUMBER | (15) | Foreign Key to PER_RATING_LEVELS, stores the rating level for which the summary is reported | |
| LEVEL_7_NAME | VARCHAR2 | (80) | Rating level name | |
| LEVEL_7_DIRECT_COUNT | NUMBER | (15) | Number of directs who were awarded this rating | |
| LEVEL_7_TOTAL_COUNT | NUMBER | (15) | Number of total employees who were awarded this rating under the current supervisor | |
| LEVEL_8_ID | NUMBER | (15) | Foreign Key to PER_RATING_LEVELS, stores the rating level for which the summary is reported | |
| LEVEL_8_NAME | VARCHAR2 | (80) | Rating level name | |
| LEVEL_8_DIRECT_COUNT | NUMBER | (15) | Number of directs who were awarded this rating | |
| LEVEL_8_TOTAL_COUNT | NUMBER | (15) | Number of total employees who were awarded this rating under the current supervisor | |
| LEVEL_9_ID | NUMBER | (15) | Foreign Key to PER_RATING_LEVELS, stores the rating level for which the summary is reported | |
| LEVEL_9_NAME | VARCHAR2 | (80) | Rating level name | |
| LEVEL_9_DIRECT_COUNT | NUMBER | (15) | Number of directs who were awarded this rating | |
| LEVEL_9_TOTAL_COUNT | NUMBER | (15) | Number of total employees who were awarded this rating under the current supervisor | |
| LEVEL_10_ID | NUMBER | (15) | Foreign Key to PER_RATING_LEVELS, stores the rating level for which the summary is reported | |
| LEVEL_10_NAME | VARCHAR2 | (80) | Rating level name | |
| LEVEL_10_DIRECT_COUNT | NUMBER | (15) | Number of directs who were awarded this rating | |
| LEVEL_10_TOTAL_COUNT | NUMBER | (15) | Number of total employees who were awarded this rating under the current supervisor | |
| LEVEL_11_ID | NUMBER | (15) | Foreign Key to PER_RATING_LEVELS, stores the rating level for which the summary is reported | |
| LEVEL_11_NAME | VARCHAR2 | (80) | Rating level name | |
| LEVEL_11_DIRECT_COUNT | NUMBER | (15) | Number of directs who were awarded this rating | |
| LEVEL_11_TOTAL_COUNT | NUMBER | (15) | Number of total employees who were awarded this rating under the current supervisor | |
| LEVEL_12_ID | NUMBER | (15) | Foreign Key to PER_RATING_LEVELS, stores the rating level for which the summary is reported | |
| LEVEL_12_NAME | VARCHAR2 | (80) | Rating level name | |
| LEVEL_12_DIRECT_COUNT | NUMBER | (15) | Number of directs who were awarded this rating | |
| LEVEL_12_TOTAL_COUNT | NUMBER | (15) | Number of total employees who were awarded this rating under the current supervisor | |
| LEVEL_13_ID | NUMBER | (15) | Foreign Key to PER_RATING_LEVELS, stores the rating level for which the summary is reported | |
| LEVEL_13_NAME | VARCHAR2 | (80) | Rating level name | |
| LEVEL_13_DIRECT_COUNT | NUMBER | (15) | Number of directs who were awarded this rating | |
| LEVEL_13_TOTAL_COUNT | NUMBER | (15) | Number of total employees who were awarded this rating under the current supervisor | |
| LEVEL_14_ID | NUMBER | (15) | Foreign Key to PER_RATING_LEVELS, stores the rating level for which the summary is reported | |
| LEVEL_14_NAME | VARCHAR2 | (80) | Rating level name | |
| LEVEL_14_DIRECT_COUNT | NUMBER | (15) | Number of directs who were awarded this rating | |
| LEVEL_14_TOTAL_COUNT | NUMBER | (15) | Number of total employees who were awarded this rating under the current supervisor | |
| LEVEL_15_ID | NUMBER | (15) | Foreign Key to PER_RATING_LEVELS, stores the rating level for which the summary is reported | |
| LEVEL_15_NAME | VARCHAR2 | (80) | Rating level name | |
| LEVEL_15_DIRECT_COUNT | NUMBER | (15) | Number of directs who were awarded this rating | |
| LEVEL_15_TOTAL_COUNT | NUMBER | (15) | Number of total employees who were awarded this rating under the current supervisor | |
| LEVEL_16_ID | NUMBER | (15) | Foreign Key to PER_RATING_LEVELS, stores the rating level for which the summary is reported | |
| LEVEL_16_NAME | VARCHAR2 | (80) | Rating level name | |
| LEVEL_16_DIRECT_COUNT | NUMBER | (15) | Number of directs who were awarded this rating | |
| LEVEL_16_TOTAL_COUNT | NUMBER | (15) | Number of total employees who were awarded this rating under the current supervisor | |
| LEVEL_17_ID | NUMBER | (15) | Foreign Key to PER_RATING_LEVELS, stores the rating level for which the summary is reported | |
| LEVEL_17_NAME | VARCHAR2 | (80) | Rating level name | |
| LEVEL_17_DIRECT_COUNT | NUMBER | (15) | Number of directs who were awarded this rating | |
| LEVEL_17_TOTAL_COUNT | NUMBER | (15) | Number of total employees who were awarded this rating under the current supervisor | |
| LEVEL_18_ID | NUMBER | (15) | Foreign Key to PER_RATING_LEVELS, stores the rating level for which the summary is reported | |
| LEVEL_18_NAME | VARCHAR2 | (80) | Rating level name | |
| LEVEL_18_DIRECT_COUNT | NUMBER | (15) | Number of directs who were awarded this rating | |
| LEVEL_18_TOTAL_COUNT | NUMBER | (15) | Number of total employees who were awarded this rating under the current supervisor | |
| LEVEL_19_ID | NUMBER | (15) | Foreign Key to PER_RATING_LEVELS, stores the rating level for which the summary is reported | |
| LEVEL_19_NAME | VARCHAR2 | (80) | Rating level name | |
| LEVEL_19_DIRECT_COUNT | NUMBER | (15) | Number of directs who were awarded this rating | |
| LEVEL_19_TOTAL_COUNT | NUMBER | (15) | Number of total employees who were awarded this rating under the current supervisor | |
| LEVEL_20_ID | NUMBER | (15) | Foreign Key to PER_RATING_LEVELS, stores the rating level for which the summary is reported | |
| LEVEL_20_NAME | VARCHAR2 | (80) | Rating level name | |
| LEVEL_20_DIRECT_COUNT | NUMBER | (15) | Number of directs who were awarded this rating | |
| LEVEL_20_TOTAL_COUNT | NUMBER | (15) | Number of total employees who were awarded this rating under the current supervisor | |
| NORATING_DIRECT_COUNT | NUMBER | (15) | Total number of directs who are not awarded a rating | |
| NORATING_TOTAL_COUNT | NUMBER | (15) | Total number of employees who are not awarded a rating | |
| APPRAISAL_PERIOD_ID | NUMBER | (15) | Yes | Foreign key to PER_APPRAISAL_PERIODS, stores the period for which the appraisal summary is computed |
| LAST_UPDATE_DATE | DATE | Standard WHO column | ||
| LAST_UPDATED_BY | NUMBER | (15) | Standard WHO column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO column | |
| CREATED_BY | NUMBER | (15) | Standard WHO column | |
| CREATION_DATE | DATE | Standard WHO column |
Cut, paste (and edit) the following text to query this object:
SELECT WPM_APPRAISAL_SUMMARY_ID
, PLAN_ID
, SUPERVISOR_PERSON_ID
, SUPERVISOR_NAME
, LEVEL_1_ID
, LEVEL_1_NAME
, LEVEL_1_DIRECT_COUNT
, LEVEL_1_TOTAL_COUNT
, LEVEL_2_ID
, LEVEL_2_NAME
, LEVEL_2_DIRECT_COUNT
, LEVEL_2_TOTAL_COUNT
, LEVEL_3_ID
, LEVEL_3_NAME
, LEVEL_3_DIRECT_COUNT
, LEVEL_3_TOTAL_COUNT
, LEVEL_4_ID
, LEVEL_4_NAME
, LEVEL_4_DIRECT_COUNT
, LEVEL_4_TOTAL_COUNT
, LEVEL_5_ID
, LEVEL_5_NAME
, LEVEL_5_DIRECT_COUNT
, LEVEL_5_TOTAL_COUNT
, LEVEL_6_ID
, LEVEL_6_NAME
, LEVEL_6_DIRECT_COUNT
, LEVEL_6_TOTAL_COUNT
, LEVEL_7_ID
, LEVEL_7_NAME
, LEVEL_7_DIRECT_COUNT
, LEVEL_7_TOTAL_COUNT
, LEVEL_8_ID
, LEVEL_8_NAME
, LEVEL_8_DIRECT_COUNT
, LEVEL_8_TOTAL_COUNT
, LEVEL_9_ID
, LEVEL_9_NAME
, LEVEL_9_DIRECT_COUNT
, LEVEL_9_TOTAL_COUNT
, LEVEL_10_ID
, LEVEL_10_NAME
, LEVEL_10_DIRECT_COUNT
, LEVEL_10_TOTAL_COUNT
, LEVEL_11_ID
, LEVEL_11_NAME
, LEVEL_11_DIRECT_COUNT
, LEVEL_11_TOTAL_COUNT
, LEVEL_12_ID
, LEVEL_12_NAME
, LEVEL_12_DIRECT_COUNT
, LEVEL_12_TOTAL_COUNT
, LEVEL_13_ID
, LEVEL_13_NAME
, LEVEL_13_DIRECT_COUNT
, LEVEL_13_TOTAL_COUNT
, LEVEL_14_ID
, LEVEL_14_NAME
, LEVEL_14_DIRECT_COUNT
, LEVEL_14_TOTAL_COUNT
, LEVEL_15_ID
, LEVEL_15_NAME
, LEVEL_15_DIRECT_COUNT
, LEVEL_15_TOTAL_COUNT
, LEVEL_16_ID
, LEVEL_16_NAME
, LEVEL_16_DIRECT_COUNT
, LEVEL_16_TOTAL_COUNT
, LEVEL_17_ID
, LEVEL_17_NAME
, LEVEL_17_DIRECT_COUNT
, LEVEL_17_TOTAL_COUNT
, LEVEL_18_ID
, LEVEL_18_NAME
, LEVEL_18_DIRECT_COUNT
, LEVEL_18_TOTAL_COUNT
, LEVEL_19_ID
, LEVEL_19_NAME
, LEVEL_19_DIRECT_COUNT
, LEVEL_19_TOTAL_COUNT
, LEVEL_20_ID
, LEVEL_20_NAME
, LEVEL_20_DIRECT_COUNT
, LEVEL_20_TOTAL_COUNT
, NORATING_DIRECT_COUNT
, NORATING_TOTAL_COUNT
, APPRAISAL_PERIOD_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM HR.PER_WPM_APPRAISAL_SUMMARY;
HR.PER_WPM_APPRAISAL_SUMMARY does not reference any database object
HR.PER_WPM_APPRAISAL_SUMMARY is referenced by following:
APPS
PER_WPM_APPRAISAL_SUMMARY
PER_WPM_APPRAISAL_SUMMARY_WHO
|
|
|
|