Search Results igs_da_cnfg

Overview

The IGS_DA_CNFG table is a core configuration table within the Oracle E-Business Suite Student System (IGS). It serves as the parent table for storing the configuration parameters that govern the capabilities and behavior of the Degree Audit Request screen. This table is essential for defining how degree audit requests are processed, determining which request types are available, and controlling access based on user responsibility and the type of person (e.g., student, applicant) being audited. Its configuration directly impacts the functional workflow for academic advising and program completion tracking.

Key Information Stored

The table's structure is defined by its primary and unique keys, which highlight the critical data points it manages. The primary key (IGS_DA_CNFG_PK) is a composite of REQUEST_TYPE_ID and RESPONSIBILITY_NAME. This enforces a rule that a specific degree audit request type is uniquely configured per user responsibility, allowing for tailored screen behavior across different functional roles. A second unique key (IGS_DA_CNFG_FTR_UK) is based on REQUEST_MODE and PERSON_TYPE, indicating these are also fundamental, non-duplicable configuration dimensions. While specific column datatypes are not detailed in the provided metadata, the logical model confirms the table stores the linkage between a request type, the user's responsibility, and the operational context (mode and person type) for the audit.

Common Use Cases and Queries

This table is primarily accessed for system setup and troubleshooting configuration issues within the Degree Audit module. A common administrative task is to identify all configured request types for a specific user responsibility to verify security and functional access. For example:

• To list all degree audit configurations for the 'Academic Advisor' responsibility, a query would join IGS_DA_CNFG to IGS_DA_CNFG_REQ_TYP on REQUEST_TYPE_ID.
• Support personnel might query for a specific configuration to diagnose why a request type is unavailable: SELECT * FROM igs.igs_da_cnfg WHERE responsibility_name = '&RESP_NAME' AND request_type_id = (SELECT request_type_id FROM igs_da_cnfg_req_typ WHERE code = '&REQ_CODE');
• Reporting on the overall configuration landscape across responsibilities and person types would also originate from this table.

Related Objects

The IGS_DA_CNFG table has a defined parent-child relationship with the IGS_DA_CNFG_REQ_TYP table, which likely stores the master list of available degree audit request types (e.g., 'Preliminary', 'Official', 'What-If').

• Foreign Key (Outgoing): IGS_DA_CNFG.REQUEST_TYPE_ID references IGS_DA_CNFG_REQ_TYP. This ensures every configuration record points to a valid, predefined request type.
• Foreign Key (Incoming): IGS_DA_CNFG_REQ_TYP.REQUEST_CONFIG_ID references IGS_DA_CNFG. This suggests a referential loop or a specific design where the request type master may optionally point back to a default configuration, though the exact cardinality is not specified.

This relationship is central; the configuration in IGS_DA_CNFG is meaningless without the request type definition it depends upon.