Search Results igs_ps_media_equip_v

Overview

IGS_PS_MEDIA_EQUIP_V is a simple reporting view owned by the APPS schema in the Oracle E-Business Suite Student System (IGS) product family. In EBS 12.1.1 and 12.2.2 it presents the contents of the media and equipment lookup table maintained by the Student System, exposing the descriptive and audit attributes of each media or equipment code defined for an institution. The view is part of the "PS" (Student System) object naming convention and is referenced by forms, concurrent programs, and self-service pages that need to display human-readable media/equipment descriptions rather than the underlying coded values.

Rather than storing data itself, the view acts as a stable, presentation-layer interface over the base table. It is a row-for-row projection — no filtering, joins, or aggregation are performed — which means it behaves identically to the underlying table for query purposes while providing a layer of abstraction. This abstraction allows Oracle to modify the physical base table without impacting dependent reporting objects, and it allows customers to build reports and integrations against a formally named, supported object rather than the raw table.

Underlying Base Objects

The view is defined over a single base object: IGS_PS_MEDIA_EQUIP. The ETRM view text confirms this with a direct, unfiltered SELECT:

• Base table: IGS_PS_MEDIA_EQUIP — the media and equipment validation table in the IGS Student System.
• Relationship: one-to-one. Every row in the table yields exactly one row in the view; no WHERE clause, DISTINCT, or join constrains the result set.
• ROWID exposure: the view selects ROWID aliased as ROW_ID, preserving a pseudo-key to the underlying physical row.

Because the projection is unfiltered, the view returns all records in the table, including those flagged as closed. Consumers are responsible for applying their own CLOSED_IND predicates when only active values are required.

Key Columns

• ROW_ID — the ROWID of the underlying table row, aliased for reporting. This is a physical row identifier, not a business key, and should not be persisted as a foreign key because ROWIDs change after table reorganization or export/import.
• MEDIA_CODE — the primary business key. This is the coded value stored on transactional student records that reference a particular medium or piece of equipment.
• MEDIA_DESCRIPTION — the translated, user-facing description displayed in forms, LOVs, and reports.
• CLOSED_IND — a status flag indicating whether the code has been end-dated and is no longer available for new selections. Active codes are typically 'N'; closed codes are 'Y'.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard EBS WHO columns that provide the audit trail for each row.

Common Use Cases and Queries

Typical scenarios include reducing a stored MEDIA_CODE to its description on student-facing reports, populating a value set or LOV for data entry, and validating that a code referenced by an integration still exists and is open.

Retrieve all active media and equipment codes for an LOV or report:

• SELECT media_code, media_description FROM igs_ps_media_equip_v WHERE closed_ind = 'N' ORDER BY media_description;

Resolve a single code to its description for reporting:

• SELECT media_description FROM igs_ps_media_equip_v WHERE media_code = :p_media_code;

Audit recently maintained records:

• SELECT media_code, media_description, closed_ind, last_updated_by, last_update_date FROM igs_ps_media_equip_v WHERE last_update_date >= :p_since_date;

Because the view performs no filtering, queries should always include a CLOSED_IND predicate for selection lists to prevent end-dated codes from appearing as valid choices.