DBA Data[Home] [Help] [Dependency Information]

TABLE: IGW.IGW_STUDY_TITLES

Object Details
Object Name: IGW_STUDY_TITLES
Object Type: TABLE
Owner: IGW
FND Design Data: TableIGW.IGW_STUDY_TITLES
Subobject Name:
Status: VALID


IGW_STUDY_TITLES stores titles of studies conducted on subjects. A proposal can have multiple study titles.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGW_STUDY_TITLES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTUDY_TITLE_ID
Columns
Name Datatype Length Mandatory Comments
STUDY_TITLE_ID NUMBER (15) Yes Study title identifier
STUDY_TITLE VARCHAR2 (240)
Title of study conducted on a particular subject
PROPOSAL_ID NUMBER (15) Yes Proposal identifier
RECORD_VERSION_NUMBER NUMBER
Yes Locking sequence number
ENROLLMENT_STATUS VARCHAR2 (30) Yes Unique code that identifies whether the study involves targeted or included human subjects.Possible values are T - Targeted, I - Included
PROTOCOL_NUMBER VARCHAR2 (8)
Protocol Number
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT STUDY_TITLE_ID
,      STUDY_TITLE
,      PROPOSAL_ID
,      RECORD_VERSION_NUMBER
,      ENROLLMENT_STATUS
,      PROTOCOL_NUMBER
FROM IGW.IGW_STUDY_TITLES;

Dependencies

[top of page]

IGW.IGW_STUDY_TITLES does not reference any database object

IGW.IGW_STUDY_TITLES is referenced by following:

SchemaAPPS
SynonymIGW_STUDY_TITLES