Search Results study_title

Overview

APPS.IGW_PRPO_SUBJECT_INFO_V is a Business Intelligence System (BIS) view in the Oracle E-Business Suite Applications (APPS) schema. It is registered under the FND Design Data identifier IGW.IGW_PRPO_SUBJECT_INFO_V, carries a status of VALID, and is owned by the APPLSYS-managed APPS account. The view is a component of the Oracle Grants Management / Proposal (IGW) module and presents a denormalized, reporting-oriented projection of human subject demographic information captured against a proposal. Its principal role is to expose subject population data in a flat, single-row-per-proposal format suitable for extraction, downstream reporting, and the generation of a flat file for Electronic Data Interchange (EDI). The view is not an operational transactional object; it is read-only and is queried rather than maintained.

The user-visible label "study_title" surfaces here as the STUDY_TITLE column, which is the human-readable name of the study associated with the proposal. This column acts as the primary descriptive attribute of the view, allowing report authors to identify the proposal without joining to the proposal header.

Underlying Base Objects

Per the documented dependency information, APPS.IGW_PRPO_SUBJECT_INFO_V references the following base objects:

• IGW_REPORT_PROCESSING — the report-processing table that supplies the demographic subject counts by race and gender.
• IGW_STUDY_TITLES — the table that supplies the STUDY_TITLE value linked to each proposal.

Both base objects reside in the APPS schema. The view joins these sources to produce one consolidated row per PROPOSAL_ID. The metadata explicitly notes that APPS.IGW_PRPO_SUBJECT_INFO_V is not referenced by any other database object, confirming that it sits at the top of its dependency chain and is consumed by external reports or interface programs rather than by further views or packages. The documented view type is "Business Intelligence System view," which in EBS terminology indicates a curated, end-user-facing view intended for query and reporting rather than transaction entry.

Key Columns

The view exposes fourteen columns, structured around a proposal key, a descriptive title, and a twelve-cell demographic matrix:

• PROPOSAL_ID (NUMBER, length 15) — the identifier of the proposal; the effective primary key of the view.
• STUDY_TITLE (VARCHAR2, length 240) — the study title associated with the proposal. This is the attribute most frequently searched for by report authors (the "study_title" search term).
• Female counts — AMERICAN_INDIAN_FEMALES, ASIAN_FEMALES, BLACK_FEMALES, HISPANIC_FEMALES, WHITE_FEMALES, and OTHER_FEMALES, each NUMBER, giving the number of female subjects per racial category.
• Male counts — AMERICAN_INDIAN_MALES, ASIAN_MALES, BLACK_MALES, HISPANIC_MALES, WHITE_MALES, and OTHER_MALES, each NUMBER, giving the number of male subjects per racial category.

Together the twelve demographic columns represent the standard NIH/agency race-and-gender reporting categories required for human subject inclusion reporting.

Common Use Cases and Queries

The view is most often used to (a) drive EDI flat-file generation for human subject data, (b) feed BI Publisher or Discoverer reports on subject demographics, and (c) provide ad-hoc extracts for inclusion enrollment reporting.

Retrieve all subject data for a proposal:

SELECT PROPOSAL_ID, STUDY_TITLE,
       AMERICAN_INDIAN_FEMALES, ASIAN_FEMALES, BLACK_FEMALES,
       HISPANIC_FEMALES, WHITE_FEMALES, OTHER_FEMALES,
       AMERICAN_INDIAN_MALES, ASIAN_MALES, BLACK_MALES,
       HISPANIC_MALES, WHITE_MALES, OTHER_MALES
FROM   APPS.IGW_PRPO_SUBJECT_INFO_V
WHERE  PROPOSAL_ID = :p_proposal_id;

Search by study title, the term the user entered:

SELECT PROPOSAL_ID, STUDY_TITLE
FROM   APPS.IGW_PRPO_SUBJECT_INFO_V
WHERE  UPPER(STUDY_TITLE) LIKE UPPER('%' || :search_term || '%');

Compute total subjects per proposal:

SELECT PROPOSAL_ID, STUDY_TITLE,
       (NVL(AMERICAN_INDIAN_FEMALES,0)+NVL(ASIAN_FEMALES,0)+NVL(BLACK_FEMALES,0)
      + NVL(HISPANIC_FEMALES,0)+NVL(WHITE_FEMALES,0)+NVL(OTHER_FEMALES,0)
      + NVL(AMERICAN_INDIAN_MALES,0)+NVL(ASIAN_MALES,0)+NVL(BLACK_MALES,0)
      + NVL(HISPANIC_MALES,0)+NVL(WHITE_MALES,0)+NVL(OTHER_MALES,0)) TOTAL_SUBJECTS
FROM   APPS.IGW_PRPO_SUBJECT_INFO_V;

Because the view is not referenced by other database objects, it can be modified or replaced without cascading impact; however, any concurrent program or report consuming its columns must be regression-tested after such changes.