Search Results mark_config_id




Overview
Explore in AI Chat

Overview

The IGS_PR_UL_MARK_CNFG table is a core configuration table within the Oracle E-Business Suite's Student System (IGS) module, specifically for releases 12.1.1 and 12.2.2. It serves as the master definition point for how academic marks are calculated at the unit (or subject) level within a student's program of study. The table establishes a critical link between a specific course version and a unit level, defining the precise calculation rules that will be applied. Its primary role is to provide a configurable framework for institutional grading policies, ensuring that mark calculations are consistent, rule-based, and tied to the appropriate academic structures.

Key Information Stored

The table's structure centers on identifying the academic context and a unique configuration identifier. While the full column list is not detailed in the provided metadata, the documented foreign keys and primary key reveal its essential components. The primary key, MARK_CONFIG_ID, is a unique identifier for each distinct mark calculation configuration. The table stores foreign key references to define the academic scope: COURSE_CD and VERSION_NUMBER link to a specific course program (IGS_PS_VER_ALL), and UNIT_LEVEL links to a defined unit level (IGS_PS_UNIT_LEVEL_ALL). This combination ensures that mark calculation rules can be tailored for different unit levels (e.g., introductory, advanced) within specific course versions.

Common Use Cases and Queries

This table is primarily accessed during the processes of grade entry, calculation, and reporting. A common operational use case is retrieving the applicable mark calculation configuration for a student's unit attempt, based on their enrolled course and the unit's level. Administrators may also query this table to audit or maintain grading rules across programs. A typical SQL pattern involves joining to course and unit level tables to present a readable configuration list:

  • SELECT cfg.MARK_CONFIG_ID, cv.COURSE_CD, cv.VERSION_NUMBER, ul.UNIT_LEVEL_CODE FROM IGS_PR_UL_MARK_CNFG cfg JOIN IGS_PS_VER_ALL cv ON cfg.COURSE_CD = cv.COURSE_CD AND cfg.VERSION_NUMBER = cv.VERSION_NUMBER JOIN IGS_PS_UNIT_LEVEL_ALL ul ON cfg.UNIT_LEVEL = ul.UNIT_LEVEL;

For troubleshooting, one might query for configurations that have no associated detail rules or for potential orphaned records missing valid course or unit level references.

Related Objects

The IGS_PR_UL_MARK_CNFG table sits at the center of a key relationship hierarchy for unit-level mark processing. As documented in the provided metadata, its relationships are as follows:

  • Referenced By (Child Table): The IGS_PR_UL_MARK_DTL table holds the detailed calculation rules (e.g., weightings, formula components) for each configuration. It references IGS_PR_UL_MARK_CNFG via the foreign key IGS_PR_UL_MARK_DTL.MARK_CONFIG_ID.
  • References (Parent Tables):
    • IGS_PS_VER_ALL: Links to the course version via columns IGS_PR_UL_MARK_CNFG.COURSE_CD and .VERSION_NUMBER.
    • IGS_PS_UNIT_LEVEL_ALL: Links to the unit level definition via column IGS_PR_UL_MARK_CNFG.UNIT_LEVEL.

This structure confirms that a mark configuration is defined for a specific combination of a Course Version and a Unit Level, and that each configuration can have multiple detailed calculation rules stored in IGS_PR_UL_MARK_DTL.

  • Table: IGS_PR_UL_MARK_CNFG 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PR_UL_MARK_CNFG,  object_name:IGS_PR_UL_MARK_CNFG,  status:VALID,  product: IGS - Student System ,  description: Defines the configuration for calculating the marks at unit level. ,  implementation_dba_data: IGS.IGS_PR_UL_MARK_CNFG , 

  • Table: IGS_PR_UL_MARK_DTL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PR_UL_MARK_DTL,  object_name:IGS_PR_UL_MARK_DTL,  status:VALID,  product: IGS - Student System ,  description: Defines the configuration details like core type indicator, priority in selecting the units for marks calculation etc. ,  implementation_dba_data: IGS.IGS_PR_UL_MARK_DTL , 

  • View: IGS_PR_UL_MARK_CNFG_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_PR_UL_MARK_CNFG_V,  object_name:IGS_PR_UL_MARK_CNFG_V,  status:VALID,  product: IGS - Student System ,  description: Defines the configuration for calculating the marks at unit level. ,  implementation_dba_data: APPS.IGS_PR_UL_MARK_CNFG_V , 

  • View: IGS_PR_UL_MARK_DTL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_PR_UL_MARK_DTL_V,  object_name:IGS_PR_UL_MARK_DTL_V,  status:VALID,  product: IGS - Student System ,  description: Defines the configuration details like core type indicator, priority in selecting the units for marks calculation etc. ,  implementation_dba_data: APPS.IGS_PR_UL_MARK_DTL_V ,