Search Results admin_only_ind

Overview

IGS_AS_GRD_SCH_GRADE_V is a supplementary Oracle EBS view owned by the APPS schema and registered under the FND Design Data object IGS.IGS_AS_GRD_SCH_GRADE_V. In the E-Business Suite Release 12.1.1 and 12.2.2 the object is documented as a VALID view whose stated purpose is to simplify Forms coding within the Student System (IGS) product family. The naming convention indicates its functional area: IGS_AS denotes the Assessment and Grading module, while GRD_SCH_GRADE identifies a grading schema grade definition. The view therefore exposes the grade records that belong to a grading schema, together with the surrounding attributes that control how a grade is displayed, calculated, ranked, and processed.

Because the object is a supplementary Forms view rather than a public interface, Oracle explicitly warns that querying or altering data through it is not recommended and that the definition may change dramatically in a subsequent minor or major release. From a reporting and integration standpoint, the view remains useful for ad hoc enquiry and diagnostic extraction, but it should not be treated as a stable contract. The most notable tie to the user search term is the ADMIN_ONLY_IND column, which flags grades that are intended for administrative use only and are therefore suppressed from ordinary display contexts.

Underlying Base Objects

The ETRM metadata records no referenced base objects for this view, and the dependency list is limited to the view itself. In practice the view is defined over the grading schema grade base table in the IGS Assessment and Grading schema, joining or resolving lookup and descriptive flexfield structures through the APPS synonym layer. The ROW_ID column of type ROWID is retained from the underlying row and confirms a one-row-per-grade-definition projection. Descriptive flexfield columns ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE11 are surfaced on the view, indicating the base table carries a DFF structure and that the view passes those segments through unchanged. Audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN are likewise exposed directly from the source record.

Key Columns

• GRADING_SCHEMA_CD and VERSION_NUMBER identify the grading schema and version to which the grade belongs.
• GRADE and FULL_GRADE_NAME carry the short grade code and its descriptive name.
• ADMIN_ONLY_IND indicates whether the grade is restricted to administrative use.
• SYSTEM_ONLY_IND and EXTERNAL_GRADE distinguish system-maintained grades and grades intended for external publication.
• S_RESULT_TYPE, MEANING, and S_SPECIAL_GRADE_TYPE provide result classification and lookup meaning.
• LOWER_MARK_RANGE, UPPER_MARK_RANGE, MIN_PERCENTAGE, MAX_PERCENTAGE, GPA_VAL, and RANK support mark banding and grade point calculation.
• SHOW_ON_NOTICEBOARD_IND, SHOW_ON_OFFICIAL_NTFCTN_IND, SHOW_IN_NEWSPAPER_IND, SHOW_INTERNALLY_IND, and SHOW_IN_EARNED_CRDT_IND control visibility across student-facing outputs.
• DFLT_OUTSTANDING_IND, INCL_IN_REPEAT_PROCESS_IND, and REPEAT_GRADE govern outstanding and repeat processing behaviour.
• GRADING_PERIOD_CD scopes the grade to a grading period.

Common Use Cases and Queries

A typical enquiry lists the grades defined for a schema and isolates those marked administrative only:

• SELECT grade, full_grade_name, gpa_val, admin_only_ind FROM apps.igs_as_grd_sch_grade_v WHERE grading_schema_cd = :schema AND admin_only_ind = 'Y';
• SELECT grade, lower_mark_range, upper_mark_range, rank FROM apps.igs_as_grd_sch_grade_v WHERE grading_schema_cd = :schema ORDER BY rank;
• SELECT grade, show_on_noticeboard_ind, show_in_newspaper_ind FROM apps.igs_as_grd_sch_grade_v WHERE show_internally_ind = 'Y';

These queries suit validation and diagnostic work. Production integrations should read the underlying grading schema grade table directly, since this supplementary Forms view offers no compatibility guarantee across releases.