Results for “unit_set_cd”

50+ results




Overview
Explore in AI Chat

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

Overview

The IGS_EN_UNITSETPSTYPE table belongs to the IGS – Student System product family, historically deployed within Oracle E-Business Suite releases 12.1.1 and 12.2.2. It is documented by ETRM as an obsolete object, and its schema owner is IGS. Functionally, the table captures course type restrictions that apply to a given unit set. A unit set represents a grouped collection of units that a student must complete to satisfy a program or pathway requirement. By defining records in IGS_EN_UNITSETPSTYPE, an institution limits which course versions may be linked to a unit set; when no rows exist for a particular unit set, the IGS application applies no restriction at all and the unit set remains open to any eligible course version.

From a dimensional modeling perspective, the ETRM heuristic Data Vault classification for this object is that of a link. This suggestion reflects the object's structure: its primary key is composed exclusively of foreign key columns that connect three distinct business entities — a unit set, its version, and a course type. The link classification is a modeling recommendation, not an assertion of physical design, and should be validated against the institution's actual integration and reporting patterns.

Key Information Stored

The documented physical schema comprises eight columns, of which three participate in the primary key and unique business key. The columns most material to interpretation and querying are:

  • UNIT_SET_CD — The unit set identifier that the restriction governs. This is a foreign key referencing IGS_EN_UNIT_SET_ALL and is the leading component of the composite primary key.
  • VERSION_NUMBER — The version of the unit set to which the restriction applies. It joins with UNIT_SET_CD to reference IGS_EN_UNIT_SET_ALL, acknowledging that unit sets are versioned entities.
  • COURSE_TYPE — The course type being restricted or permitted. This is a foreign key to IGS_PS_TYPE_ALL and is the column that carries the actual restriction semantics.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — The standard Oracle EBS audit columns recording who created and last modified the row, and when.

The surrogate identifier is defined by the primary key constraint IGS_EN_UNITSETPSTYPE_PK over (UNIT_SET_CD, VERSION_NUMBER, COURSE_TYPE). The unique index IGS_EN_UNITSETPSTYPE_U1 spans the identical three columns, confirming them as the business-key candidates. There is no separate system-generated numeric key; the table relies on this natural composite key, which is characteristic of many IGS student system intersection tables.

Common Use Cases and Queries

The principal use case is validating whether a course version may be attached to a unit set during enrollment or program setup. Application logic consults the restriction rows before permitting the linkage. Reporting scenarios commonly include auditing which unit sets are restricted, identifying unit sets with course type boundaries that may block student progression, and reconciling restriction definitions against IGS_PS_TYPE_ALL.

A representative query to retrieve restrictions for a unit set is:

  • SELECT u.unit_set_cd, u.version_number, u.course_type, t.description FROM igs_en_unitsetpstype u, igs_ps_type_all t WHERE u.course_type = t.course_type AND u.unit_set_cd = :unit_set_cd;

A second pattern identifies unit sets with no restrictions, which by definition accept any course type:

  • SELECT s.unit_set_cd, s.version_number FROM igs_en_unit_set_all s WHERE NOT EXISTS (SELECT 1 FROM igs_en_unitsetpstype r WHERE r.unit_set_cd = s.unit_set_cd AND r.version_number = s.version_number);

Because the table is documented as obsolete and not implemented in the reference database, production queries should first confirm the object's presence and population in the target instance.

Related Objects

The following objects are the most significant associated entities based on the documented foreign key relationships:

  • IGS_EN_UNIT_SET_ALL — Parent entity for UNIT_SET_CD and VERSION_NUMBER; holds the unit set definition that the restriction constrains.
  • IGS_PS_TYPE_ALL — Parent entity for COURSE_TYPE; provides the course type description and validation for restricted values.
  • IGS_EN_UNITSETPSTYPE_PK — The primary key constraint enforcing uniqueness of the three-column composite key.
  • IGS_EN_UNITSETPSTYPE_U1 — The unique index defining the business-key candidate on (UNIT_SET_CD, VERSION_NUMBER, COURSE_TYPE).

Additional dependent objects include the course version and unit set version entities that participate in the enrollment linkage process, and any concurrent program or API that creates unit set associations within the IGS student system. Each of these ultimately resolves restriction decisions through the rows stored in IGS_EN_UNITSETPSTYPE.