Search Results cart_error_flag

Overview

The IGS_EN_PLAN_UNITS table is a core data object within the Oracle E-Business Suite Student System (IGS). It functions as the primary repository for student academic planning data, specifically storing details of unit attempts that a student has placed on a planning sheet. A planning sheet is a forward-looking academic schedule used for course advising and enrollment forecasting. This table is critical for managing a student's intended academic progression, enabling institutions to track planned unit enrollments before they are formally attempted or appear in the student's official academic history. Its role is integral to the enrollment and curriculum planning modules, sitting between the student's program attempt and the unit offering catalog.

Key Information Stored

The table's structure centers on identifying the student, their course, and the specific planned unit. The primary key is a composite of four columns: PERSON_ID, COURSE_CD, UOO_ID (Unit Offering Option ID), and CART_ERROR_FLAG. This design allows a student to have multiple planned attempts for the same unit within a course, potentially with different error statuses. Key columns include the identifiers linking to the student's course attempt (PERSON_ID, COURSE_CD) and the unit offering (UOO_ID). The CART_ERROR_FLAG is significant for workflow, indicating if the planned unit has validation errors (e.g., prerequisite or load issues). Other important fields reference a grading schema (GRADING_SCHEMA_CODE, GS_VERSION_NUMBER) for the planned unit, allowing for intended grade mode selection during planning.

Common Use Cases and Queries

A primary use case is generating an advisor's view of a student's planned schedule for an upcoming term or academic year. System processes also query this table to validate planned units against current academic rules, updating the CART_ERROR_FLAG accordingly. Common reporting involves listing all planned units for students in a specific program. A typical SQL pattern retrieves planned unit details for a student:

• SELECT plan_u.* FROM igs_en_plan_units plan_u WHERE plan_u.person_id = :student_id AND plan_u.course_cd = :course_code;

Another critical query joins with unit offering tables to report on planned enrollment demand for resource planning:

• SELECT uoo_id, COUNT(*) AS planned_enrollment FROM igs_en_plan_units WHERE cart_error_flag = 'N' GROUP BY uoo_id;

Related Objects

IGS_EN_PLAN_UNITS has defined foreign key relationships with several fundamental tables, as per the provided metadata. It is a child table of IGS_EN_STDNT_PS_ATT_ALL (Student Program Attempt), which anchors the planning data to a specific student and course combination. It references IGS_PS_UNIT_OFR_OPT_ALL (Unit Offering Options) to define the specific unit, campus, and term planned. The link to IGS_AS_GRD_SCHEMA (Grading Schema) allows the planned unit to be associated with a specific assessment scheme. This table is also a likely source for views and APIs that support the student self-service planning interface and administrative planning sheet management functions.