Results for “rt_usg_cd”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

BEN_ENRT_RT (Enrollment Rate) is a core configuration table within the Oracle Advanced Benefits (BEN) module of Oracle E-Business Suite, present in both release 12.1.1 and 12.2.2. It stores the rate definitions that govern how benefit plan costs, credits, and contributions are calculated when an eligible participant elects a benefit. Each row represents a discrete rate record attached to an enrollment benefit, an eligibility/electability choice, or a derived rate, and it drives the pricing logic used during enrollment, life-event processing, and periodic rate recalculation. The table also holds computation-level factors and participation rate values that adjust the base rate according to compensation level, coverage amount, or other participant attributes.

Under a heuristic Data Vault classification mined from the foreign-key structure, BEN_ENRT_RT is satellite-leaning. It is best understood as a descriptive satellite hanging off enrollment benefit and eligibility/electability hubs, with a self-referencing link (SPCL_RT_ENRT_RT_ID) that models rate-to-rate special derivative relationships. This classification is a modeling suggestion only; in the native EBS schema the object is a conventional transactional configuration table.

The documented 12.2.2 physical schema lists 94 columns owned by the BEN schema, with a single unique index, BEN_ENRT_RT_PK, on the surrogate key ENRT_RT_ID.

Key Information Stored

The most significant columns fall into three groups: identity, rate definition, and calculation parameters.

• ENRT_RT_ID — surrogate primary key (BEN_ENRT_RT_PK); no separate business-key unique index is documented beyond this single-column key.
• ENRT_BNFT_ID — foreign key to BEN_ENRT_BNFT, anchoring the rate to the specific enrollment benefit.
• ELIG_PER_ELCTBL_CHC_ID — foreign key to BEN_ELIG_PER_ELCTBL_CHC, tying the rate to an eligibility/electability choice.
• SPCL_RT_ENRT_RT_ID — self-referencing foreign key that identifies a special or derivative rate record.
• COMP_LVL_FCTR_ID, PTD_COMP_LVL_FCTR_ID, CLM_COMP_LVL_FCTR_ID — compensation-level factors applied to the rate for calculation, period-to-date, and claim contexts.
• PRTT_RT_VAL_ID and ACTL_PREM_ID — links to participation rate values and actual premium data.
• RT_TYP_CD, BNFT_RT_TYP_CD, RT_USG_CD, RT_MLT_CD — rate type, benefit rate type, usage, and multiplier codes.
• VAL, DFLT_VAL, ANN_VAL, ANN_DFLT_VAL — standard, default, annual, and annual-default rate amounts.
• MN_ELCN_VAL, MX_ELCN_VAL, INCRMT_ELCN_VAL, ISS_VAL — minimum, maximum, increment, and issue election values governing allowable input.
• RT_STRT_DT, RT_STRT_DT_CD, RT_STRT_DT_RL — rate start date plus its code and rule.
• DFLT_FLAG, CTFN_RQD_FLAG, DSPLY_ON_ENRT_FLAG, ENTR_VAL_AT_ENRT_FLAG, ASN_ON_ENRT_FLAG — behavioral flags controlling defaulting, certification, display, and entry at enrollment.
• ECR_ATTRIBUTE_CATEGORY and ECR_ATTRIBUTE1 through ECR_ATTRIBUTE30 — descriptive flexfield columns for extensible rate attributes.
• ORDR_NUM — sequencing column for ordering rate records.
• Standard WHO and concurrency columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID.

Common Use Cases and Queries

Typical usage centers on rate setup validation, cost calculation reporting, and reconciliation of calculated rates against source configuration.

• Rates for an enrollment benefit: SELECT r.enrt_rt_id, r.rt_typ_cd, r.val, r.dflt_val FROM ben_enrt_rt r WHERE r.enrt_bnft_id = :p_enrt_bnft_id ORDER BY r.ordr_num;
• Rates tied to an electable choice: join ELIG_PER_ELCTBL_CHC_ID to BEN_ELIG_PER_ELCTBL_CHC to confirm which electable choices carry rate records.
• Derivative/special rate resolution: self-join on SPCL_RT_ENRT_RT_ID to trace a special rate back to its parent rate record.
• Minimum/maximum validation: query MN_ELCN_VAL, MX_ELCN_VAL, and INCRMT_ELCN_VAL to audit allowable election ranges per rate.
• Default flag audit: filter DFLT_FLAG and DFLT_PNDG_CTFN_FLAG to identify rates defaulted automatically versus pending certification.
• Responsibility alignment: filter BUSINESS_GROUP_ID to scope reports to a single business group.

Related Objects

• BEN_ENRT_BNFT — parent object; joined via BEN_ENRT_RT.ENRT_BNFT_ID = BEN_ENRT_BNFT.ENRT_BNFT_ID.
• BEN_ELIG_PER_ELCTBL_CHC — joined via BEN_ENRT_RT.ELIG_PER_ELCTBL_CHC_ID = BEN_ELIG_PER_ELCTBL_CHC.ELIG_PER_ELCTBL_CHC_ID.
• BEN_COMP_LVL_FCTR — joined via COMP_LVL_FCTR_ID; supplies compensation-level adjustment factors.
• BEN_PRTT_RT_VAL — joined via PRTT_RT_VAL_ID; participation rate values.
• BEN_ENRT_RT_CTFN — certification records; references BEN_ENRT_RT.ENRT_RT_ID.
• BEN_ENRT_RT_RBV — rate/benefit-value association; references BEN_ENRT_RT.ENRT_RT_ID.
• BEN_LE_CLSN_N_RSTR — life-event classification restriction; references BEN_ENRT_RT.ENRT_RT_ID.
• BEN_ENRT_RT — self-referencing via SPCL_RT_ENRT_RT_ID for special rate derivation.