Results for “abs_overlap_rule”
8 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The PQP_OSP_TEMPLATE_V view resides in the APPS schema and belongs to the PQP – Public Sector Payroll product family. It exposes all absence information elements generated through the Oracle Standard Payroll (OSP) element template. When the OSP template is applied during element creation, Oracle Payroll creates a standardized set of absence-related elements (sickness, holidays, absence entitlements, and associated plans). This view consolidates those elements and their configuration attributes into a single denormalized result set, joining the core element type definition to its extra information rows and lookup descriptions.
For reporting and integration purposes the view acts as a catalog of absence information elements per business group and legislation. Because absence category, plan, schedule, and daily rate behavior are surfaced as discrete columns, the view is frequently used by absence administrators, payroll analysts, and interfaces that need to enumerate or validate the absence element configuration without navigating the underlying extra-information flexfield segments.
Underlying Base Objects
The view is defined over the following documented base objects, all resolved through APPS synonyms or packages:
- PAY_ELEMENT_TYPES_F – supplies element type identity, business group, legislation, classification, processing type/priority, names, description, and audit columns.
- PAY_ELEMENT_CLASSIFICATIONS – provides
CLASSIFICATION_NAME. - PAY_ELEMENT_TEMPLATES – supplies
BASE_NAME. - PAY_ELEMENT_TYPE_EXTRA_INFO – the source of the
EEI_INFORMATIONnsegments mapped into named columns such asPLAN_ID,ABS_DAYS, andABS_OVERLAP_RULE. - BEN_PL_F / BEN_PL_TYP_F – resolve plan name and plan type for the absence plan referenced by
PLAN_ID. - PAY_USER_TABLES – joined twice to translate the sickness-leave and holiday UDT IDs into user table names.
- HR_LOOKUPS – provides
MEANINGfor the pay information source component lookup. - FND_DATE – converts canonical extra-information date strings to real dates for
SCH_CAL_START_DATEandSCH_CAL_END_DATE. - FND_NUMBER, FND_SESSIONS, HR_API, PAY_TEMPLATE_CORE_OBJECTS – supporting packages and context objects referenced by the view definition.
Key Columns
ELEMENT_TYPE_ID,ELEMENT_NAME,REPORTING_NAME,BASE_NAME– element identity.BUSINESS_GROUP_ID,LEGISLATION_CODE,CLASSIFICATION_NAME– organizational and statutory context.PLAN_ID,PLAN_NAME,PLAN_DESCRIPTION– the absence plan tied to the element.SCH_CAL_TYPE,SCH_CAL_DURATION,SCH_CAL_UOM,SCH_CAL_START_DATE,SCH_CAL_END_DATE– schedule calendar definition.ABS_DAYS,ABS_ENT_SICK_LEAVES,ABS_ENT_HOLIDAYS– absence days and entitlement user tables.ABS_DAILYRATE_CALCand its period/duration – daily rate derivation rules.ABS_PAY_INFO_SRC_COMP,ABS_PAY_INFO_SRC_COMP_NAME– source component for pay information.ABSENCE_CATEGORY– decoded viaDECODE(UPPER(EEI_INFORMATION30),'S','SICKNESS', INITCAP(...)), exposing categories such as Sickness.ABS_OVERLAP_RULE,PRIMARY_ABS_INFO_ELE_FLAG,ABS_DEFAULT_WORKPATTERN,ABS_TYPES_LIST_NAME,ENTITLEMENT_PRORATION– absence behavioral settings.
Common Use Cases and Queries
A frequent requirement is locating all absence elements for a given category, which aligns directly with the search term absence_category:
- Listing absence elements by category and business group.
- Auditing plan and schedule configuration for OSP-generated elements.
- Driving downstream interfaces that must map element names to plans.
Sample query:
SELECT element_name, base_name, plan_name, schedule_cal_type, absence_category
FROM apps.pqp_osp_template_v
WHERE business_group_id = :p_bg_id
AND UPPER(absence_category) = 'SICKNESS';
Because the view already decodes extra-information segments into meaningful names, no additional flexfield navigation is required.
-
View: PQP_OSP_TEMPLATE_V 12.1.1
View of all absence information elements created by the OSP element template.
APPS.PQP_OSP_TEMPLATE_V·↳ BEN_PL_F·↳ BEN_PL_TYP_F·↳ FND_DATE·Explore PQP module →
-
View: PQP_OSP_TEMPLATE_V 12.2.2
View of all absence information elements created by the OSP element template.
APPS.PQP_OSP_TEMPLATE_V·↳ BEN_PL_F·↳ BEN_PL_TYP_F·↳ FND_DATE·Explore PQP module →
-
eTRM - PQP Tables and Views 12.2.2
Entity used to store the information types for Vehicle Repository Extra information.
-
eTRM - PQP Tables and Views 12.1.1
Entity used to store the information types for Vehicle Repository Extra information.