Search Results transfer_dt

Overview

IGS.IGS_PS_STDNT_UNT_TRN is a transactional table in the Oracle EBS Student System (IGS) schema that records the association between a student's prior unit enrollment and the unit into which that enrollment was transferred following a program transfer. While the table name suggests a general student unit record, the documented columns and comments establish its precise purpose: it describes the link between two units involved in a student's program transfer. Each row captures the person, the originating program attempt, the destination program attempt, the unit code, the teaching calendar context, and the effective transfer date.

The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, consistent with transactional data objects in EBS 12.1.1 and 12.2.2. The ETRM metadata classifies this object heuristically as a link in Data Vault modeling terms. That classification is a modeling suggestion rather than a physical attribute: the table's composite primary key spanning multiple foreign key references makes it a natural connector between person and attempt entities rather than a source of descriptive history on its own.

Key Information Stored

The 13 documented columns carry both business keys and audit metadata. The most significant include:

• PERSON_ID (NUMBER, 15) — identifies the person whose units were transferred. This column participates in the primary key and in both documented foreign keys.
• COURSE_CD — the program code of the program attempt record receiving the transferred unit.
• TRANSFER_COURSE_CD — the program code of the program attempt record from which the unit was transferred.
• TRANSFER_DT (DATE) — the date on which the unit was transferred to the new program attempt record. This is the column most frequently searched by users and is a primary key component.
• UNIT_CD (VARCHAR2, 10) — identifies the unit included in the program.
• UOO_ID (NUMBER) — the Unit Section Identifier; it also participates in the primary key.
• CAL_TYPE (VARCHAR2, 10) — the teaching calendar type, such as SEM-1 or YR-LONG.
• CI_SEQUENCE_NUMBER (NUMBER) — uniquely identifies the calendar instance.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Who columns recording row audit information.

The documented unique index IGS_PS_STDNT_UNT_TRN_PK covers PERSON_ID, COURSE_CD, TRANSFER_COURSE_CD, TRANSFER_DT, and UOO_ID. There is no separate surrogate key column; the composite business-key candidate serves directly as the primary key, which also means each transfer event is uniquely distinguished by date together with the person, both program codes, and the unit section.

Common Use Cases and Queries

Typical uses center on tracking and auditing program transfers for students. Common scenarios include reconstructing the transfer history for a person, identifying which units moved into a new program and when, and reconciling enrollment counts across programs. A search phrased around transfer_dt generally maps to filtering or ordering by the effective transfer date.

• Retrieve all transfers for a person ordered by transfer date: SELECT * FROM IGS.IGS_PS_STDNT_UNT_TRN WHERE PERSON_ID = :p_id ORDER BY TRANSFER_DT;
• List units transferred within a date range for reporting: SELECT PERSON_ID, UNIT_CD, COURSE_CD, TRANSFER_COURSE_CD, TRANSFER_DT FROM IGS.IGS_PS_STDNT_UNT_TRN WHERE TRANSFER_DT BETWEEN :start_dt AND :end_dt;
• Find transfers between specific programs: ... WHERE COURSE_CD = :to_course AND TRANSFER_COURSE_CD = :from_course;
• Join to unit section or attempt data using PERSON_ID and UOO_ID to enrich the report with calendar and attempt detail.

These queries are typically embedded in enrollment audit reports, transfer reconciliation extracts, and data-migration validation scripts during upgrades between 12.1.1 and 12.2.2.

Related Objects

The documented foreign keys reference IGS_PS_STDNT_TRN and IGS_EN_SU_ATTEMPT_ALL through PERSON_ID, linking transfer records to student program attempt and the consolidated attempt entity. The object is referenced by the APPS synonym IGS_PS_STDNT_UNT_TRN, which is the access point used by reports and concurrent programs. Additional joins are commonly formed to unit and calendar definition tables via UNIT_CD, CAL_TYPE, and CI_SEQUENCE_NUMBER, and to person tables via PERSON_ID for descriptive reporting.