MWSTR Orphans - due to PowerTools usage?
-
- Posts: 40
- Joined: Fri Aug 03, 2007 10:34 am
MWSTR Orphans - due to PowerTools usage?
Select *
From MWSTR as A
Where A.\"chart number\" NOT IN
(Select B.\"chart number\"
From MWPAT as B
Where A.\"chart number\" = B.\"chart number\")
It turned up 115 MWSTR rows (records) whose Chart Number have no match in MWPAT.
I ran similar queries against the other tables that reference the 'Chart Number' key and found no orphans.
We have been using PowerTools for some time to correct the occasional mistyped Chart Number. My best guess is that perhaps PowerTools neglects to update this one table? Has anyone else used PowerTools quite a bit and also has orphaned MWSTR records? How critical are entries in the MWSTR table?
Thank you sincerely.
Paul Williams
- Gavin Walker
- Posts: 4625
- Joined: Wed Apr 04, 2007 10:11 pm
- Location: Springfield, MO
- Contact:
MWSTR is the record of superbills that have been printed. If this table is incorect it could throw off your Superbill Tracking Report.
Walker Tek Solutions, LLC
417-890-6777 x0
fax: 417-763-6386
-
- Posts: 40
- Joined: Fri Aug 03, 2007 10:34 am
You Sir, are entirely correct.
Per your comment, I just deleted a test patient we've had on our system for years, one who had a row in the MWSTR table. And sure enough, after deleting the patient, the matching record remained in MWSTR. I would guess since there are no longer other records to provide any detail for the printed statement, that there is no reason to maintain a record of when it printed? Sloppy housekeeping in the main MAPA program? I suppose I could just delete the 115 (now 116) orphan records?
I thank you very much for nailing this one down, Gavin.