What is the DR Field for the Status field that appears on the Orders screen

66 views
Skip to first unread message

Tim Engel

unread,
Apr 10, 2014, 10:53:10 AM4/10/14
to dr---data-...@googlegroups.com
I have searched and can't determine the DR field that contains the values from the Status field that appears on the Orders screen for an individual patient?
Message has been deleted
Message has been deleted

BRHS_DBA-Programmer

unread,
Apr 11, 2014, 4:12:11 PM4/11/14
to dr---data-...@googlegroups.com
I am in 6.07

I have two databases one for NPR and one for Focus (MAT)

OM Orders are in the Focus Database.

I found the status on "OmOrd_Main3" table as 'Status"


SELECT * FROM Livefdb.dbo.OmOrd_Main3 WHERE Status = 'Verified'

Vkno

unread,
Nov 30, 2022, 2:49:19 PM11/30/22
to DR - Data Repository
greetings

has anyone knows how to remove the MTDD-style in the SQL table migrated from the Meditech Mumps database. refer the screenshot below
Screenshot 2022-12-01 011835.png
Reply all
Reply to author
Forward
0 new messages