[Home] [Help] [Dependency Information]
Object Name: | BEN_ENRT_BNFT |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_ENRT_BNFT |
Subobject Name: | |
Status: | VALID |
BEN_ENRT_BNFT identifies the coverage or benefit provided by the electable choices available to an eligible person as a result of a life event or for open enrollment. This is denormalized data, made available primarily to avoid the need for reporting and enrollment processes to calculate these values on the fly.
For example, if a specific person chooses group term life insurance at 2 time salary, the coverage provided will be $85,000.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_ENRT_BNFT_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | ENRT_BNFT_ID |
BEN_ENRT_BNFT_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ELIG_PER_ELCTBL_CHC_ID |
BEN_ENRT_BNFT_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
BEN_ENRT_BNFT_FK4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | COMP_LVL_FCTR_ID |
BEN_ENRT_BNFT_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PRTT_ENRT_RSLT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ENRT_BNFT_ID | NUMBER | (15) | Yes | System generated primary key column. |
DFLT_FLAG | VARCHAR2 | (30) | Yes | Default Y or N. |
VAL_HAS_BN_PRORTD_FLAG | VARCHAR2 | (30) | Yes | Value Has Been Prorated Y or N. |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign Key to HR_ORGANIZATION_UNITS |
CTFN_RQD_FLAG | VARCHAR2 | (30) | Yes | Certification required Y or N. |
CRNTLY_ENRLD_FLAG | VARCHAR2 | (30) | Yes | Currently enrolled Y or N. |
ELIG_PER_ELCTBL_CHC_ID | NUMBER | (15) | Yes | Foreign key to BEN_ELIG_PER_ELCTBL_CHC. |
COMP_LVL_FCTR_ID | NUMBER | (15) | Foreign Key to BEN_COMP_LVL_FCTR_F. | |
ENB_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column. | |
ENB_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ENB_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ENB_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ENB_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ENB_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ENB_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ENB_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ENB_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ENB_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ENB_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ENB_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ENB_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ENB_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ENB_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ENB_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ENB_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ENB_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ENB_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ENB_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ENB_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ENB_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ENB_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ENB_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ENB_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ENB_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ENB_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ENB_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ENB_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ENB_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ENB_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. | ||
REQUEST_ID | NUMBER | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | |
PROGRAM_ID | NUMBER | (15) | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | |
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | System-generated primary key. Increments by one each update. | |
BNDRY_PERD_CD | VARCHAR2 | (30) | Boundary period. | |
VAL | NUMBER | Value. | ||
NNMNTRY_UOM | VARCHAR2 | (30) | Non-monentary unit of measure. | |
BNFT_TYP_CD | VARCHAR2 | (30) | Benefit type. | |
ENTR_VAL_AT_ENRT_FLAG | VARCHAR2 | (30) | Enter Value At Enrollment Y or N. | |
MN_VAL | NUMBER | Minimum value. | ||
MX_VAL | NUMBER | Maximum value. | ||
PRTT_ENRT_RSLT_ID | NUMBER | (15) | Foreign key to BEN_PRTT_ENRT_RSLT_F. | |
INCRMT_VAL | NUMBER | Increment value. | ||
RT_TYP_CD | VARCHAR2 | (30) | Rate type. | |
CVG_MLT_CD | VARCHAR2 | (30) | Coverage multiply code. | |
ORDR_NUM | NUMBER | (15) | Order number. | |
DFLT_VAL | NUMBER | Default value. | ||
MX_WOUT_CTFN_VAL | NUMBER | Maximum without certification value. | ||
MX_WO_CTFN_FLAG | VARCHAR2 | (30) | Yes | Maximum without certification Y or N. |
Cut, paste (and edit) the following text to query this object:
SELECT ENRT_BNFT_ID
, DFLT_FLAG
, VAL_HAS_BN_PRORTD_FLAG
, BUSINESS_GROUP_ID
, CTFN_RQD_FLAG
, CRNTLY_ENRLD_FLAG
, ELIG_PER_ELCTBL_CHC_ID
, COMP_LVL_FCTR_ID
, ENB_ATTRIBUTE_CATEGORY
, ENB_ATTRIBUTE1
, ENB_ATTRIBUTE2
, ENB_ATTRIBUTE3
, ENB_ATTRIBUTE4
, ENB_ATTRIBUTE5
, ENB_ATTRIBUTE6
, ENB_ATTRIBUTE7
, ENB_ATTRIBUTE8
, ENB_ATTRIBUTE9
, ENB_ATTRIBUTE10
, ENB_ATTRIBUTE11
, ENB_ATTRIBUTE12
, ENB_ATTRIBUTE13
, ENB_ATTRIBUTE14
, ENB_ATTRIBUTE15
, ENB_ATTRIBUTE16
, ENB_ATTRIBUTE17
, ENB_ATTRIBUTE18
, ENB_ATTRIBUTE19
, ENB_ATTRIBUTE20
, ENB_ATTRIBUTE21
, ENB_ATTRIBUTE22
, ENB_ATTRIBUTE23
, ENB_ATTRIBUTE24
, ENB_ATTRIBUTE25
, ENB_ATTRIBUTE26
, ENB_ATTRIBUTE27
, ENB_ATTRIBUTE28
, ENB_ATTRIBUTE29
, ENB_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, OBJECT_VERSION_NUMBER
, BNDRY_PERD_CD
, VAL
, NNMNTRY_UOM
, BNFT_TYP_CD
, ENTR_VAL_AT_ENRT_FLAG
, MN_VAL
, MX_VAL
, PRTT_ENRT_RSLT_ID
, INCRMT_VAL
, RT_TYP_CD
, CVG_MLT_CD
, ORDR_NUM
, DFLT_VAL
, MX_WOUT_CTFN_VAL
, MX_WO_CTFN_FLAG
FROM BEN.BEN_ENRT_BNFT;
BEN.BEN_ENRT_BNFT does not reference any database object
BEN.BEN_ENRT_BNFT is referenced by following:
|
|
|