Search Results igs_ps_unit_dscp_pk

Overview

The IGS_PS_UNIT_DSCP table is a core data object within the Oracle E-Business Suite Student System (IGS). It serves as a mapping entity that formally associates academic units (subjects or courses) with specific discipline areas. Its primary role is to enable the classification and reporting of a unit's academic focus, which is critical for curriculum management, accreditation reporting, and institutional research. The table supports a flexible model where a single unit can be associated with multiple discipline groups, with the optional ability to allocate a percentage weighting to each. This functionality is essential for accurately representing interdisciplinary courses within the student information system.

Key Information Stored

The table's structure is defined by a composite primary key, ensuring a unique relationship between a unit, its version, and a discipline. The key columns are UNIT_CD and VERSION_NUMBER, which together identify a specific version of a unit of study, and DISCIPLINE_GROUP_CD, which identifies the associated discipline classification code. While the provided metadata does not list all columns explicitly, the description indicates the likely presence of a column such as PERCENTAGE_ALLOCATION to manage the proportional distribution of a unit's focus across multiple disciplines. This design allows the system to record complex academic structures where a unit may contribute to several fields of study.

Common Use Cases and Queries

A primary use case is generating reports for academic governance or external bodies that require analysis of course offerings by discipline area. For instance, an institution may need to list all units associated with a 'Computer Science' discipline for a program review. Another critical scenario is validating unit setup during curriculum creation, ensuring all required discipline mappings are present. Common SQL queries involve joining to the unit and discipline master tables to produce readable reports.

• Listing all disciplines for a specific unit: SELECT dscp.discipline_group_cd FROM igs_ps_unit_dscp dscp WHERE dscp.unit_cd = 'MATH101' AND dscp.version_number = 1;
• Finding all units within a given discipline for a reporting period: SELECT uv.unit_cd, uv.title FROM igs_ps_unit_ver_all uv JOIN igs_ps_unit_dscp ud ON uv.unit_cd = ud.unit_cd AND uv.version_number = ud.version_number WHERE ud.discipline_group_cd = 'ENG';

Related Objects

The IGS_PS_UNIT_DSCP table maintains integral relationships with master reference tables in the Student System, ensuring data integrity through foreign key constraints.

• IGS_PS_UNIT_VER_ALL: This is the master table for unit versions. IGS_PS_UNIT_DSCP references it via the columns UNIT_CD and VERSION_NUMBER. This ensures that a discipline can only be assigned to a valid, existing unit version.
• IGS_PS_DSCP_ALL: This is the master table for discipline group codes. IGS_PS_UNIT_DSCP references it via the DISCIPLINE_GROUP_CD column. This constraint guarantees that any discipline assigned to a unit is defined in the institution's official list of discipline groups.

The table itself is referenced by its primary key constraint, IGS_PS_UNIT_DSCP_PK, and is a likely parent to other transactional or reporting entities within the IGS module, though specific child tables are not detailed in the provided metadata.