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 |