广东省2012版病案首页HIS项目归类语句(参考) - 图文

更新时间:2023-10-05 12:27:01 阅读量: 综合文库 文档下载

说明:文章内容仅供预览,部分内容可能不全。下载后的文档,内容与下面显示的完全一致。下载之前请确认下面内容是否您想要的,是否完整无缺。

广东省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

本文来源:https://www.bwwdw.com/article/8trd.html

Top