Results for “core_indicator_code”

50+ results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_EN_PLAN_UNITS is a transaction table within the Oracle E-Business Suite Student System (IGS) product family. It stores the unit attempt details that belong to a student's planning sheet — the working record in which an advisor or student assembles the proposed set of unit offerings for an academic term before those units are committed to an actual enrollment. Each row represents one planned unit attempt for a given person and course, capturing the optional unit offering selected, any overrides applied to the planned credit points, and the grading schema that governs the assessment.

The table is owned by the IGS schema and is present in both EBS 12.1.1 and 12.2.2. Its documented physical schema contains 19 columns. Based on the foreign-key structure mined from the ETRM metadata, the object is heuristically classified as a link in Data Vault terms: it resolves many-to-many relationships between a student planning record, a unit offering option, and a grading schema, rather than functioning as a standalone hub or a descriptive satellite.

Key Information Stored

The primary key is enforced by the unique index IGS_EN_PLAN_UNITS_PK, whose documented business-key candidate columns are PERSON_ID, COURSE_CD, UOO_ID, and CART_ERROR_FLAG. The remaining documented columns provide the planning context and audit trail.

Common Use Cases and Queries

The most frequent operational need is diagnosing planned units that failed to convert into enrollments. Rows with a non-null or flagged CART_ERROR_FLAG identify these cases, and DBAs or functional consultants typically join back to the student and offering tables to explain the failure.

  • Reporting all errored planned units for a term: SELECT PERSON_ID, COURSE_CD, UOO_ID FROM IGS_EN_PLAN_UNITS WHERE CART_ERROR_FLAG = 'Y' AND TERM_CAL_TYPE = :cal AND TERM_CI_SEQUENCE_NUMBER = :seq;
  • Listing a student's full planning sheet: filter by PERSON_ID and COURSE_CD, then join UOO_ID to IGS_PS_UNIT_OFR_OPT_ALL for unit codes and titles.
  • Auditing credit-point overrides: select rows where OVERRIDE_ENROLLED_CP is populated.
  • Validating grading configuration: join GRADING_SCHEMA_CODE and GS_VERSION_NUMBER to IGS_AS_GRD_SCHEMA to confirm the schema is still valid.

Related Objects

The documented foreign keys establish the principal relationships this table depends on:

  • IGS_EN_STDNT_PS_ATT_ALL — referenced via PERSON_ID and COURSE_CD; the student program attempt that owns the planning sheet.
  • IGS_PS_UNIT_OFR_OPT_ALL — referenced via UOO_ID; the unit offering option selected for the planned attempt.
  • IGS_AS_GRD_SCHEMA — referenced via GRADING_SCHEMA_CODE and GS_VERSION_NUMBER; the grading schema definition.
  • IGS_EN_PLAN_UNITS_PK — the unique index enforcing the composite key and serving as the business-key access path.