[Home] [Help] [Dependency Information]
Object Name: | BEN_BNFT_RSTRN_CTFN_F |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_BNFT_RSTRN_CTFN_F |
Subobject Name: | |
Status: | VALID |
BEN_BNFT_RSTRN_CTFN_F identifies the certification(s) that may be required
when a restriction has been placed on the levels of benefits or coverage, such as
life insurance.
.
For example, the plan provides coverage from 10,000 to 100,000
in increments of 10,000. The person may only increase his or her coverage up
to two multiples of 10,000 and certification must be provided if he or she elects
higher coverage.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_BNFT_RSTRN_CTFN_F_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
BNFT_RSTRN_CTFN_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
BEN_BNFT_RSTRN_CTFN_F_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
BEN_BNFT_RSTRN_CTFN_F_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BNFT_RSTRN_CTFN_ID | NUMBER | (15) | Yes | System generated primary key column. |
EFFECTIVE_START_DATE | DATE | Yes | Effective start date. | |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign Key to HR_ORGANIZATION_UNITS |
EFFECTIVE_END_DATE | DATE | Yes | Effective end date. | |
RQD_FLAG | VARCHAR2 | (30) | Yes | Required Y or N. |
ENRT_CTFN_TYP_CD | VARCHAR2 | (30) | Enrollment certification type. | |
CTFN_RQD_WHEN_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
PL_ID | NUMBER | (15) | Foreign Key to BEN_PL_F. | |
BRC_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column. | |
BRC_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BRC_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BRC_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BRC_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BRC_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BRC_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BRC_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BRC_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BRC_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BRC_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BRC_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BRC_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BRC_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BRC_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BRC_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BRC_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BRC_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BRC_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BRC_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BRC_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BRC_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BRC_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BRC_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BRC_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BRC_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BRC_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BRC_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BRC_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BRC_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BRC_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. |
Cut, paste (and edit) the following text to query this object:
SELECT BNFT_RSTRN_CTFN_ID
, EFFECTIVE_START_DATE
, BUSINESS_GROUP_ID
, EFFECTIVE_END_DATE
, RQD_FLAG
, ENRT_CTFN_TYP_CD
, CTFN_RQD_WHEN_RL
, PL_ID
, BRC_ATTRIBUTE_CATEGORY
, BRC_ATTRIBUTE1
, BRC_ATTRIBUTE2
, BRC_ATTRIBUTE3
, BRC_ATTRIBUTE4
, BRC_ATTRIBUTE5
, BRC_ATTRIBUTE6
, BRC_ATTRIBUTE7
, BRC_ATTRIBUTE8
, BRC_ATTRIBUTE9
, BRC_ATTRIBUTE10
, BRC_ATTRIBUTE11
, BRC_ATTRIBUTE12
, BRC_ATTRIBUTE13
, BRC_ATTRIBUTE14
, BRC_ATTRIBUTE15
, BRC_ATTRIBUTE16
, BRC_ATTRIBUTE17
, BRC_ATTRIBUTE18
, BRC_ATTRIBUTE19
, BRC_ATTRIBUTE20
, BRC_ATTRIBUTE21
, BRC_ATTRIBUTE22
, BRC_ATTRIBUTE23
, BRC_ATTRIBUTE24
, BRC_ATTRIBUTE25
, BRC_ATTRIBUTE26
, BRC_ATTRIBUTE27
, BRC_ATTRIBUTE28
, BRC_ATTRIBUTE29
, BRC_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
FROM BEN.BEN_BNFT_RSTRN_CTFN_F;
BEN.BEN_BNFT_RSTRN_CTFN_F does not reference any database object
BEN.BEN_BNFT_RSTRN_CTFN_F is referenced by following:
|
|
|