[Home] [Help] [Dependency Information]
Object Name: | BEN_APLD_DPNT_CVG_ELIG_PRFL_F |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_APLD_DPNT_CVG_ELIG_PRFL_F |
Subobject Name: | |
Status: | VALID |
BEN_APLD_DPNT_CVG_ELIG_PRFL_F specifieswhich dependent coverage eligiblity profiles are being used by which programs, plan types in programs, plans in programs, or plans. Although many
dependent coverage eligibility profiles may be specified, the potentially covered dependent must satisfy all required profiles and one of any optional profiles.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_APLD_DPNT_CVG_ELIG_PRF_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
APLD_DPNT_CVG_ELIG_PRFL_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
BEN_APLD_DPNT_CVG_ELIG_PRF_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
BEN_APLD_DPNT_CVG_ELIG_PRF_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | APLD_DPNT_CVG_ELIG_RL |
BEN_APLD_DPNT_CVG_ELIG_PRF_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PGM_ID |
BEN_APLD_DPNT_CVG_ELIG_PRF_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PTIP_ID |
BEN_APLD_DPNT_CVG_ELIG_PRF_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DPNT_CVG_ELIGY_PRFL_ID |
BEN_APLD_DPNT_CVG_ELIG_PRF_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APLD_DPNT_CVG_ELIG_PRFL_ID | NUMBER | (15) | Yes | System generated primary key column. |
EFFECTIVE_START_DATE | DATE | Yes | Effective start date. | |
EFFECTIVE_END_DATE | DATE | Yes | Effective end date. | |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign Key to HR_ORGANIZATION_UNITS |
MNDTRY_FLAG | VARCHAR2 | (30) | Yes | Mandatory Y or N. |
ADE_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column. | |
ADE_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ADE_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ADE_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ADE_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ADE_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ADE_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ADE_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ADE_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ADE_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ADE_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ADE_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ADE_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ADE_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ADE_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ADE_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ADE_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ADE_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ADE_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ADE_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ADE_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ADE_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ADE_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ADE_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ADE_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ADE_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ADE_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ADE_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ADE_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ADE_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ADE_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. | |
APLD_DPNT_CVG_ELIG_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
PGM_ID | NUMBER | (15) | Foreign key to BEN_PGM_F. | |
PTIP_ID | NUMBER | (15) | Foreign Key to BEN_PTIP_F. | |
DPNT_CVG_ELIGY_PRFL_ID | NUMBER | (15) | Foreign Key to BEN_DPNT_CVG_ELIGY_PRFL_F. | |
PL_ID | NUMBER | (15) | Foreign Key to BEN_PL_F. |
Cut, paste (and edit) the following text to query this object:
SELECT APLD_DPNT_CVG_ELIG_PRFL_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, MNDTRY_FLAG
, ADE_ATTRIBUTE_CATEGORY
, ADE_ATTRIBUTE1
, ADE_ATTRIBUTE2
, ADE_ATTRIBUTE3
, ADE_ATTRIBUTE4
, ADE_ATTRIBUTE5
, ADE_ATTRIBUTE6
, ADE_ATTRIBUTE7
, ADE_ATTRIBUTE8
, ADE_ATTRIBUTE9
, ADE_ATTRIBUTE10
, ADE_ATTRIBUTE11
, ADE_ATTRIBUTE12
, ADE_ATTRIBUTE13
, ADE_ATTRIBUTE14
, ADE_ATTRIBUTE15
, ADE_ATTRIBUTE16
, ADE_ATTRIBUTE17
, ADE_ATTRIBUTE18
, ADE_ATTRIBUTE19
, ADE_ATTRIBUTE20
, ADE_ATTRIBUTE21
, ADE_ATTRIBUTE22
, ADE_ATTRIBUTE23
, ADE_ATTRIBUTE24
, ADE_ATTRIBUTE25
, ADE_ATTRIBUTE26
, ADE_ATTRIBUTE27
, ADE_ATTRIBUTE28
, ADE_ATTRIBUTE29
, ADE_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, APLD_DPNT_CVG_ELIG_RL
, PGM_ID
, PTIP_ID
, DPNT_CVG_ELIGY_PRFL_ID
, PL_ID
FROM BEN.BEN_APLD_DPNT_CVG_ELIG_PRFL_F;
BEN.BEN_APLD_DPNT_CVG_ELIG_PRFL_F does not reference any database object
BEN.BEN_APLD_DPNT_CVG_ELIG_PRFL_F is referenced by following:
|
|
|