Search Results org_status




Overview
Explore in AI Chat

Overview

APPS.IGS_AS_EXM_SUPRVISOR_V is a reporting view in the Oracle E-Business Suite student system (the IGS/Student Systems product family, delivered under the Oracle Student System and its assessment components). It presents examination supervisor assignments together with the descriptive attributes of the person acting as supervisor, the supervisor type definition, the responsible organization unit, and the organization unit status. The view is read-only and is intended for inquiry, reporting, and integration scenarios where a denormalized, human-readable representation of examination supervision records is required. In Oracle EBS 12.1.1 and 12.2.2 the object resides in the APPS schema and is normally accessed through a custom responsibility or via a synonym granted to reporting users.

The view is particularly relevant to queries involving the organization status of the responsible unit, since it exposes both the coded value (ORG_STATUS) and the decoded description (S_ORG_STATUS). This makes it convenient for filtering on active versus inactive organizational units without joining to the status lookup table directly.

Underlying Base Objects

The view is defined over six objects joined in a single SELECT statement. Although the ETRM metadata does not document referenced base objects, the view text explicitly names them:

  • IGS_AS_EXM_SUPRVISOR (aliased ES) — the primary base table of examination supervisor assignments.
  • IGS_PE_PERSON_V (aliased P) — the person view supplying person number, preferred name, and encumbered indicator.
  • IGS_PE_PERSON_LKUPV_V (aliased PDV) — the person lookup view supplying sex, birth date, and deceased indicator.
  • IGS_AS_EXM_SPRVSRTYP (aliased EST) — the examination supervisor type definition table.
  • IGS_OR_UNIT (aliased OU) — the organization unit table supplying description and status.
  • IGS_OR_STATUS (aliased ORG_STATUS) — the organization status lookup, providing the decoded status description.

The joins are keyed on PERSON_ID, EXAM_SUPERVISOR_TYPE, and, for the organization unit, on ORG_UNIT_CD and START_DT. The organization unit and organization status joins are outer joins (indicated by the (+) operator), so supervisor records are retained even when no matching responsible organization unit or status row exists.

Key Columns

Common Use Cases and Queries

The view supports examiner supervision reporting, supervisor listing by organization, and filtering by organization status. A typical query listing active supervisors is:

  • SELECT person_number, preferred_name, exam_supervisor_type, responsible_org_unit_cd, ou_description, s_org_status FROM apps.igs_as_exm_suprvisor_v WHERE s_org_status = 'Active';
  • SELECT person_id, preferred_name, org_status FROM apps.igs_as_exm_suprvisor_v WHERE responsible_org_unit_cd = :org_unit_cd ORDER BY preferred_name;

Because ORG_STATUS and S_ORG_STATUS are exposed alongside the supervisor detail, reports can filter, group, or sort on organizational status without additional joins to IGS_OR_STATUS. Users should note the outer-join semantics: when a supervisor has no responsible organization unit, OU_DESCRIPTION, ORG_STATUS, and S_ORG_STATUS return null.