Results for “igs_ps_unit_ver_all”

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

Overview

The IGS_PS_UNIT_VER_ALL table is a core entity within the Oracle E-Business Suite Student System (IGS) product family. It describes a specific version of a unit — the fundamental teaching and learning component offered by an academic institution. In the Oracle Student System data model, a unit is the smallest discrete element of study that a student can enroll in, and this table serves as the versioned master record that governs how that unit is configured, delivered, assessed, and funded for a given academic period.

Because every unit may undergo revisions across academic years, the table employs a compound business key of UNIT_CD and VERSION_NUMBER, allowing multiple versions of the same unit to coexist. The ETRM relationship data classifies this object, using a heuristic Data Vault analysis, as hub-leaning. That classification suggests a modeling approach in which IGS_PS_UNIT_VER_ALL functions as a central hub of unit-version identities, with the many transactional and descriptive tables that reference it acting as satellites or link structures. The object is owned by the IGS schema and is marked VALID in the documented 12.1.1 metadata, with 115 physical columns.

Key Information Stored

The table persists the identity, descriptive, academic, and administrative attributes of a unit version. Among the most significant columns are:

• UNIT_CD and VERSION_NUMBER — the compound primary key (IGS_PS_UNIT_VER_PK) and unique index (IGS_PS_UNIT_VER_ALL_U1) that uniquely identify a unit version.
• UNIT_STATUS — the current lifecycle status of the version, governed by IGS_PS_UNIT_STAT.
• UNIT_LEVEL — the academic level at which the unit is taught, referencing IGS_PS_UNIT_LEVEL_ALL.
• TITLE and SHORT_TITLE — the formal and abbreviated display names of the unit.
• START_DT, END_DT, REVIEW_DT, and EXPIRY_DT — the effective dating that determines when the version is valid for offering and enrollment.
• CREDIT_POINT_DESCRIPTOR, ACHIEVABLE_CREDIT_POINTS, POINTS_MIN, and POINTS_MAX — the credit point structure associated with the unit.
• COORD_PERSON_ID — the unit coordinator, referencing HZ_PARTIES.
• OWNER_ORG_UNIT_CD and OWNER_OU_START_DT — the academic organizational unit that owns the version.
• CURRICULUM_ID — links the version to a curriculum record in IGS_PS_UNT_CRCLM_ALL.
• UNIT_TYPE_ID — the unit type classification, referencing IGS_PS_UNIT_TYPE_LVL.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE20 — descriptive flexfield columns for extensibility.

Common Use Cases and Queries

Typical reporting and integration scenarios include retrieving the currently active version of a unit, listing all versions for a unit across academic periods, and resolving unit details for enrollment, fee, or teaching-responsibility reporting.

• To find active versions: filter on UNIT_STATUS and compare SYSDATE against START_DT, END_DT, and EXPIRY_DT.
• To list version history for a unit: SELECT * FROM IGS.IGS_PS_UNIT_VER_ALL WHERE UNIT_CD = :p_unit_cd ORDER BY VERSION_NUMBER;
• To join enrollment records: SELECT e.*, u.TITLE FROM IGS.IGS_EN_SU_ATTEMPT_ALL e JOIN IGS.IGS_PS_UNIT_VER_ALL u ON e.UNIT_CD = u.UNIT_CD AND e.UV_VERSION_NUMBER = u.VERSION_NUMBER;
• To resolve the owning organizational unit and level: join to IGS_PS_UNIT_LEVEL_ALL on UNIT_LEVEL and to HZ_PARTIES on COORD_PERSON_ID.

Related Objects

The table participates in an extensive network of foreign key relationships, both as parent and child.

• IGS_PS_UNIT — the base unit definition; joined on UNIT_CD to retrieve unit-level attributes shared across versions.
• IGS_EN_SU_ATTEMPT_ALL — enrollment attempts; joined on UNIT_CD and SUP_UNIT_CD, central to student enrollment reporting.
• IGS_PS_UNIT_OFR_ALL — unit offerings, linking a version to teaching periods and delivery modes.
• IGS_PS_UNT_CRCLM_ALL — curriculum records referenced via CURRICULUM_ID.
• IGS_PS_UNIT_LEVEL_ALL and IGS_PS_UNIT_TYPE_LVL — classification lookups joined on UNIT_LEVEL and UNIT_TYPE_ID.
• IGS_FI_FEE_AS_RATE and IGS_FI_UNIT_FEE_TRG — fee assessment and fee trigger records keyed on UNIT_CD.
• IGS_PS_TCH_RESP — teaching responsibility assignments joined on UNIT_CD.
• HZ_PARTIES — the party master for the unit coordinator via COORD_PERSON_ID.

Because so many dependent objects reference this table, changes to a unit version record propagate widely across enrollment, fees, teaching, and assessment processes, making it a pivotal entity in the Student System model.