Search Results igp_us_pages_pk

Overview

The IGP_US_PAGES table is a core data repository within the Oracle E-Business Suite (EBS) Student System (IGS). It serves the specific function of storing the structural and content data for Portfolio Pages. In the context of student management, a portfolio is a collection of work, achievements, or reflections, and this table manages the individual pages that constitute those portfolios. Its role is to maintain the integrity and hierarchy of portfolio content, enabling features related to student assessment, presentation, and record-keeping within the academic framework of EBS.

Key Information Stored

While the full column list is not provided in the excerpt, the documented metadata clearly defines the primary and foreign key structure. The central column is PAGE_ID, which serves as the unique identifier for each portfolio page record and is the primary key (IGP_US_PAGES_PK). Another critical column is PORTFOLIO_ID, which acts as a foreign key. This column links each individual page to its parent portfolio record, establishing the essential one-to-many relationship between a portfolio and its constituent pages. Other columns in the table would typically store page-specific attributes such as sequence number, title, content (or pointers to content), creation date, and status.

Common Use Cases and Queries

This table is central to any process involving the creation, retrieval, or reporting of student portfolio data. A common administrative use case is generating a list of all pages within a specific portfolio for review or audit purposes. For reporting, one might join this table to the parent portfolio table to analyze page count or content distribution across different student cohorts. A fundamental query pattern involves filtering by PORTFOLIO_ID to select all related pages, often ordered by a sequence column.

SELECT page_id, page_title, sequence_num
FROM igs.igp_us_pages
WHERE portfolio_id = :portfolio_id
ORDER BY sequence_num;

Data maintenance operations, such as archiving or purging portfolio data, would also directly involve this table, typically executed via controlled APIs or batch processes within the IGS module.

Related Objects

Based on the provided ETRM relationship data, the primary documented relationship for IGP_US_PAGES is a foreign key constraint. The PORTFOLIO_ID column in IGP_US_PAGES references a parent table (the name of which is partially obscured in the documentation as '%'). This parent table is almost certainly the master portfolio definition table within the IGS schema, such as IGP_US_PORTFOLIOS or a similarly named object. The relationship enforces referential integrity, ensuring that every page is associated with a valid, existing portfolio record. The table itself is referenced by its primary key, PAGE_ID, which is likely used by child tables storing more granular page elements, such as page components, comments, or version history, though these are not explicitly listed in the provided metadata.