湘潭市中心医院电子病历五级数据质量材料2021【CP20210909】十、信息利用.docx
十、信息利用临床数据整合序号项目代码业务项目数据质量考察项目1临床数据整合一致性：1、住院病案首页（出院诊断编码、门诊诊断、手术操作编码、性别）2、门诊 病案记录（门诊诊断）2、门诊病案记录（门诊诊断）（1.1）一致性：住院病案首页（出院诊断编码、门诊诊断、手术操作编码、性别） 计算方法：要求项目住院病案首页表与字段字典表与字段总数符合记录数系数说明出院诊断编码Ba zdlr. zdbmGY JBBM. ICD9Tl=245920Cl=2459201门诊诊断编码Ba brsy. mzzdbmGY JBBM. TCD9T2=23621C2=236211手术操作编码Ba brss. ssdmGY SSDM. SSDMT3=38002C3=380021性别编码Ba brda. brxbGY DMZD. DMSBT4=23621C4=236211住院病案首页（出院诊断编码）:出院诊断编码记录数字典对照125. 1034835有110.x00x0324413有K76.0004089有N40. xOO3734有E78. 5003632有 有FROM T_PAT_EXAMREPORT TWHERE T.CREATETIME BETWEEN TO_DATE(12021-03-011'YYYY-MM-DD') ANDTO_DATE(12021-05-31 23:59:59，'YYYY-MM-DD hh24:mi:ss,)SQL 注释：1、T_PAT_EXAMREPORT 检查信息表；2、CREATETIME 报告日期；NL患者标识SELECT COUNT(*)FROM T_PAT_EXAMREPORT TWHERE T.CREATETIME BETWEEN TO_DATE(12021-03-011, 'YYYY-MM-DD') ANDTO_DATE(12021-05-31 23:59:591 'YYYY-MM-DD hh24:mi:ss,)AND T.PATIENT_ID IS NOT NULLSQL注释：1、T_PAT_EXAMREPORT检查信息表；2、CREATETIME报告日期；3、PATIENT_ID病人唯一编号不为空；N2：检查项目SELECT COUNT(*)FROM T_PAT_EXAMREPORT TWHERE T.CREATETIME BETWEEN TO_DATE(*2021-03-011, 'YYYY-MM-DD1) ANDTO_DATE(12021-05-31 23:59:59、 'YYYY-MM-DD hh24:mi;ss*)ANDT.UNIVERSAL_SERVICE_NAME IS NOT NULL;SQL 注释：1、T_PAT_EXAMREPORT 检查信息表；2、CREATETIME 报告日期；3、UNIVERSAL_SERVICE_NAME 检查项目不为空N3:检查结论SELECT COUNT(*)FROM T_PAT_EXAMREPORT TWHERE T.CREATETIME BETWEEN TO_DATE('2021-03-01 * z 'YYYY-MM-DD*) ANDTO DATE(12021-05-31 23:59:59', 'YYYY-MM-DD hh24:mi:ss*)AND T.EXAM_DIAG_DESC IS NOT NULLSQL注释：1、T_PAT_EXAMREPORT检查信息表；2、CREATETIME报告日期；3、EXAM_DIAG_DESC检查结论不为空;N4:检查时间SELECT COUNT(*)FROM T_PAT_EXAMREPORT TWHERE T.CREATETIME BETWEEN TO_DATE(12021-03-011z 'YYYY-MM-DD') ANDTO_DATE(*2021-05-31 23:59:59', 'YYYY-MM-DD hh24:mi:ss,)AND T.CREATETIME IS NOT NULLSQL注释：1、T_PAT_EXAMREPORT检查信息表；2、CREATETIME报告日期不为空；（L3）完整性：检验报告（患者标识、检验项目、结果、参考范围、检验时间） 计算方法：要求项目对应表字段总数符合记录数系数说明患者标识L_PATIENTINFO. PATIENTIDTl=5716606Nl=57166061检验项目L_TESTRESULT. TESTID12=5716606N2=57166061结果l_testresult. TESTRESULTT3=5716606N3=57166061参考范围L_TESTRESULT. REFLO, L_TESTRESULT. REF1U14=5716606N4=53425340. 9366部分项目无参考值，例如血型、 阴性阳性等检验时间L_PAT1ENTINFO. C1IECKTIME15=5716606N5=57166061统计时间范围为2021-3-1至2021-5-31共三个月的数据，n=50完整性系数=(Nl/Tl +N2/T2+Nn/Tn) /n二(5716606/5716606+5716606/5716606+5716606/5716606+4550630/5716606+5716606/5716606)/5= (l+l+l+0. 9366+1)/5=0. 9873T1T5:记录总数SELECT COUNT(*)FROM(SELECT B.PATIENTID,a.testid,a.testresult, A.REFLO | | '一' | |A.REFHI referencevalues,a.MEASURETIMEFROM L_TESTRESULT A zL_PATIENTINFO BWHERE A.SAMPLENO = B.SAMPLENO and b.resultstatus>=4AND B.Doctadviseno in (SELECT B.Doctadviseno FROM L_LIS_SQD Al,L_LIS_SQDMX B3 z L_HYXM B5,L_JYTMXX B,L_JYTMXX_MX B2 WHERE Al.STAYHOSPITALMODE in (1,2) AND B3.DOCTREQUESTNO=A1.DOCTREQUESTNO AND B.doctadviseno = B3.doctadviseno AND B3.ZXPB = 1 AND B5.HYID=B3.HYID AND B3.JGID = 1 AND B2.doctadviseno = B.doctadviseno AND B2.HYID = B5.HYID AND B2.DOCTREQUESTNO=A1.DOCTREQUESTNO AND B2.YLXH = B3.YLXH AND Al.REQUESTTIME >=TO_DATE(12021-03-01 * z1YYYY-MM-DD1) AND Al.REQUESTTIME <TO_DATE(*2021-06-011, 1YYYY-MM-DD*);注释：L_PAT工ENT工NFO表为检验报告主记录表主要记录病人资料等基本信息，其中STAYHOSP工TALMODE字段为病人类型(1为门诊，2为住院),result status 为报告状态4为已审核，PATIENTID为患者唯一标识患者号码，通过sampleno与L_TESTRESULT检验结果明细表关联，MEASURETIME为结果表检测时间， TestResult为检验结果，ref lo为参考下限，refhi为参考上限，如果为字符或者阴阳性参考数据存入ref lo字段，通过条码号doctadviseno与L_JYTMXX 检验条码记录主表关联,TEST工D为L_TESTRESULT检验结果明细表的检测项目工D,通过该字段与l_testdescribe检验项目基础表进行关联,chinesename 为检验项目基础表的检验项目中文名称字段，医院使用软件为多机构版本，所有基础表和业务表均包含机构工D(JG工D)字段，其中1为湘潭市中心医院。N1：患者标识SELECT COUNT (*)FROM(SELECT B.PATIENTIDFROM L_TESTRESULT A ,L_PATIENTINFO BWHERE A.SAMPLENO = B.SAMPLENO and b.resultstatus>=4AND B.Doctadviseno in (SELECT B.Doctadviseno FROM L_LIS_SQD Al,L_LIS_SQDMX B3 ,L_HYXM B5Z L_JYTMXX Bz L_JYTMXX_MX B2 WHERE Al.STAYHOSPITALMODE in (1,2) AND B3.DOCTREQUESTNO=A1.DOCTREQUESTNO AND B.doctadviseno = B3.doctadviseno AND B3.ZXPB = 1 AND B5.HYID=B3.HYID AND B3.JGID = 1 AND B2.doctadviseno = B.doctadviseno AND B2.HYID = B5.HYID AND B2.DOCTREQUESTNO=A1.DOCTREQUESTNO AND B2.YLXH = B3.YLXHAND Al.REQUESTTIME >=TO_DATE(,2021-03-01 *, 'YYYY-MM-DD1)AND Al.REQUESTTIME <TO_DATE(,2021-06-011, *YYYY-MM-DD1)and B.PATIENTID is not null );注释:L_PAT工ENT工NFO表为检验报告主记录表主要记录病人资料等基本信息，其中STAYHOSP工TALMODE字段为病人类型(1为门诊,2为住院),resultstatus 为报告状态4为已审核，PAT工ENT工D为患者唯一标识患者号码，通过条码号doctadvisen。与L_JYTMXX检验条码记录主表关联，医院使用软件为多机构版 本，所有基础表和业务表均包含机构工D(JG工D)字段，其中1为湘潭市中心医院。N2：检验报告项目SELECT COUNT(*)FROM(SELECT a.testidFROM L_TESTRESULT A ,L_PAT工ENT工NFO BWHERE A.SAMPLENO = B.SAMPLENO and b.resultstatus>=4AND B.Doctadviseno in (SELECT B.Doctadviseno FROM L_LIS_SQD Al,L_LIS_SQDMX B3 ,L_HYXM B5ZL_JYTMXX B,L_JYTMXX_MX B2 WHERE Al.STAYHOSPITALMODE in (1,2) AND B3.DOCTREQUESTNO=A1.DOCTREQUESTNO AND B.doctadviseno = B3.doctadviseno AND B3.ZXPB = 1 AND B5.HYID=B3.HYID AND B3.JGID = 1 AND B2.doctadviseno = B.doctadviseno AND B2.HYID = B5.HYID AND B2.DOCTREQUESTNO=A1.DOCTREQUESTNO AND B2.YLXH = B3.YLXHAND Al.REQUESTTIME >=TO_DATE(12021-03-01 * z 'YYYY-MM-DD1)AND Al.REQUESTTIME <TO_DATE(12021-06-011, 1YYYY-MM-DD*)and a.testid is not null );注释：L_PAT工ENT工NFO表为检验报告主记录表主要记录病人资料等基本信息，其中STAYHOSP工TALMODE字段为病人类型(1为门诊，2为住院),result status 为报告状态4为已审核，通过条码号doctadviseno与L_JYTMXX检验条码记录主表关联，TESTID为L_TESTRESULT检验结果明细表的检测项目工D,通过 该字段与l_testdescribe检验项目基础表进行关联，chinesename为检验项目基础表的检验项目中文名称字段，医院使用软件为多机构版本，所有基础表 和业务表均包含机构工D(JG工D)字段，其中1为湘潭市中心医院。N3：检验结果SELECT COUNT (*) FROM(SELECT B.PATIENTID,a.testid,a.testresult,A.REFLOI II |A.REFHI referencevalues,a.MEASURETIMEFROM L_TESTRESULT A zL_PATIENTINFO BWHERE A.SAMPLENO = B.SAMPLENO and b.resultstatus>=4AND B.Doctadviseno in (SELECT B.Doctadviseno FROM L_LIS_SQD Al,L_LIS_SQDMX B3 z L_HYXM B5ZL_JYTMXX B,L_JYTMXX_MX B2 WHERE Al.STAYHOSPITALMODE in (1,2) AND B3.DOCTREQUESTNO=A1.DOCTREQUESTNO AND B.doctadviseno = B3.doctadviseno AND B3.ZXPB = 1 AND B5.HYID=B3.HYID AND B3.JGID = 1 AND B2.doctadviseno = B.doctadviseno AND B2.HYID = B5.HYID AND B2.DOCTREQUESTNO=A1.DOCTREQUESTNO AND B2.YLXH = B3.YLXH AND Al.REQUESTTIME >=TO_DATE(,2021-03-011, 'YYYY-MM-DD')AND Al.REQUESTTIME <TO_DATE(*2021-06-011, *YYYY-MM-DD1)and a.testresult is not null );注释：L_PAT：EENT工NFO表为检验报告主记录表主要记录病人资料等基本信息，其中STAYHOSP工TALMODE字段为病人类型(1为门诊，2为住院),resultstatus 为报告状态4为已审核，通过samplen。与LTESTRESULT检验结果明细表关联，TestResult为检验结果，通过条码号doctadviseno与L_JYTMXX检 验条码记录主表关联，医院使用软件为多机构版本，所有基础表和业务表均包含机构工D(JG工D)字段，其中1为湘潭市中心医院。N4:参考范围SELECT COUNT(*) FROM(SELECT B.PATIENTID,a.testid,a.testresult,A.REFLO|'-| |A.REFHI referencevalueS,a.MEASURETIME FROM L_TESTRESULT A z L_PATIENTINFO B WHERE A.SAMPLENO = B.SAMPLENO and b.resultstatus>=4AND B.Doctadviseno in (SELECT B.Doctadviseno FROM L_LIS_SQD Al,L_LIS_SQDMX B3 z L_HYXM B5ZL_JYTMXX B,L_JYTMXX_MX B2 WHERE Al.STAYHOSPITALMODE in (1,2) AND B3.DOCTREQUESTNO=A1.DOCTREQUESTNO AND B.doctadviseno = B3.doctadviseno AND B3.ZXPB = 1 AND B5.HYID=B3.HYID AND B3.JGID = 1 AND B2.doctadviseno = B.doctadviseno AND B2.HYID = B5.HYID AND B2.DOCTREQUESTNO=A1.DOCTREQUESTNO AND B2.YLXH = B3.YLXH AND Al.REQUESTTIME >=TO_DATE(12021-03-01'z1YYYY-MM-DD') AND Al.REQUESTTIME <TO DATE(*2021-06-011, 1YYYY-MM-DD*)and A.REFLO is not null );注释:L_PAT工ENT工NFO表为检验报告主记录表主要记录病人资料等基本信息，其中STAYHOSP工TALMODE字段为病人类型(1为门诊,2为住院),resultstatus 为报告状态4为已审核，通过samplen。与L_TESTRESULT检验结果明细表关联，refl。为参考下限，refhi为参考上限，如果为字符或者阴阳性参考数据 存入reflo字段，通过条码号doctadviseno与L_JYTMXX检验条码记录主表关联，医院使用软件为多机构版本，所有基础表和业务表均包含机构ID (JGID) 字段，其中1为湘潭市中心医院。N5:检验时间SELECT COUNT(*)FROM(SELECT a.MEASURETIMEFROM LJTESTRESULT A zL_PATIENTINFO BWHERE A.SAMPLENO = B.SAMPLENO and b.resultstatus>=4AND B.Doctadviseno in (SELECT B.Doctadviseno FROM L_LIS_SQD Al,L_LIS_SQDMX B3 z L_HYXM B5ZL_JYTMXX B,L_JYTMXX_MX B2 WHERE Al.STAYHOSPITALMODE in (1,2) AND B3.DOCTREQUESTNO=A1.DOCTREQUESTNO AND B.doctadviseno = B3.doctadviseno AND B3.ZXPB = 1 AND B5.HYID=B3.HYID AND B3.JGID = 1 AND B2.doctadviseno = B.doctadviseno AND B2.HYID = B5.HYID AND B2.DOCTREQUESTNO=A1.DOCTREQUESTNO AND B2.YLXH = B3.YLXH AND Al.REQUESTTIME >=TO_DATE(12021-03-01', 1YYYY-MM-DD') AND Al.REQUESTTIME <TO_DATE(*2021-06-011, *YYYY-MM-DD1) and a.MEASURETIME is not null);注释:L PATIENT工NFO表为检验报告主记录表主要记录病人资料等基本信息，其中STAYHOSPITALMODE字段为病人类型(1为门诊,2为住院),resultstatus 为报告表态4为己审核，通过sampleno与L_TESTRESULT检验结果明细表关联,MEASURET工ME为结果表检测时间，通过条码号doctadviseno与L_JYTMXX 检验条码记录主表关联，医院使用软件为多机构版本，所有基础表和业务表均包含机构工D(JG工D)字段，其中1为湘潭市中心医院。(1.4)完整性：医嘱记录(患者标识、医嘱代码、医嘱开始时间) 计算方法：要求项目对应表字段总数符合记录数系数说明患者标识EMR_YZB. ZYHTl=2520258Nl=25202581医嘱代码EMR_YZB. XMIDT2=2520258N2=25202581医嘱开始时间EMR_YZB. KZSJT3=2520258N3=25202581统计时间范围为2021-3T至2021-5-31共三个月的数据，n=6o完整性系数=(N1/T1+N2/T2+Nn/Tn) /n= (2520258/2520258+2520258/2520258+2520258/2520258) /3=(1+1+1)/3= 1T1T3:记录总数SELECT COUNT(*) FROM EMR_YZBWHERE ZYH IN (SELECT ba_brsy.ZYHFROM ba_brsy WHEREba_brsy.cyrq >= TO_DATE('2021-03-01 * z1YYYY-MM-DD')AND ba_brsy.cyrq< TO_DATE(*2021-06-011z1YYYY-MM-DD,)AND ba_brsy.jgid = 1)AND EMR_YZB.YZZT IN (4,5) and emr_yzb.jgid=l;SQL注释：1、出院患者BA_BRSY (多机构版本，中心医院JGD=1) 2、医嘱表EMR_YZB,医嘱状态YZZT (4已停嘱、5已复核)。N1：病人标识SELECT COUNT(*) FROM EMR_YZBWHERE ZYH IN (SELECT ba_brsy.ZYHFROM ba_brsy WHEREba_brsy.cyrq >= TO_DATE(,2021-03-011z1YYYY-MM-DD')AND ba_brsy.cyrq< TO_DATE(12021-06-011,1YYYY-MM-DD1)AND ba_brsy.jgid = 1)AND EMR_YZB.YZZT IN (4,5) and emr_yzb.jgid=lAND EMR_YZB.ZYH IS NOT NULL;SQL注释：1、出院患者BA_BRSY (多机构版本，中心医院JG工D=1) 2、医嘱表EMR_YZB,医崛状态YZZT (4已停嘱、5已复核)。3、住院号字段ZYH不为空N2：医嘱代码SELECT COUNT(*) FROM EMR YZBWHERE ZYH IN (SELECT ba_brsy.ZYHFROM ba_brsy WHEREba_brsy.cyrq >= TO_DATE(,2021-03-011,1YYYY-MM-DD')AND ba_brsy.cyrq< TO_DATE(*2021-06-011z1YYYY-MM-DD*)AND ba_brsy.jgid = 1)AND EMR_YZB.YZZT IN (4,5) and emr_yzb.jgid=lAND EMR_YZB.XMID is not null ;SQL注释：1、出院患者BA_BRSY (多机构版本，中心医院JG工D=1) 2、医咽表EMR_YZB,医崛状态YZZT (4已停咂、5已复核)。3、项目工D字段XM工D不为空N3：医嘱开始时间 SELECT COUNT(*) FROM EMR_YZB WHERE ZYH IN (SELECT ba_brsy.ZYH FROM ba_brsy WHERE ba_brsy.cyrq >= TO_DATE('2021-03-01*,YYYY-MM-DD') AND ba_brsy.cyrq< TO_DATE(,2021-06-011,'YYYY-MM-DD*) AND ba_brsy.jgid = 1) AND EMR_YZB.YZZT IN (4,5) and emr_yzb.jgid=l AND EMR_YZB.KZSJ is not null ;SQL注释：1、出院患者BA_BRSY (多机构版本，中心医院JG1D=1) 2、医嘱表EMR_YZB,医嘱状态YZZT (4已停嘱、5已复核)。3、开嘱时间KZSJ不为空(1.5)完整性：体征记录(患者标识、体征项目、测量结果、测量时间) 计算方法：要求项目对应表字段总数符合记录数系数说明患者标识BQ_SMTZ. ZYHTl=2954695Nl=29546951体征项目BQ_TZXM. XMMCT2=2954695N2=29546951测量结果BQ_SMTZ. TZNRT3=2954695N3=29546951测量时间BQ_SMTZ. CJSJT4=2954695N4=29546951统计时间范围为2021-3-1至2021-5-31共三个月的数据，n二4。完整性系数=(N1/T1+N2/T2+Nn/Tn)/n=(2954695/2954695+2954695/2954695+2954695/2954695+2954695/2954695)/4=(l+l+l+l)/4=lT1T4:记录总数SELECT COUNT(*) FROM BQ_SMTZWHERE BQ_SMTZ.ZFBZ = 0AND BQ_SMTZ.ZYH IN (SELECT BA_BRSY.ZYH FROM BA BRSYWHERE BA_BRSY.CYRQ >= TO_DATE(,2021-03-011,'YYYY-MM-DD1)AND BA_BRSY.CYRQ < TO_DATE(*2021-06-01',1YYYY-MM-DD1) AND BA_BRSY.JGID =1);SQL注释：1、出院患者BA_BRSY (多机构版本，中心医院JGD=1) 2、体征记录表BQ_SMTZ,作废标志ZFBZ = 0未作废。N1：患者标识SELECT COUNT(*) FROM BQ_SMTZWHERE BQ_SMTZ.ZFBZ = 0AND BQ_SMTZ.ZYH IN (SELECT BA_BRSY.ZYH FROM BA BRSYWHERE BA_BRSY.CYRQ >= TO_DATE(*2021-03-01 * z 'YYYY-MM-DD*)AND BA_BRSY.CYRQ < TO_DATE(12021-06-01'z1YYYY-MM-DD1) AND BA_BRSY.JGID =1)AND BQ_SMTZ.ZYH IS NOT NULL;SQL注释：1、出院患者BA_BRSY (多机构版本，中心医院JG工D=1) 2、体征记录表BQ_SMTZ,作废标志ZFBZ=0未作废。3、住院号ZYH不为空N2：体征项目SELECT COUNT(*) FROM BQ_SMTZWHERE BQ SMTZ.ZFBZ = 0AND BQ_SMTZ.ZYH IN FROM BA BRSY(SELECT BA_BRSY.ZYHWHERE BA_BRSY.CYRQ >= TO_DATE(,2021-03-011,'YYYY-MM-DD1)AND BA_BRSY.CYRQ < TO_DATE(12021-06-01'z *YYYY-MM-DD1) AND BA_BRSY.JGID =1)AND EXISTS (SELECT * FROM BQ_TZXM WHERE BQ_SMTZ.XMH = BQ_TZXM.XMH);SQL注释：1、出院患者BA_BRSY （多机构版本，中心医院JGD=1） 2、体征记录表BQ_SMTZ,作废标志ZFBZ = 0未作废。3、体征字典表BQ_TZXMN3：测量结果SELECT COUNT(*) FROM BQ_SMTZWHERE BQ_SMTZ.ZFBZ = 0AND BQ_SMTZ.ZYH IN (SELECT BA_BRSY.ZYH FROM BA BRSYWHERE BA_BRSY.CYRQ AND BA_BRSY.CYRQ <>=TO_DATE2021-03-01, 'YYYY-MM-DD1)TO_DATE(12021-06-01'z1YYYY-MM-DD1) AND BA_BRSY.JGID =1)AND BQ_SMTZ.TZNR IS NOT NULL;SQL注释：1、出院患者BA_BRSY （多机构版本，中心医院JG工D=1） 2、体征记录表BQ_SMTZ,作废标志ZFBZ=0未作废。3、体征内容TZNR不为空N4：测量时间SELECT COUNT(*) FROM BQ_SMTZWHERE BQ_SMTZ.ZFBZ = 0AND BQ_SMTZ.ZYH IN (SELECT BA_BRSY.ZYH FROM BA BRSYWHERE BA_BRSY.CYRQ AND BA BRSY.CYRQ <>=TO_DATE(,2021-03-011,'YYYY-MM-DD1)TO DATE(T2021-06-01',1YYYY-MM-DD1) AND BA BRSY.JGID =1)AND BQ_SMTZ.CJSJ IS NOT NULL;SQL注释：1、出院患者BA BRSY （多机构版本，中心医院JG1 D=1） 2、体征记录表BQ SMTZ,作废标志ZFBZ=0未作废。3、测量时间CJSJ不为空门诊诊断记录数字典对照RIO. 402812有C34.900x001721有R42. x00x004688有有合计23621有住院病案首页记录（手术操作编码）：手术操作编码记录数字典对照99.25031625有89.54001225有88.55001132有99.9201704有有合计38003有住院病案首页记录（性别）：性别记录数字典对照男12548有女11075有合计23621有统计时间范围为2021-03-01至2021-05-31共三个月的数据，n=40一致性系数=(T1/C1+T2/C2+T3/C3+T4/C4) /n= (245920/245920+23621/23621+38003/38003+23621/23621)/4=(1+1 + 1+1)/4=1合计245920住院病案首页（门诊诊断）：有T1：select COUNT(*) from ba_brsy A,ba_zdlr B where(2)整合性：同一个患者的医嘱、检查报告、检验报告、手术记录、处方、体征记录中的患者标识能全部与病案首页中患者标识对应 计算方法：要求项目要求项目表与字段患者标识表与字段总数符合记录数系数说明医嘱EMR_YZB. ZYHBA_BRSY. ZYH11=2520258Ll=25202581检查PAT_examreport. PATIENT_IDPAT_VISITNF. PATIENT_1DT2=162594L2=1625941检验L_PATIENTINFO. VISITIDBA_BRSY. ZYHT3=383709L3=3802420. 9910存在少量急查病人直 接输入姓名发放报告手术SM_SSSQ. ZYHBA BRSY. ZYHT4=4519L4=45191药品EMR_YZB. ZYHBA BRSY. ZYHT5=930147L5=9301471体征BQ SMTZ. ZYHBA BRSY. ZYHT6=2954695L6=29546951统计时间范围为2021-3-1至2021-5-31共三个月的数据，片6。整合性系数:=(L1/T1+L2/T2+Ln/Tn)/n=(2182184/2182184+162594/162594+323115/330485+4305/4305+816931/816931+2740125/2740125)/6= (1+1+0. 9910+1+1+1)/6=0. 9982T1:医嘱记录数SELECT COUNT(*) FROM EMR_YZBWHERE ZYH IN (SELECT ba_brsy.ZYHFROM ba_brsy WHEREba_brsy.cyrq >= TO_DATE('2021-03-01*, *YYYY-MM-DD')AND ba_brsy.cyrq< TO_DATE(,2021-06-011z'YYYY-MM-DD1)AND ba_brsy.jgid = 1)AND EMR_YZB.YZZT IN (4,5) and emr_yzb.jgid=l;SQL注释：1、出院患者BA BRSY (多机构版本，中心医院JGJ：D=1) 2、医嘱表EMR YZB,医嘱状态YZZT (4已停嘱、5已复核)。L1:医嘱患者标识：SELECT COUNT(*) FROM EMR_YZB A,BA_BRSY BWHERE A.ZYH = B.ZYHAND B.cyrq >= TO_DATE(12021-03-01', 1YYYY-MM-DD *)AND B.cyrq< TO_DATE('2021-06-011,'YYYY-MM-DD1)AND B.jgid = 1AND A.YZZT IN (4,5) and A.jgid=l;SQL注释：1、出院患者BA_BRSY (多机构版本，中心医院JGD=1) 2、医嘱表EMR_YZB,医崛状态YZZT (4已停嘱、5已复核)。3、可以通过ZYH与BA_BRSY关联。T2:检查记录数select count (*) from T_PAT_examreport a where a.createtime between to_date(,2021-03-01 00:00:00 1z * yyyy-mm-dci HH24:MI:SS') AND to_date(12021-05-31 23:59:59*,'YYYY-MM-DD HH24)SQL注释：1、T_PAT_EXAMREPORT 检查信息表；2、CREATETIME 报告 Fl 期；3、PATIENT_ID 病人唯一编号；L2:检查患者标识select count(*) from T_PAT_examreport a inner join MS_BRDA b on a.PATIENT_ID=b.brid where a.createtime between to_date(12021-03-01 00:00:00',1yyyy-mm-dd HH24:MI:SS') AND to_date(,2021-05-31 23:59:59,1YYYY-MM-DD HH24:M工：SS') SQL注释：1、T_PAT_EXAMREPORT检查信息表；2、MS_BRDA 病人信息表；3、CREATETIME报告日期；4、PATIENT_ID
