Search Results credential_type_id




Overview
Explore in AI Chat

Overview

IGS_AD_CRED_TYPES is a reference (lookup) table in the Oracle E-Business Suite Student System (IGS) product family, documented as obsolete in the ETRM metadata for releases 12.1.1 and 12.2.2. The table holds credential type definitions — the master list of academic or professional credentials that can be associated with a person or an admissions record. In the IGS data model, it functions as a small, slowly changing code table that classifies credentials used elsewhere in the Admissions (AD) and People/Records (PE) sub-modules.

The ETRM documentation explicitly notes "Not implemented in this database," indicating that the object is registered in the metadata repository but is not physically present in the reference instance from which the documentation was mined. Consultants encountering this table in a 12.1.1 or 12.2.2 environment should verify its existence before writing queries against it.

Based on the foreign-key topology, the heuristic Data Vault classification is hub-leaning. IGS_AD_CRED_TYPES is referenced by three separate child tables via the CREDENTIAL_TYPE_ID column, which is the classic pattern of a hub: a stable, business-meaningful key centre surrounded by dependent satellites and links. In a Data Vault model this would be modelled as a hub with the credential type descriptor attributes carried in a satellite.

Key Information Stored

The documented physical schema (owner IGS) contains eleven columns. The most significant are:

  • CREDENTIAL_TYPE_ID — the surrogate primary key, defined by the IGS_AD_CRED_TYPES_PK constraint and reinforced by the IGS_AD_CRED_TYPES_U1 unique index. This is the column referenced by every foreign key pointing at the table.
  • CREDENTIAL_TYPE — the business-key candidate, protected by the IGS_AD_CRED_TYPES_U2 unique index. This holds the human-readable code or name of the credential type.
  • SYSTEM_TYPE — identifies the owning system or module context for the credential type, allowing the same table to serve multiple functional areas.
  • DESCRIPTION — the long description displayed in forms and reports.
  • CLOSED_IND — a Y/N style flag indicating whether the credential type is still active and selectable, or has been retired.
  • STEP_CODE — a processing or workflow step indicator associated with the credential type.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle EBS WHO columns used for auditing and concurrency.

The presence of two unique constraints on the same surrogate key column (PK and U1) is a documentation artefact typical of IGS dictionary output; both should be treated as enforcing uniqueness on CREDENTIAL_TYPE_ID.

Common Use Cases and Queries

Typical use cases involve decoding credential references on person and admissions records, and restricting lookups to active credential types. A standard decode join is:

  • SELECT c.credential_type_id, c.credential_type, c.description FROM igs_ad_cred_types c WHERE NVL(c.closed_ind,'N') = 'N' ORDER BY c.credential_type;
  • Joining to dependent tables: SELECT p.person_id, t.credential_type FROM igs_pe_credentials p, igs_ad_cred_types t WHERE p.credential_type_id = t.credential_type_id;
  • Counting usage per type across child tables to assess which credentials are actually in circulation before retiring a type via CLOSED_IND.

Because the table is obsolete and not implemented, reporting solutions should first validate availability and, where the object is absent, source credential type values from the surviving child tables or a legacy extract.

Related Objects

  • IGS_AD_CREDENTIALS — joins on CREDENTIAL_TYPE_ID; admissions-side credential records.
  • IGS_PE_CREDENTIALS — joins on CREDENTIAL_TYPE_ID; person-level credentials.
  • IGS_PE_CRED_INT — joins on CREDENTIAL_TYPE_ID; the interface/staging table for person credentials.
  • IGS_AD_CRED_TYPES_PK / _U1 — primary key and unique index on CREDENTIAL_TYPE_ID.
  • IGS_AD_CRED_TYPES_U2 — unique index on CREDENTIAL_TYPE, the business key.

Oracle Proprietary, Confidential Information — Legal Notices apply.