Oracle Fusion · Data dictionary
BEN_ELIG_PERSON_DETAILS_V
BenefitsUsed in 0 subject areas64 reporting columnsBICC incremental-ready
Benefits (BEN), denormalized view.
Primary key: not yet catalogued for BEN_ELIG_PERSON_DETAILS_V, reference Oracle Tables & Views guide. · Incremental key: ELIG_CREATION_DATE, ELIG_LAST_UPDATE_DATE, OPT_CREATION_DATE, OPT_LAST_UPDATE_DATE
Joins (inferred from key columns): BENEFIT_RELATION_ID → BEN_BILL_CHARGE_DETAILS · LEGAL_ENTITY_ID → XLE_ENTITY_PROFILES · PER_IN_LER_ID → BEN_PER_IN_LER
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| AGE_VAL | ● | Age val. | |
| BENEFIT_GROUP_ID | ● | Identifier for the benefit group. | |
| BENEFIT_RELATION_ID | ● | Identifier for the benefit relation. | |
| BENEFIT_RELATION_NAME | ● | Name of the benefit relation. | |
| COMP_REF_AMT | ● | Comp reference amount. | |
| DPNT_OTHR_PL_CVRD_RL_FLAG | ● | Indicator (Y/N) for the dpnt othr pl cvrd rl. | |
| ELIG_CREATED_BY | ● | Elig created by. | |
| ELIG_CREATION_DATE | INCR | ● | Elig creation date. |
| ELIG_EFFECTIVE_END_DATE | ● | Elig effective end date. | |
| ELIG_EFFECTIVE_START_DATE | ● | Elig effective start date. | |
| ELIG_FLAG | ● | Indicator (Y/N) for the elig. | |
| ELIG_LAST_UPDATED_BY | ● | Elig last updated by. | |
| ELIG_LAST_UPDATE_DATE | INCR | ● | Elig last update date. |
| ELIG_LAST_UPDATE_LOGIN | ● | Elig last update login. | |
| ELIG_PER_ID | ● | Identifier for the elig per. | |
| ELIG_PER_OPT_ID | ● | Identifier for the elig per opt. | |
| FRZ_AGE_FLAG | ● | Indicator (Y/N) for the frz age. | |
| GRP_EFFECTIVE_END_DATE | ● | Grp effective end date. | |
| GRP_EFFECTIVE_START_DATE | ● | Grp effective start date. | |
| HRS_WKD_VAL | ● | Hrs wkd val. | |
| LEGAL_ENTITY_ID | ● | Identifier of the legal entity. | |
| LER_ID | ● | Identifier for the ler. | |
| LOS_VAL | ● | Los val. | |
| NO_MX_PRTN_OVRID_THRU_FLAG | ● | Indicator (Y/N) for the number mx prtn ovrid thru. | |
| OPT_CREATED_BY | ● | Opt created by. | |
| OPT_CREATION_DATE | INCR | ● | Opt creation date. |
| OPT_EFFECTIVE_END_DATE | ● | Opt effective end date. | |
| OPT_EFFECTIVE_START_DATE | ● | Opt effective start date. | |
| OPT_ID | ● | Identifier for the opt. | |
| OPT_LAST_UPDATED_BY | ● | Opt last updated by. | |
| OPT_LAST_UPDATE_DATE | INCR | ● | Opt last update date. |
| OPT_LAST_UPDATE_LOGIN | ● | Opt last update login. | |
| PCT_FL_TM_VAL | ● | Percent fl tm val. | |
| PERSON_ID | ● | Identifier for the person. | |
| PER_IN_LER_ID | ● | Identifier for the per in ler. | |
| PGM_ID | ● | Identifier for the pgm. | |
| PL2_EFFECTIVE_END_DATE | ● | Pl2 effective end date. | |
| PL2_EFFECTIVE_START_DATE | ● | Pl2 effective start date. | |
| PLIP_EFFECTIVE_END_DATE | ● | Plip effective end date. | |
| PLIP_EFFECTIVE_START_DATE | ● | Plip effective start date. | |
| PLIP_ID | ● | Identifier for the plip. | |
| PL_EFFECTIVE_END_DATE | ● | Pl effective end date. | |
| PL_EFFECTIVE_START_DATE | ● | Pl effective start date. | |
| PL_ID | ● | Identifier for the pl. | |
| PL_KEY_EE_FLAG | ● | Indicator (Y/N) for the pl key ee. | |
| PL_TYP2_EFFECTIVE_END_DATE | ● | Pl typ2 effective end date. | |
| PL_TYP2_EFFECTIVE_START_DATE | ● | Pl typ2 effective start date. | |
| PL_TYP3_EFFECTIVE_END_DATE | ● | Pl typ3 effective end date. | |
| PL_TYP3_EFFECTIVE_START_DATE | ● | Pl typ3 effective start date. | |
| PL_TYP_EFFECTIVE_END_DATE | ● | Pl type effective end date. | |
| PL_TYP_EFFECTIVE_START_DATE | ● | Pl type effective start date. | |
| PL_TYP_ID | ● | Identifier for the pl type. | |
| PRIMARY_REL | ● | Primary rel. | |
| PRTN_END_DT | ● | Prtn end date. | |
| PRTN_OVRIDN_RSN_CD | ● | Prtn ovridn rsn code. | |
| PRTN_OVRIDN_THRU_DT | ● | Prtn ovridn thru date. | |
| PRTN_STRT_DT | ● | Prtn strt date. | |
| PTIP_EFFECTIVE_END_DATE | ● | Ptip effective end date. | |
| PTIP_EFFECTIVE_START_DATE | ● | Ptip effective start date. | |
| PTIP_ID | ● | Identifier for the ptip. | |
| REL_EFFECTIVE_END_DATE | ● | Rel effective end date. | |
| REL_EFFECTIVE_START_DATE | ● | Rel effective start date. | |
| REL_PRMRY_ASG_ID | ● | Identifier for the rel prmry asg. | |
| WV_CTFN_TYP_CD | ● | Wv ctfn type 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_ELIG_PERSON_DETAILS_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table