Table Detail Report

IM_SERIES



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table contains series information for an imaging study.
Definition: IM Series
Table Type: ACTIVITY





Column Detail - IM_SERIES


Column Name Type Null? Definition
IM_MPPS_ID DOUBLE N This column contains a foreign key to the IM_MPPS table.
IM_SERIES_ID DOUBLE N This column contains a meaningless number that only serves to uniquely identify a row.
MODALITY VARCHAR(16) Y This column contains the modality as it was passed from the archive.
NBR_OF_IMAGES DOUBLE Y This column indicates the number of images that are a part of the series.
OPERATOR_NAME VARCHAR(64) Y Name of the operator who performed this series
OPERATOR_PRSNL_ID DOUBLE N Prsnl id (de-aliased version of operator name)
PERFORMING_PHYSICIAN_NAME VARCHAR(64) Y Name of the physician administering this series
PERFORMING_PHYSICIAN_PRSNL_ID DOUBLE N Prsnl ID (de-aliased version of performing physician name)
PROTOCOL_NAME VARCHAR(64) Y This column is only used for MPPS. It contains the protocol used.
RETRIEVE_AE_TITLE VARCHAR(16) Y This column is only used by MPPS
SERIES_NBR DOUBLE Y This column indicates the order of the series within the study.
SERIES_UID VARCHAR(64) N This column contains the Series UID that was assigned by the modality.
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.



Relationship Detail - IM_SERIES


Child Column in IM_SERIES(FK) Parent Table Name Parent Column Name
Parents: IM_MPPS_ID IM_MPPS IM_MPPS_ID




Parent Column in IM_SERIES (PK) Child Table Name Child Column Name
Children: IM_SERIES_ID IM_MATCH_EVENT IM_SERIES_ID
IM_U_NOTIFY IM_SERIES_ID


IM_STUDY



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table contains information relevant to the Imaging Study.
Definition: IM Study
Table Type: ACTIVITY





Column Detail - IM_STUDY


Column Name Type Null? Definition
CREATED_STUDY_UID VARCHAR(64) Y This column contains the study instance UID that was generated by RadNet.
IM_STUDY_ID DOUBLE N This is a meaningless number that only serves to uniquely identify a row.
ORIG_ENTITY_ID DOUBLE N ID for originating entity
ORIG_ENTITY_NAME VARCHAR(32) Y Name of originating entity
STUDY_STATE_CD DOUBLE N This column indicates the state of matching for the study.
STUDY_UID VARCHAR(64) N This column contains the Study Instance UID that can be used to identify the image in the archive.
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_STUDY




Parent Column in IM_STUDY (PK) Child Table Name Child Column Name
Children: IM_STUDY_ID IM_ACQUIRED_STUDY MATCHED_STUDY_ID
IM_MATCH_EVENT IM_STUDY_ID
IM_STUDY_LOCATION IM_STUDY_ID
IM_STUDY_PARENT_R IM_STUDY_ID
IM_U_NOTIFY IM_STUDY_ID
IM_U_NOTIFY REPLACED_IM_STUDY_ID


IM_STUDY_LOCATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table contains the current location of the study.
Definition: IM Study Location
Table Type: ACTIVITY





Column Detail - IM_STUDY_LOCATION


Column Name Type Null? Definition
IM_DEVICE_ID DOUBLE N This column contains a foreign key to the IM_DEVICE table. It identifies the location of the study.
IM_STUDY_ID DOUBLE N This column contains a foreign key to IM_STUDY 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_STUDY_LOCATION


Child Column in IM_STUDY_LOCATION(FK) Parent Table Name Parent Column Name
Parents: IM_DEVICE_ID IM_DEVICE IM_DEVICE_ID
IM_STUDY_ID IM_STUDY IM_STUDY_ID


IM_STUDY_PARENT_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: IM STUDY PARENT R
Definition: IM STUDY PARENT R
Table Type: ACTIVITY





Column Detail - IM_STUDY_PARENT_R


Column Name Type Null? Definition
IM_STUDY_ID DOUBLE N Foreign key to the im_study table
IM_STUDY_PARENT_ID DOUBLE N Primary key of im_study_parent_r
PARENT_ENTITY_ID DOUBLE N ID of the parent entity
PARENT_ENTITY_NAME VARCHAR(32) N Name of the parent entity
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_STUDY_PARENT_R


Child Column in IM_STUDY_PARENT_R(FK) Parent Table Name Parent Column Name
Parents: IM_STUDY_ID IM_STUDY IM_STUDY_ID


IM_U_NOTIFY



Column Section Relationship Section Top of Page


Table-level Detail

Description: IM U Notify
Definition: This table contains data that will be sent to the archive upon match/unmatch.
Table Type: ACTIVITY





Column Detail - IM_U_NOTIFY


Column Name Type Null? Definition
CQM_NBR_RETRIES DOUBLE N This column indicates the number of communication attempts made to the CQM server.
CQM_STATUS_CD DOUBLE N This column indicates the status of the CQM trigger. The CQM trigger will initiate a procedure update to be sent via HL7.
ENCNTR_ID DOUBLE N Foreign key to the ENCOUNTER table for the order.
IM_ACQUIRED_STUDY_ID DOUBLE N This column contains a foreign key to the IM_ACQUIRED_STUDY table.
IM_DEVICE_ID DOUBLE N Device id for the archive being updated.
IM_SERIES_ID DOUBLE N This column contains a foreign key to the IM_SERIES table.
IM_STUDY_ID DOUBLE N This column contains a foreign key to the IM_STUDY table.
IM_U_NOTIFY_ID DOUBLE N This column contains a meaningless number that only serves the purpose of uniquely identifying a row.
INSERT_DT_TM DATETIME Y This column contains the date/time that the IM_U_NOTIFY row was inserted.
NUMBER_OF_TRIES DOUBLE Y This column contains the number of communication attempts have been made with the archive.
PATIENT_IDENTIFIER VARCHAR(64) Y This column contains the patient's identifier that is known by the archive.
PATIENT_NAME VARCHAR(64) Y This column contains the patient name that the archive knows about.
PERSON_ID DOUBLE N Foreign key to the PERSON table for the row being processed.
REPLACED_IM_STUDY_ID DOUBLE N Identifies the IM_STUDY table foreign key to be used to replace the specified study specified
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.
U_NOTIFY_CD DOUBLE N This column indicates if this u-notify message is a match, unmatch or move series.
U_NOTIFY_STATUS_CD DOUBLE N This column indicates the status of the U-Notify message



Relationship Detail - IM_U_NOTIFY


Child Column in IM_U_NOTIFY(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
IM_ACQUIRED_STUDY_ID IM_ACQUIRED_STUDY IM_ACQUIRED_STUDY_ID
IM_DEVICE_ID IM_DEVICE IM_DEVICE_ID
IM_SERIES_ID IM_SERIES IM_SERIES_ID
IM_STUDY_ID IM_STUDY IM_STUDY_ID
REPLACED_IM_STUDY_ID IM_STUDY IM_STUDY_ID
PERSON_ID PERSON PERSON_ID