Search Results igs_as_mark_sheet_all




Overview
Explore in AI Chat

Overview

The IGS_AS_MARK_SHEET_ALL table is a core data structure within the Oracle E-Business Suite Student System (IGS), specifically supporting the assessment and grading functionality. It serves as the master definition table for mark sheets, which are formal documents or electronic records used to capture, validate, and report student grades for a specific academic offering. Each record in this table describes a unique mark sheet associated with a particular unit offering pattern, which defines how a course unit is delivered in a given teaching period. Its role is critical for managing the lifecycle of student assessments, from initial grade entry through to final approval and reporting, ensuring data integrity across the grading process.

Key Information Stored

The table's primary key is the SHEET_NUMBER, a unique identifier for each mark sheet. Its structure is fundamentally linked to the academic unit offering through a composite foreign key relationship with the IGS_PS_UNIT_OFR_PAT_ALL table. This relationship is established via four key columns: UNIT_CD (the unit code), VERSION_NUMBER (the version of that unit), CAL_TYPE (the calendar type, e.g., 'SEMESTER'), and CI_SEQUENCE_NUMBER (the sequence number identifying the specific teaching calendar instance). Additional columns, while not explicitly listed in the provided metadata, typically store data such as the mark sheet status (e.g., 'DRAFT', 'VALIDATED', 'APPROVED'), creation date, and details about the staff member responsible for its management.

Common Use Cases and Queries

This table is central to operations involving grade management. A common use case is generating a list of all active mark sheets for a department in a given semester for audit or workload purposes. Another critical scenario is tracing the grading history for a specific unit offering. Sample SQL patterns often involve joining to the unit offering pattern table to add descriptive context. For instance, a query to find mark sheets for a specific unit might be:

  • SELECT ms.sheet_number, ms.unit_cd, ms.cal_type, uop.location_cd FROM igs_as_mark_sheet_all ms JOIN igs_ps_unit_ofr_pat_all uop ON ms.unit_cd = uop.unit_cd AND ms.version_number = uop.version_number AND ms.cal_type = uop.cal_type AND ms.ci_sequence_number = uop.ci_sequence_number WHERE ms.unit_cd = 'MATH101';

Reporting use cases include regulatory compliance reports, grade distribution analyses, and administrative dashboards tracking assessment completion.

Related Objects

The IGS_AS_MARK_SHEET_ALL table has defined relationships with several other key objects in the Student System. As per the metadata, it is the parent table for IGS_AS_MSHT_SU_ATMPT (likely storing the detailed student attempts and grades linked to each mark sheet) via the SHEET_NUMBER foreign key. Its definition is sourced from IGS_PS_UNIT_OFR_PAT_ALL, ensuring a mark sheet cannot exist without a valid unit offering. In a full implementation, it would also be referenced by various assessment-related views, packages (e.g., IGS_AS_GEN_001 for mark sheet generation), and forms that facilitate grade entry and approval workflows.