+=======================================+
| WorkList服务（列表服务）高级配置说明  |
+=======================================+

一、Study表字段与DICOM标签的映射关系

WorkList服务从Study表中读取信息并填写到DICOM标签中，然后发送到检查设备。
下面列出了WorkList服务支持的全部DICOM标签及其对应Study表字段的映射关系：

----------------------------------------------------------
DICOM标签（字段）                   Study表字段（别名）
----------------------------------------------------------
TAG_SPECIFIC_CHARACTER_SET          character_set
----------------------------------------------------------
TAG_SCHEDULED_STATION_AE_TITLE      schedule_aetitle
TAG_SCHEDULED_PROCEDURE_STEP_START_DATE schedule_dttm/schedule_date
TAG_SCHEDULED_PROCEDURE_STEP_START_TIME schedule_dttm/schedule_time
TAG_MODALITY                        modality
TAG_SCHEDULED_PERFORMING_PHYSICIAN_NAME schedule_physician
TAG_PERFORMING_PHYSICIAN_NAME       performing_physician
TAG_SCHEDULED_PROCEDURE_STEP_DESCRIPTION schedule_description
TAG_SCHEDULED_STATION_NAME          schedule_station
TAG_SCHEDULED_PROCEDURE_STEP_LOCATION schedule_location
TAG_PRE_MEDICATION                  pre_medication
TAG_SCHEDULED_PROCEDURE_STEP_ID     schedule_id
TAG_REQUESTED_CONTRAST_AGENT        request_agent
TAG_SCHEDULED_PROCEDURE_STEP_STATUS schedule_status
----------------------------------------------------------
TAG_REQUESTED_PROCEDURE_ID          request_id
TAG_REQUESTED_PROCEDURE_DESCRIPTION request_description
TAG_STUDY_INSTANCE_UID              study_instance_uid
TAG_STUDY_ID                        study_id
TAG_STUDY_DESCRIPTION               study_description
TAG_REQUESTED_PROCEDURE_PRIORITY    request_priority    
TAG_PATIENT_TRANSPORT_ARRANGEMENTS  patient_arrangements
----------------------------------------------------------
TAG_ACCESSION_NUMBER                accession_number
TAG_REQUESTING_PHYSICIAN            requesting_physician
TAG_REFERRING_PHYSICIAN_NAME        referring_physician
----------------------------------------------------------
TAG_ADMISSION_ID                    admission_id
TAG_CURRENT_PATIENT_LOCATION        current_location
----------------------------------------------------------  
TAG_PATIENT_NAME                    patient_name
TAG_PATIENT_ID                      patient_id
TAG_PATIENT_BIRTH_DATE              patient_birthday/patient_birth_date
TAG_PATIENT_BIRTH_TIME              patient_birthday/patient_birth_time
TAG_PATIENT_AGE                     patient_age
TAG_PATIENT_SEX                     patient_sex
TAG_PATIENT_WEIGHT                  patient_weight
TAG_PATIENT_SIZE                    patient_height
TAG_CONFIDENTIALITY_CONSTRAINT_ON_PATIENT_DATA_DESCRIPTION confidentiality
TAG_PATIENT_STATE                   patient_state
TAG_PREGNANCY_STATUS                pregnancy_status
TAG_MEDICAL_ALERTS                  medical_alerts
TAG_CONTRAST_ALLERGIES              contrast_allergies
TAG_SPECIAL_NEEDS                   special_needs
----------------------------------------------------------

注意事项：
1.如果Study表中不存在某字段，请使用“select...Study表字段 as 别名...”句式映射。
2.如果想指定某个字段为一个固定值，必须使用“select...字段名=值...”句式映射!
3.其中schedule_date和patient_birth_date字段必须满足类似“20100514”格式；
4.其中schedule_time和patient_birth_time字段必须满足类似“142305”格式；
////
5. 配置worklist查询语句时，where条件子句必须使用小括号全部包括起来。
   例如：where (report_state = 0 and (study_state = 0 or study_state is null)) ...
6. WorkList服务程序会自动在查询语句where条件子句后无条件添加产品类型过滤。
   例如：如果产品类型配置为XR（即AppBox.ini配置文件中sModality=XR），那么最终的查询语句where条件子句中将包括“study_modalitytype = 'DX'”类似语句。
7. 如果设备发送worklist请求中包括modality属性，并且worklist查询语句中配置了modality字段 ，那么WorkList服务程序会自动在查询语句where条件子句后添加对应的查询条件。
   例如：DR设备worklist请求中包括modality='DX', 并且worklist查询语句中有study_examkind as modality类似语句，那么最终的查询语句where条件子句中将包括“study_examkind = 'DX'”类似语句。


二、典型的WorkList服务配置参数

1. [GE LightSpeed16 CT]
select study_key,patient_name,patient_guid as patient_id,study_instance as study_instance_uid,study_modalityname as schedule_aetitle,study_dttm as schedule_dttm,schedule_id='0',request_id='0',study_ordinal as accession_number,study_examkind as modality,referring_physician='',patient_birthday,patient_sex,patient_weight,medical_alerts='',contrast_allergies='',pregnancy_status='',requesting_physician='',request_agent='',admission_id='',special_needs='',current_location='',patient_state='',performing_physician='',schedule_station='',schedule_location='',pre_medication='',request_priority='',patient_arrangements='',confidentiality='',patient_studyage as patient_age from study where (study_state is null or study_state=0) and report_state=0

2. 略。



<END>