Search Results igs_co_mapping_v




Overview
Explore in AI Chat

Overview

IGS_CO_MAPPING_V is a reporting view within the IGS (Student System) product family, categorized in ETRM documentation under the descriptor "Mapping and Attributes." The IGS Student System is classified as obsolete in Oracle EBS 12.1.1 and 12.2.2, and this view is documented as not implemented in the reference database. Its purpose is to expose correspondence mapping records that associate content items with document handling behaviors—such as email, fax, and print delivery—for the Oracle iLearning/Content infrastructure (IBC) tables that IGS leverages for communications management. The view is a UNION ALL construct, meaning it returns a de-duplicated set of mapping rows across multiple content-item resolution paths, enriching raw mapping data with lookup-decoded values and content item descriptors.

Underlying Base Objects

The view text identifies three documented sources: IGS_CO_MAPPING (the driving table, aliased CMAP), IBC_CITEMS_V (aliased CITM), and IBC_CONTENT_ITEMS (aliased CONITEM). The join logic requires CMAP.DOCUMENT_ID = CITM.CITEM_ID, restricts content type to IBC_QUERY, filters MAP_CODE = 'LIST', applies the session language through USERENV('LANG'), and enforces that the content item version matches its live version via CITEM_ID = CONITEM.CONTENT_ITEM_ID and CITEM_VER_ID = CONITEM.LIVE_CITEM_VERSION_ID. Lookup decoding is delegated to the function IGS_GE_GEN_004.GENP_GET_LOOKUP, and delivery-capability flags are derived through correlated subqueries against IBC_CTYPE_GROUP_NODES using directory node identifiers 32 and 33. Although the ETRM metadata lists no documented referenced base objects, the view text conclusively establishes IGS_CO_MAPPING as its foundational table.

Key Columns

Common Use Cases and Queries

Typical usage centers on reviewing active mappings, assessing reminder intervals, and auditing delivery configuration. A representative query filtering on the elapsed-days attribute follows:

SELECT map_id, document_id, map_description, elapsed_days, repeat_times, enable_flag
FROM igs_co_mapping_v
WHERE elapsed_days IS NOT NULL
ORDER BY elapsed_days;

Analysts may also aggregate by document type or delivery channel:

SELECT document_type, COUNT(*) item_count, AVG(elapsed_days) avg_days
FROM igs_co_mapping_v
WHERE enable_flag = 'Y'
GROUP BY document_type;

Because the view is documented as obsolete and not implemented in the reference database, any query must be validated against the actual instance before reliance. Where the view is absent, equivalent logic can be reconstructed directly from IGS_CO_MAPPING joined to IBC_CITEMS_V and IBC_CONTENT_ITEMS, applying the same MAP_CODE and content-type predicates shown in the view definition.