Search Results igwfv_grnt_prpsl_pers_biosktch

Overview

The view IGWFV_GRNT_PRPSL_PERS_BIOSKTCH belongs to the IGW (Grants Proposal) product family within Oracle E-Business Suite, a module that is documented as obsolete in the ETRM reference set. It is a reporting-oriented, read-only view that consolidates personnel biographical sketch information held against a person record, together with the person's full name and the lookup meaning for the biographical sketch type. In the Oracle EBS reporting and integration model, such a view exists to spare developers and report authors from writing repeated multi-table joins against person, lookup, and sketch detail tables.

The view carries the WITH READ ONLY clause, so it cannot be used as an updateable entity in a form or an interface; it is strictly a query surface. The ETRM metadata records that the object is not implemented in this database, which indicates that the IGW Grants Proposal schema objects were either never created in the instance being documented or were removed as part of the product's obsolescence.

Underlying Base Objects

The view is defined over three sources:

• IGW_PERSON_BIOSKETCH — the primary base table, aliased as BIOSKETCH, holding the biographical sketch lines themselves.
• IGW_LOOKUPS_V — the lookup view, aliased as LKUP1, supplying the translated meaning of the biographical sketch type.
• PER_ALL_PEOPLE_F — the effective-dated Oracle HRMS person table, aliased as PAPF, providing the person's full name.

The join conditions are straightforward. LKUP1.LOOKUP_CODE is joined to BIOSKETCH.BIOSKETCH_TYPE while LKUP1.LOOKUP_TYPE is constrained to 'IGW_BIOSKETCH_TYPES'. The person link is established by PAPF.PERSON_ID = BIOSKETCH.PERSON_ID, further constrained by SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE so that only the currently effective person row is returned. Although the ETRM metadata lists no referenced base objects, the view text itself unambiguously documents these three dependencies.

Key Columns

The projected columns and their practical meaning are as follows:

• PERSON_FULL_NAME — derived from PAPF.FULL_NAME; the formatted full name of the person to whom the sketch belongs.
• BIOSKETCH_TYPE — the translated lookup meaning for the sketch category.
• BIOSKETCH_LINE_SEQUENCE and BIOSKETCH_LINE — the ordering number and the descriptive text of each individual sketch line, sourced from LINE_SEQUENCE and LINE_DESCRIPTION.
• ENABLE_FLAG — indicates whether the sketch line is active or suppressed for display.
• PERSON_BIOSKETCH_ID and PERSON_ID — the surrogate primary key of the sketch record and the foreign key to the person.
• Audit columns LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, and CREATED_BY — standard Oracle EBS who-columns supporting audit and delta extraction.

Common Use Cases and Queries

The view would typically be used on a proposal or grants report to print investigator biographical sketches, or in an interface that exports sketch content for downstream review systems. A representative query filtering to enabled lines and ordering them for presentation is:

• SELECT person_full_name, biosketch_type, biosketch_line
• FROM igwfv_grnt_prpsl_pers_biosktch
• WHERE enable_flag = 'Y'
• ORDER BY person_full_name, biosketch_line_sequence;

A second common pattern retrieves all sketch lines for a specific person by ID:

• SELECT biosketch_type, biosketch_line
• FROM igwfv_grnt_prpsl_pers_biosktch
• WHERE person_id = :p_person_id;

Because the product is obsolete and the object may not exist in a given database, any report or integration referencing it should first verify its presence in ALL_VIEWS and account for the possibility that the underlying IGW tables have been decommissioned.