Results for “igs_he_submsn_header”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_HE_SUBMSN_HEADER is a core table within the Oracle E-Business Suite Student System (IGS) product family, specifically supporting the Higher Education (HE) statutory returns functionality. The table holds the header-level information for a Submission, which is a defined collection of returns that must be reported to regulatory bodies. Each row represents a single submission and stores the parameters that apply uniformly across all returns contained within that submission, such as enrolment date ranges and offset rules. It acts as the controlling parent record for its member returns and award records.

From a data modeling perspective, the ETRM metadata classifies this object as hub-leaning under a heuristic Data Vault assessment mined from its foreign-key structure. In practice, this suggests the table behaves as a business-key hub: SUBMISSION_NAME is the stable business identifier to which dependent satellites or links would attach. Modelers implementing a Data Vault layer should treat IGS_HE_SUBMSN_HEADER as the hub, with descriptive attributes such as dates, flags, and audit columns carried in associated satellites.

Key Information Stored

The table contains 15 documented columns. The surrogate primary key is SUB_HDR_ID, generated through the IGS_HE_SUBMSN_HEADER_PK constraint. Two unique indexes serve as business-key candidates: IGS_HE_SUBMSN_HEADER_U1 on SUBMISSION_NAME and IGS_HE_SUBMSN_HEADER_U2 on SUB_HDR_ID, confirming SUBMISSION_NAME as the meaningful, externally referenced identifier.

The most significant columns include:

• SUBMISSION_NAME — the business key uniquely identifying the submission; referenced by all child tables.
• DESCRIPTION — free-text description of the submission's purpose or reporting period.
• ENROLMENT_START_DATE / ENROLMENT_END_DATE — the enrolment window governing which student enrolment records are eligible to be included.
• OFFSET_DAYS — a numeric offset applied when deriving reporting dates across the returns.
• APPLY_TO_ATMPT_ST_DT — controls whether attempt start dates are subject to the submission rules.
• APPLY_TO_INST_ST_DT — controls whether instance start dates are subject to the submission rules.
• COMPLETE_FLAG — indicates whether the submission has been finalized or remains open.
• VALIDATION_COUNTRY — the country context against which validations are performed.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS audit columns.

Common Use Cases and Queries

Typical usage centers on identifying the active submission and its parameter set before extracting return data, and on validating that all child returns share consistent header parameters. A representative query retrieves the current submission parameters:

• SELECT h.submission_name, h.description, h.enrolment_start_date, h.enrolment_end_date, h.offset_days, h.complete_flag FROM igs.igs_he_submsn_header h WHERE h.complete_flag = 'N';

Reporting scenarios include auditing submissions that remain incomplete, comparing enrolment windows across academic years, and joining header parameters to the returns they govern. A join pattern linking header and returns:

• SELECT h.submission_name, r.return_name FROM igs.igs_he_submsn_header h, igs.igs_he_submsn_return r WHERE h.submission_name = r.submission_name;

Because APPLY_TO_ATMPT_ST_DT, APPLY_TO_INST_ST_DT, and OFFSET_DAYS drive selection logic, these columns are frequently inspected when troubleshooting discrepancies between expected and reported enrolment counts.

Related Objects

The following objects depend on or reference IGS_HE_SUBMSN_HEADER through documented foreign keys:

• IGS_HE_SUBMSN_AWD — references IGS_HE_SUBMSN_HEADER via SUBMISSION_NAME; stores award-level data belonging to the submission.
• IGS_HE_SUBMSN_RETURN — references IGS_HE_SUBMSN_HEADER via SUBMISSION_NAME; stores the individual returns included in the submission.

These two child tables are the principal dependents recorded in the metadata, and the SUBMISSION_NAME column is the universal join key connecting the submission header to its awards and returns. Because both foreign keys converge on the same business key, IGS_HE_SUBMSN_HEADER functions as the central parent record for the higher-education submission hierarchy, and any Data Vault or dimensional model should preserve SUBMISSION_NAME as the linking attribute across these objects.