Results for “user_code”

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

Overview

PAY_ZA_ACB_USER_GEN_NOS is an HR-schema table within the Oracle E-Business Suite Payroll (PAY) product family, validated across EBS 12.1.1 and 12.2.2. It stores ACB (Automated Clearing Bureau) generation number information that is required when a South African payroll submits magnetic tapes to ACB for bank settlement. Each record associates a payroll action with a user-supplied code and a generation number, providing the sequence control necessary for the ACB tape interface. The table is a low-volume configuration table rather than a transaction ledger; rows are created or maintained ahead of the ACB submission run.

Under the heuristic Data Vault classification mined from its foreign-key structure, the table is satellite-leaning. This is a modeling suggestion: because the table carries descriptive ACB generation attributes attached to the PAY_PAYROLL_ACTIONS parent, it behaves functionally like a satellite surrounding the payroll action hub, with the composite key providing the identifying grain rather than a standalone business entity.

Key Information Stored

The documented physical schema exposes three columns, of which the following are material:

• PAYROLL_ACTION_ID — Identifier of the parent payroll action. This column participates in the composite primary key and is also the foreign key to PAY_PAYROLL_ACTIONS. It anchors each ACB generation record to the payroll process that consumes it.
• USER_CODE — The user-facing code that, together with the payroll action, forms the composite business key. This is the value users search on when locating ACB generation configuration; it distinguishes multiple generation-number entries recorded against the same payroll action.
• GEN_NUMBER — The ACB generation number itself, the operational payload of the row. It is the value written to, or referenced by, the magnetic tape submission so that ACB can reconcile the transmitted file against prior submissions.

The surrogate-versus-business-key distinction should be noted: PAY_ZA_ACB_USER_GEN_NOS_PK is defined as the composite unique index on (PAYROLL_ACTION_ID, USER_CODE), making that pair the business-key candidate. There is no separate single-column surrogate identifier documented; the composite key performs both roles. GEN_NUMBER is a dependent attribute of that key and is not itself unique.

Common Use Cases and Queries

The table is principally queried during ACB tape setup, reconciliation of generation numbers, and audit of what was transmitted for a given payroll run. A typical lookup retrieves the generation number for a specific user code within a payroll action:

• SELECT payroll_action_id, user_code, gen_number FROM hr.pay_za_acb_user_gen_nos WHERE user_code = :p_user_code;
• SELECT g.gen_number FROM hr.pay_za_acb_user_gen_nos g WHERE g.payroll_action_id = :p_action_id ORDER BY g.user_code;
• Reconciliation report joining the parent action to list all codes and their generation numbers for a payroll period.
• Pre-submission validation ensuring every expected user code has a non-null gen_number before the ACB tape is produced.

Because the table is small and highly selective on its composite key, queries against PAYROLL_ACTION_ID and USER_CODE are index-driven and inexpensive.

Related Objects

The foreign-key metadata documents one explicit parent relationship, with additional EBS objects implied by the ACB tape process:

• PAY_PAYROLL_ACTIONS — referenced through PAY_ZA_ACB_USER_GEN_NOS.PAYROLL_ACTION_ID; the mandatory parent in every join.
• PAY_ZA_ACB_USER_GEN_NOS_PK — the composite unique index enforcing (PAYROLL_ACTION_ID, USER_CODE).
• PAY_ZA_* ACB interface tables — sibling South African payroll objects that consume the generation number at tape submission time.
• PAY_ACTION_INFORMATION / payroll action parameters — commonly joined for context on the parent action.
• Concurrent program definitions for the ACB magnetic tape process, which read this table at runtime.

Together these objects position PAY_ZA_ACB_USER_GEN_NOS as a small but essential control table in the South African ACB payment interface.