Oracle Fusion · Data dictionary
BEN_ELIG_CVRD_DPNT
BenefitsUsed in 0 subject areas96 reporting columnsBICC incremental-ready
Benefits (BEN).
Likely primary key: ELIG_CVRD_DPNT_ID (inferred from Oracle naming conventions, verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE
Joins (inferred from key columns): PER_IN_LER_ID → BEN_PER_IN_LER · PRTT_ENRT_RSLT_ID → BEN_PRTT_ENRT_RSLT
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| BUSINESS_GROUP_ID | ● | Identifier for the business group. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| CVG_PNDG_FLAG | ● | Indicator (Y/N) for the cvg pndg. | |
| CVG_STRT_DT | ● | Cvg strt date. | |
| CVG_THRU_DT | ● | Cvg thru date. | |
| DPNT_PERSON_ID | ● | Identifier for the dpnt person. | |
| ELIG_CVRD_DPNT_ID | PK? | ● | Identifier for the elig cvrd dpnt. |
| ELIG_PER_ELCTBL_CHC_ID | ● | Identifier for the elig per elctbl chc. | |
| ENDED_CVG_THRU_DT | ● | Ended cvg thru date. | |
| ENDED_PER_IN_LER_ID | ● | Identifier for the ended per in ler. | |
| JOB_DEFINITION_NAME | ● | Name of the job definition. | |
| JOB_DEFINITION_PACKAGE | ● | Job definition package. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | INCR | ● | 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. | |
| OBJECT_VERSION_NUMBER | ● | Optimistic-locking version number, incremented on each update. | |
| ORGNL_OIPL_CVG_STRT_DT | ● | Orgnl oipl cvg strt date. | |
| ORGNL_PLAN_CVG_STRT_DT | ● | Orgnl plan cvg strt date. | |
| OVRDN_FLAG | ● | Indicator (Y/N) for the ovrdn. | |
| OVRDN_THRU_DT | ● | Ovrdn thru date. | |
| PDP_ATTRIBUTE1 | ● | Pdp attribute1. | |
| PDP_ATTRIBUTE10 | ● | Pdp attribute10. | |
| PDP_ATTRIBUTE11 | ● | Pdp attribute11. | |
| PDP_ATTRIBUTE12 | ● | Pdp attribute12. | |
| PDP_ATTRIBUTE13 | ● | Pdp attribute13. | |
| PDP_ATTRIBUTE14 | ● | Pdp attribute14. | |
| PDP_ATTRIBUTE15 | ● | Pdp attribute15. | |
| PDP_ATTRIBUTE16 | ● | Pdp attribute16. | |
| PDP_ATTRIBUTE17 | ● | Pdp attribute17. | |
| PDP_ATTRIBUTE18 | ● | Pdp attribute18. | |
| PDP_ATTRIBUTE19 | ● | Pdp attribute19. | |
| PDP_ATTRIBUTE2 | ● | Pdp attribute2. | |
| PDP_ATTRIBUTE20 | ● | Pdp attribute20. | |
| PDP_ATTRIBUTE21 | ● | Pdp attribute21. | |
| PDP_ATTRIBUTE22 | ● | Pdp attribute22. | |
| PDP_ATTRIBUTE23 | ● | Pdp attribute23. | |
| PDP_ATTRIBUTE24 | ● | Pdp attribute24. | |
| PDP_ATTRIBUTE25 | ● | Pdp attribute25. | |
| PDP_ATTRIBUTE26 | ● | Pdp attribute26. | |
| PDP_ATTRIBUTE27 | ● | Pdp attribute27. | |
| PDP_ATTRIBUTE28 | ● | Pdp attribute28. | |
| PDP_ATTRIBUTE29 | ● | Pdp attribute29. | |
| PDP_ATTRIBUTE3 | ● | Pdp attribute3. | |
| PDP_ATTRIBUTE30 | ● | Pdp attribute30. | |
| PDP_ATTRIBUTE4 | ● | Pdp attribute4. | |
| PDP_ATTRIBUTE5 | ● | Pdp attribute5. | |
| PDP_ATTRIBUTE6 | ● | Pdp attribute6. | |
| PDP_ATTRIBUTE7 | ● | Pdp attribute7. | |
| PDP_ATTRIBUTE8 | ● | Pdp attribute8. | |
| PDP_ATTRIBUTE9 | ● | Pdp attribute9. | |
| PDP_ATTRIBUTE_CATEGORY | ● | Pdp attribute category. | |
| PDP_ATTRIBUTE_DATE1 | ● | Pdp attribute date1. | |
| PDP_ATTRIBUTE_DATE10 | ● | Pdp attribute date10. | |
| PDP_ATTRIBUTE_DATE11 | ● | Pdp attribute date11. | |
| PDP_ATTRIBUTE_DATE12 | ● | Pdp attribute date12. | |
| PDP_ATTRIBUTE_DATE13 | ● | Pdp attribute date13. | |
| PDP_ATTRIBUTE_DATE14 | ● | Pdp attribute date14. | |
| PDP_ATTRIBUTE_DATE15 | ● | Pdp attribute date15. | |
| PDP_ATTRIBUTE_DATE2 | ● | Pdp attribute date2. | |
| PDP_ATTRIBUTE_DATE3 | ● | Pdp attribute date3. | |
| PDP_ATTRIBUTE_DATE4 | ● | Pdp attribute date4. | |
| PDP_ATTRIBUTE_DATE5 | ● | Pdp attribute date5. | |
| PDP_ATTRIBUTE_DATE6 | ● | Pdp attribute date6. | |
| PDP_ATTRIBUTE_DATE7 | ● | Pdp attribute date7. | |
| PDP_ATTRIBUTE_DATE8 | ● | Pdp attribute date8. | |
| PDP_ATTRIBUTE_DATE9 | ● | Pdp attribute date9. | |
| PDP_ATTRIBUTE_NUMBER1 | ● | Pdp attribute number1. | |
| PDP_ATTRIBUTE_NUMBER10 | ● | Pdp attribute number10. | |
| PDP_ATTRIBUTE_NUMBER11 | ● | Pdp attribute number11. | |
| PDP_ATTRIBUTE_NUMBER12 | ● | Pdp attribute number12. | |
| PDP_ATTRIBUTE_NUMBER13 | ● | Pdp attribute number13. | |
| PDP_ATTRIBUTE_NUMBER14 | ● | Pdp attribute number14. | |
| PDP_ATTRIBUTE_NUMBER15 | ● | Pdp attribute number15. | |
| PDP_ATTRIBUTE_NUMBER16 | ● | Pdp attribute number16. | |
| PDP_ATTRIBUTE_NUMBER17 | ● | Pdp attribute number17. | |
| PDP_ATTRIBUTE_NUMBER18 | ● | Pdp attribute number18. | |
| PDP_ATTRIBUTE_NUMBER19 | ● | Pdp attribute number19. | |
| PDP_ATTRIBUTE_NUMBER2 | ● | Pdp attribute number2. | |
| PDP_ATTRIBUTE_NUMBER20 | ● | Pdp attribute number20. | |
| PDP_ATTRIBUTE_NUMBER3 | ● | Pdp attribute number3. | |
| PDP_ATTRIBUTE_NUMBER4 | ● | Pdp attribute number4. | |
| PDP_ATTRIBUTE_NUMBER5 | ● | Pdp attribute number5. | |
| PDP_ATTRIBUTE_NUMBER6 | ● | Pdp attribute number6. | |
| PDP_ATTRIBUTE_NUMBER7 | ● | Pdp attribute number7. | |
| PDP_ATTRIBUTE_NUMBER8 | ● | Pdp attribute number8. | |
| PDP_ATTRIBUTE_NUMBER9 | ● | Pdp attribute number9. | |
| PER_IN_LER_ID | ● | Identifier for the per in ler. | |
| PROGRAM_APP_NAME | ● | Name of the program app. | |
| PROGRAM_NAME | ● | Name of the program. | |
| PROGRAM_UPDATE_DATE | ● | Program update date. | |
| PRTT_ENRT_RSLT_ID | ● | Identifier for the prtt enrt rslt. | |
| PRVS_CVG_STRT_DT | ● | Prvs cvg strt date. | |
| PRVS_CVG_THRU_DT | ● | Prvs cvg thru date. | |
| REQUEST_ID | ● | Identifier of the process that created or last updated the row. | |
| RLNSHP_CD | ● | Rlnshp 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_CVRD_DPNT?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table