Search Results repeat_grade

Overview

The view APPS.IGSFV_AS_GRADING_SCHEMA_GRADES belongs to the Oracle E-Business Suite Student System (IGS) product family and exposes the definition of grading schema grades together with their parent grading schema header information. It is a read-only view, as indicated by the WITH READ ONLY clause in its definition, which prevents DML operations from being issued against it while still permitting its use in reporting, integration, and concurrent program queries. The view consolidates data that would otherwise require joins across the grading schema header and the individual grade line records, presenting a denormalized result set suited to grade validation, transcript configuration review, and administrative maintenance screens. Because the underlying grade attributes carry lookup codes rather than displayed meanings, the view embeds label substitution tokens (for example _LA:GSG.S_RESULT_TYPE:IGS_LOOKUP_VALUES:RESULT_TYPE:MEANING) that allow the Oracle Forms and OAF layers to translate codes into user-facing descriptions at runtime. The presence of _DF:IGS:IGS_AS_GRD_SCH_GRADE_FLEX:GSG further indicates that a descriptive flexfield context is associated with the grade records.

Underlying Base Objects

The ETRM metadata for this view documents no referenced base objects, though the embedded view text shows that it is defined over two tables owned by the APPS schema:

• IGS_AS_GRD_SCHEMA (aliased GS) — the grading schema header, supplying the schema code, version number, and description.
• IGS_AS_GRD_SCH_GRADE (aliased GSG) — the individual grade lines, supplying grade codes, grade names, numeric ranges, GPA values, and the various display and processing indicators.

The join condition is an equijoin on GRADING_SCHEMA_CD and VERSION_NUMBER, so a grading schema is uniquely identified by the combination of its code and version, and each row of the view represents one grade within one version of one schema. Because the view is read-only and defined over these two tables, any change to a grade definition is performed against the base table directly; the view merely reflects the resulting state.

Key Columns

• GRADING_SCHEMA_CODE, GRADING_SCHEMA_VERSION_NUMBER, GRADING_SCHEMA_DESCRIPTION — identify and describe the parent grading schema.
• GRADE, FULL_GRADE_NAME — the short grade code and its expanded descriptive name.
• _LA:RESULT — the grade result type lookup meaning (for example pass, fail, or other result classifications).
• Display and control indicator columns such as _LA:SHOW_ON_NOTICEBOARD_IND, _LA:SHOW_IN_EARNED_CRDT_IND, _LA:SHOW_IN_NEWSPAPER_IND, _LA:ADMIN_ONLY_IND, and _LA:SYSTEM_ONLY_IND — lookup-validated Yes/No values controlling where a grade may be displayed or how it may be used.
• _LA:INCL_IN_RPT_PROCESS_IND — the documented INCL_IN_REPEAT_PROCESS_IND flag, which governs whether the grade participates in repeat processing; this column is directly relevant to searches on repeat_grade.
• REPEAT_GRADE — indicates the grade value recorded when a student repeats the associated attempt, linking one grade definition to the grade applied on repetition.
• LOWER_MARK_RANGE, UPPER_MARK_RANGE, MIN_PERCENTAGE, MAX_PERCENTAGE, GPA_VAL, RANK — the numeric bounds, grade point value, and ordering rank used in grade calculation and display sequencing.
• S_SPECIAL_GRADE_TYPE, EXTERNAL_GRADE, _LA:GRADING_PE (grading period), and _LA:CLOSED_IND — supplementary classification, external reporting, period applicability, and status attributes.
• Audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE.

Common Use Cases and Queries

A frequent requirement is to identify grades configured to trigger repeat processing and to locate the associated repeat grade. For example: SELECT grading_schema_code, grading_schema_version_number, grade, "_LA:INCL_IN_RPT_PROCESS_IND", repeat_grade FROM igsfv_as_grading_schema_grades WHERE repeat_grade IS NOT NULL; This returns each grade that maps to a repeat grade, which is useful when auditing repeat rules before an academic period is opened.

Another common scenario is validating that every grade in an active schema carries a numeric GPA value and falls within a defined mark range, supporting transcript and progression calculation: SELECT grade, full_grade_name, lower_mark_range, upper_mark_range, gpa_val FROM igsfv_as_grading_schema_grades WHERE grading_schema_code = :schema AND grading_schema_version_number = :version ORDER BY rank;

Administrators also use the view to review which grades appear on noticeboards, official notifications, earned credit, or newspaper extracts, and to confirm that administrative-only or system-only grades are correctly flagged. Because the view is read-only, all such reviews are diagnostic, and any correction is applied to IGS_AS_GRD_SCH_GRADE through the standard Student System maintenance forms.