2022年表结构 .pdf
《2022年表结构 .pdf》由会员分享,可在线阅读,更多相关《2022年表结构 .pdf(26页珍藏版)》请在淘文阁 - 分享文档赚钱的网站上搜索。
1、统计系统代码表1DDHC_WorkLoad 收入数据表字段名称说明类型备注WorkLoad_ARPBL_DR 帐单号 DHC_PatientBill Designative Reference AR_PatientBill WorkLoad_BillGrp_DR 帐单大类 ARC_BillGrp Designative Reference WorkLoad_BillSub_DR 帐单子类 ARC_BillSub Designative Reference WorkLoad_CasherI_DR SS_User Designative Reference ?WorkLoad_CasherO_DR
2、 SS_User Designative Reference ?WorkLoad_DisDate Date WorkLoad_DisFlag Text WorkLoad_Flag Text WorkLoad_FlagDate 结算日期Date WorkLoad_FlagTime Time WorkLoad_HoldDep_DR CT_Loc Designative Reference WorkLoad_HoldDoc_DR CT_CareProv Designative Reference WorkLoad_HoldFlag Text WorkLoad_HoldFlagDate Date Wo
3、rkLoad_ItemCat_DR 医嘱子类 ARC_ItemCat Designative Reference WorkLoad_ItemOrd_DR 医嘱项 ARC_ItmMast Designative Reference WorkLoad_OEORI_DR 医嘱 OE_OrdItem Designative Reference WorkLoad_OrdDate 医嘱日期Date WorkLoad_OrdStatus Multiple Choice WorkLoad_OrdTime WorkLoad_PAADM_DR Pa_adm Designative Reference WorkLo
4、ad_PAPMI_DR PA_PatMas Designative Reference WorkLoad_PatDep_DR 下医嘱科室CT_Loc Designative Reference WorkLoad_PatDoc_DR 病人医生 CT_CareProv Designative Reference WorkLoad_PatWard_DR 病人病区 CT_Loc Designative Reference WorkLoad_Quantity 医嘱数量WorkLoad_RecDep_DR 执行科室 CT_Loc Designative Reference WorkLoad_RecDoc_
5、DR 执行医生 CT_CareProv Designative Reference WorkLoad_ReceiptI_DR Text WorkLoad_ReceiptO_DR Text WorkLoad_ResDep_DR 病人科室 CT_Loc Designative Reference WorkLoad_ResDoc_DR 下医嘱医生CT_CareProv Designative Reference WorkLoad_Rowid Row ID WorkLoad_StatDate 插入数据日期Date WorkLoad_StatTime Time 名师资料总结 - - -精品资料欢迎下载
6、- - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 1 页,共 26 页 - - - - - - - - - WorkLoad_TarAC_dr 会计分类DHC_TarAcctCate Designative Reference WorkLoad_TarEC_Dr 核算分类DHC_TarEMCCate Designative Reference WorkLoad_TarIC_Dr 住院分类DHC_TarInpatCate Designative Reference WorkLoad_TarItem_DR 收费项目 DHC_Tar
7、Item Designative Reference WorkLoad_TarMC_Dr 病案分类DHC_TarMRCate Designative Reference WorkLoad_TarOut_Dr 门诊分类DHC_TarOutpatCate Designative Reference WorkLoad_TarSC_Dr DHC_TarSubCate Designative Reference WorkLoad_TotalPrice 费用WorkLoad_Type 病人类型Multiple Choice WorkLoad_UnitPrice 单价WorkLoad_UserDep_DR
8、Designative Reference WorkLoad_User_DR Designative Reference Date Master:DHCWorkLoad(WorkLoad_Rowid) Index ARPBL: DHCWorkLoad(0,DateARPBL,WorkLoad_OrdDate, WorkLoad_ARPBL_DR,WorkLoad_Rowid) Index DateBillSub: DHCWorkDHCWorkLoad(0,DateBillSub,WorkLoad_OrdDate, WorkLoad_BillSub_DR,WorkLoad_Rowid) Inde
9、x DateItemOrd: DHCWorkLoad(0,DateItemOrd,WorkLoad_OrdDate, WorkLoad_ItemOrd_DR,WorkLoad_Rowid) Index DateOEORI:DHCWorkLoad(0,DateOEORI,WorkLoad_OrdDate, WorkLoad_OEORI_DR,WorkLoad_Rowid) Index OEORI: DHCWorkLoad(0,OEORI,WorkLoad_OEORI_DR,WorkLoad_Rowid) Index-BillGrp: DHCWorkLoad(0,BILLGRP,WorkLoad_
10、BillGrp_DR,WorkLoad_Rowid) Index-BillSub:DHCWorkLoad(0,BILLSUB,WorkLoad_BillSub_DR,WorkLoad_Rowid): Index-ItemCat: DHCWorkLoad(0,ITEMCAT,WorkLoad_ItemCat_DR,WorkLoad_Rowid) Index-ItemOrd:DHCWorkLoad(0,ITEMORD,WorkLoad_ItemOrd_DR,WorkLoad_Rowid) Index-OrdDate : DHCWorkLoad(0,ORDDATE,WorkLoad_OrdDate,
11、WorkLoad_Rowid) Index-OrdStatus:DHCWorkLoad(0,ORDSTATUS,WorkLoad_OrdStatus, WorkLoad_Rowid) Index-OrdTime : DHCWorkLoad(0,ORDTIME,WorkLoad_OrdTime,WorkLoad_Rowid) Index-PAADM : DHCWorkLoad(0,PAADM,WorkLoad_PAADM_DR,WorkLoad_Rowid) Index-PAPMI : DHCWorkLoad(0,PAPMI,WorkLoad_PAPMI_DR,WorkLoad_Rowid) I
12、ndex-RecDep : DHCWorkLoad(0,RECDEP,WorkLoad_RecDep_DR,WorkLoad_Rowid) Index-RecDoc : DHCWorkLoad(0,RECDOC,WorkLoad_RecDoc_DR,WorkLoad_Rowid) Index-ResDep: DHCWorkLoad(0,RESDEP,WorkLoad_ResDep_DR,WorkLoad_Rowid) Index-ResDoc: DHCWorkLoad(0,RESDOC,WorkLoad_ResDoc_DR,WorkLoad_Rowid) Index-StatDate: : D
13、HCWorkLoad(0,STATDA TE,WorkLoad_StatDate,WorkLoad_Rowid) 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 2 页,共 26 页 - - - - - - - - - Index-StatTime : DHCWorkLoad(0,STATTIME,WorkLoad_StatTime,WorkLoad_Rowid) Index-Type: : Load(0,TYPE,WorkLoad_Type,WorkLoad_Rowid) Inde
14、x -CasherI :DHCWorkLoad(0,CasherI,WorkLoad_CasherI_DR,WorkLoad_Rowid) Index -CasherO : DHCWorkLoad(0,CasherO,WorkLoad_CasherO_DR,WorkLoad_Rowid) Index - DateARPBL: DHCWorkLoad(0,DateARPBL,WorkLoad_OrdDate, WorkLoad_ARPBL_DR,WorkLoad_Rowid) Index FlagDate: DHCWorkLoad(0,FlagDate,WorkLoad_FlagDate,Wor
15、kLoad_Rowid) Index TarAC:DHCWorkLoad(0,TarAC,WorkLoad_TarAC_dr,WorkLoad_Rowid) Index TarEC:DHCWorkLoad(0,TarEC,WorkLoad_TarEC_Dr,WorkLoad_Rowid) Index TarIC:DHCWorkLoad(0,TarIC,WorkLoad_TarIC_Dr,WorkLoad_Rowid) Index TarMC:DHCWorkLoad(0,TarMC,WorkLoad_TarMC_Dr,WorkLoad_Rowid) Index TarOC:DHCWorkLoad
16、(0,TarOC,WorkLoad_TarOut_Dr,WorkLoad_Rowid) Index TarSC:DHCWorkLoad(0,TarSC,WorkLoad_TarSC_Dr,WorkLoad_Rowid) Index- StatDate: DHCWorkLoad(0,STATDATE,WorkLoad_StatDate,WorkLoad_Rowid) 2. DHCWorkRegReport 挂号基础数据表字段名称说明类型备注WR_Rowid Rowid Row id WR_PAADM_DR PA_Adm_rowid Designative Reference WR_SQINV_D
17、R DHC_Sqinv_rowid Designative Reference WR_ADMDoc_DR 挂号医生Designative Reference WR_ADMDEP_DR 所挂科室Designative Reference WR_ADMReason_DR 病人类型Designative Reference WR_ADMDate 挂号日期Date WR_RegUser 挂号员Designative Reference WR_RegType_Dr 挂号类别Designative Reference WR_PAPMI_Dr 病人 papmi Designative Reference W
18、R_AAMT 实际金额总数Number WR_Abook 实际病历本费用Number WR_Areg 实际挂号费Number WR_Adia 实际诊疗费Number WR_Status 状态Multiple Choice WR_HandDate 上交日期Date WR_Flag1 预约标志text WR_Flag2 号别种类标志Text WR_Flag3 打折标志Text WR_ Flag4 按号打折标志Text WR_Flag5 按金额打折标志Text WR_text1 预留字段 1 Text WR_text2 预留字段 2 Text WR_StatDate 记录插入表日期Date WR_S
19、tatTime 记录插入表时间Time 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 3 页,共 26 页 - - - - - - - - - WR_DateMonFlag 挂号日期月标志Text WR_SundayServer 周六周日业余服务Text WR_ AAMTRatio 提成金额(科室)Number WR_NumberFlag 挂号人次Number WR_ADMTime 挂号时间Time WR_CountFlag 挂号次数Number WR_HolidayServer
20、节假日Number WR_Text3 Text WR_Text4 Text WR_ADMSource_DR 病人来源Designative Reference WR_AdmReadm 初复诊WR_AppMethod 预约方式WR_AppFee 预约费用WR_AdmAge 年龄WR_AdmCity 城市WR_AdmCityarea 区域WR_AdmAddress 地址WR_DocAMTRatio 医生提成WR_MedicareFee 医保卡挂号费用data master : DHCWorkRegReport(WR_rowid) Index- ADMDate: DHCWorkRegReport(0
21、,ADMDATE,WR_ADMDate,WR_rowid) Index-DateMonFlag: DHCWorkRegReport(0,DateMonFlag,WR_DateMonFlag,WR_rowid) Index-HandDate: DHCWorkRegReport(0,HANDDATE,WR_HandDate,WR_rowid) Index-PAADM: DHCWorkRegReport(0,PAADM,WR_PAADM_DR,WR_rowid) Index-PAPMI: DHCWorkRegReport(0,PAPMI,WR_PAPMI_DR,WR_rowid) Index-Sqi
22、nv: DHCWorkRegReport(0,Sqinv,WR_SQINV_DR,WR_rowid) Index-StatDate: DHCWorkRegReport(0,STATDATE,WR_StatDate,WR_rowid) 3. DHCMRIPDay 工作量基础数据表字段名称说明类型备注MRIP_bednum 实际床数Number MRIP_BWRS 病危人数Number MRIP_creatdate 创建日期Date MRIP_creattime 创建时间Time MRIP_creatuser 创建人Designative Reference 暂没用MRIP_crrs 出院人数Nu
23、mber MRIP_date 日期Date MRIP_gdbednum 固定床数Number MRIP_knzc 科内转出Number 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 4 页,共 26 页 - - - - - - - - - MRIP_knzr 科内转入Number MRIP_loc_dr 病人科室Designative Reference MRIP_lyrs 原有人数Number MRIP_PHRS 陪护人数Number MRIP_QJRS 抢救人数Number M
24、RIP_qnjc 期内加床Number MRIP_qnkc 期内空床Number MRIP_rowid Row id text MRIP_ryrs 入院人数Number MRIP_subloc_dr 科室子组Designative Reference 暂没用MRIP_SWRS 死亡人数Number MRIP_tkzrrs 他科转入Number MRIP_tyrs 退院人数Number MRIP_W ARD 病人病区Designative Reference MRIP_XYRS 现有(留院)人数Number MRIP_yydm 年Text MRIP_zwtkrs 转往他科人数Number MAS
25、TER-MRIPdaily MRIPdaily(MRIP_rowid) index-subloc: MRIPdaily(MRIPLoc,MRIP_loc_dr,MRIPDate,MRIP_date, MRIPSubLoc,MRIP_subloc_dr,MRIP_rowid INDEX-MRIPSUBLOC:MRIPdaily(MRIPSubLoc,MRIP_subloc_dr,MRIPDate,MRIP_date,MRIP_rowid) INDEX-MRIPDATELOC: MRIPdaily(MRIPloc,MRIP_loc_dr,MRIPdate,MRIP_date, MRIP_rowid
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 2022年表结构 2022 年表 结构
限制150内