Search Results preferred_room_roll_flag

Overview

IGS_PS_SCH_OCR_CFIG_V is a reporting and integration view within the Oracle E-Business Suite application schema APPS, defined over the scheduling configuration table used by the Student Systems / Higher Education product family. Its name resolves to a "schedule OCR configuration" view, where OCR denotes the roll-over / override control records that govern how scheduling attributes behave when a schedule is created, copied, or regenerated. The view presents one row per scheduling OCR configuration record, exposing the set of roll-over flags and override flags that determine whether individual scheduling attributes are carried forward or manually overridden.

The view itself is a thin projection: it performs no joins, aggregations, or derivations. Every column is a direct reference to a column of the base table, with the addition of the ROWID pseudocolumn aliased as ROW_ID to provide a unique row identifier for the underlying physical record. This design makes the view a stable, read-only interface suitable for concurrent programs, Oracle Reports, BI Publisher data templates, and outbound interfaces that must not depend on the physical column ordering of the base table.

The user search term date_ovrd_flag corresponds directly to a column exposed by this view. It is one of the override flags and indicates whether the date attribute of a schedule is subject to override rather than being inherited through the roll-over process.

Underlying Base Objects

The ETRM 12.2.2 metadata documents no referenced base objects for this view; however, the view text itself is explicit. The FROM clause references a single object, IGS_PS_SCH_OCR_CFIG, aliased SOC. All projected columns are qualified with that alias, confirming a one-to-one relationship between base table rows and view rows. No DISTINCT, GROUP BY, UNION, or subquery is present, so the view is fully updatable in the Oracle sense and imposes no row multiplication.

Because the view selects soc.rowid, the ROW_ID column can be used as a surrogate key for the base table row, which is useful in forms-based or programmatic updates. The view inherits the base table's indexes and constraints indirectly, but the view itself carries no constraints or triggers. In 12.1.1 and 12.2.2 the view is compiled in the APPS schema and is granted through standard APPS schema synonym conventions.

Key Columns

• ROW_ID — the ROWID of the base table row; unique identifier.
• OCR_CFIG_ID — primary identifier of the OCR configuration record.
• ROLL_FLAG columns — TO_BE_ANNOUNCED_ROLL_FLAG, DAY_ROLL_FLAG, TIME_ROLL_FLAG, INSTRUCTOR_ROLL_FLAG, FACILITY_ROLL_FLAG, SCHD_NOT_RQD_ROLL_FLAG, REF_CD_ROLL_FLAG, PREFERRED_BLD_ROLL_FLAG, PREFERRED_ROOM_ROLL_FLAG, DEDICATED_BLD_ROLL_FLAG, DEDICATED_ROOM_ROLL_FLAG, SCHEDULED_BLD_ROLL_FLAG, SCHEDULED_ROOM_ROLL_FLAG, PREFERRED_REGION_ROLL_FLAG, OCCUR_FLEXFIELD_ROLL_FLAG, and INC_INS_CHANGE_NOTFY_ROLL_FLAG control which scheduling attributes are rolled forward.
• OVRD_FLAG columns — DATE_OVRD_FLAG, DAY_OVRD_FLAG, TIME_OVRD_FLAG, INSTRUCTOR_OVRD_FLAG, SCHEDULED_BLD_OVRD_FLAG, and SCHEDULED_ROOM_OVRD_FLAG control whether the corresponding attribute may be overridden. DATE_OVRD_FLAG is the column of interest behind the user's search.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN support standard EBS audit trail reporting.

Common Use Cases and Queries

Typical scenarios include verifying which scheduling attributes permit date override before running a scheduling concurrent request, and producing configuration extracts for environment comparison across instances.

• List configurations where date override is permitted:

SELECT ocr_cfig_id, date_ovrd_flag, day_ovrd_flag, time_ovrd_flag
FROM   apps.igs_ps_sch_ocr_cfig_v
WHERE  date_ovrd_flag = 'Y';

• Full configuration extract for audit:

SELECT ocr_cfig_id, date_ovrd_flag, instructor_ovrd_flag,
       scheduled_bld_ovrd_flag, scheduled_room_ovrd_flag,
       last_updated_by, last_update_date
FROM   apps.igs_ps_sch_ocr_cfig_v
ORDER  BY ocr_cfig_id;

Because the view is a simple projection, queries against it perform equivalently to queries against IGS_PS_SCH_OCR_CFIG and may be tuned with the same indexes.