Search Results lower_mark_range

Overview

IGS_AS_GRD_SCH_GRADE_V is a reporting view in the Oracle E-Business Suite Student System (IGS) product family. It presents grade definitions maintained within a grading schema, joining the underlying grade table to the lookup view so that the result type appears as a translated meaning rather than a raw code. The view exposes configuration attributes that govern how a given grade is displayed and treated across student-facing outputs, including official notifications, noticeboards, newspapers, internal reporting, and earned-credit processing.

The IGS product line is documented in ETRM as obsolete, and this view is recorded as "Not implemented in this database" in the reference environment. Consequently, the view should be treated as a legacy or historical object. Its primary role is read-only exposure of grading-schema grade setup for reporting, data extraction, and integration scenarios where grade presentation behavior must be audited or replicated.

The presence of the column SHOW_ON_OFFICIAL_NTFCTN_IND — the term the user searched for — reflects a specific business control: whether a grade is eligible to appear on an official notification such as an academic transcript or official grade report.

Underlying Base Objects

The view is defined over two objects:

• IGS_AS_GRD_SCH_GRADE (aliased GSG) — the base grade table holding the grading schema, version, grade code, result type, display flags, mark range, GPA value, rank, and descriptive flexfield attributes.
• IGS_LOOKUPS_VIEW (aliased LKUP) — the lookup view joined on LOOKUP_TYPE = 'RESULT_TYPE' and LOOKUP_CODE = GSG.S_RESULT_TYPE, providing the decoded MEANING for the result type.

ETRM documentation lists no further referenced base objects, so the join structure above is the complete definition. All twenty descriptive flexfield columns (ATTRIBUTE1 through ATTRIBUTE20) and the standard WHO audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) are carried through from the base grade table unchanged.

Key Columns

• GRADING_SCHEMA_CD, VERSION_NUMBER — identify the grading schema and its version to which the grade belongs.
• GRADE, FULL_GRADE_NAME — the internal grade code and its descriptive name.
• S_RESULT_TYPE, MEANING — the result type code and its decoded lookup meaning (for example Pass, Fail, Withdrawn).
• SHOW_ON_OFFICIAL_NTFCTN_IND — controls whether the grade may be printed on official notifications.
• SHOW_ON_NOTICEBOARD_IND, SHOW_IN_NEWSPAPER_IND, SHOW_INTERNALLY_IND — additional publication controls for noticeboards, newspaper extracts, and internal displays.
• SYSTEM_ONLY_IND, ADMIN_ONLY_IND, CLOSED_IND — restrict the grade to system or administrative use and mark it closed.
• DFLT_OUTSTANDING_IND — flags a default outstanding (not yet graded) result.
• LOWER_MARK_RANGE, UPPER_MARK_RANGE, MIN_PERCENTAGE, MAX_PERCENTAGE — numeric boundaries for the grade band.
• GPA_VAL, RANK, EXTERNAL_GRADE, REPEAT_GRADE — grade point value, ordering rank, externally published equivalent, and the replacement grade used in repeat processing.
• SHOW_IN_EARNED_CRDT_IND, INCL_IN_REPEAT_PROCESS_IND — inclusion flags for earned-credit calculations and the repeat processing routine.

Common Use Cases and Queries

Typical usage is auditing grade setup, verifying publication controls, and extracting grading-schema configuration for reporting or migration.

• List all official-notification grades for a schema and version:

SELECT grading_schema_cd, version_number, grade, full_grade_name, meaning
FROM   igs_as_grd_sch_grade_v
WHERE  show_on_official_ntfctn_ind = 'Y'
AND    grading_schema_cd = :schema
AND    version_number    = :version;

• Review all publication flags for a single grade:

SELECT grade, show_on_official_ntfctn_ind, show_on_noticeboard_ind,
       show_in_newspaper_ind, show_internally_ind
FROM   igs_as_grd_sch_grade_v
WHERE  grading_schema_cd = :schema
AND    grade = :grade;

• Extract mark ranges and GPA values for grading calculations:

SELECT grade, lower_mark_range, upper_mark_range,
       min_percentage, max_percentage, gpa_val, rank
FROM   igs_as_grd_sch_grade_v
WHERE  grading_schema_cd = :schema
AND    closed_ind = 'N'
ORDER BY rank;

Because the object is recorded as obsolete and not implemented in the documented environment, availability should be confirmed against the target instance before relying on it in production queries.