数据质控问题说明.docx

《数据质控问题说明.docx》由会员分享，可在线阅读，更多相关《数据质控问题说明.docx（3页珍藏版）》请在第一文库网上搜索。

1、1十堰2023年3月逻辑性采集总量和校验总量差距较大2O23O3二tfk色r?机构KRI阵Mf1tMXIFMKiM15WW*E5fi678365”3822067266.34%296158394366%1818368268%十堰布卫生玄总会41750103668350%171650%-wer=ttanae27709717062641547%14428453%2801641%州市卫生H品会728493660319602968%4M37032%180273%用门用卫生”曷食-180211167%1598833%-访市卫生MB6+食21BIS8573595996%262039%.Memztewae12

2、97378%12489622%)07825%经查询结果如下:逻辑性共计校验12张表，共计103条数据ISW乏QuerydeUAPP_DQM.OQM_CHECKOIC$HWJWRACO1ZS-$CAN1.ZW12.DB：1521/JS10_ZK1屋Se1eCtT.TARGET.RECoRD_NAM云5e1ectTse1ectT.TARGETeRECORDeNXME,T.1JX-DAT-COUNTF口.2)TARGET_REcoRD-NAMEJUX.DATA.COUNT|OPTJEEDETAI10IPT.RECORD0IPTeDAI1YCOURSER0BAijACrER1A1CU1TUREHEAD

3、ER0Iptjnspectionreport0IPTeHOSPrTA1SETaEMENT0BASENSPECT1oNREPORTH0Ipt-Resu1tsantibiotic3OPT.DEATHRECORDS14BASEeCHECK1IST17IPTeDISCHARGESUMMARY21IPTJHOSP1TA1S1GNSRECORD48；371112FrQmDQKeMTHeCHEeTARGETeRECORDtwheret.organ!zcode-420000000152,andc.businesssyear2023andc.businesstnonth-3ORDERBY2；前置机库：住院体征记

4、录（体温单）为例，校验过程中，以SOURCE1D字段为业务字段，进行去重，每IOOo条进行一次校验，共计进行48次校验，与数据质控库中的数量一致KIase1ectcount(*)fromIPTH.：e1cctD.HEADOR(iNIZATION.se1ectD.HEADeORGANIZATIONzD.HEADeEFFECTIVETIME,d.SOURCEID,count(1)roroIPT_HOSPIT1SIGNSRECORDdwhered.headeeffeetIvec1ineto-date(,202303011z,yyyymrodd,)andd.head_effeetIveciwecord

5、ate(*20230401,yyyynandd,)andd.scatein(,1z,2,)groupbyD.HEADeORGANIZATIONzD.HEADeEFFECTIVETIHErd.SOURCEIPa壬C共”国日S“国T.HEAD-ORGANIZATIONHEADjFFECTNETIMEISOURCEIDICOUNT(1)I14200000010342023/3/518:18:19237724200000010382023/3/618:28:09636234200000010382023/3/418:15:18，409144200000821722023/3/719:3242,1625

6、42000010382023/3/218:33:51146864200000010382023/3/719:3242，252174200000010342023/3/117:32:47110184200000821722023/3/117:32477994200000010342023/3/418:15:103219104200000010382023/3/317:42:391468114200000S21722023/3/31742:3992420000021722023/3/418:15:181794200000010342023/3/317:42:39160014420000001034

7、2023/3/618:28:092377154200000010382023/3/518:18:19-4041164200000821722023/3/218:33:51，1901742000010342023/3/218:33:51-2701184200000821722023/3/518:10:19-129194200000821722023/3/618:28:09-221小结出院为例，校验过程中，以SOURCEID字段为业务字段，进行去重，每IoOo条进行一次校验，共计进行21次校验，与数据质控库中的数量一致天团雇用在序se1ectcount(*)fromIPT_H.,.se1ectD.

8、HEAD-ORGAJMIZATION.Xsq输出统计Ise1eccD.HEAD-ORGNIZATION,D.HEAD-EFFECTIVETIMEzd.SOURCEID,count(1)fromIPT-DISCHRGESUHMARYto_date(12O23O3O1,yyyymdd1)andd.head_effeetIvetImedd,)andd.statein(1,2,)groupbyD.HEAD_ORGANIZATIONzD.HEAD_EFFECTIVETIME,d.SOURCEID福噌H6国电/123456789101112131415161718192021HEAD.ORGANIZATI

9、ONIHEA0FFECTIVET1MESOURCEIDCOUNT(I)4200000010342023/3/21ft12r121054200000010382023/3/719=1Q59594200000010342023/3/61ft21:23914200000010382023/3/117:25:25414200000010382023/3/6Ie:21:2310742000000122023/3/117:25:256942000010342023/3/317:33:506342000010342023/3/418t08:21-8042000010342023/3/719:1ft59914

10、200000010382023/3/41&0&21120420000001222023/3/41ft0=2121742000Q1(M22023/3/218:12:12*1894200001W22023/3/618:21:2336142000010342023/3/117:25:25624200000010382023/3/218:12:1210442000010382023/3/317:33:50904200001W22023/3/719:1ft592574200000010382023/3/5iaift56784200000010422023/3/317:33:501204200001M22023/3乃1ft1ft5620442000i0342023/3/51fti5668