Skip to content

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

VIEW: BEN.BEN_PL_F#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
PL_ID NUMBER (15) Yes
EFFECTIVE_START_DATE DATE
Yes
EFFECTIVE_END_DATE DATE
Yes
NAME VARCHAR2 (240) Yes
DRVBL_DPNT_ELIG_FLAG VARCHAR2 (30) Yes
DRVBL_FCTR_PRTN_ELIG_FLAG VARCHAR2 (30) Yes
DPNT_NO_CTFN_RQD_FLAG VARCHAR2 (30) Yes
MAY_ENRL_PL_N_OIPL_FLAG VARCHAR2 (30) Yes
DPNT_CVD_BY_OTHR_APLS_FLAG VARCHAR2 (30) Yes
DPNT_ADRS_RQD_FLAG VARCHAR2 (30) Yes
DPNT_LEG_ID_RQD_FLAG VARCHAR2 (30) Yes
DPNT_DOB_RQD_FLAG VARCHAR2 (30) Yes
DRVBL_FCTR_APLS_RTS_FLAG VARCHAR2 (30) Yes
ELIG_APLS_FLAG VARCHAR2 (30) Yes
NO_MX_OPTS_NUM_APLS_FLAG VARCHAR2 (30) Yes
ALWS_QDRO_FLAG VARCHAR2 (30) Yes
ALWS_QMCSO_FLAG VARCHAR2 (30) Yes
HGHLY_CMPD_RL_APLS_FLAG VARCHAR2 (30) Yes
ENRT_PL_OPT_FLAG VARCHAR2 (30) Yes
FRFS_APLY_FLAG VARCHAR2 (30) Yes
SVGS_PL_FLAG VARCHAR2 (30) Yes
TRK_INELIG_PER_FLAG VARCHAR2 (30) Yes
USE_ALL_ASNTS_ELIG_FLAG VARCHAR2 (30) Yes
USE_ALL_ASNTS_FOR_RT_FLAG VARCHAR2 (30) Yes
VSTG_APLS_FLAG VARCHAR2 (30) Yes
PRTN_ELIG_OVRID_ALWD_FLAG VARCHAR2 (30) Yes
HC_PL_SUBJ_HCFA_APRVL_FLAG VARCHAR2 (30) Yes
WVBL_FLAG VARCHAR2 (30) Yes
INVK_FLX_CR_PL_FLAG VARCHAR2 (30) Yes
INVK_DCLN_PRTN_PL_FLAG VARCHAR2 (30) Yes
ALWS_REIMBMTS_FLAG VARCHAR2 (30) Yes
ALWS_UNRSTRCTD_ENRT_FLAG VARCHAR2 (30) Yes
BNF_ADDL_INSTN_TXT_ALWD_FLAG VARCHAR2 (30) Yes
BNF_ADRS_RQD_FLAG VARCHAR2 (30) Yes
BNF_CTFN_RQD_FLAG VARCHAR2 (30) Yes
BNF_CNTNGT_BNFS_ALWD_FLAG VARCHAR2 (30) Yes
BNF_LEGV_ID_RQD_FLAG VARCHAR2 (30) Yes
BNF_MAY_DSGT_ORG_FLAG VARCHAR2 (30) Yes
BNF_QDRO_RL_APLS_FLAG VARCHAR2 (30) Yes
BNF_DSGE_MNR_TTEE_RQD_FLAG VARCHAR2 (30) Yes
NO_MN_CVG_AMT_APLS_FLAG VARCHAR2 (30) Yes
NO_MX_CVG_AMT_APLS_FLAG VARCHAR2 (30) Yes
NO_MN_CVG_INCR_APLS_FLAG VARCHAR2 (30) Yes
NO_MX_CVG_INCR_APLS_FLAG VARCHAR2 (30) Yes
NO_MN_OPTS_NUM_APLS_FLAG VARCHAR2 (30) Yes
BNF_DOB_RQD_FLAG VARCHAR2 (30) Yes
PL_CD VARCHAR2 (30) Yes
PL_TYP_ID NUMBER (15) Yes
BUSINESS_GROUP_ID NUMBER (15)
ORDR_NUM NUMBER (15)
CVG_INCR_R_DECR_ONLY_CD VARCHAR2 (30)
MX_CVG_WCFN_AMT NUMBER

MX_CVG_WCFN_MLT_NUM NUMBER (15)
MN_CVG_ALWD_AMT NUMBER

PRORT_PRTL_YR_CVG_RSTRN_RL NUMBER (15)
MN_OPTS_RQD_NUM NUMBER (15)
MX_OPTS_ALWD_NUM NUMBER (15)
MX_WTG_PERD_PRTE_VAL NUMBER (15)
MX_CVG_INCR_ALWD_AMT NUMBER

MX_CVG_MLT_INCR_NUM NUMBER (15)
DFLT_TO_ASN_PNDG_CTFN_RL NUMBER (15)
MX_CVG_INCR_WCF_ALWD_AMT NUMBER

MX_CVG_MLT_INCR_WCF_NUM NUMBER (15)
MX_CVG_ALWD_AMT NUMBER

MN_CVG_RQD_AMT NUMBER

ENRT_RL NUMBER (15)
MX_WTG_DT_TO_USE_RL NUMBER (15)
RQD_PERD_ENRT_NENRT_UOM VARCHAR2 (30)
RQD_PERD_ENRT_NENRT_VAL NUMBER

RQD_PERD_ENRT_NENRT_RL NUMBER (15)
SUBJ_TO_IMPTD_INCM_CD VARCHAR2 (30)
SUBJ_TO_IMPTD_INCM_TYP_CD VARCHAR2 (30)
URL_REF_NAME VARCHAR2 (240)
UNSSPND_ENRT_CD VARCHAR2 (30)
INCPTN_DT DATE

IMPTD_INCM_CALC_CD VARCHAR2 (30)
BNF_INCRMT_AMT NUMBER

BNF_MN_DSGNTBL_AMT NUMBER

BNF_MN_DSGNTBL_PCT_VAL NUMBER (15)
BNF_PCT_INCRMT_VAL NUMBER (15)
IVR_IDENT VARCHAR2 (90)
RT_END_DT_CD VARCHAR2 (30)
RT_END_DT_RL NUMBER (15)
RT_STRT_DT_CD VARCHAR2 (30)
RT_STRT_DT_RL NUMBER (15)
POSTELCN_EDIT_RL NUMBER (15)
PER_CVRD_CD VARCHAR2 (30)
BNFT_OR_OPTION_RSTRCTN_CD VARCHAR2 (30)
PLN_MN_CVG_ALWD_AMT NUMBER (15)
PCP_CD VARCHAR2 (30)
AUTO_ENRT_MTHD_RL NUMBER (15)
MX_WTG_PERD_RL NUMBER (15)
MN_CVG_RL NUMBER (15)
MX_CVG_RL NUMBER (15)
MX_WTG_PERD_PRTE_UOM VARCHAR2 (30)
MX_WTG_DT_TO_USE_CD VARCHAR2 (30)
NIP_PL_UOM VARCHAR2 (30)
BNF_DFLT_BNF_CD VARCHAR2 (30)
BNF_PCT_AMT_ALWD_CD VARCHAR2 (30)
CMPR_CLMS_TO_CVG_OR_BAL_CD VARCHAR2 (30)
COBRA_PYMT_DUE_DY_NUM NUMBER (15)
DPNT_CVG_END_DT_CD VARCHAR2 (30)
DPNT_CVG_STRT_DT_CD VARCHAR2 (30)
NIP_DFLT_ENRT_DET_RL NUMBER (15)
DPNT_DSGN_CD VARCHAR2 (30)
NIP_DFLT_ENRT_CD VARCHAR2 (30)
BNF_DSGN_CD VARCHAR2 (30)
PRMRY_FNDG_MTHD_CD VARCHAR2 (30)
DFLT_TO_ASN_PNDG_CTFN_CD VARCHAR2 (30)
ENRT_MTHD_CD VARCHAR2 (30)
HC_SVC_TYP_CD VARCHAR2 (30)
DPNT_CVG_END_DT_RL NUMBER (15)
NIP_ACTY_REF_PERD_CD VARCHAR2 (30)
ENRT_CD VARCHAR2 (30)
PRORT_PRTL_YR_CVG_RSTRN_CD VARCHAR2 (30)
PL_STAT_CD VARCHAR2 (30)
ENRT_CVG_STRT_DT_CD VARCHAR2 (30)
ENRT_CVG_END_DT_CD VARCHAR2 (30)
NIP_ENRT_INFO_RT_FREQ_CD VARCHAR2 (30)
DPNT_CVG_STRT_DT_RL NUMBER (15)
ENRT_CVG_END_DT_RL NUMBER (15)
ENRT_CVG_STRT_DT_RL NUMBER (15)
ACTL_PREM_ID NUMBER (15)
BNFT_PRVDR_POOL_ID NUMBER (15)
CR_DSTR_BNFT_PRVDR_POOL_ID NUMBER (15)
PLN_ATTRIBUTE_CATEGORY VARCHAR2 (30)
PLN_ATTRIBUTE1 VARCHAR2 (150)
PLN_ATTRIBUTE2 VARCHAR2 (150)
PLN_ATTRIBUTE3 VARCHAR2 (150)
PLN_ATTRIBUTE4 VARCHAR2 (150)
PLN_ATTRIBUTE5 VARCHAR2 (150)
PLN_ATTRIBUTE6 VARCHAR2 (150)
PLN_ATTRIBUTE7 VARCHAR2 (150)
PLN_ATTRIBUTE8 VARCHAR2 (150)
PLN_ATTRIBUTE9 VARCHAR2 (150)
PLN_ATTRIBUTE10 VARCHAR2 (150)
PLN_ATTRIBUTE11 VARCHAR2 (150)
PLN_ATTRIBUTE12 VARCHAR2 (150)
PLN_ATTRIBUTE13 VARCHAR2 (150)
PLN_ATTRIBUTE14 VARCHAR2 (150)
PLN_ATTRIBUTE15 VARCHAR2 (150)
PLN_ATTRIBUTE16 VARCHAR2 (150)
PLN_ATTRIBUTE17 VARCHAR2 (150)
PLN_ATTRIBUTE18 VARCHAR2 (150)
PLN_ATTRIBUTE19 VARCHAR2 (150)
PLN_ATTRIBUTE20 VARCHAR2 (150)
PLN_ATTRIBUTE21 VARCHAR2 (150)
PLN_ATTRIBUTE22 VARCHAR2 (150)
PLN_ATTRIBUTE23 VARCHAR2 (150)
PLN_ATTRIBUTE24 VARCHAR2 (150)
PLN_ATTRIBUTE25 VARCHAR2 (150)
PLN_ATTRIBUTE26 VARCHAR2 (150)
PLN_ATTRIBUTE27 VARCHAR2 (150)
PLN_ATTRIBUTE28 VARCHAR2 (150)
PLN_ATTRIBUTE29 VARCHAR2 (150)
PLN_ATTRIBUTE30 VARCHAR2 (150)
OBJECT_VERSION_NUMBER NUMBER (9)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

VRFY_FMLY_MMBR_CD VARCHAR2 (30)
VRFY_FMLY_MMBR_RL NUMBER (15)
ALWS_TMPRY_ID_CRD_FLAG VARCHAR2 (30) Yes
NIP_DFLT_FLAG VARCHAR2 (30) Yes
FRFS_DISTR_MTHD_CD VARCHAR2 (30)
FRFS_DISTR_MTHD_RL NUMBER (15)
FRFS_CNTR_DET_CD VARCHAR2 (30)
FRFS_DISTR_DET_CD VARCHAR2 (30)
COST_ALLOC_KEYFLEX_1_ID NUMBER (15)
COST_ALLOC_KEYFLEX_2_ID NUMBER (15)
POST_TO_GL_FLAG VARCHAR2 (30) Yes
FRFS_VAL_DET_CD VARCHAR2 (30)
FRFS_MX_CRYFWD_VAL NUMBER

FRFS_PORTION_DET_CD VARCHAR2 (30)
BNDRY_PERD_CD VARCHAR2 (30)
SHORT_CODE VARCHAR2 (30)
SHORT_NAME VARCHAR2 (30)
FUNCTION_CODE VARCHAR2 (30)
MAPPING_TABLE_NAME VARCHAR2 (60)
MAPPING_TABLE_PK_ID NUMBER

PL_YR_NOT_APPLCBL_FLAG VARCHAR2 (30) Yes
LEGISLATION_CODE VARCHAR2 (30)
LEGISLATION_SUBGROUP VARCHAR2 (30)
GROUP_PL_ID NUMBER (15)
USE_CSD_RSD_PRCCNG_CD VARCHAR2 (30)
SUSP_IF_CTFN_NOT_PRVD_FLAG VARCHAR2 (30) Yes
CTFN_DETERMINE_CD VARCHAR2 (30)
SUSP_IF_DPNT_SSN_NT_PRV_CD VARCHAR2 (30)
SUSP_IF_DPNT_DOB_NT_PRV_CD VARCHAR2 (30)
SUSP_IF_DPNT_ADR_NT_PRV_CD VARCHAR2 (30)
SUSP_IF_CTFN_NOT_DPNT_FLAG VARCHAR2 (30) Yes
SUSP_IF_BNF_SSN_NT_PRV_CD VARCHAR2 (30)
SUSP_IF_BNF_DOB_NT_PRV_CD VARCHAR2 (30)
SUSP_IF_BNF_ADR_NT_PRV_CD VARCHAR2 (30)
SUSP_IF_CTFN_NOT_BNF_FLAG VARCHAR2 (30) Yes
DPNT_CTFN_DETERMINE_CD VARCHAR2 (30)
BNF_CTFN_DETERMINE_CD VARCHAR2 (30)
ALL_INELIG VARCHAR2 (1)
ZD_EDITION_NAME VARCHAR2 (30) Yes
BNF_EXL_PARTICIPANT_FLAG VARCHAR2 (30)
Query Text

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


SELECT PL_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      NAME
,      DRVBL_DPNT_ELIG_FLAG
,      DRVBL_FCTR_PRTN_ELIG_FLAG
,      DPNT_NO_CTFN_RQD_FLAG
,      MAY_ENRL_PL_N_OIPL_FLAG
,      DPNT_CVD_BY_OTHR_APLS_FLAG
,      DPNT_ADRS_RQD_FLAG
,      DPNT_LEG_ID_RQD_FLAG
,      DPNT_DOB_RQD_FLAG
,      DRVBL_FCTR_APLS_RTS_FLAG
,      ELIG_APLS_FLAG
,      NO_MX_OPTS_NUM_APLS_FLAG
,      ALWS_QDRO_FLAG
,      ALWS_QMCSO_FLAG
,      HGHLY_CMPD_RL_APLS_FLAG
,      ENRT_PL_OPT_FLAG
,      FRFS_APLY_FLAG
,      SVGS_PL_FLAG
,      TRK_INELIG_PER_FLAG
,      USE_ALL_ASNTS_ELIG_FLAG
,      USE_ALL_ASNTS_FOR_RT_FLAG
,      VSTG_APLS_FLAG
,      PRTN_ELIG_OVRID_ALWD_FLAG
,      HC_PL_SUBJ_HCFA_APRVL_FLAG
,      WVBL_FLAG
,      INVK_FLX_CR_PL_FLAG
,      INVK_DCLN_PRTN_PL_FLAG
,      ALWS_REIMBMTS_FLAG
,      ALWS_UNRSTRCTD_ENRT_FLAG
,      BNF_ADDL_INSTN_TXT_ALWD_FLAG
,      BNF_ADRS_RQD_FLAG
,      BNF_CTFN_RQD_FLAG
,      BNF_CNTNGT_BNFS_ALWD_FLAG
,      BNF_LEGV_ID_RQD_FLAG
,      BNF_MAY_DSGT_ORG_FLAG
,      BNF_QDRO_RL_APLS_FLAG
,      BNF_DSGE_MNR_TTEE_RQD_FLAG
,      NO_MN_CVG_AMT_APLS_FLAG
,      NO_MX_CVG_AMT_APLS_FLAG
,      NO_MN_CVG_INCR_APLS_FLAG
,      NO_MX_CVG_INCR_APLS_FLAG
,      NO_MN_OPTS_NUM_APLS_FLAG
,      BNF_DOB_RQD_FLAG
,      PL_CD
,      PL_TYP_ID
,      BUSINESS_GROUP_ID
,      ORDR_NUM
,      CVG_INCR_R_DECR_ONLY_CD
,      MX_CVG_WCFN_AMT
,      MX_CVG_WCFN_MLT_NUM
,      MN_CVG_ALWD_AMT
,      PRORT_PRTL_YR_CVG_RSTRN_RL
,      MN_OPTS_RQD_NUM
,      MX_OPTS_ALWD_NUM
,      MX_WTG_PERD_PRTE_VAL
,      MX_CVG_INCR_ALWD_AMT
,      MX_CVG_MLT_INCR_NUM
,      DFLT_TO_ASN_PNDG_CTFN_RL
,      MX_CVG_INCR_WCF_ALWD_AMT
,      MX_CVG_MLT_INCR_WCF_NUM
,      MX_CVG_ALWD_AMT
,      MN_CVG_RQD_AMT
,      ENRT_RL
,      MX_WTG_DT_TO_USE_RL
,      RQD_PERD_ENRT_NENRT_UOM
,      RQD_PERD_ENRT_NENRT_VAL
,      RQD_PERD_ENRT_NENRT_RL
,      SUBJ_TO_IMPTD_INCM_CD
,      SUBJ_TO_IMPTD_INCM_TYP_CD
,      URL_REF_NAME
,      UNSSPND_ENRT_CD
,      INCPTN_DT
,      IMPTD_INCM_CALC_CD
,      BNF_INCRMT_AMT
,      BNF_MN_DSGNTBL_AMT
,      BNF_MN_DSGNTBL_PCT_VAL
,      BNF_PCT_INCRMT_VAL
,      IVR_IDENT
,      RT_END_DT_CD
,      RT_END_DT_RL
,      RT_STRT_DT_CD
,      RT_STRT_DT_RL
,      POSTELCN_EDIT_RL
,      PER_CVRD_CD
,      BNFT_OR_OPTION_RSTRCTN_CD
,      PLN_MN_CVG_ALWD_AMT
,      PCP_CD
,      AUTO_ENRT_MTHD_RL
,      MX_WTG_PERD_RL
,      MN_CVG_RL
,      MX_CVG_RL
,      MX_WTG_PERD_PRTE_UOM
,      MX_WTG_DT_TO_USE_CD
,      NIP_PL_UOM
,      BNF_DFLT_BNF_CD
,      BNF_PCT_AMT_ALWD_CD
,      CMPR_CLMS_TO_CVG_OR_BAL_CD
,      COBRA_PYMT_DUE_DY_NUM
,      DPNT_CVG_END_DT_CD
,      DPNT_CVG_STRT_DT_CD
,      NIP_DFLT_ENRT_DET_RL
,      DPNT_DSGN_CD
,      NIP_DFLT_ENRT_CD
,      BNF_DSGN_CD
,      PRMRY_FNDG_MTHD_CD
,      DFLT_TO_ASN_PNDG_CTFN_CD
,      ENRT_MTHD_CD
,      HC_SVC_TYP_CD
,      DPNT_CVG_END_DT_RL
,      NIP_ACTY_REF_PERD_CD
,      ENRT_CD
,      PRORT_PRTL_YR_CVG_RSTRN_CD
,      PL_STAT_CD
,      ENRT_CVG_STRT_DT_CD
,      ENRT_CVG_END_DT_CD
,      NIP_ENRT_INFO_RT_FREQ_CD
,      DPNT_CVG_STRT_DT_RL
,      ENRT_CVG_END_DT_RL
,      ENRT_CVG_STRT_DT_RL
,      ACTL_PREM_ID
,      BNFT_PRVDR_POOL_ID
,      CR_DSTR_BNFT_PRVDR_POOL_ID
,      PLN_ATTRIBUTE_CATEGORY
,      PLN_ATTRIBUTE1
,      PLN_ATTRIBUTE2
,      PLN_ATTRIBUTE3
,      PLN_ATTRIBUTE4
,      PLN_ATTRIBUTE5
,      PLN_ATTRIBUTE6
,      PLN_ATTRIBUTE7
,      PLN_ATTRIBUTE8
,      PLN_ATTRIBUTE9
,      PLN_ATTRIBUTE10
,      PLN_ATTRIBUTE11
,      PLN_ATTRIBUTE12
,      PLN_ATTRIBUTE13
,      PLN_ATTRIBUTE14
,      PLN_ATTRIBUTE15
,      PLN_ATTRIBUTE16
,      PLN_ATTRIBUTE17
,      PLN_ATTRIBUTE18
,      PLN_ATTRIBUTE19
,      PLN_ATTRIBUTE20
,      PLN_ATTRIBUTE21
,      PLN_ATTRIBUTE22
,      PLN_ATTRIBUTE23
,      PLN_ATTRIBUTE24
,      PLN_ATTRIBUTE25
,      PLN_ATTRIBUTE26
,      PLN_ATTRIBUTE27
,      PLN_ATTRIBUTE28
,      PLN_ATTRIBUTE29
,      PLN_ATTRIBUTE30
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      VRFY_FMLY_MMBR_CD
,      VRFY_FMLY_MMBR_RL
,      ALWS_TMPRY_ID_CRD_FLAG
,      NIP_DFLT_FLAG
,      FRFS_DISTR_MTHD_CD
,      FRFS_DISTR_MTHD_RL
,      FRFS_CNTR_DET_CD
,      FRFS_DISTR_DET_CD
,      COST_ALLOC_KEYFLEX_1_ID
,      COST_ALLOC_KEYFLEX_2_ID
,      POST_TO_GL_FLAG
,      FRFS_VAL_DET_CD
,      FRFS_MX_CRYFWD_VAL
,      FRFS_PORTION_DET_CD
,      BNDRY_PERD_CD
,      SHORT_CODE
,      SHORT_NAME
,      FUNCTION_CODE
,      MAPPING_TABLE_NAME
,      MAPPING_TABLE_PK_ID
,      PL_YR_NOT_APPLCBL_FLAG
,      LEGISLATION_CODE
,      LEGISLATION_SUBGROUP
,      GROUP_PL_ID
,      USE_CSD_RSD_PRCCNG_CD
,      SUSP_IF_CTFN_NOT_PRVD_FLAG
,      CTFN_DETERMINE_CD
,      SUSP_IF_DPNT_SSN_NT_PRV_CD
,      SUSP_IF_DPNT_DOB_NT_PRV_CD
,      SUSP_IF_DPNT_ADR_NT_PRV_CD
,      SUSP_IF_CTFN_NOT_DPNT_FLAG
,      SUSP_IF_BNF_SSN_NT_PRV_CD
,      SUSP_IF_BNF_DOB_NT_PRV_CD
,      SUSP_IF_BNF_ADR_NT_PRV_CD
,      SUSP_IF_CTFN_NOT_BNF_FLAG
,      DPNT_CTFN_DETERMINE_CD
,      BNF_CTFN_DETERMINE_CD
,      ALL_INELIG
,      ZD_EDITION_NAME
,      BNF_EXL_PARTICIPANT_FLAG
FROM BEN.BEN_PL_F#;

Dependencies

[top of page]

BEN.BEN_PL_F# references the following:

SchemaBEN
TableBEN_PL_F
BEN.BEN_PL_F# is referenced by following:

SchemaAPPS
SynonymBEN_PL_F
TriggerBEN_PL_F+
TriggerBEN_PL_F_WHO