Search Results igwfv_grant_proposal_pers_asgn

Overview

IGWFV_GRANT_PROPOSAL_PERS_ASGN is a read-only (WITH READ ONLY) view in the Oracle E-Business Suite IGW – Grants Proposal module, which is documented as obsolete in ETRM 12.2.2. The view presents the assignment of persons to grant proposals, joining personnel records to their proposal, role type, person details, and organization. It exposes proposal-level staffing data such as the proposal number, the person assigned, the role played on the proposal, key person and principal investigator flags, and the percentage of effort committed. The suffix "PERS_ASGN" denotes "person assignment," consistent with its role of reporting which individuals are attached to a given proposal and in what capacity.

Because IGW (Grants Proposal) is flagged as obsolete and the documentation states "Not implemented in this database" for the referenced environment, this view is primarily relevant to historical or legacy reporting on older EBS 12.1.1 and 12.2.2 installations where the IGW schema was still deployed. In such environments it functions as a reporting and integration surface over the underlying Grants Proposal person tables, allowing concurrent programs, BI Publisher reports, or custom queries to retrieve proposal staffing information in a denormalized, human-readable form without writing the multi-table join repeatedly.

Underlying Base Objects

The view text defines five referenced base objects, all joined in the WHERE clause:

• IGW_PROP_PERSONS PER – the primary driver table holding the proposal-to-person assignment records, including role code, effort, and the key person and PI flags.
• IGW_PROPOSALS_ALL PR – the proposals master, providing the proposal number and joined on PROPOSAL_ID.
• IGW_LOOKUPS_V LKUP1 – the lookups view filtered to LOOKUP_TYPE = 'IGW_PROPOSAL_ROLE_TYPES', translating the stored PROPOSAL_ROLE_CODE into a descriptive MEANING.
• PER_ALL_PEOPLE_F PAPF – the person effective-dated table, joined on PERSON_ID and constrained so that TRUNC(SYSDATE) falls between the effective start and end dates, yielding the current person record.
• HR_ALL_ORGANIZATION_UNITS HR – the organization units table, joined on PERSON_ORGANIZATION_ID, supplying the organization name associated with the assignment.

ETRM notes that no base objects are documented for the owner, but the view text itself establishes these five dependencies. The effective-dated join to PER_ALL_PEOPLE_F is significant: the view always returns the person's currently effective row, so historical name changes are not reflected.

Key Columns

• PROPOSAL_NUMBER – business identifier of the grant proposal.
• PERSON_SEQUENCE – ordering sequence of the person within the proposal assignment list.
• PROPOSAL_ROLE – the meaning of the role type (from IGW_LOOKUPS_V), e.g., a predefined proposal role.
• KEY_PERSON_FLAG – indicates whether the individual is designated a key person on the proposal.
• PERCENT_EFFORT – the percentage of effort the person is committing to the proposal.
• PI_FLAG – indicates whether the person is the Principal Investigator.
• PERSON_FULL_NAME – full name of the assigned person (from PER_ALL_PEOPLE_F).
• PERSON_ORG_NAME – name of the organization unit associated with the assignment.
• PROPOSAL_ID, PERSON_ID, PERSON_ORGANIZATION_ID – surrogate keys enabling joins back to the base tables.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY – standard audit columns from IGW_PROP_PERSONS.

Common Use Cases and Queries

Typical uses include identifying principal investigators and key personnel per proposal, reporting effort distribution, and reconciling proposal staffing for grants administration. A representative query lists all personnel on a given proposal:

• SELECT proposal_number, person_full_name, proposal_role, person_sequence, percent_effort, pi_flag, key_person_flag FROM igwfv_grant_proposal_pers_asgn WHERE proposal_number = :proposal_number ORDER BY person_sequence;
• SELECT proposal_number, person_full_name FROM igwfv_grant_proposal_pers_asgn WHERE pi_flag = 'Y';
• SELECT person_full_name, person_org_name, SUM(percent_effort) FROM igwfv_grant_proposal_pers_asgn GROUP BY person_full_name, person_org_name;

Because the view is read-only and IGW is obsolete, any reliance on it should be validated against the actual schema present in the target 12.1.1 or 12.2.2 instance, as the module may not be implemented.