职业病上报
来源：互联网 发布：windows 安装snmp 编辑：程序博客网 时间：2024/04/29 20:45
/****** Object: View [dbo].[V_OHS_BIGQUERYZONG_SD] Script Date: 2016-10-24 07:36:17 ******/ USE [CYYFCheckUpV5]; GO SET ANSI_NULLS ON; GO SET QUOTED_IDENTIFIER ON; GO CREATE VIEW [dbo].[V_OHS_BIGQUERYZONG_SD] AS SELECT T17.CDC_SUOZAIDIQUBIANMA '报告地区-编码', T17.HOSPITALNAME '报告地区-名称', T17.KAIHUZHANGHAO '报告单位-编码', T17.HOSPITALNAME '报告单位-名称', T17.CDC_SUOZAIDIQUBIANMA '职业健康检查机构所在地区-编码', T17.CDC_SUOZAIDIQUMINGCHENG '职业健康检查机构所在地区-名称', T1.SGLCHECKID AS '条码号', T1.ENTERPRICE, T1.SGLCHECKID, T1.REGISTDATE, TB.JOBSTATUS, TB.RISKFACTORS, --T17.CDC_SUOZAIDIQUBIANMA AS '职业健康检查机构所在地区-编码',T17.CDC_SUOZAIDIQUMINGCHENG AS '职业健康检查机构所在地区-名称', T17.CDC_JIGOUBIANMA AS '职业健康检查机构-编码',T17.CDC_JIGOUMINGCHENG AS '职业健康检查机构-名称', T1.REGISTDATE AS '体检时间',TB1.CORPARCHIVENAME AS '用人单位名称', TB1.LINKMANPHONE AS '联系电话',TB1.DIQU AS '所属地区', TB1.DIQUBM AS '所属地区国标', TB1.ADDRESS AS '通讯地址', TB1.ZIPCODE AS '邮编', TB1.NACAO AS '组织机构代码', CASE TB1.SCALEID WHEN '1' THEN '002' WHEN '2' THEN '003' WHEN '3' THEN '004' WHEN '4' THEN '006' WHEN '9' THEN '005' END AS '企业规模-编码', CASE TB1.SCALEID WHEN '1' THEN '大' WHEN '2' THEN '中' WHEN '3' THEN '小' WHEN '4' THEN '微型' WHEN '9' THEN '不详' END AS '企业规模-名称', TB1.PROPID AS '经济类型-编码',TB1.PROPID AS '经济类型-名称',TB1.INDID AS '行业分类-编码',TB1.INDID AS '行业分类-名称',TB1.INDID AS '行业分类-级别', T1.[NAME] AS '姓名', T1.IDCARD AS '身份证号',T1.MOBILEPHONE AS '联系电话（受检者）',TB.JOBSTATUS AS '体检类型-编码', CASE TB.JOBSTATUS WHEN '1' THEN '上岗前职业健康检查' WHEN '2' THEN '在岗期间职业健康检查' WHEN '3' THEN '离岗时职业健康检查' WHEN '4' THEN '离岗后健康检查' WHEN '5' THEN '应急健康检查' END AS '体检类型-名称', T1.SEX AS '性别-编码',CASE T1.SEX WHEN '1' THEN '男' WHEN '2' THEN '女' END AS '性别-名称', T1.BIRTHDATE AS '出生日期', TB.LENGTHOFSERVICESNIAN AS '总工龄-年', TB.LENGTHOFSERVICESYUE AS '总工龄-月', --'90' AS '接触监测的主要职业病危害因素名称-编码', '苯' AS '接触监测的主要职业病危害因素名称-名称', TB.LENGTHOFRISKNIAN AS '职业危害接触工龄-年', TB.LENGTHOFRISKYUE AS '职业危害接触工龄-月', TB.LENGTHOFRISKNIAN AS '接触所监测危害因素工龄-年', TB.LENGTHOFRISKYUE AS '接触所监测危害因素工龄-月', T1.DEPTNO AS '车间',TB.PROFESSIONAL AS '工种-编码',TB.PROFESSIONAL AS '工种-名称', T2.ITEMRESULT AS '血压收缩压结果', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str血压收缩压') AS '血压收缩压计量单位-编码', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str血压收缩压name') AS '血压收缩压计量单位-名称', T3.ITEMRESULT AS '血压舒张压结果', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str血压舒张压') AS '血压舒张压计量单位-编码', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str血压舒张压name') AS '血压舒张压计量单位-名称', T6.ITEMRESULT AS '血常规白细胞计数（WBC）结果', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str血常规白细胞计数') AS '血常规白细胞计数（WBC）计量单位-编码', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str血常规白细胞计数name') AS '血常规白细胞计数（WBC）计量单位-名称', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str血常规白细胞计数低') AS '血常规白细胞计数（WBC）参考范围最小值', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str血常规白细胞计数高') AS '血常规白细胞计数（WBC）参考范围最大值', T7.ITEMRESULT AS '血常规红细胞计数（RBC）结果', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str血常规红细胞计数') AS '血常规红细胞计数（RBC）计量单位-编码', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str血常规红细胞计数name') AS '血常规红细胞计数（RBC）计量单位-名称', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str血常规红细胞计数低') AS '血常规红细胞计数（RBC）参考范围最小值', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str血常规红细胞计数高') AS '血常规红细胞计数（RBC）参考范围最大值', T8.ITEMRESULT AS '血常规血红蛋白（Hb）结果', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str血常规血红蛋白') AS '血常规血红蛋白（Hb）计量单位-编码', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str血常规血红蛋白name') AS '血常规血红蛋白（Hb）计量单位-名称', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str血常规血红蛋白低') AS '血常规血红蛋白（Hb）参考范围最小值', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str血常规血红蛋白高') AS '血常规血红蛋白（Hb）参考范围最大值', T9.ITEMRESULT AS '血常规血小板计数（PLT）结果', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str血常规血小板计数') AS '血常规血小板计数（PLT）计量单位-编码', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str血常规血小板计数name') AS '血常规血小板计数（PLT）计量单位-名称', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str血常规血小板计数低') AS '血常规血小板计数（PLT）参考范围最小值', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str血常规血小板计数高') AS '血常规血小板计数（PLT）参考范围最大值', CASE T10.ITEMRESULT WHEN '-' THEN '0' WHEN '+-' THEN '0.5' WHEN '+' THEN '1' WHEN '++' THEN '2' WHEN '2+' THEN '2' WHEN '+++' THEN '3' WHEN '3+' THEN '3' WHEN '++++' THEN '4' WHEN '4+' THEN '4' END AS '尿常规尿糖（GLU）结果', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str尿常规尿糖') AS '尿常规尿糖（GLU）计量单位-编码', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str尿常规尿糖name') AS '尿常规尿糖（GLU）计量单位-名称', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str尿常规尿糖低') AS '尿常规尿糖（GLU）参考范围最小值', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str尿常规尿糖高') AS '尿常规尿糖（GLU）参考范围最大值', CASE T11.ITEMRESULT WHEN '-' THEN '0' WHEN '+-' THEN '0.5' WHEN '+' THEN '1' WHEN '++' THEN '2' WHEN '2+' THEN '2' WHEN '+++' THEN '3' WHEN '3+' THEN '3' WHEN '++++' THEN '4' WHEN '4+' THEN '4' END AS '尿常规尿蛋白（PRO）结果', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str尿常规尿蛋白') AS '尿常规尿蛋白（PRO）计量单位-编码', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str尿常规尿蛋白name') AS '尿常规尿蛋白（PRO）计量单位-名称', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str尿常规尿蛋白低') AS '尿常规尿蛋白（PRO）参考范围最小值', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str尿常规尿蛋白高') AS '尿常规尿蛋白（PRO）参考范围最大值', CASE T12.ITEMRESULT WHEN '-' THEN '0' WHEN '+-' THEN '0.5' WHEN '+' THEN '1' WHEN '++' THEN '2' WHEN '2+' THEN '2' WHEN '+++' THEN '3' WHEN '3+' THEN '3' WHEN '++++' THEN '4' WHEN '4+' THEN '4' END AS '尿常规白细胞（WBC）结果', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str尿常规白细胞') AS '尿常规白细胞（WBC）计量单位-编码', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str尿常规白细胞name') AS '尿常规白细胞（WBC）计量单位-名称', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str尿常规白细胞低') AS '尿常规白细胞（WBC）参考范围最小值', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str尿常规白细胞高') AS '尿常规白细胞（WBC）参考范围最大值', CASE T13.ITEMRESULT WHEN '-' THEN '0' WHEN '+-' THEN '0.5' WHEN '+' THEN '1' WHEN '++' THEN '2' WHEN '2+' THEN '2' WHEN '+++' THEN '3' WHEN '3+' THEN '3' WHEN '++++' THEN '4' WHEN '4+' THEN '4' END AS '尿常规尿潜血（BLD）结果', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str尿常规尿潜血') AS '尿常规尿潜血（BLD）计量单位-编码', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str尿常规尿潜血name') AS '尿常规尿潜血（BLD）计量单位-名称', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str尿常规尿潜血高') AS '尿常规尿潜血（BLD）参考范围最小值', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str尿常规尿潜血低') AS '尿常规尿潜血（BLD）参考范围最大值', T14.ITEMRESULT AS '肝功能谷丙转氨酶（ALT）结果', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str肝功能谷丙转氨酶') AS '肝功能谷丙转氨酶（ALT）计量单位-编码', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str肝功能谷丙转氨酶name') AS '肝功能谷丙转氨酶（ALT）计量单位-名称', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str肝功能谷丙转氨酶低') AS '肝功能谷丙转氨酶（ALT）参考范围最小值', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str肝功能谷丙转氨酶高') AS '肝功能谷丙转氨酶（ALT）参考范围最大值', T4.ITEMRESULT AS '胸透', '' AS '胸片-编码', '' AS '胸片-名称', T5.ITEMRESULT AS '心电图', '' AS '心电图-编码', '' AS '心电图-名称', T16.ITEMRESULT AS '苯血常规（中性粒细胞绝对值<Neut#>）结果', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str苯血常规中性粒细胞绝对值') AS '苯血常规（中性粒细胞绝对值<Neut#>）计量单位-编码', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str苯血常规中性粒细胞绝对值name') AS '苯血常规（中性粒细胞绝对值<Neut#>）计量单位-名称', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str苯血常规中性粒细胞绝对值低') AS '苯血常规（中性粒细胞绝对值<Neut#>）参考范围最小值', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str苯血常规中性粒细胞绝对值高') AS '苯血常规（中性粒细胞绝对值<Neut#>）参考范围最大值', T21.ITEMRESULT AS '肺功能FVC结果', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str肺功能FVC') AS '肺功能FVC计量单位-编码', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str肺功能FVCname') AS '肺功能FVC计量单位-名称', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str肺功能FVC低') AS '肺功能FVC参考范围最小值', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str肺功能FVC高') AS '肺功能FVC参考范围最大值', T22.ITEMRESULT AS '肺功能FEV1结果', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str肺功能FEV1') AS '肺功能FEV1计量单位-编码', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str肺功能FEV1name') AS '肺功能FEV1计量单位-名称', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str肺功能FEV1低') AS '肺功能FEV1参考范围最小值', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str肺功能FEV1高') AS '肺功能FEV1参考范围最大值', T23.ITEMRESULT AS '肺功能FEV1/FVC结果', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str肺功能FEV1FVC') AS '肺功能FEV1/FVC计量单位-编码', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str肺功能FEV1FVCname') AS '肺功能FEV1/FVC计量单位-名称', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str肺功能FEV1FVC低') AS '肺功能FEV1/FVC参考范围最小值', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str肺功能FEV1FVC高') AS '肺功能FEV1/FVC参考范围最大值', T24.ITEMRESULT AS '血铅结果', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str铅血铅') AS '血铅计量单位-编码', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str铅血铅name') AS '血铅计量单位-名称', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str铅血铅低') AS '血铅参考范围最小值', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str铅血铅高') AS '血铅参考范围最大值', T25.ITEMRESULT AS '尿铅结果', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str铅尿铅') AS '尿铅计量单位-编码', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str铅尿铅name') AS '尿铅计量单位-名称', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str铅尿铅低') AS '尿铅参考范围最小值', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str铅尿铅高') AS '尿铅参考范围最大值', T26.ITEMRESULT AS '铅红细胞锌原卟啉（ZPP）结果', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str铅红细胞锌原卟啉') AS '铅红细胞锌原卟啉（ZPP）计量单位-编码', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str铅红细胞锌原卟啉name') AS '铅红细胞锌原卟啉（ZPP）计量单位-名称', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str铅红细胞锌原卟啉低') AS '铅红细胞锌原卟啉（ZPP）参考范围最小值', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str铅红细胞锌原卟啉高') AS '铅红细胞锌原卟啉（ZPP）参考范围最大值', T27.ITEMRESULT AS '噪声双耳高频平均听阈（校正值）结果', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str噪声双耳高频平均听阈校正值') AS '噪声双耳高频平均听阈（校正值）计量单位-编码', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str噪声双耳高频平均听阈校正值name') AS '噪声双耳高频平均听阈（校正值）计量单位-名称', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str噪声双耳高频平均听阈校正值低') AS '噪声双耳高频平均听阈（校正值）参考范围最小值', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str噪声双耳高频平均听阈校正值高') AS '噪声双耳高频平均听阈（校正值）参考范围最大值', CASE T28.ITEMRESULT WHEN '-' THEN '0' WHEN '+' THEN '1' WHEN '阴性' THEN '0' WHEN '阳性' THEN '1' END AS '布鲁菌属虎红缓冲液玻片凝集实验（RPBT）-编码', T28.ITEMRESULT AS '布鲁菌属虎红缓冲液玻片凝集实验（RPBT）-名称', CASE T29.ITEMRESULT WHEN '-' THEN '0' WHEN '+-' THEN '0.5' WHEN '+' THEN '1' WHEN '++' THEN '2' WHEN '2+' THEN '2' WHEN '+++' THEN '3' WHEN '3+' THEN '3' WHEN '++++' THEN '4' WHEN '4+' THEN '4' END AS '布鲁菌属试管凝集反应（Wright）(1:100) -编码', T29.ITEMRESULT AS '布鲁菌属试管凝集反应（Wright）(1:100) -名称', CASE T15.CONCLUSION WHEN '0' THEN '1' WHEN '1' THEN '2' WHEN '2' THEN '3' WHEN '3' THEN '4' WHEN '4' THEN '5' END AS '体检结论-编码', CASE T15.CONCLUSION WHEN '0' THEN '目前未见异常' WHEN '1' THEN '复查' WHEN '2' THEN '疑似职业病' WHEN '3' THEN '职业禁忌证' WHEN '4' THEN '其他疾病或异常' END AS '体检结论-名称', T17.CDC_JIGOUMINGCHENG AS '填表单位', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str填表人') AS '填表人', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str填表人联系电话') AS '填表人联系电话', (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str填表日期') AS '填表日期' FROM T_SINGLE_CHECKINFO T1 LEFT JOIN T_SINGLE_CHECKINFO_EXTEND TB ON T1.SGLCHECKID = TB.SGLCHECKID INNER JOIN (SELECT TD.NACAO ,TD.DIQU, TD.DIQUBM, TC.FID AS 'ORDERID', TB.FNAME AS 'CORPARCHIVENAME', TC.LINKMANPHONE, TB.ADDRESS, TB.ZIPCODE, TB.SCALEID, TB.PROPID, TB.INDID FROM T_CORPARCHIVE TB, T_ORDER TC, T_OHS_CORPARCHIVE_EXTEND TD WHERE TB.FID = TC.CORPID AND TB.FID = TD.FID) TB1 ON TB1.ORDERID = T1.ORDERID LEFT JOIN (SELECT TB.ITEMRESULT,TB.SGLCHECKID FROM T_SINGLE_RESULT TB WHERE TB.CHECKITEMID = (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str项目结果血压收缩压')) T2 ON T1.SGLCHECKID = T2.SGLCHECKID LEFT JOIN (SELECT TB.ITEMRESULT,TB.SGLCHECKID FROM T_SINGLE_RESULT TB WHERE TB.CHECKITEMID = (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str项目结果血压舒张压')) T3 ON T1.SGLCHECKID = T3.SGLCHECKID LEFT JOIN (SELECT TB.ITEMRESULT,TB.SGLCHECKID FROM T_SINGLE_RESULT TB WHERE TB.CHECKITEMID = (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str项目结果胸片')) T4 ON T1.SGLCHECKID = T4.SGLCHECKID LEFT JOIN (SELECT TB.ITEMRESULT,TB.SGLCHECKID FROM T_SINGLE_RESULT TB WHERE TB.CHECKITEMID = (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str项目结果心电图')) T5 ON T1.SGLCHECKID = T5.SGLCHECKID LEFT JOIN (SELECT TB.ITEMRESULT,TB.SGLCHECKID FROM T_SINGLE_RESULT TB WHERE TB.CHECKITEMID = (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str项目结果血常规白细胞计数')) T6 ON T1.SGLCHECKID = T6.SGLCHECKID LEFT JOIN (SELECT TB.ITEMRESULT,TB.SGLCHECKID FROM T_SINGLE_RESULT TB WHERE TB.CHECKITEMID = (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str项目结果血常规红细胞计数')) T7 ON T1.SGLCHECKID = T7.SGLCHECKID LEFT JOIN (SELECT TB.ITEMRESULT,TB.SGLCHECKID FROM T_SINGLE_RESULT TB WHERE TB.CHECKITEMID = (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str项目结果血常规血红蛋白')) T8 ON T1.SGLCHECKID = T8.SGLCHECKID LEFT JOIN (SELECT TB.ITEMRESULT,TB.SGLCHECKID FROM T_SINGLE_RESULT TB WHERE TB.CHECKITEMID = (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str项目结果血常规血小板计数')) T9 ON T1.SGLCHECKID = T9.SGLCHECKID LEFT JOIN (SELECT TB.ITEMRESULT,TB.SGLCHECKID FROM T_SINGLE_RESULT TB WHERE TB.CHECKITEMID = (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str项目结果尿常规尿糖')) T10 ON T1.SGLCHECKID = T10.SGLCHECKID LEFT JOIN (SELECT TB.ITEMRESULT,TB.SGLCHECKID FROM T_SINGLE_RESULT TB WHERE TB.CHECKITEMID = (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str项目结果尿常规尿蛋白')) T11 ON T1.SGLCHECKID = T11.SGLCHECKID LEFT JOIN (SELECT TB.ITEMRESULT,TB.SGLCHECKID FROM T_SINGLE_RESULT TB WHERE TB.CHECKITEMID = (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str项目结果尿常规白细胞')) T12 ON T1.SGLCHECKID = T12.SGLCHECKID LEFT JOIN (SELECT TB.ITEMRESULT,TB.SGLCHECKID FROM T_SINGLE_RESULT TB WHERE TB.CHECKITEMID = (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str项目结果尿常规尿潜血')) T13 ON T1.SGLCHECKID = T13.SGLCHECKID LEFT JOIN (SELECT TB.ITEMRESULT,TB.SGLCHECKID FROM T_SINGLE_RESULT TB WHERE TB.CHECKITEMID = (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str项目结果肝功能谷丙转氨酶')) T14 ON T1.SGLCHECKID = T14.SGLCHECKID LEFT JOIN (SELECT TB.ITEMRESULT,TB.SGLCHECKID FROM T_SINGLE_RESULT TB WHERE TB.CHECKITEMID = (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str项目结果苯血常规')) T16 ON T1.SGLCHECKID = T16.SGLCHECKID LEFT JOIN (SELECT TB.ITEMRESULT,TB.SGLCHECKID FROM T_SINGLE_RESULT TB WHERE TB.CHECKITEMID = (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str项目结果肺功能FEV1')) T21 ON T1.SGLCHECKID = T21.SGLCHECKID LEFT JOIN (SELECT TB.ITEMRESULT,TB.SGLCHECKID FROM T_SINGLE_RESULT TB WHERE TB.CHECKITEMID = (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str项目结果肺功能FEV1FVC')) T23 ON T1.SGLCHECKID = T23.SGLCHECKID LEFT JOIN (SELECT TB.ITEMRESULT,TB.SGLCHECKID FROM T_SINGLE_RESULT TB WHERE TB.CHECKITEMID = (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str项目结果肺功能FVC')) T22 ON T1.SGLCHECKID = T22.SGLCHECKID LEFT JOIN (SELECT TB.ITEMRESULT,TB.SGLCHECKID FROM T_SINGLE_RESULT TB WHERE TB.CHECKITEMID = (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str项目结果铅红细胞锌原卟啉')) T26 ON T1.SGLCHECKID = T26.SGLCHECKID LEFT JOIN (SELECT TB.ITEMRESULT,TB.SGLCHECKID FROM T_SINGLE_RESULT TB WHERE TB.CHECKITEMID = (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str项目结果铅尿铅')) T25 ON T1.SGLCHECKID = T25.SGLCHECKID LEFT JOIN (SELECT TB.ITEMRESULT,TB.SGLCHECKID FROM T_SINGLE_RESULT TB WHERE TB.CHECKITEMID = (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str项目结果铅血铅')) T24 ON T1.SGLCHECKID = T24.SGLCHECKID LEFT JOIN (SELECT TB.ITEMRESULT,TB.SGLCHECKID FROM T_SINGLE_RESULT TB WHERE TB.CHECKITEMID = (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str项目结果噪声双耳高频平均听阈')) T27 ON T1.SGLCHECKID = T27.SGLCHECKID LEFT JOIN (SELECT TB.ITEMRESULT,TB.SGLCHECKID FROM T_SINGLE_RESULT TB WHERE TB.CHECKITEMID = (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str项目结果布鲁菌虎红')) T28 ON T1.SGLCHECKID = T28.SGLCHECKID LEFT JOIN (SELECT TB.ITEMRESULT,TB.SGLCHECKID FROM T_SINGLE_RESULT TB WHERE TB.CHECKITEMID = (select fid from T_SRV_BIGQUERY_CONFIG where FTYPE='str项目结果布鲁菌试管')) T29 ON T1.SGLCHECKID = T29.SGLCHECKID LEFT JOIN (SELECT TB.CONCLUSION,TB.SGLCHECKID FROM T_OHS_SINGLE_ANALYZE_EXTEND TB ) T15 ON T1.SGLCHECKID = T15.SGLCHECKID LEFT JOIN (SELECT TB.HOSPITALNAME AS 'CDC_JIGOUMINGCHENG', TB.* FROM T_OHS_HOSPITALMESSAGE TB WHERE TB.DF='1') T17 ON 1=1 WHERE TB.SGLTYPE='12' AND T1.CHECKSTATUS>'1080' GO
0 0
- 职业病上报
- 职业病
- IT职业病
- IT职业病
- 数据上报-上报设计
- 编辑职业病之一：熬夜
- 犯职业病了
- 教师的“职业病”
- 预防“电脑”职业病
- 预防“电脑”职业病
- IT职业病：硅谷综合症
- 谨防IT职业病
- 程序员职业病防范
- 启用职业病体检
- 链式上报
- IT常见9种职业病
- 程序员如何预防一些职业病
- 艺人劈腿是不是职业病？
- 与14级团队同学的约定
- 前缀，中缀，后缀表达式转换
- javascript中将json字符串转换成json对象
- 缓存工具类LruCache
- 服务器漏洞KB3139914
- 职业病上报
- VC++6.0快捷键大全+断点调试
- 《图解HTTP》笔记——了解web及网络基础（第一章）
- LeetCode笔记：118. Pascal's Triangle
- VS2010调试多进程
- Fragment和Activity之间的依附使用
- cocos2d-X：Json数据（1）
- SrpingMVC启动监听与普通类取Application
- CocoaLumberjack 踩坑
