Results for “proration_rule”

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

Overview

PAY_US_GARN_EXEMPTION_RULES_X is a date-effective (XF) view owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. Its purpose is to expose only those rows of the underlying garnishment exemption rules table that are currently in force, defined as records where the effective date range of the rule intersects the current system date. The view is part of the PAY (Payroll) product family and belongs to the Oracle Payroll legislative data infrastructure that supports United States garnishment processing, including the calculation of disposable earnings, statutory exemptions, and withholding limits for court-ordered deductions.

By encapsulating the effective-dating predicate, the view provides a stable, date-aware interface for forms, concurrent processes, reports, and integration points that need to evaluate the rules governing how much of an employee's pay is protected from garnishment. It also serves as a reporting layer, allowing payroll administrators and developers to query currently active exemption rules without constructing effective-date logic manually.

Underlying Base Objects

The single documented base object for this view is the table PAY_US_GARN_EXEMPTION_RULES_F, which resides in the APPS schema and is referenced through a synonym. The source view text joins or selects from this table with the date predicate:

• WHERE TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

The "_F" suffix indicates the base (full) table that stores all dated rows, including historical and future records. The "_X" view applies the effective date restriction, so it excludes rules that have already expired and rules that have not yet taken effect. The view inherits all business columns from the base table and adds no computed columns; it is purely a filtered projection. Because the predicate uses TRUNC(SYSDATE), the view reflects the current effective date at query time and is not row-level secured by employee or assignment.

Key Columns

The columns exposed by the view map directly to the base table. Notable columns include:

• EXEMPTION_RULE_ID — primary key identifying the rule.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — the date range within which the rule is valid; used by the view's predicate.
• GARN_CATEGORY and STATE_CODE — define the garnishment category (for example, child support, creditor debt, tax levy) and the U.S. state whose exemption rules apply. Rules are typically jurisdiction-specific.
• CALC_RULE and DEPENDENTS_CALC_RULE — determine the calculation method used to derive the exemption, such as a flat amount, a percentage of disposable earnings, or a dependents-based formula.
• DI_PCT, DI_PCT_DEPENDENTS, DI_PCT_IN_ARREARS, DI_PCT_DEPENDENTS_IN_ARREARS — percentage thresholds applied to disposable income, differentiated by whether dependents are claimed and whether the garnishment is in arrears.
• AMOUNT_VALUE, ADDL_DEP_AMOUNT_VALUE, DEPENDENT_AMOUNT_VALUE — monetary values forming part of the exemption computation.
• EXEMPTION_BALANCE, EXEMPTION_BALANCE_MAX_PCT, EXEMPTION_BALANCE_MIN_PCT — control the protected balance and its percentage bounds.
• MARITAL_STATUS — marital status qualifying condition for the rule.
• MIN_WAGE_FACTOR — factor applied against minimum wage to establish a protected floor.
• PRORATION_RULE — governs how the exemption is prorated, typically across pay periods or when partial-period processing occurs. This is the column most relevant to the search term "proration_rule".
• CREATOR_TYPE — indicates the originator of the rule record.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE.

Common Use Cases and Queries

The view is commonly used to retrieve active exemption rules for a given state and garnishment category, to audit which proration rule applies, and to drive garnishment calculation logic. A typical query is:

• SELECT GARN_CATEGORY, STATE_CODE, PRORATION_RULE, DI_PCT, TERRITORY_CODE FROM PAY_US_GARN_EXEMPTION_RULES_X WHERE STATE_CODE = 'CA' ORDER BY GARN_CATEGORY;

• SELECT EXEMPTION_RULE_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, PRORATION_RULE FROM PAY_US_GARN_EXEMPTION_RULES_X WHERE GARN_CATEGORY = 'CHILD_SUPPORT';

Because only currently effective rows are returned, no additional date filtering is required by the caller. When historical or future-dated rules must be examined, the base table PAY_US_GARN_EXEMPTION_RULES_F should be queried instead. The view is read-only and should not be used for direct DML; rule maintenance is performed through the Payroll legislative data forms.