Search Results igs_ad_credentials




Overview
Explore in AI Chat

Overview

The IGS_AD_CREDENTIALS table belongs to the IGS (Student System) product family within Oracle E-Business Suite. Its documented description states that the table was made obsolete in Enhancement 2177686. As a result, the object carries a "Not implemented in this database" designation in the ETRM metadata, meaning it is retained only as a historical or structural artifact and is not expected to hold active data in the supported 12.1.1 and 12.2.2 environments.

From a data-modeling perspective, the metadata classifies this object heuristically as a link table (Data Vault classification: link). This suggestion reflects its role as an associative entity: it resolves relationships between the admissions credential domain and the code/type reference tables it points to, rather than serving as a pure business hub or a descriptive satellite. Any modeling exercise should treat IGS_AD_CREDENTIALS as a junction that connects credential instances to their categorization and rating references.

Key Information Stored

The documented metadata identifies the following columns as the most significant for this object:

  • CREDENTIAL_ID — the surrogate primary key. It is defined by both the IGS_AD_CREDENTIALS_PK and the IGS_AD_CREDENTIALS_U1 unique indexes, making it the single documented key column and the sole unique identifier for each credential record.
  • CREDENTIAL_TYPE_ID — a foreign key to IGS_AD_CRED_TYPES. This column classifies the credential into its defined type category (for example, the kind of admissions credential being recorded).
  • RATING — a foreign key to IGS_AD_CODE_CLASSES. This column links the credential to a value in the code-classes reference table, providing a coded rating or classification value.

Notably, the documentation does not expose a separate business-key column distinct from the surrogate; CREDENTIAL_ID serves as both the primary key and the unique-indexed identifier. No descriptive attributes beyond the two foreign-key columns are documented in the available metadata.

Common Use Cases and Queries

Because the table is obsolete and not implemented, most practical usage focuses on impact analysis, data migration audits, and confirming that legacy customization does not still reference it. A typical verification query checks for any residual rows or dependencies:

  • Confirming existence of data before decommissioning a legacy schema: SELECT COUNT(*) FROM IGS_AD_CREDENTIALS;
  • Resolving the credential category through the type reference: SELECT c.CREDENTIAL_ID, t.CREDENTIAL_TYPE_ID FROM IGS_AD_CREDENTIALS c, IGS_AD_CRED_TYPES t WHERE c.CREDENTIAL_TYPE_ID = t.CREDENTIAL_TYPE_ID;
  • Joining to the code-classes reference to translate the RATING value: SELECT c.CREDENTIAL_ID, cc.RATING FROM IGS_AD_CREDENTIALS c, IGS_AD_CODE_CLASSES cc WHERE c.RATING = cc.RATING;
  • Extracting metadata from the data dictionary to confirm obsolescence: querying ALL_TAB_COLUMNS and ALL_CONSTRAINTS for the object name.

Reporting use cases center on reconciliation of historical admissions credential records and on verifying that Enhancement 2177686 fully removed the functional dependency.

Related Objects

The following objects are the most significant relationships documented for IGS_AD_CREDENTIALS:

  • IGS_AD_CRED_TYPES — referenced via the CREDENTIAL_TYPE_ID foreign key; supplies the credential type definition.
  • IGS_AD_CODE_CLASSES — referenced via the RATING foreign key; supplies the coded rating/classification value.
  • IGS_AD_CREDENTIALS_PK — the primary-key constraint on CREDENTIAL_ID.
  • IGS_AD_CREDENTIALS_U1 — the unique index on CREDENTIAL_ID.

These relationships confirm the link-table classification: the object depends on two reference tables and contributes no independent hub structure of its own.