Search Results igs_ad_relacad_int_all_u1

Overview

IGS.IGS_AD_RELACAD_INT_ALL is an Oracle EBS interface (staging) table owned by the IGS (Student System / Campus Solutions) product schema. It transiently holds the academic history records of relatives (relations) for each person prior to import into the production tables IGS_AD_HZ_ACAD_HIST and HZ_EDUCATION. The Admission Import process reads rows from this table, validates them, and posts the successful records to their final destinations. Its display name, "Import Person Relations Academic History," and its BUSINESS_ENTITY HZ_PERSON category confirm its role as a person-centric admissions staging object.

Rows live in the APPS_TS_INTERFACE tablespace, a standard EBS landing area for inbound data, with PCTFREE 10. The object is classified as a standalone entity with a heuristic Data Vault modeling suggestion of a standalone structure rather than a hub, link, or satellite; because it carries a single-person interface identifier with no enforced hub-style natural key, this classification is best read as a modeling heuristic rather than a normative Data Vault design.

Key Information Stored

The surrogate primary key is INTERFACE_RELACAD_ID, backed by primary key IGS_AD_RELACAD_INT_PK and protected by the unique index IGS_AD_RELACAD_INT_ALL_U1 — the exact index referenced in the search term. The documented unique index confirms INTERFACE_RELACAD_ID as the sole business-key candidate at the interface level. Its foreign key to IGS_AD_RELATIONS_INT_ALL via INTERFACE_RELATIONS_ID ties each academic-history detail row to its parent relation record.

• ORG_ID – Operating unit identifier, enabling multi-org security.
• INTERFACE_RELACAD_ID – Surrogate interface relation-academic identifier (unique).
• INTERFACE_RELATIONS_ID – FK to IGS_AD_RELATIONS_INT_ALL, the parent relation row.
• INSTITUTION_CODE and CURRENT_INST – The institution attended and whether it is current.
• PROGRAM_CODE and VERSION_NUMBER – Program studied and its version.
• DEGREE_ATTEMPTED / DEGREE_EARNED and the obsolete PROGRAM_TYPE_* columns – qualification data carried into HZ_EDUCATION.
• START_DATE, END_DATE, PLAN_COMPLETION_DATE – Attendance chronology.
• MATCH_IND – Indicates whether the academic history matched an existing record.
• STATUS, ERROR_CODE, COMMENTS – Processing outcome (imported, pending, error, or warning) and diagnostics.
• INTERFACE_RUN_ID, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE – Concurrent-program run and audit linkage.
• UPDATE_EDUCATION_ID, DUP_ACAD_HISTORY_ID – Targets used during update and duplicate resolution.
• CREATED_BY / CREATION_DATE / LAST_UPDATED_BY / LAST_UPDATE_DATE / LAST_UPDATE_LOGIN – Standard Who audit columns.

Common Use Cases and Queries

Typical use is monitoring and reconciling the Admission Import. Reports group by INTERFACE_RUN_ID or STATUS to determine batch health, and DBAs isolate failed rows for correction and reprocessing.

• Count by status: SELECT STATUS, COUNT(*) FROM IGS.IGS_AD_RELACAD_INT_ALL GROUP BY STATUS;
• List errors: SELECT INTERFACE_RELACAD_ID, INTERFACE_RELATIONS_ID, ERROR_CODE FROM IGS.IGS_AD_RELACAD_INT_ALL WHERE STATUS = 'ERROR';
• All details for one relation: SELECT ... FROM IGS.IGS_AD_RELACAD_INT_ALL WHERE INTERFACE_RELATIONS_ID = :id;
• Run-specific audit: SELECT ... WHERE INTERFACE_RUN_ID = :run AND ORG_ID = :org;
• Confirm completed degree records (DEGREE_EARNED, END_DATE) as a customs purge/reload reference.

Any SQL should be qualified by ORG_ID and INTERFACE_RUN_ID for performance, since the nonunique indexes IGS_AD_RELACAD_INT_ALL_N1 (INTERFACE_RUN_ID), N2 (STATUS), and N3 (INTERFACE_RELATIONS_ID) support exactly these access paths. Because the table is a staging object, data is generally purged after import, so queries against it should not be treated as historical system of record.

Related Objects

Relevant dependent and referenced objects include:

• IGS_AD_RELATIONS_INT_ALL – parent table joined on INTERFACE_RELATIONS_ID.
• IGS_AD_HZ_ACAD_HIST – target academic history table populated on successful import.
• HZ_EDUCATION – TCA education table updated by the import process.
• IGS_AD_PERSON_INT_ALL – staged person records referenced via the relation chain.
• IGS_AD_IMPORT_PROCESS – the concurrent program that evaluates and posts rows.
• FND_CONCURRENT_REQUESTS – joins on REQUEST_ID / INTERFACE_RUN_ID for run context.

These relationships should be validated against the target instance, as the object's full 30-column definition spans 12.1.1 and 12.2.2.