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

TABLE: BEN.BEN_CBR_QUALD_BNF_RBV

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


BEN_CBR_QUALD_BNF_RBV contains persons who have experienced
life event which may make the person eligible to participate in extended
benefits as legislated under the United States' Consolidated Omnibus
Budget Reconciliation Act (COBRA). It also contains information about whether
the person elected to participate in those benefits and when the person
will no longer be eligible for those benefits.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BEN_CBR_QUALD_BNF_RBV_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBENEFIT_ACTION_ID
ColumnCBR_QUALD_BNF_ID
BEN_CBR_QUALD_BNF_RBV_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERSON_ACTION_ID
Columns
Name Datatype Length Mandatory Comments
CBR_QUALD_BNF_ID NUMBER (15) Yes System generated primary key column.
QUALD_BNF_FLAG VARCHAR2 (30) Yes Qualified Beneficiary Y or N.
QUALD_BNF_PERSON_ID NUMBER (15) Yes Foreign key to PER_PEOPLE_F.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign Key to HR_ORGANIZATION_UNITS
CQB_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure defining column.
CQB_ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment column.
CQB_ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment column.
CQB_ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment column.
CQB_ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment column.
CQB_ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment column.
CQB_ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment column.
CQB_ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment column.
CQB_ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment column.
CQB_ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment column.
CQB_ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment column.
CQB_ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment column.
CQB_ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment column.
CQB_ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment column.
CQB_ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment column.
CQB_ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment column.
CQB_ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield segment column.
CQB_ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield segment column.
CQB_ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield segment column.
CQB_ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield segment column.
CQB_ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield segment column.
CQB_ATTRIBUTE21 VARCHAR2 (150)
Descriptive Flexfield segment column.
CQB_ATTRIBUTE22 VARCHAR2 (150)
Descriptive Flexfield segment column.
CQB_ATTRIBUTE23 VARCHAR2 (150)
Descriptive Flexfield segment column.
CQB_ATTRIBUTE24 VARCHAR2 (150)
Descriptive Flexfield segment column.
CQB_ATTRIBUTE25 VARCHAR2 (150)
Descriptive Flexfield segment column.
CQB_ATTRIBUTE26 VARCHAR2 (150)
Descriptive Flexfield segment column.
CQB_ATTRIBUTE27 VARCHAR2 (150)
Descriptive Flexfield segment column.
CQB_ATTRIBUTE28 VARCHAR2 (150)
Descriptive Flexfield segment column.
CQB_ATTRIBUTE29 VARCHAR2 (150)
Descriptive Flexfield segment column.
CQB_ATTRIBUTE30 VARCHAR2 (150)
Descriptive Flexfield segment column.
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).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
OBJECT_VERSION_NUMBER NUMBER (9)
System-generated primary key. Increments by one each update.
CBR_ELIG_PERD_STRT_DT DATE

Cobra eligibility period start date.
CBR_ELIG_PERD_END_DT DATE

Cobra eligibility period end date.
CVRD_EMP_PERSON_ID NUMBER (15)
Foreign Key to PER_ALL_PEOPLE_F.
CBR_INELG_RSN_CD VARCHAR2 (30)
Cobra ineligible reason.
PGM_ID NUMBER (15)
Foreign key to BEN_PGM_F.
PTIP_ID NUMBER (15)
Foreign Key to BEN_PTIP_F.
PL_TYP_ID NUMBER (15)
Foreign key to BEN_PL_TYP_F.
BENEFIT_ACTION_ID NUMBER (15) Yes Foreign Key to BEN_BENEFIT_ACTIONS.
PERSON_ACTION_ID NUMBER (15)
Foreign Key to BEN_PERSON_ACTIONS.
Query Text

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


SELECT CBR_QUALD_BNF_ID
,      QUALD_BNF_FLAG
,      QUALD_BNF_PERSON_ID
,      BUSINESS_GROUP_ID
,      CQB_ATTRIBUTE_CATEGORY
,      CQB_ATTRIBUTE1
,      CQB_ATTRIBUTE2
,      CQB_ATTRIBUTE3
,      CQB_ATTRIBUTE4
,      CQB_ATTRIBUTE5
,      CQB_ATTRIBUTE6
,      CQB_ATTRIBUTE7
,      CQB_ATTRIBUTE8
,      CQB_ATTRIBUTE9
,      CQB_ATTRIBUTE10
,      CQB_ATTRIBUTE11
,      CQB_ATTRIBUTE12
,      CQB_ATTRIBUTE13
,      CQB_ATTRIBUTE14
,      CQB_ATTRIBUTE15
,      CQB_ATTRIBUTE16
,      CQB_ATTRIBUTE17
,      CQB_ATTRIBUTE18
,      CQB_ATTRIBUTE19
,      CQB_ATTRIBUTE20
,      CQB_ATTRIBUTE21
,      CQB_ATTRIBUTE22
,      CQB_ATTRIBUTE23
,      CQB_ATTRIBUTE24
,      CQB_ATTRIBUTE25
,      CQB_ATTRIBUTE26
,      CQB_ATTRIBUTE27
,      CQB_ATTRIBUTE28
,      CQB_ATTRIBUTE29
,      CQB_ATTRIBUTE30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      CBR_ELIG_PERD_STRT_DT
,      CBR_ELIG_PERD_END_DT
,      CVRD_EMP_PERSON_ID
,      CBR_INELG_RSN_CD
,      PGM_ID
,      PTIP_ID
,      PL_TYP_ID
,      BENEFIT_ACTION_ID
,      PERSON_ACTION_ID
FROM BEN.BEN_CBR_QUALD_BNF_RBV;

Dependencies

[top of page]

BEN.BEN_CBR_QUALD_BNF_RBV does not reference any database object

BEN.BEN_CBR_QUALD_BNF_RBV is referenced by following:

SchemaAPPS
SynonymBEN_CBR_QUALD_BNF_RBV
TriggerBEN_CBR_QUALD_BNF_RBV_WHO