【正文】 VARCHAR2(1)YN性別BIRTHDAYDATEYN出生日期HEIGHTNUMBER(5,2)YN身高WEIGHTNUMBER(5,2)YN體重BLOOD_CODEVARCHAR2(1)YN血型編碼IN_DATEDATENN入院日期DEPT_CODEVARCHAR2(4)NN科室代碼DEPT_NAMEVARCHAR2(16)YN科室名稱SDEPT_CODEVARCHAR2(4)NN大科代碼SDEPT_NAMEVARCHAR2(10)YN大科名稱PAYKIND_CODEVARCHAR2(2)NN0:普通1:保險2:合同3:校工4:院工5:學(xué)生BED_NOVARCHAR2(10)NN病床號NURSE_CELL_CODEVARCHAR2(4)NN護(hù)理單元代碼NURSE_CELL_NAMEVARCHAR2(10)YN護(hù)理單元名稱HOUSE_DOC_CODEVARCHAR2(8)NN醫(yī)師代碼(住院)HOUSE_DOC_NAMEVARCHAR2(10)YN醫(yī)師姓名(住院)CHARGE_DOC_CODEVARCHAR2(8)NN醫(yī)師代碼(主治)CHARGE_DOC_NAMEVARCHAR2(10)YN醫(yī)師姓名(主治)CHIEF_DOC_CODEVARCHAR2(8)NN醫(yī)師代碼(主任)CHIEF_DOC_NAMEVARCHAR2(10)YN醫(yī)師姓名(主任)DUTY_NURSE_CODEVARCHAR2(8)YN護(hù)士代碼(責(zé)任)DUTY_NURSE_NAMEVARCHAR2(10)YN護(hù)士姓名(責(zé)任)OPER_DTIMEDATENN操作時間(最新)OPER_CODEVARCHAR2(8)NN操作員代碼IN_CIRCSVARCHAR2(1)YN入院情況IN_AVENUEVARCHAR2(1)YN入院途徑IN_SOURCEVARCHAR2(1)YN1:門診2:急診3:轉(zhuǎn)科4:轉(zhuǎn)院IN_TIMESNUMBER(2)YN住院次數(shù)END_DATEDATENN終止日期(匯總)BALANCE_DATEDATENN結(jié)算日期(上次)PREPAY_COSTNUMBER(10,2)NN預(yù)交金額TOT_COSTNUMBER(10,2)NN費(fèi)用金額OWN_COSTNUMBER(10,2)NN自費(fèi)金額PAY_COSTNUMBER(10,2)NN自付金額PUB_COSTNUMBER(10,2)NN公費(fèi)金額FREE_COSTNUMBER(10,2)NN余額BABY_FLAGVARCHAR2(1)NN1:有嬰兒0:無嬰兒DERATE_FLAGVARCHAR2(1)NNY:查詢費(fèi)用減免表N:沒有減免DOC_ADVICEDATEDATEYN最新醫(yī)囑日期IN_STATEVARCHAR2(1)YN0:登記1:接診2:轉(zhuǎn)科3:預(yù)約出院4:出院PREPAY_OUTDATEDATEYN出院日期(預(yù)約)HAPPEN_NONUMBER(5)YN發(fā)生序號BALANCE_NONUMBER(2)YN結(jié)算序號IDENNOVARCHAR2(18)YN身份證號PROF_CODEVARCHAR2(1)YN職業(yè)代碼WORK_NAMEVARCHAR2(10)YN工作單位WORK_TELVARCHAR2(10)YN單位電話WORK_ZIPVARCHAR2(6)YN單位郵編HOMEVARCHAR2(10)YN戶口或家庭地址HOME_TELVARCHAR2(10)YN家庭電話HOME_ZIPVARCHAR2(6)YN戶口或家庭郵編DISTVARCHAR2(10)YN籍貫NATION_CODEVARCHAR2(2)YN民族LINKMA_NAMEVARCHAR2(10)YN聯(lián)系人姓名LINKMAN_TELVARCHAR2(10)YN聯(lián)系人電話LINKMAN_ADDVARCHAR2(10)YN聯(lián)系人住址RELA_CODEVARCHAR2(1)YN聯(lián)系人關(guān)系MARIVARCHAR2(1)YN婚姻狀況COUN_CODEVARCHAR2(3)YN國籍患者診斷庫(II_DIAGNOSE)Table nameII_DIAGNOSENameTypeNullablePrimary KeyCommentsCARD_NOVARCHAR2(10)NY病歷號INPATIENT_NOVARCHAR2(14)NN住院流水號HAPPEN_NONUMBER(5)NN發(fā)生序號DIAG_KINDVARCHAR2(2)NN1：入院診斷2：出院診斷 3：轉(zhuǎn)科診斷ICD_CODEVARCHAR2(10)NN診斷ICD碼DIAG_NAMEVARCHAR2(50)NN診斷名稱DIAG_DATEDATENN診斷日期DOCT_CODEVARCHAR2(8)NN醫(yī)師代號DIAG_DOC_NAMEVARCHAR2(10)NN醫(yī)師姓名(診斷)DIAG_STATEVARCHAR2(1)NNO：舊診斷 N：新診斷SDEPT_CODEVARCHAR2(4)YN大科代碼DEPT_CODEVARCHAR2(4)NN科室代碼IN_DATEDATENN入院日期OUT_DATEDATEYN出院日期DIAG_OUTSTATEVARCHAR2(2)YN0：其他1：治愈2：好轉(zhuǎn)3：未愈4：死亡CURE_STATVARCHAR2(1)YN治療情況AV_DAYSNUMBER(4)YN平均住院日ALLERGENVARCHAR2(1)YN傳染病SECOND_ICDVARCHAR2(10)YN第二ICDSYNDROME_IDVARCHAR2(1)YN并發(fā)癥類別DIAG_MAINVARCHAR2(1)YN是否主診斷住院批費(fèi)藥品類(IF_MEDICINELIST)Table nameIF_MEDICINELISTNameTypeNullablePrimary KeyCommentsDRUG_CODEVARCHAR2(12)NY藥品編碼INPATIENT_NOVARCHAR2(14)YN住院流水號NAMEVARCHAR2(20)YN姓名DEPT_CODEVARCHAR2(4)YN科室代碼EXE_DEPT_CODEVARCHAR2(4)YN科室代碼(取藥)MEDI_DEPT_CODEVARCHAR2(4)YN科室代碼(藥房)NOTE_NOVARCHAR2(14)NN處方流水號CHOOSE_ONEVARCHAR2(1)YN擺藥與大處方QUANTITYNUMBER(7,2)NN數(shù)量TOT_COSTNUMBER(10,2)NN費(fèi)用金額OWN_COSTNUMBER(10,2)NN自費(fèi)金額PAY_COSTNUMBER(10,2)NN自付金額PUB_COSTNUMBER(10,2)NN公費(fèi)金額BACK_FEE_FLAGVARCHAR2(1)NN退費(fèi)標(biāo)志PAYKIND_CODEVARCHAR2(2)YN結(jié)算類別碼PACT_CODEVARCHAR2(10)YN合同代碼OPER_DTIMEDATENN操作時間DRUG_TYPEVARCHAR2(1)YN藥品類別DRUG_QUALITYVARCHAR2(2)YN藥品性質(zhì)PAY_RULEVARCHAR2(2)YN給付原則TRADE_NAMEVARCHAR2(32)YN藥品名稱BASE_DOSENUMBER(10,4)YN基本劑量DOSE_UNITVARCHAR2(4)YN劑量單位MIN_UNITVARCHAR2(4)YN最小單位PACK_UNITVARCHAR2(4)YN包裝單位PACK_QTYNUMBER(4)YN包裝數(shù)SPECSVARCHAR2(32)YN規(guī)格USAGE_CODEVARCHAR2(3)YN用法編碼FREQUENCY_CODEVARCHAR2(6)YN頻次編碼ONCE_DOSENUMBER(10,4)YN一次用量USE_WAY_CODEVARCHAR2(3)YN使用方式DOSE_MODEL_CODEVARCHAR2(3)YN劑型編碼HOME_MADEVARCHAR2(1)YN自制標(biāo)識APPEND_ITEMVARCHAR2(12)YN耗材標(biāo)記DOC_CODEVARCHAR2(6)YN手術(shù)醫(yī)師代碼SDEPT_CODEVARCHAR2(4)YN大科代碼IS_BABYNUMBER(5)YN是否嬰兒用藥DRUG_SEQUENCENUMBER(14)YN新批價的藥品，藥品流水號不同，退費(fèi)的藥品，藥品流水號與相對應(yīng)的批價藥品相同NURSE_STATIONVARCHAR2(4)YN護(hù)理站SALE_PRICENUMBER(10,4)YN單價OPER_CODEVARCHAR2(6)YN操作員(批價)SEND_OPER_CODEVARCHAR2(6)YN發(fā)藥人IS_JZQJVARCHAR2(1)YN急診搶救標(biāo)志DAYSNUMBER(4)YN天數(shù)DECMP_STATEVARCHAR2(1)YN醫(yī)囑是否分解BROUGHT_FLAGVARCHAR2(1)YN出院帶藥標(biāo)記DECMPS_STATEVARCHAR2(1)YN醫(yī)囑是否分解APPRNOVARCHAR2(15)YN審批號住院批費(fèi)非藥品類(IF_FEEITEMLIST)TABLE NAMEIF_FEEITEMLISTNameTypeNullablePrimary KeyCommentsINPATIENT_NOVARCHAR2(14)NY住院流水號SYS_CLASSVARCHAR2(3)YN藥品檢查化驗(yàn)手術(shù)衛(wèi)材處置治療營養(yǎng)床費(fèi)等ITEM_TYPEVARCHAR2(12)YN項(xiàng)目分類NOTE_NOVARCHAR2(14)NN處方流水號ITEM_CODEVARCHAR2(12)NN項(xiàng)目代碼ITEM_NAMEVARCHAR2(50)YN項(xiàng)目名稱FEE_CODEVARCHAR2(3)NN最小費(fèi)用代碼AMOUNTNUMBER(6,2)NN數(shù)量PRICENUMBER(8,2)NN價格TOT_COSTNUMBER(10,2)YN費(fèi)用金額OWN_COSTNUMBER(10,2)YN自費(fèi)金額PAY_COSTNUMBER(10,2)YN自付金額PUB_COSTNUMBER(10,2)YN公費(fèi)金額DEPT_CODEVARCHAR2(4)YN科室代碼EXE_DEPT_CODEVARCHAR2(4)YN科室代碼(執(zhí)行)CDEPT_CODEVARCHAR2(4)YN科室代碼(開立)DOCT_CODEVARCHAR2(6)YN醫(yī)師代碼PIECE_NUMNUMBER(3)YN件數(shù)BACK_FEE_FLAGVARCHAR2(1)NN退費(fèi)標(biāo)志PAYKIND_CODEVARCHAR2(2)YN結(jié)算類別碼OPER_CODEVARCHAR2(6)YN操作員代碼OPER_DTIMEDATEYN