Results for “igs_he_en_susa”

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

Overview

The IGS_HE_EN_SUSA table is a core operational table within the IGS (Student System) product family of Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. It stores Higher Education Statistics Agency (HESA) information that is acquired during the enrolment of a student onto a program unit set attempt. In practice, this means that for every attempt a student makes at a program unit set, the system captures the statistical and regulatory attributes required for HESA statutory returns, including funding, fee, credit, study-mode, and disability-related data.

The table resides in the IGS schema and holds 57 documented columns at the 12.1.1 physical schema level. Its primary key, IGS_HE_EN_SUSA_PK, is defined on HESA_EN_SUSA_ID. From a Data Vault modelling perspective, the heuristic classification derived from the foreign-key structure is satellite-leaning: the table primarily records descriptive, time-variant attributes attached to a parent enrolment event rather than acting as a pure hub of business keys or as a link between independent hubs. This classification should be treated as a modelling suggestion rather than a prescriptive design constraint.

Key Information Stored

The most significant columns cluster around identifying the enrolment context and capturing the HESA statistical payload:

• HESA_EN_SUSA_ID — the surrogate primary key, generated by the IGS_HE_EN_SUSA_PK constraint and the unique index IGS_HE_EN_SUSA_U1. It uniquely identifies each row.
• PERSON_ID, COURSE_CD, UNIT_SET_CD, SEQUENCE_NUMBER — the business-key candidates captured by the unique index IGS_HE_EN_SUSA_U2. These columns collectively identify the student, the course, the program unit set, and the attempt sequence, and they form the foreign key to IGS_AS_SU_SETATMPT.
• US_VERSION_NUMBER — supports versioning of the HESA record across reporting cycles.
• NEW_HE_ENTRANT_CD — indicates whether the student is a new entrant to higher education.
• STUDY_MODE, STUDY_LOCATION, TYPE_OF_YEAR, YEAR_STU — describe the mode, location, type of academic year, and year of study for the attempt.
• FEE_ELIGIBILITY, FEE_BAND, STUDENT_FEE, NON_PAYMENT_REASON, FUNDABILITY_CODE — capture the fee and funding profile of the enrolment.
• FTE_PERC_OVERRIDE, FTE_INTENSITY, CALCULATED_FTE, FTE_CALC_TYPE — store full-time-equivalent intensity and calculation basis.
• CREDIT_VALUE_YOP1 through CREDIT_VALUE_YOP4, CREDIT_LEVEL1 through CREDIT_LEVEL4, CREDIT_PT_ACHIEVED1 through CREDIT_PT_ACHIEVED4, CREDIT_LEVEL_ACHIEVED1 through CREDIT_LEVEL_ACHIEVED4 — a repeating block of credit value, credit level, and credit points achieved per year of programme.
• DISABILITY_ALLOW, DISADV_UPLIFT_FACTOR, ADDITIONAL_SUP_COST, ADDITIONAL_SUP_BAND, SLDD_DISCRETE_PROV, TERM_TIME_ACCOM — HESA-specific disability, additional support, and accommodation attributes.
• COMPLETION_STATUS, GOOD_STAND_MARKER, GRAD_SCH_GRADE, MARK, PRO_NOT_TAUGHT — outcome and progression indicators.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard Oracle EBS audit columns.

Common Use Cases and Queries

The table is principally queried for HESA statutory returns, fee and funding reconciliation, and student progression analytics. A typical pattern joins to the parent enrolment attempt table to resolve the student and course context:

• HESA return extraction: select the HESA attributes for a given reporting year, filtered by TYPE_OF_YEAR and YEAR_STU, to populate the HESA student record return.
• Funding and fee reconciliation: aggregate STUDENT_FEE and ADDITIONAL_SUP_COST by FEE_BAND and FUNDABILITY_CODE to validate institutional fee income.
• FTE analysis: compare FTE_INTENSITY and CALCULATED_FTE against FTE_PERC_OVERRIDE to identify anomalous full-time-equivalent calculations.
• Credit accumulation reporting: sum CREDIT_PT_ACHIEVED1 through CREDIT_PT_ACHIEVED4 to track credit accumulation per student per year of programme.
• Widening participation: analyse DISABILITY_ALLOW and DISADV_UPLIFT_FACTOR to support access and participation monitoring.

A representative query skeleton is: SELECT s.PERSON_ID, s.COURSE_CD, s.UNIT_SET_CD, s.SEQUENCE_NUMBER, s.STUDY_MODE, s.FEE_BAND, s.CALCULATED_FTE FROM igs.igs_he_en_susa s WHERE s.YEAR_STU = :year AND s.TYPE_OF_YEAR = :year_type, optionally joined to IGS_AS_SU_SETATMPT on PERSON_ID, COURSE_CD, UNIT_SET_CD, and SEQUENCE_NUMBER.

Related Objects

The documented foreign-key relationship anchors this table to a small set of dependent and parent objects:

• IGS_AS_SU_SETATMPT — the parent enrolment attempt table. The foreign key maps IGS_HE_EN_SUSA.PERSON_ID, COURSE_CD, UNIT_SET_CD, and SEQUENCE_NUMBER to the corresponding columns on the attempt record. This is the primary object through which HESA data is contextualised.
• IGS_HE_EN_SUSA_PK and IGS_HE_EN_SUSA_U1 — the primary key and unique index on HESA_EN_SUSA_ID, enforcing row-level uniqueness.
• IGS_HE_EN_SUSA_U2 — the composite unique index on PERSON_ID, COURSE_CD, UNIT_SET_CD, and SEQUENCE_NUMBER, which acts as the business-key candidate and supports the join to the parent attempt.

Beyond the documented relationships, HESA reporting in the IGS Student System typically draws on related person, course, and program unit set entities to resolve descriptors referenced by codes such as NEW_HE_ENTRANT_CD, FEE_BAND, and STUDY_MODE. These lookups should be validated against the institution's specific IGS configuration before being relied upon in production reporting.