[Home] [Help] [Dependency Information]
Object Name: | BEN_DPNT_CVRD_ANTHR_OIPL_CVG_F |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_DPNT_CVRD_ANTHR_OIPL_CVG_F |
Subobject Name: | |
Status: | VALID |
BEN_DPNT_CVRD_ANTHR_OIPL_CVG_F identifies under which other options in plans a person must have or have had coverage in order to be eligible for coverage under this dependent eligbility profile(most common)or options in plans under which the person may not have or have had coverage in or to qualify (less common).
.
BEN_DPNT_CVRD_ANTHR_OIPL_CVG_F is the
intersection of BEN_DPNT_CVG_ELIGY_PRFL_F and BEN_OIPL_F.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_DPNT_CVRD_ANTHR_OIPL_CV_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
DPNT_CVRD_ANTHR_OIPL_CVG_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
BEN_DPNT_CVRD_ANTHR_OIPL_C_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
BEN_DPNT_CVRD_ANTHR_OIPL_C_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | OIPL_ID |
BEN_DPNT_CVRD_ANTHR_OIPL_C_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DPNT_CVG_ELIGY_PRFL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DPNT_CVRD_ANTHR_OIPL_CVG_ID | NUMBER | (15) | Yes | Foreign key to BEN_DPNT_CVRD_ANTHR_OIPL_CVG_F. |
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 |
EXCLD_FLAG | VARCHAR2 | (30) | Yes | Exclude Y or N. |
OIPL_ID | NUMBER | (15) | Yes | Foreign Key to BEN_OIPL_F. |
DPNT_CVG_ELIGY_PRFL_ID | NUMBER | (15) | Yes | Foreign Key to BEN_DPNT_CVG_ELIGY_PRFL_F. |
DOC_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column. | |
DOC_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
DOC_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
DOC_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
DOC_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
DOC_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
DOC_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
DOC_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
DOC_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
DOC_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
DOC_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
DOC_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
DOC_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
DOC_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
DOC_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
DOC_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
DOC_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
DOC_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
DOC_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
DOC_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
DOC_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
DOC_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
DOC_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
DOC_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
DOC_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
DOC_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
DOC_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
DOC_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
DOC_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
DOC_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
DOC_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. | |
CVG_DET_DT_CD | VARCHAR2 | (30) | Coverage determination date code. | |
ORDR_NUM | NUMBER | (15) | Order number. |
Cut, paste (and edit) the following text to query this object:
SELECT DPNT_CVRD_ANTHR_OIPL_CVG_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, EXCLD_FLAG
, OIPL_ID
, DPNT_CVG_ELIGY_PRFL_ID
, DOC_ATTRIBUTE_CATEGORY
, DOC_ATTRIBUTE1
, DOC_ATTRIBUTE2
, DOC_ATTRIBUTE3
, DOC_ATTRIBUTE4
, DOC_ATTRIBUTE5
, DOC_ATTRIBUTE6
, DOC_ATTRIBUTE7
, DOC_ATTRIBUTE8
, DOC_ATTRIBUTE9
, DOC_ATTRIBUTE10
, DOC_ATTRIBUTE11
, DOC_ATTRIBUTE12
, DOC_ATTRIBUTE13
, DOC_ATTRIBUTE14
, DOC_ATTRIBUTE15
, DOC_ATTRIBUTE16
, DOC_ATTRIBUTE17
, DOC_ATTRIBUTE18
, DOC_ATTRIBUTE19
, DOC_ATTRIBUTE20
, DOC_ATTRIBUTE21
, DOC_ATTRIBUTE22
, DOC_ATTRIBUTE23
, DOC_ATTRIBUTE24
, DOC_ATTRIBUTE25
, DOC_ATTRIBUTE26
, DOC_ATTRIBUTE27
, DOC_ATTRIBUTE28
, DOC_ATTRIBUTE29
, DOC_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, CVG_DET_DT_CD
, ORDR_NUM
FROM BEN.BEN_DPNT_CVRD_ANTHR_OIPL_CVG_F;
BEN.BEN_DPNT_CVRD_ANTHR_OIPL_CVG_F does not reference any database object
BEN.BEN_DPNT_CVRD_ANTHR_OIPL_CVG_F is referenced by following:
|
|
|