Results for “pay_us_emp_county_tax_rules_f”

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

Overview

The PAY_US_EMP_COUNTY_TAX_RULES_F table, owned by the HR schema and delivered under the PAY (Payroll) product family, stores county-level tax details for employee assignments within Oracle EBS 12.1.1 and 12.2.2. It is a core configuration and transactional data object in US Payroll, capturing the withholding rules, exemptions, and jurisdiction-specific parameters that govern how county, school district, and local taxes are calculated for each employee. Each row links an employee's assignment to a specific state and county, allowing the payroll engine to apply the correct tax treatment at the county level during the payroll run.

From a modeling perspective, the metadata's heuristic Data Vault classification is link. This suggestion reflects the table's role as an associative structure that resolves relationships between employee assignments, state jurisdictions, and county jurisdictions, rather than a pure reference hub or descriptive satellite. The classification should be treated as a heuristic observation rather than a normative design directive.

Key Information Stored

The primary key, PAY_US_EMP_COUNTY_TAX_RULE_PK, is a composite surrogate key spanning EMP_COUNTY_TAX_RULE_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE. This date-effective structure enables datetracked history, so rule changes across payroll periods are preserved rather than overwritten. The same three columns also form the documented unique index PAY_US_EMP_COUNTY_TAX_RULE_PK, which serves as the business-key candidate.

The most significant columns include:

• ASSIGNMENT_ID — the employee assignment to which the county tax rules apply.
• STATE_CODE and COUNTY_CODE — the jurisdiction identifiers that drive which local tax rules are invoked.
• BUSINESS_GROUP_ID — the legislative or business group context, typically constrained to the enterprise's organization unit.
• JURISDICTION_CODE — the specific tax jurisdiction used by the payroll calculation engine.
• FILING_STATUS_CODE and WITHHOLDING_ALLOWANCES — employee-level withholding parameters.
• LIT_ADDITIONAL_TAX, LIT_OVERRIDE_AMOUNT, LIT_OVERRIDE_RATE — local income tax overrides and additional amounts.
• LIT_EXEMPT, SD_EXEMPT, HT_EXEMPT, WAGE_EXEMPT — exemption flags for local income tax, school district, and other components.
• SCHOOL_DISTRICT_CODE — school district designation for applicable jurisdictions.
• ADDITIONAL_WA_RATE — an additional rate parameter used in rate computation.
• Standard audit and extensibility columns (LAST_UPDATE_DATE, CREATED_BY, OBJECT_VERSION_NUMBER, and the ATTRIBUTE and CNT_INFORMATION descriptive flexfield segments).

Common Use Cases and Queries

This table is queried during payroll preprocessing and by reporting tools that validate county tax setups. A common pattern retrieves the currently effective rules for an assignment:

• Filter by ASSIGNMENT_ID and constrain EFFECTIVE_START_DATE and EFFECTIVE_END_DATE around the SYSDATE or payroll period date to obtain the active row.
• Join to PAY_US_COUNTIES on STATE_CODE and COUNTY_CODE to resolve county descriptive names for output.
• Join to PAY_US_STATES on STATE_CODE for state-level validation.
• Aggregate exemption and override flags per BUSINESS_GROUP_ID to audit consistency across a legislative group.

Typical reporting uses include reconciliation of withholding exemptions, exception reports for missing effective-dated rules, and audit extracts of override amounts and rates for compliance review.

Related Objects

The documented foreign keys identify the principal related objects:

• PAY_US_STATES — referenced through STATE_CODE.
• PAY_US_COUNTIES — referenced through the composite STATE_CODE and COUNTY_CODE.
• HR_ALL_ORGANIZATION_UNITS — referenced through BUSINESS_GROUP_ID.

Beyond the documented constraints, this table is closely associated with assignment and payroll process tables such as PAY_ASSIGNMENT_ACTIONS, PER_ALL_ASSIGNMENTS_F, and the payroll run result tables, which consume the county rules during calculation. Payroll balance and run results objects depend on the rules established here to produce accurate local tax withholding when the payroll process is executed.