[Home] [Help] [Dependency Information]
Object Name: | BEN_CWB_REPT_COMP_COMPARISON_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BEN.BEN_CWB_REPT_COMP_COMPARISON_V |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
BEN_CWB_REPT_COMP_COMPARISON_V contains a comparison of the compensation plan status across managers.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ASND_LF_EVT_DT | DATE | Assigned Date. | ||
MANAGER_NAME | VARCHAR2 | (332) | Manager Name. | |
MANAGER_FULL_NAME | VARCHAR2 | (240) | Manager Full Name. | |
PLAN_NAME | VARCHAR2 | (482) | Plan Name. | |
COUNTRY | VARCHAR2 | (150) | Country. | |
ELIGIBLE_EMPLOYEES | NUMBER | Number of Eligible Employees. | ||
ELIGIBLE_EMPS_W_VAL | NUMBER | Eligible Employees with Value. | ||
PCT_W_VAL | NUMBER | Percentage of Employees with Value. | ||
TOTAL_ALLOCATED | NUMBER | Total Allocated. | ||
UNITS | VARCHAR2 | (80) | Allocation Unit of Measure. | |
AVERAGE_ALLOCATED | NUMBER | Average number Allocated. | ||
BUDGET | NUMBER | Budget Amount. | ||
UNUSED_BUDGET | NUMBER | Amount of Budget Unused. | ||
MANAGER_ID | NUMBER | (15) | Yes | Manager Identifier. |
ENRT_PERD_ID | NUMBER | (15) | Yes | Enrollment Period Identifier. |
Cut, paste (and edit) the following text to query this object:
SELECT ASND_LF_EVT_DT
, MANAGER_NAME
, MANAGER_FULL_NAME
, PLAN_NAME
, COUNTRY
, ELIGIBLE_EMPLOYEES
, ELIGIBLE_EMPS_W_VAL
, PCT_W_VAL
, TOTAL_ALLOCATED
, UNITS
, AVERAGE_ALLOCATED
, BUDGET
, UNUSED_BUDGET
, MANAGER_ID
, ENRT_PERD_ID
FROM APPS.BEN_CWB_REPT_COMP_COMPARISON_V;
|
|
|