HI,
Looking to see if there is query to find out which codes have been assigned to a provider.
For example, all my Oral surgery codes were assigned to the surgeon, but I have set up things now to work better so codes should change when dropped into the providers operatory under Standard fee schedules.
Thanks
query for codes assigned to providers
-
- Posts: 129
- Joined: Sat Jun 12, 2010 3:18 pm
Re: query for codes assigned to providers
Our Query Example Page (https://opendentalsoft.com:1943/ODQuery ... yList.aspx) has query #1223 which provides a list of all procedure codes that are assigned to a specific provider, and the provider they are assigned to.
/*1223 Procedure codes with a default provider assigned*/
/*Query code written/modified: 01/04/2017*/
SELECT p.Abbr,
pc.ProcCode,
pc.Descript
FROM procedurecode pc
INNER JOIN provider p ON p.ProvNum=pc.ProvNumDefault
WHERE pc.ProvNumDefault<>0
ORDER BY pc.ProcCode
/*1223 Procedure codes with a default provider assigned*/
/*Query code written/modified: 01/04/2017*/
SELECT p.Abbr,
pc.ProcCode,
pc.Descript
FROM procedurecode pc
INNER JOIN provider p ON p.ProvNum=pc.ProvNumDefault
WHERE pc.ProvNumDefault<>0
ORDER BY pc.ProcCode