I have been trying very hard to get a Siemens Syngo Emotion 16 slice CT to pull the worklist from my linux 1.4.14 worklist server. any bugs in .14? I have no problem adding individual dicom attributes to the dicom.sql and database such as pregnancy status etc. The problem occurs when I try to get into the area of sequences. One of the sequences actually is two deep being inside of the 0040,0100 sequence that comes with conquest by default. Two specific attributes that Siemens Persists on having that i cannot get to work for the life of me are Type 1 0040,0008 SchedProtocolSequence and 0032,1064 ReqProcCodeSequence.
From my research, these contain some Code attributes. I cannot get these to feed properly using a combination of start and end sequences or just adding the attributes and seeing if the order of results just provides the fields to the SCU. I'm thinking it should act similar to the sequence scheduled performed procedure sequence. Does anyone have any working examples or some elaborate or comprehensive dicom.sql files to share? Any help is greatly appreciated. I would like to type a blog up if i can get it working for others to understand with step by step instructions. I'm thinking its possible.
*WorkList*
{
{ 0x0008, 0x0050, "AccessionNumber", 16, SQL_C_CHAR, DT_STR, "OBR.3" },
{ 0x0008, 0x0090, "ReferringPhysiciansName", 64, SQL_C_CHAR, DT_STR, "OBR.16" },
{ 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, 0x1030, "PatientsWeight", 16, SQL_C_CHAR, DT_STR, "---" },
{ 0x0010, 0x2000, "MedicalAlerts", 64, SQL_C_CHAR, DT_STR, "---" },
{ 0x0010, 0x2110, "ContrastAllergies", 64, SQL_C_CHAR, DT_STR, "---" },
{ 0x0010, 0x21c0, "PregnancyStatus", 16, 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", 16, SQL_C_CHAR, DT_STR, "OBR.4.1" },
{ 0x0032, 0x1064, "--------", 0, SQL_C_CHAR, DT_STARTSEQUENCE, "---" },
{ 0x0032, 0x1064, "ReqProcCodeSequence", 16, SQL_C_CHAR, DT_STR, "---" },
{ 0x0008, 0x0100, "CodeValue", 16, SQL_C_CHAR, DT_STR, "---" },
{ 0x0008, 0x0102, "CodeSchDesignator", 16, SQL_C_CHAR, DT_STR, "---" },
{ 0x0008, 0x0103, "CodeSchVersion", 16, SQL_C_CHAR, DT_STR, "---" },
{ 0x0008, 0x0104, "CodeMeaning", 16, SQL_C_CHAR, DT_STR, "---" },
{ 0x0032, 0x1064, "--------", 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" },
{ 0x0040, 0x1004, "PatientTransportArrangements", 16, SQL_C_CHAR, DT_STR, "---" },
{ 0x0040, 0x3001, "ConfidentialityOnPatientDataDescr", 16, SQL_C_CHAR, DT_STR, "---" },
{ 0x0038, 0x0010, "AdmissionID", 16, SQL_C_CHAR, DT_STR, "OBR.3" },
{ 0x0038, 0x0050, "SpecialNeeds", 64, SQL_C_CHAR, DT_STR, "---" },
{ 0x0038, 0x0300, "CurrentPatientLocation", 64, SQL_C_CHAR, DT_STR, "---" },
{ 0x0038, 0x0500, "PatientState", 16, SQL_C_CHAR, DT_STR, "---" },
{ 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, 0x0008, "--------", 0, SQL_C_CHAR, DT_STARTSEQUENCE, "---" },
{ 0x0040, 0x0008, "SchedProtocolSequence", 64, SQL_C_CHAR, DT_STR, "---" },
{ 0x0008, 0x0100, "CodeValue", 16, SQL_C_CHAR, DT_STR, "---" },
{ 0x0008, 0x0102, "CodeSchDesignator", 16, SQL_C_CHAR, DT_STR, "---" },
{ 0x0008, 0x0103, "CodeSchVersion", 16, SQL_C_CHAR, DT_STR, "---" },
{ 0x0008, 0x0104, "CodeMeaning", 16, SQL_C_CHAR, DT_STR, "---" },
{ 0x0040, 0x0008, "---------", 0, SQL_C_CHAR, DT_ENDSEQUENCE, "---" },
{ 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, "---" },