*WorkList* Help required please.

Hi,

I need understanding of these highlited fields.

*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, 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 }
}

Actually I am updating the modality worklist table but unable to transfer Reffering Physician Name infomation to modality.

Regards;

Hi,

I am new in this technology so i am questioning again. i google but unable to understand.
In ur mentioned link;

{ 0x0008, 0x0090, "ReferringPhysician", 64, SQL_C_CHAR, DT_STR, "---" },

And clear (reinit) the worklist database. At the --- entry the HL7 location can be set if any.

i have updated the dicom.sql for "ReferringPhysician" and reiniatilized the database. Please help me to writing up information here "---".

Regards;

Hi,

This is the status log after adding refferring physician in dicomworklist dicom.sql..

[DEVELOPER] Issue Query on Columns: DICOMWorkList.AccessionN, DICOMWorkList.ReferringP,
DICOMWorkList.PatientNam, DICOMWorkList.PatientID, DICOMWorkList.PatientBir,
DICOMWorkList.PatientSex, DICOMWorkList.MedicalAle, DICOMWorkList.StudyInsta,
DICOMWorkList.ReqProcDes, DICOMWorkList.Modality, DICOMWorkList.ReqContras,
DICOMWorkList.StartDate, DICOMWorkList.StartTime, DICOMWorkList.SchedPSDes,
DICOMWorkList.SchedPSID, DICOMWorkList.ReqProcID, DICOMWorkList.ReqProcPri
[DEVELOPER] Values: DICOMWorkList.PatientNam LIKE '%' and DICOMWorkList.PatientID =
'AD-82-29' and DICOMWorkList.StartDate >= '20110717' and DICOMWorkList.StartDate <=
'20110720'
[DEVELOPER] Tables: DICOMWorkList
[DEVELOPER] Sorting (DICOMWorkList.PatientNam) DoSort := 1
[DEVELOPER] Query Distinct Tables: DICOMWorkList
[DEVELOPER] Columns : DICOMWorkList.AccessionN, DICOMWorkList.ReferringP,
DICOMWorkList.PatientNam, DICOMWorkList.PatientID, DICOMWorkList.PatientBir,
DICOMWorkList.PatientSex, DICOMWorkList.MedicalAle, DICOMWorkList.StudyInsta,
DICOMWorkList.ReqProcDes, DICOMWorkList.Modality, DICOMWorkList.ReqContras,
DICOMWorkList.StartDate, DICOMWorkList.StartTime, DICOMWorkList.SchedPSDes,
DICOMWorkList.SchedPSID, DICOMWorkList.ReqProcID, DICOMWorkList.ReqProcPri
[DEVELOPER] Where : DICOMWorkList.PatientNam LIKE '%' and
DICOMWorkList.PatientID = 'AAAAAAAA' and DICOMWorkList.StartDate >= '20110717' and
DICOMWorkList.StartDate <= '20110720'
[DEVELOPER] Order : DICOMWorkList.PatientNam
[DEVELOPER] ***Error: Unknown column 'DICOMWorkList.ReferringP' in 'field list'
[DEVELOPER] C-Find (Modality Work List) located 0 records
[DEVELOPER] UPACS THREAD 12: ENDED AT: Tue Jul 19 10:07:36 2011
[DEVELOPER] UPACS THREAD 12: TOTAL RUNNING TIME: 0 SECONDS

Please help me how to solve this issue.

Regards;

Hi,

Thanks alot. Issue Solved.

Regards;