[Home] [Help] [Dependency Information]
Object Name: | BEN_ENRT_RT |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_ENRT_RT |
Subobject Name: | |
Status: | VALID |
BEN_ENRT_RT identifies the rates calculated for a person for a plan or option in plan. It also identifies the values of flexible credits and imputed income values. This is denormalized data, made available primarily to avoid the need for reporting and enrollment processes to calculate these values on the fly.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_ENRT_RT_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | ENRT_RT_ID |
BEN_ENRT_RT_FK3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ELIG_PER_ELCTBL_CHC_ID |
BEN_ENRT_RT_FK5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SPCL_RT_ENRT_RT_ID |
BEN_ENRT_RT_FK6 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ENRT_BNFT_ID |
BEN_ENRT_RT_FK7 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
BEN_ENRT_RT_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ACTY_BASE_RT_ID |
BEN_ENRT_RT_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DECR_BNFT_PRVDR_POOL_ID |
BEN_ENRT_RT_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PRTT_RT_VAL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ENRT_RT_ID | NUMBER | (15) | Yes | System generated primary key column. |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign Key to HR_ORGANIZATION_UNITS |
ACTY_TYP_CD | VARCHAR2 | (30) | Yes | Activity type. |
TX_TYP_CD | VARCHAR2 | (30) | Yes | Tax type. |
CTFN_RQD_FLAG | VARCHAR2 | (30) | Yes | Certification required Y or N. |
DFLT_FLAG | VARCHAR2 | (30) | Yes | Default Y or N. |
DFLT_PNDG_CTFN_FLAG | VARCHAR2 | (30) | Yes | Default pending certifications Y or N. |
DSPLY_ON_ENRT_FLAG | VARCHAR2 | (30) | Yes | Display on Enrollment Y or N. |
USE_TO_CALC_NET_FLX_CR_FLAG | VARCHAR2 | (30) | Yes | Use to calculate net flexible credit Y or N. |
ENTR_VAL_AT_ENRT_FLAG | VARCHAR2 | (30) | Yes | Enter Value At Enrollment Y or N. |
ASN_ON_ENRT_FLAG | VARCHAR2 | (30) | Yes | Assign on Enrollment Y or N. |
RL_CRS_ONLY_FLAG | VARCHAR2 | (30) | Yes | Rule Credits Only Y or N. |
ACTY_BASE_RT_ID | NUMBER | (15) | Yes | Foreign Key to BEN_ACTY_BASE_RT_F. |
ENTR_ANN_VAL_FLAG | VARCHAR2 | (30) | Yes | Enter Annual Value Y or N. |
RT_STRT_DT | DATE | Rate start date. | ||
RT_STRT_DT_CD | VARCHAR2 | (30) | Rate start date code. | |
RT_STRT_DT_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
RT_TYP_CD | VARCHAR2 | (30) | Rate type. | |
ELIG_PER_ELCTBL_CHC_ID | NUMBER | (15) | Foreign key to BEN_ELIG_PER_ELCTBL_CHC. | |
SPCL_RT_ENRT_RT_ID | NUMBER | (15) | Foreign kry to BEN_ENRT_RT. | |
ENRT_BNFT_ID | NUMBER | (15) | Foreign key to BEN_ENRT_BNF_F. | |
CVG_AMT_CALC_MTHD_ID | NUMBER | (15) | Foreign key to BEN_CVG_AMT_CALC_MTHD_F. | |
ACTL_PREM_ID | NUMBER | (15) | Foreign Key to BEN_ACTL_PREM_F. | |
COMP_LVL_FCTR_ID | NUMBER | (15) | Foreign Key to BEN_COMP_LVL_FCTR_F. | |
PTD_COMP_LVL_FCTR_ID | NUMBER | (15) | Foreign key to BEN_PTD_COMP_LVL_FCTR_F. | |
CLM_COMP_LVL_FCTR_ID | NUMBER | (15) | Foreign Key to BEN_CLM_COMP_LVL_FCTR_F. | |
ECR_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column. | |
ECR_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ECR_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ECR_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ECR_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ECR_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ECR_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ECR_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ECR_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ECR_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ECR_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ECR_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ECR_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ECR_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ECR_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ECR_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ECR_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ECR_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ECR_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ECR_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ECR_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ECR_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ECR_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ECR_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ECR_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ECR_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ECR_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ECR_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ECR_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ECR_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ECR_ATTRIBUTE30 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
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. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
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. | |
DFLT_VAL | NUMBER | Default value. | ||
DECR_BNFT_PRVDR_POOL_ID | NUMBER | (15) | Foreign Key to DECR_BNFT_PRVDR_POOL_F. | |
ANN_VAL | NUMBER | Annual value. | ||
ANN_MN_ELCN_VAL | NUMBER | Annual maximum election value. | ||
ANN_MX_ELCN_VAL | NUMBER | Annual minimum election value. | ||
VAL | NUMBER | Value. | ||
PRTT_RT_VAL_ID | NUMBER | (15) | Foreign key to BEN_PRTT_RT_VAL_F. | |
NNMNTRY_UOM | VARCHAR2 | (30) | Non-monentary unit of measure. | |
MX_ELCN_VAL | NUMBER | Maximum election value. | ||
MN_ELCN_VAL | NUMBER | Minimum election value. | ||
INCRMT_ELCN_VAL | NUMBER | Increment election value. | ||
CMCD_ACTY_REF_PERD_CD | VARCHAR2 | (30) | Communicated activity reference period. | |
CMCD_MN_ELCN_VAL | NUMBER | Communicated minimum election value. | ||
CMCD_MX_ELCN_VAL | NUMBER | Communicated maximum election value. | ||
CMCD_VAL | NUMBER | Communicated value. | ||
CMCD_DFLT_VAL | NUMBER | Communicated default value. | ||
RT_USG_CD | VARCHAR2 | (30) | Rate usage. | |
ANN_DFLT_VAL | NUMBER | (15) | Annual default value. | |
BNFT_RT_TYP_CD | VARCHAR2 | (30) | Benefit rate type. | |
RT_MLT_CD | VARCHAR2 | (30) | Rate multiply code. | |
DSPLY_MN_ELCN_VAL | NUMBER | (15) | Display minimum election value. | |
DSPLY_MX_ELCN_VAL | NUMBER | (15) | Display maximum election value. | |
ISS_VAL | NUMBER | iss_val. | ||
VAL_LAST_UPD_DATE | DATE | val_last_upd_date. | ||
VAL_LAST_UPD_PERSON_ID | NUMBER | (15) | val_last_upd_person_id. | |
PP_IN_YR_USED_NUM | NUMBER | (15) | Pay Periods in the year used. | |
ORDR_NUM | NUMBER | (15) | Order Number |
Cut, paste (and edit) the following text to query this object:
SELECT ENRT_RT_ID
, BUSINESS_GROUP_ID
, ACTY_TYP_CD
, TX_TYP_CD
, CTFN_RQD_FLAG
, DFLT_FLAG
, DFLT_PNDG_CTFN_FLAG
, DSPLY_ON_ENRT_FLAG
, USE_TO_CALC_NET_FLX_CR_FLAG
, ENTR_VAL_AT_ENRT_FLAG
, ASN_ON_ENRT_FLAG
, RL_CRS_ONLY_FLAG
, ACTY_BASE_RT_ID
, ENTR_ANN_VAL_FLAG
, RT_STRT_DT
, RT_STRT_DT_CD
, RT_STRT_DT_RL
, RT_TYP_CD
, ELIG_PER_ELCTBL_CHC_ID
, SPCL_RT_ENRT_RT_ID
, ENRT_BNFT_ID
, CVG_AMT_CALC_MTHD_ID
, ACTL_PREM_ID
, COMP_LVL_FCTR_ID
, PTD_COMP_LVL_FCTR_ID
, CLM_COMP_LVL_FCTR_ID
, ECR_ATTRIBUTE_CATEGORY
, ECR_ATTRIBUTE1
, ECR_ATTRIBUTE2
, ECR_ATTRIBUTE3
, ECR_ATTRIBUTE4
, ECR_ATTRIBUTE5
, ECR_ATTRIBUTE6
, ECR_ATTRIBUTE7
, ECR_ATTRIBUTE8
, ECR_ATTRIBUTE9
, ECR_ATTRIBUTE10
, ECR_ATTRIBUTE11
, ECR_ATTRIBUTE12
, ECR_ATTRIBUTE13
, ECR_ATTRIBUTE14
, ECR_ATTRIBUTE15
, ECR_ATTRIBUTE16
, ECR_ATTRIBUTE17
, ECR_ATTRIBUTE18
, ECR_ATTRIBUTE19
, ECR_ATTRIBUTE20
, ECR_ATTRIBUTE21
, ECR_ATTRIBUTE22
, ECR_ATTRIBUTE23
, ECR_ATTRIBUTE24
, ECR_ATTRIBUTE25
, ECR_ATTRIBUTE26
, ECR_ATTRIBUTE27
, ECR_ATTRIBUTE28
, ECR_ATTRIBUTE29
, ECR_ATTRIBUTE30
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, OBJECT_VERSION_NUMBER
, DFLT_VAL
, DECR_BNFT_PRVDR_POOL_ID
, ANN_VAL
, ANN_MN_ELCN_VAL
, ANN_MX_ELCN_VAL
, VAL
, PRTT_RT_VAL_ID
, NNMNTRY_UOM
, MX_ELCN_VAL
, MN_ELCN_VAL
, INCRMT_ELCN_VAL
, CMCD_ACTY_REF_PERD_CD
, CMCD_MN_ELCN_VAL
, CMCD_MX_ELCN_VAL
, CMCD_VAL
, CMCD_DFLT_VAL
, RT_USG_CD
, ANN_DFLT_VAL
, BNFT_RT_TYP_CD
, RT_MLT_CD
, DSPLY_MN_ELCN_VAL
, DSPLY_MX_ELCN_VAL
, ISS_VAL
, VAL_LAST_UPD_DATE
, VAL_LAST_UPD_PERSON_ID
, PP_IN_YR_USED_NUM
, ORDR_NUM
FROM BEN.BEN_ENRT_RT;
BEN.BEN_ENRT_RT does not reference any database object
BEN.BEN_ENRT_RT is referenced by following:
|
|
|