[Home] [Help] [Dependency Information]
Object Name: | BENBV_ENRT_RT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BEN.BENBV_ENRT_RT_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RT_STRT_DT | DATE | Rate start date. | ||
RT_STRT_DT_RL | NUMBER | (15) | Foreign Key to FF_FORMULAS_F | |
PROGRAM_UPDATE_DATE | DATE | Program update date. | ||
DFLT_VAL | NUMBER | Default value. | ||
ANN_VAL | NUMBER | Annual Amount. | ||
ANN_MN_ELCN_VAL | NUMBER | Annual minimum. | ||
ANN_MX_ELCN_VAL | NUMBER | Annual maximum. | ||
VAL | NUMBER | Defined amount. | ||
NNMNTRY_UOM | VARCHAR2 | (30) | Rate unit of measure (Lookup code based on lookup type BEN_NNMNTRY_UOM). | |
NNMNTRY_UOM_M | VARCHAR2 | (4000) | Rate unit of measure (Lookup meaning based on lookup type BEN_NNMNTRY_UOM). | |
MX_ELCN_VAL | NUMBER | Maximum defined amount. | ||
MN_ELCN_VAL | NUMBER | Minimum defined amount. | ||
INCRMT_ELCN_VAL | NUMBER | Defined amount increment. | ||
CMCD_MN_ELCN_VAL | NUMBER | Minimum communicated amount. | ||
CMCD_MX_ELCN_VAL | NUMBER | Maximum communicated amount. | ||
CMCD_VAL | NUMBER | Communicated amount. | ||
CMCD_DFLT_VAL | NUMBER | Communicated default amount. | ||
ANN_DFLT_VAL | NUMBER | (15) | Annual default value. | |
DSPLY_MN_ELCN_VAL | NUMBER | (15) | Display minimum election value. | |
DSPLY_MX_ELCN_VAL | NUMBER | (15) | Display maximum election value. | |
ISS_VAL | NUMBER | Defined issued amount. | ||
VAL_LAST_UPD_DATE | DATE | Last updated on. | ||
PP_IN_YR_USED_NUM | NUMBER | (15) | Pay periods in the year used. | |
ORDR_NUM | NUMBER | (15) | Order number. | |
_DF:ECR | CHAR | (23) | ||
ACTY_TYP_CD | VARCHAR2 | (30) | Yes | Activity type (Lookup code based on lookup type BEN_ACTY_TYP). |
ACTY_TYP_CD_M | VARCHAR2 | (4000) | Activity type (Lookup meaning based on lookup type BEN_ACTY_TYP). | |
TX_TYP_CD | VARCHAR2 | (30) | Yes | Tax type (Lookup code based on lookup type BEN_TX_TYP). |
TX_TYP_CD_M | VARCHAR2 | (4000) | Tax type (Lookup meaning based on lookup type BEN_TX_TYP). | |
RT_STRT_DT_CD | VARCHAR2 | (30) | Rate start code (Lookup code based on lookup type BEN_RT_STRT). | |
RT_STRT_DT_CD_M | VARCHAR2 | (4000) | Rate start code (Lookup meaning based on lookup type BEN_RT_STRT). | |
RT_TYP_CD | VARCHAR2 | (30) | Rate type (Lookup code based on lookup type BEN_RT_TYP). | |
RT_TYP_CD_M | VARCHAR2 | (4000) | Rate type (Lookup meaning based on lookup type BEN_RT_TYP). | |
CMCD_ACTY_REF_PERD_CD | VARCHAR2 | (30) | Communicated amount period (Lookup code based on lookup type BEN_ENRT_INFO_RT_FREQ). | |
CMCD_ACTY_REF_PERD_CD_M | VARCHAR2 | (4000) | Communicated amount period (Lookup meaning based on lookup type BEN_ENRT_INFO_RT_FREQ). | |
RT_USG_CD | VARCHAR2 | (30) | Rate usage (Lookup code based on lookup type BEN_RT_USG). | |
RT_USG_CD_M | VARCHAR2 | (4000) | Rate usage (Lookup meaning based on lookup type BEN_RT_USG). | |
BNFT_RT_TYP_CD | VARCHAR2 | (30) | Benefit rate type (Lookup code based on lookup type BEN_BNFT_RT_TYP). | |
BNFT_RT_TYP_CD_M | VARCHAR2 | (4000) | Benefit rate type (Lookup meaning based on lookup type BEN_BNFT_RT_TYP). | |
RT_MLT_CD | VARCHAR2 | (30) | Calculation method (Lookup code based on lookup type BEN_MLT). | |
RT_MLT_CD_M | VARCHAR2 | (4000) | Calculation method (Lookup meaning based on lookup type BEN_MLT). | |
CTFN_RQD_FLAG | VARCHAR2 | (30) | Yes | Certification required (Lookup code based on lookup type YES_NO). |
CTFN_RQD_FLAG_M | VARCHAR2 | (4000) | Certification required (Lookup meaning based on lookup type YES_NO). | |
DFLT_FLAG | VARCHAR2 | (30) | Yes | Default rate (Lookup code based on lookup type YES_NO). |
DFLT_FLAG_M | VARCHAR2 | (4000) | Default rate (Lookup meaning based on lookup type YES_NO). | |
DFLT_PNDG_CTFN_FLAG | VARCHAR2 | (30) | Yes | Default pending certification (Lookup code based on lookup type YES_NO). |
DFLT_PNDG_CTFN_FLAG_M | VARCHAR2 | (4000) | Default pending certification (Lookup meaning based on lookup type YES_NO). | |
DSPLY_ON_ENRT_FLAG | VARCHAR2 | (30) | Yes | Display rate on enrollment (Lookup code based on lookup type YES_NO). |
DSPLY_ON_ENRT_FLAG_M | VARCHAR2 | (4000) | Display rate on enrollment (Lookup meaning based on lookup type YES_NO). | |
USE_TO_CALC_NET_FLX_CR_FLAG | VARCHAR2 | (30) | Yes | Use to calculate net flexible credit (Lookup code based on lookup type YES_NO). |
USE_TO_CALC_NET_FLX_CR_FLAG_M | VARCHAR2 | (4000) | Use to calculate net flexible credit (Lookup meaning based on lookup type YES_NO). | |
ENTR_VAL_AT_ENRT_FLAG | VARCHAR2 | (30) | Yes | Enter value at enrollment (Lookup code based on lookup type YES_NO). |
ENTR_VAL_AT_ENRT_FLAG_M | VARCHAR2 | (4000) | Enter value at enrollment (Lookup meaning based on lookup type YES_NO). | |
ASN_ON_ENRT_FLAG | VARCHAR2 | (30) | Yes | Assign on enrollment (Lookup code based on lookup type YES_NO). |
ASN_ON_ENRT_FLAG_M | VARCHAR2 | (4000) | Assign on enrollment (Lookup meaning based on lookup type YES_NO). | |
RL_CRS_ONLY_FLAG | VARCHAR2 | (30) | Yes | Rule credits only (Lookup code based on lookup type YES_NO). |
RL_CRS_ONLY_FLAG_M | VARCHAR2 | (4000) | Rule credits only (Lookup meaning based on lookup type YES_NO). | |
ENTR_ANN_VAL_FLAG | VARCHAR2 | (30) | Yes | Enter annual value (Lookup code based on lookup type YES_NO). |
ENTR_ANN_VAL_FLAG_M | VARCHAR2 | (4000) | Enter annual value (Lookup meaning based on lookup type YES_NO). | |
ENRT_RT_ID | NUMBER | (15) | Yes | System generated primary key column. |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign Key to HR_ORGANIZATION_UNITS. |
ACTY_BASE_RT_ID | NUMBER | (15) | Yes | Foreign key to BEN_ACTY_BASE_RT_F. |
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_BNFT. | |
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. | |
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. | |
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 - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_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). | |
DECR_BNFT_PRVDR_POOL_ID | NUMBER | (15) | Foreign Key to DECR_BNFT_PRVDR_POOL_F. | |
PRTT_RT_VAL_ID | NUMBER | (15) | Foreign key to BEN_PRTT_RT_VAL. | |
VAL_LAST_UPD_PERSON_ID | NUMBER | (15) | Foreign Key to PER_ALL_PEOPLE_F. | |
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. |
Cut, paste (and edit) the following text to query this object:
SELECT RT_STRT_DT
, RT_STRT_DT_RL
, PROGRAM_UPDATE_DATE
, DFLT_VAL
, ANN_VAL
, ANN_MN_ELCN_VAL
, ANN_MX_ELCN_VAL
, VAL
, NNMNTRY_UOM
, NNMNTRY_UOM_M
, MX_ELCN_VAL
, MN_ELCN_VAL
, INCRMT_ELCN_VAL
, CMCD_MN_ELCN_VAL
, CMCD_MX_ELCN_VAL
, CMCD_VAL
, CMCD_DFLT_VAL
, ANN_DFLT_VAL
, DSPLY_MN_ELCN_VAL
, DSPLY_MX_ELCN_VAL
, ISS_VAL
, VAL_LAST_UPD_DATE
, PP_IN_YR_USED_NUM
, ORDR_NUM
, _DF:ECR
, ACTY_TYP_CD
, ACTY_TYP_CD_M
, TX_TYP_CD
, TX_TYP_CD_M
, RT_STRT_DT_CD
, RT_STRT_DT_CD_M
, RT_TYP_CD
, RT_TYP_CD_M
, CMCD_ACTY_REF_PERD_CD
, CMCD_ACTY_REF_PERD_CD_M
, RT_USG_CD
, RT_USG_CD_M
, BNFT_RT_TYP_CD
, BNFT_RT_TYP_CD_M
, RT_MLT_CD
, RT_MLT_CD_M
, CTFN_RQD_FLAG
, CTFN_RQD_FLAG_M
, DFLT_FLAG
, DFLT_FLAG_M
, DFLT_PNDG_CTFN_FLAG
, DFLT_PNDG_CTFN_FLAG_M
, DSPLY_ON_ENRT_FLAG
, DSPLY_ON_ENRT_FLAG_M
, USE_TO_CALC_NET_FLX_CR_FLAG
, USE_TO_CALC_NET_FLX_CR_FLAG_M
, ENTR_VAL_AT_ENRT_FLAG
, ENTR_VAL_AT_ENRT_FLAG_M
, ASN_ON_ENRT_FLAG
, ASN_ON_ENRT_FLAG_M
, RL_CRS_ONLY_FLAG
, RL_CRS_ONLY_FLAG_M
, ENTR_ANN_VAL_FLAG
, ENTR_ANN_VAL_FLAG_M
, ENRT_RT_ID
, BUSINESS_GROUP_ID
, ACTY_BASE_RT_ID
, 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
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, DECR_BNFT_PRVDR_POOL_ID
, PRTT_RT_VAL_ID
, VAL_LAST_UPD_PERSON_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.BENBV_ENRT_RT_V;
|
|
|