Select a.Dept_Id 科室id,
a.Dept_Name 科室名称,
c.Pat_Id 病人id,
c.Visit_Id 就诊id,
b.Template_Name 病历模板名称,
a.Status 状态,
a.Creator 创建人,
a.Create_Time 创建时间,
a.Cmpltr 完成人,
a.Is_Lock 是否锁定,
a.Order_Id 医嘱id,
d.Section_Name 段落名称,
To_Char(d.Section_Content) 段落内容
From Zlemr.Medical_Rec a,
Zlemr.Mr_Template b,
Baseconfig.Pat_Visit_Info c,
Zlemr.Mr_Section_Content d
Where a.Template_Id = b.Template_Id
And a.Pat_Visit_Info_Id = c.Pat_Visit_Info_Id
And a.Mr_Id = d.Mr_Id
And a.Create_Time > Sysdate - 1
web病历内容
最新推荐文章于 2024-10-19 14:58:23 发布