Search Results igw_study_titles




Overview
Explore in AI Chat

Overview

IGW_STUDY_TITLES is a table within the Oracle E-Business Suite IGW (Grants Proposal) module, which is documented as obsolete in ETRM release 12.1.1 and 12.2.2. The table stores information on proposal titles, functioning as a descriptive repository for the titles assigned to grant proposals and related study or protocol records. Within the IGW schema, the table serves as a supporting detail structure that enriches proposal header records with human-readable title text and associated enrollment and protocol attributes.

The ETRM documentation explicitly states that IGW_STUDY_TITLES is not implemented in the reference database, which is consistent with its obsolete product classification. Consequently, the table should be treated as a historical schema artifact rather than an active transactional object in current EBS implementations. From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure is satellite-leaning. This suggests that IGW_STUDY_TITLES is best modeled as a satellite attached to the IGW_PROPOSALS_ALL hub, carrying descriptive and potentially volatile attributes such as title, enrollment status, and protocol number.

Key Information Stored

The table contains six documented columns. The surrogate primary key is STUDY_TITLE_ID, which is enforced by the IGW_STUDY_TITLES_PK constraint and is also the sole unique index candidate (IGW_STUDY_TITLES_U1). While this column uniquely identifies each title record, it is a system-generated identifier rather than a natural business key.

  • STUDY_TITLE_ID — surrogate primary key uniquely identifying each study title record.
  • STUDY_TITLE — the descriptive title text associated with the proposal or study.
  • PROPOSAL_ID — foreign key to IGW_PROPOSALS_ALL, linking the title to its parent proposal.
  • RECORD_VERSION_NUMBER — optimistic locking or versioning column used to detect concurrent updates.
  • ENROLLMENT_STATUS — status indicator describing enrollment state associated with the study title.
  • PROTOCOL_NUMBER — protocol identifier associated with the study or title record.

The foreign key relationship indicates that title records are subordinate to a single proposal, while IGW_SUBJECT_INFORMATION references STUDY_TITLE_ID, establishing the title as a parent for subject information rows.

Common Use Cases and Queries

Although the object is obsolete, historical reporting and data migration exercises may still require queries against IGW_STUDY_TITLES. A typical retrieval joins titles to their parent proposal:

SELECT t.STUDY_TITLE_ID, t.STUDY_TITLE, t.PROTOCOL_NUMBER, t.ENROLLMENT_STATUS
FROM IGW_STUDY_TITLES t, IGW_PROPOSALS_ALL p
WHERE t.PROPOSAL_ID = p.PROPOSAL_ID;

A second common pattern resolves the reverse relationship to subject information:

SELECT t.STUDY_TITLE, s.SUBJECT_ID
FROM IGW_STUDY_TITLES t, IGW_SUBJECT_INFORMATION s
WHERE s.STUDY_TITLE_ID = t.STUDY_TITLE_ID;

Reporting use cases include auditing proposal title inventories, reconciling enrollment status values against protocol numbers, and analyzing record version histories to detect repeated updates. Because the table is not implemented in current databases, these queries primarily support legacy data extraction, archival conversion, and upgrade impact assessments from older IGW installations.

Related Objects

The most significant related objects are those connected through the documented foreign key relationships and the IGW module's core proposal structures.

  • IGW_PROPOSALS_ALL — parent table referenced by IGW_STUDY_TITLES.PROPOSAL_ID; holds proposal header information.
  • IGW_SUBJECT_INFORMATION — child table referencing IGW_STUDY_TITLES.STUDY_TITLE_ID through the STUDY_TITLE_ID column.
  • IGW_STUDY_TITLES_PK — the primary key constraint enforcing uniqueness of STUDY_TITLE_ID.
  • IGW_STUDY_TITLES_U1 — the unique index on STUDY_TITLE_ID, serving as the business-key candidate.
  • IGW_PROPOSALS_ALL primary key — the parent-side key supporting the PROPOSAL_ID join.

Together these objects define the proposal-to-title-to-subject lineage within the obsolete IGW Grants Proposal schema.