Results for “target_fee_type”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_FI_WAIVER_PGMS is a transactional configuration table in the Oracle E-Business Suite IGS — Student System product (now marked obsolete). It stores the waiver programs defined within the institution and the related control information governing how each waiver is applied to student fee accounts. A waiver program is the reusable definition that determines which target fee can be waived, the amount or percentage allocated, the credit type employed, and the eligibility criteria that must be met. Because the table is obsolete, it is not implemented in current databases; the documentation below reflects the historical 12.1.1 / 12.2.2 schema and is retained for reference and migration analysis.

From the documented foreign key topology, the object exhibits a heuristic Data Vault classification of satellite-leaning. It centres on the fee calendar instance and carries descriptive, mutable attributes (status, description, method, percentage allocation) rather than performing a pure hub or link function.

Key Information Stored

The table is documented with 19 columns. The primary key is a composite business key, IGS_FI_WAIVER_PGMS_PK (FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, WAIVER_NAME), which uniquely identifies each waiver program within a fee calendar instance. A secondary unique index, IGS_FI_WAIVER_PGMS_N1 (FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, TARGET_FEE_TYPE), enforces that only one waiver program may target a given fee type per calendar instance — a critical integrity rule.

• FEE_CAL_TYPE / FEE_CI_SEQUENCE_NUMBER — identify the fee calendar instance (FK to IGS_CA_INST_ALL) that scopes the waiver.
• WAIVER_NAME — the program's business identifier within that calendar.
• TARGET_FEE_TYPE — the fee type the waiver reduces; this is the column the user searched for, and it participates in both the N1 unique index and a foreign key to IGS_FI_FEE_TYPE_ALL.
• ADJUSTMENT_FEE_TYPE and RULE_FEE_TYPE — additional fee types (also FK to IGS_FI_FEE_TYPE_ALL) used in adjustment and rule evaluation logic.
• WAIVER_METHOD_CODE, WAIVER_MODE_CODE, WAIVER_CRITERIA_CODE — control the method of waiver, the operational mode, and the qualifying criteria.
• WAIVER_PERCENT_ALLOC — the percentage allocation applied to the target fee.
• CREDIT_TYPE_ID — the credit type (FK to IGS_FI_CR_TYPES_ALL) used when posting the waiver.
• WAIVER_STATUS_CODE and WAIVER_DESC — descriptive state and text.
• OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard concurrency and audit columns.

Common Use Cases and Queries

Typical reporting identifies which waiver program applies to a given target fee, or lists all programs active within a fee calendar. A representative query:

• List programs targeting a specific fee type: SELECT waiver_name, fee_cal_type, fee_ci_sequence_number, waiver_percent_alloc FROM igs_fi_waiver_pgms WHERE target_fee_type = :fee_type AND waiver_status_code = 'ACTIVE';
• Resolve the target fee description by joining to IGS_FI_FEE_TYPE_ALL on TARGET_FEE_TYPE.
• Trace prerequisite chains by joining IGS_FI_WAV_PR_PREQS on FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER and WAIVER_NAME.

Because the secondary index enforces a one-target-fee-per-calendar rule, validation scripts should confirm no duplicate TARGET_FEE_TYPE values exist within an instance before migration.

Related Objects

• IGS_FI_FEE_TYPE_ALL — referenced three times (TARGET_FEE_TYPE, ADJUSTMENT_FEE_TYPE, RULE_FEE_TYPE).
• IGS_CA_INST_ALL — fee calendar instance parent (FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER).
• IGS_FI_CR_TYPES_ALL — credit type referenced by CREDIT_TYPE_ID.
• IGS_FI_WAV_PR_PREQS — prerequisite relationships referencing this table on FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER and WAIVER_NAME.
• IGS_FI_WAV_STD_PGMS — student-level waiver program assignments keyed to this table.