新病案首页更新说明.doc

一、 新首页程序修改说明：住院医生站：1.【查询】-【病人医疗信息】窗口修改如下：新增籍贯、现住址、街村、邮编。新增入院途径。2、【首页】窗口修改如下：门诊诊断新增加了ICD10码。新增加了诊断的入院病情。手术新增加了级别。增加死亡患者尸检。新增医疗付费方式（如果结账方式为医保，系统自动选择医疗付费方式，且不能修改；如果是自费病人，则医生可以选择医疗付费方式）。新增新生儿出生体重、新生儿入院体重、离院方式、拟接受医疗结构名称、是否有出院31天内再住院计划、目的、颅脑损伤患者昏迷时间入院前、入院后。住院护士站：1、【护理文件】-【首页/医嘱单】窗口修改如下：新增责任护士。说明：系统自动根据病人出院时间打印新老病案首页格式。2012.1.1日前出院的病人使用老病案首页格式；2012.1.1起出院病人使用新病案首页格式。二、 新程序后台必须执行的SQL语句：-sql-离院方式字典create table comm.discharge_dict(serial_no number(2,0) null,discharge_code varchar2(10) not null,discharge_name varchar2(20) not null,py_code varchar2(10),wb_code varchar2(10),constraint pk_discharge_dict primary key (discharge_code);create public synonym discharge_dict for comm.discharge_dict;insert into metadict(table_name,table_description,table_id,table_names,py_code,input_code)values(DISCHARGE_DICT,离院方式,DISCHARGE_CODE,DISCHARGE_NAME,PY_CODE,WB_CODE);commit;-再住院目的字典create table comm.retrans_dict(serial_no number(2,0) null,retrans_code varchar2(10) not null,retrans_name varchar2(100) not null,py_code varchar2(10),wb_code varchar2(10),constraint pk_retrans_dict primary key (retrans_code);create public synonym retrans_dict for comm.retrans_dict;insert into metadict(table_name,table_description,table_id,table_names,py_code,input_code)values(RETRANS_DICT,再住院目的,RETRANS_CODE,RETRANS_NAME,PY_CODE,WB_CODE);commit;-医疗付费方式create table comm.mr_charge_type_dict(serial_no number(2,0) null,mr_charge_type_code varchar2(10) not null,mr_charge_type_name varchar2(20) not null,py_code varchar2(10),wb_code varchar2(10),constraint pk_mr_charge_type_dict primary key (mr_charge_type_code);create public synonym mr_charge_type_dict for comm.mr_charge_type_dict;insert into metadict(table_name,table_description,table_id,table_names,py_code,input_code)values(MR_CHARGE_TYPE_DICT,医疗付费方式字典,MR_CHARGE_TYPE_CODE,MR_CHARGE_TYPE_NAME,PY_CODE,WB_CODE);commit;-医疗机构字典create table comm.med_inst_dict(serial_no number(2,0) null,med_inst_code varchar2(20) not null,med_inst_name varchar2(200) not null,py_code varchar2(10),wb_code varchar2(10),constraint pk_med_inst_dict primary key (med_inst_code);create public synonym med_inst_dict for comm.med_inst_dict;insert into metadict(table_name,table_description,table_id,table_names,py_code,input_code)values(MED_INST_DICT,医疗机构,MED_INST_CODE,MED_INST_NAME,PY_CODE,WB_CODE);commit;-社区卫生服务站字典create table m_station_dict(serial_no number(2,0) null,comm_station_code varchar2(20) not null,comm_station_name varchar2(200) not null,py_code varchar2(10),wb_code varchar2(10),constraint pk_comm_station_dict primary key (comm_station_code);create public synonym comm_station_dict for m_station_dict;insert into metadict(table_name,table_description,table_id,table_names,py_code,input_code)values(COMM_STATION_DICT,社区卫生服务站,COMM_STATION_CODE,COMM_STATION_NAME,PY_CODE,WB_CODE);commit;-增加新生儿出生体重（克），入院体重（克）alter table MEDREC.pat_visit add weight_of_birth number(10,0);alter table MEDREC.pat_visit add weight_of_adm number(10,0);-增加死亡患者尸检标记 1.是2.否alter table MEDREC.pat_visit add die_check_flag number(10,0);-增加责任护士alter table MEDREC.pat_visit add task_nurse_no varchar2(20);alter table MEDREC.pat_visit add task_nurse varchar2(20);-医疗付款方式代码alter table MEDREC.pat_visit add mr_charge_type_code varchar2(10) ;-病人主索引中增加现住址、街村、邮编alter table MEDREC.pat_master_index add curr_place varchar2(6);alter table MEDREC.pat_master_index add curr_addr varchar2(255);alter table MEDREC.pat_master_index add curr_zip_code varchar2(12);-籍贯alter table MEDREC.pat_master_index add place_of_origin varchar2(6);-诊断中增加入院病情字段1.有2.临床未确定3.情况不明4.无alter table MEDREC.diagnosis add adm_condition varchar2(1);-手术中增加手术级别字段1.一级手术2.二级手术3.三级手术4.四级手术alter table MEDREC.Operation add operation_class varchar2(1);-增加离院方式、拟接收医疗机构名称、是否有出院31天内再住院计划、目的、颅脑损伤患者昏迷时间入院前、入院后alter table MEDREC.pat_visit add discharge_type varchar2(1);alter table MEDREC.pat_visit add accept_hospital_code varchar2(20);alter table MEDREC.pat_visit add accept_hospital_name varchar2(200);alter table MEDREC.pat_visit add reback_flag number(1,0);alter table MEDREC.pat_visit add purpose varchar2(200);alter table MEDREC.pat_visit add before_day varchar2(10);alter table MEDREC.pat_visit add before_hour varchar2(10);alter table MEDREC.pat_visit add before_min varchar2(10);alter table MEDREC.pat_visi