湘潭市中心医院电子病历五级数据质量材料2021【CP20210909】十、信息利用.docx
《湘潭市中心医院电子病历五级数据质量材料2021【CP20210909】十、信息利用.docx》由会员分享,可在线阅读,更多相关《湘潭市中心医院电子病历五级数据质量材料2021【CP20210909】十、信息利用.docx(37页珍藏版)》请在得力文库 - 分享文档赚钱的网站上搜索。
1、十、信息利用临床数据整合序号项目代码业务项目数据质量考察项目1临床数据整合一致性:1、住院病案首页(出院诊断编码、门诊诊断、手术操作编码、性别)2、门诊 病案记录(门诊诊断)2、门诊病案记录(门诊诊断)(1.1)一致性:住院病案首页(出院诊断编码、门诊诊断、手术操作编码、性别) 计算方法:要求项目住院病案首页表与字段字典表与字段总数符合记录数系数说明出院诊断编码Ba zdlr. zdbmGY JBBM. ICD9Tl=245920Cl=2459201门诊诊断编码Ba brsy. mzzdbmGY JBBM. TCD9T2=23621C2=236211手术操作编码Ba brss. ssdmGY
2、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-011YYYY-MM-DD) ANDTO_DATE(12021-05-31 23:59:59,YYYY-MM-DD hh24
3、: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、PATI
4、ENT_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 检查项目不为
5、空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
6、_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
7、=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/T
8、l +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.
9、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.H
10、YID 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 =4AND B.Doctadviseno in (SELECT B.Doctadviseno FROM L_LIS_SQD Al,L_LIS_SQDMX B3 ,L_HY
11、XM 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.
12、YLXH = B3.YLXHAND Al.REQUESTTIME =TO_DATE(,2021-03-01 *, YYYY-MM-DD1)AND Al.REQUESTTIME =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 = B
13、3.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 =4AND B.Doctadviseno in (SELECT B.Doctad
14、viseno 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 A
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- CP20210909 湘潭市 中心医院 电子 病历 级数 质量 材料 2021 信息 利用
限制150内