Search Results pi_flag




Overview
Explore in AI Chat

Overview

APPS.IGWFV_GRANT_PROPOSAL_PERS_ASGN is a Business Intelligence System (BIS) view owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle Grants Management (IGW) product family and exposes grant proposal personnel assignment data — the association between a grant proposal and the people assigned to it, together with their proposal role, effort commitment, and key-person indicators. The view is registered in FND Design Data as IGW.IGWFV_GRANT_PROPOSAL_PERS_ASGN and carries a status of VALID in both the 12.1.1 and 12.2.2 releases.

The "FV" naming convention indicates that this object is a formatted, denormalized view intended for reporting and integration rather than for transactional DML. It collapses the master–detail relationships between proposals and personnel into a single flat record set that is convenient for business intelligence tools, Oracle Discoverer workbooks, and custom concurrent programs that must report on proposal staffing. Because the view resolves descriptive attributes such as person names and organization names at query time, it is not a substitute for the base tables when performing updates; it is a read-only reporting surface.

The view is not referenced by any other database object, meaning nothing in the schema depends on it. This makes it safe to query without cascading impacts, though it also means the view must be maintained in step with changes to its underlying tables.

Underlying Base Objects

The view is defined over the following documented dependencies:

The relationship is a proposal header to personnel detail join, enriched with HR person and organization lookups. Effective-dated HR joins through PER_ALL_PEOPLE_F explain the presence of the standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY) on the view output.

Key Columns

  • PROPOSAL_NUMBER / PROPOSAL_ID — the human-readable and internal identifiers of the grant proposal.
  • PERSON_SEQUENCE — the ordering sequence of the person within the proposal's assignment list.
  • PROPOSAL_ROLE — the role the person plays on the proposal (for example, Principal Investigator or Co-Investigator).
  • PI_FLAG — the indicator that designates whether the assigned person is the Principal Investigator for the proposal. This is the column that answers the "pi_flag" search and is the primary filter used to isolate PI records.
  • KEY_PERSON_FLAG — indicates whether the person is classified as a key person on the proposal.
  • PERCENT_EFFORT — the committed percentage of effort for the individual on the proposal.
  • PERSON_FULL_NAME / PERSON_ORG_NAME — denormalized display values for the person and their home organization.
  • PERSON_ID / PERSON_ORGANIZATION_ID — the surrogate keys linking back to HR entities.

Common Use Cases and Queries

The most frequent use is identifying the Principal Investigator for each proposal, since downstream award and effort-certification processes key off this designation. A typical query is:

  • SELECT proposal_number, person_full_name, proposal_role, percent_effort FROM apps.igwfv_grant_proposal_pers_asgn WHERE pi_flag = 'Y';
  • Listing all personnel and their effort on a given proposal: SELECT person_full_name, proposal_role, percent_effort, key_person_flag FROM apps.igwfv_grant_proposal_pers_asgn WHERE proposal_number = :p_proposal_number ORDER BY person_sequence;
  • Reporting key-person effort commitments: SELECT proposal_number, person_full_name, percent_effort FROM apps.igwfv_grant_proposal_pers_asgn WHERE key_person_flag = 'Y';
  • Joining the view to IGW_PROPOSALS_ALL for award-linked analysis, or to HR views such as PER_PEOPLE_F for additional demographic detail.

Because the view is read-only and not referenced by other objects, it can be used freely in reports, BI Publisher data templates, and integration extracts without risk of affecting transactional processing.