Search Results interface_eit_id

Overview

IGS.IGS_PE_EIT_INT is the interface staging table used by Oracle E-Business Suite to import permanent resident extra information for person records. It is an open interface table that temporarily holds extra information attributes — such as Country of Physical Residence, State of Residence, and Citizenship/Residency Status — before that data is validated and transferred into the permanent destination table, IGS_PE_EIT. The table belongs to the IGS product (Student Systems / Person extra information architecture) and carries the FND Design Data reference IGS.IGS_PE_EIT_INT.

The object is scoped as public, has an active lifecycle, and is classified as a business entity associated with HZ_PERSON. It resides in the APPS_TS_INTERFACE tablespace with PCT Free 10, which is consistent with its role as a high-throughput staging table rather than a long-term transactional store.

The heuristic Data Vault classification mined from its foreign-key structure is standalone. In modeling terms, this suggests the interface table should be treated as an independent staging entity rather than as a hub, link, or satellite; it does not participate in the core Data Vault relationships and instead serves as a landing zone whose rows are consumed by downstream processing.

Key Information Stored

The table contains 24 documented physical columns. The most consequential are:

• INTERFACE_EIT_ID — The surrogate primary key (NUMBER, 15) and the column the user searched for. It uniquely identifies each interface row and is enforced by the unique index IGS_PE_EIT_INT_U1, making it the documented business-key candidate for the staging record.
• INTERFACE_ID — The interface ID that ties the row back to the parent person interface record; indexed non-uniquely by IGS_PE_EIT_INT_N1.
• INFORMATION_TYPE — The extra information type being imported (for example, residency or citizenship categories).
• PEI_INFORMATION1 through PEI_INFORMATION5 — Five generic extra-information attributes holding the actual values, such as Country of Physical Residence, State of Residence, and Citizenship/Residency Status.
• START_DATE / END_DATE — The effective date range for the extra information record.
• MATCH_IND — A match indicator used during validation.
• STATUS — Processing state: 1 Completed, 2 Pending, 3 Error, 4 Warning. Indexed non-uniquely by IGS_PE_EIT_INT_N2.
• ERROR_CODE — The error code assigned when a row fails validation.
• DUP_PE_EIT_ID — Duplicate extra information ID, supporting de-duplication logic.
• INTERFACE_RUN_ID — Identifier for the interface run, indexed by IGS_PE_EIT_INT_N3 for run-level reporting.
• REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE — Standard concurrent program who-columns.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit who-columns.

Common Use Cases and Queries

Typical usage centers on loading extra information, monitoring interface status, and diagnosing errors before the data is pushed to IGS_PE_EIT.

To inspect pending and errored rows for a given interface run:

• SELECT INTERFACE_EIT_ID, INTERFACE_ID, INFORMATION_TYPE, STATUS, ERROR_CODE FROM IGS.IGS_PE_EIT_INT WHERE INTERFACE_RUN_ID = :run_id AND STATUS IN (3,4);
• SELECT INFORMATION_TYPE, PEI_INFORMATION1, PEI_INFORMATION2 FROM IGS.IGS_PE_EIT_INT WHERE INTERFACE_ID = :interface_id;
• SELECT STATUS, COUNT(*) FROM IGS.IGS_PE_EIT_INT GROUP BY STATUS;

These patterns support reconciliation reporting, error triage, and confirmation that all staged rows have reached Completed status.

Related Objects

• IGS.IGS_PE_EIT — The destination table receiving validated rows from this interface.
• IGS_PE_PERSON_INT — The parent person interface table; related through INTERFACE_ID.
• HZ_PERSON — The business entity the imported extra information ultimately attaches to.
• FND_CONCURRENT_REQUESTS — Joined via REQUEST_ID for concurrent program tracking.
• FND_CONCURRENT_PROGRAMS — Joined via PROGRAM_ID and PROGRAM_APPLICATION_ID.

These relationships reflect the documented column structure and the standard concurrent processing framework used across IGS interface tables.