Results for “igw_prop_persons”

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

Overview

IGW_PROP_PERSONS is a table within the Oracle E-Business Suite Grants Proposal (IGW) module, which is documented as obsolete in Oracle EBS 12.1.1 and 12.2.2. The table stores personnel records associated with a grant or research proposal, capturing the individuals who participate in a proposal and the roles they perform. In the ETRM metadata, the table is described as "Personnel included in the proposal," and it is accompanied by the note "Not implemented in this database," meaning that while its definition persists in the data dictionary and reference materials, the physical object is not deployed in a standard installation. This is typical of obsolete or legacy Grants Proposal objects retained for historical and documentation continuity.

From a heuristic data modeling standpoint, the metadata classifies IGW_PROP_PERSONS as satellite-leaning. A satellite is generally dependent on a parent hub or link and carries descriptive attributes rather than defining new business entities. Here, the table's composite primary key and multiple foreign-key relationships to IGW_PROPOSALS_ALL and HR_ALL_ORGANIZATION_UNITS support that interpretation: the table provides context-rich attributes describing each person's involvement in a proposal rather than acting as an independent hub.

Key Information Stored

The table's structure is built around proposal and person identifiers, with descriptive attributes for each participant. The most significant columns include:

• PROPOSAL_ID — Foreign key to IGW_PROPOSALS_ALL, identifying the parent proposal.
• PERSON_PARTY_ID — The party identifier for the person, forming part of the composite primary key.
• PERSON_ID — The person identifier used across related Grants Proposal tables.
• PROP_PERSON_ID — A candidate surrogate or sequence identifier for the proposal-person association.
• PERSON_SEQUENCE — Ordering value for personnel records within a proposal.
• PROPOSAL_ROLE_CODE — Code indicating the person's role on the proposal.
• PI_FLAG and KEY_PERSON_FLAG — Flags identifying the principal investigator and key personnel.
• PERCENT_EFFORT — The percentage of effort committed by the person.
• PERSON_ORGANIZATION_ID — Foreign key to HR_ALL_ORGANIZATION_UNITS, identifying the person's organization.
• PERSON_ORGANIZATION_NAME and ORG_PARTY_ID — Descriptive organization attributes.
• ADDITIONAL_INFO — Supplementary information about the person's involvement.
• RECORD_VERSION_NUMBER — Optimistic locking/version control column.
• Audit columns: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN.

The primary key IGW_PROP_PERSONS_PK consists of PROPOSAL_ID and PERSON_PARTY_ID, and the unique index IGW_PROP_PERSONS_U1 (PROPOSAL_ID, PERSON_PARTY_ID) serves as the documented business-key candidate.

Common Use Cases and Queries

Because the table is obsolete and not implemented in a standard database, reporting use is primarily historical or migration-oriented. A typical query would join IGW_PROP_PERSONS to IGW_PROPOSALS_ALL to list all personnel associated with a proposal, filtering by role or principal investigator status. Analysts migrating legacy Grants Proposal data might extract rows into a target personnel model, joining on PERSON_ID and PERSON_PARTY_ID. A sample pattern is:

SELECT p.PROPOSAL_ID, p.PERSON_ID, p.PROPOSAL_ROLE_CODE, p.PERCENT_EFFORT
FROM   IGW_PROP_PERSONS p
WHERE  p.PROPOSAL_ID = :proposal_id;

Another common pattern joins to HR_ALL_ORGANIZATION_UNITS to report personnel by organization. Principal investigator and key-person flags support reporting on proposal leadership composition, while PERCENT_EFFORT supports effort analysis.

Related Objects

The most significant related objects and their join columns are:

• IGW_PROPOSALS_ALL — joined via IGW_PROP_PERSONS.PROPOSAL_ID.
• HR_ALL_ORGANIZATION_UNITS — joined via IGW_PROP_PERSONS.PERSON_ORGANIZATION_ID.
• IGW_BUDGET_PERSONS — references this table via PROPOSAL_ID and shares PERSON_ID.
• IGW_PROP_PERSON_SUPPORT — references this table via PROPOSAL_ID and shares PERSON_ID.

These relationships confirm the table's role as a personnel-detail satellite within the obsolete Grants Proposal schema.