Search Results igs_ps_sch_ocr_cfig




Overview
Explore in AI Chat

Overview

IGS_PS_SCH_OCR_CFIG is a configuration table within the Oracle E-Business Suite Student System (IGS) product family. Its documented purpose is to capture occurrence rollover and override related information. In the context of academic scheduling, an "occurrence" represents a specific offering of a scheduled course component, and the rollover process propagates scheduling attributes from one academic period to the next. This table stores the control flags that govern which attributes are carried forward automatically during rollover and which attributes may be manually overridden by the scheduling administrator.

The table resides in the IGS schema and is marked VALID in the ETRM 12.1.1 physical schema documentation, comprising 28 columns. The heuristic Data Vault classification mined from the foreign key structure is standalone, indicating that no explicit parent-child relationships were detected. As a modeling suggestion, this object behaves less like a transactional hub or link and more like a reference satellite or configuration dimension: it carries descriptive rollover and override flags keyed by a single surrogate identifier, with no downstream dependents recorded in the documented relationship data.

Key Information Stored

Each row is uniquely identified by the surrogate primary key OCR_CFIG_ID, enforced by the unique index IGS_PS_SCH_OCR_CFIG_PK. No alternate business-key unique index is documented beyond this primary key, so OCR_CFIG_ID is the sole documented identifier. The remaining columns fall into two functional groups.

The pairing of roll and override flags is significant: a roll flag determines whether the attribute is inherited at rollover time, while the corresponding override flag determines whether the inherited value may subsequently be changed.

Common Use Cases and Queries

Configuration administrators query this table to audit which schedule attributes are automatically rolled and which remain editable. A typical verification query selects the identifier alongside the rollover flags:

  • SELECT ocr_cfig_id, day_roll_flag, time_roll_flag, instructor_roll_flag, facility_roll_flag FROM igs.igs_ps_sch_ocr_cfig;
  • Filtering for enabled rollover attributes, for example WHERE instructor_roll_flag = 'Y', identifies configurations that propagate teaching assignments.
  • Reporting joins to audit columns (created_by, last_update_date) support change-tracking of configuration revisions across academic years.
  • Because the classification is standalone, queries generally treat this object as a lookup rather than joining it to occurrence or schedule fact tables through foreign keys.

Related Objects

No foreign key relationships are documented for IGS_PS_SCH_OCR_CFIG, consistent with its standalone classification. The table is therefore referenced by configuration-driven logic within the Student System scheduling rollover process rather than by declarative constraints. Practically, the IGS_PS_SCH_OCCURRENCE and IGS_PS_SCH_OVERRIDE families, the scheduling rollover concurrent programs, and the IGS Student System setup forms depend conceptually on the flag values stored here. Any integration or extract should treat OCR_CFIG_ID as the stable configuration key and respect the audit columns when staging changes.