Search Results issue_reason




Overview
Explore in AI Chat

Overview

IGS_SV_CRT_CONT_BLK_V is an APPS-owned view in the IGS (Student System) product of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It exists to supply the data required to render the XML block that describes "create continuation" information for a student. In practice, the view surfaces the subset of person records that require a continuation enrollment certificate to be produced — that is, students whose issuing reason is coded as a continuation ('C') and whose record status indicates a new, unprocessed record ('N').

Its role is primarily reporting and integration: the view is consumed by the student system's document/print generation processes (for example, Student Self-Service or enrollment certificate printing), which query it to obtain the batch identifier, person, form type, issuing reason, and session boundary dates needed to assemble the XML payload. Because it is a view rather than a table, it provides a stable, read-only interface against the underlying person data, insulating downstream XML generation from the physical structure of the base table.

Underlying Base Objects

The view is defined over a single documented base object: IGS_SV_PERSONS, aliased as PERS. The definition applies two fixed filter predicates that determine its contents:

  • PERS.RECORD_STATUS = 'N' — restricts output to records in "new" status, i.e., those not yet processed or superseded.
  • PERS.ISSUING_REASON = 'C' — restricts output to the continuation issuing reason, which is the defining characteristic of this block.

The documented metadata lists no other referenced base objects, so the view is essentially a filtered, projected slice of IGS_SV_PERSONS. Note that the column ISSUING_REASON in the base table is exposed through the view under the alias ISSUE_REASON, a naming distinction that is important when writing predicates or joins against the view.

Key Columns

  • BATCH_ID — Identifier of the processing/print batch to which the person record belongs; used to group records for a single XML generation run.
  • PERSON_ID — The unique identifier of the student/person for whom continuation information is being produced; the primary join key to person and party tables.
  • PRINT_FORM — Indicates the form type or format to be printed for the record, guiding the XML layout.
  • ISSUE_REASON — The aliased issuing reason; always 'C' for continuation in this view, but retained for downstream XML tagging.
  • CURR_SESSION_END_DATE — The end date of the current session, forming the lower boundary of the continuation period.
  • NEXT_SESSION_START_DATE — The start date of the next session, forming the upper boundary of the continuation period.

Common Use Cases and Queries

Typical usage is in the generation of continuation enrollment certificates and in reconciliation reports confirming which students are pending continuation output. A representative query listing pending continuation records is:

  • SELECT batch_id, person_id, print_form, issue_reason, curr_session_end_date, next_session_start_date FROM apps.igs_sv_crt_cont_blk_v ORDER BY batch_id, person_id;

To isolate a single processing run, filter on the batch identifier:

  • SELECT person_id, print_form, curr_session_end_date, next_session_start_date FROM apps.igs_sv_crt_cont_blk_v WHERE batch_id = :p_batch_id;

Because the view already constrains RECORD_STATUS and ISSUING_REASON, callers need not re-apply those predicates; doing so is redundant. Join to person or party tables via PERSON_ID when student names or demographics are required for the XML block, always qualifying the view with the APPS schema in EBS environments.