Search Results curriculum_id




Overview
Explore in AI Chat

Overview

The IGS_PS_UNT_CRCLM_ALL table is a master data table within the Oracle E-Business Suite (EBS) 12.1.1/12.2.2, specifically for the Oracle Student Management (formerly Campus Solutions) product. It functions as a curriculum identifier master, providing a stable, unique key to link different versions of an academic unit when the unit's code changes over time. This design is critical for maintaining historical data integrity and for facilitating mandated state reporting, as noted in the documentation. The table is multi-org enabled via the ORG_ID column, allowing it to store data for multiple operating units within a single installation.

Key Information Stored

The table's structure is focused on defining and managing the lifecycle of a curriculum identifier. The primary and most critical column is CURRICULUM_ID (VARCHAR2(10)), which serves as the unique master unit identifier. The DESCRIPTION (VARCHAR2(80)) provides the human-readable name for the identifier. The CLOSED_IND (VARCHAR2(1)) flag controls the active status of the curriculum ID, indicating whether it is available for new associations. Standard EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) provide audit trails, and the ORG_ID (NUMBER(15)) segregates data by operating unit.

Common Use Cases and Queries

A primary use case is tracing the evolution of a unit across code changes for accurate historical reporting and transcript generation. Administrators also query this table to manage which curriculum IDs are available for assignment to new unit versions. Common SQL patterns include retrieving all active curriculum IDs for a specific operating unit or finding the description for a known identifier used in reporting.

  • Retrieve all active curriculum masters for a specific org: SELECT CURRICULUM_ID, DESCRIPTION FROM IGS_PS_UNT_CRCLM_ALL WHERE CLOSED_IND = 'N' AND ORG_ID = :org_id ORDER BY CURRICULUM_ID;
  • Find all unit versions linked to a specific curriculum ID (joining to the related unit version table): SELECT uv.UNIT_CD, uv.VERSION_NUMBER FROM IGS_PS_UNIT_VER_ALL uv WHERE uv.CURRICULUM_ID = :curriculum_id;

Related Objects

The table has a defined primary key constraint, IGS_PS_UNT_CRCLM_ALL_PK, on the CURRICULUM_ID column. It serves as a parent table in a key relationship within the Student Management schema. The documented foreign key relationship shows that the IGS_PS_UNIT_VER_ALL table references this master table. Specifically, the CURRICULUM_ID column in IGS_PS_UNIT_VER_ALL is a foreign key pointing to IGS_PS_UNT_CRCLM_ALL.CURRICULUM_ID. This establishes that individual unit versions (IGS_PS_UNIT_VER_ALL) are linked to a persistent master curriculum identifier stored in this table.