Search Results pay_za_tys_processes_uk1

Overview

HR.PAY_ZA_TYS_PROCESSES is a control and audit table within the Oracle E-Business Suite Payroll module, specific to the South African (ZA) localization. The table stores information about each Tax Year Start (TYS) process that has been executed, recording the combination of payroll, consolidation set, and tax year for which the process was run. Its principal business function is to prevent the same Tax Year Start process from being executed more than once for a given payroll and tax year, and to ensure that a rollback of the process cannot occur unless the corresponding payroll and tax year combination was previously run.

The object is documented in ETRM with a status of VALID, owned by the HR schema, with FND Design Data referencing PAY.PAY_ZA_TYS_PROCESSES. It resides in the APPS_TS_TX_DATA tablespace, with its indexes stored in APPS_TS_TX_IDX. Under the heuristic Data Vault classification mined from its foreign key structure, the table is classified as standalone, meaning it does not participate in a documented parent-child relationship within the HR schema and carries no declared foreign keys. This suggests a modeling approach in which the table functions as an independent reference or control-log entity rather than as a hub, link, or satellite within a conventional Data Vault integration model.

Key Information Stored

The table contains four documented columns, each serving a distinct role in identifying and qualifying a Tax Year Start process execution:

• TYSP_ID (NUMBER) — The surrogate primary key for the table, defined by the unique index PAY_ZA_TYS_PROCESSES_PK. It uniquely identifies each Tax Year Start process record. Because the table is standalone with no documented foreign key references, TYSP_ID serves purely as an internal row identifier.
• PAYROLL_ID (NUMBER) — The identifier of the payroll for which the Tax Year Start process was executed. This is a business-key candidate and forms part of the composite unique index.
• CONSOLIDATION_SET_ID (NUMBER) — The identifier of the consolidation set associated with the payroll run. It is also a business-key candidate and participates in the composite unique index.
• TAX_YEAR (NUMBER) — The current tax year for which the process was run. This column is a business-key candidate and the third component of the composite unique index.

The composite unique index PAY_ZA_TYS_PROCESSES_UK1, defined on the combination of TAX_YEAR, PAYROLL_ID, and CONSOLIDATION_SET_ID, enforces the core business rule of the table: only one Tax Year Start process record may exist per tax year, payroll, and consolidation set combination. The distinction between the surrogate primary key (TYSP_ID) and the business-key candidates (TAX_YEAR, PAYROLL_ID, CONSOLIDATION_SET_ID) reflects a standard EBS design pattern in which technical row identity is separated from the natural business identifiers that enforce process integrity.

Common Use Cases and Queries

The primary operational use case is validating whether a Tax Year Start process has already been run before permitting a new execution, and confirming eligibility for a rollback. The following query pattern retrieves all recorded process executions:

• Listing all Tax Year Start runs: SELECT TYSP_ID, PAYROLL_ID, CONSOLIDATION_SET_ID, TAX_YEAR FROM HR.PAY_ZA_TYS_PROCESSES;
• Checking prior execution for a specific payroll and year: SELECT TYSP_ID FROM HR.PAY_ZA_TYS_PROCESSES WHERE PAYROLL_ID = :payroll_id AND TAX_YEAR = :tax_year;
• Verifying rollback eligibility: A rollback should only be permitted when a matching record exists for the payroll, consolidation set, and tax year combination being reversed. An absence of records indicates the process was never run and therefore cannot be rolled back.
• Audit and reporting: Listing distinct payrolls processed for a given tax year supports compliance and reconciliation reporting for South African statutory payroll processing.

Related Objects

The documented dependency information indicates that HR.PAY_ZA_TYS_PROCESSES does not reference any database object and is referenced by the APPS synonym PAY_ZA_TYS_PROCESSES and the PUBLIC synonym PAY_ZA_TYS_PROCESSES. Because the table is classified as standalone and carries no documented foreign keys, the principal functional dependencies are through the application layer rather than the physical schema. Significant related objects include:

• APPS.PAY_ZA_TYS_PROCESSES — The APPS-schema synonym through which application code and concurrent programs access the table.
• PUBLIC.PAY_ZA_TYS_PROCESSES — The public synonym providing general access.
• PAY_ZA_TYS_PROCESSES_PK — The primary key index on TYSP_ID.
• PAY_ZA_TYS_PROCESSES_UK1 — The unique index enforcing business-key uniqueness across TAX_YEAR, PAYROLL_ID, and CONSOLIDATION_SET_ID.
• Payroll-related reference data (by identifier convention) — PAYROLL_ID and CONSOLIDATION_SET_ID logically correspond to payroll and consolidation set definitions accessed by the Tax Year Start concurrent process, which reads and writes this table to enforce single-run and rollback constraints.