Table Detail Report

DMS_VIEWER



Column Section Relationship Section Top of Page


Table-level Detail

Description: DMS Viewer
Definition: Used to maintain view/MIME type view associations along with launch and terminate instructions.
Table Type: REFERENCE





Column Detail - DMS_VIEWER


Column Name Type Null? Definition
CONTENT_TYPE_ID DOUBLE N Relates a view/mime association to a media content type. It is a foreign key back to the DMS_CONTENT_TYPE table.
DMS_MEDIA_INSTANCE_ID DOUBLE N Relates a view/mime association to media items in the Media Management archive. It is a foreign key back to the DMS_MEDIA_INSTANCE table.
DMS_VIEWER_ID DOUBLE N The unique primary key of this table. It is an internally generated value.
EXTENSION_TXT VARCHAR(32) Y The file name extension of the file that contains the viewer.
INSTANCE_LIMIT_NBR DOUBLE N The number of instances allowed. 1 - single instance <>1 - multiple instances allowed Eventually this will be the actual number of instances allowed with -1 indicating no limit.
MIME_TYPE_NAME VARCHAR(255) Y The name of the MIME type that the viewer is associated with.
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.
VIEWER_AUXILIARY_TXT VARCHAR(255) Y This field will contain supplementary information associated with the content type & mime type. For XML it will contain style for a default style sheet name.
VIEWER_NAME VARCHAR(255) N Either an executable file name or a cocreateinstance name for a view instance.
VIEWER_TYPE_FLAG DOUBLE N 0 - (default) DOS command line The type of viewer. 1 - cocreateinstance (pass file) 2 - Java plugin 3 - custom create (hard coded) 4 - cocreateinstance (pass id)



Relationship Detail - DMS_VIEWER


Child Column in DMS_VIEWER(FK) Parent Table Name Parent Column Name
Parents: CONTENT_TYPE_ID DMS_CONTENT_TYPE DMS_CONTENT_TYPE_ID
DMS_MEDIA_INSTANCE_ID DMS_MEDIA_INSTANCE DMS_MEDIA_INSTANCE_ID


IMAGE_MATCH_TAG



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table contains all DICOM tags that relate to Image Management
Definition: Image Match Tag
Table Type: REFERENCE





Column Detail - IMAGE_MATCH_TAG


Column Name Type Null? Definition
AUTO_MATCH_IND DOUBLE Y This column indicates if a specific DICOM tag is to be considered for Auto Matching.
AUTO_MATCH_REQ_IND DOUBLE Y This column indicates if the DICOM tag is required for Auto Matching.
DATA_TYPE VARCHAR(2) Y This column specifies the data type of the DICOM tag.
DESCRIPTION VARCHAR(64) N This column contains the description of the DICOM tag.
TAG VARCHAR(11) N This column contains the actual DICOM tag.
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.
UPD_IMAGE_HDR_IND DOUBLE Y This column indicates if the DICOM tag is to be considered for update of the image header.
UPD_IMAGE_HDR_REQ_IND DOUBLE Y This column indicates if the DICOM tag is required for update of the image header.
VALUE_MULTIPLICITY DOUBLE Y This column specifies if and how many occurrences of a specific DICOM tag is possible.



Relationship Detail - IMAGE_MATCH_TAG




Parent Column in IMAGE_MATCH_TAG (PK) Child Table Name Child Column Name
Children: TAG AUTO_MATCH_DEFINITION IMAGE_TAG
AUTO_MATCH_DEFINITION RIS_TAG
IM_IGNORE_DEFINITION IGNORE_TAG_TXT
UPD_IMAGE_HDR_DEF TAG


IM_ACQUIRED_STUDY



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table contains those studies that have been acquired from the modality.
Definition: Image Acquired Study
Table Type: ACTIVITY





Column Detail - IM_ACQUIRED_STUDY


Column Name Type Null? Definition
ACCESSION VARCHAR(16) Y The Accession field contains the accession number that this order was assigned to at order time.
ACQUIRED_DT_TM DATETIME Y This column indicates the date/time the study was acquired.
ACTIVE_DT_TM DATETIME Y Indicates the last time that the ACTIVE_IND was toggled.
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
ARCHIVE_TENANT_IDENTIFIER VARCHAR(64) N This column is used to indicated the source tenant for the study.
ASSIGNING_AUTHORITY VARCHAR(192) Y This column contains the assigning authority for the study.
BIRTH_DATE VARCHAR(16) Y This column contains the birth date as received from the modality/archive.
BIRTH_DATE_TZ DOUBLE Y This column contains the birthdate time zone as passed from the archive.
BIRTH_TIME VARCHAR(16) Y This column contains the birth time as received from the modality/archive.
ETHNIC_GROUP VARCHAR(16) Y This column contains the ethnic group as received from the modality/archive.
IM_ACQUIRED_STUDY_ID DOUBLE N This column contains a unique meaningless number that only serves the purpose of uniquely identifying a row.
IM_DEVICE_ID DOUBLE N This column contains a foreign key to the IM_DEVICE table. It identifies the archive that received the study.
INSTITUTION_NAME VARCHAR(64) Y This column contains the institution name as it was passed from the archive.
MANUFACTURER VARCHAR(64) Y This column contains the name of the modalities manufacturer as it was passed from the archive.
MATCHED_PERSON_IDENTIFIER VARCHAR(64) Y This column contains the MRN of the patient from the Cerner system that was sent to the archive upon matching the image.
MATCHED_PERSON_NAME VARCHAR(64) Y This column contains the patients name from the Cerner system that was sent to the archive upon matching the image.
MATCHED_STUDY_ID DOUBLE N This column contains a foreign key to the IM_STUDY table. It identifies the study/order that the acquired study has been matched with.
MODEL_NAME VARCHAR(64) Y This column contains the model name of the modality as it was passed from the archive.
PATIENT_IDENTIFIER VARCHAR(64) Y This column contains the patient identifier as it was passed in from the archive.
PATIENT_NAME VARCHAR(64) Y This column contains the patient name as it was passed from the archive.
REFERRING_PHYS_NAME VARCHAR(64) Y This column contains the referring physician's name as it was passed in from the archive.
REQUESTED_PROC_DESC VARCHAR(64) Y This column contains the requested procedure description as it was passed from the archive.
REQUESTED_PROC_IDENTIFIER VARCHAR(16) Y This column contains the requested procedure identifier as it was passed from the archive.
SENDING_DEVICE_ID DOUBLE N This column contains a foreign key to the IM_DEVICE table. It identifies the modality from which the study was acquired/sent.
SEX VARCHAR(16) Y This column contains the patients sex as it was passed from the archive.
STATION_NAME VARCHAR(16) Y This column contains the Station Name as it was passed from the archive.
STUDY_DATE VARCHAR(16) Y This column contains the date of the study as it was passed from the archive.
STUDY_DESCRIPTION VARCHAR(64) Y This column contains the study description as it was passed in by the archive.
STUDY_IDENTIFIER VARCHAR(16) Y This column contains the study identifier as it was passed in by the archive
STUDY_STATUS_IND DOUBLE N This column contains the study status of either active or idle.
STUDY_TIME VARCHAR(16) Y This column contains the time of the study as it was passed in by the archive.
STUDY_TZ DOUBLE Y This column contains the study time zone as passed from the archive.
STUDY_UID VARCHAR(64) Y This column contains the study instance UID that was passed in from the archive.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPLOAD_IND DOUBLE N This field will indicate whether the study was uploaded from a third party archive or not.



Relationship Detail - IM_ACQUIRED_STUDY


Child Column in IM_ACQUIRED_STUDY(FK) Parent Table Name Parent Column Name
Parents: IM_DEVICE_ID IM_DEVICE IM_DEVICE_ID
SENDING_DEVICE_ID IM_DEVICE IM_DEVICE_ID
MATCHED_STUDY_ID IM_STUDY IM_STUDY_ID




Parent Column in IM_ACQUIRED_STUDY (PK) Child Table Name Child Column Name
Children: IM_ACQUIRED_STUDY_ID IM_MATCH_EVENT IM_ACQUIRED_STUDY_ID
IM_U_NOTIFY IM_ACQUIRED_STUDY_ID


IM_CONFIGURATION



Column Section Top of Page


Table-level Detail

Description: IM Configuration
Definition: This table contains configuration settings specific to image management.
Table Type: REFERENCE





Column Detail - IM_CONFIGURATION


Column Name Type Null? Definition
CONFIGURATION_COMMENT VARCHAR(60) Y This column contains a comment that could be viewed by the user that further explains the purpose of the configuration.
IM_CONFIGURATION_ID DOUBLE N This column contains a unique meaningless number that only serves as a unique identifier for a row.
PARAMETER_NAME VARCHAR(40) N This column contains the name of the configuration parameter.
RESTRICTED_IND DOUBLE Y This column indicates if the configuration setting is to be seen by the user in the database tool.
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.
VALUE_CHAR VARCHAR(512) Y This column contains the character value of the configuration setting if the setting is of type character.
VALUE_DATE DATETIME Y This column contains the date value for the configuration setting if the setting is of type date.
VALUE_DESCRIPTION VARCHAR(60) Y This column contains the description of the configuration setting.
VALUE_NUMBER DOUBLE Y This column contains the number value if the configuration is of type number.


IM_DEVICE



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table contains DICOM and non-DICOM information about the device.
Definition: IM Device
Table Type: REFERENCE





Column Detail - IM_DEVICE


Column Name Type Null? Definition
AUTO_QC_IND DOUBLE Y This column indicates if the device/modality should support auto QC.
DEVICE_NAME VARCHAR(25) Y Unique name of device or display of a digital exam room
DEVICE_NAME_KEY VARCHAR(25) Y This is the device name in upper case. This is used for indexing and searching for a device based on device name.
DEVICE_NAME_KEY_A_NLS VARCHAR(100) Y DEVICE_NAME_KEY_A_NLS column
DEVICE_NAME_KEY_NLS VARCHAR(52) Y This is the device name in upper case for NLS sites. This is used for indexing and searching for a device based on device name.
IM_DEVICE_ID DOUBLE N This column contains a unique meaningless number that only serves the purpose of identifying a row.
IP_ADDRESS VARCHAR(64) Y This column contains the network IP address of the device.
MODEL_NAME VARCHAR(64) Y The model name.
MODEL_NAME_KEY VARCHAR(64) Y This is the model name in upper case. This is used for indexing and searching for a device based on model name.
MODEL_NAME_KEY_A_NLS VARCHAR(256) Y MODEL_NAME_KEY_A_NLS column
MODEL_NAME_KEY_NLS VARCHAR(130) Y This is the model name in upper case for NLS sites. This is used for indexing and searching for a device based on model name.
SERVICE_RESOURCE_CD DOUBLE N This column contains a foreign key to the Service Resource table. For radiology it would be at the exam room level.
TIMEZONE DOUBLE N Time zone for the device
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.
VENDOR_CD DOUBLE N This column identifies the vendor of the device.



Relationship Detail - IM_DEVICE


Child Column in IM_DEVICE(FK) Parent Table Name Parent Column Name
Parents: SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD




Parent Column in IM_DEVICE (PK) Child Table Name Child Column Name
Children: IM_DEVICE_ID AUTO_MATCH_DEFINITION IM_DEVICE_ID
IM_ACQUIRED_STUDY IM_DEVICE_ID
IM_ACQUIRED_STUDY SENDING_DEVICE_ID
IM_DEVICE_ACTIVITY IM_DEVICE_ID
IM_DEVICE_DISCIPLINE_R IM_DEVICE_ID
IM_DEVICE_MWL_RULE_R IM_DEVICE_ID
IM_DEVICE_ORG_R IM_DEVICE_ID
IM_DEVICE_RESOURCE_R IM_DEVICE_ID
IM_STUDY_LOCATION IM_DEVICE_ID
IM_U_NOTIFY IM_DEVICE_ID
UPD_IMAGE_HDR_DEF IM_DEVICE_ID