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
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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