Results for “pre_attribute30”

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

Overview

The BEN.BEN_PRTT_REIMBMT_RECON table is a component of the Oracle Advanced Benefits (BEN) product family within Oracle E-Business Suite 12.1.1 and 12.2.2. As its name suggests, the object supports the reconciliation of participant reimbursement activity — most notably reimbursement requests generated through Flexible Spending Account (FSA), Health Savings Account (HSA), and Health Reimbursement Arrangement (HRA) processing. The table acts as a transaction-level reconciliation ledger that ties reimbursement amounts back to their originating payroll run results, allowing benefits administrators and payroll integrators to validate that amounts requested through benefits have been correctly reflected in payroll disbursements.

The ETRM documentation classifies this object with a description of "Out of scope," meaning it is not part of the publicly documented functional setup or user-facing configuration, but it remains a valid, populated schema object owned by the BEN schema. From a data modeling perspective, the mined relationship data suggests this table behaves as a standalone object with a single foreign-key dependency. A heuristic Data Vault classification would place it as a satellite attached to a payroll run result hub — the table carries descriptive and measurable reconciliation attributes keyed to an underlying business entity rather than representing a hub or link in its own right.

Key Information Stored

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

• PRTT_REIMBMT_RECON_ID — The surrogate primary key, defined by the unique index BEN_PRTT_REIMBMT_RECON_PK. This is the only documented business-key candidate; no alternate unique keys are recorded.
• RUN_RESULT_ID — Foreign key to PAY_RUN_RESULTS, linking each reconciliation row to the specific payroll run result that produced or consumed the reimbursement amount.
• PRTT_REIMBMT_RQST_ID — Reference to the originating participant reimbursement request, connecting the reconciliation record to the request workflow.
• INPUT_VALUE_ID — Identifier for the input value used in the reimbursement calculation, supporting traceability to payroll element input values.
• AMT — The monetary amount being reconciled, representing the reimbursement value applied against the run result.
• RQST_CMPLTD_FLAG — Flag indicating whether the associated reimbursement request has been completed.
• BUSINESS_GROUP_ID — Multi-tenant partition key identifying the business group (enterprise) that owns the row.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the Oracle Application Framework (OAF) and concurrent processing to detect stale updates.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — Standard who-column audit trail.
• PRE_ATTRIBUTE_CATEGORY and PRE_ATTRIBUTE1 through PRE_ATTRIBUTE30 — A descriptive flexfield (DFF) block of thirty attribute columns plus a category column, used to store client-specific or regional reconciliation detail without schema extension.

Common Use Cases and Queries

Typical uses of this table center on reconciliation reporting, payroll audit, and benefits-to-payroll variance analysis.

• Reconciling reimbursement amounts to payroll run results for a given payroll period or business group.
• Auditing completed versus outstanding reimbursement requests via RQST_CMPLTD_FLAG.
• Aggregating reimbursements by input value or attribute category for spending-account reporting.

A representative query joining payroll results:

• SELECT r.PRTT_REIMBMT_RECON_ID, r.AMT, r.RQST_CMPLTD_FLAG, p.PAYROLL_RUN_RESULT_ID FROM BEN.BEN_PRTT_REIMBMT_RECON r JOIN PAY.PAY_RUN_RESULTS p ON r.RUN_RESULT_ID = p.RUN_RESULT_ID WHERE r.BUSINESS_GROUP_ID = :p_bg_id;

Administrators frequently filter on LAST_UPDATE_DATE to identify reconciliation rows touched by a specific concurrent process, and use the DFF attributes when region-specific reconciliation rules are configured.

Related Objects

• PAY.PAY_RUN_RESULTS — Joined via RUN_RESULT_ID; the authoritative source of payroll run result detail and the sole documented foreign-key target.
• BEN.BEN_PRTT_REIMBMT_RQST — The reimbursement request header referenced by PRTT_REIMBMT_RQST_ID; provides request-level context.
• BEN.BEN_PRTT_REIMBMT_RECON_PK — The primary-key index object enforcing uniqueness on PRTT_REIMBMT_RECON_ID.
• BEN.BEN_PRTT_REIMBMT_RQST_LINE — Line-level reimbursement request detail that feeds reconciliation amounts.
• PAY.PAY_ELEMENT_ENTRIES / PAY.PAY_INPUT_VALUES_F — Related payroll objects that may be joined through INPUT_VALUE_ID for input-value traceability.
• BEN.BEN_PRTT_FSA_* family — FSA/HRA reimbursement processing tables that generate the request IDs consumed by this reconciliation table.

Because the ETRM metadata marks this object as out of scope, no public API or documented view is exposed; integration should rely on the underlying tables and standard payroll concurrent programs.