Search Results student_instance_number

Overview

IGSBV_HESA_EXT_RUN_DAT_LINES is a reporting view within the Oracle E-Business Suite Student System (IGS) product family, historically used to support Higher Education Statistics Agency (HESA) statutory returns for UK higher education institutions. The view exposes the base extract data generated by the HESA extract run process, presenting one row per HESA return line produced during an extraction run. In EBS 12.1.1 and 12.2.2, the object is documented as an obsolete, informational component of the IGS module; the ETRM metadata explicitly records the implementation status as "Not implemented in this database," indicating that the object was not deployed in the referenced environment and should be treated as legacy or reference-only.

The view's principal role is to provide a read-only, denormalized projection of HESA extract lines that downstream reporting, reconciliation, or data-extraction routines could query without directly touching the underlying transaction table. It carries a WITH READ ONLY clause, preventing any DML through the view and confirming its intended use as a reporting and integration surface only.

Underlying Base Objects

The view is defined over a single base table, IGS_HE_EX_RN_DAT_LN (aliased as LN), which stores the individual HESA return data lines. Although the ETRM metadata lists no formally documented referenced base objects, the view text unambiguously identifies this table as the sole source. The view performs a straight column projection with no joins, aggregations, or filters, meaning it behaves as a column alias and naming-standardization layer rather than a transformation layer.

Because the view maps physical column names to business-friendly aliases, it decouples report definitions from the physical schema, allowing the underlying table to evolve while consumers continue to reference stable view column names.

Key Columns

• HESA_RETURN_LINE_ID — Surrogate identifier for the return line (aliased from RN_DAT_LN_ID); the primary key for reconciliation.
• EXTRACT_RUN_ID — Identifies the parent HESA extract run that produced the line.
• RECORD_ID — Links the line to its associated HESA record.
• LINE_NUMBER — Sequencing of the line within the record or file.
• PERSON_ID — Party identifier of the student associated with the line.
• STUDENT_INSTANCE_NUMBER — Student instance reference (aliased from STUDENT_INST_NUMBER).
• PROGRAM_CODE / PROGRAM_VERSION_NUMBER — Course code and version (aliased from COURSE_CD and CRV_VERSION_NUMBER).
• UNIT_CODE / UNIT_VERSION_NUMBER — Unit/module code and version (aliased from UNIT_CD and UV_VERSION_NUMBER).
• MANUALLY_INSERTED_FLAG — Indicates the line was manually added rather than system-generated.
• EXCLUDE_FROM_FILE_FLAG — The column corresponding to the search term "exclude_from_file_flag"; when set, the line is suppressed from the generated HESA output file.
• RECALCULATE_FLAG — Signals that the line requires recalculation on the next extract run.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE.

Common Use Cases and Queries

Typical usage centers on validating extract output and excluding suppressed lines before file generation. A common query identifies all active (non-excluded) lines for a given run:

• SELECT HESA_RETURN_LINE_ID, RECORD_ID, LINE_NUMBER, PERSON_ID, EXCLUDE_FROM_FILE_FLAG FROM IGSBV_HESA_EXT_RUN_DAT_LINES WHERE EXTRACT_RUN_ID = :run_id AND NVL(EXCLUDE_FROM_FILE_FLAG,'N') = 'N' ORDER BY RECORD_ID, LINE_NUMBER;
• Reconciliation of manually inserted lines: SELECT * FROM IGSBV_HESA_EXT_RUN_DAT_LINES WHERE MANUALLY_INSERTED_FLAG = 'Y';
• Detecting lines flagged for recalculation prior to rerun: SELECT HESA_RETURN_LINE_ID FROM IGSBV_HESA_EXT_RUN_DAT_LINES WHERE RECALCULATE_FLAG = 'Y';

Because the object is documented as not implemented in the reference database, deployments should verify existence in the target instance before relying on these queries, and consider IGS_HE_EX_RN_DAT_LN as the authoritative physical source where the view is absent.