Search Results igs_he_ex_rn_dat_ln

Overview

The IGS_HE_EX_RN_DAT_LN table is a core data structure within the Oracle E-Business Suite Student System (IGS) module, specifically designed for the Higher Education (HE) extract framework. It functions as the detailed staging table for line-level data generated by an extract process. As documented, each physical line in the final output extract file corresponds to a single record in this table. Its primary role is to hold the raw, unformatted data extracted from the transactional system before it is processed into the final report format, serving as a critical intermediary in batch reporting and data submission workflows common in educational institutions.

Key Information Stored

Each record in the table represents one line from an extract file and is uniquely identified by a composite primary key. The key columns are EXTRACT_RUN_ID, which links the line to a specific execution instance of an extract job, and LINE_NUMBER, which defines the sequential order of the line within that run. A critical foreign key, PERSON_ID, links the extracted data line to a specific individual (Party) in the Trading Community Architecture (TCA) registry via the HZ_PARTIES table. While the specific data payload columns are not detailed in the provided metadata, the table's relationship to IGS_HE_EX_RN_DAT_FD suggests it holds the base record, with detailed field-level extracted values stored in the related child table.

Common Use Cases and Queries

This table is central to troubleshooting, auditing, and regenerating data extracts. Common operational scenarios include verifying the volume of data extracted for a specific run, identifying errors in individual data lines before file generation, and analyzing extracted data for a particular student. A typical query would join to the extract run details and party information.

• Sample Query to List Extracted Lines for a Run:
  SELECT ln.EXTRACT_RUN_ID, ln.LINE_NUMBER, ln.PERSON_ID, p.PARTY_NAME
  FROM IGS_HE_EX_RN_DAT_LN ln,
       IGS_HE_EXT_RUN_DTLS run,
       HZ_PARTIES p
  WHERE ln.EXTRACT_RUN_ID = run.EXTRACT_RUN_ID
    AND ln.PERSON_ID = p.PARTY_ID
    AND run.EXTRACT_RUN_ID = 12345
  ORDER BY ln.LINE_NUMBER;
• Reporting Use Case: Creating an audit report that counts the number of extracted data lines per extract run, often used for reconciling record counts.

Related Objects

The IGS_HE_EX_RN_DAT_LN table sits within a defined hierarchy of extract objects, as evidenced by its foreign key relationships.

• Parent/Dependent Tables:
  • IGS_HE_EXT_RUN_DTLS: This is the parent table. The EXTRACT_RUN_ID in IGS_HE_EX_RN_DAT_LN references the master record of the extract execution, providing context like the extract type and run date.
  • HZ_PARTIES: The PERSON_ID column foreign key links the extracted data line to the core person or organization record in the TCA model.
• Child/Referencing Tables:
  • IGS_HE_EX_RN_DAT_FD: This child table holds the detailed field-level data for each extracted line. It references IGS_HE_EX_RN_DAT_LN using both the EXTRACT_RUN_ID and LINE_NUMBER columns, forming a one-to-many relationship where one data line contains many data fields.