Results for “igs_rc_i_e_testtyps”

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

Overview

IGS_RC_I_E_TESTTYPS is a configuration table within the Oracle E-Business Suite Student System (IGS) module. Its documented role is to store the test types associated with inquiry entry statuses used during the recruitment and admissions cycle. In practical terms, it acts as a cross-reference between two independent reference lists: the set of admission tests defined by the institution and the set of inquiry entry statuses that describe where a prospective applicant stands in the entry funnel. The table therefore determines which admission test types are considered relevant or applicable for a given inquiry entry status.

The object belongs to the IGS - Student System product, which Oracle has designated as obsolete. The ETRM record explicitly states that the table is not implemented in the reference database, meaning the definition may exist in the data model but no physical table or data is present in the environment examined. Implementers targeting EBS 12.1.1 or 12.2.2 should confirm existence in the specific instance before writing dependent code.

From a dimensional modeling perspective, the heuristic Data Vault classification mined from the foreign key structure is link. This is a reasonable suggestion: the table carries two foreign keys pointing to separate reference entities and a surrogate primary key, which is the characteristic shape of a link table resolving a many-to-many or associative relationship rather than a hub of unique business entities or a satellite of descriptive attributes.

Key Information Stored

The documented structure is compact and centers on three identifiers plus the surrogate key:

• ENT_TEST_TYPE_ID — the surrogate primary key, defined by the constraint IGS_RC_I_E_TESTTYPS_PK. It provides the unique row identifier and is the recommended join key for any dependent object.
• INQ_ENTRY_STAT_ID — the foreign key to IGS_RC_I_ENT_STATS, identifying the inquiry entry status. Together with the admission test type this forms the documented unique key IGS_RC_I_E_TESTTYPS_UK.
• ADMISSION_TEST_TYPE — the foreign key to IGS_AD_TEST_TYPE, identifying the admission test type associated with the entry status.

The unique index IGS_RC_I_E_TESTTYPS_UK on (INQ_ENTRY_STAT_ID, ADMISSION_TEST_TYPE) is the business-key candidate, guaranteeing that any given test type is mapped to an entry status at most once. No descriptive or attribute columns beyond these identifiers are documented, which reinforces the link-table interpretation. Because the metadata lists no date-effective or audit columns, the table should be treated as a static configuration source rather than a transactional or history-bearing structure.

Common Use Cases and Queries

The principal use case is validation and presentation logic: given a prospect's inquiry entry status, the application must determine which admission test types are relevant. The canonical query joins the link to both parents:

• Retrieve all test types for a specific entry status: select t.admission_test_type from igs_rc_i_e_testtyps t where t.inq_entry_stat_id = :status_id.
• Resolve full descriptions by joining IGS_RC_I_ENT_STATS and IGS_AD_TEST_TYPE on the respective foreign key columns.
• Reconciliation reporting: outer-join IGS_AD_TEST_TYPE to this table to find test types never mapped to any entry status, and outer-join IGS_RC_I_ENT_STATS to find entry statuses with no test mapping.
• Setup verification after an upgrade or clone, where the absence of rows (consistent with the "not implemented" note) is itself a finding.

Reporting extracts should always drive from the parent reference tables and treat IGS_RC_I_E_TESTTYPS as an optional link, since the ETRM record indicates it may not be populated.

Related Objects

The significant related objects are those documented through the primary key and foreign key relationships:

• IGS_RC_I_ENT_STATS — parent of INQ_ENTRY_STAT_ID; supplies the inquiry entry status definition.
• IGS_AD_TEST_TYPE — parent of ADMISSION_TEST_TYPE; supplies the admission test type definition.
• IGS_RC_I_E_TESTTYPS_PK — the primary key constraint on ENT_TEST_TYPE_ID.
• IGS_RC_I_E_TESTTYPS_UK — the unique constraint on INQ_ENTRY_STAT_ID and ADMISSION_TEST_TYPE.

Other IGS recruitment and admissions tables that reference entry status or admission test types may logically intersect with this object, but the documented metadata identifies only these two foreign key targets. Any integration work should confirm their physical presence in the target EBS 12.1.1 or 12.2.2 instance before designing dependent logic.