表结构综查询Word文档格式.docx
- 文档编号:16455687
- 上传时间:2022-11-23
- 格式:DOCX
- 页数:42
- 大小:29.39KB
表结构综查询Word文档格式.docx
《表结构综查询Word文档格式.docx》由会员分享,可在线阅读,更多相关《表结构综查询Word文档格式.docx(42页珍藏版)》请在冰豆网上搜索。
WorkLoad_OrdTime
WorkLoad_PAADM_DR
Pa_adm
WorkLoad_PAPMI_DR
PA_PatMas
WorkLoad_PatDep_DR
下医嘱科室CT_Loc
WorkLoad_PatDoc_DR
病人医生CT_CareProv
WorkLoad_PatWard_DR
病人病区CT_Loc
WorkLoad_Quantity
医嘱数量
WorkLoad_RecDep_DR
执行科室CT_Loc
WorkLoad_RecDoc_DR
执行医生CT_CareProv
WorkLoad_ReceiptI_DR
WorkLoad_ReceiptO_DR
WorkLoad_ResDep_DR
病人科室CT_Loc
WorkLoad_ResDoc_DR
下医嘱医生CT_CareProv
WorkLoad_Rowid
RowID
WorkLoad_StatDate
插入数据日期
WorkLoad_StatTime
WorkLoad_TarAC_dr
会计分类DHC_TarAcctCate
WorkLoad_TarEC_Dr
核算分类DHC_TarEMCCate
WorkLoad_TarIC_Dr
住院分类DHC_TarInpatCate
WorkLoad_TarItem_DR
收费项目DHC_TarItem
WorkLoad_TarMC_Dr
病案分类DHC_TarMRCate
WorkLoad_TarOut_Dr
门诊分类DHC_TarOutpatCate
WorkLoad_TarSC_Dr
DHC_TarSubCate
WorkLoad_TotalPrice
费用
WorkLoad_Type
病人类型
WorkLoad_UnitPrice
单价
WorkLoad_UserDep_DR
WorkLoad_User_DR
DateMaster:
^DHCWorkLoad({WorkLoad_Rowid})
Index–ARPBL:
^DHCWorkLoad(0,"
DateARPBL"
{WorkLoad_OrdDate},
{WorkLoad_ARPBL_DR},{WorkLoad_Rowid})
Index–DateBillSub:
^DHCWork^DHCWorkLoad(0,"
DateBillSub"
{WorkLoad_BillSub_DR},{WorkLoad_Rowid})
Index–DateItemOrd:
DateItemOrd"
{WorkLoad_OrdDate},
{WorkLoad_ItemOrd_DR},{WorkLoad_Rowid})
Index–DateOEORI:
:
^DHCWorkLoad(0,"
DateOEORI"
{WorkLoad_OEORI_DR},{WorkLoad_Rowid})
Index–OEORI:
OEORI"
{WorkLoad_OEORI_DR},{WorkLoad_Rowid})
Index-BillGrp:
BILLGRP"
{WorkLoad_BillGrp_DR},{WorkLoad_Rowid})
Index-BillSub:
BILLSUB"
{WorkLoad_BillSub_DR},{WorkLoad_Rowid}):
Index-ItemCat:
ITEMCAT"
{WorkLoad_ItemCat_DR},{WorkLoad_Rowid})
Index-ItemOrd:
ITEMORD"
{WorkLoad_ItemOrd_DR},{WorkLoad_Rowid})
Index-OrdDate:
ORDDATE"
{WorkLoad_OrdDate},{WorkLoad_Rowid})
Index-OrdStatus:
ORDSTATUS"
{WorkLoad_OrdStatus},
{WorkLoad_Rowid})
Index-OrdTime:
ORDTIME"
{WorkLoad_OrdTime},{WorkLoad_Rowid})
Index-PAADM:
PAADM"
{WorkLoad_PAADM_DR},{WorkLoad_Rowid})
Index-PAPMI:
PAPMI"
{WorkLoad_PAPMI_DR},{WorkLoad_Rowid})
Index-RecDep:
RECDEP"
{WorkLoad_RecDep_DR},{WorkLoad_Rowid})
Index-RecDoc:
RECDOC"
{WorkLoad_RecDoc_DR},{WorkLoad_Rowid})
Index-ResDep:
RESDEP"
{WorkLoad_ResDep_DR},{WorkLoad_Rowid})
Index-ResDoc:
RESDOC"
{WorkLoad_ResDoc_DR},{WorkLoad_Rowid})Index-StatDate:
STATDATE"
{WorkLoad_StatDate},{WorkLoad_Rowid})
Index-StatTime:
STATTIME"
{WorkLoad_StatTime},{WorkLoad_Rowid})
Index-Type:
:
Load(0,"
TYPE"
{WorkLoad_Type},{WorkLoad_Rowid})
Index-CasherI:
CasherI"
{WorkLoad_CasherI_DR},{WorkLoad_Rowid})
Index-CasherO:
CasherO"
{WorkLoad_CasherO_DR},{WorkLoad_Rowid})
Index-DateARPBL:
{WorkLoad_OrdDate},{WorkLoad_ARPBL_DR},{WorkLoad_Rowid})
Index–FlagDate:
FlagDate"
{WorkLoad_FlagDate},{WorkLoad_Rowid})
Index–TarAC:
TarAC"
{WorkLoad_TarAC_dr},{WorkLoad_Rowid})
Index–TarEC:
TarEC"
{WorkLoad_TarEC_Dr},{WorkLoad_Rowid})
Index–TarIC:
TarIC"
{WorkLoad_TarIC_Dr},{WorkLoad_Rowid})
Index–TarMC:
TarMC"
{WorkLoad_TarMC_Dr},{WorkLoad_Rowid})
Index–TarOC:
TarOC"
{WorkLoad_TarOut_Dr},{WorkLoad_Rowid})
Index–TarSC:
TarSC"
{WorkLoad_TarSC_Dr},{WorkLoad_Rowid})
Index-StatDate:
{WorkLoad_StatDate},{WorkLoad_Rowid})
2.DHCWorkRegReport挂号基础数据表
WR_Rowid
Rowid
Rowid
WR_PAADM_DR
PA_Adm_rowid
WR_SQINV_DR
DHC_Sqinv_rowid
WR_ADMDoc_DR
挂号医生
WR_ADMDEP_DR
所挂科室
WR_ADMReason_DR
WR_ADMDate
挂号日期
WR_RegUser
挂号员
WR_RegType_Dr
挂号类别
WR_PAPMI_Dr
病人papmi
WR_AAMT
实际金额总数
Number
WR_Abook
实际病历本费用
WR_Areg
实际挂号费
WR_Adia
实际诊疗费
WR_Status
状态
WR_HandDate
上交日期
WR_Flag1
预约标志
text
WR_Flag2
号别种类标志
WR_Flag3
打折标志
WR_Flag4
按号打折标志
WR_Flag5
按金额打折标志
WR_text1
预留字段1
WR_text2
预留字段2
WR_StatDate
记录插入表日期
WR_StatTime
记录插入表时间
WR_DateMonFlag
挂号日期月标志
WR_SundayServer
周六周日业余服务
WR_AAMTRatio
提成金额(科室)
WR_NumberFlag
挂号人次
WR_ADMTime
挂号时间
WR_CountFlag
挂号次数
WR_HolidayServer
节假日
WR_Text3
WR_Text4
WR_ADMSource_DR
病人来源
WR_AdmReadm
初复诊
WR_AppMethod
预约方式
WR_AppFee
预约费用
WR_AdmAge
年龄
WR_AdmCity
城市
WR_AdmCityarea
区域
WR_AdmAddress
地址
WR_DocAMTRatio
医生提成
WR_MedicareFee
医保卡挂号费用
datamaster:
^DHCWorkRegReport({WR_rowid})
Index-ADMDate:
^DHCWorkRegReport(0,"
ADMDATE"
{WR_ADMDate},{WR_rowid})
Index-DateMonFlag:
DateMonFlag"
{WR_DateMonFlag},{WR_rowid})
Index-HandDate:
HANDDATE"
{WR_HandDate},{WR_rowid})
{WR_PAADM_DR},{WR_rowid})
{WR_PAPMI_DR},{WR_rowid})
Index-Sqinv:
Sqinv"
{WR_SQINV_DR},{WR_rowid})
Index-StatDate:
{WR_StatDate},{WR_rowid})
3.DHCMRIPDay工作量基础数据表
MRIP_bednum
实际床数
MRIP_BWRS
病危人数
MRIP_creatdate
创建日期
MRIP_creattime
创建时间
MRIP_creatuser
创建人
暂没用
MRIP_crrs
出院人数
MRIP_date
日期
MRIP_gdbednum
固定床数
MRIP_knzc
科内转出
MRIP_knzr
科内转入
MRIP_loc_dr
病人科室
MRIP_lyrs
原有人数
MRIP_PHRS
陪护人数
MRIP_QJRS
抢救人数
MRIP_qnjc
期内加床
MRIP_qnkc
期内空床
MRIP_rowid
MRIP_ryrs
入院人数
MRIP_subloc_dr
科室子组
MRIP_SWRS
死亡人数
MRIP_tkzrrs
他科转入
MRIP_tyrs
退院人数
MRIP_WARD
病人病区
MRIP_XYRS
现有(留院)人数
MRIP_yydm
年
MRIP_zwtkrs
转往他科人数
MASTER-MRIPdaily^MRIPdaily({MRIP_rowid})
index-subloc:
^MRIPdaily("
MRIPLoc"
{MRIP_loc_dr},"
MRIPDate"
{MRIP_date},"
MRIPSubLoc"
{MRIP_subloc_dr},{MRIP_rowid}
INDEX-MRIPSUBLOC:
^MRIPdaily("
{MRIP_subloc_dr},"
{MRIP_date},{MRIP_rowid})
INDEX-MRIPDATELOC:
MRIPloc"
MRIPdate"
{MRIP_date},{MRIP_rowid})
index-mripdate:
MRIP_DATE"
INDESX-WARD:
MRIPWARD"
{MRIP_WARD},"
MRIPDATE"
4.DHC_MRIPDetail工作量明细数据表
IPDE_MRIPDay_Dr
DHCMRIPDAY表ID
IPDE_PAADM_Dr
病人ID
IPDE_Rowid
IPDE_Type
DataMaster:
^DHCMRIPDetail({IPDE_Rowid})
Index–IPDay:
^DHCMRIPDetail(0,"
IPDay"
{IPDE_MRIPDay_Dr},{IPDE_Rowid})
Index-IPType:
^DHCMRIPDetail(0,"
IPType"
{IPDE_MRIPDay_Dr},{IPDE_Type},{IPDE_Rowid})
Index-IPTypeAdm:
{IPDE_Type},"
ADM"
{IPDE_PAADM_Dr},{IPDE_Rowid})
Index-Paadm:
Paadm"
index-IPTypePaadm:
IPDayDr"
{IPDE_MRIPDay_Dr},"
Type"
5.DHCWLAddReport急诊累计数据表
AddReport_Date
AddReport_ECCat_Dr
核算分类
AddReport_FlagPrice
结算费用
AddReport_ItemDr
医嘱项
AddReport_ItemLocFlag
AddReport_LastAddPrice
上期余额
AddReport_MonFlag
月标志
AddReport_NowAddPrice
本期余额
AddReport_OrdPrice
实际发生费用
AddReport_PatLocDr
AddReport_PatType
AddReport_Rowid
AddReport_StatDate
AddReport_StatTime
插入数据时间
DataMaster:
^DHCWLAddReport({AddReport_Rowid})
index–ItemDate:
^DHCWLAddReport(0,"
ItemDr"
{AddReport_ItemDr},"
PatType"
{AddReport_PatType},"
Date"
{AddReport_Date},{AddReport_Rowid})
Index–Mon:
^DHCWLAddReport(0,"
MonFlag"
{AddReport_MonFlag},{AddReport_Rowid})
Index–Name:
Data"
{AddReport_Date}
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 结构 查询