Search Results igs_pr_ul_mark_dtl_pk

Overview

The IGS_PR_UL_MARK_DTL table is a configuration entity within the Oracle E-Business Suite 12.1.1 and 12.2.2 Student System (IGS), which is noted as obsolete. It serves as a child table that defines detailed rules for calculating student marks based on unit load. Specifically, it stores configuration details that dictate how units are selected and prioritized for marks calculation within a broader marking configuration framework. Its primary role is to provide the granular, rule-based logic that determines which units (e.g., core vs. elective) are considered in academic assessments and in what order of precedence.

Key Information Stored

The table's structure is defined by a composite primary key and holds configuration parameters. The key columns are MARK_CONFIG_ID, which links to the parent marking configuration, and CORE_INDICATOR_CODE, which classifies the type of unit (such as core, elective, or other defined categories). While the full column list is not detailed in the provided metadata, the description indicates the table stores attributes like a priority indicator for selecting units in the calculation process. This priority setting would determine the sequence or weighting of units when aggregating marks for a student's academic record.

Common Use Cases and Queries

This table is central to batch or programmatic processes that compute academic standings, progression, or honors classifications based on a student's unit load and results. A typical use case involves an administrative process retrieving all detailed rules for a specific marks configuration to apply them during an academic audit. A common query pattern would join this table to its parent to fetch the complete rule set.

• Retrieving Configuration Details: SELECT * FROM igs_pr_ul_mark_dtl WHERE mark_config_id = :config_id ORDER BY priority;
• Reporting on Mark Calculation Rules: Reports would join IGS_PR_UL_MARK_DTL to IGS_PR_UL_MARK_CNFG to list all configured rules, showing for each configuration the core indicator codes and their assigned selection priorities.

Related Objects

The table maintains a strict foreign key relationship with its parent configuration table, as documented in the ETRM metadata.

• Primary Key: IGS_PR_UL_MARK_DTL_PK on columns (MARK_CONFIG_ID, CORE_INDICATOR_CODE).
• Foreign Key (References): The table IGS_PR_UL_MARK_DTL has a foreign key where its column MARK_CONFIG_ID references the primary key of the table IGS_PR_UL_MARK_CNFG. This enforces that every detail record must be associated with a valid, existing parent marks configuration.

Given the "Obsolete" status of the IGS module, direct integration with newer APIs or user interfaces is unlikely. All operations on this table would be performed through legacy batch programs or database-level scripts within the Student System.