门诊系统数据表结构说明书

1、CHISC.NET - 国内第一医疗信息化网站 ,为业内人士提供最强大的交流共享平台门诊系统数据表结构说明书注：此结构文档为文档完成当前时间的标准数据结构。因系统不断升级，数据结构也相应地升级，因此，当前数据结构以DATA文件夹下的数据结构文件（.XML）为准。MZ_BH门诊病人登记表序号列名中文名称类型长度小数充许为空自动增加备注1LSH流水号int40002GHRQ挂号日期int00103RQ日期tinyint10104MZH门诊号varchar150105XM姓名varchar400106ICYEIC余额money84107GHLB挂号类别tinyint10108KSBM科室编码varc

2、har100109YS医生varchar1001010RYCS初复诊tinyint101011ZD诊断varchar1601012XB性别varchar201013FB费别tinyint101014CSRQ出生日期datetime831015SFZH身份证号varchar1801016JTZZ家庭住址varchar3001017cJTZZ详细家庭住址varchar5001018CBH参保号varchar2001019GHBHIC卡号varchar2001020HTDW合同单位varchar1001021QT备注varchar2001022STATE状态tinyint001023FZYS分诊医生

3、varchar1001024BQJL病情记录image001025FZCXint001026GHXH挂号序号smallint001027XXZD详细诊断varchar5001028ICDFLAGtinyint101029YETZ婴儿体重smallmoney001030LXDH联系电话varchar1001031BRTW0money001032BRFR1int001033DBRDHvarchar2001034DBRXMvarchar1001035DBRXBvarchar201036DBRCSRQint001037DBRSFZHvarchar3001038BRFR0int001039GZDW工作单

4、位varchar5001040PHONE工作单位电话varchar2001041MZ民族varchar1001042SF身分varchar1001043BSLQK病生理情况smallint0010STATE BIT0: 0=候诊 1=就诊; BIT1: 0=未分诊 1=已分诊; BIT2: 0=未挂号 1=已挂号; BIT3: 0=未退号 1=已退号;BSLQK: 病生理情况bit0: 孕妇bit1: 肝功能不全bibt2: 肾功能不全bit4: 哺乳期bit5: 严重肝功能不全bit6: 严重肾功能不全MZ_BL门诊病历序号列名中文名称类型长度小数充许为空自动增加备注1MZHvarchar1

5、50002ZYHvarchar150103XMvarchar400104XBvarchar20105FBtinyint10106CSRQdatetime83107SFZHvarchar180108JTZZvarchar300109cJTZZvarchar5001010RYCStinyint101011CBHvarchar2001012GHBHvarchar2001013QTvarchar2001014HTDWvarchar1001015PRNPAGEtinyint101016PRNCOLtinyint101017PRNROWtinyint101018GMvarchar5001019YETZsm

6、allmoney001020LXDHvarchar2001021GZDW工作单位varchar5001022PHONE工作单位电话varchar2001023MZ民族varchar2001024EMPI居民健康档案唯一索引varchar5001025BSLQK病生理情况smallint0010MZ_CF门诊处方明细表序号列名中文名称类型长度小数充许为空自动增加备注1SFIDint40002CFIDint40103BM编码varchar200004YL用量money00105ZL总量money92106CS次数varchar100107YF用法varchar100108DJ单价smallmone

7、y44109FY费用money841010FYLB费用类别smallint101011STATEtinyint101012ZRL折让率numeric961013YFDJ用法单价smallmoney001014YFFYLB用法费用类别smallint001015YFFY用法费用money001016XH序号smallint001017LX类型tinyint001018TS天数tinyint001019CLLB处理类别tinyint001020YFCLLB用法处理类别tinyint001021SQDH申请单号int001022SM说明varchar2001023CFYLDWLX处方用量单位类型ti

8、nyint101024CFYLDW处方用量单位varchar401025CFZLDWLX处方总量单位类型tinyint101026MGROUPIDint001027ZXBZ专项标志int001028ZSZH注射组号smallint001029F_PRINT打印标志tinyint001030CFMC处方名称varchar10001031ZXKS执行科室varchar1001032YDJ原单价money0010STATE BIT3-0(数字): ; 0=西药 1=中药 ; 2=注射 3=检查(当BIT7=1时有效); BIT6:0=总量使用剂量单位; BIT6:1=总量使用包装单位; BIT7:

9、; 0=收费员录入的项目 ; 1=医生录入的项目;ZXBZ: bit0:是否专项; bit4:是否自备 bit8:是否组合项目 bit9:是否试敏（仅对医生站有效） Bit10:是否门诊治疗项目组合 bit11:协议处方 F_PRINT: bit0 : 注射单是否已打印(在注射室打印)MZ_FY门诊病人费用表序号列名中文名称类型长度小数充许为空自动增加备注1SFIDint40002HSFFtinyint10003FYLBsmallint10004FYmoney84105JZDWvarchar10010MZ_FYADD门诊病人费用表补充序号列名中文名称类型长度小数充许为空自动增加备注1SFIDi

10、nt00102LX类型tinyint00103HSFFtinyint00104FYLBsmallint00105ZXKS执行科室varchar100106FYmoney0010LX=1: 折扣金额，该金额未包含在MZ_FY表中的数据。即该金额是通过折扣前单价计算出来的折扣金额，MZ_FY表中保存的是折后金额2: 各ZXKS对应的基类费用明细（包括基类费用为空的）及支付方式费用。3: 因DJ与YDJ不等的折让金额ZXKS:仅在LX=2时才有效MZ_FYTJB1门诊费用统计表序号列名中文名称类型长度小数充许为空自动增加备注1TJBBMsmallint20102YEARsmallint20103MO

11、NTHtinyint10104HSFFtinyint10105GROUPNAMEvarchar100106CFZSint40107JEmoney84108FLXHsmallint10109GROUP1varchar1001010FLAGtinyint1010MZ_GHNO门诊挂号编号序号列名中文名称类型长度小数充许为空自动增加备注1RQint40102GHLBtinyint10103GHBMvarchar100104MAXNOsmallint20105CURNOsmallint20106FLAGtinyint10107KSCOUNTsmallint0010MZ_RZ门诊系统工作日志序号列名中文

12、名称类型长度小数充许为空自动增加备注1SJdatetime83102CZNRvarchar1000103OPERATEvarchar100104GZZvarchar150105LKSJdatetime8310MZ_SF门诊收费表序号列名中文名称类型长度小数充许为空自动增加备注1SFIDint40002RQ日期tinyint10103CFRQ处方日期int00104SFRQ收费日期int00105SJ时间int20106LSH流水号int40107CFLB处方类别tinyint10108YS医生varchar100109FKFS付款方式varchar401010CZRY操作人员varchar10

13、01011FPBH发票编号int401012KS科室varchar1001013STATE状态tinyint101014YBDJH医保单据号varchar2001015RJIDint401016GM过敏varchar5001017XYKYH信用卡银行smallint001018XYKNO信用卡号varchar2001019LYQ领药区tinyint101020FPS发票数tinyint001022TJDH体检单号int001023CKH窗口号varchar2001024HSXZ核算小组varchar1001026YLMEMOvarchar2001027RYFB人员费别tinyint0010暂时

14、门诊收费每次收费时写入,其他地方未使用.等以后改动程序,RYFB使用MZ_SF表的数据28FPQZ发票前缀varchar10010为桂洲医院加29MZSFC门诊收费处编码varchar1001030F_PRINTCF处方是否已打印tinyint001031FB费别tinyint001032FLAGtinyint001033ZD诊断varchar1601034XXZD详细诊断varchar5001035BYQMvarchar1001036FYQMvarchar1001037CZKID储值卡内部IDint001038F_PRINTCFQD处方清单1081格式打印次数tinyint0010STATE

15、 BIT0: 0=收费 1=退款; BIT1: 0=未日结 1=已日结; BIT2: 0=挂号处收费 1=收费处收费; BIT3: 0=未重打发票 1=已重打发票; BIT5-6: ; 00=收费处处方 10=电子处方 ; 01=药房划价 11=体检处方; BIT7: 0=已收费 1=未收费FLAG: BIT0: 1=医生电子签名 BIT1: 1=摆药电子签名 BIT2: 1=发药电子签名MZ_SFRJ0门诊日结单0序号列名中文名称类型长度小数充许为空自动增加备注1RJSJnumeric1810102CZRYvarchar100103RJIDint40104FLAGtinyint10105KS

16、FPHint40106JSFPHint40107ZFFPHtext160108FPS使用发票数int00109KSRQint001010JSRQint001011MZSFC门诊收费处varchar2001012FP记录使用发票信息text1601013ZFFPS退款发票数int001014CDFPS重打发票数int001015KSSJ开始时间int401016JSSJ结束时间int401017SYFPHText001018F_JKQK交款情况tinyint001019RJRY日结操作人员编码varchar1001020SKRY收款人员编码varchar1001021TKFPH退款发票号text

17、001022LASTRJSJ上次日结时间datetime0010FLAG 0：收费处个人日结 ; 1：收费处全院日结; 2：挂号处个人日结 ; 3：挂号处全院日结F_JKQK: （目前仅对汕头医院的日结有效）NULL或0： 历史记录1 ： 未缴款2 ： 已交款MZ_SFRJ1门诊日结单1序号列名中文名称类型长度小数充许为空自动增加备注1RJIDint40102HSFFtinyint10103FYLBsmallint10104XMtinyint10105FYmoney84106BSint40107FPDvarchar30010MZ_TK门诊退款序号列名中文名称类型长度小数充许为空自动增加备注1T

18、KRQdatetime83102SFIDint40103CFRQint40104CZRYvarchar100105FPHint40106FPStinyint00107STATEtinyint10108RJIDint40109JZRYvarchar1001010JZRQint401011FPQZ发票前缀varchar1001012MZSFC门诊收费处varchar10010STATE BIT0: 0=挂号处收费 1=收费处收费; BIT1: 0=未日结 1=已日结; BIT2: 0=退款 1=重打发票; BIT3: 0=退药未记帐 1=退药已记帐;MZ_CFD门诊收费项目明细序号列名中文名称类型

19、长度小数充许为空自动增加备注1SFIDint00102DGROUPIDint00103BMvarchar20010His的4DJmoney00105FYLBsmallint00106YZZL种类tinyint00107ZLmoney00108ZKL折扣率numeric96109YZLXtinyint001010FYmoney001011F_YCSF是否一次性收费tinyint001012YDJ原单价money0010YZZL=1:检验组合项目明细 2：用法费用项目明细 3：自动收费项目明细 4：中药处方明细（保留以后升级用）F_YCSF:=0:计费时总量为：CF.TS*CF.RYCS*ZL=1

20、:计费时总量为：ZLMZ_ZYCF门诊中药处方序号列名中文名称类型长度小数充许为空自动增加备注1SFIDint40102CFIDint40103BM编码varchar200104YL每剂用量money40105DJsmallmoney44106FYLBsmallint10107FYmoney84108ZRLsmallmoney44109XHtinyint101010JF每剂金额varchar1001011ZYCFMCvarchar10001012ZXBZsmallint001013MJZL每剂总量money001014YDJ原单价money0010ZXBZBit9:是否中药协议处方(中药协议处

21、方处方及清单,发药均不显示明细,记帐时才按明细进行,实时库存不检测其库存)MZ_TMPBH门诊病号暂存表序号列名中文名称类型长度小数充许为空自动增加备注1LSHint40002GHRQint00103RQtinyint10104MZHvarchar100105XMvarchar400106ICYEmoney84107GHLBtinyint10108KSBMvarchar100109YSvarchar1001010RYCStinyint101011ZDvarchar1601012XBvarchar201013FBtinyint101014CSRQdatetime831015SFZHvarchar

22、1801016JTZZvarchar3001017cJTZZvarchar5001018CBHvarchar2001019GHBHvarchar2001020STATEtinyint001021ZCRQint001022HTDWvarchar1001023QTvarchar20010MZ_TMPSF门诊收费暂存表序号列名中文名称类型长度小数充许为空自动增加备注1SFIDint40002RQtinyint10103SJint20104LSHint40105CFLBtinyint10106YSvarchar100107FKFSvarchar40108CZRYvarchar100109FYRYvar

23、char1001010BYRYvarchar1001011FPBHint401012KSvarchar1001013STATEtinyint101014YBDJHvarchar2001015GHRQint0010MZ_TMPCF门诊处方暂存表序号列名中文名称类型长度小数充许为空自动增加备注1SFIDint40002CFIDint40103BM编码varchar200004YLreal40105ZLmoney92106CSvarchar100107YFvarchar100108DJmoney84109FYmoney841010FYLBsmallint101011STATEtinyint10101

24、2ZRLsmallmoney441013XHtinyint001014LXtinyint001015TStinyint001016ZSZHsmallint0010MZ_TMPFY门诊费用暂存表序号列名中文名称类型长度小数充许为空自动增加备注1SFIDint40002HSFFtinyint10003FYLBsmallint10004FYmoney8410MZ_TMPZYCF门诊中药处方暂存表序号列名中文名称类型长度小数充许为空自动增加备注1SFIDint40102CFIDint40103BM编码varchar200104YLreal40105DJsmallmoney44106FYLBsmalli

25、nt10107FYmoney84108XHtinyint0010MZ_YPQLDM门诊药品请领单M序号列名中文名称类型长度小数充许为空自动增加备注1SFIDint00102CKHtinyint00103YPLXtinyint00105QLDHint00106QLRQint00107QLSJint00108CFIDint00109BYRYvarchar1001010JZRYvarchar1001011FYRYvarchar1001012FLAGsmallint001013ZYFStinyint001014SMvarchar2001015JZRQint001016JZSJint001017LYQt

26、inyint101018HZDHint401019TYDHint401020BYCKHtinyint001021YFBMvarchar1001022TYRY退药人员编码varchar1001023TYRQint001024TYSJint001025F_YXFY优先发药标志tinyint0010FLAG BIT0: 0=领药 1=退药; BIT1: 0=未摆药 1=已摆药; BIT2: 0=未发药 1=已发药; BIT3: 0=未记帐 1=已记帐; BIT4: 0=未打印 1=已打印; BIT5: 0=退药未记帐 1=退药已记帐; BIT6: 0=退药未处理 1=退药已处理; BIT7: 0=未

27、暂存 1=已暂存;MZ_YPQLDD门诊药品请领单D序号列名中文名称类型长度小数充许为空自动增加备注1QLDHint00102YPBMvarchar200103XHint00104YLreal00105YFvarchar60106CSvarchar60107ZLsmallmoney00108DJsmallmoney00109FYmoney001010JFvarchar1001011SMvarchar2001012CFIDint401013TStinyint101014CFXHtinyint101015LXtinyint101016F_FYtinyint101017ZSZH注射组号smallin

28、t001018PCID药房入库批次IDint001019ZXBZint001020ISSFYBL是否收费员补录项目tinyint001021AUTOINC唯一值，用于更新PCIDint0011F_FY：0/1是否已发药ZXBZ: bit4:是否自备药MZ_ZSGZL1门诊注射工作量1序号列名中文名称类型长度小数充许为空自动增加备注1GROUPIDint00102ZSXMvarchar100103SLsmallint00104FStinyint00105ZFSsmallint00106AUTOINCint0011MZ_ZSDJB门诊注射登记表序号列名中文名称类型长度小数充许为空自动增加备注1ZS

29、DHint00102RQint00103ZSCStinyint00104FLAGtinyint0010MZ_ZSGZL0门诊注射工作量0序号列名中文名称类型长度小数充许为空自动增加备注1ZSDHint00102CFRQint00103ZSRYvarchar100104ZSKSvarchar100105CZRQint00106ZSXHtinyint00107GROUPIDint00108HZDHint00109FLAGtinyint0010MZ_ZSHZD0门诊注射汇总单0序号列名中文名称类型长度小数充许为空自动增加备注1HZDHint00102HZRQint00103HZRYvarchar10

30、0104JZRQint00105JZRYvarchar100106ZSKSvarchar100107FLAGtinyint0010MZ_ZSHZD1门诊注射汇总单1序号列名中文名称类型长度小数充许为空自动增加备注1HZDHint00102YPBMvarchar200103SLmoney0010MZ_YSWORK门诊医生工作记录序号列名中文名称类型长度小数充许为空自动增加备注1YSvarchar100102HOSTNAMEvarchar150103SPIDsmallint20104FZTHint40105FLAGtinyint1010MZ_TZBZDBL门诊特种病诊断病历序号列名中文名称类型长度

31、小数充许为空自动增加备注1CBHvarchar200102GHBHvarchar200103ZDvarchar16010MZ_IC0门诊IC卡序号列名中文名称类型长度小数充许为空自动增加备注1ICKHvarchar200002MZHvarchar100103XMvarchar400104ICYEmoney00105RQint00106SJint00107CZRYvarchar100108ISLOSEtinyint00109FLAGtinyint001010NEWICKHvarchar2000011BZvarchar5001012PASSWORDvarchar10010MZ_IC1门诊IC卡明细表序号列名中文名称类型长度小数充许为空自动增加备注1ICKHvarchar200002BICJEmoney00103CRJEmoney00104ZCJEmoney00105EICJEmoney00106SFIDint00107RQint00108SJint00109CZRYvarchar1001010FLAGtinyint00