select '' ||(select '<?xml version="1.0" encoding="UTF-8"?>
<ClinicalDocument xmlns="urn:hl7-org:v3" xmlns:mif="urn:hl7-org:v3/mif" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="urn:hl7-org:v3 ..\sdschemas\SDA.xsd">
<realmCode code="CN"/>
<typeId root="2.16.840.1.113883.1.3" extension="POCD_MT000040"/>
<templateId root="2.16.156.10011.2.1.1.66"/>
<!-- 文档流水号 -->
<id root="2.16.156.10011.1.1" extension="1559727806"/>
<code code="C0046" codeSystem="2.16.156.10011.2.4" codeSystemName="卫生信息共享文档编码体系"/>
<!--title-->
<title>术前小结</title>
<!-- 文档机器生成时间 -->
<effectiveTime value="'||replace( replace(replace( created_date::varchar(60),'-',''),' ',''),':','')::varchar(14)||'"/>
<confidentialityCode code="N" codeSystem="2.16.840.1.113883.5.25" codeSystemName="Confidentiality" displayName="正常访问保密级别"/>
<languageCode code="zh-CN"/>
<setId/>
<versionNumber/>'
from emr_apply_file where treat_id='716199974265839616' and ID like 'cc970d21d8a249c3ae2e560b4d0c0b25' and COALESCE(del_flag, '') != '1' )
||
(select '<recordTarget typeCode="RCT" contextControlCode="OP">
<patientRole classCode="PAT">
<!--住院号标识-->
<id root="2.16.156.10011.1.12" extension="'||vae94||'"/>
<patient classCode="PSN" determinerCode="INSTANCE">
<!--患者身份证号标识-->
<id root="2.16.156.10011.1.3" extension="'||VAA15||'"/>
<name>'||vaa05||'</name>
<administrativeGenderCode code="'||vaa1.abw01::text||'" codeSystem="2.16.156.10011.2.3.3.4" codeSystemName="生理性别代码表(GB/T 2261.1)" displayName="'||abw02||'性" />
<!--1数据集里是年龄（年）、年龄（月）-->
<age unit="'||aau1.aau02||'" value="'||vaa10||'"></age>
</patient>
</patientRole>
</recordTarget>' from vae1 join vaa1 on vae1.vaa01=vaa1.vaa01
join abw1 on vaa1.abw01=abw1.abw01
join aau1 on vaa1.aau01=aau1.aau01
where vae01='716199974265839616')||
(select '
<author typeCode="AUT" contextControlCode="OP">
<!-- DE09.00.053.00 记录日期时间 完成此项业务活动时的公元纪年日期和时间的完整描述 -->
<time value="'||replace( replace(replace( write_time::varchar(60),'-',''),' ',''),':','')::varchar(14)||'"/>
<assignedAuthor classCode="ASSIGNED">
<id root="2.16.156.10011.1.7" extension="'||write_author_id||'"/>
<assignedPerson>
<name>'||author||'</name>
</assignedPerson>
</assignedAuthor>
</author>'
from emr_apply_file where treat_id='716199974265839616' and ID like 'cc970d21d8a249c3ae2e560b4d0c0b25' and COALESCE(del_flag, '') != '1' )||
(select '
<custodian typeCode="CST">
<assignedCustodian classCode="ASSIGNED">
<representedCustodianOrganization classCode="ORG" determinerCode="INSTANCE">
<id root="2.16.156.10011.1.5" extension="41734607-4"/>
<name>安阳市肿瘤医院</name>
</representedCustodianOrganization>
</assignedCustodian>
</custodian>
')||
(select '
<authenticator>
<!--签名日期时间-->
<time/>
<signatureCode/>
<assignedEntity>
<id root="2.16.156.10011.1.4" extension="'||ven1.bce01::text||'"/>
<code displayName="手术者"/>
<assignedPerson>
<name>'||ven1.bce03||'</name>
</assignedPerson>
</assignedEntity>
</authenticator>
' from ven1 join bce1 on bce1.bce01=ven1.bce01
where vaq01 in (select id from emr_apply_file where treat_id='716199974265839616' and ID like 'cc970d21d8a249c3ae2e560b4d0c0b25' and COALESCE(del_flag, '') != '1')
order by aah01
limit 1)||
(select '
<authenticator>
<!--签名日期时间-->
<time/>
<signatureCode/>
<assignedEntity>
<id root="2.16.156.10011.1.4" extension="'||ven1.bce01::text||'"/>
<code displayName="医师"/>
<assignedPerson>
<name>'||ven1.bce03||'</name>
</assignedPerson>
</assignedEntity>
</authenticator>
'
from ven1 join bce1 on bce1.bce01=ven1.bce01
join aah1 on bce1.aah01=aah1.aah01
where vaq01 in (select id from emr_apply_file where treat_id='716199974265839616' and ID like 'cc970d21d8a249c3ae2e560b4d0c0b25' and COALESCE(del_flag, '') != '1')
order by bce1.aah01 desc
limit 1
)||
(select '<participant typeCode="NOT">
<!--联系人@classCode：CON，固定值，表示角色是联系人 -->
<associatedEntity classCode="ECON">
<!--联系人电话-->
<telecom value="'||VAE71||'"/>
<!--联系人-->
<associatedPerson>
<!--姓名-->
<name>'||VAE68||'</name>
</associatedPerson>
</associatedEntity>
</participant>
<relatedDocument typeCode="RPLC">
<parentDocument>
<id/>
<setId/>
<versionNumber/>
</parentDocument>
</relatedDocument>' from vae1 join vaa1 on vae1.vaa01=vaa1.vaa01
join abw1 on vaa1.abw01=abw1.abw01
join aau1 on vaa1.aau01=aau1.aau01
where vae01='716199974265839616')||
(select '
<componentOf>
<encompassingEncounter>
<!--记录日期时间-->
<effectiveTime xsi:type="IVL_TS" value="'|| replace( replace(replace( created_date::varchar(60),'-',''),' ',''),':','')::varchar(14)||'"/>
<location>
<healthCareFacility>
<serviceProviderOrganization>
<asOrganizationPartOf classCode="PART">
<!-- DE01.00.026.00 病床号 -->
<wholeOrganization classCode="ORG" determinerCode="INSTANCE">
<id root="2.16.156.10011.1.22" extension="'||bcq1.bcq01::text||'"/>
<name>'||to_char( BCQ04B::int,'000')||'</name>
<!-- DE01.00.019.00 病房号 -->
<asOrganizationPartOf classCode="PART">
<wholeOrganization classCode="ORG" determinerCode="INSTANCE">
<id root="2.16.156.10011.1.21" extension="'||bck01c||'"/>
<name>'||bck1.bck03||'</name>
<!-- DE08.10.026.00 科室名称 -->
<asOrganizationPartOf classCode="PART">
<wholeOrganization classCode="ORG" determinerCode="INSTANCE">
<id root="2.16.156.10011.1.26" extension="'||bck01d::text||'"/>
<name>'||bck2.bck03||'</name>
<!-- DE08.10.054.00 病区名称 -->
<asOrganizationPartOf classCode="PART">
<wholeOrganization classCode="ORG" determinerCode="INSTANCE">
<id root="2.16.156.10011.1.27" extension="'||bck01c::text||'"/>
<name>'||bck1.bck03||'</name>
<!--XX医院 -->
<asOrganizationPartOf classCode="PART">
<wholeOrganization classCode="ORG" determinerCode="INSTANCE">
<id root="2.16.156.10011.1.5" extension="41734607-4"/>
<name>安阳市肿瘤医院</name>
</wholeOrganization>
</asOrganizationPartOf>
</wholeOrganization>
</asOrganizationPartOf>
</wholeOrganization>
</asOrganizationPartOf>
</wholeOrganization>
</asOrganizationPartOf>
</wholeOrganization>
</asOrganizationPartOf>
</serviceProviderOrganization>
</healthCareFacility>
</location>
</encompassingEncounter>
</componentOf>' from vae1
join bcq1 on bcq1.bck01a=vae1.bck01c and bcq1.bck01b=vae1.bck01d and bcq1.bcq04= vae1.BCQ04B
join bck1 on vae1.bck01c= bck1.bck01
join bck1 bck2 on bck2.bck01=vae1.bck01d
join emr_apply_file on treat_id='716199974265839616' and ID like 'cc970d21d8a249c3ae2e560b4d0c0b25' and COALESCE(del_flag, '') != '1'
where vae01='716199974265839616' )||
(select '<component>
<structuredBody classCode="DOCBODY" moodCode="EVN">
<!--病历摘要章节-->
<component>
<section>
<code code="DE06.00.182.00" codeSystem="2.16.156.10011.2.2.1" codeSystemName="卫生信息数据元目录" displayName="病历摘要"/>
<text><![CDATA['||CONTENT||']]></text>
</section>
</component>'
from emr_app_element
where element_name in ('病历摘要')
and apply_file_id in (select id from emr_apply_file where treat_id='716199974265839616' and ID like 'cc970d21d8a249c3ae2e560b4d0c0b25' and COALES
评论10