Results for “igs_ps_unit_ofr”

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

Overview

IGS_PS_UNIT_OFR is a core table in the Oracle E-Business Suite Student System (IGS) product family, present in both release 12.1.1 and 12.2.2. It describes an offering of a unit within a calendar type. In practical terms, each row represents the decision to offer a specific version of a unit of study in a specific calendar type (for example, an academic period or teaching period), making the table the central reference point for downstream scheduling, enrollment, and assessment activity.

The table is owned by the IGS schema and is documented as VALID with eight physical columns. Its primary key, IGS_PS_UNIT_OFR_PK, is defined on the composite of UNIT_CD, VERSION_NUMBER, and CAL_TYPE, and a matching unique index (IGS_PS_UNIT_OFR_U1) exists on the same three columns. From a Data Vault modeling perspective, the mined foreign-key structure suggests a hub-leaning classification: the table appears to function primarily as a business-key container with attributes, rather than as a pure relationship (link) or change-history (satellite) structure. This classification is a heuristic suggestion derived from the documented key topology and should be validated against a full column-level assessment before being treated as authoritative.

Key Information Stored

The documented column set is compact, with the business identity carried entirely by the primary key columns:

• UNIT_CD — the code identifying the unit of study; part of the primary key and the FK to IGS_PS_UNIT_VER_ALL.
• VERSION_NUMBER — the version of the unit definition; part of the primary key and the FK to IGS_PS_UNIT_VER_ALL, ensuring the offering references a specific versioned unit.
• CAL_TYPE — the calendar type in which the unit is offered; part of the primary key and the FK to IGS_CA_TYPE.
• CREATED_BY, CREATION_DATE — standard audit columns recording the user and timestamp of initial row creation.
• LAST_UPDATED_BY, LAST_UPDATE_DATE — standard audit columns recording the user and timestamp of the most recent modification.
• LAST_UPDATE_LOGIN — the login/session identifier associated with the last update, supporting audit traceability.

The three key columns constitute both the surrogate primary key and the natural business-key candidate (via unique index IGS_PS_UNIT_OFR_U1). There is no single numeric surrogate column; the primary key is a composite of business attributes. The remaining columns are the standard Oracle Applications WHO columns (eight in total, as documented).

Common Use Cases and Queries

Typical reporting and integration scenarios revolve around identifying which unit versions are offered in which calendar types, and joining those offerings to patterns, notes, and teaching-load appointments. A basic listing of offerings might read:

• SELECT unit_cd, version_number, cal_type FROM igs_ps_unit_ofr WHERE cal_type = :cal_type;
• Join to IGS_CA_TYPE to resolve calendar descriptions: SELECT o.unit_cd, o.version_number, t.description FROM igs_ps_unit_ofr o, igs_ca_type t WHERE o.cal_type = t.cal_type;
• Join to IGS_PS_UNIT_VER_ALL to retrieve versioned unit attributes: SELECT o.unit_cd, o.version_number, v.* FROM igs_ps_unit_ofr o, igs_ps_unit_ver_all v WHERE o.unit_cd = v.unit_cd AND o.version_number = v.version_number;
• Locate pattern associations: SELECT p.* FROM igs_ps_unit_ofr_pat_all p WHERE p.unit_cd = :unit_cd AND p.version_number = :version_number AND p.cal_type = :cal_type;
• Check notes attached to an offering via IGS_PS_UNIT_OFR_NOTE using the same three key columns.

Because the offering keys flow into load appointments (IGS_ST_UNT_LOAD_APPO), this table is also a natural starting point for teaching-load and staff-activity reporting.

Related Objects

The documented foreign-key relationships identify the following significant dependencies:

• IGS_CA_TYPE — referenced via IGS_PS_UNIT_OFR.CAL_TYPE; supplies calendar type definitions.
• IGS_PS_UNIT_VER_ALL — referenced via UNIT_CD and VERSION_NUMBER; supplies versioned unit details.
• IGS_ST_UNT_LOAD_APPO — references this table through UNIT_CD, VERSION_NUMBER, and TEACH_CAL_TYPE; holds teaching-load appointment data.
• IGS_PS_UNIT_OFR_NOTE — references UNIT_CD, VERSION_NUMBER, and CAL_TYPE; stores notes attached to an offering.
• IGS_PS_UNIT_OFR_PAT_ALL — references UNIT_CD, VERSION_NUMBER, and CAL_TYPE; stores offering pattern associations.

These five objects represent the principal documented join paths; other IGS tables (such as enrollment and assessment structures) may reference unit offerings indirectly through related keys not enumerated in the metadata above.