Oracle Fusion · Data dictionary
BEN_OPT_F
BenefitsUsed in 0 subject areas57 reporting columnsBICC incremental-ready
Benefits (BEN).
Likely primary key: OPT_ID, EFFECTIVE_START_DATE (inferred from Oracle naming conventions — verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| BUSINESS_GROUP_ID | ● | Identifier for the business group. | |
| CARRIER_OPT_NAME | ● | Name of the carrier opt. | |
| CMBN_PTIP_OPT_ID | ● | Identifier for the cmbn ptip opt. | |
| COMPONENT_REASON | ● | Component reason. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| EFFECTIVE_END_DATE | ● | End date of the effective-dated record. | |
| EFFECTIVE_START_DATE | PK? | ● | Start date of the effective-dated record. |
| GLOBAL_FLAG | ● | Indicator (Y/N) for the global. | |
| GROUP_OPT_ID | ● | Identifier for the group opt. | |
| INVK_WV_OPT_FLAG | ● | Indicator (Y/N) for the invk wv opt. | |
| 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. | |
| 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. | |
| NAME | ● | Name. | |
| OBJECT_VERSION_NUMBER | ● | Optimistic-locking version number, incremented on each update. | |
| OPT_ATTRIBUTE1 | ● | Opt attribute1. | |
| OPT_ATTRIBUTE10 | ● | Opt attribute10. | |
| OPT_ATTRIBUTE11 | ● | Opt attribute11. | |
| OPT_ATTRIBUTE12 | ● | Opt attribute12. | |
| OPT_ATTRIBUTE13 | ● | Opt attribute13. | |
| OPT_ATTRIBUTE14 | ● | Opt attribute14. | |
| OPT_ATTRIBUTE15 | ● | Opt attribute15. | |
| OPT_ATTRIBUTE16 | ● | Opt attribute16. | |
| OPT_ATTRIBUTE17 | ● | Opt attribute17. | |
| OPT_ATTRIBUTE18 | ● | Opt attribute18. | |
| OPT_ATTRIBUTE19 | ● | Opt attribute19. | |
| OPT_ATTRIBUTE2 | ● | Opt attribute2. | |
| OPT_ATTRIBUTE20 | ● | Opt attribute20. | |
| OPT_ATTRIBUTE21 | ● | Opt attribute21. | |
| OPT_ATTRIBUTE22 | ● | Opt attribute22. | |
| OPT_ATTRIBUTE23 | ● | Opt attribute23. | |
| OPT_ATTRIBUTE24 | ● | Opt attribute24. | |
| OPT_ATTRIBUTE25 | ● | Opt attribute25. | |
| OPT_ATTRIBUTE26 | ● | Opt attribute26. | |
| OPT_ATTRIBUTE27 | ● | Opt attribute27. | |
| OPT_ATTRIBUTE28 | ● | Opt attribute28. | |
| OPT_ATTRIBUTE29 | ● | Opt attribute29. | |
| OPT_ATTRIBUTE3 | ● | Opt attribute3. | |
| OPT_ATTRIBUTE30 | ● | Opt attribute30. | |
| OPT_ATTRIBUTE4 | ● | Opt attribute4. | |
| OPT_ATTRIBUTE5 | ● | Opt attribute5. | |
| OPT_ATTRIBUTE6 | ● | Opt attribute6. | |
| OPT_ATTRIBUTE7 | ● | Opt attribute7. | |
| OPT_ATTRIBUTE8 | ● | Opt attribute8. | |
| OPT_ATTRIBUTE9 | ● | Opt attribute9. | |
| OPT_ATTRIBUTE_CATEGORY | ● | Opt attribute category. | |
| OPT_ID | PK? | ● | Identifier for the opt. |
| 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. | |
| SHORT_CODE | ● | Code identifying the short. | |
| SHORT_NAME | ● | Name of the short. |
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_OPT_F?
We ship parameterized SQL, BICC config, and dbt models you own.