Results for “igf_aw_career_map_all”

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

Overview

IGF_AW_CAREER_MAP_ALL is a Financial Aid configuration table within the Oracle E-Business Suite IGF (Financial Aid) module. Its documented purpose is to store the mapping between Student System Program Types and Financial Aid Class Standings, so that the resulting combination satisfies the Career Level requirements used in FISAP (Fiscal Operations Report and Application to Participate) reporting. Career Level is a mandatory reporting attribute for federal campus-based aid programs, and institutions must be able to translate their internal academic classification scheme into the standardized values expected by the U.S. Department of Education. This table provides that translation layer.

The metadata explicitly declares the object as a Multi-Org table. Accordingly it carries an ORG_ID column, and the "_ALL" suffix in the name reflects that the same logical mapping definition can exist independently for each operating unit represented in the installation. Queries against this table in a multi-org environment should therefore either be constrained by ORG_ID explicitly or executed in a session where the Multi-Org views and security profile already restrict the visible rows.

The documentation set classifies the table's Data Vault role, via heuristic mining of the foreign key structure, as standalone. In Data Vault modeling terms this suggests treating the entity as a self-contained reference or lookup structure rather than as a hub with dependent satellites, or as a link resolving two or more business entities. The absence of documented inbound or outbound foreign key relationships supports that interpretation: the table is referenced by configuration and reporting logic rather than by a rigid referential chain.

The object is flagged as part of the IGF – Financial Aid module and is marked obsolete in the current product documentation. It is also recorded as not implemented in the documented database instance. Both facts indicate that the table should be treated as a legacy or dormant artifact in release 12.1.1 and 12.2.2 environments: it may exist in the schema definition but be empty, or it may be absent entirely depending on which Financial Aid patches and country-specific extensions were applied.

Key Information Stored

The table is documented with nine physical columns. The most significant are the three business attributes and the multi-org discriminator.

• CAREER_LEVEL_ID — The surrogate primary key, defined by the constraint IGF_AW_CAREER_MAP_PK. It also participates in the unique index IGF_AW_CAREER_MAP_ALL_U1, meaning the identifier is enforced as unique in its own right. This is the value most likely consumed by downstream FISAP reporting logic when it needs to resolve a career level for a student record.
• PROGRAM_TYPE — The Student System program type, representing the institution's internal academic program classification.
• CLASS_STANDING — The Financial Aid class standing value, representing the standardized classification used in federal reporting.
• PROGRAM_TYPE and CLASS_STANDING together form the business key, enforced by the unique index IGF_AW_CAREER_MAP_ALL_U2. This composite uniqueness guarantees that any given program-type and class-standing pair resolves to exactly one career level, preventing ambiguous mappings.
• ORG_ID — The Multi-Org operating unit discriminator, present because the metadata designates the table as a Multi-Org object.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN follow the standard Oracle EBS WHO-column convention and record the identity and timestamp of the row's original creation and most recent modification.

The surrogate key (CAREER_LEVEL_ID) and the business-key candidate (PROGRAM_TYPE plus CLASS_STANDING) serve different purposes. The surrogate key is a stable internal reference suitable for foreign key propagation and programmatic lookup, while the composite business key is the meaningful uniqueness constraint that reflects the real-world rule being modeled.

Common Use Cases and Queries

The primary use case is configuration maintenance and verification: administrators confirm that every program type and class standing combination in use at the institution maps to a valid career level. A secondary use case is FISAP extract validation, where the reporting process joins student records to this table to derive the career level that must appear on the federal return.

A straightforward lookup of the configured mappings is the most common query pattern:

• SELECT career_level_id, program_type, class_standing, org_id FROM igf.igf_aw_career_map_all WHERE org_id = :p_org_id ORDER BY program_type, class_standing;

To test whether a specific combination is configured before attempting an insert or update, the composite business key can be probed directly:

• SELECT career_level_id FROM igf.igf_aw_career_map_all WHERE program_type = :p_program_type AND class_standing = :p_class_standing AND org_id = :p_org_id;

A reconciliation query useful during implementation verifies that no duplicate or overlapping definitions exist, which the U2 unique index should already prevent:

• SELECT program_type, class_standing, COUNT(*) FROM igf.igf_aw_career_map_all GROUP BY program_type, class_standing HAVING COUNT(*) > 1;

Because the table is documented as obsolete and not implemented, any query returning rows should be treated as an exception requiring confirmation that the environment has been correctly patched.

Related Objects

The documentation records no explicit foreign key relationships for this object, and the heuristic Data Vault classification is standalone. Consequently, the related-object list below is drawn from the module context and from the internal constraints documented above rather than from referential integrity metadata.

• IGF_AW_CAREER_MAP_PK — The primary key constraint on CAREER_LEVEL_ID; any consumer resolving a career level will use this index path.
• IGF_AW_CAREER_MAP_ALL_U1 — Unique index on CAREER_LEVEL_ID, reinforcing surrogate-key uniqueness.
• IGF_AW_CAREER_MAP_ALL_U2 — Composite unique index on PROGRAM_TYPE and CLASS_STANDING, enforcing the business-key rule.
• IGF_AW_CLASS_STANDINGS_ALL — The Financial Aid class standings reference table whose values supply the CLASS_STANDING column.
• IGF_AW_PROGRAM_TYPES_ALL — The Student System program type reference table supplying the PROGRAM_TYPE column.
• FISAP reporting and extract programs within the IGF module, which consume the resolved career level when producing the federal return.
• Student System (Student Records) program and plan tables, which provide the program type and class standing values that must be reconciled against this mapping.
• Multi-Org views and security profiles, which filter the ORG_ID column for the active operating unit.

Given the obsolete and unimplemented status of the object, implementers should confirm the presence of any dependent reporting logic in their specific 12.1.1 or 12.2.2 instance before relying on these relationships.