[Home] [Help] [Dependency Information]

TABLE: ORDDATA.ORDDCM_CT_PRED_SET_WRK

Object Details

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: ORDDCM_CT_PS_W_PK

1. PSID

Unique Key: ORDDCM_CT_PS_W_UQ

1. NAME
2. PSTYPE
3. SUPER

Indexes

Index	Type	Uniqueness	Tablespace	Column
ORDDCM_CT_PS_W_PK	NORMAL	UNIQUE	SYSTEM	PSID
ORDDCM_CT_PS_W_UQ	NORMAL	UNIQUE	SYSTEM	NAME PSTYPE SUPER
ORDDCM_CT_PSW_DOCID_IDX	NORMAL	NONUNIQUE	SYSTEM	DOC_ID
ORDDCM_CT_PSW_NAME_IDX	NORMAL	NONUNIQUE	SYSTEM	NAME
ORDDCM_CT_PSW_PID_IDX	NORMAL	NONUNIQUE	SYSTEM	PID
ORDDCM_CT_PSW_SPR_IDX	NORMAL	NONUNIQUE	SYSTEM	SUPER
ORDDCM_CT_PSW_STATUS_IDX	NORMAL	NONUNIQUE	SYSTEM	STATUS
ORDDCM_CT_PSW_TYPE_IDX	NORMAL	NONUNIQUE	SYSTEM	PSTYPE

Foreign Keys

Table		Foreign Table	Foreign Key Column
ORDDCM_CT_PRED_SET_WRK		ORDDCM_CT_PRED_SET_WRK	ORDDCM_CT_PRED_SET_WRK SUPER
ORDDCM_CT_PRED_SET_WRK		ORDDCM_CT_PRED_WRK	ORDDCM_CT_PRED_SET_WRK PID
ORDDCM_CT_PRED_SET_WRK		ORDDCM_DOCS_WRK	ORDDCM_CT_PRED_SET_WRK DOC_ID
ORDDCM_CT_LOCATORPATHS_WRK		ORDDCM_CT_PRED_SET_WRK	ORDDCM_CT_LOCATORPATHS_WRK PSID
ORDDCM_CT_MACRO_DEP_WRK		ORDDCM_CT_PRED_SET_WRK	ORDDCM_CT_MACRO_DEP_WRK PSID
ORDDCM_CT_MACRO_DEP_WRK		ORDDCM_CT_PRED_SET_WRK	ORDDCM_CT_MACRO_DEP_WRK DEP_PSID
ORDDCM_CT_MACRO_PAR_WRK		ORDDCM_CT_PRED_SET_WRK	ORDDCM_CT_MACRO_PAR_WRK PSID
ORDDCM_CT_PRED_SET_WRK		ORDDCM_CT_PRED_SET_WRK	ORDDCM_CT_PRED_SET_WRK SUPER

Columns

Query Text

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

SELECT PSID
,      NAME
,      PSTYPE
,      PID
,      STATUS
,      SUPER
,      DOC_ID
,      DESCRIPTION
FROM ORDDATA.ORDDCM_CT_PRED_SET_WRK;

Dependencies

[top of page]

ORDDATA.ORDDCM_CT_PRED_SET_WRK does not reference any database object

ORDDATA.ORDDCM_CT_PRED_SET_WRK is referenced by following:

ORDSYS

ORD_DICOM_ADMIN_PRV - show dependent code

ORD_DICOM_CT - show dependent code