Search Results portfolio_type_code

Overview

The IGS.IGP_US_PORTFOLIOS table is a core data repository within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, specifically for the IGS (iGrad) product family. It serves as the primary storage entity for portfolio records, which are structured collections of work, achievements, and career-related materials created by users (typically students). The table's fundamental role is to manage the master definition of each portfolio, including its metadata, publication status, and ownership, thereby supporting key functionalities in career services and student self-representation modules.

Key Information Stored

The table's columns capture the essential attributes defining a portfolio. The primary identifier, PORTFOLIO_ID, is a system-generated sequence number. Critical relational and descriptive fields include ACCOUNT_ID, which links to the portfolio's author or owner, and PORTFOLIO_NAME, a mandatory 80-character field for the portfolio's title. Business logic is governed by columns such as PORTFOLIO_TYPE_CODE, PUB_START_DATE, PUB_END_DATE, and flags like PUB_CAREER_SERVICES_FLAG and ASSIGNED_FLAG. For enhanced searchability, the table provides lengthy text columns for DESCRIPTION, PURPOSE, and CAREER_OBJECTIVE, which are indexed using domain indexes. Standard EBS "Who" columns (CREATED_BY, LAST_UPDATE_DATE, etc.) and OBJECT_VERSION_NUMBER are present for auditing and data integrity.

Common Use Cases and Queries

Primary use cases involve retrieving portfolios for user dashboards, administrative reporting, and integration with career service tools. A frequent query pattern is searching for active portfolios by name for a specific user. For instance, to find all portfolios containing "Engineering" in the name for account ID 1001:

• SELECT portfolio_id, portfolio_name, portfolio_type_code, description FROM igs.igp_us_portfolios WHERE account_id = 1001 AND portfolio_name LIKE '%Engineering%';

Another common operational report identifies portfolios currently published to career services:

• SELECT portfolio_id, portfolio_name, pub_start_date, pub_end_date FROM igs.igp_us_portfolios WHERE pub_career_services_flag = 'Y' AND SYSDATE BETWEEN pub_start_date AND NVL(pub_end_date, SYSDATE);

Data maintenance often involves updating the ASSIGNED_FLAG based on related assignment records or modifying publication windows.

Related Objects

The table's integrity and functionality are supported by several related database objects. Its primary key is enforced by the unique index IGP_US_PORTFOLIOS_PK on PORTFOLIO_ID. A critical unique index, IGP_US_PORTFOLIOS_U1, enforces a key constraint on the combination of ACCOUNT_ID and PORTFOLIO_NAME, preventing duplicate portfolio names for a single user. The domain indexes (IGP_US_PORTFOLIOS_CTX1, CTX2, CTX3) on PURPOSE, CAREER_OBJECTIVE, and DESCRIPTION facilitate full-text searching within portfolio content. This table is a likely parent to other IGS tables storing portfolio items, comments, or viewer assignments, which would reference the PORTFOLIO_ID as a foreign key.