Search Results hi_organization_id




Overview
Explore in AI Chat

Overview

PAY_JP_PRE_TAX_OLD is a temporary staging table within the Oracle E-Business Suite Payroll (PAY) module, owned by the HR schema. As documented in the ETRM metadata, this table serves as a temporary repository for Japanese legislative reports. It is not an operational payroll calculation table but rather a transient holding area populated during the execution of Japanese statutory reporting processes, such as withholding tax statements, social insurance filings, and employment insurance declarations required by Japanese regulatory authorities.

From a Data Vault modeling perspective, the metadata suggests this object is best classified as standalone; the heuristic FK analysis identifies no inbound or outbound satellite or link dependencies beyond a single reference to PAY_ASSIGNMENT_ACTIONS. In practice, therefore, PAY_JP_PRE_TAX_OLD behaves like a satellite-like staging entity rather than a true hub or link. Because the data is temporary and regenerated for each reporting run, the table should not be treated as a system of record; it is a working artifact whose lifespan is bounded by the concurrent program or report that populates it.

Key Information Stored

The table contains 44 documented columns. The most significant are summarized below.

Common Use Cases and Queries

The primary use case is generating Japanese statutory legislative reports. A typical query retrieves all staged tax lines for a payroll action run:

  • Joining staging rows to payroll actions: SELECT p.pre_tax_id, p.assignment_action_id, p.taxable_sal_amt, p.itax FROM hr.pay_jp_pre_tax_old p, pay_assignment_actions paa WHERE p.assignment_action_id = paa.assignment_action_id
  • Filtering by income tax organization and category to reconcile withholding tax by legal entity.
  • Summarizing employee versus employer social insurance premiums (HI_PREM_EE, HI_PREM_ER, WP_PREM_EE, WP_PREM_ER) for monthly remittance reporting.
  • Reconciling prior-period figures using PREVIOUS_TAXABLE_AMT and PREVIOUS_ITAX before final submission.
  • Diagnostic queries by ASSIGNMENT_ACTION_ID to determine whether a specific action was staged successfully, given the U1 unique index on that column.

Related Objects

Because the table is largely standalone, the object dependency set is narrow. The most significant related objects are:

  • PAY_ASSIGNMENT_ACTIONS — Referenced by the ASSIGNMENT_ACTION_ID foreign key; the parent table linking staged rows to payroll processing runs.
  • PAY_JP_PRE_TAX — The presumed non-_OLD counterpart that is populated as the adjacent staging table in the same reporting cycle; typically compared with this table when diagnosing versioned or prior-run data.
  • PAY_ACTION_INFORMATION — Provides ACTION_ID context for the staged action.
  • PAY_PAYROLL_ACTIONS — Parent of assignment actions; used to filter staging data by payroll run.
  • HR_ORGANIZATION_UNITS — Suppliers of the various HI_/WP_/UI_/ITAX_ ORG ANIZATION_ID values used in statutory filings.
  • PAY_PERSON_PROCESSING — Links assignment actions to persons for employee-level reporting.

Oracle Proprietary, Confidential Information — Legal Notices apply to the underlying object and this summary.