Results for “igs_ps_unit”

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

Overview

IGS_PS_UNIT is a foundational reference table within the Oracle E-Business Suite Student System (IGS) module, which is classified in the ETRM documentation as obsolete. The table stores the codes allocated to units offered by a university — a "unit" in the IGS context being equivalent to a course, subject, or module offered within an academic program. Each row represents one distinct unit identified by its unit code, serving as the master definition from which fee assessment, program-of-study enrollment, personal exclusion, requirement tracking, and student unit attempt records all derive their unit references.

The documented implementation note states that the object is "Not implemented in this database," meaning that in the specific instance captured by the ETRM extract the table was not physically present, though its definition and relationships remain documented for reference and impact analysis. The documented physical schema confirms an owner of IGS with six columns in release 12.1.1.

Based on the foreign key structure, the ETRM metadata carries a heuristic Data Vault classification of hub-leaning. This is a modeling suggestion: the table presents itself as a candidate hub because it holds a stable, unique business key (UNIT_CD) that is referenced by numerous downstream tables, with no obvious parent dependency of its own within the documented relationships.

Key Information Stored

The six documented columns fall into two functional groups: the business identifier and standard EBS audit/who columns.

• UNIT_CD — The unit code allocated to a unit offered by the university. This is the central business attribute of the table and the sole documented primary key column.
• CREATED_BY — The user or process that created the record.
• CREATION_DATE — The date on which the record was created.
• LAST_UPDATED_BY — The user or process responsible for the most recent update.
• LAST_UPDATE_DATE — The timestamp of the most recent update.
• LAST_UPDATE_LOGIN — The login identifier associated with the most recent update.

Regarding key structure: the surrogate/primary key is defined as IGS_PS_UNIT_PK, composed of the single column UNIT_CD. A unique index, IGS_PS_UNIT_U1, is documented on UNIT_CD and serves as the business-key candidate — in this case the business key and the primary key coincide, which is characteristic of a lean hub-style definition.

Common Use Cases and Queries

The principal use case is establishing the canonical list of offered units and resolving unit references across the student system. Because many dependent tables carry UNIT_CD, a common reporting pattern is to join IGS_PS_UNIT to transactional or eligibility tables to obtain the descriptive context of the unit. A representative query retrieves all student unit attempts for a given unit:

• SELECT u.UNIT_CD, s.* FROM IGS_PS_UNIT u, IGS_PR_STDNT_PR_UNIT s WHERE u.UNIT_CD = s.UNIT_CD;
• SELECT f.UNIT_CD, f.FEE_AMOUNT FROM IGS_FI_FEE_AS_RATE f, IGS_PS_UNIT u WHERE f.UNIT_CD = u.UNIT_CD;
• SELECT p.UNIT_CD FROM IGS_PE_PERS_UNT_EXCL p, IGS_PS_UNIT u WHERE p.UNIT_CD = u.UNIT_CD;

Additional scenarios include auditing which units are referenced by requirement definitions (IGS_PE_UNT_REQUIRMNT), validating that all populated unit codes exist in the master list, and reconciling fee assessment rates against the defined unit set. Because the table is documented as obsolete and not implemented, any such queries should be treated as historical or migration reference patterns rather than executable against a current 12.2.2 instance.

Related Objects

The following are the most significant documented objects referencing IGS_PS_UNIT through the UNIT_CD column:

• IGS_PS_UNIT_VER_ALL — Version/alternate record for the unit, joined on UNIT_CD.
• IGS_FI_FEE_AS_RATE — Fee assessment rates applicable to the unit, joined on UNIT_CD.
• IGS_FI_FEE_AS_RT_H_ALL — Historical fee assessment rate records, joined on UNIT_CD.
• IGS_FI_UNIT_FEE_TRG — Unit fee trigger definitions, joined on UNIT_CD.
• IGS_PS_PAT_STUDY_UNT — Program-of-study unit associations, joined on UNIT_CD.
• IGS_PE_PERS_UNT_EXCL — Personal unit exclusions, joined on UNIT_CD.
• IGS_PE_UNT_REQUIRMNT — Unit requirement definitions, joined on UNIT_CD.
• IGS_PR_STDNT_PR_UNIT — Student program unit attempt records, joined on UNIT_CD.

All of these relationships reference IGS_PS_UNIT via the UNIT_CD column, reinforcing the table's role as a hub-leaning master definition within the IGS student data model.