Results for “igs_fi_fee_cat_map”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGS_FI_FEE_CAT_MAP is a reference and cross-reference table within the Oracle E-Business Suite Student System (IGS) product family. Its documented purpose is to describe special contract-based fee assessment rates, meaning it associates a fee category with an admission category so that contract-specific pricing or assessment behavior can be applied during fee calculation. The table resides in the IGS schema and carries a VALID status in both Oracle EBS 12.1.1 and 12.2.2 releases. Physically it is a narrow table, consisting of eight documented columns and one composite unique index.
Under a heuristic Data Vault classification mined from the foreign key structure, this entity is best modeled as a link. The rationale is that the table exists primarily to resolve and record a relationship between two independent reference entities — the fee category and the admission category — rather than to store descriptive attributes about a single business key. Analysts designing a dimensional or Data Vault representation of IGS fee configuration should therefore treat IGS_FI_FEE_CAT_MAP as an associative construct joining IGS_FI_FEE_CAT_ALL and IGS_AD_CAT_ALL.
Key Information Stored
The table is defined by a small set of business-relevant columns supplemented by standard Oracle EBS auditing columns.
- FEE_CAT — the fee category identifier. This is the first component of the primary key IGS_FI_FEE_CAT_MAP_PK and of the unique index IGS_FI_FEE_CAT_MAP_U1, and it is a foreign key to IGS_FI_FEE_CAT_ALL.
- ADMISSION_CAT — the admission category identifier. This is the second component of both the primary key and the unique index, and it is a foreign key to IGS_AD_CAT_ALL.
- DFLT_CAT_IND — a default category indicator. This flag designates whether the mapped combination functions as the default for the associated category pair, allowing the fee engine to select a fallback mapping when no explicit contract rate applies.
- CREATED_BY, CREATION_DATE — standard audit columns recording the user and timestamp of row creation.
- LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns recording the most recent modification user, timestamp, and login session.
Because FEE_CAT and ADMISSION_CAT together form both the primary key and the sole business-key candidate (IGS_FI_FEE_CAT_MAP_U1), the table enforces uniqueness on each category pairing. No separate surrogate key column is documented; the composite of the two foreign keys serves as the primary key.
Common Use Cases and Queries
Typical usage centers on validating and reporting fee assessment configuration. Common scenarios include confirming that every admission category has an appropriate fee category mapping, identifying default mappings via DFLT_CAT_IND, and joining the map to its parent reference tables to present human-readable category names.
A representative join pattern resolves the mapping to its descriptive parents:
- Select m.FEE_CAT, f.description, m.ADMISSION_CAT, a.description, m.DFLT_CAT_IND from IGS_FI_FEE_CAT_MAP m join IGS_FI_FEE_CAT_ALL f on f.FEE_CAT = m.FEE_CAT join IGS_AD_CAT_ALL a on a.ADMISSION_CAT = m.ADMISSION_CAT.
- Filter on m.DFLT_CAT_IND = 'Y' to list default contract-based assessment mappings.
- Query by FEE_CAT alone to enumerate all admission categories mapped to a given fee category.
Reporting use cases include fee configuration audits, reconciliation of contract-based rates against standard fee setup, and data migration validation when loading new admission or fee categories into an institution's Student System implementation.
Related Objects
The following objects are the most significant dependencies, based on the documented foreign key relationships:
- IGS_FI_FEE_CAT_ALL — referenced by IGS_FI_FEE_CAT_MAP.FEE_CAT; provides the parent fee category definition.
- IGS_AD_CAT_ALL — referenced by IGS_FI_FEE_CAT_MAP.ADMISSION_CAT; provides the parent admission category definition.
- IGS_FI_FEE_CAT_MAP_PK — the composite primary key constraint on (FEE_CAT, ADMISSION_CAT).
- IGS_FI_FEE_CAT_MAP_U1 — the unique index on (FEE_CAT, ADMISSION_CAT), confirming the business-key candidate.
Collectively these objects establish IGS_FI_FEE_CAT_MAP as a dependent cross-reference table linking the admission and fee configuration domains within the IGS Student System.
-
This entity describes special contract based fee assessment rates
-
Table: IGS_FI_FEE_CAT_MAP 12.2.2
This entity describes special contract based fee assessment rates
Not implemented in this database·Explore IGS module →
-
PACKAGE: APPS.IGS_AD_VAL_FCM 12.1.1
-
View: IGSFV_ADM_FEE_CAT 12.1.1
APPS.IGSFV_ADM_FEE_CAT·↳ IGS_AD_CAT_ALL·↳ IGS_FI_FEE_CAT_ALL·↳ IGS_FI_FEE_CAT_MAP·Explore IGS module →
-
View: IGSBV_ADM_FEE_CAT 12.1.1
APPS.IGSBV_ADM_FEE_CAT·↳ IGS_FI_FEE_CAT_MAP·Explore IGS module →
-
View: IGSBV_ADM_FEE_CAT 12.2.2
Not implemented in this database·Explore IGS module →
-
Table: IGS_FI_FEE_CAT_ALL 12.2.2
This entity describes special contract based fee assessment rates
Not implemented in this database·Explore IGS module →
-
VIEW: APPS.IGSFV_ADM_FEE_CAT 12.1.1
-
VIEW: APPS.IGSBV_ADM_FEE_CAT 12.1.1
-
Table: IGS_AD_CAT_ALL 12.2.2
Describes user-defined categories of applicant that identify different processing requirements of applicants to institution
Not implemented in this database·Explore IGS module →
-
View: IGSFV_ADM_FEE_CAT 12.2.2
Not implemented in this database·Explore IGS module →
-
PACKAGE: APPS.IGS_AD_GEN_005 12.1.1
-
VIEW: APPS.IGSBV_ADM_FEE_CAT 12.1.1
-
PACKAGE: APPS.IGS_FI_VAL_FC 12.1.1
-
VIEW: APPS.IGSFV_ADM_FEE_CAT 12.1.1
-
PACKAGE: APPS.IGS_AD_VAL_AA 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.
-
12.1.1 DBA Data 12.1.1