Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: BEN.BEN_ENRT_RT_RBV#

Object Details
Object Name: BEN_ENRT_RT_RBV#
Object Type: VIEW
Owner: BEN
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ENRT_RT_ID NUMBER (15) Yes
BUSINESS_GROUP_ID NUMBER (15) Yes
ACTY_TYP_CD VARCHAR2 (30) Yes
TX_TYP_CD VARCHAR2 (30) Yes
CTFN_RQD_FLAG VARCHAR2 (30) Yes
DFLT_FLAG VARCHAR2 (30) Yes
DFLT_PNDG_CTFN_FLAG VARCHAR2 (30) Yes
DSPLY_ON_ENRT_FLAG VARCHAR2 (30) Yes
USE_TO_CALC_NET_FLX_CR_FLAG VARCHAR2 (30) Yes
ENTR_VAL_AT_ENRT_FLAG VARCHAR2 (30) Yes
ASN_ON_ENRT_FLAG VARCHAR2 (30) Yes
RL_CRS_ONLY_FLAG VARCHAR2 (30) Yes
ACTY_BASE_RT_ID NUMBER (15) Yes
ENTR_ANN_VAL_FLAG VARCHAR2 (30) Yes
RT_STRT_DT DATE

RT_STRT_DT_CD VARCHAR2 (30)
RT_STRT_DT_RL NUMBER (15)
RT_TYP_CD VARCHAR2 (30)
ELIG_PER_ELCTBL_CHC_ID NUMBER (15)
SPCL_RT_ENRT_RT_ID NUMBER (15)
ENRT_BNFT_ID NUMBER (15)
CVG_AMT_CALC_MTHD_ID NUMBER (15)
ACTL_PREM_ID NUMBER (15)
COMP_LVL_FCTR_ID NUMBER (15)
PTD_COMP_LVL_FCTR_ID NUMBER (15)
CLM_COMP_LVL_FCTR_ID NUMBER (15)
ECR_ATTRIBUTE_CATEGORY VARCHAR2 (30)
ECR_ATTRIBUTE1 VARCHAR2 (150)
ECR_ATTRIBUTE2 VARCHAR2 (150)
ECR_ATTRIBUTE3 VARCHAR2 (150)
ECR_ATTRIBUTE4 VARCHAR2 (150)
ECR_ATTRIBUTE5 VARCHAR2 (150)
ECR_ATTRIBUTE6 VARCHAR2 (150)
ECR_ATTRIBUTE7 VARCHAR2 (150)
ECR_ATTRIBUTE8 VARCHAR2 (150)
ECR_ATTRIBUTE9 VARCHAR2 (150)
ECR_ATTRIBUTE10 VARCHAR2 (150)
ECR_ATTRIBUTE11 VARCHAR2 (150)
ECR_ATTRIBUTE12 VARCHAR2 (150)
ECR_ATTRIBUTE13 VARCHAR2 (150)
ECR_ATTRIBUTE14 VARCHAR2 (150)
ECR_ATTRIBUTE15 VARCHAR2 (150)
ECR_ATTRIBUTE16 VARCHAR2 (150)
ECR_ATTRIBUTE17 VARCHAR2 (150)
ECR_ATTRIBUTE18 VARCHAR2 (150)
ECR_ATTRIBUTE19 VARCHAR2 (150)
ECR_ATTRIBUTE20 VARCHAR2 (150)
ECR_ATTRIBUTE21 VARCHAR2 (150)
ECR_ATTRIBUTE22 VARCHAR2 (150)
ECR_ATTRIBUTE23 VARCHAR2 (150)
ECR_ATTRIBUTE24 VARCHAR2 (150)
ECR_ATTRIBUTE25 VARCHAR2 (150)
ECR_ATTRIBUTE26 VARCHAR2 (150)
ECR_ATTRIBUTE27 VARCHAR2 (150)
ECR_ATTRIBUTE28 VARCHAR2 (150)
ECR_ATTRIBUTE29 VARCHAR2 (150)
ECR_ATTRIBUTE30 VARCHAR2 (150)
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

OBJECT_VERSION_NUMBER NUMBER (9)
DFLT_VAL NUMBER

DECR_BNFT_PRVDR_POOL_ID NUMBER (15)
ANN_VAL NUMBER

ANN_MN_ELCN_VAL NUMBER

ANN_MX_ELCN_VAL NUMBER

VAL NUMBER

PRTT_RT_VAL_ID NUMBER (15)
NNMNTRY_UOM VARCHAR2 (30)
MX_ELCN_VAL NUMBER

MN_ELCN_VAL NUMBER

INCRMT_ELCN_VAL NUMBER

CMCD_ACTY_REF_PERD_CD VARCHAR2 (30)
CMCD_MN_ELCN_VAL NUMBER

CMCD_MX_ELCN_VAL NUMBER

CMCD_VAL NUMBER

CMCD_DFLT_VAL NUMBER

RT_USG_CD VARCHAR2 (30)
ANN_DFLT_VAL NUMBER (15)
BNFT_RT_TYP_CD VARCHAR2 (30)
RT_MLT_CD VARCHAR2 (30)
DSPLY_MN_ELCN_VAL NUMBER (15)
DSPLY_MX_ELCN_VAL NUMBER (15)
ISS_VAL NUMBER

VAL_LAST_UPD_DATE DATE

VAL_LAST_UPD_PERSON_ID NUMBER (15)
BENEFIT_ACTION_ID NUMBER
Yes
PERSON_ACTION_ID NUMBER

Query Text

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
,      BENEFIT_ACTION_ID
,      PERSON_ACTION_ID
FROM BEN.BEN_ENRT_RT_RBV#;

Dependencies

[top of page]

BEN.BEN_ENRT_RT_RBV# references the following:

SchemaBEN
TableBEN_ENRT_RT_RBV
BEN.BEN_ENRT_RT_RBV# is referenced by following:

SchemaAPPS
SynonymBEN_ENRT_RT_RBV
TriggerBEN_ENRT_RT_RBV_WHO