Results for “igs_as_inc_grd_cprof”

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

Overview

The IGS_AS_INC_GRD_CPROF table is a core configuration object within the Oracle E-Business Suite Student System (IGS) product family. It stores incomplete grade conversion profile details, defining how an institution converts an incomplete grade into a final, awarded grade after a defined completion deadline. Institutions use incomplete grades when a student has not finished required coursework within a term, and this table governs the rules that determine the substitute grade applied once the completion period lapses or the instructor updates the outcome.

Because each row is keyed primarily by INC_GRD_CPROF_ID and constrained by a business-key unique index across grading schema, version, incomplete grade, and organization unit, the table functions as a reference catalog of conversion policies rather than a transactional record. Under the heuristic Data Vault classification supplied in the metadata, this object is best modeled as a link, since it associates grading schema definitions, organization units, and grade codes together into a reusable policy relationship.

Key Information Stored

The table contains 16 documented columns. The most significant include:

• INC_GRD_CPROF_ID — Surrogate primary key (from IGS_AS_INC_GRD_CPROF_PK) uniquely identifying each conversion profile.
• GRADING_SCHEMA_CD, VERSION_NUMBER — Identify the grading schema and version to which the profile applies; both participate in the unique business key and in foreign keys to grading schema tables.
• INCOMPLETE_GRADE — The incomplete grade code that triggers conversion; part of the unique key and an FK to the grade definition.
• ORG_UNIT_CD — The organization unit scope, allowing different policies by academic unit; part of the unique key.
• DEFAULT_GRADE — The substitute grade assigned when no instructor action occurs; validated against the grading schema grade table.
• DEFAULT_MARK — Companion default numeric or alpha mark applied alongside the default grade.
• COMP_AFTER_DT_ALIAS — Alias referencing a date/attribute definition (IGS_CA_DA) used to compute the completion deadline.
• INSTRUCTOR_UPDATE_IND — Flag indicating whether instructors may override the default conversion outcome.
• NUMBER_UNIT_TIME, TYPE_UNIT_TIME — Define the unit-of-time magnitude and type (for example, days, weeks) governing the completion window.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns tracking row creation and modification.

The surrogate key INC_GRD_CPROF_ID distinguishes individual rows, while the IGS_AS_INC_GRD_CPROF_U2 unique index establishes the natural business key, preventing duplicate policies for the same schema, version, incomplete grade, and organization unit.

Common Use Cases and Queries

Typical reporting retrieves the conversion rule applicable to a given incomplete grade within an organization and grading schema:

• Identifying the default grade and mark applied when a completion deadline passes.
• Auditing which grading schemas permit instructor updates versus automatic conversion.
• Listing all incomplete grade profiles scoped to a specific organization unit for policy review.

A representative query joins the profile to the grading schema and grade definitions:

SELECT p.INC_GRD_CPROF_ID, p.INCOMPLETE_GRADE, p.DEFAULT_GRADE, p.ORG_UNIT_CD
FROM IGS_AS_INC_GRD_CPROF p
WHERE p.GRADING_SCHEMA_CD = :schema
AND p.VERSION_NUMBER = :version
AND p.ORG_UNIT_CD = :org_unit;

Validation reports frequently join COMP_AFTER_DT_ALIAS to IGS_CA_DA to confirm that the completion deadline attribute is properly configured before term rollover processing.

Related Objects

The foreign key metadata links this profile table to several significant Student System objects:

• IGS_AS_GRD_SCH_GRADE — Joined on GRADING_SCHEMA_CD, VERSION_NUMBER, and either INCOMPLETE_GRADE or DEFAULT_GRADE; validates that both the triggering and resulting grades exist in the grading schema.
• IGS_AS_GRD_SCHEMA — Joined on GRADING_SCHEMA_CD and VERSION_NUMBER; provides the parent grading schema definition.
• IGS_CA_DA — Joined on COMP_AFTER_DT_ALIAS; supplies the date/attribute alias used to derive the completion deadline.
• Grade conversion and incomplete grade processing logic in the IGS Student System consumes this table to determine automated grade substitution during grading and term-end processes.

Administrators maintain these rows through Student System setup, and downstream conversion routines depend on the configured profiles to resolve final grades consistently across organization units.