DBA Data[Home] [Help] [Dependency Information]

TABLE: BEN.BEN_CWB_PERSON_GROUPS_EFC

Object Details
Object Name: BEN_CWB_PERSON_GROUPS_EFC
Object Type: TABLE
Owner: BEN
Subobject Name:
Status: VALID


Table for supporting EFC conversion of monetary columns in BEN_CWB_PERSON_GROUPS table


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BEN_CWB_PERSON_GROUPS_EFC_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnGROUP_PER_IN_LER_ID
ColumnGROUP_PL_ID
ColumnGROUP_OIPL_ID
ColumnEFC_ACTION_ID
Columns
Name Datatype Length Mandatory Comments
GROUP_PER_IN_LER_ID NUMBER (15) Yes Employee Life event
GROUP_PL_ID NUMBER (15) Yes Group Plan
GROUP_OIPL_ID NUMBER (15) Yes Group Option
EFC_ACTION_ID NUMBER (15) Yes Reference EFC process table
DIST_BDGT_ISS_VAL NUMBER

Distribution Budget issued
DIST_BDGT_MN_VAL NUMBER

Minimum Distribution Budget
DIST_BDGT_MX_VAL NUMBER

Maximum Distribution Budget
DIST_BDGT_VAL NUMBER

Distribution Budget
RSRV_MN_VAL NUMBER

Minimum Reserver Amount
RSRV_MX_VAL NUMBER

Maximum Reserve Amount
RSRV_VAL NUMBER

Reserve Amount Value
WS_BDGT_ISS_VAL NUMBER

Worksheet Budget Issued
WS_BDGT_MN_VAL NUMBER

Minimum Worksheet Budget
WS_BDGT_MX_VAL NUMBER

Maximum Worksheet Budget
WS_BDGT_VAL NUMBER

Worksheet Budet value
DFLT_DIST_BDGT_VAL NUMBER

Default Distribution Budget Value
DFLT_WS_BDGT_VAL NUMBER

Default Worksheet Budget Value
PL_UOM VARCHAR2 (30)
Unit of Measure for the Plan
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT GROUP_PER_IN_LER_ID
,      GROUP_PL_ID
,      GROUP_OIPL_ID
,      EFC_ACTION_ID
,      DIST_BDGT_ISS_VAL
,      DIST_BDGT_MN_VAL
,      DIST_BDGT_MX_VAL
,      DIST_BDGT_VAL
,      RSRV_MN_VAL
,      RSRV_MX_VAL
,      RSRV_VAL
,      WS_BDGT_ISS_VAL
,      WS_BDGT_MN_VAL
,      WS_BDGT_MX_VAL
,      WS_BDGT_VAL
,      DFLT_DIST_BDGT_VAL
,      DFLT_WS_BDGT_VAL
,      PL_UOM
FROM BEN.BEN_CWB_PERSON_GROUPS_EFC;

Dependencies

[top of page]

BEN.BEN_CWB_PERSON_GROUPS_EFC does not reference any database object

BEN.BEN_CWB_PERSON_GROUPS_EFC is referenced by following:

SchemaBEN
ViewBEN_CWB_PERSON_GROUPS_EFC#