6
一致性系数 = (2620/5000 + 3893/5000 + 25980/26000) / 3
= (0.524 + 0.7786 + 0.99923) / 3
= 0.76727666666
数据库查询(ORACLE):
患者性别:
T1=5000
C1=2620
数据库查询(ORACLE):
T1:
SELECT COUNT(*) FROM LABAPP_MASTER
WHERE TEST_TIME BETWEEN TO_DATE(‘2018-01-01’,’YYYY-MM-DD’) AND
TO_DATE(‘2018-3-31 23:59:59’,’YYYY-MM-DD HH:MI:SS’);
C1:
SELECT COUNT(*) FROM LABAPP_MASTER A, DICT_SEX B
WHERE A.SEX = B.SEX_NAME AND
A.TEST_TIME BETWEEN TO_DATE(‘2018-01-01’,’YYYY-MM-DD’) AND
TO_DATE(‘2018-3-31 23:59:59’,’YYYY-MM-DD HH:MI:SS’);
标本名称
T2=5000
C2=3893
数据库查询(ORACLE):
T2:
SELECT COUNT(*) FROM LABAPP_MASTER
WHERE TEST_TIME BETWEEN TO_DATE(‘2018-01-01’,’YYYY-MM-DD’) AND
TO_DATE(‘2018-3-31 23:59:59’,’YYYY-MM-DD HH:MI:SS’);
C2:
SELECT COUNT(*) FROM LABAPP_MASTER A, DICT_SPECIMAN B
WHERE A.SPECIMEN = B.ITEM_NAME AND
A.TEST_TIME BETWEEN TO_DATE(‘2018-01-01’,’YYYY-MM-DD’) AND
TO_DATE(‘2018-3-31 23:59:59’,’YYYY-MM-DD HH:MI:SS’);
检验项目名称
T3=26000
C3=25980
数据库查询(ORACLE):
T3:
SELECT COUNT(*) FROM LABAPP_DETAIL
WHERE TEST_TIME BETWEEN TO_DATE(‘2018-01-01’,’YYYY-MM-DD’) AND
TO_DATE(‘2018-3-31 23:59:59’,’YYYY-MM-DD HH:MI:SS’);
C3:
SELECT COUNT(*) FROM LABAPP_DETAIL A, DICT_TEST B
WHERE A.TEST_ITEM = B.ITEM_NAME AND
评论0