Search Results igs_fi_hecs_pay_optn




Overview
Explore in AI Chat

Overview

The IGS_FI_HECS_PAY_OPTN table resides in the IGS schema (Oracle Student System) and serves as a reference or lookup entity for Higher Education Contribution Scheme (HECS) contribution payment options. In Australian higher education administration, HECS payment options define how a student elects to satisfy a contribution liability — for example, a deferred option (code 10), an upfront payment option (code 11), or an overseas student option (code 24). This table therefore acts as a controlled vocabulary of valid payment-option codes that drive application, continuation, and enrolment processing across the Student System.

From a Data Vault modeling perspective, the mined foreign-key structure classifies this object as hub-leaning. It carries a natural business key (HECS_PAYMENT_OPTION) that is also the primary key, and comparatively few descriptive or mutable attributes. This suggests a hub with a thin satellite, referencing a government-defined payment-option hub (IGS_FI_GOV_HEC_PA_OP) and itself referenced by several transactional or association tables.

Key Information Stored

The table contains 10 documented columns in the 12.1.1 physical schema. The most important include:

  • HECS_PAYMENT_OPTION — the primary key (enforced by IGS_FI_HECS_PAY_OPTN_PK) and the unique business-key candidate (backed by unique index IGS_FI_HECS_PAY_OPTN_U1). Holds the payment-option code, e.g., 10 (Deferred), 11 (Upfront), 24 (Overseas students).
  • GOVT_HECS_PAYMENT_OPTION — foreign key to IGS_FI_GOV_HEC_PA_OP, mapping the internal option to its government-recognised equivalent.
  • DESCRIPTION — the human-readable label presented to users and reproduced on reports.
  • EXPIRE_AFTR_ACDMC_PERD_IND — indicator governing whether the option expires after an academic period, controlling validity windows.
  • CLOSED_IND — flag marking the option as no longer available for new selections while preserving historical referential integrity.
  • Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN capture the standard Oracle EBS who/when stamping.

The surrogate primary key and the business-key candidate are the same column here, which is typical of seeded reference data maintained by the Student System rather than user-populated lists.

Common Use Cases and Queries

The dominant use case is validating and presenting valid HECS payment options during admissions, enrolment, and student financial processing. A common reporting pattern joins this table to dependent transactional tables to resolve codes to descriptions:

  • Enumerating active options: SELECT hecs_payment_option, description FROM igs_fi_hecs_pay_optn WHERE closed_ind = 'N';
  • Resolving option text for a student's HECS selection by joining IGS_EN_STDNTPSHECSOP.HECS_PAYMENT_OPTION to this table on HECS_PAYMENT_OPTION.
  • Reconciling internal options to government codes via the join to IGS_FI_GOV_HEC_PA_OP on GOVT_HECS_PAYMENT_OPTION, useful in statutory reporting.
  • Auditing historical usage, where CLOSED_IND and the expiry indicator determine which options applied within a given academic period.

Related Objects

The table participates in a small but well-defined referential network:

  • IGS_FI_GOV_HEC_PA_OP — referenced through GOVT_HECS_PAYMENT_OPTION; the parent government payment-option definition.
  • IGS_AD_PS_APPL_INST_ALL — application-instance data referencing HECS_PAYMENT_OPTION, capturing the option chosen at application time.
  • IGS_AD_CT_HECS_PAYOP — a HECS payment-option association table keyed on HECS_PAYMENT_OPTION.
  • IGS_EN_STDNTPSHECSOP — the student programme HECS option table, recording the enrolled student's elected option.

Together these relationships establish IGS_FI_HECS_PAY_OPTN as the central reference point for HECS payment-option semantics across admissions and enrolment in Oracle EBS 12.1.1 and 12.2.2.