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

BEN_ELIGY_PRFL

BenefitsUsed in 0 subject areas96 reporting columnsBICC incremental-ready

Benefits (BEN).

Likely primary key: ELIGY_PRFL_ID (inferred from Oracle naming conventions, verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE

Columns

ColumnKeyIn reportsDescription (inferred)
ASG_TYP_CD●Asg type code.
ASMT_TO_USE_CD●Asmt to use code.
BNFT_CAGR_PRTN_CD●Bnft cagr prtn code.
BUSINESS_GROUP_ID●Identifier for the business group.
CNTNG_PRTN_ELIG_PRFL_FLAG●Indicator (Y/N) for the cntng prtn elig prfl.
CREATED_BY●User who created the row.
CREATION_DATE●Date and time the row was created.
DESCRIPTION●Description.
DPNT_CVG_ELIG_DET_RL●Dpnt cvg elig det rl.
DPNT_CVRD_IN_ANTHR_PL_FLAG●Indicator (Y/N) for the dpnt cvrd in anthr pl.
DPNT_DSGNT_CRNTLY_ENRLD_FLAG●Indicator (Y/N) for the dpnt dsgnt crntly enrld.
DPNT_MLTRY_FLAG●Indicator (Y/N) for the dpnt mltry.
DPNT_RLSHP_FLAG●Indicator (Y/N) for the dpnt rlshp.
DPNT_STUD_FLAG●Indicator (Y/N) for the dpnt stud.
ELIGY_PRFL_IDPK?●Identifier for the eligy prfl.
ELIGY_PRFL_RL_FLAG●Indicator (Y/N) for the eligy prfl rl.
ELIG_AGE_FLAG●Indicator (Y/N) for the elig age.
ELIG_ANTHR_PL_FLAG●Indicator (Y/N) for the elig anthr pl.
ELIG_ASNT_SET_FLAG●Indicator (Y/N) for the elig asnt set.
ELIG_BENFTS_GRP_FLAG●Indicator (Y/N) for the elig benfts grp.
ELIG_BRGNG_UNIT_FLAG●Indicator (Y/N) for the elig brgng unit.
ELIG_BU_FLAG●Indicator (Y/N) for the elig business unit.
ELIG_CBR_QUALD_BNF_FLAG●Indicator (Y/N) for the elig cbr quald bnf.
ELIG_CMBN_AGE_LOS_FLAG●Indicator (Y/N) for the elig cmbn age los.
ELIG_COMPTNCY_FLAG●Indicator (Y/N) for the elig comptncy.
ELIG_COMP_LVL_FLAG●Indicator (Y/N) for the elig comp lvl.
ELIG_CRIT_VALUES_FLAG●Indicator (Y/N) for the elig crit values.
ELIG_DPNT_CVRD_PGM_FLAG●Indicator (Y/N) for the elig dpnt cvrd pgm.
ELIG_DPNT_CVRD_PLIP_FLAG●Indicator (Y/N) for the elig dpnt cvrd plip.
ELIG_DPNT_CVRD_PL_FLAG●Indicator (Y/N) for the elig dpnt cvrd pl.
ELIG_DPNT_CVRD_PTIP_FLAG●Indicator (Y/N) for the elig dpnt cvrd ptip.
ELIG_DPNT_OTHR_PTIP_FLAG●Indicator (Y/N) for the elig dpnt othr ptip.
ELIG_DSBLD_FLAG●Indicator (Y/N) for the elig dsbld.
ELIG_DSBLTY_CTG_FLAG●Indicator (Y/N) for the elig dsblty ctg.
ELIG_DSBLTY_DGR_FLAG●Indicator (Y/N) for the elig dsblty dgr.
ELIG_DSBLTY_RSN_FLAG●Indicator (Y/N) for the elig dsblty rsn.
ELIG_EE_STAT_FLAG●Indicator (Y/N) for the elig ee status.
ELIG_ENRLD_OIPL_FLAG●Indicator (Y/N) for the elig enrld oipl.
ELIG_ENRLD_PGM_FLAG●Indicator (Y/N) for the elig enrld pgm.
ELIG_ENRLD_PLIP_FLAG●Indicator (Y/N) for the elig enrld plip.
ELIG_ENRLD_PL_FLAG●Indicator (Y/N) for the elig enrld pl.
ELIG_ENRLD_PTIP_FLAG●Indicator (Y/N) for the elig enrld ptip.
ELIG_FL_TM_PT_TM_FLAG●Indicator (Y/N) for the elig fl tm pt tm.
ELIG_GEO_FLAG●Indicator (Y/N) for the elig geo.
ELIG_GNDR_FLAG●Indicator (Y/N) for the elig gndr.
ELIG_GRD_FLAG●Indicator (Y/N) for the elig grd.
ELIG_HIREDT_FLAG●Indicator (Y/N) for the elig hiredt.
ELIG_HLTH_CVG_FLAG●Indicator (Y/N) for the elig hlth cvg.
ELIG_HRLY_SLRD_FLAG●Indicator (Y/N) for the elig hrly slrd.
ELIG_HRS_WKD_FLAG●Indicator (Y/N) for the elig hrs wkd.
ELIG_JOBFAM_FLAG●Indicator (Y/N) for the elig jobfam.
ELIG_JOBFUNC_FLAG●Indicator (Y/N) for the elig jobfunc.
ELIG_JOB_FLAG●Indicator (Y/N) for the elig job.
ELIG_LBR_MMBR_FLAG●Indicator (Y/N) for the elig lbr mmbr.
ELIG_LGL_ENTY_FLAG●Indicator (Y/N) for the elig lgl enty.
ELIG_LOA_RSN_FLAG●Indicator (Y/N) for the elig loa rsn.
ELIG_LOS_FLAG●Indicator (Y/N) for the elig los.
ELIG_LVG_RSN_FLAG●Indicator (Y/N) for the elig lvg rsn.
ELIG_MGR_FLAG●Indicator (Y/N) for the elig mgr.
ELIG_MRTL_STS_FLAG●Indicator (Y/N) for the elig mrtl status.
ELIG_NO_OTHR_CVG_FLAG●Indicator (Y/N) for the elig number othr cvg.
ELIG_OPTD_MDCR_FLAG●Indicator (Y/N) for the elig optd mdcr.
ELIG_ORG_UNIT_FLAG●Indicator (Y/N) for the elig organization unit.
ELIG_PCT_FL_TM_FLAG●Indicator (Y/N) for the elig percent fl tm.
ELIG_PERF_RTNG_FLAG●Indicator (Y/N) for the elig perf rtng.
ELIG_PER_TYP_FLAG●Indicator (Y/N) for the elig per type.
ELIG_PPL_GRP_FLAG●Indicator (Y/N) for the elig ppl grp.
ELIG_PRBTN_PERD_FLAG●Indicator (Y/N) for the elig prbtn perd.
ELIG_PRTT_PL_FLAG●Indicator (Y/N) for the elig prtt pl.
ELIG_PSTL_CD_FLAG●Indicator (Y/N) for the elig pstl code.
ELIG_PSTN_FLAG●Indicator (Y/N) for the elig pstn.
ELIG_PTIP_PRTE_FLAG●Indicator (Y/N) for the elig ptip prte.
ELIG_PYRL_FLAG●Indicator (Y/N) for the elig pyrl.
ELIG_PY_BSS_FLAG●Indicator (Y/N) for the elig py bss.
ELIG_QUAL_TITL_FLAG●Indicator (Y/N) for the elig qual titl.
ELIG_QUA_IN_GR_FLAG●Indicator (Y/N) for the elig qua in gr.
ELIG_RELIGION_FLAG●Indicator (Y/N) for the elig religion.
ELIG_SCHEDD_HRS_FLAG●Indicator (Y/N) for the elig schedd hrs.
ELIG_SP_CLNG_PRG_PT_FLAG●Indicator (Y/N) for the elig sp clng prg pt.
ELIG_SUPPL_ROLE_FLAG●Indicator (Y/N) for the elig suppl role.
ELIG_SVC_AREA_FLAG●Indicator (Y/N) for the elig svc area.
ELIG_TBCO_USE_FLAG●Indicator (Y/N) for the elig tbco use.
ELIG_TTL_CVG_VOL_FLAG●Indicator (Y/N) for the elig ttl cvg vol.
ELIG_TTL_PRTT_FLAG●Indicator (Y/N) for the elig ttl prtt.
ELIG_WK_LOC_FLAG●Indicator (Y/N) for the elig wk loc.
ELP_ATTRIBUTE_CATEGORY●Elp attribute category.
END_DATE●End date.
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.
NAME●Name.
OBJECT_VERSION_NUMBER●Optimistic-locking version number, incremented on each update.
PROFILE_TYPE●Type of profile.
REGN_ID●Identifier for the regn.
START_DATE●Start date.
STAT_CD●Status code.

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_ELIGY_PRFL?
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