广东省2012版病案首页HIS项目归类语句(参考) - 图文
更新时间:2023-10-05 12:27:01 阅读量: 综合文库 文档下载
- 2012版病案首页推荐度:
- 相关推荐
广东省2012版病案HIS项目归类语句(参考)
这里比较有用的应该是归类的省代码区间,语句内容只是作参考用,在更改前要大概查看下所要更改的内容是符合,如符合就从update选择到语句尾部开始执行语句即可。 http://allround.taobao.com -------中成药
SELECT BsItem.Name AS Expr1, BsZyFeety.Name AS Expr2, BsItemFirstPage.ItemId, BsItemFirstPage.PsFeeName, BsItemFirstPageType.Name, BsItem.LsRpType -----update BsItemFirstPage set psfeename=41 FROM BsItemFirstPage INNER JOIN
BsItem ON BsItemFirstPage.ItemId = BsItem.ID INNER JOIN BsZyFeety ON BsItem.FeeZyId = BsZyFeety.ID LEFT OUTER JOIN BsItemFirstPageType ON
BsItemFirstPage.PsFeeName = BsItemFirstPageType.ID WHERE ((BsItemFirstPage.PsFeeName IS NULL) OR
(BsItemFirstPage.PsFeeName = 0)) AND (BsItem.LsRpType IN (1))
-------西药
SELECT BsItem.Name AS Expr1, BsZyFeety.Name AS Expr2, BsItemFirstPage.ItemId, BsItemFirstPage.PsFeeName, BsItemFirstPageType.Name, BsItem.LsRpType -----update BsItemFirstPage set psfeename=40 FROM BsItemFirstPage INNER JOIN
BsItem ON BsItemFirstPage.ItemId = BsItem.ID INNER JOIN BsZyFeety ON BsItem.FeeZyId = BsZyFeety.ID LEFT OUTER JOIN BsItemFirstPageType ON
BsItemFirstPage.PsFeeName = BsItemFirstPageType.ID WHERE ((BsItemFirstPage.PsFeeName IS NULL) OR
(BsItemFirstPage.PsFeeName = 0)) AND (BsItem.LsRpType IN (2))
--------中草药
SELECT BsItem.Name AS Expr1, BsZyFeety.Name AS Expr2, BsItemFirstPage.ItemId, BsItemFirstPage.PsFeeName, BsItemFirstPageType.Name, BsItem.LsRpType -----update BsItemFirstPage set psfeename=26 FROM BsItemFirstPage INNER JOIN
BsItem ON BsItemFirstPage.ItemId = BsItem.ID INNER JOIN BsZyFeety ON BsItem.FeeZyId = BsZyFeety.ID LEFT OUTER JOIN BsItemFirstPageType ON
BsItemFirstPage.PsFeeName = BsItemFirstPageType.ID WHERE ((BsItemFirstPage.PsFeeName IS NULL) OR
(BsItemFirstPage.PsFeeName = 0)) AND (BsItem.LsRpType IN (3))
比一比商城真情奉献,欢迎访问:http://allround.taobao.com及
http://allround2.taobao.com
---------诊查费(110200001-110200005)
SELECT BsItem.Name AS Expr1, BsZyFeety.Name AS Expr2, BsItemFirstPage.ItemId, BsItemFirstPage.PsFeeName, BsItemFirstPageType.Name, BsItem.LsRpType -----update BsItemFirstPage set psfeename=1 FROM BsItemFirstPage INNER JOIN
BsItem ON BsItemFirstPage.ItemId = BsItem.ID INNER JOIN BsZyFeety ON BsItem.FeeZyId = BsZyFeety.ID LEFT OUTER JOIN BsItemFirstPageType ON
BsItemFirstPage.PsFeeName = BsItemFirstPageType.ID where BsItem.id in (SELECT id
FROM [BsItem] where f1>='110200001' and f1<='110200005' ) and ((BsItemFirstPage.PsFeeName IS NULL) OR
(BsItemFirstPage.PsFeeName = 0))
---------一般医疗服务费(110100001-110900005)
SELECT BsItem.Name AS Expr1, BsZyFeety.Name AS Expr2, BsItemFirstPage.ItemId, BsItemFirstPage.PsFeeName, BsItemFirstPageType.Name, BsItem.LsRpType -----update BsItemFirstPage set psfeename=36 FROM BsItemFirstPage INNER JOIN
BsItem ON BsItemFirstPage.ItemId = BsItem.ID INNER JOIN BsZyFeety ON BsItem.FeeZyId = BsZyFeety.ID LEFT OUTER JOIN BsItemFirstPageType ON
BsItemFirstPage.PsFeeName = BsItemFirstPageType.ID where BsItem.id in (SELECT id
FROM [BsItem] where f1>='110100001' and f1<='110900005') and ((BsItemFirstPage.PsFeeName IS NULL) OR
(BsItemFirstPage.PsFeeName = 0))
---------一般治疗操作费(120200001-121700001)
SELECT BsItem.Name AS Expr1, BsZyFeety.Name AS Expr2, BsItemFirstPage.ItemId, BsItemFirstPage.PsFeeName, BsItemFirstPageType.Name, BsItem.LsRpType -----update BsItemFirstPage set psfeename=3 FROM BsItemFirstPage INNER JOIN
BsItem ON BsItemFirstPage.ItemId = BsItem.ID INNER JOIN BsZyFeety ON BsItem.FeeZyId = BsZyFeety.ID LEFT OUTER JOIN BsItemFirstPageType ON
BsItemFirstPage.PsFeeName = BsItemFirstPageType.ID where BsItem.id in (SELECT id
FROM [BsItem] where f1>='120200001' and f1<='121700001') and ((BsItemFirstPage.PsFeeName
比一比商城真情奉献,欢迎访问:http://allround.taobao.com及
http://allround2.taobao.com
IS NULL) OR
(BsItemFirstPage.PsFeeName = 0))
---------护理费(120100001-120100014)
SELECT BsItem.Name AS Expr1, BsZyFeety.Name AS Expr2, BsItemFirstPage.ItemId, BsItemFirstPage.PsFeeName, BsItemFirstPageType.Name, BsItem.LsRpType -----update BsItemFirstPage set psfeename=4 FROM BsItemFirstPage INNER JOIN
BsItem ON BsItemFirstPage.ItemId = BsItem.ID INNER JOIN BsZyFeety ON BsItem.FeeZyId = BsZyFeety.ID LEFT OUTER JOIN BsItemFirstPageType ON
BsItemFirstPage.PsFeeName = BsItemFirstPageType.ID where BsItem.id in (SELECT id
FROM [BsItem] where f1>='120100001' and f1<='120100014') and ((BsItemFirstPage.PsFeeName IS NULL) OR
(BsItemFirstPage.PsFeeName = 0))
---------其他费用(130100001-140100004)
SELECT BsItem.Name AS Expr1, BsZyFeety.Name AS Expr2, BsItemFirstPage.ItemId, BsItemFirstPage.PsFeeName, BsItemFirstPageType.Name, BsItem.LsRpType -----update BsItemFirstPage set psfeename=5 FROM BsItemFirstPage INNER JOIN
BsItem ON BsItemFirstPage.ItemId = BsItem.ID INNER JOIN BsZyFeety ON BsItem.FeeZyId = BsZyFeety.ID LEFT OUTER JOIN BsItemFirstPageType ON
BsItemFirstPage.PsFeeName = BsItemFirstPageType.ID where BsItem.id in (SELECT id
FROM [BsItem] where f1>='130100001' and f1<='140100004') and ((BsItemFirstPage.PsFeeName IS NULL) OR
(BsItemFirstPage.PsFeeName = 0))
---------病理诊断费(270100001-270800008)
SELECT BsItem.Name AS Expr1, BsZyFeety.Name AS Expr2, BsItemFirstPage.ItemId, BsItemFirstPage.PsFeeName, BsItemFirstPageType.Name, BsItem.LsRpType -----update BsItemFirstPage set psfeename=6 FROM BsItemFirstPage INNER JOIN
BsItem ON BsItemFirstPage.ItemId = BsItem.ID INNER JOIN BsZyFeety ON BsItem.FeeZyId = BsZyFeety.ID LEFT OUTER JOIN BsItemFirstPageType ON
BsItemFirstPage.PsFeeName = BsItemFirstPageType.ID
比一比商城真情奉献,欢迎访问:http://allround.taobao.com及
http://allround2.taobao.com
where BsItem.id in (SELECT id
FROM [BsItem] where f1>='270100001' and f1<='270800008') and ((BsItemFirstPage.PsFeeName IS NULL) OR
(BsItemFirstPage.PsFeeName = 0))
---------实验室诊断费(250101001-260000023)
SELECT BsItem.Name AS Expr1, BsZyFeety.Name AS Expr2, BsItemFirstPage.ItemId, BsItemFirstPage.PsFeeName, BsItemFirstPageType.Name, BsItem.LsRpType -----update BsItemFirstPage set psfeename=7 FROM BsItemFirstPage INNER JOIN
BsItem ON BsItemFirstPage.ItemId = BsItem.ID INNER JOIN BsZyFeety ON BsItem.FeeZyId = BsZyFeety.ID LEFT OUTER JOIN BsItemFirstPageType ON
BsItemFirstPage.PsFeeName = BsItemFirstPageType.ID where BsItem.id in (SELECT id
FROM [BsItem] where f1>='250101001' and f1<='260000023') and ((BsItemFirstPage.PsFeeName IS NULL) OR
(BsItemFirstPage.PsFeeName = 0))
---------影像学诊断费(210101001-230600016)
SELECT BsItem.Name AS Expr1, BsZyFeety.Name AS Expr2, BsItemFirstPage.ItemId, BsItemFirstPage.PsFeeName, BsItemFirstPageType.Name, BsItem.LsRpType -----update BsItemFirstPage set psfeename=8 FROM BsItemFirstPage INNER JOIN
BsItem ON BsItemFirstPage.ItemId = BsItem.ID INNER JOIN BsZyFeety ON BsItem.FeeZyId = BsZyFeety.ID LEFT OUTER JOIN BsItemFirstPageType ON
BsItemFirstPage.PsFeeName = BsItemFirstPageType.ID where BsItem.id in (SELECT id
FROM [BsItem] where f1>='210101001' and f1<='230600016') and ((BsItemFirstPage.PsFeeName IS NULL) OR
(BsItemFirstPage.PsFeeName = 0))
---------非手术治疗项目费(310607001-310607006)
SELECT BsItem.Name AS Expr1, BsZyFeety.Name AS Expr2, BsItemFirstPage.ItemId, BsItemFirstPage.PsFeeName, BsItemFirstPageType.Name, BsItem.LsRpType -----update BsItemFirstPage set psfeename=10 FROM BsItemFirstPage INNER JOIN
BsItem ON BsItemFirstPage.ItemId = BsItem.ID INNER JOIN BsZyFeety ON BsItem.FeeZyId = BsZyFeety.ID LEFT OUTER JOIN
比一比商城真情奉献,欢迎访问:http://allround.taobao.com及
http://allround2.taobao.com
BsItemFirstPageType ON
BsItemFirstPage.PsFeeName = BsItemFirstPageType.ID where BsItem.id in (SELECT id
FROM [BsItem] where f1>='310607001' and f1<='310607006') and ((BsItemFirstPage.PsFeeName IS NULL) OR
(BsItemFirstPage.PsFeeName = 0))
---------非手术治疗项目费2(311503001-311503030)
SELECT BsItem.Name AS Expr1, BsZyFeety.Name AS Expr2, BsItemFirstPage.ItemId, BsItemFirstPage.PsFeeName, BsItemFirstPageType.Name, BsItem.LsRpType -----update BsItemFirstPage set psfeename=10 FROM BsItemFirstPage INNER JOIN
BsItem ON BsItemFirstPage.ItemId = BsItem.ID INNER JOIN BsZyFeety ON BsItem.FeeZyId = BsZyFeety.ID LEFT OUTER JOIN BsItemFirstPageType ON
BsItemFirstPage.PsFeeName = BsItemFirstPageType.ID where BsItem.id in (SELECT id
FROM [BsItem] where f1>='311503001' and f1<='311503030') and ((BsItemFirstPage.PsFeeName IS NULL) OR
(BsItemFirstPage.PsFeeName = 0))
---------临床物理治疗(240100001-240700003)
SELECT BsItem.Name AS Expr1, BsZyFeety.Name AS Expr2, BsItemFirstPage.ItemId, BsItemFirstPage.PsFeeName, BsItemFirstPageType.Name, BsItem.LsRpType -----update BsItemFirstPage set psfeename=11 FROM BsItemFirstPage INNER JOIN
BsItem ON BsItemFirstPage.ItemId = BsItem.ID INNER JOIN BsZyFeety ON BsItem.FeeZyId = BsZyFeety.ID LEFT OUTER JOIN BsItemFirstPageType ON
BsItemFirstPage.PsFeeName = BsItemFirstPageType.ID where BsItem.id in (SELECT id
FROM [BsItem] where f1>='240100001' and f1<='240700003') and ((BsItemFirstPage.PsFeeName IS NULL) OR
(BsItemFirstPage.PsFeeName = 0))
---------临床诊断项目费(310100001-311502006)
SELECT BsItem.Name AS Expr1, BsZyFeety.Name AS Expr2, BsItemFirstPage.ItemId, BsItemFirstPage.PsFeeName, BsItemFirstPageType.Name, BsItem.LsRpType -----update BsItemFirstPage set psfeename=9 FROM BsItemFirstPage INNER JOIN
比一比商城真情奉献,欢迎访问:http://allround.taobao.com及
http://allround2.taobao.com
BsItem ON BsItemFirstPage.ItemId = BsItem.ID INNER JOIN BsZyFeety ON BsItem.FeeZyId = BsZyFeety.ID LEFT OUTER JOIN BsItemFirstPageType ON
BsItemFirstPage.PsFeeName = BsItemFirstPageType.ID where BsItem.id in (SELECT id
FROM [BsItem] where f1>='310100001' and f1<='311502006') and ((BsItemFirstPage.PsFeeName IS NULL) OR
(BsItemFirstPage.PsFeeName = 0))
---------麻醉费(330100001-330100017)
SELECT BsItem.Name AS Expr1, BsZyFeety.Name AS Expr2, BsItemFirstPage.ItemId, BsItemFirstPage.PsFeeName, BsItemFirstPageType.Name, BsItem.LsRpType -----update BsItemFirstPage set psfeename=12 FROM BsItemFirstPage INNER JOIN
BsItem ON BsItemFirstPage.ItemId = BsItem.ID INNER JOIN BsZyFeety ON BsItem.FeeZyId = BsZyFeety.ID LEFT OUTER JOIN BsItemFirstPageType ON
BsItemFirstPage.PsFeeName = BsItemFirstPageType.ID where BsItem.id in (SELECT id
FROM [BsItem] where f1>='330100001' and f1<='330100017') and ((BsItemFirstPage.PsFeeName IS NULL) OR
(BsItemFirstPage.PsFeeName = 0))
---------手术治疗费(320100001-320600011)
SELECT BsItem.Name AS Expr1, BsZyFeety.Name AS Expr2, BsItemFirstPage.ItemId, BsItemFirstPage.PsFeeName, BsItemFirstPageType.Name, BsItem.LsRpType -----update BsItemFirstPage set psfeename=37 FROM BsItemFirstPage INNER JOIN
BsItem ON BsItemFirstPage.ItemId = BsItem.ID INNER JOIN BsZyFeety ON BsItem.FeeZyId = BsZyFeety.ID LEFT OUTER JOIN BsItemFirstPageType ON
BsItemFirstPage.PsFeeName = BsItemFirstPageType.ID where BsItem.id in (SELECT id
FROM [BsItem] where f1>='320100001' and f1<='320600011') and ((BsItemFirstPage.PsFeeName IS NULL) OR
(BsItemFirstPage.PsFeeName = 0))
---------手术费(330100001-331604034)
SELECT BsItem.Name AS Expr1, BsZyFeety.Name AS Expr2, BsItemFirstPage.ItemId, BsItemFirstPage.PsFeeName, BsItemFirstPageType.Name, BsItem.LsRpType
比一比商城真情奉献,欢迎访问:http://allround.taobao.com及
http://allround2.taobao.com
-----update BsItemFirstPage set psfeename=13 FROM BsItemFirstPage INNER JOIN
BsItem ON BsItemFirstPage.ItemId = BsItem.ID INNER JOIN BsZyFeety ON BsItem.FeeZyId = BsZyFeety.ID LEFT OUTER JOIN BsItemFirstPageType ON
BsItemFirstPage.PsFeeName = BsItemFirstPageType.ID where BsItem.id in (SELECT id
FROM [BsItem] where f1>='330100001' and f1<='331604034') and ((BsItemFirstPage.PsFeeName IS NULL) OR
(BsItemFirstPage.PsFeeName = 0))
---------康复费(340100001-340200042)
SELECT BsItem.Name AS Expr1, BsZyFeety.Name AS Expr2, BsItemFirstPage.ItemId, BsItemFirstPage.PsFeeName, BsItemFirstPageType.Name, BsItem.LsRpType -----update BsItemFirstPage set psfeename=14 FROM BsItemFirstPage INNER JOIN
BsItem ON BsItemFirstPage.ItemId = BsItem.ID INNER JOIN BsZyFeety ON BsItem.FeeZyId = BsZyFeety.ID LEFT OUTER JOIN BsItemFirstPageType ON
BsItemFirstPage.PsFeeName = BsItemFirstPageType.ID where BsItem.id in (SELECT id
FROM [BsItem] where f1>='340100001' and f1<='340200042') and ((BsItemFirstPage.PsFeeName IS NULL) OR
(BsItemFirstPage.PsFeeName = 0))
---------中医外治(410000001-410000012)
SELECT BsItem.Name AS Expr1, BsZyFeety.Name AS Expr2, BsItemFirstPage.ItemId, BsItemFirstPage.PsFeeName, BsItemFirstPageType.Name, BsItem.LsRpType -----update BsItemFirstPage set psfeename=16 FROM BsItemFirstPage INNER JOIN
BsItem ON BsItemFirstPage.ItemId = BsItem.ID INNER JOIN BsZyFeety ON BsItem.FeeZyId = BsZyFeety.ID LEFT OUTER JOIN BsItemFirstPageType ON
BsItemFirstPage.PsFeeName = BsItemFirstPageType.ID where BsItem.id in (SELECT id
FROM [BsItem] where f1>='410000001' and f1<='410000012') and ((BsItemFirstPage.PsFeeName IS NULL) OR
(BsItemFirstPage.PsFeeName = 0))
比一比商城真情奉献,欢迎访问:http://allround.taobao.com及
http://allround2.taobao.com
---------中医骨伤(420000001-420000011)
SELECT BsItem.Name AS Expr1, BsZyFeety.Name AS Expr2, BsItemFirstPage.ItemId,
BsItemFirstPage.PsFeeName, BsItemFirstPageType.Name, BsItem.LsRpType,BsItem.f1 -----update BsItemFirstPage set psfeename=17 FROM BsItemFirstPage INNER JOIN
BsItem ON BsItemFirstPage.ItemId = BsItem.ID INNER JOIN BsZyFeety ON BsItem.FeeZyId = BsZyFeety.ID LEFT OUTER JOIN BsItemFirstPageType ON
BsItemFirstPage.PsFeeName = BsItemFirstPageType.ID where BsItem.id in (SELECT id
FROM [BsItem] where f1>='420000001' and f1<='420000011') and ((BsItemFirstPage.PsFeeName IS NULL) OR
(BsItemFirstPage.PsFeeName = 0))
---------针刺与灸法(430000001-440000006)
SELECT BsItem.Name AS Expr1, BsZyFeety.Name AS Expr2, BsItemFirstPage.ItemId,
BsItemFirstPage.PsFeeName, BsItemFirstPageType.Name, BsItem.LsRpType,BsItem.f1 -----update BsItemFirstPage set psfeename=18 FROM BsItemFirstPage INNER JOIN
BsItem ON BsItemFirstPage.ItemId = BsItem.ID INNER JOIN BsZyFeety ON BsItem.FeeZyId = BsZyFeety.ID LEFT OUTER JOIN BsItemFirstPageType ON
BsItemFirstPage.PsFeeName = BsItemFirstPageType.ID where BsItem.id in (SELECT id
FROM [BsItem] where f1>='430000001' and f1<='440000006') and ((BsItemFirstPage.PsFeeName IS NULL) OR
(BsItemFirstPage.PsFeeName = 0))
---------推拿治疗(450000001-450000011)
SELECT BsItem.Name AS Expr1, BsZyFeety.Name AS Expr2, BsItemFirstPage.ItemId,
BsItemFirstPage.PsFeeName, BsItemFirstPageType.Name, BsItem.LsRpType,BsItem.f1 -----update BsItemFirstPage set psfeename=19 FROM BsItemFirstPage INNER JOIN
BsItem ON BsItemFirstPage.ItemId = BsItem.ID INNER JOIN BsZyFeety ON BsItem.FeeZyId = BsZyFeety.ID LEFT OUTER JOIN BsItemFirstPageType ON
BsItemFirstPage.PsFeeName = BsItemFirstPageType.ID where BsItem.id in (SELECT id
FROM [BsItem] where f1>='450000001' and f1<='450000011') and ((BsItemFirstPage.PsFeeName IS NULL) OR
(BsItemFirstPage.PsFeeName = 0))
比一比商城真情奉献,欢迎访问:http://allround.taobao.com及
http://allround2.taobao.com
---------肛肠治疗(460000001-460000011)
SELECT BsItem.Name AS Expr1, BsZyFeety.Name AS Expr2, BsItemFirstPage.ItemId,
BsItemFirstPage.PsFeeName, BsItemFirstPageType.Name, BsItem.LsRpType,BsItem.f1 -----update BsItemFirstPage set psfeename=20 FROM BsItemFirstPage INNER JOIN
BsItem ON BsItemFirstPage.ItemId = BsItem.ID INNER JOIN BsZyFeety ON BsItem.FeeZyId = BsZyFeety.ID LEFT OUTER JOIN BsItemFirstPageType ON
BsItemFirstPage.PsFeeName = BsItemFirstPageType.ID where BsItem.id in (SELECT id
FROM [BsItem] where f1>='460000001' and f1<='460000011') and ((BsItemFirstPage.PsFeeName IS NULL) OR
(BsItemFirstPage.PsFeeName = 0))
---------特殊治疗(470000001-470000016)
SELECT BsItem.Name AS Expr1, BsZyFeety.Name AS Expr2, BsItemFirstPage.ItemId,
BsItemFirstPage.PsFeeName, BsItemFirstPageType.Name, BsItem.LsRpType,BsItem.f1 -----update BsItemFirstPage set psfeename=21 FROM BsItemFirstPage INNER JOIN
BsItem ON BsItemFirstPage.ItemId = BsItem.ID INNER JOIN BsZyFeety ON BsItem.FeeZyId = BsZyFeety.ID LEFT OUTER JOIN BsItemFirstPageType ON
BsItemFirstPage.PsFeeName = BsItemFirstPageType.ID where BsItem.id in (SELECT id
FROM [BsItem] where f1>='470000001' and f1<='470000016') and ((BsItemFirstPage.PsFeeName IS NULL) OR
(BsItemFirstPage.PsFeeName = 0))
---------特殊调配加工(480000003-480000005)
SELECT BsItem.Name AS Expr1, BsZyFeety.Name AS Expr2, BsItemFirstPage.ItemId,
BsItemFirstPage.PsFeeName, BsItemFirstPageType.Name, BsItem.LsRpType,BsItem.f1 -----update BsItemFirstPage set psfeename=22 FROM BsItemFirstPage INNER JOIN
BsItem ON BsItemFirstPage.ItemId = BsItem.ID INNER JOIN BsZyFeety ON BsItem.FeeZyId = BsZyFeety.ID LEFT OUTER JOIN BsItemFirstPageType ON
BsItemFirstPage.PsFeeName = BsItemFirstPageType.ID where BsItem.id in (SELECT id
FROM [BsItem] where f1>='480000003' and f1<='480000005') and ((BsItemFirstPage.PsFeeName
比一比商城真情奉献,欢迎访问:http://allround.taobao.com及
http://allround2.taobao.com
IS NULL) OR
(BsItemFirstPage.PsFeeName = 0))
---------辩证施膳(480000001)
SELECT BsItem.Name AS Expr1, BsZyFeety.Name AS Expr2, BsItemFirstPage.ItemId,
BsItemFirstPage.PsFeeName, BsItemFirstPageType.Name, BsItem.LsRpType,BsItem.f1 -----update BsItemFirstPage set psfeename=23 FROM BsItemFirstPage INNER JOIN
BsItem ON BsItemFirstPage.ItemId = BsItem.ID INNER JOIN BsZyFeety ON BsItem.FeeZyId = BsZyFeety.ID LEFT OUTER JOIN BsItemFirstPageType ON
BsItemFirstPage.PsFeeName = BsItemFirstPageType.ID where BsItem.id in (SELECT id
FROM [BsItem] where f1='480000001') and ((BsItemFirstPage.PsFeeName IS NULL) OR (BsItemFirstPage.PsFeeName = 0))
比一比商城真情奉献,欢迎访问:http://allround.taobao.com及
http://allround2.taobao.com
ID 小类别 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 中医辩证论治费(医疗服务类) 中医辩证论治会诊费(医疗服务类) 一般治疗操作费(医疗服务类) 护理费(医疗服务类) 其他费用(医疗服务类) 病理诊断费 实验室诊断费 影像学诊断费 临床诊断项目费 非手术治疗项目费 临床物理治疗费 麻醉费 手术费 康复费 中医诊断 中医外治 中医骨伤 中医针刺与灸法 中医推拿治疗 中医肛肠治疗 中医特殊治疗 中药特殊调配加工 辩证施膳 抗菌药物费用 医疗机构中药制剂费 中草药费 血费 白蛋白类制品费 球蛋白类制品费 凝血因子类制品费 细胞因子类制品费 检查用一次性医用材料费 治疗用一次性医用材料费 归属大类 一般医疗服务费(医疗服务类) 一般医疗服务费(医疗服务类) 一般治疗操作费(医疗服务类) 护理费(医疗服务类) 对应病案字段(小类) ZHFWLYLF01 ZHFWLYLF02 ZHFWLCZF ZHFWLHLF 对应病案字段(大类) FZHFWLYLF FZHFWLYLF FZHFWLCZF FZHFWLHLF FZHFWLQTF FZDLBLF FZDLSSSF FZDLYXF FZDLLCF FZLLFFSSF FZLLFFSSF FZLLFSSF FZLLFSSF FKFLKFF FZYLZDF FZYLZLF FZYLZLF FZYLZLF FZYLZLF FZYLZLF FZYLZLF FZYLQTF FZYLQTF FXYF FZCHYF FZCYF FXYLXF FXYLBQBF FXYLQDBF FXYLYXYZF FXYLXBYZF FHCLCJF FHCLZLF 其他费用(医疗服务类) ZHFWLQTF 病理诊断费 实验室诊断费 影像学诊断费 临床诊断项目费 非手术治疗项目费 非手术治疗项目费 手术治疗费 手术治疗费 康复费 中医治疗 中医治疗 中医治疗 中医治疗 中医治疗 中医治疗 中医治疗 中医其他 中医其他 西药费 中成药费 中草药费 血费 白蛋白类制品费 球蛋白类制品费 凝血因子类制品费 细胞因子类制品费 检查用一次性医用材料费 治疗用一次性医用材料费 ZDLBLF ZDLSSSF ZDLYXF ZDLLCF ZLLFFSSF ZLLFWLZWLF ZLLFMZF ZLLFSSZLF KFLKFF ZYLZDF ZYLZLF01 ZYLQTF02 ZYLZLF03 ZYLZLF04 ZYLZLF05 ZYLZLF06 ZYLQTF01 ZYLQTF02 XYLGJF ZCLJGZJF ZCYF XYLXF XYLBQBF XYLQDBF XYLYXYZF XYLXBYZF HCLCJF HCLZLF 比一比商城真情奉献,欢迎访问:http://allround.taobao.com及
http://allround2.taobao.com
34 35 36 37 38 39 40 41 手术用一次性医用材料费 其他费(其他类) 一般医疗服务费(医疗服务类) 手术治疗费 中医治疗 中医类其他 西药费 中成药费 手术用一次性医用材料费 其他费(其他类) 一般医疗服务费(医疗服务类) 手术治疗费 中医治疗 中医其他 西药费 中成药费 HCLSSF QTF ZHFWLYLF ZLLFSSF ZYLZLF ZYLQTF XYF ZCHYF FHCLSSF FQTF FZHFWLYLF FZLLFSSF FZYLZLF FZYLQTF FXYF FZCHYF 比一比商城真情奉献,欢迎访问:http://allround.taobao.com及
http://allround2.taobao.com
正在阅读:
广东省2012版病案首页HIS项目归类语句(参考) - 图文10-05
液压泵站操作规程12-05
广西壮族自治区教育厅05-18
室内分布系统试题(答案)学习资料05-02
小学英语外研版四年级上册Unit 1 What are they doing优质07-09
译林版四年级英语下册试卷10-16
党费收缴使用管理问答(1-60)全09-29
我名字的来历作文400字07-01
哑铃的设计与加工毕业论文 - 图文05-06
7直线和圆的位置关系08-21
- 多层物业服务方案
- (审判实务)习惯法与少数民族地区民间纠纷解决问题(孙 潋)
- 人教版新课标六年级下册语文全册教案
- 词语打卡
- photoshop实习报告
- 钢结构设计原理综合测试2
- 2014年期末练习题
- 高中数学中的逆向思维解题方法探讨
- 名师原创 全国通用2014-2015学年高二寒假作业 政治(一)Word版
- 北航《建筑结构检测鉴定与加固》在线作业三
- XX县卫生监督所工程建设项目可行性研究报告
- 小学四年级观察作文经典评语
- 浅谈110KV变电站电气一次设计-程泉焱(1)
- 安全员考试题库
- 国家电网公司变电运维管理规定(试行)
- 义务教育课程标准稿征求意见提纲
- 教学秘书面试技巧
- 钢结构工程施工组织设计
- 水利工程概论论文
- 09届九年级数学第四次模拟试卷
- 病案
- 广东省
- 首页
- 归类
- 语句
- 参考
- 图文
- 项目
- 2012
- HIS
- 麻醉学副高考试 - 实践技能(300题)
- 985个高考英语考试大纲核心单词
- 幼儿园督导评估整改措施-共10页
- 7月18日水灾救灾演练习报告
- 继电保护装置投退管理制度
- 幼儿园督导评估整改措施-2019年精选范文
- 工商所职责 工商所所长职责 - 工商所各岗位职责
- 地测管理
- 热电厂事故、障碍、异常认定细则及奖罚标准
- 以顾客为中心的价值营销
- 1-3单元易错题练习
- 什么是年味作文700字完美版
- 农村中学班级管理
- 统计复习资料(医本)
- Acronis Disk Director Suite使用教程 - 图文
- 2018年秋部编人教版语文小学三年级上随堂练习(每课一练,精选习题)
- 学14—15学年下学期高二期中考试生物(文)试题(附答案)
- 驿都实验学校办学理念的文化阐释资料
- 产业园企业入驻协议
- 电功率复习导学案