Search Results hr_h2pi_city_tax_rules




Overview
Explore in AI Chat

Overview

The HR_H2PI_CITY_TAX_RULES table is a staging table within the Oracle E-Business Suite Human Resources (HR) module. Its primary role is to support the HR to Payroll Interface (H2PI), a critical integration point for transferring employee and assignment data from the HRMS system to the Oracle Payroll engine. Specifically, this table temporarily stores data related to US employees' city tax rules during the upload and validation process. It acts as a holding area, ensuring data integrity before the tax rule information is formally processed and applied within the payroll system, which is essential for accurate US payroll tax calculations and compliance.

Key Information Stored

The table's structure is designed to manage the lifecycle of city tax rule data for employees. Its primary key, HR_H2PI_CITY_TAX_RULES_PK, enforces uniqueness on a combination of columns critical for identifying a specific rule record. The key columns include EMP_CITY_TAX_RULE_ID, which uniquely identifies the tax rule record; CLIENT_ID, used for multi-org and data partitioning contexts; BUSINESS_GROUP_ID, which scopes the data to a specific HR business group; and the date-effective columns EFFECTIVE_START_DATE and EFFECTIVE_END_DATE. These date columns are standard in Oracle HRMS and define the period during which the particular city tax rule is active for the employee, allowing for historical tracking and future-dated changes.

Common Use Cases and Queries

The primary use case for this table is during the execution of the H2PI process, where data is extracted from HR, staged in tables like this one, validated, and then transferred to payroll. Common operations involve querying staged data for review or troubleshooting failed interface runs. A typical query might retrieve all pending city tax rules for a specific business group to verify data before submission. For example:

  • SELECT * FROM hr_hr_h2pi_city_tax_rules WHERE business_group_id = &bg_id AND client_id IS NOT NULL;

Reporting use cases are generally focused on interface monitoring and data reconciliation between the HR and Payroll systems, rather than end-user operational reporting, which would typically query the finalized tables in Payroll.

Related Objects

This table is intrinsically linked to the H2PI interface framework. It is part of a family of similarly named staging tables (e.g., HR_H2PI_STATE_TAX_RULES, HR_H2PI_FEDERAL_TAX_RULES) that handle different tax jurisdictions. It is populated by H2PI extraction logic and is referenced by the interface's validation and transfer programs. The finalized, active city tax rules for payroll processing are stored in core Payroll tables, such as PAY_US_CITY_TAX_RULES_F. The table's dependence on the CLIENT_ID and BUSINESS_GROUP_ID columns also ties it to the multi-organization and security structures within Oracle EBS.