Results for “information_category”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The PAY_VIEW_ACCRUAL_PLANS_V view, owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2, is a user-interface support view within the Payroll (PAY) product module. Its documented status is VALID and it is described in Oracle's ETRM metadata simply as "Used to support user interface." In practice this view denormalizes the accrual plan configuration and its associated payroll element constructs — accrual plan header, payroll, assignment, element entry, element type, element link, and input value — into a single queryable result set. It is not intended as an end-user reporting object but rather as a presentation-layer dependency for accrual plan forms and related PTO (paid time off) pages. Because the view flattens several effective-dated _F tables, it is frequently referenced when developers or analysts need to reconcile an assignment to its accrual plan element entry, its element link, and the input value that drives the accrual.
Underlying Base Objects
The view joins objects across HR and PAY schemas exposed via APPS synonyms. The documented referenced objects include HR_LOOKUPS (VIEW), PAY_ACCRUAL_PLANS and PAY_ACCRUAL_PLANS_TL (SYNONYMS), PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_LINKS_F, PAY_ELEMENT_TYPES_F, PAY_INPUT_VALUES_F, PAY_NET_CALCULATION_RULES, and PER_ALL_ASSIGNMENTS_F (all SYNONYMS). HR_API (PACKAGE) is also listed as a referenced base object, reflecting the forms/API dependency behind the accrual plan definition.
The defining SQL joins:
- PAY_ACCRUAL_PLANS (aliased PAP) as the driving table, supplying accrual plan identity, name, category, units of measure, business group, and the element type / input value foreign keys.
- HR_LOOKUPS (HRL, HRL1) to translate ACCRUAL_CATEGORY via lookup type 'US_PTO_ACCRUAL' and ACCRUAL_UNITS_OF_MEASURE via lookup type 'HOURS_OR_DAYS' into meaningful descriptions.
- PER_ALL_ASSIGNMENTS_F (ASS), PAY_ELEMENT_ENTRIES_F (PEE), PAY_ELEMENT_LINKS_F (PEL), PAY_ELEMENT_TYPES_F (PET), and PAY_INPUT_VALUES_F (PIV), chained through assignment ID, element link ID, element type ID, and input value ID.
Key Columns
- ACCRUAL_PLAN_ID / ACCRUAL_PLAN_NAME — the plan identity from PAY_ACCRUAL_PLANS.
- ACCRUAL_CATEGORY / ACCRUAL_CATEGORY_NAME — the coded value and its decoded meaning.
- ACCRUAL_UNITS_OF_MEASURE / ACCRUAL_UNITS_OF_MEASURE_NAME — coded value plus HOURS_OR_DAYS meaning.
- PAYROLL_ID, BUSINESS_GROUP_ID — payroll and business group context (BUSINESS_GROUP_ID is coerced with + 0).
- ASSIGNMENT_ID, ELEMENT_ENTRY_ID, PERSON_ID — the assignment, its accrual element entry, and person.
- ABSENCE_ELEMENT_TYPE_ID — the accrual plan's associated element type.
- ASG_EFFECTIVE_START_DATE / ASG_EFFECTIVE_END_DATE — the assignment-level effective dates; this is the column users typically search for as "asg_effective_start_date."
- IV_EFFECTIVE_START_DATE / IV_EFFECTIVE_END_DATE — input value effective dates.
- E_ENTRY_EFFECTIVE_START_DATE / E_ENTRY_EFFECTIVE_END_DATE — element entry effective dates.
- E_TYPE_EFFECTIVE_START_DATE / E_TYPE_EFFECTIVE_END_DATE — element type effective dates.
- E_LINK_EFFECTIVE_START_DATE / E_LINK_EFFECTIVE_END_DATE — element link effective dates.
The multiple date pairs are the dominant feature of this view: each _F table contributes its own date-tracked effectivity, and date-overlap logic must be supplied by the calling query.
Common Use Cases and Queries
Typical scenarios include: identifying the accrual plan element entry for a given assignment as of a date; reconciling element link, element type, and input value effectivity; and feeding user-interface regions for accrual plan administration.
To retrieve the assignment effective start date for a person's accrual plans:
SELECT accrual_plan_name,
assignment_id,
asg_effective_start_date,
asg_effective_end_date,
e_entry_effective_start_date
FROM apps.pay_view_accrual_plans_v
WHERE person_id = :p_person_id
AND TRUNC(:p_effective_date) BETWEEN asg_effective_start_date
AND asg_effective_end_date;
To list accrual plans and their decoded categories for a business group:
SELECT DISTINCT accrual_plan_id, accrual_plan_name,
accrual_category_name, accrual_units_of_measure_name
FROM apps.pay_view_accrual_plans_v
WHERE business_group_id = :p_business_group_id;
Because the view joins several effective-dated tables without date predicates of its own, queries must always constrain the relevant effective date columns to avoid multiplication of rows across effectivity ranges. Joins back to PAY_ELEMENT_ENTRIES_F on ELEMENT_ENTRY_ID, or to PER_ALL_ASSIGNMENTS_F on ASSIGNMENT_ID, should also be date-bounded to preserve the intended result set.
-
Used to support user interface
APPS.PAY_VIEW_ACCRUAL_PLANS_V·↳ HR_API·↳ HR_LOOKUPS·↳ PAY_ACCRUAL_PLANS·Explore PAY module →
-
Used to support user interface
APPS.PAY_VIEW_ACCRUAL_PLANS_V·↳ FND_GLOBAL·↳ HR_API·↳ HR_LOOKUPS·Explore PAY module →
-
Date-effective view.
APPS.PER_SPINAL_POINT_PLACEMENTS_X·↳ PER_SPINAL_POINT_PLACEMENTS_F·Explore PER module →
-
View: PER_SHARED_TYPES_VL 12.1.1
Used to support user-interface.
APPS.PER_SHARED_TYPES_VL·↳ PER_SHARED_TYPES·↳ PER_SHARED_TYPES_TL·Explore PER module →
-
Date-effective view.
APPS.PER_SPINAL_POINT_PLACEMENTS_X·↳ PER_SPINAL_POINT_PLACEMENTS_F·Explore PER module →
-
Used to support user interface
APPS.PER_SPINAL_PT_PLACEMENTS_V·↳ FND_SESSIONS·↳ PER_SPINAL_POINT_PLACEMENTS_F·Explore PER module →
-
Date-effective view.
APPS.PER_SPINAL_POINT_PLACEMENTS·↳ FND_SESSIONS·↳ PER_SPINAL_POINT_PLACEMENTS_F·Explore PER module →
-
Holds 'type' and 'status' information.
-
Configurable properties for configurable forms modules
-
APPS.PQH_POSITION_EXTRA_INFO_V·↳ PER_POSITION_EXTRA_INFO·Explore PQH module →
-
Properties of windows for configurable forms
-
List of progression points in a pay scale.
-
Canvas properties for configurable forms
-
Canvas properties for configurable forms
-
View: HR_TEMPLATE_TAB_PAGES 12.2.2
View of template tab page definitions and translated properties
APPS.HR_TEMPLATE_TAB_PAGES·↳ HR_TAB_PAGE_PROPERTIES_VL·↳ HR_TEMPLATE_TAB_PAGES_B·Explore PER module →
-
View: HR_POSITIONS_X 12.1.1
Date-effective view based on secured positions view.
APPS.HR_POSITIONS_X·↳ FND_PROFILE·↳ HR_GENERAL·↳ HR_POSITIONS_F·Explore PER module →
-
View: HR_POSITIONS 12.1.1
Date-effective view based on secured positions view.
APPS.HR_POSITIONS·↳ FND_PROFILE·↳ FND_SESSIONS·↳ HR_GENERAL·Explore PER module →
-
Properties of windows for configurable forms
-
Properties of tab pages for configurable forms
-
Criteria and Change list for mass process functionality is stored
-
Criteria and Change list for mass process functionality is stored
-
Log table
-
List of progression points in a pay scale.
-
View: PER_PERIODS_OF_WORK_V 12.2.2
Combined view of periods of service and periods of placement
APPS.PER_PERIODS_OF_WORK_V·↳ HR_GENERAL·↳ PER_PERIODS_OF_PLACEMENT·↳ PER_PERIODS_OF_SERVICE·Explore PER module →
-
View: PER_PERIODS_OF_WORK_V 12.1.1
Combined view of periods of service and periods of placement
APPS.PER_PERIODS_OF_WORK_V·↳ HR_GENERAL·↳ PER_PERIODS_OF_PLACEMENT·↳ PER_PERIODS_OF_SERVICE·Explore PER module →
-
View: HR_POSITIONS_X 12.2.2
Date-effective view based on secured positions view.
APPS.HR_POSITIONS_X·↳ FND_PROFILE·↳ HR_GENERAL·↳ HR_POSITIONS_F·Explore PER module →
-
Translated view of HR_WINDOW_PROPERTIES_B and HR_WINDOW_PROPERTIES_TL
APPS.HR_WINDOW_PROPERTIES_VL·↳ HR_WINDOW_PROPERTIES_B·↳ HR_WINDOW_PROPERTIES_TL·Explore PER module →
-
Grade steps defined in a specific grade scale and their incremental order.
-
View: HR_FORM_TAB_PAGES 12.1.1
View of tab page definitions and translated properties
APPS.HR_FORM_TAB_PAGES·↳ HR_FORM_TAB_PAGES_B·↳ HR_FORM_TAB_PAGES_VL·↳ HR_TAB_PAGE_PROPERTIES_VL·Explore PER module →
-
View: HR_TEMPLATE_CANVASES 12.2.2
View of template canvas definitions and translated properties
APPS.HR_TEMPLATE_CANVASES·↳ HR_CANVAS_PROPERTIES·↳ HR_TEMPLATE_CANVASES_B·Explore PER module →
-
View: HR_TEMPLATE_WINDOWS 12.2.2
View of template window definition and translated properties
APPS.HR_TEMPLATE_WINDOWS·↳ HR_TEMPLATE_WINDOWS_B·↳ HR_WINDOW_PROPERTIES_VL·Explore PER module →
-
Date-effective view.
APPS.PER_SPINAL_POINT_STEPS_X·↳ PER_SPINAL_POINT_STEPS_F·Explore PER module →
-
Date-effective view.
APPS.PER_SPINAL_POINT_STEPS_X·↳ PER_SPINAL_POINT_STEPS_F·Explore PER module →
-
View: HR_ALL_POSITIONS 12.2.2
Date-effective view.
APPS.HR_ALL_POSITIONS·↳ FND_SESSIONS·↳ HR_ALL_POSITIONS_F·↳ HR_GENERAL·Explore PER module →
-
View: HR_FORM_WINDOWS 12.2.2
View of window defintions and translated properties
APPS.HR_FORM_WINDOWS·↳ HR_FORM_WINDOWS_B·↳ HR_FORM_WINDOWS_VL·↳ HR_WINDOW_PROPERTIES_VL·Explore PER module →
-
View: HR_FORM_WINDOWS 12.1.1
View of window defintions and translated properties
APPS.HR_FORM_WINDOWS·↳ HR_FORM_WINDOWS_B·↳ HR_FORM_WINDOWS_VL·↳ HR_WINDOW_PROPERTIES_VL·Explore PER module →
-
View: HR_FORM_TAB_PAGES 12.2.2
View of tab page definitions and translated properties
APPS.HR_FORM_TAB_PAGES·↳ HR_FORM_TAB_PAGES_B·↳ HR_FORM_TAB_PAGES_VL·↳ HR_TAB_PAGE_PROPERTIES_VL·Explore PER module →
-
View: HR_FORM_CANVASES 12.2.2
View of canvas definition and translated properties
APPS.HR_FORM_CANVASES·↳ HR_CANVAS_PROPERTIES·↳ HR_FORM_CANVASES_B·↳ HR_FORM_CANVASES_VL·Explore PER module →
-
Competence outcomes
-
The outcomes achieved towards a given Competency .
-
Used to support user interface
APPS.PER_SPINAL_PT_PLACEMENTS_V·↳ FND_SESSIONS·↳ PER_SPINAL_POINT_PLACEMENTS_F·Explore PER module →
-
Definitions of specific salary bases.
-
Details of assignment placements to a grade step and point.
-
Allocated Checklists
-
Kiosk workflow data rows
-
Grade definitions for a business group.
-
Used to support user interface
APPS.PER_COMPETENCE_ELEMENTS_V2·↳ FND_GLOBAL·↳ HR_API·↳ HR_GENERAL·Explore PER module →
-
View: PER_GRADES_VL 12.1.1
APPS.PER_GRADES_VL·↳ PER_GRADES·↳ PER_GRADES_TL·Explore PER module →
-
Used to support Mass Assignment Update UI
APPS.PER_MASS_UPDATE_ASSIGNMENT_V·↳ FND_DATE·↳ PQH_COPY_ENTITY_RESULTS·Explore PER module →