Results for “crs_version_number”

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

Overview

IGS_FI_FAI_DTLS is a transactional table in the IGS (Student System) schema of Oracle E-Business Suite, documented as VALID in both 12.1.1 and 12.2.2. Its description identifies it as the Fee Assessment Item Detail table, which stores the unit information associated with a fee assessment item record. In functional terms, each row represents one assessed fee line tied to a specific unit attempt or unit offering, carrying both the charge basis and the resulting fee amount.

The table sits in the core fee assessment path of the Student System: fee assessment items are generated for enrolled or attempting students, and the detail rows decompose those items into the units, unit sets, and unit offering options that drove the calculation. From a Data Vault modeling perspective, the metadata's heuristic classification is link, since the table's dominant role is to associate fee assessment items with unit sets and unit offering options. It also carries descriptive and measurable attributes such as fee category, charge elements, and fee amount, so a satellite component would typically be modeled alongside the link.

Key Information Stored

The surrogate primary key is FEE_AS_ITEM_DTL_ID, enforced by unique index IGS_FI_FAI_DTLS_PK, which is the only documented business-key candidate. The table contains 19 documented columns; the most significant are grouped below.

• FEE_AS_ITEM_DTL_ID — surrogate primary key uniquely identifying each detail line.
• FEE_ASS_ITEM_ID — foreign key to IGS_FI_FEE_AS_ITEMS, linking the detail to its parent fee assessment item.
• FEE_CAT — fee category, classifying the nature of the assessed charge.
• COURSE_CD and CRS_VERSION_NUMBER — the course and version against which the fee was assessed.
• UNIT_ATTEMPT_STATUS — status of the student's unit attempt at the time of assessment.
• ORG_UNIT_CD and LOCATION_CD — owning organizational unit and delivery location.
• CLASS_STANDING — the student's class standing used in fee determination.
• UOO_ID — foreign key to IGS_PS_UNIT_OFR_OPT_ALL, identifying the unit offering option.
• UNIT_SET_CD and US_VERSION_NUMBER — foreign keys to IGS_EN_UNIT_SET_ALL, identifying the unit set and its version.
• CHG_ELEMENTS — charge elements describing how the fee was composed.
• FEE_AMOUNT — the assessed monetary value for this detail line.
• CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard Oracle EBS WHO audit columns.

Common Use Cases and Queries

Typical reporting scenarios include fee assessment reconciliation, audit of assessed amounts by course or location, and analysis of charges by fee category. A common pattern joins the detail to its parent item and to the unit set definition:

• Reconciling detail amounts to parent fee assessment items: SELECT d.FEE_AS_ITEM_DTL_ID, d.FEE_ASS_ITEM_ID, d.FEE_AMOUNT FROM IGS.IGS_FI_FAI_DTLS d WHERE d.FEE_ASS_ITEM_ID = :item_id;
• Aggregating assessed fees by category and location: SELECT FEE_CAT, LOCATION_CD, SUM(FEE_AMOUNT) FROM IGS.IGS_FI_FAI_DTLS GROUP BY FEE_CAT, LOCATION_CD;
• Resolving unit set context via the foreign key: SELECT d.FEE_AS_ITEM_DTL_ID, u.UNIT_SET_CD, d.FEE_AMOUNT FROM IGS.IGS_FI_FAI_DTLS d, IGS.IGS_EN_UNIT_SET_ALL u WHERE d.UNIT_SET_CD = u.UNIT_SET_CD AND d.US_VERSION_NUMBER = u.US_VERSION_NUMBER;
• Auditing recent changes using WHO columns filtered on LAST_UPDATE_DATE.

Related Objects

The FK metadata identifies the principal related objects. IGS_FI_FEE_AS_ITEMS is the parent fee assessment item table, joined on FEE_ASS_ITEM_ID. IGS_EN_UNIT_SET_ALL supplies unit set definition, joined on UNIT_SET_CD and US_VERSION_NUMBER. IGS_PS_UNIT_OFR_OPT_ALL supplies unit offering option context, joined on UOO_ID. Beyond these documented relationships, reports commonly traverse to student enrollment and fee calendar objects to complete the assessment picture. All joins should respect the IGS schema owner and the documented key columns.