Results for “employer_address”

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

Overview

OIE_ATTENDEES_ARC is an Oracle E-Business Suite archive table residing in the AP (Payables) schema. It stores historical attendee information associated with expense report lines processed by Oracle Internet Expenses (OIE). As the "_ARC" suffix indicates, the table functions as the archival counterpart to OIE_ATTENDEES_ALL, preserving attendee records that have been moved out of the active transaction tables during purge, period-close, or archiving routines. Its role is to retain a permanent, queryable record of attendee data for audit, tax substantiation, and compliance purposes long after the originating expense report has been closed or archived.

The ETRM metadata classifies this table with a heuristic Data Vault classification of standalone. Consistent with that finding, the table does not serve as a hub, link, or satellite in a formal Data Vault sense; it is best modeled as an independent archival snapshot that duplicates the structure of OIE_ATTENDEES_ALL with the addition of archive-specific control columns. The 34-column footprint mirrors the operational attendee table plus archive tracking attributes.

Key Information Stored

The table carries surrogate and archival control columns alongside the business-relevant attendee attributes. The most significant columns are:

• ARC_REQ_ID — The archive request identifier that groups rows belonging to a single archiving run, enabling traceability back to the archival job.
• ARCHIVE_DATE — Timestamp at which the attendee row was moved into the archive.
• ATTENDEE_LINE_ID — Surrogate identifier for the attendee line; foreign key to OIE_ATTENDEES_ALL and the primary business-key candidate linking the archived row to its live counterpart.
• REPORT_LINE_ID — Foreign key to AP_EXPENSE_REPORT_LINES_ALL, tying the attendee to the specific expense report line.
• EMPLOYEE_ID — Foreign key to PSB_EMPLOYEES, identifying the employee when the attendee is an internal employee.
• EMPLOYEE_FLAG — Indicates whether the attendee is an employee or an external party.
• ATTENDEE_TYPE — Classification of the attendee for reporting and reimbursement rules.
• NAME, TITLE, EMPLOYER, EMPLOYER_ADDRESS — Descriptive attendee details used in expense substantiation.
• TAX_ID — Tax identification for the attendee, relevant to taxable-benefit reporting.
• ORG_ID — Multi-org operating unit identifier.
• Standard audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — plus the fifteen ATTRIBUTE1–15 and ATTRIBUTE_CATEGORY descriptive flexfield columns.

Common Use Cases and Queries

Typical uses center on audit reconstruction and historical reporting where live attendee rows have been purged. A representative query linking archived attendees to their expense report lines:

• SELECT a.NAME, a.EMPLOYER, a.TAX_ID, a.ARCHIVE_DATE FROM AP.OIE_ATTENDEES_ARC a WHERE a.REPORT_LINE_ID = :report_line_id;
• Joining to the employee table to resolve internal attendees: SELECT a.NAME, e.employee_number FROM AP.OIE_ATTENDEES_ARC a, PSB_EMPLOYEES e WHERE a.EMPLOYEE_ID = e.employee_id AND a.EMPLOYEE_FLAG = 'Y';
• Auditing an archive run: filter by ARC_REQ_ID or an ARCHIVE_DATE range to reconcile counts against the source report lines.

Reporting scenarios include tax substantiation for employee business meals, reconciliation of archived versus active attendee volumes, and retention-policy verification.

Related Objects

• OIE_ATTENDEES_ALL — The live attendee table; joined on ATTENDEE_LINE_ID.
• AP_EXPENSE_REPORT_LINES_ALL — Expense report lines; joined on REPORT_LINE_ID.
• PSB_EMPLOYEES — Employee master; joined on EMPLOYEE_ID.
• AP_EXPENSE_REPORT_HEADERS_ALL — Report headers reached via the report line join.
• OIE_ATTENDEES_ARC — Archive control columns (ARC_REQ_ID, ARCHIVE_DATE) typically correspond to the archiving process that also purges OIE_ATTENDEES_ALL.