Results for “fee_cat”

50+ results




Overview
Explore in AI Chat

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

Overview

IGS_PS_TYPE_FEE_TRG is a reference and control table within the Oracle E-Business Suite Student System (IGS) product family, owned by the IGS schema. It describes program type based fee triggers, which are records used during fee assessment processing to indicate that a program type based fee applies for a particular fee type. In practical terms, the table acts as a bridge between the fee configuration model (fee categories, fee calendars, fee types) and the academic program type model, allowing the fee assessment engine to determine whether a given student's program type causes a specific fee to be triggered.

Because the table carries foreign key references to both IGS_PS_TYPE_ALL (the program type reference) and IGS_FI_F_CAT_FEE_LBL_ALL (the fee category / fee type label reference), the mined Data Vault classification heuristic identifies it as a link entity. This classification should be treated as a modeling suggestion: the table's physical structure is a transactional-style intersection that resolves a many-to-many relationship between program types and fee definitions, qualified by calendar and sequence context. The table is listed as VALID and is present in both Oracle EBS 12.1.1 and 12.2.2 documentation sets.

Key Information Stored

The table is documented with 16 physical columns. The most significant columns for functional and reporting purposes are:

  • FEE_CAT — the fee category, part of both the primary key and the unique business key. It joins to IGS_FI_F_CAT_FEE_LBL_ALL.
  • FEE_CAL_TYPE — the fee calendar type that qualifies which calendar the fee definition belongs to.
  • FEE_CI_SEQUENCE_NUMBER — the calendar instance sequence number, identifying the specific calendar instance within the calendar type.
  • FEE_TYPE — the fee type being triggered, completing the fee-side qualification of the record.
  • COURSE_TYPE — the program type against which the fee trigger is defined; this is the foreign key column referencing IGS_PS_TYPE_ALL.
  • CREATE_DT — the creation date of the trigger record, which participates in the primary key and unique index, indicating that effective-dated or version-controlled trigger definitions are supported.
  • LOGICAL_DELETE_DT — the date on which the record was logically deleted, supporting soft-delete semantics common in the Student System.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS WHO columns providing audit traceability.
  • REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — standard concurrent program and multi-org/concurrent request context columns used to trace which batch process inserted or updated the row.

The surrogate-style primary key IGS_PS_TYPE_FEE_TRG_PK is composed of FEE_CAT, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, FEE_TYPE, COURSE_TYPE and CREATE_DT. The unique index IGS_PS_TYPE_FEE_TRG_U1 carries the same column list, meaning the business key and the primary key coincide — there is no separate single-column surrogate key. Consequently, uniqueness is enforced across the full combination of fee identification plus program type plus creation date.

Common Use Cases and Queries

The primary consumer of this table is fee assessment processing. When a fee is being calculated for a student, the process must determine whether the fee is a general fee or a program type based fee. The presence of a row in IGS_PS_TYPE_FEE_TRG for a matching fee category, calendar type, calendar instance sequence, fee type and course type indicates that the program type based fee applies.

Typical reporting queries resolve the trigger records against their reference tables:

  • Listing all program types that trigger a given fee: join IGS_PS_TYPE_FEE_TRG to IGS_PS_TYPE_ALL on COURSE_TYPE to obtain the descriptive program type name, filtered by FEE_CAT and FEE_TYPE.
  • Reconciling fee setup: join to IGS_FI_F_CAT_FEE_LBL_ALL on FEE_CAT, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER and FEE_TYPE to display the human-readable fee label alongside the trigger.
  • Auditing changes: query using LAST_UPDATE_DATE, LAST_UPDATED_BY, REQUEST_ID and PROGRAM_ID to trace which concurrent program introduced or modified trigger rows during a fee assessment run.
  • Detecting retired configuration: filter on LOGICAL_DELETE_DT IS NULL to exclude logically deleted triggers from effective date reporting.

Related Objects

The following objects are the most significant related references for this table, based on the documented foreign key and key structure:

  • IGS_PS_TYPE_ALL — referenced via COURSE_TYPE; supplies the program type definition that a fee trigger applies to.
  • IGS_FI_F_CAT_FEE_LBL_ALL — referenced via FEE_CAT, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER and FEE_TYPE; supplies the fee label and category definition.
  • IGS_PS_TYPE_FEE_TRG_PK — the primary key constraint, defining the composite uniqueness of the trigger records.
  • IGS_PS_TYPE_FEE_TRG_U1 — the unique business key index, identical in column composition to the primary key.
  • Fee assessment processing programs and the broader IGS fee calendar and fee type reference tables, which supply the calendar type and instance context consumed by this table.