[Home] [Help] [Dependency Information]
Object Name: | BENBV_CWB_SUMMARY_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BEN.BENBV_CWB_SUMMARY_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STATUS | VARCHAR2 | (30) | Summary Row Status. | |
ELIG_COUNT_DIRECT | NUMBER | (15) | Directs Eligible. | |
ELIG_COUNT_ALL | NUMBER | (15) | Alls Eligible. | |
EMP_RECV_COUNT_DIRECT | NUMBER | (15) | Directs Receiving. | |
EMP_RECV_COUNT_ALL | NUMBER | (15) | Alls Receiving. | |
ELIG_SAL_VAL_DIRECT | NUMBER | Directs Eligible Salary. | ||
ELIG_SAL_VAL_ALL | NUMBER | Alls Eligible Salary. | ||
WS_VAL_DIRECT | NUMBER | Directs Worksheet Value. | ||
WS_VAL_ALL | NUMBER | Alls Worksheet Value. | ||
WS_BDGT_VAL_DIRECT | NUMBER | Directs Worksheet Budget Value. | ||
WS_BDGT_VAL_ALL | NUMBER | Alls Worksheet Budget Value. | ||
WS_BDGT_ISS_VAL_DIRECT | NUMBER | Directs Worksheet Budget Issued Value. | ||
WS_BDGT_ISS_VAL_ALL | NUMBER | Alls Worksheet Budget Issued Value. | ||
BDGT_VAL_DIRECT | NUMBER | Directs Budget Value. | ||
BDGT_ISS_VAL_DIRECT | NUMBER | Directs Budget Issued Value. | ||
STAT_SAL_VAL_DIRECT | NUMBER | Directs Stated Salary. | ||
STAT_SAL_VAL_ALL | NUMBER | Alls Stated Salary. | ||
OTH_COMP_VAL_DIRECT | NUMBER | Directs Other Compensation. | ||
OTH_COMP_VAL_ALL | NUMBER | Alls Other Compensation. | ||
TOT_COMP_VAL_DIRECT | NUMBER | Directs Total Compensation. | ||
TOT_COMP_VAL_ALL | NUMBER | Alls Total Compensation. | ||
REC_VAL_DIRECT | NUMBER | Directs Recommended Value. | ||
REC_VAL_ALL | NUMBER | Alls Recommended Value. | ||
REC_MN_VAL_DIRECT | NUMBER | Directs Recommended Min Value. | ||
REC_MN_VAL_ALL | NUMBER | Alls Recommended Min Value. | ||
REC_MX_VAL_DIRECT | NUMBER | Directs Recommended Max Value. | ||
REC_MX_VAL_ALL | NUMBER | Alls Recommended Max Value. | ||
MISC1_VAL_DIRECT | NUMBER | Directs Miscellaneous 1 Value. | ||
MISC1_VAL_ALL | NUMBER | Alls Miscellaneous 1 Value. | ||
MISC2_VAL_DIRECT | NUMBER | Directs Miscellaneous 2 Value. | ||
MISC2_VAL_ALL | NUMBER | Alls Miscellaneous 2 Value. | ||
MISC3_VAL_DIRECT | NUMBER | Directs Miscellaneous 3 Value. | ||
MISC3_VAL_ALL | NUMBER | Alls Miscellaneous 3 Value. | ||
LF_EVT_OCRD_DT | DATE | Life Event Occured Date | ||
GROUP_PLAN | VARCHAR2 | (4000) | Group Plan. | |
GROUP_OPTION_IN_PLAN | VARCHAR2 | (4000) | Group Option in Plan. | |
SUMMARY_ID | NUMBER | (15) | Yes | Summary Primary Key. |
GROUP_PER_IN_LER_ID | NUMBER | (15) | Yes | Group Per in Ler ID |
GROUP_PL_ID | NUMBER | (15) | Yes | Group Plan ID |
GROUP_OIPL_ID | NUMBER | (15) | Group Option in Plan | |
PERSON_ID | NUMBER | (15) | Person ( Foreign key to PER_ALL_PEOPLE_F) | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Standard who column - date when this row was created. |
Cut, paste (and edit) the following text to query this object:
SELECT STATUS
, ELIG_COUNT_DIRECT
, ELIG_COUNT_ALL
, EMP_RECV_COUNT_DIRECT
, EMP_RECV_COUNT_ALL
, ELIG_SAL_VAL_DIRECT
, ELIG_SAL_VAL_ALL
, WS_VAL_DIRECT
, WS_VAL_ALL
, WS_BDGT_VAL_DIRECT
, WS_BDGT_VAL_ALL
, WS_BDGT_ISS_VAL_DIRECT
, WS_BDGT_ISS_VAL_ALL
, BDGT_VAL_DIRECT
, BDGT_ISS_VAL_DIRECT
, STAT_SAL_VAL_DIRECT
, STAT_SAL_VAL_ALL
, OTH_COMP_VAL_DIRECT
, OTH_COMP_VAL_ALL
, TOT_COMP_VAL_DIRECT
, TOT_COMP_VAL_ALL
, REC_VAL_DIRECT
, REC_VAL_ALL
, REC_MN_VAL_DIRECT
, REC_MN_VAL_ALL
, REC_MX_VAL_DIRECT
, REC_MX_VAL_ALL
, MISC1_VAL_DIRECT
, MISC1_VAL_ALL
, MISC2_VAL_DIRECT
, MISC2_VAL_ALL
, MISC3_VAL_DIRECT
, MISC3_VAL_ALL
, LF_EVT_OCRD_DT
, GROUP_PLAN
, GROUP_OPTION_IN_PLAN
, SUMMARY_ID
, GROUP_PER_IN_LER_ID
, GROUP_PL_ID
, GROUP_OIPL_ID
, PERSON_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
FROM APPS.BENBV_CWB_SUMMARY_V;
APPS.BENBV_CWB_SUMMARY_V is not referenced by any database object
|
|
|