Results for “curriculum_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_PS_UNT_CRCLM_ALL is an Oracle E-Business Suite table owned by the IGS schema and delivered as part of the Student System product family (IGS). Functionally, it describes the master unit identifier for units within the curriculum. In practical terms, it acts as the curriculum container header that anchors the versioning structure of academic program units, allowing multiple version records to be grouped under a single master curriculum identifier.

The object carries a status of VALID in the documented ETRM 12.1.1 physical schema, which records nine columns. A heuristic Data Vault classification mined from the foreign-key structure characterizes this table as hub-leaning. As a modeling suggestion, this indicates the table behaves as a durable, business-key-bearing parent entity whose primary key is referenced by dependent version satellites, rather than as a transactional intersection or a descriptive child.

Key Information Stored

The table contains nine documented columns. The most important are:

• CURRICULUM_ID — the master unit identifier that serves as the primary key column of the IGS_PS_UNT_CRCLM_ALL_PK constraint and the sole column of the unique index IGS_PS_UNT_CRCLM_ALL_U1. It is simultaneously the surrogate primary key and the business-key candidate, which is why downstream version records can join to it directly.
• DESCRIPTION — the descriptive label for the master unit curriculum, used in inquiry screens and reports where the numeric identifier alone would be unhelpful.
• CLOSED_IND — a status flag indicating whether the master unit curriculum is closed to further versioning or enrollment activity.
• ORG_ID — the multi-org operating unit discriminator that scopes the record to a specific organization, enabling row-level security in a multi-organization deployment.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN form the standard EBS who-column set, recording insert and update lineage for every row.

The distinction between surrogate and business key is nominal here: CURRICULUM_ID is documented as both the enforced primary key and the only unique business-key candidate, so no alternate natural key exists for this entity.

Common Use Cases and Queries

Typical use cases involve resolving a master curriculum to its descriptive attributes and enumerating the versions that belong to it. A representative query resolves the header:

• SELECT curriculum_id, description, closed_ind, org_id FROM igs.igs_ps_unt_crclm_all WHERE curriculum_id = :p_id;
• SELECT c.curriculum_id, c.description, v.unit_version_id FROM igs.igs_ps_unt_crclm_all c JOIN igs.igs_ps_unit_ver_all v ON v.curriculum_id = c.curriculum_id WHERE c.closed_ind = 'N';

Reporting scenarios include listing open master units by organization, auditing recently created or amended curricula using the LAST_UPDATE_DATE column, and driving version-history extracts by joining to the history-all table. Because ORG_ID scopes the row, any reporting SQL crossing operating units should filter or group by ORG_ID to avoid double counting.

Related Objects

The table participates in a parent-child relationship with version-level objects that carry CURRICULUM_ID as a foreign key back to this master:

• IGS_PS_UNIT_VER_ALL — the primary dependent, joining on CURRICULUM_ID = CURRICULUM_ID; holds each version of the unit under the master.
• IGS_PS_UNIT_VER_HIST_ALL — the historical counterpart of the version table, also keyed by CURRICULUM_ID, used for audit and point-in-time reporting.
• IGS_PS_LGCY_UV_INT — the legacy unit-version interface table, referencing CURRICULUM_ID, used during data migration and conversion.
• The primary key constraint IGS_PS_UNT_CRCLM_ALL_PK and unique index IGS_PS_UNT_CRCLM_ALL_U1, both on CURRICULUM_ID.

Applications and concurrent programs in the Student System that define, approve, and maintain unit curricula depend on this table as the authoritative master registry for the curriculum identifier.