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 |