Results for “igs_fi_fee_as_rate”

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

Overview

IGS_FI_FEE_AS_RATE is a fee assessment configuration table within the Oracle E-Business Suite Student System (IGS) product family. It defines the method and set of parameters used by the fee assessment engine to determine the amount to charge against a specific fee category fee liability. Each row effectively captures a "rate rule" that the assessment process evaluates when calculating charges for a student's fee liability.

The table is highly dimensional in nature: it carries a surrogate primary key, FAR_ID, alongside multiple business-key candidate indexes (IGS_FI_FEE_AS_RATE_U1 on FAR_ID, U2 on FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, RATE_NUMBER, FEE_CAT, and U3 which adds S_RELATION_TYPE). A significant portion of its columns are foreign keys pointing to attendance, course, unit, residency, and organizational reference data, indicating that IGS_FI_FEE_AS_RATE behaves primarily as a descriptive attribute store for its parent entities. Consistent with the supplied heuristic Data Vault classification of "satellite-leaning," this object is best modeled as a satellite attached to its fee type/calendar-instance hub, rather than as a hub or link.

Key Information Stored

The most significant columns include the following. FAR_ID is the surrogate primary key generated for each rate record. The composite business key is formed by FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, RATE_NUMBER, and FEE_CAT, and is extended with S_RELATION_TYPE in the U3 variant — this combination uniquely identifies a rate row within a fee category and calendar instance.

• FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER — identify the fee type and the specific fee calendar instance the rate applies to.
• RATE_NUMBER — the sequence/priority identifier for the rate rule, which is central to the user's search term.
• FEE_CAT — the fee category (liability category) the rate is assessed against.
• CHG_RATE — the charge rate or amount value to be applied.
• S_RELATION_TYPE — the student relationship type dimension used to scope the rate.
• ORDER_OF_PRECEDENCE — controls evaluation order when multiple rate rules could apply.
• ATTENDANCE_TYPE, ATTENDANCE_MODE — attendance-based qualification criteria.
• COURSE_CD, VERSION_NUMBER — course and version scope for the rate.
• UNIT_CD, UNIT_VERSION_NUMBER, UNIT_SET_CD, UNIT_CLASS, UNIT_LEVEL, UNIT_TYPE_ID, UNIT_MODE — unit-level scoping dimensions.
• RESIDENCY_STATUS_ID, RESIDENCY_STATUS_CD — residency-based differentiation.
• CLASS_STANDING — class standing qualifier.
• GOVT_HECS_PAYMENT_OPTION, GOVT_HECS_CNTRBTN_BAND — HECS contribution configuration.
• ORG_PARTY_ID, LOCATION_CD — organizational party and location scope.
• LOGICAL_DELETE_DT and the standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE) — support soft deletion and auditing.

Common Use Cases and Queries

Typical reporting scenarios include auditing which rate rules are configured for a fee type, tracing which rule produced a given assessed amount, and verifying that precedence ordering resolves conflicts as intended. A frequently used pattern is to retrieve all active rates for a fee category within a calendar instance:

• SELECT RATE_NUMBER, FEE_CAT, CHG_RATE, ORDER_OF_PRECEDENCE FROM IGS_FI_FEE_AS_RATE WHERE FEE_TYPE = :p_fee_type AND FEE_CAL_TYPE = :p_cal_type AND FEE_CI_SEQUENCE_NUMBER = :p_seq AND FEE_CAT = :p_cat AND LOGICAL_DELETE_DT IS NULL ORDER BY ORDER_OF_PRECEDENCE;
• Joining to IGS_FI_SUB_ER_RT on FAR_ID to find sub-entity rate detail associated with a given rate record.
• Joining to IGS_FI_ELM_RANGE_RT on FEE_TYPE to reconcile element range rates with the governing assessment rates.

Related Objects

The table participates in a dense foreign-key network. The most significant related objects, with their join columns, are:

• IGS_FI_F_TYP_CA_INST_ALL — joined on FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER; the parent fee type/calendar instance.
• IGS_FI_F_CAT_FEE_LBL_ALL — joined on FEE_CAT and the calendar-instance columns; the fee category definition.
• IGS_FI_GOVT_HEC_CNTB — joined on GOVT_HECS_CNTRBTN_BAND; HECS contribution bands.
• IGS_FI_GOV_HEC_PA_OP — joined on GOVT_HECS_PAYMENT_OPTION; HECS payment options.
• IGS_PR_CLASS_STD — joined on CLASS_STANDING.
• IGS_PE_CODE_CLASSES — joined on RESIDENCY_STATUS_ID.
• IGS_PS_UNIT, IGS_PS_UNIT_VER_ALL — joined on UNIT_CD (and UNIT_VERSION_NUMBER).
• HZ_PARTIES — joined on ORG_PARTY_ID for the owning organization.
• IGS_FI_SUB_ER_RT — a child table referencing FAR_ID.
• IGS_FI_ELM_RANGE_RT — a child table referencing FEE_TYPE.