Results for “igw_support_types”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGW_PRPO_OTHER_SUPPORT_V is a Business Intelligence System (BIS) view owned by the APPS schema in Oracle E-Business Suite, registered under FND Design Data as IGW.IGW_PRPO_OTHER_SUPPORT_V. It presents details of other sources of support that are either pending or already available for personnel named on a proposal. The view is consumed primarily during the generation of flat files for Electronic Data Interchange (EDI) processing, where grant or proposal personnel data must be exported in a fixed, denormalized structure. Because it is a BIS view rather than a transactional entity view, it is intended for read-only reporting and extraction, not for direct DML.

The object is marked VALID in the ETRM 12.1.1 and 12.2.2 object listings. It belongs to the IGW product family, which covers Oracle Grants Proposal and the broader research administration flow. When a user searches for PM_LAST_NAME, this view is returned because it exposes the project manager's name components directly as top-level columns, avoiding the joins that would otherwise be required against the person or party tables.

Underlying Base Objects

The ETRM documentation excerpt for this view does not enumerate the base tables or synonyms over which it is defined; the "Referenced base objects" entry is recorded as none documented. In practice, a BIS view of this shape is constructed from the IGW proposal and other-support entities, including the proposal header, the other-support detail records, and the personnel/party resolution that yields the PM name columns. The OTH_SUPPORT_ATTRIBUTE1 through OTH_SUPPORT_ATTRIBUTE15 columns follow the standard Oracle descriptive flexfield pattern for the other-support entity, with OTH_SUPPORT_ATTRIBUTE_CATEGORY supplying the context that determines which attribute segments are meaningful.

Because the view is defined in the APPS schema, it is normally accessed through the APPS credentials or through a synonym granted to a custom schema. No public base-object list is published, so any dependency analysis should be performed against the live data dictionary views such as ALL_DEPENDENCIES rather than relying on the static ETRM text.

Key Columns

• PROPOSAL_ID — Identifier of the proposal to which the other-support record belongs; the primary join key back to the proposal header.
• PERSON_ID / PARTY_ID — Identifiers of the individual and the corresponding party for whom the other support is reported.
• SUPPORT_STATUS — Status of the external support, distinguishing pending from available or awarded support.
• AWARD_NUMBER, AWARD_TITLE, SPONSOR_NAME — Descriptive identity of the external award or sponsor.
• ANNUAL_DIRECT_COST, TOTAL_COST, PERCENT_EFFORT — Financial and effort measures used in the EDI flat file.
• PM_LAST_NAME, PM_FIRST_NAME, PM_MIDDLE_NAME — Name components of the project manager associated with the other-support record; the columns most commonly targeted by ad hoc searches.
• START_DATE, END_DATE, OVERLAP — Period of the other support and an indicator of overlap with the proposal period.
• OTH_SUPPORT_ATTRIBUTE_CATEGORY and OTH_SUPPORT_ATTRIBUTE1–15 — Descriptive flexfield context and segment values for the other-support record.

Common Use Cases and Queries

The principal use case is extraction for EDI or downstream research administration reporting, where the flat structure removes the need to join proposal, personnel, and flexfield tables. A secondary use is ad hoc inquiry into pending or existing support, particularly locating records by project manager name.

To retrieve all other-support records for a proposal:

• SELECT proposal_id, person_id, support_status, award_number, total_cost, pm_last_name FROM apps.igw_prpo_other_support_v WHERE proposal_id = :p_proposal_id;

To locate records by the searched attribute:

• SELECT proposal_id, person_id, award_title, sponsor_name, pm_last_name, pm_first_name FROM apps.igw_prpo_other_support_v WHERE pm_last_name = :p_last_name;

To report only confirmed support within a date range:

• SELECT award_number, sponsor_name, start_date, end_date, percent_effort FROM apps.igw_prpo_other_support_v WHERE support_status = 'AVAILABLE' AND start_date >= :p_from_date;

Flexfield values should be filtered with OTH_SUPPORT_ATTRIBUTE_CATEGORY to ensure that attribute segments are interpreted in the correct context for the owning entity.