Results for “pay_net_calculation_rules”

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

Overview

The PAY_NET_CALCULATION_RULES table, owned by the HR schema and delivered under the PAY (Payroll) product, defines the element entry values that contribute to the net value of Paid Time Off (PTO). In Oracle EBS 12.1.1 and 12.2.2, it acts as the configuration bridge between accrual plans, absence attendance types, and the payroll input values that feed net absence calculations. A rule row determines, for a given accrual plan and absence attendance type within a business group, which input value (or date-based input value) participates in the net calculation and whether that value is added or subtracted. It is consulted during absence and payroll processing to resolve the monetary or unit effect of a PTO entry.

From a dimensional modeling perspective, the metadata classifies this table heuristically as a link. This is consistent with its structure: the surrogate primary key NET_CALCULATION_RULE_ID anchors each row while foreign keys to accrual plans, absence attendance types, and business groups express the relationships that define the rule. The link classification should be treated as a modeling suggestion rather than an architectural mandate.

Key Information Stored

The table carries 14 documented columns. The most significant are:

• NET_CALCULATION_RULE_ID — surrogate primary key, unique via PAY_NET_CALCULATION_RULES_PK; no natural business key is documented.
• ACCRUAL_PLAN_ID — foreign key to PAY_ACCRUAL_PLANS, identifying the accrual plan the rule applies to.
• ABSENCE_ATTENDANCE_TYPE_ID — foreign key to PER_ABSENCE_ATTENDANCE_TYPES, linking the rule to the relevant absence type.
• BUSINESS_GROUP_ID — foreign key to HR_ALL_ORGANIZATION_UNITS, scoping the rule to a business group (legislative context).
• INPUT_VALUE_ID — identifies the element input value contributing to the net calculation.
• DATE_INPUT_VALUE_ID — identifies a date-based input value that also participates in the calculation.
• ADD_OR_SUBTRACT — flag indicating whether the input value adds to or subtracts from the net value of Paid Time Off.
• USE_ELEMENT_LINK — controls whether an element link is applied when evaluating the rule.
• Standard audit columns: OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE.

Common Use Cases and Queries

Typical scenarios include auditing which input values affect PTO net calculations, validating accrual plan configuration, and reporting rules by absence type or business group. A representative query joins the rule to its related plan and absence type:

• List all rules for a business group: SELECT net_calculation_rule_id, accrual_plan_id, input_value_id, add_or_subtract FROM pay_net_calculation_rules WHERE business_group_id = :bg_id;
• Join to plans and types: SELECT r.net_calculation_rule_id, p.accrual_plan_id, a.absence_attendance_type_id FROM pay_net_calculation_rules r, pay_accrual_plans p, per_absence_attendance_types a WHERE r.accrual_plan_id = p.accrual_plan_id AND r.absence_attendance_type_id = a.absence_attendance_type_id;
• Detect add/subtract distribution: SELECT add_or_subtract, COUNT(*) FROM pay_net_calculation_rules GROUP BY add_or_subtract;

These queries support configuration review, data migration validation (for example, when moving between 12.1.1 and 12.2.2), and reconciliation of accrual-to-payroll flows.

Related Objects

The documented foreign keys tie this table to:

• PAY_ACCRUAL_PLANS — joined via ACCRUAL_PLAN_ID.
• HR_ALL_ORGANIZATION_UNITS — joined via BUSINESS_GROUP_ID.
• PER_ABSENCE_ATTENDANCE_TYPES — joined via ABSENCE_ATTENDANCE_TYPE_ID.

Beyond these, the table is functionally associated with payroll element and input value definitions (PAY_INPUT_VALUES_F) referenced by INPUT_VALUE_ID and DATE_INPUT_VALUE_ID, and with absence processing logic that consumes its rules. Where the metadata is limited, these supplementary associations should be confirmed against the specific 12.1.1 or 12.2.2 schema in use.