Hi Marcel
I need some help in Worklist. Appended below is the Server Log and dicom.sql for your review.
Server Log
7/17/2017 1:39:34 PM [HPACS] UPACS THREAD 7: STARTED AT: Mon Jul 17 13:39:33 2017
7/17/2017 1:39:34 PM [HPACS] A-ASSOCIATE-RQ Packet Dump
7/17/2017 1:39:34 PM [HPACS] Calling Application Title : "NX_DEFAULT1 "
7/17/2017 1:39:34 PM [HPACS] Called Application Title : "HPACS "
7/17/2017 1:39:34 PM [HPACS] Application Context : "1.2.840.10008.3.1.1.1", PDU length: 65542
7/17/2017 1:39:34 PM [HPACS] Number of Proposed Presentation Contexts: 1
7/17/2017 1:39:34 PM [HPACS] Presentation Context 0 "1.2.840.10008.5.1.4.31" 1
7/17/2017 1:39:34 PM [HPACS] Server Command := 0020
7/17/2017 1:39:34 PM [HPACS] Message ID := 0001
7/17/2017 1:39:34 PM [HPACS] 0000,0002 22 UI AffectedSOPClassUID "1.2.840.10008.5.1.4.31"
7/17/2017 1:39:34 PM [HPACS] 0000,0100 2 US CommandField 32
7/17/2017 1:39:34 PM [HPACS] 0000,0110 2 US MessageID 1
7/17/2017 1:39:34 PM [HPACS] 0000,0700 2 US Priority 1
7/17/2017 1:39:34 PM [HPACS] 0000,0800 2 US DataSetType 1
7/17/2017 1:39:34 PM [HPACS] 0002,0010 17 UI TransferSyntaxUID "1.2.840.10008.1.2"
7/17/2017 1:39:34 PM [HPACS] (ModalityWorkListQuery) search level:
7/17/2017 1:39:34 PM [HPACS] 0002,0010 17 UI TransferSyntaxUID "1.2.840.10008.1.2"
7/17/2017 1:39:34 PM [HPACS] 0008,0005 0 CS SpecificCharacterSet (empty)
7/17/2017 1:39:34 PM [HPACS] 0008,0050 0 SH AccessionNumber (empty)
7/17/2017 1:39:34 PM [HPACS] 0008,0090 0 PN ReferringPhysicianNa (empty)
7/17/2017 1:39:34 PM [HPACS] 0008,1110 0 SQ ReferencedStudySeque Sequence Item
7/17/2017 1:39:34 PM [HPACS] >0008,1150 0 UI ReferencedSOPClassUI (empty)
7/17/2017 1:39:34 PM [HPACS] >0008,1155 0 UI ReferencedSOPInstanc (empty)
7/17/2017 1:39:34 PM [HPACS] 0008,1120 0 SQ ReferencedPatientSeq Sequence Item
7/17/2017 1:39:34 PM [HPACS] >0008,1150 0 UI ReferencedSOPClassUI (empty)
7/17/2017 1:39:34 PM [HPACS] >0008,1155 0 UI ReferencedSOPInstanc (empty)
7/17/2017 1:39:34 PM [HPACS] 0010,0010 0 PN PatientName (empty)
7/17/2017 1:39:34 PM [HPACS] 0010,0020 0 LO PatientID (empty)
7/17/2017 1:39:34 PM [HPACS] 0010,0030 0 DA PatientBirthDate (empty)
7/17/2017 1:39:34 PM [HPACS] 0010,0032 0 TM PatientBirthTime (empty)
7/17/2017 1:39:34 PM [HPACS] 0010,0040 0 CS PatientSex (empty)
7/17/2017 1:39:34 PM [HPACS] 0010,1000 0 LO OtherPatientIDs (empty)
7/17/2017 1:39:34 PM [HPACS] 0010,1020 0 DS PatientSize (empty)
7/17/2017 1:39:34 PM [HPACS] 0010,1030 0 DS PatientWeight (empty)
7/17/2017 1:39:34 PM [HPACS] 0010,1080 0 LO MilitaryRank (empty)
7/17/2017 1:39:34 PM [HPACS] 0010,2000 0 LO MedicalAlerts (empty)
7/17/2017 1:39:34 PM [HPACS] 0010,2110 0 LO Allergies (empty)
7/17/2017 1:39:34 PM [HPACS] 0010,2160 0 SH EthnicGroup (empty)
7/17/2017 1:39:34 PM [HPACS] 0010,2180 0 SH Occupation (empty)
7/17/2017 1:39:34 PM [HPACS] 0010,21b0 0 LT AdditionalPatientHis (empty)
7/17/2017 1:39:34 PM [HPACS] 0010,21c0 0 US PregnancyStatus (empty)
7/17/2017 1:39:34 PM [HPACS] 0010,4000 0 LT PatientComments (empty)
7/17/2017 1:39:34 PM [HPACS] 0020,000d 0 UI StudyInstanceUID (empty)
7/17/2017 1:39:34 PM [HPACS] 0032,1032 0 PN RequestingPhysician (empty)
7/17/2017 1:39:34 PM [HPACS] 0032,1033 0 LO RequestingService (empty)
7/17/2017 1:39:34 PM [HPACS] 0032,1060 0 LO RequestedProcedureDe (empty)
7/17/2017 1:39:34 PM [HPACS] 0032,1064 0 SQ RequestedProcedureCo Sequence Item
7/17/2017 1:39:34 PM [HPACS] >0008,0100 0 SH CodeValue (empty)
7/17/2017 1:39:34 PM [HPACS] >0008,0102 0 SH CodingSchemeDesignat (empty)
7/17/2017 1:39:34 PM [HPACS] >0008,0104 0 LO CodeMeaning (empty)
7/17/2017 1:39:34 PM [HPACS] 0038,0010 0 LO AdmissionID (empty)
7/17/2017 1:39:34 PM [HPACS] 0038,0050 0 LO SpecialNeeds (empty)
7/17/2017 1:39:34 PM [HPACS] 0038,0300 0 LO CurrentPatientLocati (empty)
7/17/2017 1:39:34 PM [HPACS] 0038,0500 0 LO PatientState (empty)
7/17/2017 1:39:34 PM [HPACS] 0040,0100 0 SQ ScheduledProcedureSt Sequence Item
7/17/2017 1:39:34 PM [HPACS] >0008,0060 2 CS Modality "DX"
7/17/2017 1:39:34 PM [HPACS] >0032,1070 0 LO RequestedContrastAge (empty)
7/17/2017 1:39:34 PM [HPACS] >0040,0001 0 AE ScheduledStationAETi (empty)
7/17/2017 1:39:34 PM [HPACS] >0040,0002 0 DA ScheduledProcedureSt (empty)
7/17/2017 1:39:34 PM [HPACS] >0040,0003 0 TM ScheduledProcedureSt (empty)
7/17/2017 1:39:34 PM [HPACS] >0040,0006 0 PN ScheduledPerformingP (empty)
7/17/2017 1:39:34 PM [HPACS] >0040,0007 0 LO ScheduledProcedureSt (empty)
7/17/2017 1:39:34 PM [HPACS] >0040,0008 0 SQ ScheduledProtocolCod Sequence Item
7/17/2017 1:39:34 PM [HPACS] >0040,0009 0 SH ScheduledProcedureSt (empty)
7/17/2017 1:39:34 PM [HPACS] >0040,0010 0 SH ScheduledStationName (empty)
7/17/2017 1:39:34 PM [HPACS] >0040,0011 0 SH ScheduledProcedureSt (empty)
7/17/2017 1:39:34 PM [HPACS] >0040,0012 0 LO PreMedication (empty)
7/17/2017 1:39:34 PM [HPACS] >0040,0020 0 CS ScheduledProcedureSt (empty)
7/17/2017 1:39:34 PM [HPACS] 0040,1001 0 SH RequestedProcedureID (empty)
7/17/2017 1:39:34 PM [HPACS] 0040,1002 0 LO ReasonForTheRequeste (empty)
7/17/2017 1:39:34 PM [HPACS] 0040,1003 0 SH RequestedProcedurePr (empty)
7/17/2017 1:39:34 PM [HPACS] 0040,1004 0 LO PatientTransportArra (empty)
7/17/2017 1:39:34 PM [HPACS] 0040,2016 0 LO PlacerOrderNumberIma (empty)
7/17/2017 1:39:34 PM [HPACS] 0040,2017 0 LO FillerOrderNumberIma (empty)
7/17/2017 1:39:34 PM [HPACS] 0040,2400 0 LT ImagingServiceReques (empty)
7/17/2017 1:39:34 PM [HPACS] 0040,3001 0 LO ConfidentialityConst (empty)
7/17/2017 1:39:34 PM [HPACS] Query On Modality WorkList
7/17/2017 1:39:34 PM [HPACS] Queried item 0008 0005 is not in the database
7/17/2017 1:39:34 PM [HPACS] Queried item 0008 0090 is not in the database
7/17/2017 1:39:34 PM [HPACS] Queried item 0008 1150 is not in the database
7/17/2017 1:39:34 PM [HPACS] Queried item 0008 1155 is not in the database
7/17/2017 1:39:34 PM [HPACS] Queried item 0008 1150 is not in the database
7/17/2017 1:39:34 PM [HPACS] Queried item 0008 1155 is not in the database
7/17/2017 1:39:34 PM [HPACS] Queried item 0010 0032 is not in the database
7/17/2017 1:39:34 PM [HPACS] Queried item 0010 1000 is not in the database
7/17/2017 1:39:34 PM [HPACS] Queried item 0010 1020 is not in the database
7/17/2017 1:39:34 PM [HPACS] Queried item 0010 1030 is not in the database
7/17/2017 1:39:34 PM [HPACS] Queried item 0010 1080 is not in the database
7/17/2017 1:39:34 PM [HPACS] Queried item 0010 2160 is not in the database
7/17/2017 1:39:34 PM [HPACS] Queried item 0010 2180 is not in the database
7/17/2017 1:39:34 PM [HPACS] Queried item 0010 21b0 is not in the database
7/17/2017 1:39:34 PM [HPACS] Queried item 0010 21c0 is not in the database
7/17/2017 1:39:34 PM [HPACS] Queried item 0010 4000 is not in the database
7/17/2017 1:39:34 PM [HPACS] Queried item 0032 1033 is not in the database
7/17/2017 1:39:34 PM [HPACS] Queried item 0008 0100 is not in the database
7/17/2017 1:39:34 PM [HPACS] Queried item 0008 0102 is not in the database
7/17/2017 1:39:34 PM [HPACS] Queried item 0008 0104 is not in the database
7/17/2017 1:39:34 PM [HPACS] Queried item 0038 0010 is not in the database
7/17/2017 1:39:34 PM [HPACS] Queried item 0038 0050 is not in the database
7/17/2017 1:39:34 PM [HPACS] Queried item 0038 0300 is not in the database
7/17/2017 1:39:34 PM [HPACS] Queried item 0038 0500 is not in the database
7/17/2017 1:39:34 PM [HPACS] Queried item 0040 0020 is not in the database
7/17/2017 1:39:34 PM [HPACS] Queried item 0040 1002 is not in the database
7/17/2017 1:39:34 PM [HPACS] Queried item 0040 1004 is not in the database
7/17/2017 1:39:34 PM [HPACS] Queried item 0040 2016 is not in the database
7/17/2017 1:39:34 PM [HPACS] Queried item 0040 2017 is not in the database
7/17/2017 1:39:34 PM [HPACS] Queried item 0040 2400 is not in the database
7/17/2017 1:39:34 PM [HPACS] Queried item 0040 3001 is not in the database
7/17/2017 1:39:34 PM [HPACS] Issue Query on Columns: DICOMWorkList.AccessionN, DICOMWorkList.PatientNam, DICOMWorkList.PatientID, DICOMWorkList.PatientBir, DICOMWorkList.PatientSex, DICOMWorkList.MedicalAle, DICOMWorkList.ContrastAl, DICOMWorkList.StudyInsta, DICOMWorkList.ReqPhysici, DICOMWorkList.ReqProcDes, DICOMWorkList.Modality, DICOMWorkList.ReqContras, DICOMWorkList.ScheduledA, DICOMWorkList.StartDate, DICOMWorkList.StartTime, DICOMWorkList.PerfPhysic, DICOMWorkList.SchedPSDes, DICOMWorkList.SchedPSID, DICOMWorkList.SchedStati, DICOMWorkList.SchedPSLoc, DICOMWorkList.PreMedicat, DICOMWorkList.ReqProcID, DICOMWorkList.ReqProcPri
7/17/2017 1:39:34 PM [HPACS] Values: DICOMWorkList.Modality = 'DX'
7/17/2017 1:39:34 PM [HPACS] Tables: DICOMWorkList
7/17/2017 1:39:34 PM [HPACS] Sorting (DICOMWorkList.PatientNam) DoSort := 1
7/17/2017 1:39:34 PM [HPACS] Query Distinct Tables: DICOMWorkList
7/17/2017 1:39:34 PM [HPACS] Columns : DICOMWorkList.AccessionN, DICOMWorkList.PatientNam, DICOMWorkList.PatientID, DICOMWorkList.PatientBir, DICOMWorkList.PatientSex, DICOMWorkList.MedicalAle, DICOMWorkList.ContrastAl, DICOMWorkList.StudyInsta, DICOMWorkList.ReqPhysici, DICOMWorkList.ReqProcDes, DICOMWorkList.Modality, DICOMWorkList.ReqContras, DICOMWorkList.ScheduledA, DICOMWorkList.StartDate, DICOMWorkList.StartTime, DICOMWorkList.PerfPhysic, DICOMWorkList.SchedPSDes, DICOMWorkList.SchedPSID, DICOMWorkList.SchedStati, DICOMWorkList.SchedPSLoc, DICOMWorkList.PreMedicat, DICOMWorkList.ReqProcID, DICOMWorkList.ReqProcPri
7/17/2017 1:39:34 PM [HPACS] Where : DICOMWorkList.Modality = 'DX'
7/17/2017 1:39:34 PM [HPACS] Order : DICOMWorkList.PatientNam
7/17/2017 1:39:34 PM [HPACS] Records = 0
7/17/2017 1:39:34 PM [HPACS] C-Find (Modality Work List) located 0 records
7/17/2017 1:39:34 PM [HPACS] UPACS THREAD 7: ENDED AT: Mon Jul 17 13:39:34 2017
7/17/2017 1:39:34 PM [HPACS] UPACS THREAD 7: TOTAL RUNNING TIME: 1 SECONDS
7/17/2017 1:41:41 PM [HPACS] UPACS THREAD 9: STARTED AT: Mon Jul 17 13:41:41 2017
7/17/2017 1:41:41 PM [HPACS] A-ASSOCIATE-RQ Packet Dump
7/17/2017 1:41:42 PM [HPACS] Calling Application Title : "NX_DEFAULT1 "
7/17/2017 1:41:42 PM [HPACS] Called Application Title : "HPACS "
7/17/2017 1:41:42 PM [HPACS] Application Context : "1.2.840.10008.3.1.1.1", PDU length: 65542
7/17/2017 1:41:42 PM [HPACS] Number of Proposed Presentation Contexts: 1
7/17/2017 1:41:42 PM [HPACS] Presentation Context 0 "1.2.840.10008.5.1.4.31" 1
7/17/2017 1:41:42 PM [HPACS] Server Command := 0020
7/17/2017 1:41:42 PM [HPACS] Message ID := 0001
7/17/2017 1:41:42 PM [HPACS] 0000,0002 22 UI AffectedSOPClassUID "1.2.840.10008.5.1.4.31"
7/17/2017 1:41:42 PM [HPACS] 0000,0100 2 US CommandField 32
7/17/2017 1:41:42 PM [HPACS] 0000,0110 2 US MessageID 1
7/17/2017 1:41:42 PM [HPACS] 0000,0700 2 US Priority 1
7/17/2017 1:41:42 PM [HPACS] 0000,0800 2 US DataSetType 1
7/17/2017 1:41:42 PM [HPACS] 0002,0010 17 UI TransferSyntaxUID "1.2.840.10008.1.2"
7/17/2017 1:41:42 PM [HPACS] (ModalityWorkListQuery) search level:
7/17/2017 1:41:42 PM [HPACS] 0002,0010 17 UI TransferSyntaxUID "1.2.840.10008.1.2"
7/17/2017 1:41:42 PM [HPACS] 0008,0005 0 CS SpecificCharacterSet (empty)
7/17/2017 1:41:42 PM [HPACS] 0008,0050 0 SH AccessionNumber (empty)
7/17/2017 1:41:42 PM [HPACS] 0008,0090 0 PN ReferringPhysicianNa (empty)
7/17/2017 1:41:42 PM [HPACS] 0008,1110 0 SQ ReferencedStudySeque Sequence Item
7/17/2017 1:41:42 PM [HPACS] >0008,1150 0 UI ReferencedSOPClassUI (empty)
7/17/2017 1:41:42 PM [HPACS] >0008,1155 0 UI ReferencedSOPInstanc (empty)
7/17/2017 1:41:42 PM [HPACS] 0008,1120 0 SQ ReferencedPatientSeq Sequence Item
7/17/2017 1:41:42 PM [HPACS] >0008,1150 0 UI ReferencedSOPClassUI (empty)
7/17/2017 1:41:42 PM [HPACS] >0008,1155 0 UI ReferencedSOPInstanc (empty)
7/17/2017 1:41:42 PM [HPACS] 0010,0010 0 PN PatientName (empty)
7/17/2017 1:41:42 PM [HPACS] 0010,0020 0 LO PatientID (empty)
7/17/2017 1:41:42 PM [HPACS] 0010,0030 0 DA PatientBirthDate (empty)
7/17/2017 1:41:42 PM [HPACS] 0010,0032 0 TM PatientBirthTime (empty)
7/17/2017 1:41:42 PM [HPACS] 0010,0040 0 CS PatientSex (empty)
7/17/2017 1:41:42 PM [HPACS] 0010,1000 0 LO OtherPatientIDs (empty)
7/17/2017 1:41:42 PM [HPACS] 0010,1020 0 DS PatientSize (empty)
7/17/2017 1:41:42 PM [HPACS] 0010,1030 0 DS PatientWeight (empty)
7/17/2017 1:41:42 PM [HPACS] 0010,1080 0 LO MilitaryRank (empty)
7/17/2017 1:41:42 PM [HPACS] 0010,2000 0 LO MedicalAlerts (empty)
7/17/2017 1:41:42 PM [HPACS] 0010,2110 0 LO Allergies (empty)
7/17/2017 1:41:42 PM [HPACS] 0010,2160 0 SH EthnicGroup (empty)
7/17/2017 1:41:42 PM [HPACS] 0010,2180 0 SH Occupation (empty)
7/17/2017 1:41:42 PM [HPACS] 0010,21b0 0 LT AdditionalPatientHis (empty)
7/17/2017 1:41:42 PM [HPACS] 0010,21c0 0 US PregnancyStatus (empty)
7/17/2017 1:41:42 PM [HPACS] 0010,4000 0 LT PatientComments (empty)
7/17/2017 1:41:42 PM [HPACS] 0020,000d 0 UI StudyInstanceUID (empty)
7/17/2017 1:41:42 PM [HPACS] 0032,1032 0 PN RequestingPhysician (empty)
7/17/2017 1:41:42 PM [HPACS] 0032,1033 0 LO RequestingService (empty)
7/17/2017 1:41:42 PM [HPACS] 0032,1060 0 LO RequestedProcedureDe (empty)
7/17/2017 1:41:42 PM [HPACS] 0032,1064 0 SQ RequestedProcedureCo Sequence Item
7/17/2017 1:41:42 PM [HPACS] >0008,0100 0 SH CodeValue (empty)
7/17/2017 1:41:42 PM [HPACS] >0008,0102 0 SH CodingSchemeDesignat (empty)
7/17/2017 1:41:42 PM [HPACS] >0008,0104 0 LO CodeMeaning (empty)
7/17/2017 1:41:42 PM [HPACS] 0038,0010 0 LO AdmissionID (empty)
7/17/2017 1:41:42 PM [HPACS] 0038,0050 0 LO SpecialNeeds (empty)
7/17/2017 1:41:42 PM [HPACS] 0038,0300 0 LO CurrentPatientLocati (empty)
7/17/2017 1:41:42 PM [HPACS] 0038,0500 0 LO PatientState (empty)
7/17/2017 1:41:42 PM [HPACS] 0040,0100 0 SQ ScheduledProcedureSt Sequence Item
7/17/2017 1:41:42 PM [HPACS] >0008,0060 2 CS Modality "DX"
7/17/2017 1:41:42 PM [HPACS] >0032,1070 0 LO RequestedContrastAge (empty)
7/17/2017 1:41:42 PM [HPACS] >0040,0001 0 AE ScheduledStationAETi (empty)
7/17/2017 1:41:42 PM [HPACS] >0040,0002 0 DA ScheduledProcedureSt (empty)
7/17/2017 1:41:42 PM [HPACS] >0040,0003 0 TM ScheduledProcedureSt (empty)
7/17/2017 1:41:42 PM [HPACS] >0040,0006 0 PN ScheduledPerformingP (empty)
7/17/2017 1:41:42 PM [HPACS] >0040,0007 0 LO ScheduledProcedureSt (empty)
7/17/2017 1:41:42 PM [HPACS] >0040,0008 0 SQ ScheduledProtocolCod Sequence Item
7/17/2017 1:41:42 PM [HPACS] >0040,0009 0 SH ScheduledProcedureSt (empty)
7/17/2017 1:41:42 PM [HPACS] >0040,0010 0 SH ScheduledStationName (empty)
7/17/2017 1:41:42 PM [HPACS] >0040,0011 0 SH ScheduledProcedureSt (empty)
7/17/2017 1:41:42 PM [HPACS] >0040,0012 0 LO PreMedication (empty)
7/17/2017 1:41:42 PM [HPACS] >0040,0020 0 CS ScheduledProcedureSt (empty)
7/17/2017 1:41:42 PM [HPACS] 0040,1001 0 SH RequestedProcedureID (empty)
7/17/2017 1:41:42 PM [HPACS] 0040,1002 0 LO ReasonForTheRequeste (empty)
7/17/2017 1:41:42 PM [HPACS] 0040,1003 0 SH RequestedProcedurePr (empty)
7/17/2017 1:41:42 PM [HPACS] 0040,1004 0 LO PatientTransportArra (empty)
7/17/2017 1:41:42 PM [HPACS] 0040,2016 0 LO PlacerOrderNumberIma (empty)
7/17/2017 1:41:42 PM [HPACS] 0040,2017 0 LO FillerOrderNumberIma (empty)
7/17/2017 1:41:42 PM [HPACS] 0040,2400 0 LT ImagingServiceReques (empty)
7/17/2017 1:41:42 PM [HPACS] 0040,3001 0 LO ConfidentialityConst (empty)
7/17/2017 1:41:42 PM [HPACS] Query On Modality WorkList
7/17/2017 1:41:42 PM [HPACS] Queried item 0008 0005 is not in the database
7/17/2017 1:41:42 PM [HPACS] Queried item 0008 0090 is not in the database
7/17/2017 1:41:42 PM [HPACS] Queried item 0008 1150 is not in the database
7/17/2017 1:41:42 PM [HPACS] Queried item 0008 1155 is not in the database
7/17/2017 1:41:42 PM [HPACS] Queried item 0008 1150 is not in the database
7/17/2017 1:41:42 PM [HPACS] Queried item 0008 1155 is not in the database
7/17/2017 1:41:42 PM [HPACS] Queried item 0010 0032 is not in the database
7/17/2017 1:41:42 PM [HPACS] Queried item 0010 1000 is not in the database
7/17/2017 1:41:42 PM [HPACS] Queried item 0010 1020 is not in the database
7/17/2017 1:41:42 PM [HPACS] Queried item 0010 1030 is not in the database
7/17/2017 1:41:42 PM [HPACS] Queried item 0010 1080 is not in the database
7/17/2017 1:41:42 PM [HPACS] Queried item 0010 2160 is not in the database
7/17/2017 1:41:42 PM [HPACS] Queried item 0010 2180 is not in the database
7/17/2017 1:41:42 PM [HPACS] Queried item 0010 21b0 is not in the database
7/17/2017 1:41:42 PM [HPACS] Queried item 0010 21c0 is not in the database
7/17/2017 1:41:42 PM [HPACS] Queried item 0010 4000 is not in the database
7/17/2017 1:41:42 PM [HPACS] Queried item 0032 1033 is not in the database
7/17/2017 1:41:42 PM [HPACS] Queried item 0008 0100 is not in the database
7/17/2017 1:41:42 PM [HPACS] Queried item 0008 0102 is not in the database
7/17/2017 1:41:42 PM [HPACS] Queried item 0008 0104 is not in the database
7/17/2017 1:41:42 PM [HPACS] Queried item 0038 0010 is not in the database
7/17/2017 1:41:42 PM [HPACS] Queried item 0038 0050 is not in the database
7/17/2017 1:41:42 PM [HPACS] Queried item 0038 0300 is not in the database
7/17/2017 1:41:42 PM [HPACS] Queried item 0038 0500 is not in the database
7/17/2017 1:41:42 PM [HPACS] Queried item 0040 0020 is not in the database
7/17/2017 1:41:42 PM [HPACS] Queried item 0040 1002 is not in the database
7/17/2017 1:41:42 PM [HPACS] Queried item 0040 1004 is not in the database
7/17/2017 1:41:42 PM [HPACS] Queried item 0040 2016 is not in the database
7/17/2017 1:41:42 PM [HPACS] Queried item 0040 2017 is not in the database
7/17/2017 1:41:42 PM [HPACS] Queried item 0040 2400 is not in the database
7/17/2017 1:41:42 PM [HPACS] Queried item 0040 3001 is not in the database
7/17/2017 1:41:42 PM [HPACS] Issue Query on Columns: DICOMWorkList.AccessionN, DICOMWorkList.PatientNam, DICOMWorkList.PatientID, DICOMWorkList.PatientBir, DICOMWorkList.PatientSex, DICOMWorkList.MedicalAle, DICOMWorkList.ContrastAl, DICOMWorkList.StudyInsta, DICOMWorkList.ReqPhysici, DICOMWorkList.ReqProcDes, DICOMWorkList.Modality, DICOMWorkList.ReqContras, DICOMWorkList.ScheduledA, DICOMWorkList.StartDate, DICOMWorkList.StartTime, DICOMWorkList.PerfPhysic, DICOMWorkList.SchedPSDes, DICOMWorkList.SchedPSID, DICOMWorkList.SchedStati, DICOMWorkList.SchedPSLoc, DICOMWorkList.PreMedicat, DICOMWorkList.ReqProcID, DICOMWorkList.ReqProcPri
7/17/2017 1:41:42 PM [HPACS] Values: DICOMWorkList.Modality = 'DX'
7/17/2017 1:41:42 PM [HPACS] Tables: DICOMWorkList
7/17/2017 1:41:42 PM [HPACS] Sorting (DICOMWorkList.PatientNam) DoSort := 1
7/17/2017 1:41:42 PM [HPACS] Query Distinct Tables: DICOMWorkList
7/17/2017 1:41:42 PM [HPACS] Columns : DICOMWorkList.AccessionN, DICOMWorkList.PatientNam, DICOMWorkList.PatientID, DICOMWorkList.PatientBir, DICOMWorkList.PatientSex, DICOMWorkList.MedicalAle, DICOMWorkList.ContrastAl, DICOMWorkList.StudyInsta, DICOMWorkList.ReqPhysici, DICOMWorkList.ReqProcDes, DICOMWorkList.Modality, DICOMWorkList.ReqContras, DICOMWorkList.ScheduledA, DICOMWorkList.StartDate, DICOMWorkList.StartTime, DICOMWorkList.PerfPhysic, DICOMWorkList.SchedPSDes, DICOMWorkList.SchedPSID, DICOMWorkList.SchedStati, DICOMWorkList.SchedPSLoc, DICOMWorkList.PreMedicat, DICOMWorkList.ReqProcID, DICOMWorkList.ReqProcPri
7/17/2017 1:41:42 PM [HPACS] Where : DICOMWorkList.Modality = 'DX'
7/17/2017 1:41:42 PM [HPACS] Order : DICOMWorkList.PatientNam
7/17/2017 1:41:42 PM [HPACS] 0008,0050 10 SH AccessionNumber "20170717-1"
7/17/2017 1:41:42 PM [HPACS] Coding sequence (0008,1110), level=1
7/17/2017 1:41:42 PM [HPACS] (sequence is empty)
7/17/2017 1:41:42 PM [HPACS] Coding sequence (0008,1120), level=1
7/17/2017 1:41:42 PM [HPACS] (sequence is empty)
7/17/2017 1:41:42 PM [HPACS] 0010,0010 12 PN PatientName "ABC"
7/17/2017 1:41:42 PM [HPACS] 0010,0020 12 LO PatientID "A1234"
7/17/2017 1:41:42 PM [HPACS] 0010,0030 10 DA PatientBirthDate "2017-07-16"
7/17/2017 1:41:42 PM [HPACS] 0010,0040 2 CS PatientSex "M "
7/17/2017 1:41:42 PM [HPACS] 0010,2000 0 LO MedicalAlerts (empty)
7/17/2017 1:41:42 PM [HPACS] 0010,2110 0 LO Allergies (empty)
7/17/2017 1:41:42 PM [HPACS] 0020,000d 0 UI StudyInstanceUID (empty)
7/17/2017 1:41:42 PM [HPACS] 0032,1032 20 PN RequestingPhysician "Requesting Physician"
7/17/2017 1:41:42 PM [HPACS] 0032,1060 8 LO RequestedProcedureDe "CHEST PA"
7/17/2017 1:41:42 PM [HPACS] Coding sequence (0032,1064), level=1
7/17/2017 1:41:42 PM [HPACS] (sequence is empty)
7/17/2017 1:41:42 PM [HPACS] Coding sequence (0040,0100), level=1
7/17/2017 1:41:42 PM [HPACS] 0008,0060 2 CS Modality "DX"
7/17/2017 1:41:42 PM [HPACS] 0032,1070 0 LO RequestedContrastAge (empty)
7/17/2017 1:41:42 PM [HPACS] 0040,0001 12 AE ScheduledStationAETi "NX_DEFAULT1 "
7/17/2017 1:41:42 PM [HPACS] 0040,0002 8 DA ScheduledProcedureSt "20170717"
7/17/2017 1:41:42 PM [HPACS] 0040,0003 6 TM ScheduledProcedureSt "235010"
7/17/2017 1:41:42 PM [HPACS] 0040,0007 0 LO ScheduledProcedureSt (empty)
7/17/2017 1:41:42 PM [HPACS] Server Command := 0fff
7/17/2017 1:41:42 PM [HPACS] Message ID := 0000
7/17/2017 1:41:42 PM [HPACS] 0000,0100 2 US CommandField 4095
7/17/2017 1:41:42 PM [HPACS] 0000,0120 2 US MessageIDBeingRespon 1
7/17/2017 1:41:42 PM [HPACS] 0000,0800 2 US DataSetType 257
7/17/2017 1:41:42 PM [HPACS] 0002,0010 17 UI TransferSyntaxUID "1.2.840.10008.1.2"
7/17/2017 1:41:42 PM [HPACS] Cancel request
7/17/2017 1:41:48 PM [HPACS] Protocol error 0 in PDU:Read
7/17/2017 1:41:48 PM [HPACS] UPACS THREAD 9: ENDED AT: Mon Jul 17 13:41:48 2017
7/17/2017 1:41:48 PM [HPACS] UPACS THREAD 9: TOTAL RUNNING TIME: 7 SECONDS
Dicom.sql
*WorkList*
{
{ 0x0008, 0x0050, "AccessionNumber", 16, SQL_C_CHAR, DT_STR, "OBR.3" },
{ 0x0010, 0x0020, "PatientID", 64, SQL_C_CHAR, DT_STR, "PID.4" },
{ 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_UI, "---" },
{ 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.21" },
{ 0x0032, 0x1070, "ReqContrastAgent", 64, SQL_C_CHAR, DT_STR, "---" },
{ 0x0040, 0x0001, "ScheduledAE", 16, SQL_C_CHAR, DT_STR, "---" },
{ 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, "---" },
{ 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, 0x0008, "SchedProtCode", 128, SQL_C_CHAR, DT_STR, "OBR.4.1" },
{ 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 }
}
On querying the PACS Server, all the required records were shown but Patient Age and Schedule Protocol Code is not shown on Agfa CR whereas they do exist in the database.
Please also guide me about the OBR,4.0 and PID,5 stuff that comes in the end of worklist table. If i want to add more columns in the worklist table will you please guide me.
--HM