[Home] [Help] [Dependency Information]
Object Name: | BEN_CMBN_PTIP_OPT_F |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_CMBN_PTIP_OPT_F |
Subobject Name: | |
Status: | VALID |
BEN_CMBN_PTIP_OPT_F is a collection of plan types in a program further refined by option that may provide credits to a participant for enrolling in one or more plans of the specified plan types and options in the program.
.
For example, the combination plan type in program of "Health Benefit Participant Only"
may be comprised of Medical Participant Only, Dental Participant Only, and
Vision Participant Only Plan Types and Options.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_CMBN_PTIP_OPT_F_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CMBN_PTIP_OPT_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
BEN_CMBN_PTIP_OPT_F_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CMBN_PTIP_OPT_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 |
PTIP_ID | NUMBER | (15) | Foreign Key to BEN_PTIP_F. | |
CPT_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column. | |
CPT_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CPT_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CPT_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CPT_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CPT_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CPT_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CPT_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CPT_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CPT_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CPT_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CPT_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CPT_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CPT_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CPT_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CPT_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CPT_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CPT_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CPT_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CPT_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CPT_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CPT_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CPT_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CPT_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CPT_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CPT_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CPT_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CPT_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CPT_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CPT_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CPT_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. | |
NAME | VARCHAR2 | (240) | Name of the combination plan type in program option. | |
PGM_ID | NUMBER | (15) | Yes | Foreign key to BEN_PGM_F. |
OPT_ID | NUMBER | (15) | Yes | Foreign Key to BEN_OPT_F. |
Cut, paste (and edit) the following text to query this object:
SELECT CMBN_PTIP_OPT_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, PTIP_ID
, CPT_ATTRIBUTE_CATEGORY
, CPT_ATTRIBUTE1
, CPT_ATTRIBUTE2
, CPT_ATTRIBUTE3
, CPT_ATTRIBUTE4
, CPT_ATTRIBUTE5
, CPT_ATTRIBUTE6
, CPT_ATTRIBUTE7
, CPT_ATTRIBUTE8
, CPT_ATTRIBUTE9
, CPT_ATTRIBUTE10
, CPT_ATTRIBUTE11
, CPT_ATTRIBUTE12
, CPT_ATTRIBUTE13
, CPT_ATTRIBUTE14
, CPT_ATTRIBUTE15
, CPT_ATTRIBUTE16
, CPT_ATTRIBUTE17
, CPT_ATTRIBUTE18
, CPT_ATTRIBUTE19
, CPT_ATTRIBUTE20
, CPT_ATTRIBUTE21
, CPT_ATTRIBUTE22
, CPT_ATTRIBUTE23
, CPT_ATTRIBUTE24
, CPT_ATTRIBUTE25
, CPT_ATTRIBUTE26
, CPT_ATTRIBUTE27
, CPT_ATTRIBUTE28
, CPT_ATTRIBUTE29
, CPT_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, NAME
, PGM_ID
, OPT_ID
FROM BEN.BEN_CMBN_PTIP_OPT_F;
BEN.BEN_CMBN_PTIP_OPT_F does not reference any database object
BEN.BEN_CMBN_PTIP_OPT_F is referenced by following:
|
|
|