Search Results igp_us_reg_viewers




Overview
Explore in AI Chat

Overview

The IGP_US_REG_VIEWERS table is a data object within the Oracle E-Business Suite (EBS) Student System (IGS), specifically noted as obsolete. Its primary function is to manage the relationship between portfolio assignments and authorized viewers. In the context of student portfolio management, it serves as a junction table, linking specific portfolios (IGP_US_PORTFOLIOS) with the individuals or entities (HZ_PARTIES) who are registered to view them. This table is a core component for managing access permissions and audit trails for portfolio content within the obsolete IGS module. The provided metadata indicates it is "Not implemented in this database," suggesting it may be a reference or legacy object in the documented EBS versions (12.1.1 / 12.2.2).

Key Information Stored

The table's structure centers on establishing and identifying viewer assignments. The primary key, REG_VIEWER_ID, uniquely identifies each viewer-portfolio relationship record. The critical foreign key columns define the core relationships: PORTFOLIO_ID links to the specific portfolio being accessed, PARTY_ID identifies the individual viewer (a person from HZ_PARTIES), and ORG_PARTY_ID links to an organizational party, potentially representing a department, institution, or company associated with the viewing context. This design allows for granular tracking of which parties are permitted to view which student portfolios.

Common Use Cases and Queries

This table supports administrative and reporting functions related to portfolio access control. A common use case is generating a list of all authorized viewers for a specific student's portfolio for audit purposes. Another scenario involves checking if a particular individual (party) has viewing rights across any portfolios. Sample SQL patterns would typically involve joins to the HZ_PARTIES table to resolve party names.

  • To list all viewers for a portfolio: SELECT p.party_name, rv.* FROM igp_us_reg_viewers rv, hz_parties p WHERE rv.party_id = p.party_id AND rv.portfolio_id = :PORTFOLIO_ID;
  • To find all portfolios a specific party can view: SELECT pf.* FROM igp_us_reg_viewers rv, igp_us_portfolios pf WHERE rv.portfolio_id = pf.portfolio_id AND rv.party_id = :PARTY_ID;

Related Objects

The IGP_US_REG_VIEWERS table has defined foreign key relationships with other core EBS tables, as documented in the ETRM metadata.

  • IGP_US_PORTFOLIOS: Linked via the PORTFOLIO_ID column. This is the primary relationship, connecting a viewer record to the specific portfolio assignment it governs.
  • HZ_PARTIES (Person): Linked via the PARTY_ID column. This relationship identifies the individual human viewer authorized to access the portfolio.
  • HZ_PARTIES (Organization): Linked via the ORG_PARTY_ID column. This relationship associates the viewer record with an organizational entity, which may be used for grouping or institutional reporting.

The table's primary key constraint is named IGP_US_REG_VIEWERS_PK on the REG_VIEWER_ID column.