Search Results length_of_study




Overview
Explore in AI Chat

Overview

IGS_SV_CRT_STDT_BLK_V is a PL/SQL view owned by the APPS schema in the Oracle E-Business Suite Student System (IGS) product. In EBS 12.1.1 and 12.2.2, it is used by the SEVIS (Student and Exchange Visitor Information System) interface to obtain information for the XML block describing the creation of a student record. It sits within the SEVIS person and batch processing model, feeding the outbound XML payload that reports new and updated student (F and M visa) records to the U.S. government SEVIS system.

The view is a "stub" or template view: it exposes the full set of SEVIS student-block columns, but the majority are returned as hard-coded NULLs. Only the columns drawn from IGS_SV_PERSONS carry data — BATCH_ID, PERSON_ID, PRINT_FORM, RECORD_NUMBER, PDSO_SEVIS_ID, REMARKS, and ISSUING_REASON — along with derived person-number columns. This design lets the SEVIS generation layer reference a stable column list while the actual data population is handled elsewhere in the reporting pipeline.

Underlying Base Objects

The view is defined over four IGS SEVIS tables:

  • IGS_SV_PERSONS PERS — the driving table, holding person-level SEVIS data and record status.
  • IGS_SV_BTCH_SUMMARY BIOSUMM — batch summary aliased for the SV_BIO tag.
  • IGS_SV_BTCH_SUMMARY FADDSUMM — batch summary aliased for the foreign address tag.
  • IGS_SV_BTCH_SUMMARY PRGMSUMM — batch summary aliased for the program tag.
  • IGS_SV_BTCH_SUMMARY FINSUMM — batch summary aliased for the financial tag.

IGS_SV_BTCH_SUMMARY is joined multiple times on PERSON_ID and BATCH_ID, once per tag code, so the view only returns rows for persons who have all required SEVIS tag summaries present in the batch. The driving filter is PERS.RECORD_STATUS = 'N', restricting output to new student records. The documented base-object list is empty in the ETRM metadata, but the view text confirms these tables as the source.

Key Columns

  • BATCH_ID, PERSON_ID, RECORD_NUMBER — batch, person, and record identifiers from IGS_SV_PERSONS.
  • PRINT_FORM — indicates whether the SEVIS form should be printed.
  • PDSO_SEVIS_ID — the SEVIS identifier of the principal designated school official associated with the record.
  • ISSUE_REASON / REMARKS — reason for issuance and free-text remarks from the person record.
  • STDNT_PERSON_ID and STDNT_PERSON_NUMBER — derived from PERSON_ID and formatted for the SEVIS person block.
  • LENGTH_OF_STUDY — the requested search term; exposed here as a NULL placeholder, populated by other SEVIS reporting logic.
  • Bio, address, education, program, and financial columns (STDNT_LAST_NAME, FN_ADDRESS_LINE1, PRIMARY_MAJOR, TUITION, and so on) — all returned as NULL in this view.

Common Use Cases and Queries

This view is most commonly referenced when generating or troubleshooting the student-creation XML block for SEVIS. A typical inspection query is:

SELECT batch_id, person_id, record_number, pdso_sevis_id, print_form, remarks FROM apps.igs_sv_crt_stdt_blk_v WHERE batch_id = :p_batch_id;

Consultants use it to confirm which persons in a batch qualify as new records and to trace the batch-to-person mapping before the XML is produced. Because LENGTH_OF_STUDY and the bio/address/financial columns are NULL here, they should not be relied upon for data; for those attributes, the corresponding IGS_SV_PERSONS and IGS_SV_BTCH_SUMMARY data must be queried directly.