[Home] [Help] [Dependency Information]
Object Name: | BEN_WV_PRTN_RSN_CTFN_PTIP_F |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_WV_PRTN_RSN_CTFN_PTIP_F |
Subobject Name: | |
Status: | VALID |
BEN_WV_PRTN_RSN_CTFN_PTIP_F identifies the certification that may be required when a person waives coverage in a plan type in program for a specified reason as opposed to actively electing a "Waive" plan. For example, if an eligible person waives participation in all medical plans for the reason of "have other coverage", he or she may be required to provide proof of coverage in an external plan.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_WV_PRTN_RSN_CTFN_PTIP_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
WV_PRTN_RSN_CTFN_PTIP_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
BEN_WV_PRTN_RSN_CTFN_PTIP_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
BEN_WV_PRTN_RSN_CTFN_PTIP_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | WV_PRTN_RSN_PTIP_ID |
BEN_WV_PRTN_RSN_CTFN_PTIP_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CTFN_RQD_WHEN_RL |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WV_PRTN_RSN_CTFN_PTIP_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 |
LACK_CTFN_SSPND_WVR_FLAG | VARCHAR2 | (30) | Yes | Lack of certification suspend waiver Y or N. |
RQD_FLAG | VARCHAR2 | (30) | Yes | Required Y or N. |
PFD_FLAG | VARCHAR2 | (30) | Yes | Preferred Y or N. |
WV_PRTN_CTFN_TYP_CD | VARCHAR2 | (30) | Yes | Waive participation certification type. |
WV_PRTN_RSN_PTIP_ID | NUMBER | (15) | Yes | Foreign key to BEN_WV_PRTN_RSN_PTIP_F. |
CTFN_RQD_WHEN_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
WCT_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column. | |
WCT_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
WCT_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
WCT_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
WCT_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
WCT_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
WCT_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
WCT_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
WCT_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
WCT_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
WCT_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
WCT_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
WCT_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
WCT_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
WCT_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
WCT_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
WCT_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
WCT_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
WCT_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
WCT_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
WCT_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
WCT_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
WCT_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
WCT_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
WCT_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
WCT_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
WCT_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
WCT_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
WCT_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
WCT_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
WCT_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. | |
WV_PRTN_CTFN_CD | VARCHAR2 | (30) | No longer used. |
Cut, paste (and edit) the following text to query this object:
SELECT WV_PRTN_RSN_CTFN_PTIP_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, LACK_CTFN_SSPND_WVR_FLAG
, RQD_FLAG
, PFD_FLAG
, WV_PRTN_CTFN_TYP_CD
, WV_PRTN_RSN_PTIP_ID
, CTFN_RQD_WHEN_RL
, WCT_ATTRIBUTE_CATEGORY
, WCT_ATTRIBUTE1
, WCT_ATTRIBUTE2
, WCT_ATTRIBUTE3
, WCT_ATTRIBUTE4
, WCT_ATTRIBUTE5
, WCT_ATTRIBUTE6
, WCT_ATTRIBUTE7
, WCT_ATTRIBUTE8
, WCT_ATTRIBUTE9
, WCT_ATTRIBUTE10
, WCT_ATTRIBUTE11
, WCT_ATTRIBUTE12
, WCT_ATTRIBUTE13
, WCT_ATTRIBUTE14
, WCT_ATTRIBUTE15
, WCT_ATTRIBUTE16
, WCT_ATTRIBUTE17
, WCT_ATTRIBUTE18
, WCT_ATTRIBUTE19
, WCT_ATTRIBUTE20
, WCT_ATTRIBUTE21
, WCT_ATTRIBUTE22
, WCT_ATTRIBUTE23
, WCT_ATTRIBUTE24
, WCT_ATTRIBUTE25
, WCT_ATTRIBUTE26
, WCT_ATTRIBUTE27
, WCT_ATTRIBUTE28
, WCT_ATTRIBUTE29
, WCT_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, WV_PRTN_CTFN_CD
FROM BEN.BEN_WV_PRTN_RSN_CTFN_PTIP_F;
BEN.BEN_WV_PRTN_RSN_CTFN_PTIP_F does not reference any database object
BEN.BEN_WV_PRTN_RSN_CTFN_PTIP_F is referenced by following:
|
|
|