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

TABLE: BEN.BEN_CWB_PERSON_GROUPS

Object Details
Object Name: BEN_CWB_PERSON_GROUPS
Object Type: TABLE
Owner: BEN
FND Design Data: TableBEN.BEN_CWB_PERSON_GROUPS
Subobject Name:
Status: VALID


Budget details for Group Plan and/or Group options for a CWB plan


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BEN_CWB_PERSON_GROUPS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnGROUP_PER_IN_LER_ID
ColumnGROUP_PL_ID
ColumnGROUP_OIPL_ID
BEN_CWB_PERSON_GROUPS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGROUP_OIPL_ID
ColumnLF_EVT_OCRD_DT
ColumnGROUP_PL_ID
Columns
Name Datatype Length Mandatory Comments
GROUP_PER_IN_LER_ID NUMBER (15) Yes Group Per In Ler Id.
GROUP_PL_ID NUMBER (15) Yes Group Plan .
GROUP_OIPL_ID NUMBER (15) Yes Group Option.
LF_EVT_OCRD_DT DATE
Yes Life Event Occured Date.
BDGT_POP_CD VARCHAR2 (30)
Budget Population Code .
DUE_DT DATE

Due Date .
ACCESS_CD VARCHAR2 (30)
Access Code .
APPROVAL_CD VARCHAR2 (30)
Approval Code .
APPROVAL_DATE DATE

Approval Date .
APPROVAL_COMMENTS VARCHAR2 (2000)
Approval Comment.
SUBMIT_CD VARCHAR2 (30)
Submit Code.
SUBMIT_DATE DATE

Submit Date .
SUBMIT_COMMENTS VARCHAR2 (2000)
SubmitComments.
DIST_BDGT_VAL NUMBER

Distribution Budget Value .
WS_BDGT_VAL NUMBER

Worksheet Budget Value .
RSRV_VAL NUMBER

Reserve Budget Value .
DIST_BDGT_MN_VAL NUMBER

Distribution Budget Min Value
DIST_BDGT_MX_VAL NUMBER

Distribution Budget Max Value
DIST_BDGT_INCR_VAL NUMBER

Distribution Budget Incr Value
WS_BDGT_MN_VAL NUMBER

Worksheet Budget Min Value
WS_BDGT_MX_VAL NUMBER

Worksheet Budget Max Value
WS_BDGT_INCR_VAL NUMBER

Worksheet Budget Incr Value
RSRV_MN_VAL NUMBER

Reserve Budget Min Value
RSRV_MX_VAL NUMBER

Reserve Budget Max Value
RSRV_INCR_VAL NUMBER

Reserve Budget Incr Value
DIST_BDGT_ISS_VAL NUMBER

Distribution Budget Issued Value
WS_BDGT_ISS_VAL NUMBER

Worksheet Budget Issued Value
DFLT_DIST_BDGT_VAL NUMBER

Default Distribution Bugdet Value
DFLT_WS_BDGT_VAL NUMBER

Worksheet Distribution Budget Value.
DIST_BDGT_ISS_DATE DATE

Distribution Budget Issued Date
WS_BDGT_ISS_DATE DATE

Worksheet Budget Issued Date
WS_BDGT_VAL_LAST_UPD_DATE DATE

Worksheet Budget Update Date
DIST_BDGT_VAL_LAST_UPD_DATE DATE

Distribution Budget Update Date
RSRV_VAL_LAST_UPD_DATE DATE

Reserve Budget Update Date
WS_BDGT_VAL_LAST_UPD_BY NUMBER (15)
Worksheet Budget Updated by Person
DIST_BDGT_VAL_LAST_UPD_BY NUMBER (15)
Distribution Budget Updated by Person
RSRV_VAL_LAST_UPD_BY NUMBER (15)
Reserve Budget Updated by Person
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number
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
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
,      LF_EVT_OCRD_DT
,      BDGT_POP_CD
,      DUE_DT
,      ACCESS_CD
,      APPROVAL_CD
,      APPROVAL_DATE
,      APPROVAL_COMMENTS
,      SUBMIT_CD
,      SUBMIT_DATE
,      SUBMIT_COMMENTS
,      DIST_BDGT_VAL
,      WS_BDGT_VAL
,      RSRV_VAL
,      DIST_BDGT_MN_VAL
,      DIST_BDGT_MX_VAL
,      DIST_BDGT_INCR_VAL
,      WS_BDGT_MN_VAL
,      WS_BDGT_MX_VAL
,      WS_BDGT_INCR_VAL
,      RSRV_MN_VAL
,      RSRV_MX_VAL
,      RSRV_INCR_VAL
,      DIST_BDGT_ISS_VAL
,      WS_BDGT_ISS_VAL
,      DFLT_DIST_BDGT_VAL
,      DFLT_WS_BDGT_VAL
,      DIST_BDGT_ISS_DATE
,      WS_BDGT_ISS_DATE
,      WS_BDGT_VAL_LAST_UPD_DATE
,      DIST_BDGT_VAL_LAST_UPD_DATE
,      RSRV_VAL_LAST_UPD_DATE
,      WS_BDGT_VAL_LAST_UPD_BY
,      DIST_BDGT_VAL_LAST_UPD_BY
,      RSRV_VAL_LAST_UPD_BY
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM BEN.BEN_CWB_PERSON_GROUPS;

Dependencies

[top of page]

BEN.BEN_CWB_PERSON_GROUPS does not reference any database object

BEN.BEN_CWB_PERSON_GROUPS is referenced by following:

SchemaBEN
ViewBEN_CWB_PERSON_GROUPS#