Search Results hecs_payment_type

Overview

The view APPS.IGS_FI_GOV_HEC_PA_OP_V is a read-only query object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, owned by the APPS schema. It is a component of the student systems / financial aid functional area, specifically the IGS (Integrated Government Student / Student Systems) product family. Its principal purpose is to present government HECS (Higher Education Contribution Scheme) payment option definitions in a denormalized, presentation-ready form by decoding the stored payment type against the Oracle EBS lookup mechanism.

This view is significant because it directly answers the data requirement implied by the search term hecs_payment_type. The underlying base table stores payment types only as a short lookup code (S_HECS_PAYMENT_TYPE). This view joins that code to the lookup view so that the human-readable MEANING is returned alongside it, which is normally the value most reporting layers and integrations actually consume. It is therefore well suited to LOV (List of Values) queries, concurrent program data sources, BI Publisher (XML Publisher) reports, and inbound/outbound interface extraction where the descriptive payment type is required rather than the coded value.

Underlying Base Objects

The documented view text defines the object over two sources:

• IGS_FI_GOV_HEC_PA_OP ghpo — the primary base table, holding the HECS government payment option records. The table alias GHPO appears throughout the column list and is referenced in the WHERE clause.
• IGS_LOOKUPS_VIEW lkups — the standard Oracle EBS lookup view used to resolve lookup codes into meanings. It is joined on LKUPS.LOOKUP_CODE = GHPO.S_HECS_PAYMENT_TYPE and constrained with LKUPS.LOOKUP_TYPE = 'HECS_PAYMENT_TYPE'.

Note that although the ETRM metadata reports "Referenced base objects: none documented," the view definition itself explicitly references the two objects above. The join is written in the legacy comma-separated ("Oracle") syntax rather than ANSI JOIN syntax, and it is an inner join: any payment option whose S_HECS_PAYMENT_TYPE does not have a matching enabled lookup for the HECS_PAYMENT_TYPE lookup type will be silently excluded from the result set. This behaviour is important when troubleshooting missing rows in downstream reports.

Key Columns

• ROW_ID — the row identifier of the base table row (GHPO.ROWID), useful for updates or row-based lookup.
• GOVT_HECS_PAYMENT_OPTION — the primary identifier/key of the government HECS payment option.
• DESCRIPTION — the descriptive text for the payment option.
• S_HECS_PAYMENT_TYPE — the stored lookup code for the HECS payment type; this is the coded value that the view decodes.
• MEANING — the decoded, user-facing meaning of the lookup code, sourced from IGS_LOOKUPS_VIEW for lookup type HECS_PAYMENT_TYPE.
• ALLOW_DISCOUNT_IND — indicator controlling whether a discount is permitted for the payment option.
• CLOSED_IND — indicator denoting whether the payment option is closed/inactive.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS WHO columns used for audit and change tracking.

Common Use Cases and Queries

The view is typically queried when a report or integration needs the descriptive HECS payment type rather than the raw code. A standard listing query is:

• SELECT govt_hecs_payment_option, s_hecs_payment_type, meaning, allow_discount_ind, closed_ind FROM apps.igs_fi_gov_hec_pa_op_v WHERE closed_ind = 'N';

To resolve a specific payment type by its descriptive meaning:

• SELECT govt_hecs_payment_option, description, meaning FROM apps.igs_fi_gov_hec_pa_op_v WHERE meaning = :p_payment_type;

For validation or reconciliation against the lookup directly, an outer join back to the base table can identify orphan codes excluded by the view's inner join. Because the object is a view, it is read-only; any DML must be performed against IGS_FI_GOV_HEC_PA_OP. Access is governed by the standard APPS schema grants and any associated menu/responsibility restrictions.