Results for “sch_cal_start_date”

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:

Key Columns

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.