Results for “attrib_name”

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

Overview

IGS_EN_ATTRIBUTES is a table within the IGS – Student System product family of Oracle E-Business Suite, historically associated with the management of educational records and the National Student Loan Centre (NSLC) attribute data. The table's documented purpose is "Storage Location of Attribute for NSLC," indicating that it functions as a repository for named attribute values attached to enrollment-related documents. The IGS module is flagged as obsolete in Oracle EBS 12.1.1 and 12.2.2, and the ETRM metadata explicitly records that the object is "Not implemented in this database." Consequently, IGS_EN_ATTRIBUTES will generally not appear in a standard EBS 12.1.1 or 12.2.2 installation unless legacy IGS customizations or historical data migrations from earlier releases were preserved.

From a dimensional modeling perspective, the heuristic Data Vault classification derived from its foreign key structure is satellite-leaning. This suggestion reflects the table's role as a descriptive companion to a parent document entity: it stores attributes that qualify or describe records held in IGS_EN_DOCUMENTS rather than acting as an independent business hub or a pure many-to-many link.

Key Information Stored

The documented physical schema for the 12.1.1 release lists eight columns owned by the IGS schema. The most important of these are:

• ATTRIB_ID — Surrogate primary key, enforced by IGS_EN_ATTRIBUTES_PK and mirrored by the unique index IGS_EN_ATTRIBUTES_U1. This artificial identifier uniquely distinguishes each attribute row.
• DOC_ID — Foreign key to IGS_EN_DOCUMENTS, establishing the ownership of each attribute by a specific document record. This is the principal join column to the parent object.
• ATTRIB_NAME — The business name of the attribute being stored. Together with DOC_ID, it forms the alternate unique key IGS_EN_ATTRIBUTES_UK (index IGS_EN_ATTRIBUTES_U2), guaranteeing that any given attribute name occurs only once per document.
• CREATED_BY, CREATION_DATE — Standard WHO audit columns capturing the user and timestamp of row insertion.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns capturing the identity and session of the most recent modification.

The distinction between the surrogate key and the business key is significant: ATTRIB_ID provides a stable technical identifier, while the ATTRIB_NAME and DOC_ID combination represents the meaningful business uniqueness constraint, ensuring attributes are not duplicated within a single document context.

Common Use Cases and Queries

Because the table is obsolete and typically absent from production databases, most use cases involve historical analysis, migration validation, or documentation of legacy customizations. A typical query to retrieve all attributes belonging to a document joins the table to its parent:

• SELECT a.ATTRIB_ID, a.ATTRIB_NAME, d.DOC_ID FROM IGS_EN_ATTRIBUTES a, IGS_EN_DOCUMENTS d WHERE a.DOC_ID = d.DOC_ID;
• Reporting queries frequently filter on ATTRIB_NAME to extract specific NSLC-defined attributes for a given document set.
• Audit queries examine LAST_UPDATED_BY and LAST_UPDATE_DATE to trace when an attribute value or label was changed.
• Uniqueness validation can be performed against IGS_EN_ATTRIBUTES_U2 (DOC_ID, ATTRIB_NAME) to detect orphaned or duplicated rows during data migration.

In 12.2.2 environments, any surviving usage would likely be through legacy custom forms or concurrent programs rather than standard Oracle-delivered functionality.

Related Objects

The following objects are most directly associated with IGS_EN_ATTRIBUTES:

• IGS_EN_DOCUMENTS — The parent table referenced via the foreign key IGS_EN_ATTRIBUTES.DOC_ID. This is the primary join partner and the source of document context for every attribute row.
• IGS_EN_ATTRIBUTES_PK — Primary key constraint on ATTRIB_ID.
• IGS_EN_ATTRIBUTES_UK — Unique constraint on DOC_ID and ATTRIB_NAME.
• IGS_EN_ATTRIBUTES_U1 / IGS_EN_ATTRIBUTES_U2 — Unique indexes supporting the primary and alternate keys respectively.
• Other IGS_EN_* tables within the Student System document model, which may share the DOC_ID lineage through IGS_EN_DOCUMENTS.

The relationship topology confirms that IGS_EN_ATTRIBUTES is a dependent satellite of IGS_EN_DOCUMENTS, and no other foreign key relationships were documented in the ETRM metadata.