Table Detail Report

IM_DEVICE_ACTIVITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table contains information specific to the DICOM services supported.
Definition: IM Device Activity
Table Type: REFERENCE





Column Detail - IM_DEVICE_ACTIVITY


Column Name Type Null? Definition
AE_TITLE VARCHAR(16) Y This column contains the Application Entity Title for the specific DICOM service.
IM_ACTIVITY_CD DOUBLE N This column contains identifies the activity/service that is associated with a device.
IM_DEVICE_ID DOUBLE N This column contains a foreign key to the IM_DEVICE table. It indicates the device with which the activities are associated.
PORT DOUBLE Y This column identifies the network port used for this specific device/activity.
PRIMARY_IND DOUBLE Y This column indicates if this device is the primary device used for this activity.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - IM_DEVICE_ACTIVITY


Child Column in IM_DEVICE_ACTIVITY(FK) Parent Table Name Parent Column Name
Parents: IM_DEVICE_ID IM_DEVICE IM_DEVICE_ID


IM_DEVICE_DISCIPLINE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Imaging Device Discipline Relationship
Definition: The im_device_discipline_r table describes the discipline(s) for which a device is used. For example, a modality device may be used for radiology purposes only, or it may be used for both radiology and cardiology purposes.
Table Type: REFERENCE





Column Detail - IM_DEVICE_DISCIPLINE_R


Column Name Type Null? Definition
DISCIPLINE_CD DOUBLE N The discipline, such as radiology or cardiology, for which the associated device is used.
IM_DEVICE_ID DOUBLE N The device, such as a modality device, for which discipline is to be defined. Foreign key to im_device table.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - IM_DEVICE_DISCIPLINE_R


Child Column in IM_DEVICE_DISCIPLINE_R(FK) Parent Table Name Parent Column Name
Parents: IM_DEVICE_ID IM_DEVICE IM_DEVICE_ID


IM_DEVICE_MWL_RULE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Imaging Device MWL Rule Relationship
Definition: The im_device_mwl_rule_r table associates devices with mwl rules. A single device can only be associated with a single mwl rule, and a single mwl rule may be associated with multiple devices.
Table Type: REFERENCE





Column Detail - IM_DEVICE_MWL_RULE_R


Column Name Type Null? Definition
IM_DEVICE_ID DOUBLE N The device, such as a modality device, for which service resource is to be associated. Foreign key to im_device table.
IM_DEVICE_MWL_RULE_R_ID DOUBLE N IM DEVICE MWL RULE REALTION TABLE
IM_MWL_RULE_ID DOUBLE N The Modality Worklist Rule, for which device is to be associated. Foreign key to im_mwl_rule table
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - IM_DEVICE_MWL_RULE_R


Child Column in IM_DEVICE_MWL_RULE_R(FK) Parent Table Name Parent Column Name
Parents: IM_DEVICE_ID IM_DEVICE IM_DEVICE_ID


IM_DEVICE_ORG_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: IM Device Organization Relationship
Definition: A relationship table used to associate organizations with devices stored on the IM_Device table.
Table Type: REFERENCE





Column Detail - IM_DEVICE_ORG_R


Column Name Type Null? Definition
IM_DEVICE_ID DOUBLE N The primary key of the device the organization is related to.
IM_DEVICE_ORG_R_ID DOUBLE N The primary key of this table.
ORGANIZATION_ID DOUBLE N The primary key of the organization the device is related to.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - IM_DEVICE_ORG_R


Child Column in IM_DEVICE_ORG_R(FK) Parent Table Name Parent Column Name
Parents: IM_DEVICE_ID IM_DEVICE IM_DEVICE_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID


IM_DEVICE_RESOURCE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Imaging Device Service Resource Relationship
Definition: The im_device_resource_r table associates devices with service resources. A single device may be associated with multiple service resources, and a single service resource may be associated with multiple devices.
Table Type: REFERENCE





Column Detail - IM_DEVICE_RESOURCE_R


Column Name Type Null? Definition
IM_DEVICE_ID DOUBLE N The device, such as a modality device, for which service resource is to be associated. Foreign key to im_device table.
SERVICE_RESOURCE_CD DOUBLE N The service resource, such as the exam room, for which device is to be associated.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - IM_DEVICE_RESOURCE_R


Child Column in IM_DEVICE_RESOURCE_R(FK) Parent Table Name Parent Column Name
Parents: IM_DEVICE_ID IM_DEVICE IM_DEVICE_ID