Search Results human_review_pending

Overview

IGW_SPECIAL_REVIEWS_V is a public Oracle EBS view owned by the APPS schema and registered under the FND Design Data identifier IGW.IGW_SPECIAL_REVIEWS_V. It exposes proposal-level information concerning the special reviews required for research involving human subjects and animal subjects. The view is classified as a public view, meaning it is intended for reuse in custom reporting, extracts, and integration scenarios rather than being restricted to internal application logic. In EBS 12.1.1 and 12.2.2, it is part of the Information Gateway (IGW) product family, which supports grants, proposals, and sponsored research administration.

The view consolidates descriptive and status attributes so that a single query can determine whether a proposal involves human or animal subjects, the current disposition of each review (pending, approved, or rejected), the review category (full or expedited), and the corresponding approval dates. Boolean-style indicators are encoded using the EBS convention in which a literal "X" signifies True and NULL signifies False.

Underlying Base Objects

The documented ETRM metadata for this view records the owner as APPS but does not enumerate the referenced base tables. This view is defined over the underlying IGW proposal and special review entities and is presented as a read-only reporting layer. Because the metadata does not document specific base objects, consumers should treat the view as the supported access path and avoid direct dependency on the underlying tables, whose join structure is not guaranteed across releases.

The column set, including PROPOSAL_ID, PROPOSAL_NUMBER, and the paired subject and review flag columns, confirms a denormalized projection in which review attributes from related records are folded onto the proposal grain. This design provides one row per proposal, with review details available without additional joins.

Key Columns

• PROPOSAL_ID (NUMBER 15) — The proposal identifier; the primary key for joining to other IGW proposal views and tables.
• PROPOSAL_NUMBER (VARCHAR2 30) — The user-facing proposal number.
• HUMAN_SUBJECTS_YES / HUMAN_SUBJECTS_NO — Flags ("X" or NULL) indicating whether the proposal does or does not involve human subjects.
• HUMAN_REVIEW_PENDING / APPROVED / REJECTED — The current human subjects review disposition.
• HUMAN_REVIEW_FULL / HUMAN_REVIEW_EXPEDITED — The review category assigned to the human subjects review.
• HUMAN_APPROVAL_DATE (DATE) — The date the human subjects review was approved.
• ANIMAL_SUBJECTS_YES / ANIMAL_SUBJECTS_NO — Flags indicating whether the proposal does or does not involve animal subjects.
• ANIMAL_REVIEW_PENDING / APPROVED / REJECTED — The current animal subjects review disposition.
• ANIMAL_REVIEW_FULL / ANIMAL_REVIEW_EXPEDITED — The review category assigned to the animal subjects review.
• ANIMAL_APPROVAL_DATE (DATE) — The date the animal subjects review was approved. This is the column sought by the search term "animal_approval_date."

Common Use Cases and Queries

Typical uses include identifying proposals with approved animal protocols, reporting approval dates for compliance tracking, and monitoring reviews that remain pending. The following query returns approved animal reviews and their approval dates:

• SELECT PROPOSAL_ID, PROPOSAL_NUMBER, ANIMAL_APPROVAL_DATE FROM APPS.IGW_SPECIAL_REVIEWS_V WHERE ANIMAL_REVIEW_APPROVED = 'X' ORDER BY ANIMAL_APPROVAL_DATE DESC;
• SELECT PROPOSAL_NUMBER, ANIMAL_REVIEW_PENDING FROM APPS.IGW_SPECIAL_REVIEWS_V WHERE ANIMAL_SUBJECTS_YES = 'X' AND ANIMAL_REVIEW_PENDING = 'X';
• SELECT PROPOSAL_NUMBER, HUMAN_APPROVAL_DATE, ANIMAL_APPROVAL_DATE FROM APPS.IGW_SPECIAL_REVIEWS_V WHERE HUMAN_APPROVAL_DATE IS NOT NULL OR ANIMAL_APPROVAL_DATE IS NOT NULL;

Because the "X"/NULL encoding is used throughout, conditions should test for the literal "X" rather than relying on a boolean datatype.