Results for “person_degree_id”

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

Overview

The view IGWBV_GRNT_PRPSL_PERS_DEG_ASGN belongs to the Oracle E-Business Suite product IGW – Grants Proposal, which Oracle classifies as obsolete. The view exposes the association between award proposals and the academic degrees recorded for persons associated with those proposals, joining proposal header information to the person-degree detail table. Its name reflects its purpose: it presents the "grant proposal person degree assignment" relationship within the Grants Proposal data model, with the base table column SHOW_FLAG surfaced as an exposed attribute controlling whether a given degree assignment is displayed.

In the context of Oracle EBS 12.1.1 and 12.2.2, this view is a read-only reporting object. The view definition carries a WITH READ ONLY clause, meaning no DML (INSERT, UPDATE, DELETE) can be issued against it. It serves integration and reporting purposes where a flattened, denormalized listing of proposal numbers alongside personnel degree rows is required, without exposing every column of the underlying transactional tables.

Underlying Base Objects

The documented view text defines the object over exactly two base tables:

• IGW_PROP_PERSON_DEGREES (PPD) – holds the person-degree records associated with proposals, including the degree sequence, the flag controlling display, and standard audit columns.
• IGW_PROPOSALS_ALL (PR) – the proposal header table, supplying the proposal number and proposal identifier.

The two tables are joined on PR.PROPOSAL_ID = PPD.PROPOSAL_ID, so the view returns one row per person-degree assignment per proposal. The ETRM metadata documents no additional referenced base objects. Notably, the ETRM note states "Not implemented in this database," and the documented owner and referenced base objects fields are empty, indicating this view is an unshipped or obsolete artifact that may be absent from a given EBS instance. Deployments still running legacy IGW code may nevertheless encounter it in grants-related reporting.

Key Columns

• PROPOSAL_NUMBER – the human-readable identifier of the proposal, sourced from IGW_PROPOSALS_ALL. This is typically the primary filter or grouping key in reports.
• SHOW_FLAG – the column most directly relevant to the query that surfaced this object. It indicates whether the associated degree record should be displayed, functioning as a display-control attribute on the person-degree assignment.
• DEGREE_SEQUENCE – appears in the view's column list. The view text selects PPD.DEGREE_SEQUENCE, while the documented column list labels the corresponding attribute DEGREE_OBTAINED_SEQUENCE, reflecting the ordinal position of the degree within the person's credentials.
• PROPOSAL_ID and PERSON_DEGREE_ID – the surrogate primary keys linking back to the proposals and person-degree base tables respectively.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY – standard EBS audit columns supporting change tracking and compliance reporting.

Common Use Cases and Queries

The principal use case is enumerating the degree assignments associated with a proposal while honoring the display flag. A typical query retrieves only the assignments marked for display:

• SELECT proposal_number, person_degree_id, degree_obtained_sequence FROM igwbv_grnt_prpsl_pers_deg_asgn WHERE show_flag = 'Y' ORDER BY proposal_number, degree_obtained_sequence;
• Filtering by a specific proposal: SELECT person_degree_id, show_flag FROM igwbv_grnt_prpsl_pers_deg_asgn WHERE proposal_number = :p_proposal_number;
• Audit extraction: SELECT proposal_number, last_updated_by, last_update_date FROM igwbv_grnt_prpsl_pers_deg_asgn WHERE last_update_date >= :since_date;

Because the object is read-only and documented as obsolete, queries should be validated against the target instance before use; where the view is absent, equivalent results must be constructed directly from IGW_PROP_PERSON_DEGREES and IGW_PROPOSALS_ALL.