Results for “igs_pr_ul_mark_cnfg”

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

Overview

The IGS_PR_UL_MARK_CNFG table is a core configuration object within the Oracle EBS IGS – Student System product (Advanced Planning / Records & Marks). It defines the configuration rules used to calculate marks at the unit level, establishing the parameters by which assessment outcomes are derived for a given course, version, and unit level. The table is owned by the IGS schema and holds status VALID in the documented 12.1.1 release; the same definition applies to 12.2.2.

The table is uniquely identified by the primary key constraint IGS_PR_UL_MARK_CNFG_PK, which is defined on the single column MARK_CONFIG_ID. This surrogate key is the value users typically search for against the phrase "mark_config_id," and it is the identifier propagated to child detail records.

From a Data Vault modeling perspective, the metadata classifies this object as satellite-leaning. It should therefore be treated as a descriptive, dependent entity rather than an independent business hub: it carries the configurable attributes that qualify a parent business key composed of COURSE_CD, VERSION_NUMBER, and UNIT_LEVEL, and it functions as a parent/aggregate for line-level detail rows.

Key Information Stored

The documented physical schema exposes eleven columns. The most significant are:

• MARK_CONFIG_ID — Surrogate primary key; the unique identifier for each mark-configuration record and the value joined to downstream detail rows.
• COURSE_CD — Course identifier; part of the foreign key to IGS_PS_VER_ALL and a business-key candidate for the configuration.
• VERSION_NUMBER — Version of the course, joined with COURSE_CD to the version table.
• UNIT_LEVEL — The unit level to which the mark configuration applies; foreign key to IGS_PS_UNIT_LEVEL_ALL.
• TOTAL_UNIT_LEVEL_CREDITS — The total credit weighting defined for the unit level, used when computing marks or results.
• SELECTION_METHOD_CODE — Code determining the method by which marks are selected or aggregated (for example, best-of or weighted selection).
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS Who columns capturing audit and concurrency information.

The combination of COURSE_CD, VERSION_NUMBER, and UNIT_LEVEL is the practical business key even though only MARK_CONFIG_ID is enforced as a unique index in the documented metadata.

Common Use Cases and Queries

Typical usage is to retrieve the configuration that governs mark calculation for a given course/version/unit-level combination, and then to resolve the associated detail rules.

• Looking up the configuration identifier for a course and unit level:

SELECT mark_config_id, course_cd, version_number, unit_level,
       total_unit_level_credits, selection_method_code
FROM   igs.igs_pr_ul_mark_cnfg
WHERE  course_cd = :course_cd
AND    version_number = :version_number
AND    unit_level = :unit_level;

• Reporting configured credit weighting and selection methods by unit level across a version.
• Driving the child detail rules through the mark_config_id key:

SELECT d.*
FROM   igs.igs_pr_ul_mark_dtl d
WHERE  d.mark_config_id = :mark_config_id;

Because the table is configuration rather than transactional, reporting joins are usually one configuration row to many detail rows, making it a reliable driver for assessment and results reporting.

Related Objects

The ETRM relationship data identifies the following key dependencies:

• IGS_PR_UL_MARK_DTL — Child detail table referencing MARK_CONFIG_ID; holds the per-line rules that implement the configuration.
• IGS_PS_UNIT_LEVEL_ALL — Parent reference for UNIT_LEVEL, supplying valid unit-level definitions.
• IGS_PS_VER_ALL — Parent reference for COURSE_CD and VERSION_NUMBER, supplying course version context.
• IGS_PR_UL_MARK_CNFG_PK — The primary key constraint enforcing uniqueness on MARK_CONFIG_ID.

Collectively these objects form the configuration layer of the unit-level mark calculation framework in the Oracle Student System.