Pull Dicom Record tags from MosaiQ

[ghost]

I would like to pull Dicom record tags from MosaiQ. I saw the query you shared for pulling data from MosaiQ. I have no idea what host name is and how to access it. I would appreciate your assistance in retrieving data from MosaiQ

[SimonBiggs]

@dg1an3 or @mchamberland might either of you be in a position to help out here?

[sjswerdloff]

I would like to pull Dicom record tags from MosaiQ. I saw the query you shared for pulling data from MosaiQ. I have no idea what host name is and how to access it. I would appreciate your assistance in retrieving data from MosaiQ

Is there something in particular you are looking for?
Are there specific DICOM elements from a specific kind of DICOM Object (RT Plan? or literally DICOM RT (Ion) Beams Treatment Record ?)

[ghost]

We look for Dose Site Summary info(That displays all the info regarding prescription and delivery dose and fraction, start and end date of radiotherapy....) besides the TPS plan name and patient's date of birth. Besides, does Mosaiq provide DICOM RT format data?

…

On Tue, Dec 19, 2023 at 11:43 PM sjswerdloff ***@***.***> wrote: I would like to pull Dicom record tags from MosaiQ. I saw the query you shared for pulling data from MosaiQ. I have no idea what host name is and how to access it. I would appreciate your assistance in retrieving data from MosaiQ Is there something in particular you are looking for? Are there specific DICOM elements from a specific kind of DICOM Object (RT Plan? or literally DICOM RT (Ion) Beams Treatment Record ? — Reply to this email directly, view it on GitHub <#1814 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/BEMSMPUOFXU2P7MSANSHWSDYKJ3ILAVCNFSM6AAAAABADFJPSKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQNRTHA4DSNRQHA> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[sjswerdloff]

MOSAIQ is able to export DICOM data (including RT Plan).
The route is not obvious, but if you go to export images, and then use the advanced option... you'll see a few options for other kinds of data including RT Dose, RT Plan, RT SS (assuming those were transmitted to MOSAIQ).

Prescription information is primarily in the Site table.
History of delivery is mostly in the Dose_Hst table.
Patient demographics are in the Patient table, whose primary key is PAT_ID1, which is a foreign key in the other tables.
TPS Plan name is more complicated, it isn't directly stored (the Rx Site Name is a proxy for that but it is usually populated with the description of the dose reference that is of dose reference type TARGET and dose reference structure type SITE).
If your site doesn't delete "the rainbow icon", then the RT Plan is still stored (and you might be able to export that as mentioned above). The easier way to identify the plan is to find the fields (TxField table) that reference the Site, and each TxField record should contain a value in the OriginalPlanUID. SOP Instance UIDs are the appropriate way to uniquely identify a DICOM object, and the OriginalPlanUID is the SOP Instance UID of the plan that was used to populated the field (you'll find OriginalBeamName and OriginalBeamNumber there as well).
Assuming you are a clinical site, you should be able to view the schema (e.g. using Microsoft SQL Server Management Studio), and you might have the schema documentation as a set of linked HTML files.

[sjswerdloff]

You would need to talk to your administrator to get the hostname.
However, if you already have access to MOSAIQ as a user,
Help->About and then Alt-D (or maybe Ctrl-D?).
That will show you the server and the name of the database (typically "MOSAIQ").

Assuming you intend to access the database, you will need to get a set of credentials (username/password) from the administrator that give you read-only access.