Search Results balance_set_member_id

Overview

HR.PAY_BALANCE_SET_MEMBERS is a transactional configuration table in the Oracle E-Business Suite HR (Payroll) schema that holds the details of the individual components of a balance set. In Oracle Payroll, a balance set is a grouping of balances that can be processed and reported together, typically for the purpose of driving payroll calculations, reports, or legislative reporting. Each row in this table represents one member (component) of a balance set, defining which balance dimension and which defined balance participate in that set.

The table is owned by the HR schema and registered under FND Design Data PAY.PAY_BALANCE_SET_MEMBERS. It is stored in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, indicating a typical transactional configuration profile. The object is documented as VALID in the ETRM metadata for both 12.1.1 and 12.2.2, meaning the structure and dependencies are consistent across those releases. Under the heuristic Data Vault classification mined from its foreign-key structure, PAY_BALANCE_SET_MEMBERS is tagged as "standalone". In practice, however, its two foreign keys (to PAY_BALANCE_SETS and PAY_BALANCE_DIMENSIONS) suggest it functions naturally as a link or association entity connecting balance sets, dimensions, and defined balances, rather than as a pure satellite of a single parent.

Key Information Stored

The table contains four documented columns. The most significant are:

• BALANCE_SET_MEMBER_ID (NUMBER) — the surrogate primary key and unique identifier for each balance set member record. It is the sole column of the unique index PAY_BALANCE_SET_MEMBERS_PK and is the column users most commonly search for when resolving the "balance_set_member_id" reference.
• BALANCE_SET_ID (NUMBER) — foreign key to PAY_BALANCE_SETS. Identifies the parent balance set to which this member belongs. This is the primary business-key candidate for grouping members back to their owning set.
• BALANCE_DIMENSION_ID (NUMBER) — foreign key to PAY_BALANCE_DIMENSIONS. Identifies the balance dimension (for example, an assignment-level or payroll-level dimension) applicable to the member.
• DEFINED_BALANCE_ID (NUMBER) — foreign key to PAY_DEFINED_BALANCES. Identifies the specific defined balance that this member contributes to the balance set.

The primary key is a system-generated surrogate, whereas the meaningful business keys are the combination of BALANCE_SET_ID, BALANCE_DIMENSION_ID, and DEFINED_BALANCE_ID, which together describe the membership relationship. No separate unique index on those three columns is documented, so the surrogate remains the only declared unique constraint.

Common Use Cases and Queries

Typical use cases include diagnosing payroll balance set configuration, reproducing reported balance values, and building custom balance-set reports. A frequent query resolves a set member ID back to its parent set and defined balance:

• Retrieve all members of a given balance set: SELECT BALANCE_SET_MEMBER_ID, BALANCE_DIMENSION_ID, DEFINED_BALANCE_ID FROM HR.PAY_BALANCE_SET_MEMBERS WHERE BALANCE_SET_ID = :p_set_id;
• Resolve a member ID to its parent set: SELECT BALANCE_SET_ID, DEFINED_BALANCE_ID FROM HR.PAY_BALANCE_SET_MEMBERS WHERE BALANCE_SET_MEMBER_ID = :p_member_id;
• Enumerate the full composition of a set joined to its dimension and defined balance names for reporting.

Developers frequently include PAY_BALANCE_SET_MEMBERS in SQL*Loader or PL/SQL scripts that create or clone balance sets, since the table is the authoritative source for set membership.

Related Objects

• HR.PAY_BALANCE_SETS — parent table referenced via BALANCE_SET_ID; defines the balance set header.
• HR.PAY_BALANCE_DIMENSIONS — referenced via BALANCE_DIMENSION_ID; defines the dimension context for each member.
• HR.PAY_DEFINED_BALANCES — references the defined balance identified by DEFINED_BALANCE_ID (documented FK target).
• HR.PAY_BALANCE_SET_MEMBERS# — the editioning/upgrade backing object noted as referencing this table.
• Related payroll balance APIs and views that consume balance sets, such as those used by payroll run and balance reporting processes.