卫统4-1表接口规范1

整理文档很辛苦,赏杯茶钱您下走!

免费阅读已结束,点击下载阅读编辑剩下 ...

阅读已结束,您可以下载文档离线阅读编辑

资源描述

卫统4-1住院病案首页表(表号N041)字段名类型是否允许为空字段含义序号USERNAMEVARCHAR2(60)N机构名称1YLFKFSVARCHAR2(100)Y医疗付款方式2JKKHVARCHAR2(100)Y健康卡号3ZYCSVARCHAR2(100)Y住院次数4BAHVARCHAR2(100)Y病案号5XMVARCHAR2(100)Y姓名6XBVARCHAR2(100)Y性别7CSRQVARCHAR2(12)Y出生日期8NLNUMBER(10)Y年龄9GJVARCHAR2(100)Y国籍10BZYZSNLNUMBER(4)Y(年龄不足1周岁的)年龄(月)11XSECSTZNUMBER(12,2)Y新生儿出生体重(克)12XSERYTZNUMBER(12,2)Y新生儿入院体重(克)13CSDVARCHAR2(200)Y出生地14GGVARCHAR2(200)Y籍贯15MZVARCHAR2(100)Y民族16SFZHVARCHAR2(100)Y身份证号17ZYVARCHAR2(100)Y职业18HYVARCHAR2(100)Y婚姻19XZZVARCHAR2(100)Y现住址20DHVARCHAR2(100)Y电话21YB1VARCHAR2(100)Y邮编22HKDZVARCHAR2(100)Y户口地址23YB2VARCHAR2(100)Y邮编24GZDWJDZVARCHAR2(100)Y工作单位及地址25DWDHVARCHAR2(100)Y单位电话26YB3VARCHAR2(100)Y邮编27LXRXMVARCHAR2(100)Y联系人姓名28GXVARCHAR2(100)Y关系29DZVARCHAR2(100)Y地址30DH2VARCHAR2(100)Y电话31RYTJVARCHAR2(100)Y入院途径32RYSJVARCHAR2(12)Y入院时间33RYSJSNUMBER(24)Y时34RYKBVARCHAR2(100)Y入院科别35RYBFVARCHAR2(100)Y入院病房36ZKKBVARCHAR2(100)Y转科科别37CYSJVARCHAR2(12)Y出院时间38CYSJSNUMBER(24)Y时39CYKBVARCHAR2(100)Y出院科别40CYBFVARCHAR2(100)Y出院病房41SJZYTSVARCHAR2(100)Y实际住院(天)42MZZDVARCHAR2(200)Y门(急)诊诊断43JBBMVARCHAR2(100)Y疾病编码44ZYZDVARCHAR2(200)Y主要诊断45JBDMVARCHAR2(100)Y疾病编码46RYBQVARCHAR2(100)Y入院病情47QTZD8VARCHAR2(200)Y其他诊断48JBDM8VARCHAR2(100)Y疾病编码49RYBQ8VARCHAR2(100)Y入院病情50QTZD1VARCHAR2(200)Y其他诊断51JBDM1VARCHAR2(100)Y疾病编码52RYBQ1VARCHAR2(100)Y入院病情53QTZD9VARCHAR2(200)Y其他诊断54JBDM9VARCHAR2(100)Y疾病编码55RYBQ9VARCHAR2(100)Y入院病情56QTZD2VARCHAR2(200)Y其他诊断57JBDM2VARCHAR2(100)Y疾病编码58RYBQ2VARCHAR2(100)Y入院病情59QTZD10VARCHAR2(200)Y其他诊断60JBDM10VARCHAR2(100)Y疾病编码61RYBQ10VARCHAR2(100)Y入院病情62QTZD3VARCHAR2(200)Y其他诊断63JBDM3VARCHAR2(100)Y疾病编码64RYBQ3VARCHAR2(100)Y入院病情65QTZD11VARCHAR2(200)Y其他诊断66JBDM11VARCHAR2(100)Y疾病编码67RYBQ11VARCHAR2(100)Y入院病情68QTZD4VARCHAR2(200)Y其他诊断69JBDM4VARCHAR2(100)Y疾病编码70RYBQ4VARCHAR2(100)Y入院病情71QTZD12VARCHAR2(200)Y其他诊断72JBDM12VARCHAR2(100)Y疾病编码73RYBQ12VARCHAR2(100)Y入院病情74QTZD5VARCHAR2(200)Y其他诊断75JBDM5VARCHAR2(100)Y疾病编码76RYBQ5VARCHAR2(100)Y入院病情77QTZD13VARCHAR2(200)Y其他诊断78JBDM13VARCHAR2(100)Y疾病编码79RYBQ13VARCHAR2(100)Y入院病情80QTZD6VARCHAR2(200)Y其他诊断81JBDM6VARCHAR2(100)Y疾病编码82RYBQ6VARCHAR2(100)Y入院病情83QTZD14VARCHAR2(200)Y其他诊断84JBDM14VARCHAR2(100)Y疾病编码85RYBQ14VARCHAR2(100)Y入院病情86QTZD7VARCHAR2(200)Y其他诊断87JBDM7VARCHAR2(100)Y疾病编码88RYBQ7VARCHAR2(100)Y入院病情89QTZD15VARCHAR2(200)Y其他诊断90JBDM15VARCHAR2(100)Y疾病编码91RYBQ15VARCHAR2(100)Y入院病情92WBYYVARCHAR2(254)Y中毒的外部原因93H23VARCHAR2(100)Y疾病编码94BLZDVARCHAR2(100)Y病理诊断出95JBMMVARCHAR2(100)Y疾病编码96BLHVARCHAR2(100)Y病理号97YWGMVARCHAR2(254)Y药物过敏98GMYWVARCHAR2(100)Y过敏药物疾病99SWHZSJVARCHAR2(100)Y死亡患者尸检100XXVARCHAR2(100)Y血型101RHVARCHAR2(100)YRh102KZRVARCHAR2(100)Y科主任103ZRYSVARCHAR2(100)Y主任(副主任)医师104ZZYSVARCHAR2(100)Y主治医师病理号死亡患者尸检105ZYYSVARCHAR2(100)Y住院医师出院情况入院病情106ZRHSVARCHAR2(100)Y责任护士107JXYSVARCHAR2(100)Y进修医师住108SXYSVARCHAR2(100)Y实习医师109BMYVARCHAR2(100)Y编码员110BAZLVARCHAR2(100)Y病案质量111ZKYSVARCHAR2(100)Y质控医师112ZKHSVARCHAR2(100)Y质控护士113ZKRQVARCHAR2(12)Y质控日期114SSJCZBM1VARCHAR2(100)Y手术及操作编码115SSJCZRQ1VARCHAR2(12)Y手术及操作日期116SSJB1VARCHAR2(100)Y手术级别117SSJCZMC1VARCHAR2(200)Y手术及操作名称118SZ1VARCHAR2(100)Y术者119YZ1VARCHAR2(100)YI助120EZ1VARCHAR2(100)YII助121QKDJ1VARCHAR2(100)Y切口等级122QKYHLB1VARCHAR2(100)Y切口愈合类别123MZFS1VARCHAR2(100)Y麻醉方式124MZYS1VARCHAR2(100)Y麻醉医师125SSJCZBM2VARCHAR2(100)Y手术及操作编码126SSJCZRQ2VARCHAR2(12)Y手术及操作日期127SSJB2VARCHAR2(100)Y手术级别128SSJCZMC2VARCHAR2(200)Y手术及操作名称129SZ2VARCHAR2(100)Y术者130YZ2VARCHAR2(100)YI助131EZ2VARCHAR2(100)YII助132QKDJ2VARCHAR2(100)Y切口等级133QKYHLB2VARCHAR2(100)Y切口愈合类别134MZFS2VARCHAR2(100)Y麻醉方式135MZYS2VARCHAR2(100)Y麻醉医师136SSJCZBM3VARCHAR2(100)Y手术及操作编码137SSJCZRQ3VARCHAR2(12)Y手术及操作日期138SSJB3VARCHAR2(100)Y手术级别139SSJCZMC3VARCHAR2(200)Y手术及操作名称140SZ3VARCHAR2(100)Y术者141YZ3VARCHAR2(100)YI助142EZ3VARCHAR2(100)YII助143QKDJ3VARCHAR2(100)Y切口等级144QKYHLB3VARCHAR2(100)Y切口愈合类别145MZFS3VARCHAR2(100)Y麻醉方式146MZYS3VARCHAR2(100)Y麻醉医师147SSJCZBM4VARCHAR2(100)Y手术及操作编码148SSJCZRQ4VARCHAR2(12)Y手术及操作日期149SSJB4VARCHAR2(100)Y手术级别150SSJCZMC4VARCHAR2(200)Y手术及操作名称151SZ4VARCHAR2(100)Y术者152YZ4VARCHAR2(100)YI助153EZ4VARCHAR2(100)YII助154QKDJ4VARCHAR2(100)Y切口等级155QKYHLB4VARCHAR2(100)Y切口愈合类别156MZFS4VARCHAR2(100)Y麻醉方式157MZYS4VARCHAR2(100)Y情况麻醉医师158SSJCZBM5VARCHAR2(100)Y手术及操作编码159SSJCZRQ5VARCHAR2(12)Y手术及操作日期160SSJB5VARCHAR2(100)Y手术级别161SSJCZMC5VARCHAR2(200)Y手术及操作名称162SZ5VARCHAR2(100)Y术者163YZ5VARCHAR2(100)YI助164EZ5VARCHAR2(100)YII助165QKDJ5VARCHAR2(100)Y切口等级166QKYHLB5VARCHAR2(100)Y切口愈合类别167MZFS5VARCHAR2(100)Y麻醉方式168MZYS5VARCHAR2(100)Y麻醉医师169SSJCZBM6VARCHAR2(100)Y手术及操作编码170SSJCZRQ6VARCHAR2(12)Y手术及操作日期171SSJB6VARCHAR2(100)Y手术级别172SSJCZMC6VARCHAR2(200)Y手术及操作名称173SZ6VARCHAR2(100)Y术者174YZ6VARCHAR2(100)YI助175EZ6VARCHAR2(100)YII助176QKDJ6VARCHAR2(100)Y切口等级177QKYHLB6VARCHAR2(100)Y切口愈合类别178MZFS6VARCHAR2(100)Y麻醉方式179MZYS6VARCHAR2(100)Y麻醉医师180SSJCZBM7VARCHAR2(100)Y手术及操作编码181SSJCZRQ7VARCHAR2(12)Y手术及操作日期182SSJB7VARCHAR2(100)Y手术级别183SSJCZMC7VARCHAR2(200)Y手术及操作名称184SZ7VARCHAR2(100)Y术者185YZ7VARCHAR2(100)YI助186EZ7VARCHAR2(100)YII助187QKDJ7VARCHAR2(100)Y切口等级188QKYHLB7VARCHAR2(100)Y切口愈合类别189MZFS7VARCHAR2(100)Y麻醉方式190MZYS7VARCHAR2(100)Y麻醉医师191LYFSVARCHAR2(100)Y离院方式192YZZY_YLJGVARCHAR2(200)Y医嘱转院,拟接收医疗机构名称193WSY_YLJGVARCHAR2(200)Y医嘱转社区卫生服务

1 / 10
下载文档,编辑使用

©2015-2020 m.777doc.com 三七文档.

备案号:鲁ICP备2024069028号-1 客服联系 QQ:2149211541

×
保存成功