Search Results igw_proposal_role_types




Overview
Explore in AI Chat

Overview

APPS.IGWBV_GRANT_PROPOSAL_PERS_ASGN is a read-only Oracle EBS view that consolidates grant proposal personnel assignments with descriptive role information. It is part of the Oracle Grants Management (IGW) schema and is exposed in ETRM 12.2.2 as a reporting and integration aid for proposal staffing data. The view joins proposal header information, proposal person (assignment) records, and the IGW_PROPOSAL_ROLE_TYPES lookup so that consumers see a resolved role meaning rather than a raw lookup code.

The "BV" designation indicates a business view intended for query and reporting use. The view is defined with WITH READ ONLY, so it cannot be used as a DML target. It provides a denormalized, human-readable projection of the proposal-to-personnel relationship used throughout Grants proposal processing.

Underlying Base Objects

The view text references three objects:

  • IGW_PROP_PERSONS PER — the primary personnel assignment table, holding person records tied to a proposal, including sequence, role code, effort, and key person indicators.
  • IGW_PROPOSALS_ALL PR — the proposals base table providing proposal number and proposal identifier.
  • IGW_LOOKUPS_V LKUP1 — the lookups view filtered to LOOKUP_TYPE = 'IGW_PROPOSAL_ROLE_TYPES', supplying the role meaning.

The join conditions link PR.PROPOSAL_ID to PER.PROPOSAL_ID and LKUP1.LOOKUP_CODE to PER.PROPOSAL_ROLE_CODE. The view metadata documents no additional base objects beyond these.

Key Columns

Common Use Cases and Queries

This view supports reporting on proposal personnel and role composition, and provides the role meaning needed when the lookup code alone is insufficient.

  • Listing all personnel on a proposal with their role meaning.
  • Identifying principal investigators and key personnel.
  • Reporting percent effort by role across proposals.

Sample SQL:

SELECT proposal_number,
       person_sequence,
       meaning,
       key_person_flag,
       percent_effort,
       pi_flag
FROM   apps.igwbv_grant_proposal_pers_asgn
WHERE  proposal_number = :p_proposal_number
ORDER  BY person_sequence;

Because IGW_PROPOSAL_ROLE_TYPES is the lookup referenced internally, queries filtering by role should compare against MEANING or join to IGW_LOOKUPS_V on the same lookup type to obtain the underlying LOOKUP_CODE where required for integration logic.