Results for “igs_ps_fee_trg”

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

Overview

IGS_PS_FEE_TRG is an Oracle E-Business Suite table belonging to the IGS — Student System product family. It describes program-based fee triggers and is referenced during fee assessment processing to indicate that a program-based fee applies for a given fee type. In functional terms, the table records the conditions under which the fee assessment engine should raise a specific fee for a student's program, course, location, attendance mode, or attendance type.

The ETRM metadata classifies this object, heuristically mined from its foreign-key structure, as a link table in a Data Vault modeling sense. This is consistent with its design: it sits between fee catalogue definitions, program/course structures, and organizational dimensions such as location and attendance attributes. It does not hold descriptive history of a single business entity; instead it associates several reference entities to produce a trigger rule.

In Oracle EBS 12.1.1 and 12.2.2, IGS_PS_FEE_TRG is documented in ETRM with an owner of IGS and a physical schema of 23 columns. The ETRM implementation note states that the table is "Not implemented in this database," meaning some environments may not contain the physical object even though the definition is catalogued.

Key Information Stored

The table's primary key is IGS_PS_FEE_TRG_PK, defined over FEE_CAT, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, FEE_TYPE, COURSE_CD, and SEQUENCE_NUMBER. A unique index, IGS_PS_FEE_TRG_U1, covers the same six columns, confirming this composite as the business-key candidate in addition to the surrogate primary key.

• FEE_CAT / FEE_CAL_TYPE / FEE_CI_SEQUENCE_NUMBER / FEE_TYPE — identify the fee catalogue, calendar type, calendar instance sequence, and fee type that the trigger applies to.
• COURSE_CD — the course against which the program-based fee trigger is scoped.
• SEQUENCE_NUMBER — distinguishes multiple trigger rows for the same fee/course combination.
• VERSION_NUMBER and CAL_TYPE — support versioning and calendar classification of the trigger.
• LOCATION_CD — the delivery location associated with the trigger.
• ATTENDANCE_MODE and ATTENDANCE_TYPE — the attendance characteristics that qualify the fee.
• FEE_TRIGGER_GROUP_NUMBER — groups related triggers for assessment processing.
• LOGICAL_DELETE_DT — supports soft deletion without physical row removal.
• Standard WHO/audit columns such as CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE, plus concurrent-program columns (REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID).

Common Use Cases and Queries

Typical usage centres on fee assessment configuration and reporting. A common pattern is to retrieve all triggers for a fee catalogue or course:

• Listing active trigger rules for a fee type, filtering out logically deleted rows: SELECT * FROM igs_ps_fee_trg WHERE fee_type = :p_fee_type AND logical_delete_dt IS NULL;
• Joining to the course table to validate that the trigger references an existing programme/course: SELECT t.* FROM igs_ps_fee_trg t, igs_ps_course c WHERE t.course_cd = c.course_cd;
• Grouping by FEE_TRIGGER_GROUP_NUMBER to review trigger sets configured for assessment runs.
• Auditing changes via LAST_UPDATE_DATE and LAST_UPDATED_BY to trace configuration drift.

Because the table feeds fee assessment processing, reconciliation reports typically join it to fee catalogue label definitions and location definitions to present a human-readable view of each trigger.

Related Objects

The documented foreign keys identify the principal reference objects:

• IGS_FI_F_CAT_FEE_LBL_ALL — joined on FEE_CAT, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, and FEE_TYPE, supplying fee catalogue labels.
• IGS_FI_FEE_TRG_GRP — joined on the same four fee columns plus FEE_TRIGGER_GROUP_NUMBER, defining trigger groupings.
• IGS_PS_COURSE — joined on COURSE_CD.
• IGS_CA_TYPE — joined on CAL_TYPE.
• IGS_AD_LOCATION_ALL — joined on LOCATION_CD.
• IGS_EN_ATD_MODE_ALL — joined on ATTENDANCE_MODE.
• IGS_EN_ATD_TYPE_ALL — joined on ATTENDANCE_TYPE.

These relationships confirm the table's role as a link joining fee, programme, calendar, location, and attendance reference data into a single trigger definition consumed during fee assessment.