Results for “igs_fi_fee_as_rt_ht_all”

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

Overview

The IGS_FI_FEE_AS_RT_HT_ALL table belongs to the IGS (Student System) product family within Oracle E-Business Suite, a module now classified as obsolete in current EBS releases. It is documented as the entity that describes special contract-based fee assessment rates. In operational terms, the table stores the historical and effective-dated rate records applied when assessing fees against a student under a specific contractual arrangement, such as a negotiated corporate, sponsor, or third-party billing agreement rather than standard published tuition and fee schedules.

The Data Vault classification mined heuristically from the foreign key structure is link. This suggests a modeling interpretation in which the table functions as an associative entity resolving relationships between parties, courses, fee types, and effective-dated rate attributes, rather than a pure hub of a single business concept or a satellite carrying descriptive attributes of one parent key. Practitioners designing integration or migration mappings should treat the table accordingly, as a junction of contract-specific fee assessment context.

Key Information Stored

The physical schema documented for ETRM 12.1.1 lists nineteen columns. The most significant are described below.

• PERSON_ID — Identifies the party (student or contract holder) for whom the fee assessment rate applies. This column participates in the primary key and carries a foreign key to HZ_PARTIES.
• COURSE_CD — The course code associated with the assessment rate, forming part of the composite business key.
• FEE_TYPE — The fee category being assessed; foreign keyed to IGS_FI_FEE_TYPE_ALL and part of the primary key.
• START_DT — The effective start date of the rate record, part of the business key.
• HIST_START_DT — The historical start date used for versioning within the effective-dated record set, also part of the primary key.
• HIST_END_DT — The historical end date bounding the versioned record.
• END_DT — The effective end date of the assessment rate.
• CHG_RATE — The contract-based charge rate value applied to the fee assessment.
• LOWER_NRML_RATE_OVRD_IND — Indicator controlling whether the contracted rate may override a lower normal rate.
• LOCATION_CD — The location at which the rate applies.
• ATTENDANCE_TYPE and ATTENDANCE_MODE — Attributes qualifying the attendance context for which the rate is valid.
• HIST_WHO — Audit identifier of the user or process that created the historical version.
• ORG_ID — The operating unit or organization context, supporting multi-org data segregation.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns.

The surrogate-facing primary key is IGS_FI_FEE_AS_RT_HT_PK, composed of PERSON_ID, COURSE_CD, FEE_TYPE, START_DT, and HIST_START_DT. The unique index IGS_FI_FEE_AS_RT_HT_ALL_U1 mirrors this same combination, making it the documented business-key candidate.

Common Use Cases and Queries

Typical usage involves retrieving the effective contracted rate for a party, course, and fee type as of a given date, or auditing historical changes to that rate. A representative query pattern joins the table to HZ_PARTIES and IGS_FI_FEE_TYPE_ALL:

• Effective-rate lookup: filter on PERSON_ID, COURSE_CD, FEE_TYPE, and a date range between START_DT/END_DT or HIST_START_DT/HIST_END_DT.
• Historical trend reporting: order by HIST_START_DT to reconstruct the sequence of rate revisions, using HIST_WHO for change attribution.
• Override analysis: inspect LOWER_NRML_RATE_OVRD_IND alongside CHG_RATE to identify contracts where a negotiated rate supersedes the normal lower rate.
• Multi-org reporting: constrain ORG_ID to the relevant operating unit.

Related Objects

The documented relationships center on two confirmed foreign keys, with additional adjacency implied by the IGS fee assessment schema.

• HZ_PARTIES — joined via IGS_FI_FEE_AS_RT_HT_ALL.PERSON_ID = HZ_PARTIES.PARTY_ID, resolving party identity.
• IGS_FI_FEE_TYPE_ALL — joined via IGS_FI_FEE_AS_RT_HT_ALL.FEE_TYPE = IGS_FI_FEE_TYPE_ALL.FEE_TYPE, providing the fee type definition.
• Fee assessment and calculation tables within the IGS_FI family that consume contracted rates. As the metadata notes, the object is not implemented in the reference database, so confirm availability within the target instance before relying on it in production queries or interfaces.