Search Results igs_ad_ct_hecs_payop




Overview
Explore in AI Chat

Overview

The IGS_AD_CT_HECS_PAYOP table belongs to the IGS – Student System product family within Oracle E-Business Suite. It records the association between an admission category and a HECS (Higher Education Contribution Scheme) payment option, enabling fees to be assessed from the admission fees category during the admissions process. In practical terms, this table functions as a mapping or cross-reference object: it determines which HECS payment options are valid for a given admission category, and therefore governs how admissions-related fee assessments are generated for students admitted under that category.

The ETRM documentation classifies this object as belonging to the IGS – Student System (Obsolete) module and explicitly notes that it is not implemented in the current database release. This is a significant caveat: the table is documented for historical and reference purposes, and its presence in a live 12.1.1 or 12.2.2 environment will depend on whether the relevant IGS patches or legacy components were ever applied. Where the object does exist, its heuristic Data Vault classification is a link, since it resolves a many-to-many relationship between admission categories and HECS payment options and carries no descriptive attributes beyond standard audit columns. This classification is a modeling suggestion derived from the foreign key structure rather than a formal Oracle designation.

Key Information Stored

The table is narrow, with seven documented columns. The most important are the two composite key members and the standard audit fields:

  • ADMISSION_CAT – The admission category identifier. This is a business-key column and part of the composite primary key. It also forms the foreign key to IGS_AD_CAT_ALL.
  • HECS_PAYMENT_OPTION – The HECS payment option identifier. This is the second business-key column, part of the composite primary key and the foreign key to IGS_FI_HECS_PAY_OPTN.
  • CREATED_BY – Standard WHO column recording the user who inserted the row.
  • CREATION_DATE – Standard WHO column recording the row insertion timestamp.
  • LAST_UPDATED_BY – Standard WHO column recording the user who last modified the row.
  • LAST_UPDATE_DATE – Standard WHO column recording the last modification timestamp; commonly used for incremental extraction and auditing.
  • LAST_UPDATE_LOGIN – Standard WHO column recording the login session associated with the last update.

The surrogate primary key is IGS_AD_CT_HECS_PAYOP_PK, defined over (ADMISSION_CAT, HECS_PAYMENT_OPTION). The unique index IGS_AD_CT_HECS_PAYOP_U1 covers the same two columns and is the documented business-key candidate, confirming that the combination of admission category and payment option must be unique. There is no separate surrogate sequence-generated identifier; the business key is the primary key.

Common Use Cases and Queries

Typical uses centre on validating and reporting the permitted HECS payment options per admission category, and on reconciling fee assessments generated from admission categories.

  • Listing all payment options for a given admission category:
    SELECT hecs_payment_option FROM igs_ad_ct_hecs_payop WHERE admission_cat = :cat;
  • Finding all admission categories that permit a specific HECS option:
    SELECT admission_cat FROM igs_ad_ct_hecs_payop WHERE hecs_payment_option = :opt;
  • Joining to the parent admission category table for descriptive reporting:
    SELECT a.admission_cat, c.description, h.hecs_payment_option
    FROM igs_ad_ct_hecs_payop h
    JOIN igs_ad_cat_all c ON c.admission_cat = h.admission_cat;
  • Joining to IGS_FI_HECS_PAY_OPTN to expand payment-option detail for fee assessment or student finance reports.
  • Audit and delta extraction using LAST_UPDATE_DATE to identify rows changed since a prior extract.

Because the object is marked obsolete and not implemented, these queries are relevant primarily to legacy data migration, historical reporting, or environments where the IGS admissions components were deployed.

Related Objects

The following objects are most significant in relation to IGS_AD_CT_HECS_PAYOP, based on the documented foreign key relationships:

  • IGS_AD_CAT_ALL – Parent table for admission categories; joined on IGS_AD_CT_HECS_PAYOP.ADMISSION_CAT = IGS_AD_CAT_ALL.ADMISSION_CAT.
  • IGS_FI_HECS_PAY_OPTN – Parent table for HECS payment options; joined on IGS_AD_CT_HECS_PAYOP.HECS_PAYMENT_OPTION = IGS_FI_HECS_PAY_OPTN.HECS_PAYMENT_OPTION.

Additional dependent or related objects may include IGS admissions fee assessment routines and student finance views that resolve payment options, though these are not enumerated in the supplied metadata. The two foreign key parent tables above are the authoritative related objects for join and integrity analysis.