Results for “sit_override_amount”

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

Overview

The HR.HR_H2PI_STATE_TAX_RULES table is a Human Resources (PER) product data object within the Oracle E-Business Suite 12.1.1 and 12.2.2 environments. It stores the state-level tax rules and withholding preferences that govern how payroll processing calculates and applies state income tax, state disability insurance, and related statutory deductions for a person or assignment. This table sits at the intersection of HR master data and payroll tax configuration, and it is queried whenever a payroll run must determine the correct withholding treatment for an employee working in a given state jurisdiction.

The mined foreign key structure classifies this object as standalone under the heuristic Data Vault model. From a modeling perspective, this behaves as a downstream dependent object anchored to the person and assignment — effectively a satellite-like record capturing point-in-time tax election state. It is not a hub or link in its own right, since it holds descriptive, date-effective attributes rather than pure identity or relationship keys. This classification is a heuristic suggestion derived from FK structure and should be validated against the actual data model.

Key Information Stored

The table carries 29 documented columns. The most operationally significant are summarized below.

• EMP_STATE_TAX_RULE_ID — the surrogate identifier for each state tax rule row; the column referenced by the user's search term.
• PERSON_ID and ASSIGNMENT_ID — business keys tying the rule to the employee and their assignment.
• STATE_CODE and JURISDICTION_CODE — define the taxing state and the specific tax jurisdiction.
• FILING_STATUS_CODE — the employee's declared filing status for state withholding.
• WITHHOLDING_ALLOWANCES — the number of allowances claimed.
• SIT_OVERRIDE_RATE, SIT_OVERRIDE_AMOUNT, SIT_ADDITIONAL_TAX — optional overrides for state income tax calculation.
• SIT_EXEMPT, SDI_EXEMPT, SUI_EXEMPT, WC_EXEMPT — exemption indicators for state income tax, disability, unemployment, and workers' compensation.
• ADDITIONAL_WA_AMOUNT, REMAINDER_PERCENT, SECONDARY_WA — withholding allowance configuration, including split remainder handling.
• SUI_WAGE_BASE_OVERRIDE_AMOUNT, SUPP_TAX_OVERRIDE_RATE — supplementary wage and tax overrides.
• EFFECTIVE_START_DATE and EFFECTIVE_END_DATE — date-effective validity window.
• STATUS and OBJECT_VERSION_NUMBER — row state and optimistic locking.

The primary key HR_H2PI_STATE_TAX_RULES_PK is composed of BUSINESS_GROUP_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, EMP_STATE_TAX_RULE_ID, and CLIENT_ID. This composite structure confirms that EMP_STATE_TAX_RULE_ID is a surrogate component rather than a standalone unique business key; uniqueness is enforced only in combination with the multi-tenant and date-effective columns.

Common Use Cases and Queries

The table is primarily consumed during payroll tax calculation, tax reconciliation reporting, and employee self-service updates to withholding elections. A typical effective-dated lookup retrieves the active rule for a person as of a payroll period:

• SELECT emp_state_tax_rule_id, state_code, filing_status_code, withholding_allowances FROM hr.hr_h2pi_state_tax_rules WHERE person_id = :p_person_id AND TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date AND business_group_id = :p_bg_id;
• Reporting on exemption counts by state: grouping by STATE_CODE and counting rows where SIT_EXEMPT = 'Y'.
• Auditing override usage by filtering rows where SIT_OVERRIDE_RATE or SIT_OVERRIDE_AMOUNT is non-null.

Related Objects

• PER_ALL_PEOPLE_F — joined on PERSON_ID to resolve the employee identity.
• PER_ALL_ASSIGNMENTS_F — joined on ASSIGNMENT_ID for assignment context.
• HR_ORGANIZATION_UNITS / HR_ALL_ORGANIZATION_UNITS — via BUSINESS_GROUP_ID for the legal entity.
• PAY_STATE_TAX_RULES and PAY_TAX_RULES — tax rule definitions that drive calculation logic.
• PAY_STATE_TAX_RULE_DTLS — jurisdiction-level detail that complements the withholding election.
• HR_H2PI_STATE_TAX_RULES_PK — the primary key constraint enforcing row uniqueness.