[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | BEN_CWB_SUMMARY |
|---|---|
| Object Type: | TABLE |
| Owner: | BEN |
| FND Design Data: |  BEN.BEN_CWB_SUMMARY
|
| Subobject Name: | |
| Status: | VALID |
Stores the summarized information for budgets, allocations and reserved amounts. The totals are held at the directs and all levels for every manager.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| BEN_CWB_SUMMARY_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 SUMMARY_ID
|
| BEN_CWB_SUMMARY_FK1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
GROUP_PER_IN_LER_ID
LF_EVT_OCRD_DT
GROUP_PL_ID
GROUP_OIPL_ID
|
| BEN_CWB_SUMMARY_FK2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PERSON_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SUMMARY_ID | NUMBER | (15) | Yes | Summary Primary Key |
| GROUP_PER_IN_LER_ID | NUMBER | (15) | Yes | Group Person Life Event |
| GROUP_PL_ID | NUMBER | (15) | Yes | Group Plan |
| GROUP_OIPL_ID | NUMBER | (15) | Group Option | |
| PERSON_ID | NUMBER | (15) | Person | |
| LF_EVT_OCRD_DT | DATE | Life Event Occured on Date | ||
| 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 | ||
| 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 SUMMARY_ID
, GROUP_PER_IN_LER_ID
, GROUP_PL_ID
, GROUP_OIPL_ID
, PERSON_ID
, LF_EVT_OCRD_DT
, 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
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM BEN.BEN_CWB_SUMMARY;
BEN.BEN_CWB_SUMMARY does not reference any database object
BEN.BEN_CWB_SUMMARY is referenced by following:
BEN
BEN_CWB_SUMMARY#
|
|
|
|