Results for “project_location”

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

Overview

IGW_PRPO_OTHER_SUPPORT_V is a Grants Proposal (IGW) view in Oracle E-Business Suite 12.1.1 and 12.2.2 that presents the "other sources of support" declared for personnel associated with a proposal. In the grants lifecycle, principal investigators and key personnel must disclose pending and active awards, sponsorships, and in-kind contributions when a proposal is submitted. This view consolidates those disclosures—termed other support—into a single reporting structure joining personnel, sponsor, and lookup reference data. As with the broader IGW module, the object belongs to the Grants Proposal product family, which Oracle has since designated obsolete and which is not implemented in a standard EBS database; it is shipped only for customers running legacy OPA or Grants installations.

The view is read-only by design and is intended for inquiry, extraction, and integration rather than transactional maintenance of other-support records. Its principal value lies in exposing the PROJECT_LOCATION attribute alongside award, cost, and effort metrics, allowing administrators and reporting tools to evaluate whether declared support overlaps geographically or temporally with the pending proposal.

Underlying Base Objects

ETRM documentation identifies no separate base objects beyond those visible in the view text. The definition selects from four objects:

• IGW_PROP_PERSON_SUPPORT — the driving table, storing one row per other-support disclosure linked to a proposal and person.
• PER_PEOPLE_X — supplies the person's last, first, and middle names; joined on PI_PERSON_ID with an outer (+) operator.
• IGW_LOOKUPS_V — a lookup view restricted to LOOKUP_TYPE = 'IGW_SUPPORT_TYPES' that decodes the support type code into a meaning; joined with an outer (+) operator.
• RA_CUSTOMERS — provides the sponsor or customer name via CUSTOMER_ID linked to SPONSOR_ID; also an outer join.

All three supporting joins are outer, so disclosures persist in the result set even when the person, lookup, or customer record is missing.

Key Columns

• PROPOSAL_ID, PERSON_ID, PARTY_ID — identifiers tying the disclosure to the proposal and the disclosed individual.
• SUPPORT_STATUS — the decoded meaning of the other-support type, such as pending or current.
• AWARD_NUMBER / AWARD_TITLE — the sponsor's award reference and title for the disclosed support.
• ANNUAL_DIRECT_COST, TOTAL_COST, PERCENT_EFFORT — financial and effort commitments associated with the other support.
• SPONSOR_NAME — resolved from RA_CUSTOMERS.CUSTOMER_NAME.
• PROJECT_LOCATION — the geographic location where the disclosed project is performed; frequently queried to detect institutional or geographic overlap.
• START_DATE, END_DATE, OVERLAP — the support period and any overlap indicator.
• MAJOR_GOALS — narrative description of the disclosed project's objectives.
• OTH_SUPPORT_ATTRIBUTE_CATEGORY and OTH_SUPPORT_ATTRIBUTE1–15 — descriptive flexfield columns for customer-specific extensions.

Common Use Cases and Queries

Typical uses include other-support disclosure reports, conflict-of-interest reviews, and extracts feeding grants data warehouses. A search on "project_location" commonly returns this view because it is the only IGW structure surfacing that column directly. A representative query is:

SELECT proposal_id, person_id, award_number, sponsor_name, project_location, start_date, end_date, percent_effort FROM igw_prpo_other_support_v WHERE proposal_id = :p_proposal_id ORDER BY start_date;

Analysts detecting geographic overlap filter on PROJECT_LOCATION, for example WHERE project_location LIKE '%Cambridge%'. Because the view is not implemented in a base EBS database, its availability depends on the legacy Grants schema being present; queries against it will fail with ORA-00942 otherwise. Oracle recommends migrating to successor grant-management offerings.