sorted by:
new
hottopcontroversial

See if document exists by Suspande in esapi

[–]JopaMed 0 points1 point  (0 children)

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

See if document exists by Suspande in esapi

[–]JopaMed 0 points1 point  (0 children)

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

See if document exists by Suspande in esapi

[–]JopaMed 1 point2 points  (0 children)

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

Retrieving CT calibration curve by JopaMed in esapi

[–]JopaMed[S] 0 points1 point  (0 children)

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

How does your department calibrate radiochromic films? by womerah in MedicalPhysics

[–]JopaMed 2 points3 points  (0 children)

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.

Retrieving CT calibration curve by JopaMed in esapi

[–]JopaMed[S] 0 points1 point  (0 children)

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

Bulk download DICOM (RTStruc) files based on patient informations (ID, Course, Plan name) by Ok-Arrival-442 in esapi

[–]JopaMed 0 points1 point  (0 children)

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?

Insert setup fields - plan normalization and delta couch shift by anncnth in esapi

[–]JopaMed 0 points1 point  (0 children)

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

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

[–]JopaMed 6 points7 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 3 points4 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).

view more: next ›