和HIS接口解決方案2

經(jīng)典word整理文檔，僅參考，雙擊此處可刪除頁眉頁腳。本資料屬于網(wǎng)絡(luò)整理，如有侵權(quán)，請聯(lián)系刪除，謝謝！B的與系~}4.:綠色：HIS系統(tǒng)。藍色：電子病歷系統(tǒng)。，雙方通信通過數(shù)據(jù)庫，EMR被動請求通信。，此業(yè)務(wù)流程中，不需要HIS端支持，電子病歷需要手工同步HIS已入院，EMR中未入院的病人。2，此業(yè)務(wù)雙方通信，由EMR主動觸發(fā)。HISEMREMR!綠色：HIS系統(tǒng)。藍色：電子病歷系統(tǒng)。Package:Diagram:聊城2院入院databasestudiousDate:2009-08-06成功消息藍色：電子病歷系統(tǒng)。2，雙方服務(wù)接口，通過WebService方式進行通信。，此業(yè)務(wù)流程中，HIS發(fā)起請求，電子病歷自動接受新入院病人數(shù)據(jù)，進行處理。HISHIS:…和、手術(shù)預(yù)約；|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多個診斷用“,”分割。多個手術(shù)用“,”分割。（Varchar2(200)Varchar2(200)Varchar2(40)Timestamp(6)多個手術(shù)用“,”分割。*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收費類型預(yù)約狀態(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)多個手術(shù)用“,”分割。多個手術(shù)用“,”分割。,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)`預(yù)約狀態(tài)12某觸發(fā)器，當(dāng)中產(chǎn)生新的預(yù)約時由程序觸發(fā)數(shù)據(jù)庫中的Create_His_Registry_Operation《當(dāng)?shù)紿is_Registry_Operation；、表》IDNumber…TORCINPATIENT_IDCODEVarchar2(20)\Varchar2(20)…NAMESTATE檢驗檢查項目名稱Varchar2(50)1.申請未完成,2.申請已完成,3.預(yù)約,4.報告完成\Varchar2(1)USER_IDVarchar(20)timestamp^BESPEAK_DATEtimestamp}BESPEAK_CREATORVarchar2(20)Varchar2(20);預(yù)約創(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可用標(biāo)志Varchar2(1)-&CHARGE_TYPE[CHARGE_ITEM_ID與ChargeItemPackagesRel關(guān)聯(lián)}ID]@PINYIN-TYPEENABLE&與ChargeItemPackagesRel關(guān)聯(lián)；ID^、CHARGE_ITEM_ID!量Notnull】IDCODE…NAMEPINYIN>類型ENABLE—ID、CODE>NAMEPINYIN~ENABLE可用標(biāo)志Varchar2IDIDNumberVarchar2Varchar2Varchar2NumberVarchar2Varchar2Varchar2ACTUALNAMEPOSITIONPASSWORDROLE_IDENABLETITLEEXECUTIVE_LEVELID行政級別I