Senographe 2000D worklist

brady7ls · Sep 14th 2011

I am current running Conquest 1.4.16. We currently have worklists up and running correctly with several of my IU-22 sonogram machines. Right out of the box the IU-22's connected and pulled the worklist up with no issues.

The problem I'm having is that I also have GE Senographe 2000D mamogram machines. These machines have been setup to point to my PACS server but I am unable to get the worklist working. I am able to hit the refresh worlist button on the machine and my PACS server gets the query and send it back information but nothing ever shows up. I'm thinking I need to add another database field in the worklist or format an exiting one with specific information but what it is i'm at a loss.

Any and all assistance would greatly appreciated.

Below is my dicom.sql and the output from the PACS server

Code

*WorkList*{ 	{ 0x0008, 0x0050, "AccessionNumber",    16, SQL_C_CHAR, DT_STR,  "OBR.3" }, 	{ 0x0010, 0x0020, "PatientID",          64, SQL_C_CHAR, DT_STR,  "PID.18" }, 	{ 0x0010, 0x0010, "PatientName",        64, SQL_C_CHAR, DT_STR,  "PID.5" },        { 0x0010, 0x0030, "PatientBirthDate",    8, SQL_C_DATE, DT_DATE, "PID.7" }, 	{ 0x0010, 0x0040, "PatientSex",         16, SQL_C_CHAR, DT_STR,  "PID.8" }, 	{ 0x0010, 0x2000, "MedicalAlerts",      64, SQL_C_CHAR, DT_STR,  "---" }, 	{ 0x0010, 0x2110, "ContrastAllergies",  64, SQL_C_CHAR, DT_STR,  "---" }, 	{ 0x0020, 0x000d, "StudyInstanceUID",   64, SQL_C_CHAR, DT_STR,  "OBR.3" }, 	{ 0x0032, 0x1032, "ReqPhysician",       64, SQL_C_CHAR, DT_STR,  "OBR.16" }, 	{ 0x0032, 0x1060, "ReqProcDescription", 64, SQL_C_CHAR, DT_STR,  "OBR.4.1" }, 	{ 0x0040, 0x0100, "--------",   0, SQL_C_CHAR, DT_STARTSEQUENCE, "---" }, 	{ 0x0008, 0x0060, "Modality",           16, SQL_C_CHAR, DT_STR,  "OBR.24.0" }, 	{ 0x0032, 0x1070, "ReqContrastAgent",   64, SQL_C_CHAR, DT_STR,  "---" }, 	{ 0x0040, 0x0001, "ScheduledAE",        16, SQL_C_CHAR, DT_STR,  "WL_AWS1" }, 	{ 0x0040, 0x0002, "StartDate",           8, SQL_C_DATE, DT_DATE, "OBR.7.DATE" }, 	{ 0x0040, 0x0003, "StartTime",          16, SQL_C_CHAR, DT_TIME, "OBR.7.TIME" }, 	{ 0x0040, 0x0006, "PerfPhysician",      64, SQL_C_CHAR, DT_STR,  "OBR.16" }, 	{ 0x0040, 0x0007, "SchedPSDescription", 64, SQL_C_CHAR, DT_STR,  "---" }, 	{ 0x0040, 0x0009, "SchedPSID",          16, SQL_C_CHAR, DT_STR,  "OBR.4" }, 	{ 0x0040, 0x0010, "SchedStationName",   16, SQL_C_CHAR, DT_STR,  "OBR.24" }, 	{ 0x0040, 0x0011, "SchedPSLocation",    16, SQL_C_CHAR, DT_STR,  "---" }, 	{ 0x0040, 0x0012, "PreMedication",      64, SQL_C_CHAR, DT_STR,  "---" }, 	{ 0x0040, 0x0400, "SchedPSComments",    64, SQL_C_CHAR, DT_STR,  "---" }, 	{ 0x0040, 0x0100, "---------",    0, SQL_C_CHAR, DT_ENDSEQUENCE, "---" },        { 0x0040, 0x1001, "ReqProcID",          16, SQL_C_CHAR, DT_STR,  "OBR.4.0" }, 	{ 0x0040, 0x1003, "ReqProcPriority",    16, SQL_C_CHAR, DT_STR,  "OBR.27 }

Code

9/14/2011 4:32:57 PM [SHCONQUESTTEST] UPACS THREAD 12: STARTED AT: Wed Sep 14 16:32:57 2011
9/14/2011 4:32:57 PM [SHCONQUESTTEST] A-ASSOCIATE-RQ Packet Dump
9/14/2011 4:32:57 PM [SHCONQUESTTEST]  Calling Application Title : "WL_AWS1         "
9/14/2011 4:32:57 PM [SHCONQUESTTEST]  Called Application Title : "SHCONQUESTTEST  "
9/14/2011 4:32:57 PM [SHCONQUESTTEST]  Application Context : "1.2.840.10008.3.1.1.1", PDU length: 28672
9/14/2011 4:32:57 PM [SHCONQUESTTEST]  Number of Proposed Presentation Contexts: 1
9/14/2011 4:32:57 PM [SHCONQUESTTEST]  Presentation Context 0 "1.2.840.10008.5.1.4.31" 1
9/14/2011 4:32:57 PM [SHCONQUESTTEST] Server Command   := 0020
9/14/2011 4:32:57 PM [SHCONQUESTTEST] Message ID       := 0002
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0000,0002     22 UI AffectedSOPClassUID    "1.2.840.10008.5.1.4.31" 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0000,0100      2 US CommandField           32 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0000,0110      2 US MessageID              2 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0000,0700      2 US Priority               0 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0000,0800      2 US DataSetType            0 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0002,0010     17 UI TransferSyntaxUID      "1.2.840.10008.1.2" 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] (ModalityWorkListQuery) search level: 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0002,0010     17 UI TransferSyntaxUID      "1.2.840.10008.1.2" 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0008,0050      0 SH AccessionNumber        (empty)
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0008,0090      0 PN ReferringPhysicianNa   (empty)
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0010,0010      0 PN PatientName            (empty)
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0010,0020      0 LO PatientID              (empty)
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0010,0030      0 DA PatientBirthDate       (empty)
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0010,0040      0 CS PatientSex             (empty)
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0020,000d      0 UI StudyInstanceUID       (empty)
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0032,1060      0 LO RequestedProcedureDe   (empty)
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0040,0100      0 SQ ScheduledProcedureSt   Sequence Item
9/14/2011 4:32:57 PM [SHCONQUESTTEST] >0008,0060      0 CS Modality               (empty)
9/14/2011 4:32:57 PM [SHCONQUESTTEST] >0040,0001      0 AE ScheduledStationAETi   (empty)
9/14/2011 4:32:57 PM [SHCONQUESTTEST] >0040,0002     18 DA ScheduledProcedureSt   "20110914-20110914 " 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] >0040,0003      0 TM ScheduledProcedureSt   (empty)
9/14/2011 4:32:57 PM [SHCONQUESTTEST] >0040,0006      0 PN ScheduledPerformingP   (empty)
9/14/2011 4:32:57 PM [SHCONQUESTTEST] >0040,0007      0 LO ScheduledProcedureSt   (empty)
9/14/2011 4:32:57 PM [SHCONQUESTTEST] >0040,0009      0 SH ScheduledProcedureSt   (empty)
9/14/2011 4:32:57 PM [SHCONQUESTTEST] >0040,0010      0 SH ScheduledStationName   (empty)
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0040,1001      0 SH RequestedProcedureID   (empty)
9/14/2011 4:32:57 PM [SHCONQUESTTEST] Query On Modality WorkList
9/14/2011 4:32:57 PM [SHCONQUESTTEST] Queried item 0008 0090 is not in the database
9/14/2011 4:32:57 PM [SHCONQUESTTEST] Issue Query on Columns: DICOMWorkList.AccessionN, DICOMWorkList.PatientNam, DICOMWorkList.PatientID, DICOMWorkList.PatientBir, DICOMWorkList.PatientSex, DICOMWorkList.StudyInsta, DICOMWorkList.ReqProcDes, DICOMWorkList.Modality, DICOMWorkList.ScheduledA, DICOMWorkList.StartDate, DICOMWorkList.StartTime, DICOMWorkList.PerfPhysic, DICOMWorkList.SchedPSDes, DICOMWorkList.SchedPSID, DICOMWorkList.SchedStati, DICOMWorkList.ReqProcID
9/14/2011 4:32:57 PM [SHCONQUESTTEST] Values: DICOMWorkList.StartDate >= '20110914' and DICOMWorkList.StartDate <= '20110914'
9/14/2011 4:32:57 PM [SHCONQUESTTEST] Tables: DICOMWorkList
9/14/2011 4:32:57 PM [SHCONQUESTTEST] Sorting (DICOMWorkList.PatientNam) DoSort := 1
9/14/2011 4:32:57 PM [SHCONQUESTTEST] Query Distinct Tables: DICOMWorkList
9/14/2011 4:32:57 PM [SHCONQUESTTEST] Columns              : DICOMWorkList.AccessionN, DICOMWorkList.PatientNam, DICOMWorkList.PatientID, DICOMWorkList.PatientBir, DICOMWorkList.PatientSex, DICOMWorkList.StudyInsta, DICOMWorkList.ReqProcDes, DICOMWorkList.Modality, DICOMWorkList.ScheduledA, DICOMWorkList.StartDate, DICOMWorkList.StartTime, DICOMWorkList.PerfPhysic, DICOMWorkList.SchedPSDes, DICOMWorkList.SchedPSID, DICOMWorkList.SchedStati, DICOMWorkList.ReqProcID
9/14/2011 4:32:57 PM [SHCONQUESTTEST] Where                : DICOMWorkList.StartDate >= '20110914' and DICOMWorkList.StartDate <= '20110914'
9/14/2011 4:32:57 PM [SHCONQUESTTEST] Order                : DICOMWorkList.PatientNam
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0008,0050      6 SH AccessionNumber        "523000" 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0010,0010     12 PN PatientName            "xxxxx" 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0010,0020     10 LO PatientID              "1226711239" 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0010,0030      8 DA PatientBirthDate       "19711226" 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0010,0040      2 CS PatientSex             "F " 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0020,000d      6 UI StudyInstanceUID       "523000" 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0032,1060      8 LO RequestedProcedureDe   "SCREENI " 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] Coding sequence (0040,0100), level=1
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0008,0060      2 CS Modality               "MG" 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0040,0001      0 AE ScheduledStationAETi   (empty)
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0040,0002      8 DA ScheduledProcedureSt   "20110914" 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0040,0003      4 TM ScheduledProcedureSt   "0830" 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0040,0006      2 PN ScheduledPerformingP   "SH" 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0040,0007      0 LO ScheduledProcedureSt   (empty)
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0040,0009      2 SH ScheduledProcedureSt   "MG" 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0040,0010      2 SH ScheduledStationName   "MG" 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0040,1001      2 SH RequestedProcedureID   "MG" 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] Records = 1
9/14/2011 4:32:57 PM [SHCONQUESTTEST] First record of cleaned response:
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0008,0005     10 CS SpecificCharacterSet   "ISO_IR 100" 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0008,0050      6 SH AccessionNumber        "523000" 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0008,1110      0 SQ ReferencedStudySeque   Sequence Item
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0008,1120      0 SQ ReferencedPatientSeq   Sequence Item
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0010,0010     12 PN PatientName            "xxxxx " 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0010,0020     10 LO PatientID              "1226711239" 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0010,0030      8 DA PatientBirthDate       "19711226" 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0010,0040      2 CS PatientSex             "F " 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0020,000d      6 UI StudyInstanceUID       "523000" 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0032,1060      8 LO RequestedProcedureDe   "SCREENI " 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0040,0100      0 SQ ScheduledProcedureSt   Sequence Item
9/14/2011 4:32:57 PM [SHCONQUESTTEST] >0008,0060      2 CS Modality               "MG" 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] >0040,0001      0 AE ScheduledStationAETi   (empty)
9/14/2011 4:32:57 PM [SHCONQUESTTEST] >0040,0002      8 DA ScheduledProcedureSt   "20110914" 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] >0040,0003      4 TM ScheduledProcedureSt   "0830" 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] >0040,0006      2 PN ScheduledPerformingP   "SH" 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] >0040,0007      0 LO ScheduledProcedureSt   (empty)
9/14/2011 4:32:57 PM [SHCONQUESTTEST] >0040,0009      2 SH ScheduledProcedureSt   "MG" 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] >0040,0010      2 SH ScheduledStationName   "MG" 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] 0040,1001      2 SH RequestedProcedureID   "MG" 
9/14/2011 4:32:57 PM [SHCONQUESTTEST] C-Find (Modality Work List) located 1 records
9/14/2011 4:32:57 PM [SHCONQUESTTEST] UPACS THREAD 12: ENDED AT: Wed Sep 14 16:32:57 2011
9/14/2011 4:32:57 PM [SHCONQUESTTEST] UPACS THREAD 12: TOTAL RUNNING TIME: 0 SECONDS

Display More

brady7ls · Oct 13th 2011

I was finally able to get in contact with someone at GE who informed me that there needed to be additional fields in the worklist and that some entries needed to have data, ie not NULL. Below is the response of what needed to be added as well as my worklist definition which is working correctly.

The following tags in the RESPONSE are the problem:

Must contain a value ( may not be left empty

0020,000d 0 UI StudyInstanceUID (empty)
0040,0001 0 AE ScheduledStationAETi (empty)
0040,0006 0 PN ScheduledPerformingP (empty)
0040,0007 0 LO ScheduledProcedureSt (empty)

Must be present in the RESPONSE ( may be left empty
0008,0090 0 PN ReferringPhysicianNa (empty)

Code

{ 0x0008, 0x0050, "AccessionNumber",    16, SQL_C_CHAR, DT_STR,  "OBR.3" },
 	{ 0x0010, 0x0020, "PatientID",          64, SQL_C_CHAR, DT_STR,  "PID.18" },
 	{ 0x0010, 0x0010, "PatientName",        64, SQL_C_CHAR, DT_STR,  "PID.5" },
        { 0x0010, 0x0030, "PatientBirthDate",    8, SQL_C_DATE, DT_DATE, "PID.7" },
 	{ 0x0010, 0x0040, "PatientSex",         16, SQL_C_CHAR, DT_STR,  "PID.8" },


 	{ 0x0010, 0x2000, "MedicalAlerts",      64, SQL_C_CHAR, DT_STR,  "---" },
 	{ 0x0010, 0x2110, "ContrastAllergies",  64, SQL_C_CHAR, DT_STR,  "---" },
 	{ 0x0020, 0x000d, "StudyInstanceUID",   64, SQL_C_CHAR, DT_STR,  "OBR.3" },
 	{ 0x0032, 0x1032, "ReqPhysician",       64, SQL_C_CHAR, DT_STR,  "OBR.16" },
 	{ 0x0032, 0x1060, "ReqProcDescription", 64, SQL_C_CHAR, DT_STR,  "OBR.4.1" },


 	{ 0x0040, 0x0100, "--------",   0, SQL_C_CHAR, DT_STARTSEQUENCE, "---" },
 	{ 0x0008, 0x0090, "ReferringPhysicianNa",16, SQL_C_CHAR, DT_STR,  "OBR.24.0" },
 	{ 0x0008, 0x0060, "Modality",           16, SQL_C_CHAR, DT_STR,  "OBR.24.0" },
 	{ 0x0032, 0x1070, "ReqContrastAgent",   64, SQL_C_CHAR, DT_STR,  "---" },
 	{ 0x0040, 0x0001, "ScheduledAE",        16, SQL_C_CHAR, DT_STR,  "OBR.24.0" },
 	{ 0x0040, 0x0002, "StartDate",           8, SQL_C_DATE, DT_DATE, "OBR.7.DATE" },
 	{ 0x0040, 0x0003, "StartTime",          16, SQL_C_CHAR, DT_TIME, "OBR.7.TIME" },
 	{ 0x0040, 0x0006, "PerfPhysician",      64, SQL_C_CHAR, DT_STR,  "OBR.16" },
 	{ 0x0040, 0x0007, "SchedPSDescription", 64, SQL_C_CHAR, DT_STR,  "OBR.16" },
 	{ 0x0040, 0x0009, "SchedPSID",          16, SQL_C_CHAR, DT_STR,  "OBR.4" },
 	{ 0x0040, 0x0010, "SchedStationName",   16, SQL_C_CHAR, DT_STR,  "OBR.24" },
 	{ 0x0040, 0x0011, "SchedPSLocation",    16, SQL_C_CHAR, DT_STR,  "---" },
 	{ 0x0040, 0x0012, "PreMedication",      64, SQL_C_CHAR, DT_STR,  "---" },
 	{ 0x0040, 0x0400, "SchedPSComments",    64, SQL_C_CHAR, DT_STR,  "---" },
 	{ 0x0040, 0x0100, "---------",    0, SQL_C_CHAR, DT_ENDSEQUENCE, "---" },


        { 0x0040, 0x1001, "ReqProcID",          16, SQL_C_CHAR, DT_STR,  "OBR.4.0" },
 	{ 0x0040, 0x1003, "ReqProcPriority",    16, SQL_C_CHAR, DT_STR,  "OBR.27 }

Display More

marcelvanherk · Oct 13th 2011

Thanks!

Marcel

Senographe 2000D worklist

Participate now!

Share