Search Results subject_field_code




Overview
Explore in AI Chat

Overview

The view IGS_SV_EV_CRT_PRGM_V belongs to the IGS – Student System product family within Oracle E-Business Suite. Its documented purpose is to fetch program information for new Exchange Visitor students, supporting the Student System’s exchange visitor (SEVIS-related) processing and reporting flows. The view name segments reflect this role: “IGS_SV” (Student System / Student & Visitor), “EV” (Exchange Visitor), and “CRT_PRGM” (create program), indicating that it supplies program-creation attributes used when exchange visitor records are assembled.

From a reporting and integration standpoint, the view acts as a denormalized presentation layer: it flattens selected program attributes and re-labels one source column (REMARKS becomes SUBJECT_REMARKS) for downstream consumers. In Oracle EBS 12.1.1 and 12.2.2, such views are typically consumed by concurrent programs, OAF pages, or extracts rather than used directly by end users. Importantly, the ETRM metadata records this object as Obsolete and Not implemented in this database, so it will not resolve at runtime in the documented environment.

Underlying Base Objects

The view text references a single base object: IGS_SV_PRGMS_INFO (aliased PRGM). No other tables, views, or joins are documented, and the ETRM entry lists Referenced base objects: none documented. The absence of a join suggests a straightforward projection view over the program-information entity, with column aliasing applied at the view level.

Because IGS_SV_PRGMS_INFO is a Student System table holding exchange visitor program data, the view inherits its row grain directly. Each row in the view corresponds to one row in the base table for the selected attributes. There is no aggregation, filtering predicate, or grouping in the documented SELECT statement, so the view returns the full population of the underlying program-information records.

Key Columns

  • BATCH_ID — Identifier grouping program records into a processing batch, used to correlate a run of exchange visitor program creation or maintenance.
  • PERSON_ID — The party/person identifier for the student (exchange visitor) associated with the program record.
  • POSITION_CODE — The documented column most directly tied to the user’s search term. It carries the code denoting the individual’s position in the exchange visitor program context.
  • SUBJECT_FIELD_CODE — Code identifying the subject field or academic discipline tied to the program.
  • SUBJECT_REMARKS — Aliased from the base column REMARKS; free-text remarks associated with the subject field.

Common Use Cases and Queries

Typical scenarios include batch-oriented data verification, person-level program inspection, and code validation against lookup values. The following query retrieves position codes by person:

SELECT person_id, position_code, subject_field_code
FROM   igs_sv_ev_crt_prgm_v
WHERE  person_id = :p_person_id;

To review all records within a batch run:

SELECT batch_id, person_id, position_code, subject_remarks
FROM   igs_sv_ev_crt_prgm_v
WHERE  batch_id = :p_batch_id;

Because the view is documented as obsolete and not implemented, these queries serve reference and migration-assessment purposes only; production usage should target the current supported Student System objects.