Results for “plip_stat_cd”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
BEN_PLIP is an Oracle E-Business Suite Advanced Benefits (BEN) view owned by the APPS schema. In the ETRM 12.2.2 documentation the object is marked VALID and its description is recorded simply as "Retrofitted," indicating that the view was introduced or repositioned as part of the multi-release retrofit effort that aligned the Advanced Benefits data model between EBS 12.1.1 and 12.2.2. The view exposes plan-in-program (PLIP) configuration data — that is, the rules that govern how a particular compensation object or plan is offered within a benefits program, including enrollment methods, coverage effective and end dates, eligibility application flags, and minimum/maximum coverage amounts.
Functionally, BEN_PLIP presents the PLIP entity for reporting, concurrent processing, and integration consumption. Where the underlying base table holds current-row and date-tracked records, BEN_PLIP surfaces the columns most commonly required by downstream extracts such as benefits enrollment listings, plan configuration audits, and interface files consumed by payroll or third-party administrators.
Underlying Base Objects
According to the documented ETRM metadata, BEN_PLIP is defined over the following referenced base objects:
- BEN_PLIP_F (SYNONYM) — the primary base table for plan-in-program definitions. The "_F" suffix conventionally denotes the "frozen" or non-date-tracked presentation of the entity within the BEN schema's multi-table date-tracking architecture.
- FND_SESSIONS (SYNONYM) — the Oracle Application Object Library session table, referenced in the view definition to supply runtime session context (for example the effective session date) used to constrain which date-tracked rows are visible.
The view text confirms this dependency by selecting every major attribute of the plan-in-program record, prefixed in the SQL as CPP.*. The direct relationship is therefore a one-to-one projection: BEN_PLIP does not aggregate or join across the full benefits configuration hierarchy, but rather flattens BEN_PLIP_F into a reporting-friendly interface while applying session-derived filters. Because the synonyms resolve to APPS-owned objects, the view is queryable by any application user with SELECT privilege on APPS.BEN_PLIP.
Key Columns
The column list defines the PLIP contract. Significant columns include:
PLIP_ID,EFFECTIVE_START_DATE,EFFECTIVE_END_DATE— the primary key and date-tracked validity boundaries for each PLIP row.PLIP_STAT_CD— the plan-in-program status code, the attribute referenced in the user's search string "plip_stat_cd". This drives whether a PLIP record is active, pending, or end-dated.PGM_ID,PL_ID,CMBN_PLIP_ID— foreign keys linking the PLIP to its benefits program, its plan, and any combined PLIP parent.DFLT_ENRT_CD,ENRT_CD,ENRT_MTHD_CD,ENRT_RL— default enrollment indicator, enrollment code, enrollment method, and the enrollment rule reference.ENRT_CVG_STRT_DT_CD/ENRT_CVG_STRT_DT_RLand the corresponding end-date columns — control how enrollment coverage start and end dates are calculated.ELIG_APLS_FLAG,PRTN_ELIG_OVRID_ALWD_FLAG,ALWS_UNRSTRCTD_ENRT_FLAG— eligibility application and override controls.MN_CVG_AMT,MX_CVG_ALWD_AMT,MX_CVG_INCR_ALWD_AMT,MX_CVG_MLT_INCR_NUM— minimum and maximum coverage amount and increment constraints.- Twenty-nine
CPP_ATTRIBUTEcolumns plusOBJECT_VERSION_NUMBER,LAST_UPDATE_DATE, and audit columns — the standard DFF and concurrency-control extensions.
Common Use Cases and Queries
Typical uses include auditing which PLIPs are active for a program, driving enrollment interface extracts, and troubleshooting status-related issues surfaced by the "plip_stat_cd" search. A representative query listing active PLIPs with their plans and programs is:
SELECT plip_id, pl_id, pgm_id, plip_stat_cd, enrt_cd, enrt_mthd_cd, effective_start_date, effective_end_date FROM apps.ben_plip WHERE plip_stat_cd = 'A' ORDER BY pgm_id, pl_id;SELECT plip_id, dflt_enrt_cd, enrt_cvg_strt_dt_cd, elig_apls_flag FROM apps.ben_plip WHERE pgm_id = :p_program_id AND SYSDATE BETWEEN effective_start_date AND effective_end_date;- Joining to
BEN_PL_FandBEN_PGM_Fto resolve plan and program names for user-facing reports.
Because the view applies session context from FND_SESSIONS, users should confirm the active session's effective date before interpreting date-tracked results, particularly during enrollment windows.
-
View: BEN_PLIP 12.1.1
- Retrofitted
APPS.BEN_PLIP·↳ BEN_PLIP_F·↳ FND_SESSIONS·Explore BEN module →
-
View: BEN_PLIP_V 12.2.2
- Retrofitted
APPS.BEN_PLIP_V·↳ BEN_PLIP_F·↳ FND_SESSIONS·Explore BEN module →
-
View: BEN_PLIP_V 12.1.1
- Retrofitted
APPS.BEN_PLIP_V·↳ BEN_PLIP_F·↳ FND_SESSIONS·Explore BEN module →
-
Incedence of a plan in a program.
-
View: BEN_PLIP_X 12.2.2
- Retrofitted
-
View: BENBV_PLIP_V 12.1.1
This view identifies and specifies processing characteristics of a plan assigned to a program.
APPS.BENBV_PLIP_V·↳ BEN_PLIP_F·↳ HR_BIS·Explore BEN module →
-
View: BEN_PLIP_X 12.1.1
- Retrofitted
-
View: BEN_PLIP 12.2.2
- Retrofitted
APPS.BEN_PLIP·↳ BEN_PLIP_F·↳ FND_SESSIONS·Explore BEN module →
-
View: BENBV_PLIP_V 12.2.2
This view identifies and specifies processing characteristics of a plan assigned to a program.
APPS.BENBV_PLIP_V·↳ BEN_PLIP_F·↳ HR_BIS·Explore BEN module →
-
Incedence of a plan in a program.
-
VIEW: BEN.BEN_PLIP_F# 12.2.2
-
PACKAGE: APPS.BEN_CPP_SHD 12.1.1
-
PACKAGE: APPS.BEN_CPP_SHD 12.2.2
-
VIEW: BEN.BEN_PLIP_F# 12.2.2
-
VIEW: APPS.BEN_PLIP_X 12.1.1
-
VIEW: APPS.BEN_PLIP_V 12.1.1
-
VIEW: APPS.BEN_PLIP_X 12.2.2
-
VIEW: APPS.BEN_PLIP 12.1.1
-
VIEW: APPS.BEN_PLIP_V 12.2.2
-
VIEW: APPS.BEN_PLIP 12.2.2
-
PACKAGE: APPS.BEN_CPP_INS 12.1.1
-
PACKAGE: APPS.BEN_CPP_UPD 12.1.1
-
PACKAGE: APPS.BEN_CPP_INS 12.2.2
-
PACKAGE: APPS.BEN_CPP_UPD 12.2.2
-
TABLE: BEN.BEN_PLIP_F 12.1.1
-
TABLE: BEN.BEN_PLIP_F 12.2.2
-
VIEW: APPS.BENBV_PLIP_V 12.1.1
-
VIEW: APPS.BENBV_PLIP_V 12.2.2