WS 445-448 - 电子病历基本数据集等20项标准-2014 excel版

数据采集说明,,每天同步最新的数据,,,,,,,

No,住院结算,HBI_IN_SETTLE,版本号：v1.0.0,,,,,,

,字段名,字段含义,数据类型,长度,主键,非空,索引,"关键

字段",备注

1,ID,主键,VARCHAR2(字符串),64,,,,,

2,SRC_ID,源表主键,VARCHAR2(字符串),64,,,,,源表物理主键

3,HOSP_ID,医疗机构编码,VARCHAR2(字符串),64,,,,,

4,HOSP_NAME,医疗机构名称,VARCHAR2(字符串),64,,,,,

5,SETTLE_ID,结算ID,VARCHAR2(字符串),64,,,,,

6,SETTLE_NUM,结账次数,VARCHAR2(字符串),64,,,,,

7,IN_NO,住院号,VARCHAR2(字符串),64,,,,,

8,IN_NUM,住院次数,INT(整数),,,,,,

9,SETTLE_DATE,结算日期,VARCHAR2(字符串),8,,,,,YYYYMMDD

10,ACCOUNT_DATE,记账日期,VARCHAR3(字符串),8,,,,,YYYYMMDD

11,CHARGE_DATE,收费日期,VARCHAR4(字符串),8,,,,,YYYYMMDD

12,MEDICARE_TYPE_CODE,医疗保险类别代码,VARCHAR2(字符串),8,,,,,参考医疗保险类别

13,MEDICARE_TYPE_NAME,医疗保险类别名称,VARCHAR2(字符串),32,,,,,

14,PAY_METHOD_CODE,医疗费用支付方式代码,VARCHAR2(字符串),8,,,,,参考医疗支付方式字典

15,PAY_METHOD_NAME,医疗费用支付方式名称,VARCHAR2(字符串),32,,,,,

16,CURR_DEPT_CODE,科室代码,VARCHAR2(字符串),32,,,,,

17,CURR_DEPT_NAME,科室名称,VARCHAR2(字符串),32,,,,,

18,CURR_WARD_CODE,病区代码,VARCHAR2(字符串),32,,,,,

19,CURR_WARD_NAME,病区名称,VARCHAR2(字符串),32,,,,,

20,TOTAL_FEE,总费用,NUMBER(数值),"2,8",,,,,

21,MEDICARE_FEE,医保支付金额,NUMBER(数值),"2,8",,,,,

22,SELF_PAYMENT_FEE,自付总金额,NUMBER(数值),"2,8",,,,,

23,OFF_FEE,优惠金额,NUMBER(数值),"2,8",,,,,

24,ADV_PAY_FEE,预交金支付金额,NUMBER(数值),"2,8",,,,,

25,BACK_ADV_PAY_FEE,退预交金金额,NUMBER(数值),"2,8",,,,,

26,RESUB_FEE,补交金额,NUMBER(数值),"2,8",,,,,

27,BLANCE_FEE,结存金额,NUMBER(数值),"2,8",,,,,

28,OWE_FEE,欠费金额,NUMBER(数值),"2,8",,,,,

29,SETTLE_STATUS,结算状态,VARCHAR2(字符串),8,,,,,

30,REFUND_FLAG,退费标志,VARCHAR2(字符串),8,,,,,

31,SETTLE_METHOD_CODE,结算方式代码,VARCHAR2(字符串),8,,,,,

32,SETTLE_METHOD_NAME,结算方式名称,VARCHAR2(字符串),32,,,,,

33,SETTLE_DEPT_CODE,结算科室代码,VARCHAR2(字符串),32,,,,,

34,SETTLE_DEPT_NAME,结算科室名称,VARCHAR2(字符串),32,,,,,

35,SETTLE_STAFF_CODE,结算职工工号,VARCHAR2(字符串),32,,,,,

36,SETTLE_STAFF_NAME,结算职工姓名,VARCHAR2(字符串),16,,,,,

37,RECORD_DTIME,数据采集时间,DATE(日期时间),,,,,,管理字段

38,RECORD_UPDATE_DTIME,数据更新时间,DATE(日期时间),,,,,