Search Results ethnic_group

Overview

IGW_PI_V is a public Oracle EBS view owned by the APPS schema and registered under FND Design Data as IGW.IGW_PI_V. It exposes personal and professional information about the Proposal Manager (Principal Investigator) associated with proposals managed within the Grants/Proposal module. The view is documented as a public view that may be useful for custom reporting or other data requirements, meaning Oracle supports direct query access for extension and reporting purposes without a formal API contract.

The view surfaces identifying attributes of the individual — full name, name components, title, suffix, date of birth, national identifier, sex, and ethnic group — alongside job, degree, and address information, and links each record to the owning proposal and award context. Because the user's search term "ethnic_group" maps directly to the ETHNIC_GROUP column, this view is the appropriate source for workforce or proposal demographic reporting in the IGW product family.

Underlying Base Objects

The ETRM 12.2.2 documentation excerpt does not enumerate the base tables over which IGW_PI_V is defined; the metadata records "Referenced base objects: none documented." The view is therefore documented at the column level only, with status VALID and a stable public definition.

Functionally, the view joins proposal data (identified by PROPOSAL_ID, PROPOSAL_NUMBER, ORGANIZATION_ID, and PROPOSAL_TYPE_CODE) to person data (identified by PERSON_ID and the associated name, demographic, and address attributes). The person-derived columns correspond to standard Oracle HR/per-person structures, while the proposal columns derive from the IGW proposal tables. For custom development, the safest assumption is that IGW_PI_V already performs all required joins, so consumers should query the view rather than attempting to reconstruct the underlying join logic. Where column-level lineage is required for a specific patch level, it should be confirmed against the deployed view source in the target instance, since no base object list is published in the metadata.

Key Columns

• PROPOSAL_ID / PROPOSAL_NUMBER — Primary proposal identifier and human-readable proposal number; the principal join keys back to proposal records.
• ORGANIZATION_ID — Organization identifier associated with the proposal.
• PROPOSAL_TYPE_CODE / ORIGINAL_PROPOSAL_NUMBER / AWARD_NUMBER — Proposal classification and linkage to prior proposals and resulting awards.
• PERSON_ID — Person identifier for the Proposal Manager; the key back to the person record.
• FULL_NAME, LAST_NAME, FIRST_NAME, MIDDLE_NAMES, TITLE, SUFFIX — Name components. LAST_FIRST_MIDDLE_NAME and FIRST_MIDDLE_LAST_NAME provide pre-formatted, comma-separated concatenations for display.
• DATE_OF_BIRTH, NATIONAL_IDENTIFIER, SEX, ETHNIC_GROUP — Sensitive personal and demographic attributes. ETHNIC_GROUP is VARCHAR2(80); NATIONAL_IDENTIFIER is VARCHAR2(30) and represents the social security number. Access to these columns should be restricted and audited.
• JOB_NAME, DEGREES — Job title and academic degrees; DEGREES is VARCHAR2(4000) and only the first three degrees are displayed.
• ADDRESS_LINE1–3, POSTAL_CODE, REGION_1–3 — Mailing address captured in hierarchical region levels.

Common Use Cases and Queries

Typical scenarios include demographic and diversity analysis of proposal managers, proposal workload and award reporting by investigator, and directory-style listings. Because the view is public and read-only, it is well suited to custom reports, Oracle BI Publisher data templates, and integration extracts. Note that a small number of columns appear truncated in the supplied metadata excerpt (for example the DEGREES and trailing region columns) and should be verified against the live definition before use.

• List Proposal Managers with ethnicity and award context:

  SELECT proposal_number, award_number, full_name, sex, ethnic_group, job_name
  FROM   apps.igw_pi_v
  ORDER  BY last_name, first_name;

• Count proposals by ethnic group for diversity reporting:

  SELECT ethnic_group, COUNT(DISTINCT proposal_id) proposal_count
  FROM   apps.igw_pi_v
  GROUP  BY ethnic_group;

• Retrieve contact and address details for a specific investigator:

  SELECT full_name, title, suffix, address_line1, address_line2,
         postal_code, region_1, region_2
  FROM   apps.igw_pi_v
  WHERE  person_id = :p_person_id;

Queries should be executed within an APPS-privileged context and HR security should be considered where person-level data is exposed to general report users.