Search Results igs_as_inc_grd_cprof




Overview
Explore in AI Chat

Overview

The IGS_AS_INC_GRD_CPROF table is a core data structure within the Oracle E-Business Suite Student System (IGS) module. Its primary function is to define and store the rules for converting an "incomplete" grade into a final grade after a specified period. This table is essential for academic administration, as it automates the process of managing student coursework that was not completed by the standard deadline. It provides a configurable profile that links an incomplete grade within a specific grading schema to a default final grade and defines the timeframe for the conversion. This ensures consistent and policy-driven grade management across the institution in both EBS releases 12.1.1 and 12.2.2.

Key Information Stored

The table's design centers on identifying a unique grading context and specifying its conversion parameters. The primary identifier is the system-generated INC_GRD_CPROF_ID. The table is uniquely constrained by a combination of columns that define the grading context: GRADING_SCHEMA_CD, VERSION_NUMBER, ORG_UNIT_CD (organizational unit), and the specific INCOMPLETE_GRADE code. For each profile, the critical conversion data includes the DEFAULT_GRADE (the final grade to be assigned), the COMP_AFTER_DT_ALIAS (a date alias that determines the completion deadline), and a COMP_AFTER_DAYS column (not explicitly listed but typical for such logic) to calculate the conversion date relative to the course or grade date.

Common Use Cases and Queries

The primary use case is the batch or real-time process that evaluates incomplete grades and automatically converts them to a default grade once the allowed completion period has elapsed. Administrators may query this table to audit or report on conversion rules. A common SQL pattern involves joining to grading schema tables to get descriptive information.

  • Finding all conversion profiles for a grading schema: SELECT * FROM igs.igs_as_inc_grd_cprof WHERE grading_schema_cd = 'UG' AND version_number = 1;
  • Identifying the default grade for a specific incomplete: SELECT default_grade FROM igs.igs_as_inc_grd_cprof WHERE grading_schema_cd = 'GRAD' AND incomplete_grade = 'I';
  • Reporting use case: Generating a list of all incomplete grade rules with their associated deadline date aliases for academic policy documentation.

Related Objects

The IGS_AS_INC_GRD_CPROF table maintains integral foreign key relationships with other Student System tables, ensuring referential integrity and enabling complex academic rules.

  • IGS_AS_GRD_SCHEMA: Defines the parent grading schema. Joined via GRADING_SCHEMA_CD and VERSION_NUMBER.
  • IGS_AS_GRD_SCH_GRADE (for INCOMPLETE_GRADE): Validates that the incomplete grade code exists within the specified grading schema version. Joined on GRADING_SCHEMA_CD, VERSION_NUMBER, and INCOMPLETE_GRADE.
  • IGS_AS_GRD_SCH_GRADE (for DEFAULT_GRADE): Validates that the default final grade code exists within the same grading schema version. Joined on GRADING_SCHEMA_CD, VERSION_NUMBER, and DEFAULT_GRADE.
  • IGS_CA_DA (Calendar Date Alias): References the date alias table to define the completion deadline. Joined via COMP_AFTER_DT_ALIAS.