Search Results igs_ps_stdnt_unt_trn_pk

Overview

IGS_PS_STDNT_UNT_TRN is a legacy Student System table that resides in the IGS product schema. As indicated by its product designation, it belongs to the obsolete Oracle Student System (SIS) module rather than to the current Oracle Student Cloud or any supported EBS application. The table describes the linkage between two academic units that were involved in a program transfer transaction — that is, the originating unit a student was enrolled in and the destination unit into which the student transferred.

The ETRM metadata records this object as "Not implemented in this database," meaning the table is documented in the reference model but does not physically exist in a standard Oracle EBS 12.1.1 or 12.2.2 installation. It is retained for historical and reference purposes only. Based on the foreign key topology, the heuristic Data Vault classification for this object is a link table — it sits between the student transfer header and the student unit attempt records, resolving a many-to-many style association across transfer events.

Key Information Stored

The table is documented with thirteen columns at the physical level. The columns of greatest significance are:

• PERSON_ID — Identifies the student involved in the transfer. Part of the composite primary key and a foreign key to IGS_PS_STDNT_TRN and IGS_EN_SU_ATTEMPT_ALL.
• COURSE_CD — The originating course/unit code from which the student transferred.
• TRANSFER_COURSE_CD — The destination course/unit code into which the student transferred.
• TRANSFER_DT — The date on which the transfer took effect.
• UOO_ID — The unit offering option identifier, tying the transfer to a specific unit offering instance.
• UNIT_CD — The unit code associated with the transfer record.
• CAL_TYPE — The calendar type governing the unit occurrence.
• CI_SEQUENCE_NUMBER — A sequencing value used to order records within a calendar instance.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle WHO audit columns.

The documented primary key, IGS_PS_STDNT_UNT_TRN_PK, is a composite surrogate/business key spanning PERSON_ID, COURSE_CD, TRANSFER_COURSE_CD, TRANSFER_DT, and UOO_ID. This same set of columns forms the only unique index on the table, which means all five columns together constitute the business-key candidate; there is no separate system-generated single-column surrogate.

Common Use Cases and Queries

Typical reporting scenarios center on reconstructing a student's transfer history between units and reconciling that history with enrollment attempts. A representative query joining the transfer link to its parent header would resemble:

• Listing all transfers for a person within a date range, joining PERSON_ID and COURSE_CD back to IGS_PS_STDNT_TRN.
• Identifying the destination unit attempts by joining UOO_ID and PERSON_ID to IGS_EN_SU_ATTEMPT_ALL.
• Auditing transfer sequences by ordering on CAL_TYPE and CI_SEQUENCE_NUMBER.
• Producing institutional reporting on transfer volumes by COURSE_CD and TRANSFER_COURSE_CD pairings.

Because the object is obsolete and not implemented, these queries are relevant only to legacy data migrations, historical archive analysis, or conversion projects moving Student System data into a supported platform.

Related Objects

• IGS_PS_STDNT_TRN — Parent transfer header; joined on PERSON_ID and COURSE_CD.
• IGS_EN_SU_ATTEMPT_ALL — Student unit attempt records; joined on PERSON_ID, COURSE_CD, and UOO_ID.
• IGS_PS_STDNT_UNT_TRN_PK — The unique index enforcing the composite primary key.

Given the obsolete status, downstream dependencies are confined to legacy Student System code paths and migration scripts rather than active EBS concurrent programs or APIs.