[Home] [Help] [Dependency Information]
Object Name: | BEN_PTIP_DPNT_CVG_CTFN_F |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_PTIP_DPNT_CVG_CTFN_F |
Subobject Name: | |
Status: | VALID |
BEN_PTIP_DPNT_CVG_CTFN_F identifies the certifications that may be required when participants designate contacts that have been determine to be eligible for coverage under the terms identifies by the plan type for the plan or option in plan under which the participant is covering the dependent.
.
For example, a participant requests the addition of a new dependent for the Stay Healthy Family medical coverage and a certification of proof of birth or adoption is required for all Medical Plans in the program.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_PTIP_DPNT_CVG_CTFN_F_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PTIP_DPNT_CVG_CTFN_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
BEN_PTIP_DPNT_CVG_CTFN_F_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
BEN_PTIP_DPNT_CVG_CTFN_F_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PTIP_ID |
BEN_PTIP_DPNT_CVG_CTFN_F_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CTFN_RQD_WHEN_RL |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PTIP_DPNT_CVG_CTFN_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 |
PFD_FLAG | VARCHAR2 | (30) | Yes | Preferred Y or N. |
LACK_CTFN_SSPND_ENRT_FLAG | VARCHAR2 | (30) | Yes | Lack of certification suspend enrollment Y or N. |
PTIP_ID | NUMBER | (15) | Yes | Foreign Key to BEN_PTIP_F. |
DPNT_CVG_CTFN_TYP_CD | VARCHAR2 | (30) | Yes | Dependent coverage certification type. |
RQD_FLAG | VARCHAR2 | (30) | Yes | Required Y or N. |
CTFN_RQD_WHEN_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
PYD_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column. | |
PYD_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PYD_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PYD_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PYD_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PYD_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PYD_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PYD_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PYD_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PYD_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PYD_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PYD_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PYD_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PYD_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PYD_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PYD_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PYD_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PYD_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PYD_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PYD_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PYD_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PYD_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PYD_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PYD_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PYD_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PYD_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PYD_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PYD_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PYD_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PYD_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PYD_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. | |
RLSHP_TYP_CD | VARCHAR2 | (30) | Relationship type. |
Cut, paste (and edit) the following text to query this object:
SELECT PTIP_DPNT_CVG_CTFN_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, PFD_FLAG
, LACK_CTFN_SSPND_ENRT_FLAG
, PTIP_ID
, DPNT_CVG_CTFN_TYP_CD
, RQD_FLAG
, CTFN_RQD_WHEN_RL
, PYD_ATTRIBUTE_CATEGORY
, PYD_ATTRIBUTE1
, PYD_ATTRIBUTE2
, PYD_ATTRIBUTE3
, PYD_ATTRIBUTE4
, PYD_ATTRIBUTE5
, PYD_ATTRIBUTE6
, PYD_ATTRIBUTE7
, PYD_ATTRIBUTE8
, PYD_ATTRIBUTE9
, PYD_ATTRIBUTE10
, PYD_ATTRIBUTE11
, PYD_ATTRIBUTE12
, PYD_ATTRIBUTE13
, PYD_ATTRIBUTE14
, PYD_ATTRIBUTE15
, PYD_ATTRIBUTE16
, PYD_ATTRIBUTE17
, PYD_ATTRIBUTE18
, PYD_ATTRIBUTE19
, PYD_ATTRIBUTE20
, PYD_ATTRIBUTE21
, PYD_ATTRIBUTE22
, PYD_ATTRIBUTE23
, PYD_ATTRIBUTE24
, PYD_ATTRIBUTE25
, PYD_ATTRIBUTE26
, PYD_ATTRIBUTE27
, PYD_ATTRIBUTE28
, PYD_ATTRIBUTE29
, PYD_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, RLSHP_TYP_CD
FROM BEN.BEN_PTIP_DPNT_CVG_CTFN_F;
BEN.BEN_PTIP_DPNT_CVG_CTFN_F does not reference any database object
BEN.BEN_PTIP_DPNT_CVG_CTFN_F is referenced by following:
|
|
|