Search Results igp_us_portfolios




Overview
Explore in AI Chat

Overview

The IGP_US_PORTFOLIOS table is a core data structure within the now-obsolete IGS (Student System) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. Its primary function was to serve as the master repository for storing detailed records of student or academic portfolios. A portfolio, in this context, typically represents a curated collection of a student's academic work, achievements, or related administrative records. The table's design, centered around a unique PORTFOLIO_ID, establishes it as a key reference point for associating various student activities, financial accounts, and authorized viewers within the legacy student information system.

Key Information Stored

While the full column list is not provided in the metadata, the documented primary and foreign key relationships reveal the essential data elements. The central column is PORTFOLIO_ID, which serves as the unique primary key identifier for each portfolio record. Another critical column is ACCOUNT_ID, which creates a link to the IGP_AC_ACCOUNTS table, indicating a financial or administrative account associated with the portfolio. It is logical to infer the table also contained descriptive columns such as portfolio name, creation date, status, and possibly a reference to the student or owner, though these are not explicitly listed in the provided excerpt.

Common Use Cases and Queries

This table was fundamental for queries related to student records and their associated components. Common reporting and operational use cases included generating a list of all portfolios linked to a specific student account, identifying portfolios with recent activity, or managing user access permissions. A typical query would join IGP_US_PORTFOLIOS to its related tables to build a comprehensive view. For example, to list portfolios and their linked financial accounts, a developer might use:

  • SELECT p.PORTFOLIO_ID, p.ACCOUNT_ID, a.ACCOUNT_NAME FROM IGP_US_PORTFOLIOS p, IGP_AC_ACCOUNTS a WHERE p.ACCOUNT_ID = a.ACCOUNT_ID;

Another common pattern involved retrieving all activities for a given portfolio by joining with the IGP_VW_PORT_ACTIVITIES view using the PORTFOLIO_ID column.

Related Objects

The IGP_US_PORTFOLIOS table is integrally connected to several other objects in the obsolete IGS module, as defined by its foreign key constraints. The documented relationships are:

  • IGP_AC_ACCOUNTS: Linked via the ACCOUNT_ID column in IGP_US_PORTFOLIOS. This associates each portfolio with a financial or administrative account.
  • IGP_US_REG_VIEWERS: Referenced by its PORTFOLIO_ID column, which is a foreign key to IGP_US_PORTFOLIOS. This table manages users authorized to view or access the portfolio.
  • IGP_VW_PORT_ACTIVITIES: A view that references the table, also via the PORTFOLIO_ID column. This view likely consolidates activity logs or events related to each portfolio.

It is crucial to note the metadata states this table was "Not implemented in this database," indicating it may exist in the data dictionary but not be populated or actively used in a standard deployment.