Results for “igs_en_splacements”

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

Overview

IGS_EN_SPLACEMENTS is a transactional table within the Oracle E-Business Suite Student System (IGS) module, which is documented as obsolete in current EBS 12.1.1 and 12.2.2 environments. The table stores placement information associated with a student unit attempt, capturing records where a student's learning occurs at an external location, institution, or supervised setting rather than through standard on-campus delivery. Each row represents a single placement episode tied to a person, course, and unit offering option.

From a dimensional modeling perspective, the mined foreign key structure suggests a satellite-leaning classification. The table carries descriptive, time-bounded attributes about a specific placement event and is anchored to parent entities through its foreign keys, which is characteristic of satellite behavior attached to a core hub or link. This classification should be treated as a design suggestion rather than a documented Oracle construct, since IGS_EN_SPLACEMENTS is a conventional relational table.

The table is marked as not implemented in the reference database, meaning it exists in the ETRM data model definition but may not be physically present in every environment. Its presence depends on whether the obsolete Student System components were ever deployed.

Key Information Stored

The surrogate primary key is SPLACEMENT_ID, enforced by the IGS_EN_SPLACEMENTS_PK unique index. Two additional unique indexes define business-key candidates:

• IGS_EN_SPLACEMENTS_U1 — PERSON_ID, COURSE_CD, UOO_ID: uniquely identifies a placement by student, course, and unit offering option.
• IGS_EN_SPLACEMENTS_U2 — PERSON_ID, INSTITUTION_CODE, TITLE, START_DATE: identifies a placement by student, host institution, title, and commencement date.

The most significant descriptive columns include:

• PERSON_ID — the student or person undertaking the placement; joins to IGS_EN_SU_ATTEMPT_ALL.
• COURSE_CD and UOO_ID — the course and unit offering option context for the placement.
• INSTITUTION_CODE — the external or host institution where the placement occurs.
• TITLE and DESCRIPTION — human-readable identification of the placement.
• START_DATE and END_DATE — the effective period of the placement.
• CATEGORY_CODE, PLACEMENT_TYPE_CODE, and SPECIALTY_CODE — classification attributes describing the nature of the placement.
• COMPENSATION_FLAG — indicates whether the placement is compensated.
• ATTENDANCE_TYPE — references IGS_EN_ATD_TYPE_ALL, describing the attendance mode.
• LOCATION and NOTES — free-form placement location and commentary.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

Typical reporting scenarios include tracking student placements by institution, auditing placement duration, and reconciling placement records against unit attempts. A representative query joining placements to the student unit attempt and attendance type follows:

• Extract active placements: SELECT s.SPLACEMENT_ID, s.PERSON_ID, s.TITLE, s.START_DATE, s.END_DATE FROM IGS_EN_SPLACEMENTS s WHERE SYSDATE BETWEEN s.START_DATE AND s.END_DATE;
• Join to unit attempts: SELECT s.SPLACEMENT_ID, a.PERSON_ID, a.COURSE_CD FROM IGS_EN_SPLACEMENTS s, IGS_EN_SU_ATTEMPT_ALL a WHERE s.PERSON_ID = a.PERSON_ID AND s.COURSE_CD = a.COURSE_CD AND s.UOO_ID = a.UOO_ID;
• Aggregate placements by host institution for external reporting: SELECT INSTITUTION_CODE, COUNT(*) FROM IGS_EN_SPLACEMENTS GROUP BY INSTITUTION_CODE;
• List faculty and supervisors assigned to a placement via the child tables IGS_EN_SPLACE_FACS and IGS_EN_SPLACE_SUPS.

Related Objects

IGS_EN_SPLACEMENTS participates in a defined foreign key network:

• IGS_EN_SU_ATTEMPT_ALL — parent via PERSON_ID, COURSE_CD, and UOO_ID; the student unit attempt that the placement supports.
• IGS_EN_ATD_TYPE_ALL — parent via ATTENDANCE_TYPE; supplies the attendance mode reference.
• IGS_EN_SPLACE_FACS — child table referencing SPLACEMENT_ID; records faculty associated with a placement.
• IGS_EN_SPLACE_SUPS — child table referencing SPLACEMENT_ID; records supervisors associated with a placement.

Because the module is obsolete, no supported public APIs are documented in the ETRM metadata; integration should rely on direct SQL against these tables where they remain physically present.