eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: BEN.BEN_LE_CLSN_N_RSTR#

Object Details

Object Name:	BEN_LE_CLSN_N_RSTR#
Object Type:	VIEW
Owner:	BEN
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
BKUP_TBL_ID	NUMBER	(15)	Yes
BKUP_TBL_TYP_CD	VARCHAR2	(30)	Yes
PER_IN_LER_ID	NUMBER	(15)	Yes
EFFECTIVE_START_DATE	DATE
EFFECTIVE_END_DATE	DATE
ENRT_CVG_STRT_DT	DATE
ENRT_CVG_THRU_DT	DATE
BNFT_AMT	NUMBER
BNFT_NNMNTRY_UOM	VARCHAR2	(30)
BNFT_ORDR_NUM	NUMBER	(30)
BNFT_TYP_CD	VARCHAR2	(30)
COMP_LVL_CD	VARCHAR2	(30)
ENRT_MTHD_CD	VARCHAR2	(30)
ENRT_OVRID_RSN_CD	VARCHAR2	(30)
ENRT_OVRID_THRU_DT	DATE
ENRT_OVRIDN_FLAG	VARCHAR2	(30)
ERLST_DEENRT_DT	DATE
NO_LNGR_ELIG_FLAG	VARCHAR2	(30)
ORGNL_ENRT_DT	DATE
PRTT_ENRT_RSLT_STAT_CD	VARCHAR2	(30)
PRTT_IS_CVRD_FLAG	VARCHAR2	(30)
SSPNDD_FLAG	VARCHAR2	(30)
UOM	VARCHAR2	(30)
ADDL_INSTRN_TXT	VARCHAR2	(2000)
AMT_DSGD_VAL	NUMBER
AMT_DSGD_UOM	VARCHAR2	(30)
DSGN_STRT_DT	DATE
DSGN_THRU_DT	DATE
PCT_DSGD_NUM	NUMBER
PRMRY_CNTNGNT_CD	VARCHAR2	(30)
CVG_PNDG_FLAG	VARCHAR2	(30)
CVRD_FLAG	VARCHAR2	(30)
ELIG_FLAG	VARCHAR2	(30)
OVRDN_FLAG	VARCHAR2	(30)
CVG_STRT_DT	DATE
CVG_THRU_DT	DATE
ELIG_STRT_DT	DATE
ELIG_THRU_DT	DATE
OVRDN_THRU_DT	DATE
RT_STRT_DT	DATE
RT_END_DT	DATE
DSPLY_ON_ENRT_FLAG	VARCHAR2	(30)
RT_OVRIDN_FLAG	VARCHAR2	(30)
ACTY_REF_PERD_CD	VARCHAR2	(30)
ACTY_TYP_CD	VARCHAR2	(30)
ANN_RT_VAL	NUMBER
BNFT_RT_TYP_CD	VARCHAR2	(30)
CMCD_REF_PERD_CD	VARCHAR2	(30)
CMCD_RT_VAL	NUMBER
ELCNS_MADE_DT	DATE
MLT_CD	VARCHAR2	(30)
PRTT_RT_VAL_STAT_CD	VARCHAR2	(30)
RT_OVRIDN_THRU_DT	DATE
RT_VAL	NUMBER
TX_TYP_CD	VARCHAR2	(30)
INELG_RSN_CD	VARCHAR2	(30)
RT_COMP_REF_AMT	NUMBER
RT_CMBN_AGE_N_LOS_VAL	NUMBER
RT_COMP_REF_UOM	VARCHAR2	(30)
RT_AGE_VAL	NUMBER
RT_LOS_VAL	NUMBER
RT_HRS_WKD_VAL	NUMBER
RT_HRS_WKD_BNDRY_PERD_CD	VARCHAR2	(30)
RT_AGE_UOM	VARCHAR2	(30)
RT_LOS_UOM	VARCHAR2	(30)
RT_PCT_FL_TM_VAL	NUMBER
RT_FRZ_LOS_FLAG	VARCHAR2	(30)
RT_FRZ_AGE_FLAG	VARCHAR2	(30)
RT_FRZ_CMP_LVL_FLAG	VARCHAR2	(30)
RT_FRZ_PCT_FL_TM_FLAG	VARCHAR2	(30)
RT_FRZ_HRS_WKD_FLAG	VARCHAR2	(30)
RT_FRZ_COMB_AGE_AND_LOS_FLAG	VARCHAR2	(30)
AGE_UOM	VARCHAR2	(30)
AGE_VAL	NUMBER
CMBN_AGE_N_LOS_VAL	NUMBER
COMP_REF_AMT	NUMBER
COMP_REF_UOM	VARCHAR2	(30)
DPNT_OTHER_PL_CVRD_RL_FLAG	VARCHAR2	(30)
DSTR_RSTCN_FLAG	VARCHAR2	(30)
FRZ_AGE_FLAG	VARCHAR2	(30)
FRZ_CMP_LVL_FLAG	VARCHAR2	(30)
FRZ_COMB_AGE_AND_LOS_FLAG	VARCHAR2	(30)
FRZ_HRS_WKD_FLAG	VARCHAR2	(30)
FRZ_LOS_FLAG	VARCHAR2	(30)
FRZ_PCT_FL_TM_FLAG	VARCHAR2	(30)
HRS_WKD_BNDRY_PERD_CD	VARCHAR2	(30)
HRS_WKD_VAL	NUMBER
LOS_UOM	VARCHAR2	(30)
LOS_VAL	NUMBER
NO_MX_PRTN_OVRID_THRU_FLAG	VARCHAR2	(30)
OVRID_SVC_DT	DATE
PCT_FL_TM_VAL	NUMBER
PL_HGHLY_COMPD_FLAG	VARCHAR2	(30)
PL_KEY_EE_FLAG	VARCHAR2	(30)
PL_WVD_FLAG	VARCHAR2	(30)
PRTN_END_DT	DATE
PRTN_OVRIDN_FLAG	VARCHAR2	(30)
PRTN_OVRIDN_RSN_CD	VARCHAR2	(30)
PRTN_OVRIDN_THRU_DT	DATE
PRTN_STRT_DT	DATE
WAIT_PERD_CMPLTN_DT	DATE
WV_CTFN_TYP_CD	VARCHAR2	(30)
WV_PRTN_RSN_CD	VARCHAR2	(30)
PERSON_ID	NUMBER	(15)
PL_ID	NUMBER	(15)
LER_ID	NUMBER	(15)
PTIP_ID	NUMBER	(15)
PLIP_ID	NUMBER	(15)
OTHR_PL_ENRLD_ID	NUMBER	(15)
PGM_ID	NUMBER	(15)
ELIG_PER_ID	NUMBER	(15)
OPT_ID	NUMBER	(15)
ORGANIZATION_ID	NUMBER	(15)
PRTT_ENRT_RSLT_ID	NUMBER	(15)
PERSON_TTEE_ID	NUMBER	(15)
ELIG_PER_ELCTBL_CHC_ID	NUMBER	(15)
PERSON_DPNT_ID	NUMBER	(15)
ELEMENT_ENTRY_VALUE_ID	NUMBER	(15)
PER_IN_LER_ENDED_ID	NUMBER	(15)
CVG_AMT_CALC_MTHD_ID	NUMBER	(15)
TTEE_PERSON_ID	NUMBER	(15)
ENRT_RT_ID	NUMBER	(15)
ACTY_BASE_RT_ID	NUMBER	(15)
OIPL_ID	NUMBER	(15)
COMP_LVL_FCTR_ID	NUMBER	(15)
PL_TYP_ID	NUMBER	(15)
ACTL_PREM_ID	NUMBER	(15)
PRTT_ENRT_RSLT_SSPNDD_ID	NUMBER	(15)
ASSIGNMENT_ID	NUMBER	(15)
ENRT_BNFT_ID	NUMBER	(15)
BUSINESS_GROUP_ID	NUMBER	(15)
DPNT_PERSON_ID	NUMBER	(15)
ONCE_R_CNTUG_CD	VARCHAR2	(30)
DPNT_OTHR_PL_CVRD_RL_FLAG	VARCHAR2	(30)
MUST_ENRL_ANTHR_PL_ID	NUMBER	(15)
PL_ORDR_NUM	NUMBER	(15)
PLIP_ORDR_NUM	NUMBER	(15)
PTIP_ORDR_NUM	NUMBER	(15)
OIPL_ORDR_NUM	NUMBER	(15)
BNF_PERSON_ID	NUMBER	(15)
RPLCS_SSPNDD_RSLT_ID	NUMBER	(15)
VAL	NUMBER
STD_PREM_VAL	NUMBER	(15)
STD_PREM_UOM	VARCHAR2	(30)
LCR_ATTRIBUTE_CATEGORY	VARCHAR2	(30)
LCR_ATTRIBUTE1	VARCHAR2	(150)
LCR_ATTRIBUTE2	VARCHAR2	(150)
LCR_ATTRIBUTE3	VARCHAR2	(150)
LCR_ATTRIBUTE4	VARCHAR2	(150)
LCR_ATTRIBUTE5	VARCHAR2	(150)
LCR_ATTRIBUTE6	VARCHAR2	(150)
LCR_ATTRIBUTE7	VARCHAR2	(150)
LCR_ATTRIBUTE8	VARCHAR2	(150)
LCR_ATTRIBUTE9	VARCHAR2	(150)
LCR_ATTRIBUTE10	VARCHAR2	(150)
LCR_ATTRIBUTE11	VARCHAR2	(150)
LCR_ATTRIBUTE12	VARCHAR2	(150)
LCR_ATTRIBUTE13	VARCHAR2	(150)
LCR_ATTRIBUTE14	VARCHAR2	(150)
LCR_ATTRIBUTE15	VARCHAR2	(150)
LCR_ATTRIBUTE16	VARCHAR2	(150)
LCR_ATTRIBUTE17	VARCHAR2	(150)
LCR_ATTRIBUTE18	VARCHAR2	(150)
LCR_ATTRIBUTE19	VARCHAR2	(150)
LCR_ATTRIBUTE20	VARCHAR2	(150)
LCR_ATTRIBUTE21	VARCHAR2	(150)
LCR_ATTRIBUTE22	VARCHAR2	(150)
LCR_ATTRIBUTE23	VARCHAR2	(150)
LCR_ATTRIBUTE24	VARCHAR2	(150)
LCR_ATTRIBUTE25	VARCHAR2	(150)
LCR_ATTRIBUTE26	VARCHAR2	(150)
LCR_ATTRIBUTE27	VARCHAR2	(150)
LCR_ATTRIBUTE28	VARCHAR2	(150)
LCR_ATTRIBUTE29	VARCHAR2	(150)
LCR_ATTRIBUTE30	VARCHAR2	(150)
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_LOGIN	NUMBER	(15)
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE
REQUEST_ID	NUMBER	(15)
PROGRAM_APPLICATION_ID	NUMBER	(15)
PROGRAM_ID	NUMBER	(15)
PROGRAM_UPDATE_DATE	DATE
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BKUP_TBL_ID
,      BKUP_TBL_TYP_CD
,      PER_IN_LER_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      ENRT_CVG_STRT_DT
,      ENRT_CVG_THRU_DT
,      BNFT_AMT
,      BNFT_NNMNTRY_UOM
,      BNFT_ORDR_NUM
,      BNFT_TYP_CD
,      COMP_LVL_CD
,      ENRT_MTHD_CD
,      ENRT_OVRID_RSN_CD
,      ENRT_OVRID_THRU_DT
,      ENRT_OVRIDN_FLAG
,      ERLST_DEENRT_DT
,      NO_LNGR_ELIG_FLAG
,      ORGNL_ENRT_DT
,      PRTT_ENRT_RSLT_STAT_CD
,      PRTT_IS_CVRD_FLAG
,      SSPNDD_FLAG
,      UOM
,      ADDL_INSTRN_TXT
,      AMT_DSGD_VAL
,      AMT_DSGD_UOM
,      DSGN_STRT_DT
,      DSGN_THRU_DT
,      PCT_DSGD_NUM
,      PRMRY_CNTNGNT_CD
,      CVG_PNDG_FLAG
,      CVRD_FLAG
,      ELIG_FLAG
,      OVRDN_FLAG
,      CVG_STRT_DT
,      CVG_THRU_DT
,      ELIG_STRT_DT
,      ELIG_THRU_DT
,      OVRDN_THRU_DT
,      RT_STRT_DT
,      RT_END_DT
,      DSPLY_ON_ENRT_FLAG
,      RT_OVRIDN_FLAG
,      ACTY_REF_PERD_CD
,      ACTY_TYP_CD
,      ANN_RT_VAL
,      BNFT_RT_TYP_CD
,      CMCD_REF_PERD_CD
,      CMCD_RT_VAL
,      ELCNS_MADE_DT
,      MLT_CD
,      PRTT_RT_VAL_STAT_CD
,      RT_OVRIDN_THRU_DT
,      RT_VAL
,      TX_TYP_CD
,      INELG_RSN_CD
,      RT_COMP_REF_AMT
,      RT_CMBN_AGE_N_LOS_VAL
,      RT_COMP_REF_UOM
,      RT_AGE_VAL
,      RT_LOS_VAL
,      RT_HRS_WKD_VAL
,      RT_HRS_WKD_BNDRY_PERD_CD
,      RT_AGE_UOM
,      RT_LOS_UOM
,      RT_PCT_FL_TM_VAL
,      RT_FRZ_LOS_FLAG
,      RT_FRZ_AGE_FLAG
,      RT_FRZ_CMP_LVL_FLAG
,      RT_FRZ_PCT_FL_TM_FLAG
,      RT_FRZ_HRS_WKD_FLAG
,      RT_FRZ_COMB_AGE_AND_LOS_FLAG
,      AGE_UOM
,      AGE_VAL
,      CMBN_AGE_N_LOS_VAL
,      COMP_REF_AMT
,      COMP_REF_UOM
,      DPNT_OTHER_PL_CVRD_RL_FLAG
,      DSTR_RSTCN_FLAG
,      FRZ_AGE_FLAG
,      FRZ_CMP_LVL_FLAG
,      FRZ_COMB_AGE_AND_LOS_FLAG
,      FRZ_HRS_WKD_FLAG
,      FRZ_LOS_FLAG
,      FRZ_PCT_FL_TM_FLAG
,      HRS_WKD_BNDRY_PERD_CD
,      HRS_WKD_VAL
,      LOS_UOM
,      LOS_VAL
,      NO_MX_PRTN_OVRID_THRU_FLAG
,      OVRID_SVC_DT
,      PCT_FL_TM_VAL
,      PL_HGHLY_COMPD_FLAG
,      PL_KEY_EE_FLAG
,      PL_WVD_FLAG
,      PRTN_END_DT
,      PRTN_OVRIDN_FLAG
,      PRTN_OVRIDN_RSN_CD
,      PRTN_OVRIDN_THRU_DT
,      PRTN_STRT_DT
,      WAIT_PERD_CMPLTN_DT
,      WV_CTFN_TYP_CD
,      WV_PRTN_RSN_CD
,      PERSON_ID
,      PL_ID
,      LER_ID
,      PTIP_ID
,      PLIP_ID
,      OTHR_PL_ENRLD_ID
,      PGM_ID
,      ELIG_PER_ID
,      OPT_ID
,      ORGANIZATION_ID
,      PRTT_ENRT_RSLT_ID
,      PERSON_TTEE_ID
,      ELIG_PER_ELCTBL_CHC_ID
,      PERSON_DPNT_ID
,      ELEMENT_ENTRY_VALUE_ID
,      PER_IN_LER_ENDED_ID
,      CVG_AMT_CALC_MTHD_ID
,      TTEE_PERSON_ID
,      ENRT_RT_ID
,      ACTY_BASE_RT_ID
,      OIPL_ID
,      COMP_LVL_FCTR_ID
,      PL_TYP_ID
,      ACTL_PREM_ID
,      PRTT_ENRT_RSLT_SSPNDD_ID
,      ASSIGNMENT_ID
,      ENRT_BNFT_ID
,      BUSINESS_GROUP_ID
,      DPNT_PERSON_ID
,      ONCE_R_CNTUG_CD
,      DPNT_OTHR_PL_CVRD_RL_FLAG
,      MUST_ENRL_ANTHR_PL_ID
,      PL_ORDR_NUM
,      PLIP_ORDR_NUM
,      PTIP_ORDR_NUM
,      OIPL_ORDR_NUM
,      BNF_PERSON_ID
,      RPLCS_SSPNDD_RSLT_ID
,      VAL
,      STD_PREM_VAL
,      STD_PREM_UOM
,      LCR_ATTRIBUTE_CATEGORY
,      LCR_ATTRIBUTE1
,      LCR_ATTRIBUTE2
,      LCR_ATTRIBUTE3
,      LCR_ATTRIBUTE4
,      LCR_ATTRIBUTE5
,      LCR_ATTRIBUTE6
,      LCR_ATTRIBUTE7
,      LCR_ATTRIBUTE8
,      LCR_ATTRIBUTE9
,      LCR_ATTRIBUTE10
,      LCR_ATTRIBUTE11
,      LCR_ATTRIBUTE12
,      LCR_ATTRIBUTE13
,      LCR_ATTRIBUTE14
,      LCR_ATTRIBUTE15
,      LCR_ATTRIBUTE16
,      LCR_ATTRIBUTE17
,      LCR_ATTRIBUTE18
,      LCR_ATTRIBUTE19
,      LCR_ATTRIBUTE20
,      LCR_ATTRIBUTE21
,      LCR_ATTRIBUTE22
,      LCR_ATTRIBUTE23
,      LCR_ATTRIBUTE24
,      LCR_ATTRIBUTE25
,      LCR_ATTRIBUTE26
,      LCR_ATTRIBUTE27
,      LCR_ATTRIBUTE28
,      LCR_ATTRIBUTE29
,      LCR_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
FROM BEN.BEN_LE_CLSN_N_RSTR#;

Dependencies

[top of page]

BEN.BEN_LE_CLSN_N_RSTR# references the following:

BEN: BEN_LE_CLSN_N_RSTR

BEN.BEN_LE_CLSN_N_RSTR# is referenced by following:

APPS: BEN_LE_CLSN_N_RSTR; BEN_LE_CLSN_N_RSTR_WHO