Analytics Catalog/Data dictionary/BEN_PL_F
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion · Data dictionary

BEN_PL_F

BenefitsUsed in 0 subject areas207 reporting columnsBICC incremental-ready

Benefits (BEN).

Likely primary key: PL_ID, EFFECTIVE_START_DATE (inferred from Oracle naming conventions, verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE
Joins (inferred from key columns): CARRIER_ID → WSH_CARRIERS

Columns

ColumnKeyIn reportsDescription (inferred)
ACTL_PREM_ID●Identifier for the actl prem.
ALWS_QDRO_FLAG●Indicator (Y/N) for the alws qdro.
ALWS_QMCSO_FLAG●Indicator (Y/N) for the alws qmcso.
ALWS_REIMBMTS_FLAG●Indicator (Y/N) for the alws reimbmts.
ALWS_TMPRY_ID_CRD_FLAG●Indicator (Y/N) for the alws tmpry id crd.
ALWS_UNRSTRCTD_ENRT_FLAG●Indicator (Y/N) for the alws unrstrctd enrt.
ASNT_RQD_FOR_ENRT_FLAG●Indicator (Y/N) for the asnt rqd for enrt.
AUTO_ENRT_MTHD_RL●Auto enrt mthd rl.
BNDRY_PERD_CD●Bndry perd code.
BNFT_OR_OPTION_RSTRCTN_CD●Bnft or option rstrctn code.
BNFT_PRVDR_POOL_ID●Identifier for the bnft prvdr pool.
BNFT_R_OPT_RSTRN_CD●Bnft r opt rstrn code.
BNF_ADDL_INSTN_ALWD_FLAG●Indicator (Y/N) for the bnf addl instn alwd.
BNF_ADRS_RQD_FLAG●Indicator (Y/N) for the bnf adrs rqd.
BNF_CNTNGT_BNFS_ALWD_FLAG●Indicator (Y/N) for the bnf cntngt bnfs alwd.
BNF_CTFN_DETERMINE_CD●Bnf ctfn determine code.
BNF_CTFN_RQD_FLAG●Indicator (Y/N) for the bnf ctfn rqd.
BNF_DFLT_BNF_CD●Bnf dflt bnf code.
BNF_DOB_RQD_FLAG●Indicator (Y/N) for the bnf dob rqd.
BNF_DSGE_MNR_TTEE_RQD_FLAG●Indicator (Y/N) for the bnf dsge mnr ttee rqd.
BNF_INCRMT_AMT●Bnf incrmt amount.
BNF_LEGV_ID_RQD_FLAG●Indicator (Y/N) for the bnf legv id rqd.
BNF_MAY_DSGT_ORG_FLAG●Indicator (Y/N) for the bnf may dsgt organization.
BNF_MN_DSGNTBL_AMT●Bnf mn dsgntbl amount.
BNF_MN_DSGNTBL_PCT_VAL●Bnf mn dsgntbl percent val.
BNF_PCT_AMT_ALWD_CD●Bnf percent amount alwd code.
BNF_PCT_INCRMT_VAL●Bnf percent incrmt val.
BNF_QDRO_RL_APLS_FLAG●Indicator (Y/N) for the bnf qdro rl apls.
BUSINESS_GROUP_ID●Identifier for the business group.
CARRIER_ID●Identifier for the carrier.
CARRIER_PL_NAME●Name of the carrier pl.
CMPR_CLMS_TO_CVG_OR_BAL_CD●Cmpr clms to cvg or balance code.
COBRA_PYMT_DUE_DY_NUM●Cobra payment due dy number.
COBRA_PYMT_DUE_DY_NUM_CD●Cobra payment due dy number code.
CONFIG_CHAR_1●Config char 1.
CONFIG_CHAR_3●Config char 3.
CONFIG_CHAR_7●Config char 7.
CONFIG_ID_1●Config id 1.
COST_ALLOC_KEYFLEX_1_ID●Identifier for the cost alloc keyflex 1.
COST_ALLOC_KEYFLEX_2_ID●Identifier for the cost alloc keyflex 2.
CREATED_BY●User who created the row.
CREATION_DATE●Date and time the row was created.
CR_DSTR_BNFT_PRVDR_POOL_ID●Identifier for the cr dstr bnft prvdr pool.
CVG_AMT_LMT_RL●Cvg amount lmt rl.
CVG_INCR_R_DECR_ONLY_CD●Cvg incr r decr only code.
CVG_MLT_LMT_RL●Cvg mlt lmt rl.
DFLT_TO_ASN_PNDG_CTFN_CD●Dflt to advance shipment notice pndg ctfn code.
DFLT_TO_ASN_PNDG_CTFN_RL●Dflt to advance shipment notice pndg ctfn rl.
DMSTC_PRTR_RT_TRTMT_FLAG●Indicator (Y/N) for the dmstc prtr rt trtmt.
DPNT_CVD_BY_OTHR_APLS_FLAG●Indicator (Y/N) for the dpnt cvd by othr apls.
DPNT_CVG_END_DT_CD●Dpnt cvg end date code.
DPNT_CVG_END_DT_RL●Dpnt cvg end date rl.
DPNT_CVG_STRT_DT_CD●Dpnt cvg strt date code.
DPNT_CVG_STRT_DT_RL●Dpnt cvg strt date rl.
DPNT_LEG_ID_RQD_FLAG●Indicator (Y/N) for the dpnt leg id rqd.
DPNT_NO_CTFN_RQD_FLAG●Indicator (Y/N) for the dpnt number ctfn rqd.
DRVBL_DPNT_ELIG_FLAG●Indicator (Y/N) for the drvbl dpnt elig.
DRVBL_FCTR_APLS_RTS_FLAG●Indicator (Y/N) for the drvbl fctr apls rts.
DRVBL_FCTR_PRTN_ELIG_FLAG●Indicator (Y/N) for the drvbl fctr prtn elig.
EFFECTIVE_END_DATE●End date of the effective-dated record.
EFFECTIVE_START_DATEPK?●Start date of the effective-dated record.
ELIG_APLS_FLAG●Indicator (Y/N) for the elig apls.
ENRL_PL_OPT_FLAG●Indicator (Y/N) for the enrl pl opt.
ENRT_CD●Enrt code.
ENRT_CVG_END_DT_CD●Enrt cvg end date code.
ENRT_CVG_END_DT_RL●Enrt cvg end date rl.
ENRT_CVG_STRT_DT_CD●Enrt cvg strt date code.
ENRT_CVG_STRT_DT_RL●Enrt cvg strt date rl.
ENRT_MTHD_CD●Enrt mthd code.
ENRT_PL_OPT_FLAG●Indicator (Y/N) for the enrt pl opt.
ENRT_RL●Enrt rl.
FRFS_APLY_FLAG●Indicator (Y/N) for the frfs aply.
FRFS_CNTR_DET_CD●Frfs cntr det code.
FRFS_DISTR_DET_CD●Frfs distr det code.
FRFS_DISTR_MTHD_CD●Frfs distr mthd code.
FRFS_DISTR_MTHD_RL●Frfs distr mthd rl.
FRFS_MX_CRYFWD_VAL●Frfs mx cryfwd val.
FRFS_PORTION_DET_CD●Frfs portion det code.
FRFS_VAL_DET_CD●Frfs val det code.
FUNCTION_CODE●Code identifying the function.
GLOBAL_FLAG●Indicator (Y/N) for the global.
GROUP_PL_ID●Identifier for the group pl.
HC_PL_SUBJ_HCFA_APRVL_FLAG●Indicator (Y/N) for the hc pl subj hcfa aprvl.
HC_SVC_TYP_CD●Hc svc type code.
HGHLY_CMPD_RL_APLS_FLAG●Indicator (Y/N) for the hghly cmpd rl apls.
IMPTD_INCM_CALC_CD●Imptd incm calc code.
INCPTN_DT●Incptn date.
INVK_DCLN_PRTN_PL_FLAG●Indicator (Y/N) for the invk dcln prtn pl.
INVK_FLX_CR_PL_FLAG●Indicator (Y/N) for the invk flx cr pl.
INVK_IMPTD_INCM_PL_FLAG●Indicator (Y/N) for the invk imptd incm pl.
IVR_IDENT●Ivr ident.
LAST_UPDATED_BY●User who last updated the row.
LAST_UPDATE_DATEINCR●Date and time the row was last updated (the incremental-extract key).
LAST_UPDATE_LOGIN●Session login of the user who last updated the row.
LEGISLATION_CODE●Code identifying the legislation.
LEGISLATION_SUBGROUP●Legislation subgroup.
MAPPING_TABLE_NAME●Name of the mapping table.
MAPPING_TABLE_PK_ID●Identifier for the mapping table pk.
MAY_ENRL_PL_N_OIPL_FLAG●Indicator (Y/N) for the may enrl pl n oipl.
MN_CVG_ALWD_AMT●Mn cvg alwd amount.
MN_CVG_RQD_AMT●Mn cvg rqd amount.
MN_CVG_RQD_MLT_NUM●Mn cvg rqd mlt number.
MN_OPTS_RQD_NUM●Mn opts rqd number.
MX_CVG_ALWD_AMT●Mx cvg alwd amount.
MX_CVG_ALWD_MLT_NUM●Mx cvg alwd mlt number.
MX_CVG_INCR_ALWD_AMT●Mx cvg incr alwd amount.
MX_CVG_INCR_WCF_ALWD_AMT●Mx cvg incr wcf alwd amount.
MX_CVG_MLT_INCR_NUM●Mx cvg mlt incr number.
MX_CVG_MLT_INCR_WCF_NUM●Mx cvg mlt incr wcf number.
MX_CVG_WCFN_AMT●Mx cvg wcfn amount.
MX_CVG_WCFN_MLT_NUM●Mx cvg wcfn mlt number.
MX_OPTS_ALWD_NUM●Mx opts alwd number.
MX_WTG_DT_TO_USE_CD●Mx wtg date to use code.
MX_WTG_DT_TO_USE_RL●Mx wtg date to use rl.
MX_WTG_PERD_PRTE_APLS_FLAG●Indicator (Y/N) for the mx wtg perd prte apls.
MX_WTG_PERD_PRTE_DET_CD●Mx wtg perd prte det code.
MX_WTG_PERD_PRTE_DET_RL●Mx wtg perd prte det rl.
MX_WTG_PERD_PRTE_UOM●Mx wtg perd prte unit of measure.
MX_WTG_PERD_PRTE_VAL●Mx wtg perd prte val.
MX_WTG_PERD_RL●Mx wtg perd rl.
NAME●Name.
NIP_ACTY_REF_PERD_CD●Nip acty reference perd code.
NIP_DFLT_ENRT_CD●Nip dflt enrt code.
NIP_DFLT_ENRT_DET_RL●Nip dflt enrt det rl.
NIP_DFLT_FLAG●Indicator (Y/N) for the nip dflt.
NIP_ENRT_INFO_RT_FREQ_CD●Nip enrt info rt freq code.
NIP_PL_UOM●Nip pl unit of measure.
NIP_RQD_ENRL_PERD_TCO_CD●Nip rqd enrl perd tco code.
NO_MN_OPTS_NUM_APLS_FLAG●Indicator (Y/N) for the number mn opts number apls.
NO_MX_OPTS_NUM_APLS_FLAG●Indicator (Y/N) for the number mx opts number apls.
OBJECT_VERSION_NUMBER●Optimistic-locking version number, incremented on each update.
ORDR_NUM●Ordr number.
PAYROLL_MAPPING_LEVEL●Payroll mapping level.
PCP_CD●Pcp code.
PER_CVRD_CD●Per cvrd code.
PLN_ATTRIBUTE1●Pln attribute1.
PLN_ATTRIBUTE10●Pln attribute10.
PLN_ATTRIBUTE11●Pln attribute11.
PLN_ATTRIBUTE12●Pln attribute12.
PLN_ATTRIBUTE13●Pln attribute13.
PLN_ATTRIBUTE14●Pln attribute14.
PLN_ATTRIBUTE15●Pln attribute15.
PLN_ATTRIBUTE16●Pln attribute16.
PLN_ATTRIBUTE17●Pln attribute17.
PLN_ATTRIBUTE18●Pln attribute18.
PLN_ATTRIBUTE19●Pln attribute19.
PLN_ATTRIBUTE2●Pln attribute2.
PLN_ATTRIBUTE20●Pln attribute20.
PLN_ATTRIBUTE21●Pln attribute21.
PLN_ATTRIBUTE22●Pln attribute22.
PLN_ATTRIBUTE23●Pln attribute23.
PLN_ATTRIBUTE24●Pln attribute24.
PLN_ATTRIBUTE25●Pln attribute25.
PLN_ATTRIBUTE26●Pln attribute26.
PLN_ATTRIBUTE27●Pln attribute27.
PLN_ATTRIBUTE28●Pln attribute28.
PLN_ATTRIBUTE29●Pln attribute29.
PLN_ATTRIBUTE3●Pln attribute3.
PLN_ATTRIBUTE30●Pln attribute30.
PLN_ATTRIBUTE4●Pln attribute4.
PLN_ATTRIBUTE5●Pln attribute5.
PLN_ATTRIBUTE6●Pln attribute6.
PLN_ATTRIBUTE7●Pln attribute7.
PLN_ATTRIBUTE8●Pln attribute8.
PLN_ATTRIBUTE9●Pln attribute9.
PLN_ATTRIBUTE_CATEGORY●Pln attribute category.
PLN_MN_CVG_ALWD_AMT●Pln mn cvg alwd amount.
PL_CD●Pl code.
PL_IDPK?●Identifier for the pl.
PL_STAT_CD●Pl status code.
PL_TYP_ID●Identifier for the pl type.
PL_YR_NOT_APPLCBL_FLAG●Indicator (Y/N) for the pl yr not applcbl.
POSTELCN_EDIT_RL●Postelcn edit rl.
POST_TO_GL_FLAG●Indicator (Y/N) for the post to general ledger.
PRMRY_FNDG_MTHD_CD●Prmry fndg mthd code.
PRORT_PRTL_YR_CVG_RSTRN_CD●Prort prtl yr cvg rstrn code.
PRORT_PRTL_YR_CVG_RSTRN_RL●Prort prtl yr cvg rstrn rl.
PRTN_ELIG_OVRID_ALWD_FLAG●Indicator (Y/N) for the prtn elig ovrid alwd.
RQD_PERD_ENRT_NENRT_RL●Rqd perd enrt nenrt rl.
RQD_PERD_ENRT_NENRT_UOM●Rqd perd enrt nenrt unit of measure.
RQD_PERD_ENRT_NENRT_VAL●Rqd perd enrt nenrt val.
RT_END_DT_CD●Rt end date code.
RT_END_DT_RL●Rt end date rl.
RT_STRT_DT_CD●Rt strt date code.
RT_STRT_DT_RL●Rt strt date rl.
SHORT_CODE●Code identifying the short.
SHORT_NAME●Name of the short.
SUBJ_TO_IMPTD_INCM_CD●Subj to imptd incm code.
SUBJ_TO_IMPTD_INCM_TYP_CD●Subj to imptd incm type code.
SUBJ_TO_IMPUT_INC_FLAG●Indicator (Y/N) for the subj to imput inc.
SUSP_IF_CTFN_NOT_BNF_FLAG●Indicator (Y/N) for the susp if ctfn not bnf.
SUSP_IF_CTFN_NOT_PRVD_FLAG●Indicator (Y/N) for the susp if ctfn not prvd.
SVGS_PL_FLAG●Indicator (Y/N) for the svgs pl.
TRK_INELIG_PER_FLAG●Indicator (Y/N) for the trk inelig per.
UNSSPND_ENRT_CD●Unsspnd enrt code.
UNSSPND_ENRT_RL●Unsspnd enrt rl.
UNSSPND_RT_CD●Unsspnd rt code.
UNSSPND_RT_RL●Unsspnd rt rl.
URL_REF_NAME●Name of the url reference.
USES_CIR●Uses cir.
USE_ALL_ASNTS_ELIG_FLAG●Indicator (Y/N) for the use all asnts elig.
USE_ALL_ASNTS_FOR_RT_FLAG●Indicator (Y/N) for the use all asnts for rt.
USE_CSD_RSD_PRCCNG_CD●Use csd rsd prccng code.
VRFY_FMLY_MMBR_CD●Vrfy fmly mmbr code.
VRFY_FMLY_MMBR_RL●Vrfy fmly mmbr rl.
VSTG_APLS_FLAG●Indicator (Y/N) for the vstg apls.
WVBL_FLAG●Indicator (Y/N) for the wvbl.

Used by reports

No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.

Subject areas

Need the extract + dbt staging for BEN_PL_F?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us
Problems that run through this table
What the extract does not carry · The export ceiling · The extraction pattern