Results for “igs_he_st_spa_cc”

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

Overview

IGS_HE_ST_SPA_CC is a table within the IGS (Student System) product family in Oracle E-Business Suite, documented across releases 12.1.1 and 12.2.2. Its purpose is to hold HESA (Higher Education Statistics Agency) Cost Center details defined at the Student Program Attempt level. In the context of statutory higher-education reporting, this table records how a student's program attempt is apportioned across cost centers and fields of study, capturing the proportion of activity attributable to each combination. The object is flagged as Obsolete in the ETRM documentation, and the implementation notes explicitly state that it is not implemented in the referenced database, meaning it should be treated as a legacy or reference-only object rather than an active transactional table.

Heuristic Data Vault classification mined from the foreign-key structure suggests this table behaves as a link. A link modeling suggestion is appropriate because the table resolves associations between a student program attempt, a course, a cost center, and a subject (field of study), rather than acting as a standalone descriptive hub or a pure satellite of a single parent entity. The recorded measures, such as proportion, would typically be modeled as link-level attributes or effectivity metadata in a Data Vault representation.

Key Information Stored

The documented physical schema contains eleven columns owned by the IGS schema. The most significant are:

• HE_SPA_CC_ID — the surrogate primary key, enforced by the unique index IGS_HE_ST_SPA_CC_PK. This is the technical identifier for each cost center allocation row.
• PERSON_ID — identifies the student. This participates in a foreign key to IGS_EN_STDNT_PS_ATT_ALL, tying the record to the student's program attempt.
• COURSE_CD — the course code associated with the program attempt; it forms part of the secondary unique key and the foreign key relationship to the student program attempt table.
• COST_CENTRE — the HESA cost center to which the attempt is attributed. This is a core business-key element.
• SUBJECT — the field of study. It is a foreign key to IGS_PS_FLD_OF_STUDY_ALL and part of the business-key unique index.
• PROPORTION — the share or weighting assigned to the cost center/subject combination, the principal quantitative attribute.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS auditing columns recording who created and last modified each row and when.

The secondary unique index IGS_HE_ST_SPA_CC_U1 on (PERSON_ID, COURSE_CD, COST_CENTRE, SUBJECT) is the primary business-key candidate, enforcing that a given student, course, cost center, and subject combination appears only once.

Common Use Cases and Queries

Reporting use cases center on HESA statutory returns, cost-center apportionment analysis, and student activity breakdowns. A typical query retrieves the allocations for a student program attempt:

• Join to IGS_EN_STDNT_PS_ATT_ALL on PERSON_ID and COURSE_CD to enrich with program attempt details.
• Join to IGS_PS_FLD_OF_STUDY_ALL on SUBJECT to resolve field-of-study descriptions.
• Aggregate PROPORTION by COST_CENTRE for institutional cost-center reporting.

A representative pattern is SELECT a.person_id, a.course_cd, a.cost_centre, a.subject, a.proportion FROM igs_he_st_spa_cc a WHERE a.person_id = :person_id. Because the table is not implemented in the documented database, such queries are relevant primarily to historical migrations, data extracts, or environments where the legacy IGS schema remains populated.

Related Objects

The most significant related objects, drawn from the documented foreign-key relationships, are:

• IGS_EN_STDNT_PS_ATT_ALL — referenced via PERSON_ID (and COURSE_CD), the student program attempt master.
• IGS_PS_FLD_OF_STUDY_ALL — referenced via SUBJECT, providing field-of-study definitions.
• IGS_HE_ST_SPA_CC_PK — the primary key unique index.
• IGS_HE_ST_SPA_CC_U1 — the business-key unique index on PERSON_ID, COURSE_CD, COST_CENTRE, SUBJECT.

These relationships establish the table as a linking construct between student program attempts and the reference data required for HESA cost-center and field-of-study reporting.