How to query/retrieve series date?

[jazb83]

If a patient is approved to follow a radiotherapy treatment, the treatment is split in different sessions. Every session of radiotherapy is given in a different day (i.e. date), and every session will generate a different serie of images (i.e. image modality RTIMAGE).

e.g. Patient X was approved for a radiotherapy planning and the radiation dose will be given in 3 sessions. So, we will have the following series of images:

Session 1: Serie1; 10 RTIMAGES; Date1. (oldest)
Session 2: Serie2; 10 RTIMAGES; Date2. (old)
Session 3: Serie3; 10 RTIMAGES; Date3. (newest)

Every Serie is composed of 10 RTIMAGES acquired at date X.

My problem:
I need to pull only the series with a specific date (e.g. Date 3), and not the whole bunch of series every time that a new radiotherapy sessions is given to the patient.
So far, I am able to pull all the series of images related to one patient using EvilDICOM , DCMTK or DICOMan. This is great if the patient has already finished treatment, but if the patient is ongoing a radiotherapy treatment I cannot just pull the newest series (e.g. Serie3 Date 3). I have to pull everything again to get the newest series.

The big question: is it possible to query series date from the Aria database using the Varian DB service on any level (i.e. Study/ Serie / Image)?

Difficulties:

1. According to the DICOM standard normative : Query/Retrieve Service Class C.6.1.1.4 Series level defines the key at the series information level that we can Query/Retrieve for:

Attribute Name Tag Type
Modality (0008,0060) R
Series Number (0020,0011) R
Series Instance UID (0020,000E) U
Number of Series Related Instances (0020,1209) O
All Other Attributes at Series Level O:
RTIMAGE
RTSeries
Series Date (0008,0021) (ref: https://dicom.innolitics.com/ciods/rt-image)

It should be possible to query for the series dates, but it is also truth that some keys are not always available. So, I don’t know if this is the case for Varian.

I read “The Varian System Server V15.5 DICOM Conformance Statement” and the only supported keys on series level are Series Instance UID, Modality, Series Number and Series Description (Table 2-50, 70 pag.). It seems that it is not supported, but I want to double-check.

2. The series date tag is not available in the headers of “RTIMAGE”. It is for example available on CT headers but it is missing on “RTIMAGE”.

Thank you for your help,
Jorge

----------------RTIMAGE HEADER EXAMPLE -----------------------

(0002,0010) Transfer Syntax UID VR: UI Length: 18 Value: 1.2.840.10008.1.2
(0008,0005) Specific Character Set VR: CS Length: 10 Value: ISO_IR 192
(0008,0008) Image Type VR: CS Length: 38 Value: ORIGINAL\PRIMARY\PORTAL\ACQUIRED_DOSE
(0008,0012) Instance Creation Date VR: DA Length: 8 Value: 20190109
(0008,0013) Instance Creation Time VR: TM Length: 14 Value: 101449.000000
(0008,0016) SOP Class UID VR: UI Length: 30 Value: 1.2.840.XXXXX.5.1.4.1.1.XXXX.1
(0008,0018) SOP Instance UID VR: UI Length: 58 Value: 1.2.246.352.62.1.XXXX57728163800XXXX.XXXX111166213709XXXX
(0008,0020) Study Date VR: DA Length: 8 Value: 20171006
(0008,0022) Acquisition Date VR: DA Length: 8 Value: 20171025
(0008,0023) Image Date VR: DA Length: 8 Value: 20171025
(0008,0030) Study Time VR: TM Length: 14 Value: 110912.000000
(0008,0032) Acquisition Time VR: TM Length: 14 Value: 114107.643000
(0008,0033) Image Time VR: TM Length: 14 Value: 114107.643000
(0008,0050) Accession Number VR: SH Length: 0
(0008,0052) Query/Retrieve Level VR: CS Length: 6 Value: IMAGE
(0008,0054) Retrieve AE Title VR: AE Length: 6 Value: VMSDBD
(0008,0060) Modality VR: CS Length: 8 Value: RTIMAGE
(0008,0064) Conversion Type VR: CS Length: 2 Value: DI
(0008,0070) Manufacturer VR: LO Length: 22 Value: Varian Medical Systems
(0008,0090) Referring Physician's Name VR: PN Length: 2 Value: Jorge
(0008,1010) Station Name VR: SH Length: 10 Value: Jorge
(0008,1030) Study Description VR: LO Length: 8 Value: PROSTATE
(0008,1048) Physician(s) of Record VR: PN Length: 10 Value: Jorge
(0008,1070) Operators' Name VR: PN Length: 6 Value: Jorge
(0008,1090) Manufacturer's Model Name VR: LO Length: 10 Value: RDS - PVA
(0008,3010) Irradiation Event UID VR: UI Length: 58 Value: 1.2.246.352.62.30.5598275662951412257.7291058207840952983
(0010,0010) Patient's Name VR: PN Length: 20 Value: Jorge Smith
(0010,0020) Patient ID VR: LO Length: 8 Value: XXXXXX
(0010,0030) Patient's Birth Date VR: DA Length: 8 Value: XXXXXX
(0010,0032) Patient's Birth Time VR: TM Length: 14 Value: 000000.000000
(0010,0040) Patient's Sex VR: CS Length: 2 Value: X
(0018,1000) Device Serial Number VR: LO Length: 4 Value: XXX
(0018,1020) Software Version(s) VR: LO Length: 8 Value: 2.7.48.0
(0018,5100) Patient Position VR: CS Length: 4 Value: HFS
(0020,000D) Study Instance UID VR: UI Length: 52 Value: 1.2.840.113619.2.XXXX.3.34XXXX037.XXXX.1507XXXX17.374
(0020,000E) Series Instance UID VR: UI Length: 56 Value: 1.2.246.352.62.2.554944291XXXX761755.8762XXXX50811XXXX40
(0020,0010) Study ID VR: SH Length: 4 Value: XXXX
(0020,0011) Series Number VR: IS Length: 2 Value: 6
(0020,0013) Image Number VR: IS Length: 2 Value: 4
(0020,0020) Patient Orientation VR: CS Length: 0
(0020,0052) Frame of Reference UID VR: UI Length: 58 Value: 1.2.246.352.62.3.4750470XXXX12464077.180549XXXX976124824
(0020,1040) Position Reference Indicator VR: LO Length: 0
(0028,0002) Samples per Pixel VR: US Length: 2 Value: 1
(0028,0004) Photometric Interpretation VR: CS Length: 12 Value: MONOCHROME2
(0028,0010) Rows VR: US Length: 2 Value: 1280
(0028,0011) Columns VR: US Length: 2 Value: 1280
(0028,0100) Bits Allocated VR: US Length: 2 Value: 16
(0028,0101) Bits Stored VR: US Length: 2 Value: 16
(0028,0102) High Bit VR: US Length: 2 Value: 15
(0028,0103) Pixel Representation VR: US Length: 2 Value: 0
(0028,1040) Pixel Intensity Relationship VR: CS Length: 4 Value: LIN
(0028,1041) Pixel Intensity Relationship Sign VR: SS Length: 2 Value: 1
(0028,1050) Window Center VR: DS Length: 16 Value: 0.0438953197386
(0028,1051) Window Width VR: DS Length: 16 Value: 0.0867601780907
(0028,1052) Rescale Intercept VR: DS Length: 2 Value: 0
(0028,1053) Rescale Slope VR: DS Length: 16 Value: 1.4595770346E-06
(0028,1054) Rescale Type VR: LO Length: 2 Value: CU
(3002,0002) RT Image Label VR: SH Length: 10 Value: MV_265_2a
(3002,0004) RT Image Description VR: ST Length: 270 Value: (Long Size Data)
(3002,000A) Reported Values Origin VR: CS Length: 6 Value: ACTUAL
(3002,000C) RT Image Plane VR: CS Length: 6 Value: NORMAL
(3002,000D) VR: DS Length: 36 Value: -0.179169021657\0.0777708091799-540
(3002,000E) X-Ray Image Receptor Angle VR: DS Length: 2 Value: 0
(3002,0010) RT Image Orientation VR: DS Length: 12 Value: 1\0\0\0-1\0
(3002,0011) Image Plane Pixel Spacing VR: DS Length: 12 Value: 0.336\0.336
(3002,0012) RT Image Position VR: DS Length: 16 Value: -214.872\214.872
(3002,0020) Radiation Machine Name VR: SH Length: 10 Value: TPHal1004
(3002,0022) Radiation Machine SAD VR: DS Length: 4 Value: 1000
(3002,0026) RT Image SID VR: DS Length: 4 Value: 1540
(3002,0029) Fraction Number VR: IS Length: 2 Value: 2
(3002,0030) Exposure Sequence VR: SQ Length: 284
(FFFE,E000)
(0008,1160) Referenced Frame Number VR: IS Length: 2 Value: 1
(0018,0060) KVP VR: DS Length: 4 Value: 6000
(0018,1150) Exposure Time VR: IS Length: 4 Value: 8830
(3002,0032) Meterset Exposure VR: DS Length: 14 Value: 106.642045392
(300A,00B6) Beam Limiting Device Sequence VR: SQ Length: 88
(FFFE,E000)
(300A,00B8) RT Beam Limiting Device Type VR: CS Length: 2 Value: X
(300A,00BC) Number of Leaf/Jaw Pairs VR: IS Length: 2 Value: 1
(300A,011C) Leaf/Jaw Positions VR: DS Length: 8 Value: -140\140
(FFFE,E000)
(300A,00B8) RT Beam Limiting Device Type VR: CS Length: 2 Value: Y
(300A,00BC) Number of Leaf/Jaw Pairs VR: IS Length: 2 Value: 1
(300A,011C) Leaf/Jaw Positions VR: DS Length: 8 Value: -140\140
(300A,00F0) Number of Blocks VR: IS Length: 2 Value: 0
(300A,011E) Gantry Angle VR: DS Length: 14 Value: 265.000500552
(300A,0120) Beam Limiting Device Angle VR: DS Length: 14 Value: 34.9997446902
(300A,0122) Patient Support Angle VR: DS Length: 2 Value: 0
(300A,0128) Table Top Vertical Position VR: DS Length: 8 Value: -114.41
(300A,0129) Table Top Longitudinal Position VR: DS Length: 14 Value: 2140.85991027
(300A,012A) Table Top Lateral Position VR: DS Length: 14 Value: 16.8171717172
(300A,00B3) Primary Dosimeter Unit VR: CS Length: 2 Value: MU
(300A,011E) Gantry Angle VR: DS Length: 14 Value: 265.000500552
(300A,0120) Beam Limiting Device Angle VR: DS Length: 14 Value: 34.9997446902
(300A,0122) Patient Support Angle VR: DS Length: 2 Value: 0
(300A,0128) Table Top Vertical Position VR: DS Length: 8 Value: -114.41
(300A,0129) Table Top Longitudinal Position VR: DS Length: 14 Value: 2140.85991027
(300A,012A) Table Top Lateral Position VR: DS Length: 14 Value: 16.8171717172
(300A,012C) Isocenter Position VR: DS Length: 6 Value: 0\0\0
(300C,0002) Referenced RT Plan Sequence VR: SQ Length: 96
(FFFE,E000)
(0008,1150) Referenced SOP Class UID VR: UI Length: 20 Value: 1.2.246.352.70.1.70
(0008,1155) Referenced SOP Instance UID VR: UI Length: 52 Value: 1.2.246.352.71.5.568872780110.1299301.20171019094246
(300C,0006) Referenced Beam Number VR: IS Length: 2 Value: 8
(300C,0008) Start Cumulative Meterset Weight VR: DS Length: 14 Value: 1.53329580874
(300C,0009) End Cumulative Meterset Weight VR: DS Length: 14 Value: 1.53401638403
(300C,0022) Referenced Fraction Group Number VR: IS Length: 2 Value: 1
(3253,0010) VR: LO Length: 34 Value: Varian Medical Systems VISION 3253
(3253,1000) VR: ST Length: 484 Value: (Long Size Data)
(3253,1001) VR: IS Length: 2 Value: 0
(3253,1002) VR: CS Length: 16 Value: ImageProcessing
(3273,0010) VR: LO Length: 34 Value: Varian Medical Systems VISION 3273
(3273,1000) VR: CS Length: 6 Value: 0\0\0
(3273,1001) VR: CS Length: 4 Value: HFS
(5000,0005) Curve Dimensions VR: US Length: 2 Value: 2
(5000,0010) Number of Points VR: US Length: 2 Value: 26
(5000,0020) Type of Data VR: CS Length: 4 Value: ROI
(5000,0030) Axis Units VR: SH Length: 10 Value: PIXL\PIXL
(5000,0040) Axis Labels VR: SH Length: 32 Value: Plan Field Edge\Plan Field Edge
(5000,0103) Data Value Representation VR: US Length: 2 Value: 3
(5000,2500) Curve Label VR: LO Length: 16 Value: Field Edge (3 G2
(5000,3000) Curve Data VR: OW Length: 416 Value: fb,b9,51,99