Search Results cv_version_number




Overview
Explore in AI Chat

Overview

The APPS.IGS_CO_OU_CO_REF view is a critical data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (OSM) product, previously known as Campus Solutions. This view serves as a security-filtered interface to the underlying base table, IGS_CO_OU_CO_REF_ALL. Its primary function is to store and provide access to organizational unit (OU) correspondence references, which link official communications or documents (correspondence) to specific academic entities such as courses and units for a person. The view's WHERE clause implements a Multi-Org security model, restricting rows to those associated with the user's current operating unit context, as derived from the CLIENT_INFO session variable. This ensures data isolation and integrity in a shared installation.

Key Information Stored

The view consolidates key identifiers for a person, their correspondence, and the related academic structures. Important columns include:

  • PERSON_ID: The unique identifier for the student or person.
  • CORRESPONDENCE_TYPE, REFERENCE_NUMBER, ISSUE_DT: Core details identifying the specific correspondence document.
  • COURSE_CD and CV_VERSION_NUMBER: The code and version number of the course (program of study) to which the correspondence is linked. The CV_VERSION_NUMBER is a critical field for tracking the specific curriculum version.
  • UNIT_CD and UV_VERSION_NUMBER: The code and version number of the unit (module or subject) related to the correspondence.
  • CAL_TYPE and CI_SEQUENCE_NUMBER: Identifies the academic calendar (e.g., semester, term) and its sequence.
  • ORG_ID: The operating unit identifier, central to the view's security filtering.

Common Use Cases and Queries

This view is primarily used for reporting and data extraction related to student communications within their academic context. A common scenario involves generating a list of all official correspondence issued for a specific course version. For example, to find correspondence for a person (ID 12345) related to a particular course version, one might query:

SELECT correspondence_type, reference_number, issue_dt
FROM apps.igs_co_ou_co_ref
WHERE person_id = 12345
AND course_cd = 'BSC_COMPSCI'
AND cv_version_number = 2020;

Another key use case is auditing or compliance reporting, where it is necessary to verify that specific communications were issued and linked to the correct academic program version. The view is also essential for integrations that need to retrieve correspondence data filtered by the user's authorized operating unit.

Related Objects

The view has a direct relationship with its base table and is linked to other core OSM entities via foreign keys. Key related objects include:

  • IGS_CO_OU_CO_REF_ALL: The base table from which this view selects data. The join is implicit on all columns, with the view applying the ORG_ID security filter.
  • IGS_PE_PERSON (PERSON_ID): The master person table, providing student demographic information.
  • IGS_PS_COURSE (COURSE_CD, CV_VERSION_NUMBER): The course version master table.
  • IGS_PS_UNIT (UNIT_CD, UV_VERSION_NUMBER): The unit version master table.
  • IGS_CA_INST (CAL_TYPE, CI_SEQUENCE_NUMBER): The calendar instance table.

The relationships are enforced through the foreign key columns (PERSON_ID, COURSE_CD, CV_VERSION_NUMBER, etc.) stored in the underlying IGS_CO_OU_CO_REF_ALL table, ensuring referential integrity to the core academic and person master data.