Search Results media_description




Overview
Explore in AI Chat

Overview

IGS_PS_MEDIA_EQUIP_V is a database view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Student Systems (IGS) product family that underpins Oracle Student Information Management. The view exposes the set of media equipment records used in the academic and pedagogical delivery context, where "media equipment" refers to the physical or logical resources (for example projectors, laboratory apparatus, presentation units, or other teaching media) that may be associated with the delivery of a program, unit, or teaching activity.

Functionally the view is a thin projection over a single base table. It does not aggregate, join, or transform source data; its purpose is to present the media equipment master data with a stable, read-only interface for forms, concurrent programs, reports, and interface/API extraction routines. Because the object is a view rather than a table, it carries no independent storage and any DML executed against it is ultimately applied to the underlying base table. In Oracle EBS 12.1.1 and 12.2.2 the object is used chiefly for reference and validation lookups rather than transactional posting.

Underlying Base Objects

The view is defined directly over the base table IGS_PS_MEDIA_EQUIP. The documented view text is:

No additional referenced base objects are documented in the ETRM metadata, and no joins, filters, or aggregation clauses appear in the view definition, so the relationship to the base table is strictly one-to-one. The ROWID of the underlying IGS_PS_MEDIA_EQUIP row is surfaced as ROW_ID. Standard "WHO" audit columns are inherited unchanged from the table. The view therefore inherits the table's indexing and constraints indirectly but does not itself enforce them; validation of media codes must still be driven through the base table or its associated lookups.

Key Columns

  • ROW_ID – the ROWID of the corresponding IGS_PS_MEDIA_EQUIP record, enabling direct row addressing when the view is used in update or locking scenarios.
  • MEDIA_CODE – the unique business key identifying a media equipment item. This is the column most commonly used in lookups, foreign-key joins, and validation of data entry.
  • MEDIA_DESCRIPTION – the descriptive or display name of the media equipment. This is the column users typically search for when locating a record by name rather than by code, and it is the field returned in LOV and report listings.
  • CLOSED_IND – an indicator flag denoting whether the media equipment record is active or closed (inactive) for new usage. Reporting queries normally filter on this value to exclude retired items.
  • CREATED_BY, CREATION_DATE – the user and timestamp of the initial record creation, used for audit and data lineage.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – the user, timestamp, and login identifier of the most recent modification, supporting change auditing and incremental extraction.

Common Use Cases and Queries

Typical usage includes providing the LOV source for media equipment selection in Student Systems forms, populating reference data extracts, and validating codes during data conversion or interface loading. Because the view is unfiltered, callers are responsible for applying their own active/inactive logic.

  • Lookup of an item by description: SELECT media_code, media_description FROM apps.igs_ps_media_equip_v WHERE UPPER(media_description) LIKE '%PROJECTOR%';
  • Listing active equipment: SELECT media_code, media_description FROM apps.igs_ps_media_equip_v WHERE NVL(closed_ind,'N') = 'N' ORDER BY media_description;
  • Validation of a code during a load: SELECT COUNT(*) FROM apps.igs_ps_media_equip_v WHERE media_code = :p_media_code;
  • Incremental extraction for integration: SELECT row_id, media_code, media_description, last_update_date FROM apps.igs_ps_media_equip_v WHERE last_update_date > :p_since;

All queries should be schema-qualified with APPS and executed with the standard EBS MO or APPS responsibility context to respect the product's security and access conventions.