和HIS接口解決方案2

經典word整理文檔，僅參考，雙擊此處可刪除頁眉頁腳。本資料屬于網絡整理，如有侵權，請聯(lián)系刪除，謝謝！B的與系~}4.:綠色：HIS系統(tǒng)。藍色：電子病歷系統(tǒng)。，雙方通信通過數據庫，EMR被動請求通信。，此業(yè)務流程中，不需要HIS端支持，電子病歷需要手工同步HIS已入院，EMR中未入院的病人。2，此業(yè)務雙方通信，由EMR主動觸發(fā)。HISEMREMR!綠色：HIS系統(tǒng)。藍色：電子病歷系統(tǒng)。Package:Diagram:聊城2院入院databasestudiousDate:2009-08-06成功消息藍色：電子病歷系統(tǒng)。2，雙方服務接口，通過WebService方式進行通信。，此業(yè)務流程中，HIS發(fā)起請求，電子病歷自動接受新入院病人數據，進行處理。HISHIS:…和、手術預約；|IDIDNumber(9)Varchar2(40)》NAMEAGE·BIRTHDAYSEXVarchar2(8)Varchar2(8)Varchar2(40)$MEDICAL_TYPE~IDENTITY_NOHID、Varchar2(40)CIDVarchar2(40)Varchar2(40)@REGION_NOREGION_NAMEVarchar2(40)—DEPTBEDVarchar2(40)Varchar2(40)》DIAGNOSIS_CODEVarchar2(200)Varchar2(200)>多個診斷用“,”分DIAGNOSIS_NAME多個診斷用“,”分割。多個手術用“,”分割。（Varchar2(200)Varchar2(200)Varchar2(40)Timestamp(6)多個手術用“,”分割。*OPERATOROPERATIONDATE@OPERATIONTIMEROOM%OPERATINGTABLEVarchar2(2)@ANAESTHETISTVarchar2(40)CIRCUANESTHETIST|Varchar2(40)ANAES_ASSISTANTVarchar2(40)Varchar2(40)]ASSISTANT1ASSISTANT2Varchar2(40)#INSTRNURSE1INSTRNURSE2Varchar2(40)Varchar2(40)\CIRCUNURSE1Varchar2(40)Varchar2(40)！CIRCUNURSE2/Varchar2(600)OPT_LEVELVarchar2(4)Boolean)EMERGENCYCHARGES_TYPE收費類型預約狀態(tài)Varchar2(4)Varchar2(1)-STATE在、與到Number(9)—IDNAMEVarchar2(40)—AGEBIRTHDAY、SEX}MEDICAL_TYPEIDENTITY_NO`Varchar2(40)HIDVarchar2(40)Varchar2(40)、CIDREGION_NOVarchar2(40):NotnullREGION_NAMEDEPTVarchar2(40)Varchar2(40)[BED床號Varchar2(40){DIAGNOSIS_CODEVarchar2(200)多個診斷用“,”分割。DIAGNOSIS_NAME多個診斷用“,”分割。~Varchar2(200)Varchar2(200)Varchar2(200)Varchar2(40)多個手術用“,”分割。多個手術用“,”分割。,OPERATOR;OPERATIONDATEOPERATIONTIME.ROOMVarchar2(40)Varchar2(2)<OPERATINGTABLEANAESTHETIST；Varchar2(40)CIRCUANESTHETISTVarchar2(40)Varchar2(40)[ANAES_ASSISTANTASSISTANT1Varchar2(40)'ASSISTANT2Varchar2(40)Varchar2(40)INSTRNURSE1~INSTRNURSE2Varchar2(40)Varchar2(40)\CIRCUNURSE1CIRCUNURSE2、Varchar2(40)Varchar2(600)Varchar2(4)|OPT_LEVELEMERGENCYBoolean？CHARGES_TYPESTATEVarchar2(4)Varchar2(1)`預約狀態(tài)12某觸發(fā)器，當中產生新的預約時由程序觸發(fā)數據庫中的Create_His_Registry_Operation《當到His_Registry_Operation；、表》IDNumber…TORCINPATIENT_IDCODEVarchar2(20)\Varchar2(20)…NAMESTATE檢驗檢查項目名稱Varchar2(50)1.申請未完成,2.申請已完成,3.預約,4.報告完成\Varchar2(1)USER_IDVarchar(20)timestamp^BESPEAK_DATEtimestamp}BESPEAK_CREATORVarchar2(20)Varchar2(20);預約創(chuàng)建人AUDITING_TIMEtimestamptimestamp[SPEAK_TIMEAPPLY_TIME/timestampSPEAKERVarchar2(20)Varchar2(20)`SPEAKER_NAMEAUDITING_MANVarchar2(20)…Varchar2(20)Varchar2(1000)@SECTION_IDVarchar2(20)Varchar2(50)？SECTION_NAMESAMPLE？Varchar2(20)CLINIC_CIRCSVarchar2(50)Varchar2(50)$PICTUREEXAMCHECK_PARTVarchar2(20)@EXAMCHECK_AIMREPORT_CONTENTVarchar2(50)Varchar2(500)%Varchar2(50)Varchar2(50)[EXAMCHECK_SEEIDEA|Varchar2(50)病人入院情況及診Varchar2(50)…FEE、[IDNumber@EXAMINE_IDITEM_CODE項目代碼Varchar2(20)；ITEM_NAMEREF_VALUEVarchar2(50)Varchar2(50)]VALUE_TYPEVarchar2(20)Varchar2(20)"UNIT_CODEVALUE_NUM；VALUE_STRVarchar2(50)Varchar2(20)：VALUR_CODE3.IDID"MEDICINE_IDMEDICINE_CODE,HIS_MEDICINE_CODEHIS藥品名稱MEDICINE_NAME[SPEC"FIRMBATCH《PRICE_MIN_PACKAGE價格;SOURCE…<IS_CHARGED{·IDCODE—[SPECNAME{TYPE全科、麻醉……（常量）ENABLE￥SOURCE【PINYINBRIEF_NAME*DOSAGE_UNIT劑量單位Varchar2^ID《CODE(NAMETYPE&SUBTYPEENABLEPINYIN輸血、晶體液、膠體液、其他……￥快捷碼"SPECBRIEF_NAME`DOSAGE_UNIT劑量單位Varchar2；IO_DEFINATIONID\MEDICINE_CODE'\FIRM…BATCH]>ENABLE。<ID)`SPEC！PINYINUNIT…Varchar2(10)PRICE醫(yī)技、耗材、儀器使用等*TYPEENABLE可用標志Varchar2(1)-&CHARGE_TYPE[CHARGE_ITEM_ID與ChargeItemPackagesRel關聯(lián)}ID]@PINYIN-TYPEENABLE&與ChargeItemPackagesRel關聯(lián)；ID^、CHARGE_ITEM_ID!量Notnull】IDCODE…NAMEPINYIN>類型ENABLE—ID、CODE>NAMEPINYIN~ENABLE可用標志Varchar2IDIDNumberVarchar2Varchar2Varchar2NumberVarchar2Varchar2Varchar2ACTUALNAMEPOSITIONPASSWORDROLE_IDENABLETITLEEXECUTIVE_LEVELID行政級別I