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

广东省2012版病案HIS项目归类语句（参考）这里比较有用的应该是归类的省代码区间，语句内容只是作参考用，在更改前要大概查看下所要更改的内容是符合，如符合就从update选择到语句尾部开始执行语句即可。-中成药SELECT BsItem.Name AS Expr1, BsZyFeety.Name AS Expr2, BsItemFirstPage.ItemId, BsItemFirstPage.PsFeeName, BsItemFirstPageType.Name, BsItem.LsRpType-update BsItemFirstPage set psfeename=41FROM 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.IDWHERE (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=40FROM 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.IDWHERE (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=26FROM 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.IDWHERE (BsItemFirstPage.PsFeeName IS NULL) OR (BsItemFirstPage.PsFeeName = 0) AND (BsItem.LsRpType IN (3)-诊查费(110200001-110200005)SELECT BsItem.Name AS Expr1, BsZyFeety.Name AS Expr2, BsItemFirstPage.ItemId, BsItemFirstPage.PsFeeName, BsItemFirstPageType.Name, BsItem.LsRpType-update BsItemFirstPage set psfeename=1FROM 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.IDwhere BsItem.id in (SELECT idFROM BsItem where f1=110200001 and f1=110100001 and f1=120200001 and f1=120100001 and f1=130100001 and f1=270100001 and f1=250101001 and f1=210101001 and f1=310607001 and f1=311503001 and f1=240100001 and f1=310100001 and f1=330100001 and f1=320100001 and f1=330100001 and f1=340100001 and f1=410000001 and f1=420000001 and f1=430000001 and f1=450000001 and f1=460000001 and f1=470000001 and f1=480000003 and f1=480000005) and (BsItemFirstPage.PsFeeName 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=23FROM 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.IDwhere BsItem.id in (SELECT idFROM BsItem where f1=480000001) and (BsItemFirstPage.PsFeeName IS NULL) OR (BsItemFirstPage.PsFeeName = 0)ID小类别归属大类对应病案字段（小类）对应病案字段（大类）1中医辩证论治费(医疗服务类)一般医疗服务费(医疗服务类)ZHFWLYLF01FZHFWLYLF2中医辩证论治会诊费(医疗服务类)一般医疗服务费(医疗服务类)ZHFWLYLF02FZHFWLYLF3一般治疗操作费(医疗服务类)一般治疗操作费(医疗服务类)ZHFWLCZFFZHFWLCZF4护理费(医疗服务类)护理费(医疗服务类)ZHFWLHLFFZHFWLHLF5其他费用(医疗服务类)其他费用(医疗服务类)ZHFWLQTFFZHFWLQTF6病理诊断费病理诊断费ZDLBLFFZDLBLF7实验室诊断费实验室诊断费ZDLSSSFFZDLSSSF8影像学诊断费影像学诊断费ZDLYXFFZDLYXF9临床诊断项目费临床诊断项目费ZDLLCFFZDLLCF10非手术治疗项目费非手术治疗项目费ZLLFFSSFFZLLFFSSF11临床物理治疗费非手术治疗项目费ZLLFWLZWLFFZLLFFSSF12麻醉费手术治疗费ZLLFMZFFZLLFSSF13手术费手术治疗费ZLLFSSZLFFZLLFSSF14康复费康复费KFLKFFFKFLKFF15中医诊断中医治疗ZYLZDFFZYLZDF16中医外治中医治疗ZYLZLF01FZYLZLF17中医骨伤中医治疗ZYLQTF02FZYLZLF18中医针刺与灸法中医治疗ZYLZLF03FZYLZLF19中医推拿治疗中医治疗ZYLZLF04FZYLZLF20中医肛肠治疗中医治疗ZYLZLF05FZYLZLF21中医特殊治疗中医治疗ZYLZLF06FZYLZLF22中药特殊调配加工中医其他ZYLQTF01FZYLQTF23辩证施膳中医其他ZYLQTF02FZYLQTF24抗菌药物费用西药费XYLGJFFXYF25医疗机构中药制剂费中成药费ZCLJGZJFFZCHYF26中草药费中草药费ZCYFFZCYF27血费血费XYLXFFXYLXF28白蛋白类制品费白蛋白类制品费XYLBQBFFXYLBQBF29球蛋白类制品费球蛋白类制品费XYLQDBFFXYLQDBF30凝血因子类制品费凝血因子类制品费XYLYXYZFFXYLYXYZF31细胞因子类制品费细胞因子类制品费XYLXBYZFFXYLXBYZF32检查用一次性医用材料费检查用一次性医用材料费HCLCJFFHCLCJF33治疗用一次性医用材料费治疗用一次性医用材料费HCLZLFFHCLZLF34手术用一次性医用材料费手术用一次性医用材料费HCLSSFFHCLSSF35其他费(其他类)其他费(其他类)QTFFQT