Search Results reprint_reason




Overview
Explore in AI Chat

Overview

IGS_SV_OPT_EMPL_DUM_V is a reporting view belonging to the IGS — Student System product family in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to fetch Optional Practical Training (OPT) employment details for students, data that is assembled for transmission to the Student and Exchange Visitor Information System (SEVIS). OPT is a period of authorized off-campus employment available to eligible F-1 nonimmigrant students, and its reporting is a regulated activity; consequently the view sits within the SEVIS-facing side of the Student System rather than in general academic records reporting.

The object is explicitly classified as obsolete in the ETRM documentation, and the metadata records that it is not implemented in the reference database. The _DUM suffix and the absence of a referenced base-object list indicate a placeholder or dummy definition retained for backward compatibility with earlier releases or with interface code that once expected a view of this name. In practice, sites on 12.1.1 or 12.2.2 should treat the view as non-functional unless a custom implementation has supplied it.

Underlying Base Objects

No referenced base objects are documented in the ETRM metadata, and the object is reported as not implemented. The view text supplied in the documentation, however, defines IGS_SV_OPT_EMPL_DUM_V over two IGS Student System tables:

  • IGS_SV_PERSONS — aliased PERS, the driving table supplying person, batch, SEVIS user, and reprint attributes.
  • IGS_SV_BTCH_SUMMARY — aliased OPTSUMM, the SEVIS batch summary table used to restrict the result set to the OPT employment transmission.

The join is on PERSON_ID and BATCH_ID, filtered by RECORD_STATUS = 'C' on the person row, TAG_CODE = 'SV_OPT_EMPL' and ADM_ACTION_CODE = 'SEND' on the batch summary row. These predicates confine the view to current persons belonging to an OPT employment batch that has been marked for transmission.

Key Columns

  • BATCH_ID — identifier of the SEVIS batch to which the employment record belongs.
  • PDSO_SEVIS_ID — the SEVIS identifier of the Principal Designated School Official associated with the record; this is the column a user searching on "pdso_sevis_id" would be looking for.
  • PERSON_ID — the internal person identifier from the person table.
  • SEVIS_USER_ID — the SEVIS user identifier carried for the record.
  • PERSON_NUMBER — derived by zero-padding the leading ten characters of PERSON_ID via TO_CHAR with the '0000000000' format mask.
  • RECORD_NUMBER — the record sequence number within the batch.
  • PERSON_ID_LONG — a fourteen-character zero-padded derivation of PERSON_ID, used for transmittal layouts requiring the longer form.
  • REPRINT_REASON — REPRINT_RSN_CODE with reason code '11' suppressed to NULL via DECODE.
  • REPRINT_REMARKS — free-text remarks accompanying a reprint.

Common Use Cases and Queries

Because the view is documented as obsolete and unimplemented, the primary diagnostic use case is verification: confirming whether the object exists at a given site and, if a custom version has been created, inspecting its definition and output. Reference queries are useful when reviewing historical EL/OPT employment extracts or reconciling SEVIS batch contents by PDSO.

A basic existence check on 12.2.2 is:

  • SELECT object_name, object_type, status FROM all_objects WHERE object_name = 'IGS_SV_OPT_EMPL_DUM_V';

Where an implementation is present, a representative query selecting the SEVIS-oriented attributes is:

  • SELECT batch_id, pdso_sevis_id, person_id, sevis_user_id, person_number, record_number, reprint_reason, reprint_remarks FROM igs_sv_opt_empl_dum_v WHERE batch_id = :batch_id ORDER BY record_number;

A second scenario filters by PDSO to group transmittable OPT employment records:

  • SELECT pdso_sevis_id, COUNT(*) record_count FROM igs_sv_opt_empl_dum_v GROUP BY pdso_sevis_id;

Given the obsolete classification, any production dependency on this view should be re-pointed to the supported SEVIS OPT employment objects shipped in the current release before an upgrade from 12.1.1 to 12.2.2 is undertaken.