Search Results src_cat_id




Overview
Explore in AI Chat

Overview

The IGS_AD_DSCP_ATTR table is a core data definition table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (iGrad Student) product family, which is part of the Oracle Student Systems suite. This table functions as a master repository for defining and managing discrepancy attributes associated with admission source categories. Its primary role is to establish the configurable attributes used to validate and process application data against defined business rules during the admissions lifecycle. By linking attributes to specific source categories, it enables the system to apply targeted discrepancy checks, ensuring data integrity and adherence to admission criteria.

Key Information Stored

The table stores metadata that defines the relationship between admission categories and their validation attributes. The key columns include DISCREPANCY_ATTR_ID, which serves as the unique primary key identifier for each attribute record. The SRC_CAT_ID column holds the foreign key linking the attribute to its specific admission source category. The ATTRIBUTE_NAME column defines the name of the attribute being tracked (e.g., GPA, Test Score, Prerequisite). The DISCREPANCY_RULE_CD column specifies the business rule code that governs how discrepancies for this attribute are evaluated. The table is completed by standard Oracle EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for auditing purposes. The table's unique indexes enforce data integrity by preventing duplicate attribute IDs (IGS_AD_DSCP_ATTR_U1) and duplicate combinations of source category and attribute name (IGS_AD_DSCP_ATTR_U2).

Common Use Cases and Queries

This table is central to the setup and execution of admissions discrepancy management. Common use cases include the initial configuration of validation rules for different applicant categories, the generation of discrepancy reports for admissions officers, and the programmatic validation of incoming application data. A fundamental query retrieves all attributes defined for a specific source category, which is essential for building dynamic validation logic. For example:

  • Retrieve All Attributes for a Category: SELECT ATTRIBUTE_NAME, DISCREPANCY_RULE_CD FROM IGS.IGS_AD_DSCP_ATTR WHERE SRC_CAT_ID = <category_id> ORDER BY ATTRIBUTE_NAME;
  • Audit Configuration Changes: SELECT ATTRIBUTE_NAME, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM IGS.IGS_AD_DSCP_ATTR WHERE TRUNC(LAST_UPDATE_DATE) = TRUNC(SYSDATE);
  • Validate Setup for Reporting: SELECT SRC_CAT_ID, COUNT(DISCREPANCY_ATTR_ID) FROM IGS.IGS_AD_DSCP_ATTR GROUP BY SRC_CAT_ID;

Related Objects

Based on the provided dependency information, the IGS_AD_DSCP_ATTR table is referenced by an object within the APPS schema named IGS_AD_DSCP_ATTR. This is typically a public synonym that points to the IGS-owned table, allowing other application modules and custom code in the APPS schema to access it seamlessly. While the explicit foreign key relationship to the table containing source categories (likely named IGS_AD_SRC_CAT or similar) is not detailed in the metadata, the SRC_CAT_ID column logically references the primary key of such a master category table. This table is foundational for any downstream processes or user interfaces that manage or report on admission discrepancies.