eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: HR.PER_COBRA_QFYING_EVENTS_F

Object Details

Object Name:	PER_COBRA_QFYING_EVENTS_F
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.PER_COBRA_QFYING_EVENTS_F
Subobject Name:
Status:	VALID

PER_COBRA_QFYING_EVENTS_F is the DateTracked table holding the events
that have meaning in the context of COBRA coverage. These include,
for example, divorce, termination of employment and death.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PER_COBRA_QFYING_EVENTS_F_PK

QUALIFYING_EVENT_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE

Unique Key: PER_COBRA_QFYING_EVENTS_F_UK2

QUALIFYING_EVENT
BUSINESS_GROUP_ID
LEGISLATION_CODE
LEGISLATION_SUBGROUP
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_COBRA_QFYING_EVENTS_F_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	QUALIFYING_EVENT_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE
PER_COBRA_QFYING_EVENTS_F_UK2	NORMAL	UNIQUE	APPS_TS_TX_IDX	QUALIFYING_EVENT BUSINESS_GROUP_ID LEGISLATION_CODE LEGISLATION_SUBGROUP EFFECTIVE_START_DATE EFFECTIVE_END_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
QUALIFYING_EVENT_ID	NUMBER	(15)	Yes	Primary key.
EFFECTIVE_START_DATE	DATE		Yes	Effective start date.
EFFECTIVE_END_DATE	DATE		Yes	Effective end date.
BUSINESS_GROUP_ID	NUMBER	(15)		Foreign key to HR_ORGANIZATION_UNITS.
LEGISLATION_CODE	VARCHAR2	(30)		Legislation code for this data. Always US for this entity.
ELECTOR	VARCHAR2	(1)	Yes	Person who elects to have the coverage. E(mployee) or D(ependent).
EVENT_COVERAGE	NUMBER	(2)	Yes	Maximum duration for coverage, in months.
QUALIFYING_EVENT	VARCHAR2	(30)	Yes	Type of qualifying event, from US_COBRA_EVENT lookup type.
LEGISLATION_SUBGROUP	VARCHAR2	(30)		Further identifies the legislation of startup data.
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 QUALIFYING_EVENT_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      BUSINESS_GROUP_ID
,      LEGISLATION_CODE
,      ELECTOR
,      EVENT_COVERAGE
,      QUALIFYING_EVENT
,      LEGISLATION_SUBGROUP
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PER_COBRA_QFYING_EVENTS_F;

Dependencies

[top of page]

HR.PER_COBRA_QFYING_EVENTS_F does not reference any database object

HR.PER_COBRA_QFYING_EVENTS_F is referenced by following:

APPS: PER_COBRA_QFYING_EVENTS_F; PER_COBRA_QFYING_EVENTS_F_WHO
PUBLIC: PER_COBRA_QFYING_EVENTS_F