Search Results igsfv_student_prg_transfers

Overview

IGSFV_STUDENT_PRG_TRANSFERS is a read-only Oracle E-Business Suite view belonging to the IGS (Student System) product family. Within the ETRM documentation it is classified under the notation "IGS - Student System (Obsolete)," indicating that the object originates from the legacy Student System data model and is not implemented in current 12.1.1 / 12.2.2 environments. Its stated purpose is to expose "the student program attempt transfers" — that is, records in which a student's prior or external program attempt is recognized as a transfer against a program of study.

The view is not a stored table. The ETRM entry explicitly records "Not implemented in this database," and the referenced base objects list is empty. This means the view is documented as part of the historical IGS schema but is absent from the shipped database. Consequently it plays no active role in current reporting or integration; its value is as a reference artefact for understanding the structure and relationships that existed in the legacy Student System.

Underlying Base Objects

Although the ETRM metadata records no referenced base objects, the documented view text defines the joins unambiguously. The view is built over seven underlying objects:

• IGS_PS_STDNT_TRN PST — the student transfer table, providing the driving rows for person, course, transfer course, dates, flags, and status.
• HZ_PARTIES HP — the party (person) master, joined on PERSON_ID = PARTY_ID to supply party number and name.
• IGS_EN_STDNT_PS_ATT_ALL SCA — the student program attempt, joined on PERSON_ID and COURSE_CD to validate the source attempt and its version.
• IGS_EN_STDNT_PS_ATT_ALL SCA1 — a second alias of the same attempt object, joined on PERSON_ID and TRANSFER_COURSE_CD to identify the receiving/transferred attempt.
• IGS_PS_VER_ALL PSV and IGS_PS_VER_ALL PSV1 — the program version objects supplying the source and transfer program titles respectively, joined on COURSE_CD and VERSION_NUMBER.
• IGS_CA_INST_ALL CI — the calendar instance, outer-joined on EFFECTIVE_TERM_CAL_TYPE and EFFECTIVE_TERM_SEQUENCE_NUM to resolve the effective term description.

The final clause "WITH READ ONLY" confirms the view's non-updatable character.

Key Columns

The projected column list combines transfer attributes, party information, program titles, and audit fields:

• PERSON_IDENTIFIER / PERSON_NUMBER / PERSON_NAME — the student's identifier, party number, and display name from HZ_PARTIES.
• PROGRAM_CODE / PROGRAM_TITLE — the source program course code and its version title.
• TRANSFER_PROGRAM_CODE / TRANSFER_PROGRAM_TITLE — the destination transfer program and its title.
• TRANSFER_DATE / APPROVED_DATE / COMMENTS — transfer timing, approval milestone, and free-text notes.
• EFFECTIVE_TERM_CAL_TYPE / EFFECTIVE_TERM_SEQUENCE_NUM / EFFECTIVE_TERM_CAL_DESC — the calendar type, sequence number, and resolved calendar instance description for the effective term.
• DISCONTINUE_SOURCE_FLAG / TRANSFER_ADV_STAND_FLAG — indicators governing whether the source attempt is discontinued and whether advanced standing applies.
• UOOIDS_TO_TRANSFER / SUSA_TO_TRANSFER — unit-of-study and student-unit identifiers carried across as credit.
• STATUS_FLAG / STATUS_DATE — the current processing state of the transfer and the date it was set.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard audit columns.

Common Use Cases and Queries

In legacy implementations this view supported student transfer reporting, credit recognition checks, and integration extracts into downstream records. Because the object is not implemented in 12.1.1 or 12.2.2, queries against it will fail with an "object does not exist" error and are presented here only illustratively.

A typical listing of transfers for a student:

• SELECT person_number, person_name, program_code, transfer_program_code, transfer_date, status_flag FROM igsfv_student_prg_transfers WHERE person_id = :p_person_id;

Extracting approved transfers for a term:

• SELECT program_code, transfer_program_code, transfer_date, effective_term_cal_desc FROM igsfv_student_prg_transfers WHERE approved_date IS NOT NULL AND effective_term_cal_type = :cal_type AND effective_term_sequence_num = :seq;

Summarizing advanced standing transfers:

• SELECT transfer_program_code, COUNT(*) FROM igsfv_student_prg_transfers WHERE transfer_adv_stand_flag = 'Y' GROUP BY transfer_program_code;

For current environments, equivalent functionality must be sourced from the supported Student System tables, since this documented view remains only as a historical reference in the ETRM catalogue.