Table Detail Report

IM_IGNORE_DEFINITION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Image Management Ignore Definition
Definition: Contains Study Validation Ignore (previously called deny) tags and values.
Table Type: ACTIVITY





Column Detail - IM_IGNORE_DEFINITION


Column Name Type Null? Definition
IGNORE_TAG_TXT VARCHAR(11) N Foreign key to IMAGE_MATCH_TAG.tag
IM_IGNORE_DEFINITION_ID DOUBLE N Primary key to identify a row in this table.
TAG_VALUE_TXT VARCHAR(64) N Value used to identify study validation ignore data.
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_IGNORE_DEFINITION


Child Column in IM_IGNORE_DEFINITION(FK) Parent Table Name Parent Column Name
Parents: IGNORE_TAG_TXT IMAGE_MATCH_TAG TAG


IM_MATCH_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table contains a log of match and unmatch events that have occurred.
Definition: IM Match Event
Table Type: ACTIVITY





Column Detail - IM_MATCH_EVENT


Column Name Type Null? Definition
IM_ACQUIRED_STUDY_ID DOUBLE N This column contains a foreign key to the IM_ACQUIRED_STUDY table. It identifies the acquired study that has been matched / unmatched.
IM_MATCH_EVENT_ID DOUBLE N This column contains a meaningless number that only serves to uniquely identify a row.
IM_SERIES_ID DOUBLE N This column is a foreign key to the IM_SERIES table. It uniquely identifies the series.
IM_STUDY_ID DOUBLE N This column contains a foreign key to the IM_STUDY table. It identifies the study row that has been matched/unmatched.
MATCH_EVENT_CD DOUBLE N This column indicates what event took place. (match/unmatch)
MATCH_PRSNL_ID DOUBLE N This column contains a foreign key to the PRSNL table. It identifies the user that performed the match/unmatch if it was done manually.
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_MATCH_EVENT


Child Column in IM_MATCH_EVENT(FK) Parent Table Name Parent Column Name
Parents: IM_ACQUIRED_STUDY_ID IM_ACQUIRED_STUDY IM_ACQUIRED_STUDY_ID
IM_SERIES_ID IM_SERIES IM_SERIES_ID
IM_STUDY_ID IM_STUDY IM_STUDY_ID


IM_MPPS



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table contains the Modality Perform Procedure Step related data.
Definition: IM Modality Perform Procedure Step
Table Type: ACTIVITY





Column Detail - IM_MPPS


Column Name Type Null? Definition
DEVICE_ID DOUBLE N Modality Device Id
DISTANCE_SOURCE_TO_DETECTOR DOUBLE N Distance in MM from the source to detector center
IM_MPPS_ID DOUBLE N This column contains a meaningless number that only serves to uniquely identify a row.
LOCATION VARCHAR(16) Y This column contains the location as it was received from the archive.
MPPS_END_DT_TM DATETIME Y This column contains the date and time that the MPPS transaction ended.
MPPS_START_DT_TM DATETIME Y This column contains the date and time that the MPPS transaction started.
MPPS_STATUS_CD DOUBLE Y This column indicates the status of the MPPS transaction
MPPS_UID VARCHAR(64) Y This column contains the MPPS UID as received from the modality.
NBR_OF_SERIES DOUBLE Y This column indicates the number of series associated with this MPPS.
PARENT_ENTITY_ID DOUBLE N This column contains the primary key of the parent table. This column along with Parent_entity_name identifies the parent table and row.
PARENT_ENTITY_NAME VARCHAR(32) Y This column contains the name of the parent table. It along with Parent_entity_id identifies the parent table and row.
SCHEDULED_PROTOCOL_CD DOUBLE N The code value that represents the DTA of the step being performed
SCHEDULED_STEP_ID DOUBLE N Unique ID assigned to the scheduled step
STATION_AE_TITLE VARCHAR(16) Y This column indicates the AE Title of the station that the MPPS originated.
STATION_NAME VARCHAR(16) Y This column identifies the station name from which the MPPS originated.
TOTAL_NUMBER_OF_EXPOSURES DOUBLE N Total number of exposures column
TOTAL_TIME_OF_FLUOROSCOPY DOUBLE N Total duration of X-Ray exposure during fluoroscopy in seconds (pedal time)
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_MPPS




Parent Column in IM_MPPS (PK) Child Table Name Child Column Name
Children: IM_MPPS_ID IM_SERIES IM_MPPS_ID


IM_MWL_RULE



Column Section Top of Page


Table-level Detail

Description: im mwl rule
Definition: Contains information about the configuration rules that affect modality worklist server behavior.
Table Type: REFERENCE





Column Detail - IM_MWL_RULE


Column Name Type Null? Definition
ALT_PATIENT_ID_TYPE VARCHAR(16) N The field that determines which alternate patient id source should be used.
CONTRIBUTOR_SYS_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. Contributor system for the outbound alias.
FALLBACK_ID_TYPE VARCHAR(16) Y The field that determines which fallback id source should be used when primary id is unavailable.
GROUP_LEVEL VARCHAR(60) N Group level search logic when doing device specific query. Valid values are: SUBSECTION, SECTION, DEPARTMENT, INSTITUTION, and blank. Default is blank. Blank indicates no group level search logic will be used.
IM_MWL_RULE_ID DOUBLE N Unique identifier for this row
INCLUDE_INSTITUTION_IND DOUBLE N The field that determines whether or not institution is included in current patient location.
MWL_RULE_NAME VARCHAR(60) N Unique name of this MWL rule.
PATIENT_ID_ALIAS_POOL_CD DOUBLE N The field that determines the alias pool to use for formatting patient id.
PATIENT_ID_TYPE VARCHAR(16) N The field that determines which patient id source should be used.
RETURN_CODE_VALUE DOUBLE N Whether to send canonical value of the requested procedure code or display value. Valid values are: 1 - return canonical value. 0 - return display value. Default is 1.
RETURN_DEPT_DISPLAY DOUBLE N Whether to send display value of the code or department display name for RequestedProcedureId (0040, 1001) field. Valid values: 1 - return department display name; 0 - return display value of the code. Default is 0
RETURN_ONE_STEP_IND DOUBLE N This field determines whether or not all steps should be returned in MWL queries.
RETURN_REQDESC_FOR_SPSDESC DOUBLE N Whether to send RequestedProcedureDescription (0032, 1060) for the ScheduledStepDescription (0040,0007) instead of sending the step description as built in the database. Valid values: 1 - yes, 0 - No. Default is 0.
RETURN_REQUEST_AE DOUBLE N Always send AE title from the request SCU in the AE title field of the return modality worklist item. Valid values are: 1 - yes, 0 - no. Default is 0.
SEARCH_DAYS DOUBLE N Define the number of days the search will book back and forward from current day if the scheduled procedure start date is not given. Valid values are any integer value. Default is 5.
SUPPRESS_OPTIONAL_FIELDS_IND DOUBLE N Indicates whether optional MWL fields should be returned when not requested.
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.
USE_CONNECTION_AE DOUBLE N Whether to use AE title from the DICOM connection for query purpose if AE title is not specified in the query tags. Valid values are: 1 - use. 0 - no. Default is 0.


IM_NOT_VALIDATED_STUDY_FILTER



Column Section Top of Page


Table-level Detail

Description: Image Not-Validated Study Filter
Definition: This table contains a list of filters. Currently it contains institution names, station names, and modality types. Users will be able to select zero or more of these filters to save as preferences. The user's preferences will be used to build the not-validated studies list displayed in the Radiology Desktop worklist.
Table Type: ACTIVITY





Column Detail - IM_NOT_VALIDATED_STUDY_FILTER


Column Name Type Null? Definition
IM_FILTER_DATA VARCHAR(64) N This column contains the station name, modality, or institution as it was received from the archive.
IM_FILTER_ID DOUBLE N This column contains a unique meaningless number that only serves the purpose of uniquely identifying a row.
IM_FILTER_TYPE_CD DOUBLE N This column contains the code value to indicate if the row contains a station name, modality, or institution.
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.