Results for “igs_ps_tch_resp_ovrd”

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

Overview

The view IGS_PS_TCH_RESP_OVRD belongs to the Oracle Student System (IGS) product family, a module classified as obsolete in Oracle E-Business Suite Releases 12.1.1 and 12.2.2. Its name reflects its purpose: teacher responsibility overrides for teaching and unit delivery within an academic institution. The view exposes organization-filtered data drawn from the multi-organization table IGS_PS_TCH_RESP_OVRD_ALL, applying an Operational Unit (OU) security predicate through the ORG_ID column. This design is characteristic of Oracle's Multi-Org Access Control (MOAC) model, in which a "_ALL" base table stores records for all operating units while a corresponding view restricts visibility to the organization currently active in the user's session.

The view is documented as not implemented in the reference database, meaning the underlying objects and this view may not exist in all environments. It therefore serves primarily as a historical or reference definition for institutions that deployed the Student System ahead of its obsolescence. Where present, the view functions as a reporting and integration surface for teaching responsibility allocation data, allowing downstream reports, concurrent programs, and interfaces to retrieve override records without directly querying the base table.

Underlying Base Objects

The view is defined exclusively over a single base object: IGS_PS_TCH_RESP_OVRD_ALL. No other documented referenced base objects exist in the ETRM metadata. The view does not perform joins; instead, it selects the columns of the base table and appends the ORG_ID predicate to enforce MOAC security.

The security predicate compares the session's organization identifier, derived from USERENV('CLIENT_INFO'), against TAB.ORG_ID. The DECODE and SUBSTRB logic extracts the first ten characters of the client information string, defaulting missing values to -99. Rows are returned only when the two evaluated values match, ensuring that users see records only for the operating unit to which their session is restricted. This is consistent with Oracle's standard "_ALL" table and "security view" architecture and confirms the view's role as an OU-scoped projection of the base table rather than a distinct data entity.

Key Columns

The view exposes the following notable columns, which together describe a teaching responsibility override for a unit offering:

• ROW_ID — the row identifier derived from the base table's ROWID, used for direct addressing of the underlying record.
• UNIT_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER — identify the unit and its calendar context, including version, calendar type, and calendar instance sequence.
• LOCATION_CD, UNIT_CLASS, ORG_UNIT_CD, OU_START_DT — describe the location, classification, academic organizational unit, and the start date from which the organizational unit assignment applies.
• UOO_ID — the identifier of the unit offering option, linking the override to a specific offering instance.
• PERCENTAGE — the proportion of teaching responsibility assigned to the override entry.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns recording creation and modification metadata.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent program context columns identifying the process that last modified the record.
• ORG_ID — the operating unit identifier governing multi-org security and row visibility.

Common Use Cases and Queries

The view is typically used in reporting on teaching responsibility splits and overrides within a given operating unit. A standard query retrieves override percentages for a specific unit offering option:

• SELECT UNIT_CD, VERSION_NUMBER, UOO_ID, PERCENTAGE FROM IGS_PS_TCH_RESP_OVRD WHERE UOO_ID = :p_uoo_id;
• SELECT ORG_ID, LOCATION_CD, UNIT_CLASS, PERCENTAGE FROM IGS_PS_TCH_RESP_OVRD WHERE CAL_TYPE = :p_cal_type;
• SELECT UNIT_CD, ORG_UNIT_CD, OU_START_DT, PERCENTAGE FROM IGS_PS_TCH_RESP_OVRD WHERE ORG_UNIT_CD = :p_org_unit;

Because the MOAC predicate is applied automatically, no explicit ORG_ID filter is required when the session context is correctly initialized; users will see only rows for their active operating unit. Attempting to bypass the view to query IGS_PS_TCH_RESP_OVRD_ALL would expose records across organizations and is discouraged. As the Student System module is obsolete, no new development should depend on this view, and forward migration to supported successor products is advisable.