Search Results prgm_end_date




Overview
Explore in AI Chat

Overview

APPS.IGS_SV_EV_MATRIC_BLK_V is a valid database view owned by the APPS schema in Oracle E-Business Suite, registered in FND Design Data as IGS.IGS_SV_EV_MATRIC_BLK_V. It belongs to the Student System (IGS) product family, specifically to the SEVIS (Student and Exchange Visitor Information System) integration components that support regulatory reporting to the United States government for international students and exchange visitors.

The view is documented as a Web view designed to simplify access from Oracle Self-Service Web Applications. Its functional purpose is to present matriculation updates for an Exchange Visitor record that is transmitted in an XML file to SEVIS. In this context, it acts as a reporting and staging surface: the Self-Service layer, or a concurrent program assembling the SEVIS batch, reads matriculation data from this view and renders it into the outbound XML payload. The view is described as a "block" view, implying it supplies a discrete data block — matriculation records for a batch of persons — rather than the entire SEVIS message.

Underlying Base Objects

Per the ETRM dependency metadata, APPS.IGS_SV_EV_MATRIC_BLK_V references the object APPS.IGS_SV_PRGMS_INFO. This base object supplies the program-level information from which the view derives its matriculation-related rows, including person identification, batch grouping, and, most relevant to the user's search term, the program end date. No further base tables or views are documented, and the view is not referenced by any other database object, confirming it functions as a terminal reporting surface rather than a building block for other views. It is important to note that the view is a Web view, so it may apply security predicates or row filtering enforced through the Self-Service framework rather than exposing the full contents of its underlying source. Because the documented dependency list is minimal, DBAs performing impact analysis should treat IGS_SV_PRGMS_INFO as the authoritative upstream object for change management.

Key Columns

The view exposes four columns, each defined as follows in the ETRM column metadata:

  • BATCH_ID (NUMBER, 14) — Batch identifier for the requested run. This groups all rows produced by a single SEVIS processing request, allowing the XML generator to isolate one transmission from another.
  • PERSON_ID (NUMBER, 15) — Person identifier for the student or exchange visitor in the request. This is the primary linkage to the person record and drives downstream lookups of name, SEVIS ID, and biographical data.
  • MATRICULATION (VARCHAR2) — Matriculation code. This is the SEVIS-defined value describing the exchange visitor's matriculation status or the matriculation action being reported.
  • PRGM_END_DATE (VARCHAR2, 10) — Program End Date. This is the column most directly tied to the user's search term. It is significant that the datatype is VARCHAR2(10) rather than DATE, indicating the value is stored and exposed as a character string, typically in a fixed ten-character format such as YYYY-MM-DD or MM/DD/YYYY, consistent with the literal rendering required in an XML element.

Common Use Cases and Queries

The primary use case is extraction of matriculation block data for a pending SEVIS batch. A developer or support analyst troubleshooting a rejected or missing SEVIS transmission will query by BATCH_ID to inspect exactly what was sent. A second use case is verification of program end date values for a specific person before a batch is released, since an incorrect PRGM_END_DATE is a common cause of SEVIS validation errors. Because PRGM_END_DATE is character-typed, comparisons should use string literals and care must be taken not to assume implicit date conversion.

Sample queries include:

  • Retrieve all matriculation rows for a specific batch:
    SELECT BATCH_ID, PERSON_ID, MATRICULATION, PRGM_END_DATE FROM APPS.IGS_SV_EV_MATRIC_BLK_V WHERE BATCH_ID = :batch_id;
  • Inspect the pending program end date for a given exchange visitor:
    SELECT PERSON_ID, MATRICULATION, PRGM_END_DATE FROM APPS.IGS_SV_EV_MATRIC_BLK_V WHERE PERSON_ID = :person_id;
  • List all persons in a batch whose program end date falls in a given year, using string matching rather than date functions:
    SELECT PERSON_ID, PRGM_END_DATE FROM APPS.IGS_SV_EV_MATRIC_BLK_V WHERE BATCH_ID = :batch_id AND PRGM_END_DATE LIKE '2024%';

Users should always filter on BATCH_ID or PERSON_ID where possible, as the view is intended to be consumed in a batched, person-centric manner within the SEVIS integration flow.