BEN — Advanced Benefits
498 documented tables · 1368 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
BEN_YR_PERD |
Start and End periods. | hub-leaning |
BEN_ENRT_PERD |
Enrollment Period | hub-leaning |
BEN_PER_IN_LER |
Person having a life event. | hub-leaning |
BEN_PTNL_LER_FOR_PER |
Participant potential life event. | satellite-leaning |
BEN_COMP_LVL_FCTR |
Compensation level factor. | hub-leaning |
BEN_BENEFIT_ACTIONS |
Run parameters for benefits batch processes. | hub-leaning |
BEN_RPTG_GRP |
Reporting group. | hub-leaning |
BEN_BENFTS_GRP |
Grouping item that can be applied to participants to enable them to be eligible for the same benefits. | hub-leaning |
BEN_ELIG_PER_ELCTBL_CHC |
Choices that partipant may elect. | hub-leaning |
BEN_AGE_FCTR |
Age factor. | hub-leaning |
BEN_LOS_FCTR |
Leave of service factor. | hub-leaning |
BEN_EXT_CRIT_PRFL |
Extract criteria profile. | hub-leaning |
BEN_EXT_FLD |
Extract field. | hub-leaning |
BEN_EXT_DATA_ELMT |
Extract data element. | hub |
BEN_CMBN_AGE_LOS_FCTR |
Combination age and length of service factor. | satellite-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
BEN_PRTT_ENRT_RESULT_API |
API | 18 | 29 packages |
BEN_BENEFIT_ACTIONS_API |
API | 5 | 26 packages |
BEN_PTNL_LER_FOR_PER_API |
API | 6 | 23 packages |
BEN_ELIG_PER_ELC_CHC_API |
API | 7 | 22 packages |
BEN_PERSON_ACTIONS_API |
API | 4 | 21 packages |
BEN_PRTT_RT_VAL_API |
API | 7 | 17 packages |
BEN_PERSON_LIFE_EVENT_API |
API | 5 | 17 packages |
BEN_ELIG_DPNT_API |
API | 17 | 17 packages |
BEN_ELIG_CVRD_DPNT_API |
API | 10 | 15 packages |
BEN_BATCH_RANGES_API |
API | 4 | 15 packages |