Search Results igs_ad_dscp_attr

Overview

The table IGS_AD_DSCP_ATTR is a core data structure within the Oracle E-Business Suite (EBS) Student System (IGS) module. It functions as a repository for defining and managing specific attributes associated with source categories. Its primary role is to support the configuration and validation of data by holding metadata that describes which attributes are relevant or required for a given category. This table is essential for maintaining data integrity and enforcing business rules during processes like admissions, where data from various sources must be standardized and checked for discrepancies.

Key Information Stored

The table stores the metadata definitions for category-specific attributes. The key columns, as indicated by its constraints, are critical for its operation. The DISCREPANCY_ATTR_ID column serves as the unique primary key identifier for each attribute record. The SRC_CAT_ID column is a foreign key that links the attribute to its parent source category defined in the IGS_AD_SOURCE_CAT_ALL table. The ATTRIBUTE_NAME column stores the actual name or code of the attribute being defined for that category. Together, the combination of SRC_CAT_ID and ATTRIBUTE_NAME is enforced as a unique key, ensuring that an attribute name is not duplicated within the same source category.

Common Use Cases and Queries

A primary use case is the setup and maintenance of discrepancy checking rules within the admissions lifecycle. Administrators can configure which data points (attributes) are mandatory or subject to validation for different categories of application sources or document types. For reporting and system queries, common patterns include retrieving all attributes for a specific source category or validating if a particular attribute is active for a category. Sample SQL to list all attribute names for a source category would be:

SELECT ATTRIBUTE_NAME
FROM IGS.IGS_AD_DSCP_ATTR
WHERE SRC_CAT_ID = :p_src_cat_id
ORDER BY ATTRIBUTE_NAME;

Another common query involves joining with the source category table to get a descriptive report:

SELECT scat.SOURCE_CAT_NAME, dattr.ATTRIBUTE_NAME
FROM IGS.IGS_AD_DSCP_ATTR dattr,
     IGS.IGS_AD_SOURCE_CAT_ALL scat
WHERE dattr.SRC_CAT_ID = scat.SRC_CAT_ID
ORDER BY 1, 2;

Related Objects

The table has a direct and documented dependency on the source category master table. The primary relationship is defined by a foreign key constraint:

• IGS_AD_SOURCE_CAT_ALL: This is the parent table. The IGS_AD_DSCP_ATTR.SRC_CAT_ID column references the SRC_CAT_ID in IGS_AD_SOURCE_CAT_ALL. This relationship ensures that every attribute record is associated with a valid, pre-defined source category. Any integration, data load, or validation process involving discrepancy attributes will typically require a join to this parent table to resolve the category name or context.