Results for “period_weekly_std_rate_cut_off”

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

Overview

APPS.PAY_IE_SOE_PAYE_DETAILS_V is a reporting view in Oracle EBS Payroll (Oracle HRMS / Irish Payroll legislation) that exposes the PAYE (Pay As You Earn) tax parameters captured for an Irish employee as part of a payroll run. The view is part of the Irish Statement of Earnings (SOE) / Revenue Commissioner reporting infrastructure and is most relevant in releases 12.1.1 and 12.2.2. Its purpose is to consolidate, per assignment action (i.e., per payroll run processed for an assignment), the various input values that describe the employee's PAYE calculation basis — weekly and monthly tax credits, standard rate cutoffs, tax basis, information source, assessment basis, and certificate issue date — into a single normalized row set.

A key characteristic of this view is its use of NVL logic to reconcile period-based and standard tax credit values. The columns PERIOD_WEEKLY_TAX_CREDIT and WEEKLY_TAX_CREDIT are merged via NVL(period_weekly_tax_credit, weekly_tax_credit), so a caller searching for period_weekly_tax_credit receives a single, coalesced weekly tax credit value regardless of which payroll element input actually carried the data. This design supports both weekly and monthly paid employees under one view.

Underlying Base Objects

The view is defined over the following documented base objects:

• FND_SESSIONS (SYNONYM) — Oracle Application Object Library session context; drives the driving-table hint INDEX(SES FND_SESSIONS_U1) in the defining query.
• PAY_ELEMENT_TYPES_F (SYNONYM) — Element type definitions, filtered on element_name = 'IE PAYE details'.
• PAY_RUN_RESULTS (SYNONYM) — Payroll run result rows keyed by assignment_action_id and element_type_id.
• PAY_INPUT_VALUES_F (SYNONYM) — Defines the named inputs (e.g., 'Weekly Tax Credit', 'Monthly Tax Credit') whose values are pivoted.
• PAY_RUN_RESULT_VALUES (SYNONYM) — The actual input values, retrieved via prrv.result_value.
• HR_GENERAL (PACKAGE) — Supplies the decode_lookup calls used to resolve internal codes into display values for tax basis, info source, and assessment basis.

The defining SQL joins these objects and applies MAX(DECODE(...)) aggregations to pivot rows into named columns, grouped by assignment_action_id, using USE_NL and index hints for performance.

Key Columns

• ASSIGNMENT_ACTION_ID — The payroll action identifier linking to a specific run processed for an assignment; the grouping key.
• WEEKLY_TAX_CREDIT — Coalesced weekly tax credit (NVL(PERIOD_WEEKLY_TAX_CREDIT, WEEKLY_TAX_CREDIT)).
• WEEKLY_STD_RATE_CUT_OFF — Coalesced weekly standard rate cutoff.
• MONTHLY_TAX_CREDIT / MONTHLY_STD_RATE_CUT_OFF — Monthly equivalents for monthly-paid employees.
• D_TAX_BASIS, D_INFO_SOURCE, D_TAX_ASSESS_BASIS — Decoded (display) values from lookups IE_PAYE_TAX_BASIS, IE_PAYE_INFO_SOURCE, and IE_PAYE_ASSESS_BASIS, truncated to 80 characters.
• CERTIFICATE_ISSUE_DATE — The date on the employee's Revenue tax credit certificate.

Common Use Cases and Queries

This view is typically consumed by Irish PAYE reporting, SOE extracts, and reconciliation of tax credits against the Revenue certificate.

SELECT assignment_action_id,
       weekly_tax_credit,
       weekly_std_rate_cut_off,
       monthly_tax_credit,
       d_tax_basis,
       certificate_issue_date
FROM   apps.pay_ie_soe_paye_details_v
WHERE  assignment_action_id = :p_assignment_action_id;

Because the view exposes the coalesced weekly tax credit, it is also used to validate that period and standard inputs agree, or to feed downstream SOE letter generation where a single weekly tax credit figure is required.