eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: ORDDATA.ORDDCM_PROTOCOL_METADATA

Object Details

Object Name:	ORDDCM_PROTOCOL_METADATA
Object Type:	TABLE
Owner:	ORDDATA
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: ORDDCM_PROTOCOL_METADATA_PK

DOC_NAME
SOP_INSTANCE_UID

Indexes

Index	Type	Uniqueness	Tablespace	Column
ORDDCM_PROTOCOL_METADATA_PK	NORMAL	UNIQUE	SYSTEM	DOC_NAME SOP_INSTANCE_UID

Foreign Keys

Table		Foreign Table	Foreign Key Column
ORDDCM_PROTOCOL_METADATA		ORDDCM_DOCS	ORDDCM_PROTOCOL_METADATA DOC_NAME

Columns

Name	Datatype	Length	Mandatory
DOC_NAME	VARCHAR2	(100)	Yes
STUDY_UID	VARCHAR2	(128)	Yes
SERIES_UID	VARCHAR2	(128)	Yes
SOP_INSTANCE_UID	VARCHAR2	(128)	Yes
MODALITY	VARCHAR2	(2)	Yes
SOP_CLASS	VARCHAR2	(128)	Yes
AVAILABILITY	VARCHAR2	(8)	Yes

Query Text

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


SELECT DOC_NAME
,      STUDY_UID
,      SERIES_UID
,      SOP_INSTANCE_UID
,      MODALITY
,      SOP_CLASS
,      AVAILABILITY
FROM ORDDATA.ORDDCM_PROTOCOL_METADATA;

Dependencies

[top of page]

ORDDATA.ORDDCM_PROTOCOL_METADATA does not reference any database object

ORDDATA.ORDDCM_PROTOCOL_METADATA is not referenced by any database object