---

[WL_DAO]
DEL_SQL=delete from solution_lab.instrument_work_list where id \= \:ID
GROUP_DEV_COMMANDS=false
SQL=SELECT ls.id                                AS ID\n      \
,ld.code                              AS DEV_CODE\n      \
,dt.wl_code                           AS DEV_COMMAND\n      \
,ls.id                                AS RESEARCH_ID\n      \
,ls.ids                               AS IDS\n      \
,s.code                               AS SPECIMEN_CODE\n  \
FROM nlab.lab_sample  ls\n      \
,nlab.test_result tr\n      \
,nlab.device_test dt\n      \
,nlab.lab_device  ld\n      \
,nlab.specimen    s\n \
WHERE tr.lab_sample_id \= ls.id\n   \
AND dt.test_id       \= tr.lab_test_id\n   \
AND dt.device_id     \= ld.id\n   \
AND ls.specimen_id   \= s.id\n   \
AND ls.ids           \= \:OBR2\n   \
AND ld.code          \= \:DEV_CODE\n   \
AND dt.wl_code IS NOT NULL
TYPE=DATABASE
[WL_FORMATTER]
DSP_21=IDS
DSP_24=CITO
DSP_26=SPECIMEN_CODE
DSP_3=LAST_NAME
DSP_4=BIRTH_DATE
DSP_5=SEX
DSP_SIZE=28
FORCED_ENCODE_1=MSH-21
FORCED_ENCODE_10=QRF-10
FORCED_ENCODE_11=DSC-2
FORCED_ENCODE_12=DSP-6
FORCED_ENCODE_2=QAK-3
FORCED_ENCODE_3=MSA-7
FORCED_ENCODE_4=OBR-46
FORCED_ENCODE_5=OBX-18
FORCED_ENCODE_6=QRD-13
FORCED_ENCODE_7=PID-31
FORCED_ENCODE_8=ERR-2
FORCED_ENCODE_9=DSP-3-4
TYPE=HL7_DSR