Results for “igs_ad_ss_test_conf”

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

Overview

The IGS_AD_SS_TEST_CONF table belongs to the IGS (Student System) product family within Oracle E-Business Suite. As reflected in the ETRM metadata, this module carries the designation "Obsolete," indicating that the object reflects the legacy Oracle Student System data model rather than a currently supported EBS application component. The table is documented as storing the attributes of Admission Test Types Configuration, meaning it functions as a configuration repository that links admission test types to the admission application types for which those tests are accepted, required, or otherwise applicable.

From a modeling perspective, the metadata classifies this object, via heuristic derived from its foreign key structure, as a link table. This suggestion is consistent with the physical design: the table's primary key is composed entirely of two foreign key columns, each referencing a separate parent entity. Rather than storing descriptive attributes of a single business entity, the table resolves a many-to-many relationship between Admission Test Types and Admission Application Types. It should therefore be treated as an association or cross-reference construct when reverse-engineering the underlying data model.

The ETRM documentation further notes that the table is "Not implemented in this database," indicating that in the specific 12.1.1 or 12.2.2 instance examined, the physical object was absent or not populated. This is common for obsolete IGS objects, and the metadata should be regarded as the authoritative reference for the intended structure.

Key Information Stored

The documented schema comprises eight columns. The most significant are the two key components and the administrative control and auditing columns.

• ADMISSION_TEST_TYPE — Identifies the admission test type, such as a standardized examination or institutional placement test. This column forms part of the composite primary key and is a foreign key to the IGS_AD_TEST_TYPE table.
• ADMISSION_APPLICATION_TYPE — Identifies the admission application type for which the test configuration applies. It also participates in the composite primary key and references the IGS_AD_SS_APPL_TYP table.
• INACTIVE — A status flag indicating whether the configuration row is active or has been logically retired. Because configuration tables are rarely deleted, this column governs whether the association remains in effect for new admissions processing.
• CREATED_BY, CREATION_DATE — Standard EBS audit columns recording the user and timestamp of row creation.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit columns capturing the identity of the last modifying user, the modification timestamp, and the login session associated with the change.

The primary key is documented as IGS_AD_SS_TEST_CONF_PK, defined over the pair (ADMISSION_TEST_TYPE, ADMISSION_APPLICATION_TYPE). The unique index IGS_AD_SS_TEST_CONF_U1 carries the identical column list, confirming that this combination is the sole business key. There is no independent surrogate identifier column; the two foreign keys together serve as both the natural key and the row identity.

Common Use Cases and Queries

The principal use case for this table is determining which admission tests are configured as applicable to a given application type, or conversely which application types accept a given test. A join between the configuration table and both parents produces a fully resolved view of the rule set, as illustrated below.

• Listing active test configurations for a specific application type, filtered on the INACTIVE flag, to drive application form validation or document checklist generation.
• Producing a reconciliation report of all test-to-application-type associations, joined to both IGS_AD_TEST_TYPE and IGS_AD_SS_APPL_TYP, for configuration review during implementation or upgrade testing.
• Auditing changes by querying LAST_UPDATED_BY and LAST_UPDATE_DATE to determine who altered a given configuration and when.

A representative query pattern would select the test and application type descriptions from the parent tables, joining on ADMISSION_TEST_TYPE and ADMISSION_APPLICATION_TYPE respectively, with a predicate of INACTIVE = 'N' to restrict output to effective configurations.

Related Objects

The following objects are the most significant relative to IGS_AD_SS_TEST_CONF, based on the documented foreign key relationships.

• IGS_AD_TEST_TYPE — Parent table of ADMISSION_TEST_TYPE; holds the definition of each admission test type.
• IGS_AD_SS_APPL_TYP — Parent table of ADMISSION_APPLICATION_TYPE; holds the definition of each admission application type.
• IGS_AD_SS_TEST_CONF_PK — The primary key constraint enforcing uniqueness of the test/application-type pair.
• IGS_AD_SS_TEST_CONF_U1 — The unique index mirroring the primary key columns and confirming the business key.

Because the object is obsolete and absent from the documented instance, dependency analysis against higher-level IGS admission configuration views and concurrent programs should be validated against the specific deployment before being relied upon.