Results for “hesa_st_spau_id”

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

Overview

The IGS_HE_ST_SPA_UT_ALL table belongs to the IGS (Student System) product family within Oracle E-Business Suite. Its documented purpose is to store UCAS (Universities and Colleges Admissions Service) tariff information for a student program attempt. The table resides in the IGS schema and contains 13 documented columns in the ETRM 12.1.1 physical schema. Notably, the ETRM metadata records the object as "Not implemented in this database." This means the table is documented in the data model reference but is not physically present in the certified EBS 12.1.1 or 12.2.2 instance from which the metadata was extracted — behavior consistent with an obsolete or dormant IGS component retained for reference purposes only.

Because the object carries legacy IGS heritage and is marked obsolete, its practical significance in a supported 12.1.1 or 12.2.2 environment is limited to historical data retention, integration mapping, or migration validation. From a Data Vault modeling perspective, the heuristic classification derived from its foreign-key structure is standalone. In practice, the table behaves like a satellite: it stores descriptive attributes (qualification level, number of qualifications, tariff score) that describe a student program attempt, keyed by a surrogate identifier. Report authors and migration analysts should treat it as an attribute-bearing, non-hub object without independent business lineage.

Key Information Stored

The primary key is defined by IGS_HE_ST_SPA_UT_ALL_PK, enforced across the surrogate identifier HESA_ST_SPAU_ID. A unique index, IGS_HE_ST_SPA_UT_ALL_U1, also exists on HESA_ST_SPAU_ID, confirming it as the sole business-key candidate and the natural join column for related UCAS tariff records.

• HESA_ST_SPAU_ID — Surrogate primary key and unique business identifier for the tariff record.
• ORG_ID — Operating unit / organization context, supporting multi-org data segregation.
• PERSON_ID — Reference to the student whose program attempt the tariff row describes.
• COURSE_CD — Course code associated with the student program attempt.
• VERSION_NUMBER — Version of the course or program attempt record, enabling historical tracking.
• QUALIFICATION_LEVEL — UCAS tariff qualification level (for example, A-level, BTEC, or equivalent).
• NUMBER_OF_QUAL — Count of qualifications held at the given level.
• TARIFF_SCORE — The UCAS tariff points total derived from the qualifications.
• CREATED_BY / CREATION_DATE — Standard audit columns for row creation.
• LAST_UPDATE_DATE / LAST_UPDATED_BY / LAST_UPDATE_LOGIN — Standard audit columns for row modification and session tracking.

Common Use Cases and Queries

In legacy or migration contexts, the table supports UCAS tariff reporting: aggregating tariff scores by student, course, or qualification level. Typical SQL patterns join HESA_ST_SPAU_ID to sibling IGS student program attempt tables and filter on PERSON_ID or ORG_ID. A representative pattern is:

• SELECT PERSON_ID, COURSE_CD, SUM(TARIFF_SCORE) FROM IGS_HE_ST_SPA_UT_ALL WHERE ORG_ID = :org GROUP BY PERSON_ID, COURSE_CD;
• Reconciliation of tariff points against admissions offers during data migration to 12.2.2.
• Audit queries using LAST_UPDATE_DATE to identify records modified after cutover.
• Analysis of qualification distribution using GROUP BY QUALIFICATION_LEVEL and NUMBER_OF_QUAL.

Given the "Not implemented in this database" status, confirm object existence with a data dictionary query against ALL_TABLES before writing production reports.

Related Objects

The metadata records no foreign-key relationships — the Data Vault classification is standalone, and no FK columns are documented beyond PERSON_ID and ORG_ID. Consequently, related objects are inferred from column semantics rather than enforced constraints:

• HR_ALL_ORGANIZATION_UNITS — join on ORG_ID to resolve operating unit context.
• PER_ALL_PEOPLE_F — join on PERSON_ID to retrieve student or person details.
• IGS_HE_ST_PROGRAM_ATTEMPT (or the corresponding student program attempt table present in the instance) — logical parent describing the attempt.
• HESA tariff reference tables — used to map QUALIFICATION_LEVEL codes to descriptions.
• IGS_HE_ST_SPA_UT — the base (non-_ALL) tariff table, often paired with the _ALL multi-org variant.
• Student course registration views under the IGS schema, used to correlate COURSE_CD and VERSION_NUMBER.

Because there are no documented FK constraints, all joins should be validated against the actual instance schema before deployment.