数据质控问题说明.docx
1十堰2023年3月逻辑性采集总量和校验总量差距较大2O23O3二tfk色r?机构KRI阵Mf1tMXIFM>KiM15WW*E5fi678365”3822067266.34%296158394366%1818368268%十堰布卫生玄总会41750103668350%171650%-wer=ttanae27709717062641547%14428453%2801641%州市卫生H品会728493660319602968%4M37032%180273%用门用卫生”曷食-180211167%1598833%-访市卫生MB6+食21BIS«8573595996%262039%.Memztewae1297378%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.RECORD0IPTeDAI1YCOURSER0BAijACrER1A1CU1TUREHEADER0Iptjnspectionreport0IPTeHOSPrTA1SETaEMENT0BASENSPECT1oNREPORTH0Ipt-Resu1tsantibiotic3OPT.DEATHRECORDS14BASEeCHECK1IST17IPTeDISCHARGESUMMARY21IPTJHOSP1TA1S1GNSRECORD48；371112FrQmDQKeMTHeCHEeTARGETeRECORDtwheret.organ!zcode-'420000000152,andc.businesssyear2023andc.businesstnonth-3ORDERBY2；前置机库：住院体征记录（体温单）为例，校验过程中，以SOURCE1D字段为业务字段，进行去重，每IOOo条进行一次校验，共计进行48次校验，与数据质控库中的数量一致KIase1ectcount(*)fromIPTH.：§>e1cctD.HEADOR(iNIZATION.×se1ectD.HEADeORGANIZATIONzD.HEADeEFFECTIVETIME,d.SOURCEID,count(1)±roroIPT_HOSPIT1SIGNSRECORDdwhered.headeeffeetIvec1ine>to-date(,202303011z,yyyymrodd,)andd.head_effeetIveciwe<cordate(*20230401,yyyynandd,)andd.scatein(,1'z,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,162542000010382023/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:391600144200000010342023/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.HEAD-ORGAJMIZATION.Xsq输出统计Ise1eccD.HEAD-ORGNIZATION,D.HEAD-EFFECTIVETIMEzd.SOURCEID,count(1)fromIPT-DISCHRGESUHMARY<vhered.head_effeetIvetiroe>to_date(12O23O3O1','yyyym>dd1)andd.head_effeetIvetIme<eo_date(,20230401',yyyyn>dd,)andd.statein('1','2,)groupbyD.HEAD_ORGANIZATIONzD.HEAD_EFFECTIVETIME,d.SOURCEID福噌H6国电/123456789101112131415161718192021HEAD.ORGANIZATIONIHEA0FFECTIVET1MESOURCEIDCOUNT(I)4200000010342023/3/21ft12r121054200000010382023/3/719=1Q59594200000010342023/3/61ft21:23914200000010382023/3/117:25:25414200000010382023/3/6Ie:21:23107420000001«22023/3/117:25:256942000010342023/3/317:33:506342000010342023/3/418t08:21-8042000010342023/3/719:1ft59914200000010382023/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
