ClientManager
Signout
Clients
Global Settings
EMR Sql Queries
CPS Sql Queries
Logs
Edit
Centricity Sql Query
Order
Name
Query
select c.*, cf.TransmissionStatus from ediclaim c INNER JOIN ediClaimFile cf on cf.ediclaimfileid = c.EDIClaimFileId and cf.TransmissionStatus <> 'Transmitted' where c.created >= '31 mar 2026'
Notes
Back to List