Search Results igs_ps_stdnt_trn




Overview
Explore in AI Chat

Overview

IGS_PS_STDNT_TRN is a legacy table belonging to the IGS - Student System product family within Oracle E-Business Suite. The ETRM metadata explicitly identifies this product as obsolete, and the table itself is documented as "Not implemented in this database," meaning it does not exist in a standard Oracle EBS 12.1.1 or 12.2.2 installation. It survives as a reference artifact for historical data models and for customers who may have custom or pre-upgrade deployments derived from earlier Oracle Student System releases.

The entity describes the link between two programs (courses) in which a student was involved during a program transfer. When a learner moves from one programme of study to another, this table captures the origin programme, the destination programme, and the effective transfer date, thereby establishing the audit chain between the two academic records. In Data Vault modeling terms, the metadata's heuristic classification is satellite-leaning. That classification should be treated as a modeling suggestion: the table's composite key primarily describes an event/relationship between two student-programme associations, suggesting it could be modeled as a link with descriptive satellite attributes, or as a link-satellite hybrid given its rich non-key payload (flags, UOO identifiers, status).

Key Information Stored

The table carries 19 documented columns. The primary key, IGS_PS_STDNT_TRN_PK, is defined over the composite of PERSON_ID, COURSE_CD, TRANSFER_COURSE_CD, and TRANSFER_DT. The unique index IGS_PS_STDNT_TRN_U1 mirrors this same column set, making it the business-key candidate; there is no separate single-column surrogate identifier documented.

Common Use Cases and Queries

Because the object is obsolete, production use cases are limited to historical reporting, data migration, and upgrade remediation. A typical query reconstructs a student's transfer history by joining to the enrollment attempt table:

  • Trace the transfer chain for a person: SELECT course_cd, transfer_course_cd, transfer_dt, status_flag FROM igs_ps_stdnt_trn WHERE person_id = :p_person_id ORDER BY transfer_dt;
  • Reconcile transfers against enrollment records using the FK on PERSON_ID and COURSE_CD to IGS_EN_STDNT_PS_ATT_ALL.
  • Report advanced-standing grants by filtering on TRANSFER_ADV_STAND_FLAG.
  • Drive term-based reporting by joining EFFECTIVE_TERM_CAL_TYPE and EFFECTIVE_TERM_SEQUENCE_NUM to IGS_CA_INST_ALL.
  • Migrate carry-forward unit data by parsing UOOIDS_TO_TRANSFER and SUSA_TO_TRANSFER into the successor enrollment structures.

Related Objects

  • IGS_EN_STDNT_PS_ATT_ALL — referenced via PERSON_ID/COURSE_CD and PERSON_ID/TRANSFER_COURSE_CD; the primary enrollment anchor.
  • IGS_CA_INST_ALL — referenced via EFFECTIVE_TERM_CAL_TYPE and EFFECTIVE_TERM_SEQUENCE_NUM for calendar/term validation.
  • IGS_PS_STDNT_UNT_TRN — the unit-level counterpart, referencing this table on PERSON_ID, COURSE_CD, TRANSFER_COURSE_CD, and TRANSFER_DT.
  • IGS_PS_STDNT_TRN_PK / IGS_PS_STDNT_TRN_U1 — the primary-key constraint and unique business-key index.