Results for “discrepancy_rule_cd”

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

Overview

The IGS_AD_DSCP_ATTR table belongs to the IGS (Student System) product family within Oracle E-Business Suite. Its documented description states that it "holds information about attributes used with category," indicating that it stores the attribute definitions associated with discrepancy categories in the Student System. Within EBS 12.1.1 and 12.2.2, this object is flagged as obsolete and, per the ETRM metadata, is "not implemented in this database." It therefore appears in the data dictionary lineage primarily to support historical, upgrade, or migration analysis rather than active transactional use.

From a Data Vault modeling perspective, the mined FK structure suggests a satellite-leaning classification. The table's single foreign key to IGS_AD_SOURCE_CAT_ALL, combined with descriptive columns such as ATTRIBUTE_NAME and DISCREPANCY_RULE_CD, indicates that it behaves as a descriptive attribute store attached to the source category hub rather than as an independent hub or a pure link table. This classification is offered as a modeling heuristic and not as a certified Data Vault designation.

Key Information Stored

The physical schema documented for ETRM 12.1.1 comprises nine columns owned by the IGS schema. The most significant columns are:

• DISCREPANCY_ATTR_ID — the surrogate primary key of the table, backed by the IGS_AD_DSCP_ATTR_PK constraint and the unique index IGS_AD_DSCP_ATTR_U1. It uniquely identifies each attribute record.
• SRC_CAT_ID — the foreign key to IGS_AD_SOURCE_CAT_ALL, linking each attribute to its parent discrepancy source category.
• ATTRIBUTE_NAME — the business name of the attribute used with the category. Together with SRC_CAT_ID it forms the alternate unique key IGS_AD_DSCP_ATTR_UK / IGS_AD_DSCP_ATTR_U2.
• DISCREPANCY_RULE_CD — the code describing the discrepancy rule associated with the attribute.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard EBS audit columns recording who last modified the row and when.
• CREATION_DATE, CREATED_BY — the standard EBS audit columns recording row creation metadata.

The surrogate key (DISCREPANCY_ATTR_ID) is distinct from the business-key candidate defined by the composite unique constraint over SRC_CAT_ID and ATTRIBUTE_NAME. This separation allows the business identifier to be enforced independently of the technical primary key.

Common Use Cases and Queries

Because the table is obsolete and not implemented, practical usage is typically limited to data migration validation, static analysis, and legacy reporting. A typical lookup joins attributes to their parent category:

• Attribute-to-category join — SELECT a.DISCREPANCY_ATTR_ID, a.ATTRIBUTE_NAME, a.DISCREPANCY_RULE_CD, c.SRC_CAT_ID FROM IGS_AD_DSCP_ATTR a JOIN IGS_AD_SOURCE_CAT_ALL c ON a.SRC_CAT_ID = c.SRC_CAT_ID;
• Business-key enforcement check — querying by SRC_CAT_ID and ATTRIBUTE_NAME to detect duplicates that would violate IGS_AD_DSCP_ATTR_UK.
• Audit reporting — filtering by LAST_UPDATE_DATE to trace recent changes during migration cutover windows.

These patterns are useful for reconciliation and impact analysis rather than ongoing operational processing.

Related Objects

The following objects are most significant in relation to IGS_AD_DSCP_ATTR:

• IGS_AD_SOURCE_CAT_ALL — referenced via SRC_CAT_ID; the parent discrepancy source category table.
• IGS_AD_DSCP_ATTR_PK — the primary key constraint over DISCREPANCY_ATTR_ID.
• IGS_AD_DSCP_ATTR_UK — the unique constraint over SRC_CAT_ID and ATTRIBUTE_NAME.
• IGS_AD_DSCP_ATTR_U1 — unique index supporting the primary key.
• IGS_AD_DSCP_ATTR_U2 — unique index supporting the business-key candidate.

Together these objects define the integrity and relationship surface of the table within the IGS Student System schema.