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

TABLE: HR.BEN_VALID_DEPENDENT_TYPES

Object Details
Object Name: BEN_VALID_DEPENDENT_TYPES
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.BEN_VALID_DEPENDENT_TYPES
Subobject Name:
Status: VALID


BEN_VALID_DEPENDENT_TYPES holds the list of valid dependent types, and
the maximum number of people who may be included for coverage of a
specific type. For example, there may be a rule that limits spousal
coverage to one spouse. This table is used to validate the creation
of covered dependents.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: BEN_VALID_DEPENDENT_TYPES_PK
  1. ColumnVALID_DEPENDENT_TYPE_ID
Unique Key: BEN_VALID_DEPENDENT_TYPES_UK2
  1. ColumnCOVERAGE_TYPE
  2. ColumnBUSINESS_GROUP_ID
  3. ColumnLEGISLATION_CODE
  4. ColumnCONTACT_TYPE
Indexes
Index Type Uniqueness Tablespace Column
BEN_VALID_DEPENDENT_TYPES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnVALID_DEPENDENT_TYPE_ID
BEN_VALID_DEPENDENT_TYPES_UK2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOVERAGE_TYPE
ColumnBUSINESS_GROUP_ID
ColumnLEGISLATION_CODE
ColumnCONTACT_TYPE
Columns
Name Datatype Length Mandatory Comments
VALID_DEPENDENT_TYPE_ID NUMBER (15) Yes Unique identifier for the dependent type.
BUSINESS_GROUP_ID NUMBER (15)
Foreign key to HR_ALL_ORGANIZATION_UNITS.
LEGISLATION_CODE VARCHAR2 (30)
The legislation in which the dependent type belongs.
CONTACT_TYPE VARCHAR2 (30) Yes Type of contact used to define the maximum limit.
COVERAGE_TYPE VARCHAR2 (30) Yes Type of cover used to define the maximum limit.
MAXIMUM_NUMBER NUMBER (3) Yes Maximum number of covered dependents for this relationship and cover.
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 VALID_DEPENDENT_TYPE_ID
,      BUSINESS_GROUP_ID
,      LEGISLATION_CODE
,      CONTACT_TYPE
,      COVERAGE_TYPE
,      MAXIMUM_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.BEN_VALID_DEPENDENT_TYPES;

Dependencies

[top of page]

HR.BEN_VALID_DEPENDENT_TYPES does not reference any database object

HR.BEN_VALID_DEPENDENT_TYPES is referenced by following:

SchemaHR
ViewBEN_VALID_DEPENDENT_TYPES#