Search Results igs_en_stdntpshecsop




Overview
Explore in AI Chat

Overview

The IGS_EN_STDNTPSHECSOP table is a legacy Oracle EBS Student System (IGS) object that records the Higher Education Contribution Scheme (HECS) payment option selected by a student for a specific student course attempt. HECS is the Australian higher education contribution and loan framework, and this entity captures both the election made by the student and the associated residency, citizenship, and tax file number attributes that govern eligibility and repayment treatment.

In Oracle EBS 12.1.1 and 12.2.2, the product is flagged as obsolete. The ETRM metadata explicitly states that this table is not implemented in the current database, meaning it exists only as a documented historical artifact and would not be present in a fresh installation of either release. The documented physical schema identifies the owner as IGS with 27 columns.

Under the heuristic Data Vault classification mined from the foreign key structure, this object is best modeled as a link — it associates a student-course attempt with a HECS payment option, functioning as a relationship record rather than a standalone hub of core business identity or a pure descriptive satellite.

Key Information Stored

The 27 documented columns capture the HECS election, eligibility indicators, and standard EBS audit metadata. The most significant columns are:

The composite primary key, IGS_EN_STDNTPSHECSOP_PK, consists of PERSON_ID, COURSE_CD, and START_DT. The unique index IGS_EN_STDNTPSHECSOP_U1 covers the same three columns and thus represents the business-key candidate that enforces one active HECS option per student, course, and start date. Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) provide concurrency and audit tracking.

Common Use Cases and Queries

Although obsolete, this table would historically support HECS election reporting, eligibility validation, and loan reconciliation. A typical pattern retrieves a student's current HECS option:

SELECT person_id, course_cd, start_dt, hecs_payment_option, tax_file_number
FROM igs_en_stdntpshecsop
WHERE person_id = :person_id
AND TRUNC(SYSDATE) BETWEEN start_dt AND NVL(end_dt, SYSDATE);

Reporting scenarios include joining to IGS_FI_HECS_PAY_OPTN to resolve option descriptions, and aggregating by DIFFERENTIAL_HECS_IND or SAFETY_NET_IND to analyze repayment cohorts. Data-migration and audit queries typically compare the composite key against historical snapshots using START_DT ranges.

Related Objects

The documented foreign keys define the principal relationships:

  • IGS_EN_STDNT_PS_ATT_ALL — joined via PERSON_ID and COURSE_CD; the parent student course attempt entity.
  • IGS_FI_HECS_PAY_OPTN — joined via HECS_PAYMENT_OPTION; the reference table of valid HECS pay options.
  • IGS_EN_STDNTPSHECSOP_PK / IGS_EN_STDNTPSHECSOP_U1 — the primary key and unique index enforcing record integrity.

Because the table is documented as not implemented, related objects should be validated against the specific environment before use in any remediation or conversion effort.