I understand dangers of modifying tags without newuids. Using 1.4.16e and 1.4.16i to test. Trying to come up with some scripts that i can modify tags for when techs select the wrong patient for an exam so i can overwrite the study and not generate a new one. I would want to be able to overwrite tags such as PatientID, PatientDOB, ReferringPhysi, AccessionNum etc etc....is this script supposed to be able to accomplish this? I would be probably issuing commands from a php script or like. Also..what is the proper way to issue this command from web interface....i get a server returned 500 but it actually does process the command in the console...
http://127.0.0.1/cgi-bin/dgate…46475.7.1331292644.921.46 set PatientID to 1234567'
C:\dicomserver>dgate --modifystudy:123456,1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.46 set PatientID to 1234567
none of the tags ever gets changed?
no debug
[JHELENIAK] Connected by address: 0100007f
[JHELENIAK] Testing transfer: '1.2.840.10008.1.2' against list #0 = '1.2.840.10008.1.2'
[JHELENIAK] 0000,0002 18 UI AffectedSOPClassUID "1.2.840.10008.1.1"
[JHELENIAK] 0000,0100 2 US CommandField 48
[JHELENIAK] 0000,0110 2 US MessageID 1
[JHELENIAK] 0000,0800 2 US DataSetType 257
[JHELENIAK] 0002,0010 17 UI TransferSyntaxUID "1.2.840.10008.1.2"
[JHELENIAK] 9999,0300 42 LO ConquestConsoleText "Server command sent using DGATE -- option"
[JHELENIAK] 9999,0400 80 LO ConquestConsoleComma "modifystudy:123456,1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.46"
[JHELENIAK] Server command sent using DGATE -- option
[JHELENIAK] Query On Image
[JHELENIAK] Issue Query on Columns: DICOMImages.SOPInstanc, DICOMImages.ImageNumbe, DICOMImages.NumberOfFr, DICOMStudies.PatientID, DICOMStudies.StudyInsta,DICOMImages.ObjectFile,DICOMImages.DeviceName
[JHELENIAK] Values: DICOMStudies.PatientID = '123456' and DICOMStudies.StudyInsta = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.46' and DICOMSeries.StudyInsta = DICOMStudies.StudyInsta and DICOMImages.SeriesInst = DICOMSeries.SeriesInst
[JHELENIAK] Tables: DICOMImages, DICOMSeries, DICOMStudies
[JHELENIAK] Query Distinct Tables: DICOMImages, DICOMSeries, DICOMStudies
[JHELENIAK] Columns : DICOMImages.SOPInstanc, DICOMImages.ImageNumbe, DICOMImages.NumberOfFr, DICOMStudies.PatientID, DICOMStudies.StudyInsta,DICOMImages.ObjectFile,DICOMImages.DeviceName
[JHELENIAK] Where : DICOMStudies.PatientID = '123456' and DICOMStudies.StudyInsta = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.46' and DICOMSeries.StudyInsta = DICOMStudies.StudyInsta and DICOMImages.SeriesInst = DICOMSeries.SeriesInst
[JHELENIAK] Order : (null)
[JHELENIAK] Records = 2
[JHELENIAK] Locating file:MAG0 123456\1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47_0001_002000_1331292644000c.dcm
[JHELENIAK] Locating file:MAG0 123456\1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47_0001_003000_1331292644000d.dcm
with debug on
[JHELENIAK] Connected by address: 0100007f
[JHELENIAK] Testing transfer: '1.2.840.10008.1.2' against list #0 = '1.2.840.10008.1.2'
[JHELENIAK] 0000,0002 18 UI AffectedSOPClassUID "1.2.840.10008.1.1"
[JHELENIAK] 0000,0100 2 US CommandField 48
[JHELENIAK] 0000,0110 2 US MessageID 1
[JHELENIAK] 0000,0800 2 US DataSetType 257
[JHELENIAK] 0002,0010 17 UI TransferSyntaxUID "1.2.840.10008.1.2"
[JHELENIAK] 9999,0300 42 LO ConquestConsoleText "Server command sent using DGATE -- option"
[JHELENIAK] 9999,0400 108 LO ConquestConsoleComma "modifystudy:123456,1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.46,, set PatientID to 1234567"
[JHELENIAK] Server command sent using DGATE -- option
[JHELENIAK] Query On Image
[JHELENIAK] Issue Query on Columns: DICOMImages.SOPInstanc, DICOMImages.ImageNumbe, DICOMImages.NumberOfFr, DICOMStudies.PatientID, DICOMStudies.StudyInsta,DICOMImages.ObjectFile,DICOMImages.DeviceName
[JHELENIAK] Values: DICOMStudies.PatientID = '123456' and DICOMStudies.StudyInsta = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.46' and DICOMSeries.StudyInsta = DICOMStudies.StudyInsta and DICOMImages.SeriesInst = DICOMSeries.SeriesInst
[JHELENIAK] Tables: DICOMImages, DICOMSeries, DICOMStudies
[JHELENIAK] Query Distinct Tables: DICOMImages, DICOMSeries, DICOMStudies
[JHELENIAK] Columns : DICOMImages.SOPInstanc, DICOMImages.ImageNumbe, DICOMImages.NumberOfFr, DICOMStudies.PatientID, DICOMStudies.StudyInsta,DICOMImages.ObjectFile,DICOMImages.DeviceName
[JHELENIAK] Where : DICOMStudies.PatientID = '123456' and DICOMStudies.StudyInsta = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.46' and DICOMSeries.StudyInsta = DICOMStudies.StudyInsta and DICOMImages.SeriesInst = DICOMSeries.SeriesInst
[JHELENIAK] Order : (null)
[JHELENIAK] Records = 2
[JHELENIAK] Locating file:MAG0 123456\1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47_0001_002000_1331292644000c.dcm
[JHELENIAK] Locating file:MAG0 123456\1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47_0001_003000_1331292644000d.dcm
[JHELENIAK] *** Importconverter-1.0 error: , set PatientID to 1234567
[JHELENIAK] Deleting database entry for image: C:\dicomserver\Data\123456\1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47_0001_002000_1331292644000c.dcm
[JHELENIAK] Query On Image
[JHELENIAK] Issue Query on Columns: DICOMImages.SOPInstanc, DICOMSeries.SeriesInst, DICOMStudies.PatientID, DICOMStudies.StudyInsta
[JHELENIAK] Values: DICOMImages.SOPInstanc = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.906.44' and DICOMStudies.PatientID = '123456' and DICOMSeries.StudyInsta = DICOMStudies.StudyInsta and DICOMImages.SeriesInst = DICOMSeries.SeriesInst
[JHELENIAK] Tables: DICOMImages, DICOMSeries, DICOMStudies
[JHELENIAK] Query Distinct Tables: DICOMImages, DICOMSeries, DICOMStudies
[JHELENIAK] Columns : DICOMImages.SOPInstanc, DICOMSeries.SeriesInst, DICOMStudies.PatientID, DICOMStudies.StudyInsta
[JHELENIAK] Where : DICOMImages.SOPInstanc = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.906.44' and DICOMStudies.PatientID = '123456' and DICOMSeries.StudyInsta = DICOMStudies.StudyInsta and DICOMImages.SeriesInst = DICOMSeries.SeriesInst
[JHELENIAK] Order : (null)
[JHELENIAK] Records = 1
[JHELENIAK] RemoveFromPACS 1 image database entries
[JHELENIAK] Query Tables: DICOMImages
[JHELENIAK] Columns : ObjectFile, DeviceName
[JHELENIAK] Where : SOPInstanc = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.906.44' AND ImagePat = '123456'
[JHELENIAK] Order : (null)
[JHELENIAK] IOD File being removed: C:\dicomserver\Data\123456\1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47_0001_002000_1331292644000c.dcm
[JHELENIAK] Query Tables: DICOMImages
[JHELENIAK] Columns : DICOMImages.SopInstanc
[JHELENIAK] Where : DICOMImages.SopInstanc = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.906.44' and DICOMImages.SeriesInst = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47' and DICOMImages.ImagePat = '123456'
[JHELENIAK] Order : (null)
[JHELENIAK] Delete Record Table: DICOMImages
[JHELENIAK] Where : DICOMImages.SopInstanc = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.906.44' and DICOMImages.SeriesInst = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47' and DICOMImages.ImagePat = '123456'
[JHELENIAK] Query Tables: DICOMImages
[JHELENIAK] Columns : DICOMImages.SeriesInst
[JHELENIAK] Where : DICOMImages.SeriesInst = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47' and DICOMImages.ImagePat = '123456'
[JHELENIAK] Order : (null)
[JHELENIAK] Query Tables: DICOMSeries
[JHELENIAK] Columns : DICOMSeries.StudyInsta
[JHELENIAK] Where : DICOMSeries.StudyInsta = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.46' and DICOMSeries.SeriesPat = '123456'
[JHELENIAK] Order : (null)
[JHELENIAK] Query Tables: DICOMStudies
[JHELENIAK] Columns : DICOMStudies.PatientID
[JHELENIAK] Where : DICOMStudies.PatientID = '123456'
[JHELENIAK] Order : (null)
[JHELENIAK] Query Tables: DICOMImages
[JHELENIAK] Columns : ObjectFile, DeviceName
[JHELENIAK] Where : SOPInstanc = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.906.44' AND ImagePat = '123456'
[JHELENIAK] Order : (null)
[JHELENIAK] FreeStore Left 11239 on C:\
[JHELENIAK] Add to Table: DICOMImages
[JHELENIAK] Columns: SOPInstanc, SOPClassUI, ImageNumbe, ImageDate, ImageTime, AcqDate, AcqNumber, SliceLocat, SamplesPer, PhotoMetri, Rows, Colums, BitsStored, ImageType, ImagePat, SeriesInst, AccessTime, ObjectFile, DeviceName
[JHELENIAK] Values: '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.906.44', '1.2.840.10008.5.1.4.1.1.2', '2000', '19980414', '170346.000000', '19980414', ' 1', '-91.000000', '1', 'MONOCHROME2', '320', '320', '12', 'ORIGINAL\PRIMARY\AXIAL\NORMAL', '123456', '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47', 1331294880, '123456\1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47_0001_002000_13312948860000.dcm', 'MAG0'
[JHELENIAK] Query Tables: DICOMSeries
[JHELENIAK] Columns : SeriesInst,SeriesNumb,SeriesDate,SeriesTime,SeriesDesc,Modality,PatientPos,ContrastBo,Manufactur,ModelName,BodyPartEx,ProtocolNa,StationNam,Institutio,FrameOfRef,SeriesPat,StudyInsta
[JHELENIAK] Where : SeriesInst = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47' AND SeriesPat = '123456'
[JHELENIAK] Order : (null)
[JHELENIAK] Update Table: DICOMSeries
[JHELENIAK] Updates : SeriesInst = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47', SeriesNumb = ' 1', SeriesDate = '19980414', SeriesTime = '170346.000000', Modality = 'CT', PatientPos = 'HFS', ContrastBo = 'NONE', Manufactur = 'Philips Medical Systems', ModelName = 'AVE1', ProtocolNa = '1', Institutio = '', FrameOfRef = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.48', SeriesPat = '123456', StudyInsta = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.46', AccessTime = 1331294880
[JHELENIAK] Where : SeriesInst = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47' AND SeriesPat = '123456'
[JHELENIAK] Query Tables: DICOMStudies
[JHELENIAK] Columns : StudyInsta,StudyDate,StudyTime,StudyID,StudyDescr,AccessionN,ReferPhysi,PatientsAg,PatientsWe,StudyModal,PatientNam,PatientBir,PatientSex,PatientID
[JHELENIAK] Where : StudyInsta = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.46'
[JHELENIAK] Order : (null)
[JHELENIAK] Update Table: DICOMStudies
[JHELENIAK] Updates : StudyInsta = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.46', StudyDate = '19980414', StudyTime = '203538.960689', StudyID = '0009703828', StudyDescr = ' ', StudyModal = 'CT', PatientNam = 'HEAD EXP2', PatientSex = 'O', PatientID = '123456', AccessTime = 1331294880
[JHELENIAK] Where : StudyInsta = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.46'
[JHELENIAK] Query Tables: DICOMPatients
[JHELENIAK] Columns : PatientID,PatientNam,PatientBir,PatientSex
[JHELENIAK] Where : PatientID = '123456'
[JHELENIAK] Order : (null)
[JHELENIAK] Update Table: DICOMPatients
[JHELENIAK] Updates : PatientID = '123456', PatientNam = 'HEAD EXP2', PatientSex = 'O', AccessTime = 1331294880
[JHELENIAK] Where : PatientID = '123456'
[JHELENIAK] Modified image: C:\dicomserver\Data\123456\1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47_0001_002000_13312948860000.dcm
[JHELENIAK] Deleting file: C:\dicomserver\Data\123456\1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47_0001_002000_1331292644000c.dcm
[JHELENIAK] *** Importconverter-1.0 error: , set PatientID to 1234567
[JHELENIAK] Deleting database entry for image: C:\dicomserver\Data\123456\1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47_0001_003000_1331292644000d.dcm
[JHELENIAK] Query On Image
[JHELENIAK] Issue Query on Columns: DICOMImages.SOPInstanc, DICOMSeries.SeriesInst, DICOMStudies.PatientID, DICOMStudies.StudyInsta
[JHELENIAK] Values: DICOMImages.SOPInstanc = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.78.49' and DICOMStudies.PatientID = '123456' and DICOMSeries.StudyInsta = DICOMStudies.StudyInsta and DICOMImages.SeriesInst = DICOMSeries.SeriesInst
[JHELENIAK] Tables: DICOMImages, DICOMSeries, DICOMStudies
[JHELENIAK] Query Distinct Tables: DICOMImages, DICOMSeries, DICOMStudies
[JHELENIAK] Columns : DICOMImages.SOPInstanc, DICOMSeries.SeriesInst, DICOMStudies.PatientID, DICOMStudies.StudyInsta
[JHELENIAK] Where : DICOMImages.SOPInstanc = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.78.49' and DICOMStudies.PatientID = '123456' and DICOMSeries.StudyInsta = DICOMStudies.StudyInsta and DICOMImages.SeriesInst = DICOMSeries.SeriesInst
[JHELENIAK] Order : (null)
[JHELENIAK] Records = 1
[JHELENIAK] RemoveFromPACS 1 image database entries
[JHELENIAK] Query Tables: DICOMImages
[JHELENIAK] Columns : ObjectFile, DeviceName
[JHELENIAK] Where : SOPInstanc = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.78.49' AND ImagePat = '123456'
[JHELENIAK] Order : (null)
[JHELENIAK] IOD File being removed: C:\dicomserver\Data\123456\1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47_0001_003000_1331292644000d.dcm
[JHELENIAK] Query Tables: DICOMImages
[JHELENIAK] Columns : DICOMImages.SopInstanc
[JHELENIAK] Where : DICOMImages.SopInstanc = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.78.49' and DICOMImages.SeriesInst = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47' and DICOMImages.ImagePat = '123456'
[JHELENIAK] Order : (null)
[JHELENIAK] Delete Record Table: DICOMImages
[JHELENIAK] Where : DICOMImages.SopInstanc = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.78.49' and DICOMImages.SeriesInst = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47' and DICOMImages.ImagePat = '123456'
[JHELENIAK] Query Tables: DICOMImages
[JHELENIAK] Columns : ObjectFile, DeviceName
[JHELENIAK] Query Tables: DICOMSeries
[JHELENIAK] Columns : SeriesInst,SeriesNumb,SeriesDate,SeriesTime,SeriesDesc,Modality,PatientPos,ContrastBo,Manufactur,ModelName,BodyPartEx,ProtocolNa,StationNam,Institutio,FrameOfRef,SeriesPat,StudyInsta
[JHELENIAK] Query Tables: DICOMStudies
[JHELENIAK] Modified image: C:\dicomserver\Data\123456\1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47_0001_003000_13312948860001.dcm
[JHELENIAK] Connected by address: 0100007f
[JHELENIAK] Testing transfer: '1.2.840.10008.1.2' against list #0 = '1.2.840.10008.1.2'
[JHELENIAK] 0000,0002 18 UI AffectedSOPClassUID "1.2.840.10008.1.1"
[JHELENIAK] 0000,0100 2 US CommandField 48
[JHELENIAK] 0000,0110 2 US MessageID 7
[JHELENIAK] 0000,0800 2 US DataSetType 257
[JHELENIAK] 0002,0010 17 UI TransferSyntaxUID "1.2.840.10008.1.2"
[JHELENIAK] 9999,0300 34 LO ConquestConsoleText "db extract for GUI of patient dbf"
[JHELENIAK] 9999,0400 8 LO ConquestConsoleComma "extract:"
[JHELENIAK] db extract for GUI of patient dbf
[JHELENIAK] Create Table: XADICOMPatients
[JHELENIAK] Columns : PatientID varchar(64), PatientNam varchar(64), PatientBir char(8) , PatientSex varchar(16), AccessTime int, qTimeStamp int, qFlags int, qSpare varchar(64)
[JHELENIAK] Query Tables: DICOMPatients
[JHELENIAK] Columns : PatientID, PatientNam, PatientBir, PatientSex, AccessTime, qTimeStamp, qFlags, qSpare
[JHELENIAK] Where : (null)
[JHELENIAK] Order : (null)
[JHELENIAK] Add to Table: XADICOMPatients
[JHELENIAK] Columns: PatientID, PatientNam, PatientBir, PatientSex, AccessTime, qTimeStamp, qFlags, qSpare
[JHELENIAK] Values: '123456', 'HEAD EXP2', '', 'O', '1331294880', '', '', ''
[JHELENIAK] Connected by address: 0100007f
[JHELENIAK] Testing transfer: '1.2.840.10008.1.2' against list #0 = '1.2.840.10008.1.2'
[JHELENIAK] 0000,0002 18 UI AffectedSOPClassUID "1.2.840.10008.1.1"
[JHELENIAK] 0000,0100 2 US CommandField 48
[JHELENIAK] 0000,0110 2 US MessageID 7
[JHELENIAK] 0000,0800 2 US DataSetType 257
[JHELENIAK] 0002,0010 17 UI TransferSyntaxUID "1.2.840.10008.1.2"
[JHELENIAK] 9999,0300 38 LO ConquestConsoleText "db extract for GUI of patient: 123456"
[JHELENIAK] 9999,0400 28 LO ConquestConsoleComma "extract:PatientID = '123456'"
[JHELENIAK] db extract for GUI of patient: 123456
[JHELENIAK] Create Table: XADICOMPatients
[JHELENIAK] Columns : PatientID varchar(64), PatientNam varchar(64), PatientBir char(8) , PatientSex varchar(16), AccessTime int, qTimeStamp int, qFlags int, qSpare varchar(64)
[JHELENIAK] Query Tables: DICOMPatients
[JHELENIAK] Columns : PatientID, PatientNam, PatientBir, PatientSex, AccessTime, qTimeStamp, qFlags, qSpare
[JHELENIAK] Where : (null)
[JHELENIAK] Order : (null)
[JHELENIAK] Add to Table: XADICOMPatients
[JHELENIAK] Columns: PatientID, PatientNam, PatientBir, PatientSex, AccessTime, qTimeStamp, qFlags, qSpare
[JHELENIAK] Values: '123456', 'HEAD EXP2', '', 'O', '1331294880', '', '', ''
[JHELENIAK] Create Table: XDICOMPatients
[JHELENIAK] Columns : PatientID varchar(64), PatientNam varchar(64), PatientBir char(8) , PatientSex varchar(16), AccessTime int, qTimeStamp int, qFlags int, qSpare varchar(64)
[JHELENIAK] Query Tables: DICOMPatients
[JHELENIAK] Columns : PatientID, PatientNam, PatientBir, PatientSex, AccessTime, qTimeStamp, qFlags, qSpare
[JHELENIAK] Where : PatientID = '123456'
[JHELENIAK] Order : (null)
[JHELENIAK] Add to Table: XDICOMPatients
[JHELENIAK] Columns: PatientID, PatientNam, PatientBir, PatientSex, AccessTime, qTimeStamp, qFlags, qSpare
[JHELENIAK] Values: '123456', 'HEAD EXP2', '', 'O', '1331294880', '', '', ''
[JHELENIAK] Create Table: XDICOMStudies
[JHELENIAK] Columns : StudyInsta varchar(64), StudyDate char(8) , StudyTime varchar(16), StudyID varchar(16), StudyDescr varchar(64), AccessionN varchar(16), ReferPhysi varchar(64), PatientsAg varchar(16), PatientsWe varchar(16), StudyModal varchar(64), PatientNam varchar(64), PatientBir char(8) , PatientSex varchar(16), PatientID varchar(64), AccessTime int, qTimeStamp int, qFlags int, qSpare varchar(64)
[JHELENIAK] Query Tables: DICOMStudies
[JHELENIAK] Columns : StudyInsta, StudyDate, StudyTime, StudyID, StudyDescr, AccessionN, ReferPhysi, PatientsAg, PatientsWe, StudyModal, PatientNam, PatientBir, PatientSex, PatientID, AccessTime, qTimeStamp, qFlags, qSpare
[JHELENIAK] Where : PatientID = '123456'
[JHELENIAK] Order : (null)
[JHELENIAK] Add to Table: XDICOMStudies
[JHELENIAK] Columns: StudyInsta, StudyDate, StudyTime, StudyID, StudyDescr, AccessionN, ReferPhysi, PatientsAg, PatientsWe, StudyModal, PatientNam, PatientBir, PatientSex, PatientID, AccessTime, qTimeStamp, qFlags, qSpare
[JHELENIAK] Values: '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.46', '19980414', '203538.960689', '0009703828', ' ', '', '', '', '', 'CT', 'HEAD EXP2', '', 'O', '123456', '1331294880', '', '', ''
[JHELENIAK] Create Table: XDICOMSeries
[JHELENIAK] Columns : SeriesInst varchar(64), SeriesNumb varchar(12), SeriesDate char(8) , SeriesTime varchar(16), SeriesDesc varchar(64), Modality varchar(16), PatientPos varchar(16), ContrastBo varchar(64), Manufactur varchar(64), ModelName varchar(64), BodyPartEx varchar(64), ProtocolNa varchar(64), StationNam varchar(16), Institutio varchar(64), FrameOfRef varchar(64), SeriesPat varchar(64), StudyInsta varchar(64), AccessTime int, qTimeStamp int, qFlags int, qSpare varchar(64)
[JHELENIAK] Query Tables: DICOMSeries
[JHELENIAK] Columns : SeriesInst, SeriesNumb, SeriesDate, SeriesTime, SeriesDesc, Modality, PatientPos, ContrastBo, Manufactur, ModelName, BodyPartEx, ProtocolNa, StationNam, Institutio, FrameOfRef, SeriesPat, StudyInsta, AccessTime, qTimeStamp, qFlags, qSpare
[JHELENIAK] Where : SeriesPat = '123456'
[JHELENIAK] Order : (null)
[JHELENIAK] Add to Table: XDICOMSeries
[JHELENIAK] Columns: SeriesInst, SeriesNumb, SeriesDate, SeriesTime, SeriesDesc, Modality, PatientPos, ContrastBo, Manufactur, ModelName, BodyPartEx, ProtocolNa, StationNam, Institutio, FrameOfRef, SeriesPat, StudyInsta, AccessTime, qTimeStamp, qFlags, qSpare
[JHELENIAK] Values: '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47', ' 1', '19980414', '170346.000000', '', 'CT', 'HFS', 'NONE', 'Philips Medical Systems', 'AVE1', '', '1', '', '', '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.48', '123456', '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.46', '1331294880', '', '', ''
[JHELENIAK] Create Table: XDICOMImages
[JHELENIAK] Columns : SOPInstanc varchar(64), SOPClassUI varchar(64), ImageNumbe varchar(12), ImageDate char(8) , ImageTime varchar(16), EchoNumber varchar(64), NumberOfFr varchar(12), AcqDate char(8) , AcqTime varchar(16), ReceivingC varchar(16), AcqNumber varchar(12), SliceLocat varchar(16), SamplesPer varchar(5), PhotoMetri varchar(16), Rows varchar(5), Colums varchar(5), BitsStored varchar(5), ImageType varchar(128), ImageID varchar(16), ImagePat varchar(64), SeriesInst varchar(64), AccessTime int, qTimeStamp int, qFlags int, qSpare varchar(64), ObjectFile varchar(255), DeviceName varchar(32)
[JHELENIAK] Query Tables: DICOMImages
[JHELENIAK] Columns : SOPInstanc, SOPClassUI, ImageNumbe, ImageDate, ImageTime, EchoNumber, NumberOfFr, AcqDate, AcqTime, ReceivingC, AcqNumber, SliceLocat, SamplesPer, PhotoMetri, Rows, Colums, BitsStored, ImageType, ImageID, ImagePat, SeriesInst, AccessTime, qTimeStamp, qFlags, qSpare, ObjectFile, DeviceName
[JHELENIAK] Where : ImagePat = '123456'
[JHELENIAK] Order : (null)
[JHELENIAK] Add to Table: XDICOMImages
[JHELENIAK] Columns: SOPInstanc, SOPClassUI, ImageNumbe, ImageDate, ImageTime, EchoNumber, NumberOfFr, AcqDate, AcqTime, ReceivingC, AcqNumber, SliceLocat, SamplesPer, PhotoMetri, Rows, Colums, BitsStored, ImageType, ImageID, ImagePat, SeriesInst, AccessTime, qTimeStamp, qFlags, qSpare, ObjectFile, DeviceName
[JHELENIAK] Values: '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.906.44', '1.2.840.10008.5.1.4.1.1.2', '2000', '19980414', '170346.000000', '', '', '19980414', '', '', ' 1', '-91.000000', '1', 'MONOCHROME2', '320', '320', '12', 'ORIGINAL\PRIMARY\AXIAL\NORMAL', '', '123456', '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47', '1331294880', '', '', '', '123456\1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47_0001_002000_13312948860000.dcm', 'MAG0'
[JHELENIAK] Add to Table: XDICOMImages