Results for “eng_ecn_approvers”

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

Overview

The ENG_ECN_APPROVERS table in the Oracle E-Business Suite Engineering (ENG) module stores the list of employees assigned as approvers on an Engineering Change Order (ECO) approval list. It is the associative detail table that links an approval list header, held in ENG_ECN_APPROVAL_LISTS, to the specific employees who must review and authorize an engineering change before it can be released. Each row represents one approver on one approval list, together with the sequence in which that approver acts.

Under the Data Vault classification heuristic mined from its foreign-key structure, ENG_ECN_APPROVERS is satellite-leaning. It carries descriptive and state-holding attributes (sequence, description, disable date) attached to a parent business key supplied by ENG_ECN_APPROVAL_LISTS, rather than acting as an independent hub or as a pure many-to-many link. This classifies it conceptually as a satellite of the approval-list entity, with the employee reference supplying a secondary dimension.

Key Information Stored

The table is defined in the ENG schema and contains 27 documented columns. The most significant are:

• APPROVAL_LIST_ID — Foreign key to ENG_ECN_APPROVAL_LISTS; identifies the approval list to which the approver belongs. Part of the primary key.
• EMPLOYEE_ID — Identifies the employee assigned as an approver. Part of the primary key.
• SEQUENCE1 — Ordering position of the approver within the approval list.
• SEQUENCE2 — Secondary sequencing value used to control approval routing where a list requires more than one ordinal.
• DESCRIPTION — Free-text annotation describing the approver's role or responsibility on the list.
• DISABLE_DATE — Date on which the approver assignment is deactivated, supporting historical audit of approval rosters.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns recording who created and last modified each row.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — The standard EBS DFF (descriptive flexfield) columns for extending approver records without schema change.

The surrogate primary key is ENG_ECN_APPROVERS_PK, defined over (APPROVAL_LIST_ID, EMPLOYEE_ID). The unique index ENG_ECN_APPROVERS_U1 covers the same column pair and serves as the business-key candidate, enforcing that an employee appears at most once per approval list.

Common Use Cases and Queries

Typical reporting and integration scenarios include retrieving the full approver roster for a given approval list, identifying all change orders on which a particular employee must approve, and auditing active versus disabled approvers.

To list approvers for a specific list in routing order:

• SELECT EMPLOYEE_ID, SEQUENCE1, SEQUENCE2, DESCRIPTION, DISABLE_DATE FROM ENG.ENG_ECN_APPROVERS WHERE APPROVAL_LIST_ID = :list_id ORDER BY SEQUENCE1, SEQUENCE2;

To identify all lists on which an employee serves as an active approver:

• SELECT APPROVAL_LIST_ID FROM ENG.ENG_ECN_APPROVERS WHERE EMPLOYEE_ID = :emp_id AND (DISABLE_DATE IS NULL OR DISABLE_DATE > SYSDATE);

Joining to the parent header supplies the change-order context for a report:

• SELECT l.APPROVAL_LIST_ID, a.EMPLOYEE_ID, a.SEQUENCE1 FROM ENG.ENG_ECN_APPROVAL_LISTS l JOIN ENG.ENG_ECN_APPROVERS a ON a.APPROVAL_LIST_ID = l.APPROVAL_LIST_ID;

Related Objects

• ENG_ECN_APPROVAL_LISTS — Parent table; joined on APPROVAL_LIST_ID. This is the sole documented foreign-key relationship for ENG_ECN_APPROVERS.
• ENG_ECN_APPROVAL_LIST_ASSIGNMENTS and the approval-list setup forms in the Engineering module — consume approver rows when building approval routing for an ECO.
• ENG_ENGINEERING_CHANGES / ENG_ECN_HEADERS — The change-order header entities whose release depends on completion of the approvers defined here.
• PER_ALL_PEOPLE_F (HR) — Source of EMPLOYEE_ID detail such as approver name and status; typically joined on PERSON_ID/EMPLOYEE_ID for reporting.
• ENG_ECN_APPROVERS_U1 and ENG_ECN_APPROVERS_PK — The unique and primary indexes that enforce approver uniqueness per list.