14XX医院病案管理数据结构Word格式文档下载.docx
《14XX医院病案管理数据结构Word格式文档下载.docx》由会员分享,可在线阅读,更多相关《14XX医院病案管理数据结构Word格式文档下载.docx(40页珍藏版)》请在冰豆网上搜索。
评审意见
1
2
3
东华项目负责人意见:
签字:
医院主管领导意见:
批批准人:
批批准日期:
修改记录表
修改日期
修改内容描述
修改人
1、病案流通
1.1字典项目表DHC_WMR_Dictionary
顺序
字段名
描述
数据类型
备注
Rowid
DHC_WMR_DictionaryRowID
DictionaryName
所属字典
Text
Code
代码
*同类型的Code不重复
4
Description
5
FromDate
生效日期
Date
6
ToDate
废止日期
7
TextA
8
TextB
9
TextC
10
TextD
11
IsActive
是否有效
Yes/No
12
ResumeText
DataMasterMap^DHCWMRDIC({Rowid})
IndexDicName^DHCWMRDIC(0,"
DicName"
{DictionaryName},{IsActive},{Rowid})
IndexDicName-Code^DHCWMRDIC(0,"
DicNameCode"
{DictionaryName},{Code},{Rowid})
1.2历史病人基本信息表DHC_WMR_History
DHC_WMR_HistoryRowID
PatientName
病人姓名
NameSpell
姓名拼音码
Sex
性别
Birthday
生日
Age
年龄
Number
Wedlock
婚姻
Occupation
职业
City
出生市
County
出生县
Nation
民族
Nationality
国籍
13
IdentityCode
身份证号
14
Company
工作单位
15
CompanyTel
工作单位电话
16
CompanyZip
工作单位邮编
17
HomeAddress
家庭住址
18
HomeTel
家庭电话
19
HomeZip
家庭邮编
20
RelationDesc
与联系人关系
21
RelativeName
联系人
22
RelativeTel
联系人电话
23
RelativeAddress
联系人地址
24
25
DataMasterMap^DHCWMRHISTORY({Rowid})
IndexNameSpell^DHCWMRHISTORY(0,"
NameSpell"
{NameSpell},{Rowid})
1.3历史卷信息表DHC_WMR_HistoryAdm
DHC_WMR_HistoryAdmRowID
History_Dr
历史基本信息
Dr
DHC_WMR_History
AdmitDate
就诊日期
AdmitTime
就诊时间
AdmitDep
就诊科室
AdmitStatus
就诊时状态
危、急、一般
DischargeDate
出院日期
DischargeTime
出院时间
DischargeDep
出院科室
Diagnose
诊断
DataMasterMap^DHCWMRHISADM({Rowid})
IndexAdmDate^DHCWMRHISADM(0,"
ADMDate"
{AdmitDate},{Rowid})
IndexDisDate^DHCWMRHISADM(0,"
DisDate"
{DischargeDate},{Rowid})
IndexHistory^DHCWMRHISADM(0,"
HISTORY"
{History_Dr},{Rowid})
1.4病案主信息表DHC_WMR_Main
DHC_WMR_MainRowID
MrType_Dr
病案类型
DHC_WMR_Dictionary
MRNO
住院病案号码
Papmi_Dr
病人基本信息
PA_PatMas
History_DR
IsDead
是否死亡
活动(未被删除)
有部分病案在生成之后又被删除
IsStayIn
病案是否已归架
BuildDate
生成日期
DataMasterMap^DHCWMRMAIN({Rowid})
IndexHistory^DHCWMRMAIN(0,"
{History_DR},{Rowid})
IndexPapmi^DHCWMRMAIN(0,"
PAPMI"
{Papmi_Dr},{Rowid})
IndexType-NO^DHCWMRMAIN(0,"
TypeNO"
{MrType_Dr},{MRNO},{Rowid})
IndexTypeStay^DHCWMRMAIN(0,"
TypeStay"
{MrType_Dr},{IsStayIn},{Rowid})
1.5病案状态信息表DHC_WMR_MainStatus
Parref
DHC_WMR_MainParentReference
DHC_WMR_MainStatusRowID
ChildSub
Childsubscript
Status_Dr
病案操作项目
DHC_WMR_WorkItem
UserFromDr
转交人
SS_User
CurrDate
操作日期
CurrTime
操作时间
Time
UserToDr
接收人
DataMasterMap^DHCWMRMAIN({DHC_WMR_Main.Rowid},"
S"
{ChildSub})
IndexDate-Status^DHCWMRMAIN(0,"
SDateStatus"
{CurrDate},{Status_Dr},{DHC_WMR_Main.Rowid},"
IndexStatus^DHCWMRMAIN({DHC_WMR_Main.Rowid},"
0,"
Status"
{Status_Dr},{ChildSub})
1.6病案附加项目明细表DHC_WMR_MainStatusDtl
DHC_WMR_MainStatusParentReference
DHC_WMR_MainStatusDtlRowID
Detail_Dr
附加项目明细
DHC_WMR_WorkDetail
ItemValue
附加项目值
Resume
WorkItemList_Dr
附加项目明细列表
DHC_WMR_WorkItemList
{DHC_WMR_MainStatus.ChildSub},"
D"
IndexDtlValue^DHCWMRMAIN(0,"
Dtl"
{Detail_Dr},{ItemValue},"
M"
{DHC_WMR_Main.Rowid},{DHC_WMR_MainStatus.ChildSub},{ChildSub})
1.7病案卷表DHC_WMR_MainVolume
DHC_WMR_MainVolumeRowID
Main_Dr
指向DHC_WMR_Main
原ChildSub
Paadm_Dr
病人就诊基本信息
PA_Adm
HistroyAdm_Dr
历史卷信息
DHC_WMR_HistoryAdm
IsReprography
是否复印
IsSeal
是否被封存
DHC_WMR_WorkItem
InFlow
流项目
DataMasterMap^DHCWMRVOL({DHC_WMR_MainVolume.Rowid})
IndexVolAc-F-S^DHCWMRVOL(0,"
VolAFS"
{IsActive},{InFlow},{Status_Dr},{DHC_WMR_MainVolume.Rowid})
IndexMainDr^DHCWMRVOL(0,"
Main"
{Main_Dr},{Rowid})
IndexStatus^DHCWMRVOL(0,"
{Status_Dr},{Rowid})
IndexHistoryAdm^DHCWMRVOL(0,"
HistoryAdm"
{HistroyAdm_Dr},{Rowid})
1.8病案号更改列表DHC_WMR_VolLog
记录卷合并日志,即DHC_WMR_MainVolume.Main_Dr的修改记录流水
DHC_WMR_MainVolumeParentReference
DHC_WMR_VolLogRowID
DHC_WMR_Main
User_Dr
UpdateDate
UpdateTime
DataMasterMap^DHCWMRVOL({DHC_WMR_MainVolume.Rowid},"
L"
1.9卷就诊列表信息表DHC_WMR_VolAdm
针对特殊情况,多次就诊对应一卷病案的情况(例如:
医保中途出院),保存其它几个Paadm的指针
DHC_WMR_VolAdmRowID
ADM"
IndexVolAdm^DHCWMRVOL(0,"
VolAdm"
{Paadm_Dr},{DHC_WMR_MainVolume.Rowid},{ChildSub})
1.10病案卷状态表DHC_WMR_VolStatus
DHC_WMR_VolStatusRowID
UserFrom_Dr
UserTo_Dr
IndexDate-Status^DHCWMRVOL(0,"
VSDateStatus"
{CurrDate},{Status_Dr},{DHC_WMR_MainVolume.Rowid},{ChildSub})
IndexStatus^DHCWMRVOL(DHC_WMR_MainVolume.Rowid},"
{Status_Dr},{ChildSub})
1.11病案卷附加项目内容明细表DHC_WMR_VolStatusDtl
DHC_WMR_VolStatusParentReference
DHC_WMR_VolStatusDtlRowID
DataMasterMap^DHCWMRVOL({DHC_WMR_MainVolume.Rowid},"
{DHC_WMR_VolStatus.ChildSub},"
{ChildSub})
V"
{DHC_WMR_MainVolume.Rowid},{DHC_WMR_VolStatus.ChildSub},{ChildSub}
1.12病案卷状态评价列表DHC_WMR_VolStatusEva
DHC_WMR_VolStatusEvaRowID
Eva_Dr
病案操作项目评价列表
DHC_WMR_WorkItemRule
评价人
EvaDate
评价日期
EvaTime
评价时间
E"
1.13卷基本信息表DHC_WMR_VolInfo
DHC_WMR_VolInfoRowID
DHC_WMR_MainVolume
26
Volume_Dr
病案的卷
DataMasterMap^DHCWMRVOLINFO({Rowid})
IndexNameSpell^DHCWMRVOLINFO(0,"
IndexVolumeId^DHCWMRVOLINFO(0,"
VOL"
{Volume_Dr},{Rowid})
1.14附加项目明细字典DHC_WMR_WorkDetail
DHC_WMR_WorkDetailRowID
*不重复
DataType
数据类型(如:
时间,数字)
DictionaryCode
字典代码
DataMasterMap^DHCWMRWDTL({Rowid})
IndexCode^DHCWMRWDTL(0,"
Code"
{Code},{Rowid})
1.15病案工作流表DHC_WMR_WorkFlow
DHC_WMR_WorkFlowRowID
工作流描述
DateFrom
DateTo