[Home] [Help] [Dependency Information]
Object Name: | BEN_ACRS_PTIP_CVG_F |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_ACRS_PTIP_CVG_F |
Subobject Name: | |
Status: | VALID |
BEN_ACRS_PTIP_CVG_F holds the maximum coverage or benefit value for multiple plan types in the same program. For example, if you have plan types of Basic Employee Life Insurance and Supplemental Life Insurance, you could define here that if a person enrolls in
plans of both of these plan types, the total coverage a person is allowed to elect is 1,000,000.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_ACRS_PTIP_CVG_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ACRS_PTIP_CVG_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
BEN_ACRS_PTIP_CVG_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
BEN_ACRS_PTIP_CVG_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PGM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACRS_PTIP_CVG_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 |
NAME | VARCHAR2 | (240) | Name of the across plan type in program coverage. | |
MX_CVG_ALWD_AMT | NUMBER | Maximum coverage allowed amount. | ||
MN_CVG_ALWD_AMT | NUMBER | Minimum coverage allowed amount. | ||
PGM_ID | NUMBER | (15) | Foreign key to BEN_PGM_F. | |
APC_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column. | |
APC_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APC_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APC_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APC_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APC_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APC_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APC_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APC_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APC_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APC_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APC_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APC_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APC_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APC_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APC_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APC_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APC_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APC_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APC_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APC_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APC_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APC_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APC_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APC_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APC_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APC_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APC_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APC_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APC_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APC_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. |
Cut, paste (and edit) the following text to query this object:
SELECT ACRS_PTIP_CVG_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, NAME
, MX_CVG_ALWD_AMT
, MN_CVG_ALWD_AMT
, PGM_ID
, APC_ATTRIBUTE_CATEGORY
, APC_ATTRIBUTE1
, APC_ATTRIBUTE2
, APC_ATTRIBUTE3
, APC_ATTRIBUTE4
, APC_ATTRIBUTE5
, APC_ATTRIBUTE6
, APC_ATTRIBUTE7
, APC_ATTRIBUTE8
, APC_ATTRIBUTE9
, APC_ATTRIBUTE10
, APC_ATTRIBUTE11
, APC_ATTRIBUTE12
, APC_ATTRIBUTE13
, APC_ATTRIBUTE14
, APC_ATTRIBUTE15
, APC_ATTRIBUTE16
, APC_ATTRIBUTE17
, APC_ATTRIBUTE18
, APC_ATTRIBUTE19
, APC_ATTRIBUTE20
, APC_ATTRIBUTE21
, APC_ATTRIBUTE22
, APC_ATTRIBUTE23
, APC_ATTRIBUTE24
, APC_ATTRIBUTE25
, APC_ATTRIBUTE26
, APC_ATTRIBUTE27
, APC_ATTRIBUTE28
, APC_ATTRIBUTE29
, APC_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
FROM BEN.BEN_ACRS_PTIP_CVG_F;
BEN.BEN_ACRS_PTIP_CVG_F does not reference any database object
BEN.BEN_ACRS_PTIP_CVG_F is referenced by following:
|
|
|