Search Results s_org_status

Overview

The view IGS_AS_EXM_SUPRVISOR_V belongs to the IGS – Student System product family, a module that is documented as obsolete in Oracle E-Business Suite 12.1.1 and 12.2.2. The view consolidates examination supervisor records with related person, lookup, and organizational unit information, allowing consumers to query supervisor details in a single denormalized result set rather than joining multiple base entities manually. In the EBS reporting and integration layer, such views typically serve as the primary access point for concurrent programs, Oracle Reports, OBIEE extract routines, and inbound/outbound interfaces that require supervisor data. The ETRM metadata records the implementation/DBA data as "Not implemented in this database," which indicates that in the documented environment the object is absent from the data dictionary. This is consistent with the view belonging to a decommissioned module, and it should therefore be treated as reference-only for the 12.1.1 and 12.2.2 releases.

Underlying Base Objects

Although the documented ETRM metadata lists no referenced base objects, the view definition itself identifies the following sources:

• IGS_AS_EXM_SUPRVISOR – the primary examination supervisor entity, aliased ES.
• IGS_PE_PERSON_V – person details, aliased P.
• IGS_PE_PERSON_LKUPV_V – person descriptive value lookups such as sex and birth data, aliased PDV.
• IGS_AS_EXM_SPRVSRTYP – examination supervisor type descriptions, aliased EST.
• IGS_OR_UNIT – organizational unit details, aliased OU, joined with an outer join on ORG_UNIT_CD and START_DT.
• IGS_OR_STATUS – organization status lookup, aliased ORG_STATUS, outer joined on ORG_STATUS.

The joins are keyed primarily on PERSON_ID and EXAM_SUPERVISOR_TYPE, with the organizational unit and status relationships implemented as outer joins so that supervisors without an assigned responsible unit still appear in the result set.

Key Columns

The view exposes a mixture of identifiers, descriptive attributes, and audit columns. Notable columns include:

• ROW_ID – the ROWID of the underlying supervisor row, useful for direct DML anchoring.
• PERSON_NUMBER, PERSON_ID, PREFERRED_NAME – person identification and display attributes.
• SEX, MEANING_SEX, BIRTH_DT, ENCUMBERED_IND, DECEASED_IND – personal descriptive and status flags.
• ES_DESCRIPTION, IN_CHARGE_IND, CLOSED_IND – supervisor type description and its controlling flags.
• EXAM_SUPERVISOR_TYPE, PREVIOUS_SESSIONS – the supervisor classification and prior session count.
• RESPONSIBLE_ORG_UNIT_CD, OU_DESCRIPTION, ORG_STATUS, S_ORG_STATUS, RESPONSIBLE_OU_START_DT – organizational assignment and its status, where S_ORG_STATUS is the lookup meaning searched by the user.
• COMMENTS and the standard audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical usage centers on retrieving supervisors filtered by organizational status or person attributes. The user's search term s_org_status maps directly to the S_ORG_STATUS column, which resolves the organization status code to its lookup meaning. Example queries include:

• Listing active supervisors by organization status: SELECT person_number, preferred_name, s_org_status FROM igs_as_exm_suprvisor_v WHERE s_org_status = 'ACTIVE';
• Identifying supervisors in charge: SELECT person_number, es_description, in_charge_ind FROM igs_as_exm_suprvisor_v WHERE in_charge_ind = 'Y';
• Reporting supervisors without an assigned organizational unit, exploiting the outer joins: SELECT person_number FROM igs_as_exm_suprvisor_v WHERE responsible_org_unit_cd IS NULL;

Because the object is documented as not implemented in the reference database and belongs to an obsolete product, these queries are illustrative of the intended contract rather than guaranteed runnable. Integrations referencing this view should be migrated to supported alternatives within the current EBS data model.