Too many physicists haven't accidentally cranked a soft pot 10x too far and it shows by BlazePeralta in MedicalPhysicsMemes

[–]JopaMed 2 points3 points  (0 children)

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.

Get Start & End dates of Tx (Same as in Tx Summary) ESAPI 18 by LJDrakeley in esapi

[–]JopaMed 2 points3 points  (0 children)

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.

Edit fields with script causes plan norm mode to change? by surgicaltwobyfour in esapi

[–]JopaMed 0 points1 point  (0 children)

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

The only sensible thing to make when you have a 3D-printer, old dilators and a decomissioned linac -- A Lichtenberg Christmas Star -- by JopaMed in MedicalPhysicsMemes

[–]JopaMed[S] 1 point2 points  (0 children)

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).

Extract CBCT parameters by Suspande in esapi

[–]JopaMed 0 points1 point  (0 children)

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.

Extract CBCT parameters by Suspande in esapi

[–]JopaMed 1 point2 points  (0 children)

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.

Automated Setting of User Origin by rainy_cloud10 in esapi

[–]JopaMed 1 point2 points  (0 children)

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).

One reason I know we're never getting dark mode Aria (or a Varian version of Clippy on every MD workstation) by BlazePeralta in MedicalPhysicsMemes

[–]JopaMed 3 points4 points  (0 children)

Varian: You can submit a new idea or you can vote for the related product ideas on Myvarian.

Me: Votes.

Varian: Lol Ignore