Results for “unit_selection_code”

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

Overview

The table IGS_PR_UL_MARK_DTL, owned by the IGS schema, is a configuration table within the Oracle E-Business Suite IGS — Student System product family. It defines the configuration details governing how units (modules or course units) are selected and weighted during marks calculation. Specifically, it stores rules such as the core type indicator for a unit, its priority for inclusion in marks calculation, total credit thresholds, and the unit selection codes applied when assembling a student's academic record for grading and progression purposes.

From a Data Vault modeling perspective, the metadata suggests a satellite-leaning classification. The table does not function as an independent business hub; instead, it attaches descriptive rule attributes (core indicator, priority, credit thresholds) to a parent configuration identified by MARK_CONFIG_ID. This positions it as a dependent detail/satellite table whose grain is defined by the combination of a parent configuration and a core indicator code.

Key Information Stored

IGS_PR_UL_MARK_DTL contains 11 documented columns. The composite primary key, IGS_PR_UL_MARK_DTL_PK, is defined over MARK_CONFIG_ID and CORE_INDICATOR_CODE, making this pair the unique business-key candidate that establishes row uniqueness. The most significant columns include:

• MARK_CONFIG_ID — Foreign key to IGS_PR_UL_MARK_CNFG; identifies the parent marks configuration to which this detail row belongs.
• CORE_INDICATOR_CODE — Classifies the unit as core or non-core, affecting whether it must be included in marks calculation.
• TOTAL_CREDITS — The credit value or threshold associated with the unit under this configuration.
• REQUIRED_FLAG — Indicates whether the unit is mandatory within the marks calculation ruleset.
• PRIORITY_NUM — Determines the order or precedence in which units are selected when assembling marks.
• UNIT_SELECTION_CODE — Governs the selection logic applied to units during marks processing.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle EBS WHO (audit) columns capturing record provenance and modification history.

The surrogate relationship is expressed through the mark configuration identifier rather than a system-generated sequence key; the composite PK reflects the business identity of each rule row.

Common Use Cases and Queries

Typical uses of this table include configuring and auditing the rules that drive marks calculation, validating that required or core units are properly weighted, and reporting on unit selection priorities per configuration. Administrators review these rows when troubleshooting why a particular unit was or was not included in a student's computed marks.

A representative query retrieves all detail rules for a given configuration, ordering by the selection priority:

SELECT d.mark_config_id,
       d.core_indicator_code,
       d.required_flag,
       d.priority_num,
       d.total_credits,
       d.unit_selection_code
FROM   igs.igs_pr_ul_mark_dtl d
WHERE  d.mark_config_id = :p_mark_config_id
ORDER  BY d.priority_num;

A join to the parent configuration table correlates detail rules with their governing configuration header:

SELECT c.*, d.core_indicator_code, d.priority_num
FROM   igs.igs_pr_ul_mark_cnfg c,
       igs.igs_pr_ul_mark_dtl d
WHERE  c.mark_config_id = d.mark_config_id
AND    d.required_flag  = 'Y';

Reporting use cases include identifying configurations that contain required core units, and validating credit totals across the priority sequence to ensure academic rules are satisfied.

Related Objects

The most significant related objects, based on the documented foreign key relationships and surrounding IGS structures, include:

• IGS_PR_UL_MARK_CNFG — Parent configuration table; joined on MARK_CONFIG_ID. This is the primary dependency for IGS_PR_UL_MARK_DTL.
• IGS_PR_UL_MARK_DTL_PK — The composite primary key constraint/index over MARK_CONFIG_ID and CORE_INDICATOR_CODE.
• Associated IGS marks calculation and unit selection configuration objects that consume the rules defined here.
• Student academic record and unit registration tables within IGS that reference unit selection codes for grading.

Any process that computes or validates unit marks for a student relies on the configuration stored in this table, making it a foundational reference object for the IGS marks calculation subsystem.