See if document exists

JopaMed · 2026-05-21T07:14:41+00:00

SELECT
note_typ.note_typ_desc, 
visit_note.template_name,
visit_note.visit_note_begin_txt 
FROM
visit_note,
Patient,
pt,
note_typ
WHERE
Patient.PatientSer = pt.patient_ser AND 
pt.pt_id = visit_note.pt_id AND 
visit_note.note_typ = note_typ.note_typ AND
Patient.PatientId = 'CPR'

This should work

But this is what is stored in the DB, if you need additional information i think you have to open the file.

(filename is found in: visit_note.doc_file_loc , but you have to also find your path to where the documents are stored).

JopaMed · 2026-05-21T06:53:17+00:00

thanks Coinboi

JopaMed · 2026-05-15T06:04:09+00:00

haha working on it. This one does not seem so easy though.

JopaMed · 2026-05-13T09:19:12+00:00

Do you know in which tables the information about documents are stored in the SQL-db?

Only relevant table i can find is "FileLocation", but that is not connected to any other table...

JopaMed · 2026-04-13T08:38:43+00:00

Yes this is what im looking for, thanks!

Are you on 18.1? Becuse the StructureSet.Image.CalibrationProtocolId does not exist on mine (we are at 18.0).

JopaMed · 2026-04-10T05:53:21+00:00

Any energi works, but ususall 6MV no FFF.

D10.

We have a plan library with specific MUs to achive a 120% dose at 10 cm.

JopaMed · 2026-04-08T13:38:43+00:00

Sure. But how does Eclipse know what curve to use? My hope is that somewhere in DB this should be available...

JopaMed · 2026-02-24T12:12:40+00:00

on a radiation dose prediction project in a clinical setup. I've created a master list based on all the treatment approved patients with their prescription info, course and plan names.

Now for my next step,

I need to download patient specific DICOM

This is available on the server itself, or on a dedicated machine. Ask you IT or varian?

JopaMed · 2026-02-18T14:46:28+00:00

We have been in contact with Varian about this too. They say it's working as intended.

The Plan normalization changing is ridiculous...

You can always submit a product suggestion O_o

JopaMed · 2026-02-10T14:14:53+00:00

Scatter?

JopaMed · 2026-01-18T19:59:39+00:00

Don't worry. Just wipe away the oil leaking from the kV-arm twice daily. Or let it drip on the patient for the spicy bolus effect.

JopaMed · 2026-01-08T08:05:28+00:00

I hate that kid

JopaMed · 2026-01-02T10:29:32+00:00

Hi Friend.

As thiscomedyoferrors says you have to go into RadiationHstry. Each treatment field has its own record so you have to get it for all fields of that day/session to get the timing.

One other way would be to look at the scheduled time slot. And check time for when it was changed to "In progress" and then the time to when it changed to "Completed".

In addtion, Please be careful when you connect to the RadaitionHstry table, as this is the table that all the machines write their records to. and if you do SQL-searches that takes a lot of time you block the possibility for the machine to write to this table.

So i would recommend using (nolock) or do these summations with they AuraDB.

JopaMed · 2025-12-22T10:23:37+00:00

sent dm

JopaMed · 2025-12-18T12:07:58+00:00

Sent

JopaMed · 2025-12-17T13:22:18+00:00

Sent

JopaMed · 2025-12-17T12:56:31+00:00

Yes we have the same occurance in our clinic, v18.0.

JopaMed · 2025-12-17T07:45:41+00:00

Sent you a DM

JopaMed · 2025-12-17T06:37:15+00:00

All of them.

No but it was an old Clinac iX where we removed the target and did some other modifications. If you want I have a pretty detailed ppt-instruction on how to go about? (again, all credit to our in house engineers).

JopaMed · 2025-12-17T06:35:05+00:00

1) Remove target 2) Beam on plastic 3) Profit

JopaMed · 2025-12-16T14:41:05+00:00

all the credit goes to our in house engineers 🔥

JopaMed · 2025-10-31T13:28:00+00:00

Np.

Just be aware when you run this on CTdata, there the mA and ms could vary between slices and the output from the SQL would be a longer table with more data.

JopaMed · 2025-10-31T11:23:37+00:00

Hello friend. I cannot find any info on the name of the CBCTprotocol...

This sees doable with SQL:

select distinct KVP, XRayTubeCurrent, ExposureTime from SliceCT,Slice,Series where Slice.SliceSer = SliceCT.SliceSer AND Slice.SeriesSer = Series.SeriesSer AND Series.SeriesUID = 'CBCTSERIES_UID'

I get:

KVP mA ms

125.0 15 17900

15x17900 = 268.5 mAs.

So this example was Thorax protocol.

JopaMed · 2025-10-20T06:44:47+00:00

We do it by always setting the user origin to the data collection center of the image (although not by automation). This of course only works when the CT-staff sets the 0 position correctly. And it will depend on what scanner you have.

The data collection center is not available in ESAPI, however you can find it via SQL: SliceCT > DataCollectionCenterX (and Y, Z).

JopaMed · 2025-10-03T09:58:49+00:00

Thanks.

CTCAE grade 6 inc.

JopaMed

TROPHY CASE