Search Results allow_discount_ind

Overview

The view APPS.IGS_FI_GOV_HEC_PA_OP_V is a reporting and integration object within the Oracle E-Business Suite Student System (IGS) product family. It exposes the set of government HECS (Higher Education Contribution Scheme) payment options that control how a student may satisfy a government-funded tuition liability. In an EBS 12.1.1 or 12.2.2 environment, the view resides in the APPS schema with a status of VALID. Its principal role is to present the denormalized, human-readable form of the HECS payment option codes by resolving the coded payment type against the application lookup repository. Rather than forcing downstream reports, concurrent programs, or integration interfaces to join the base entity table to the lookup view themselves, this view performs that join once and exposes the decoded meaning directly. This makes it suitable for LOVs, seeded reports, and inbound/outbound interface mapping that require a clean list of valid payment options together with their descriptions and status flags.

Underlying Base Objects

The view text documents two referenced objects:

• IGS_FI_GOV_HEC_PA_OP GHPO — the base entity table holding the government HECS payment option definitions.
• IGS_LOOKUPS_VIEW LKUPS — the standard lookups view used to decode the payment type code into a user-facing meaning.

The defining query performs an inner join between these two objects, linking LKUPS.LOOKUP_CODE to GHPO.S_HECS_PAYMENT_TYPE and restricting LKUPS.LOOKUP_TYPE to the value 'HECS_PAYMENT_TYPE'. Because it is an inner join, only payment option rows whose payment type resolves to a valid lookup entry are returned. The view is owned by APPS, which is consistent with the other seeded IGS financial views; consumers should therefore reference it as APPS.IGS_FI_GOV_HEC_PA_OP_V or via a synonym rather than querying the base table directly.

Key Columns

• ROW_ID — the ROWID of the underlying base table row, used by the Forms/BC4J framework for row identification.
• GOVT_HECS_PAYMENT_OPTION — the primary business key identifying the payment option.
• DESCRIPTION — free-text description of the payment option as stored on the base record.
• S_HECS_PAYMENT_TYPE — the system-coded payment type, key to the HECS_PAYMENT_TYPE lookup type.
• ALLOW_DISCOUNT_IND — indicator of whether a discount is permitted for this option.
• CLOSED_IND — indicator that the payment option has been closed and should not be selected for new transactions.
• MEANING — the decoded, display-ready meaning of the payment type obtained from the lookup view; this is the column report users typically present.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit (WHO) columns inherited from the base table.

Common Use Cases and Queries

Typical uses include populating list-of-values regions on payment capture forms, driving HECS reconciliation and financial reporting extract, and validating payment option values in interface staging tables. A representative query listing active options with their decoded meaning follows:

SELECT govt_hecs_payment_option,
       description,
       meaning,
       allow_discount_ind
FROM   apps.igs_fi_gov_hec_pa_op_v
WHERE  closed_ind = 'N'
ORDER  BY meaning;

To retrieve the full domain, including retired options, omit the closed_ind predicate. Because MEANING is sourced from IGS_LOOKUPS_VIEW, calls made through this view automatically reflect lookup maintenance performed in the application, ensuring that reporting labels stay synchronized with the seeded HECS_PAYMENT_TYPE lookup codes.