About
This report shows patients who were billed J0561 (long acting injectable penicillin) with something other than 6 or 12 units between two dates that you specify.
A sample image of this SQL report run in the Database Viewer is shown below:
Caveats
- You must be using OP's billing module, and the charge must have gone through the daysheet process.
- Benzathine penicillin is usually given in 600,000U or 1,200,000U doses. The definition of J0561 is “per 100,000U.” This means you should be billing J0561 in 6 or 12 units. That said, there may be medical reasons why your providers might use a different dose.
Code
To highlight and copy the code below to your clipboard, simply click the Copy button.
SELECT ARCHIVE_TRANSACTIONS_1.PATNO, ARCHIVE_TRANSACTIONS_1.DATE1, ARCHIVE_TRANSACTIONS_1.CHARGE, ARCHIVE_TRANSACTIONS_1.CPTCODE, ARCHIVE_TRANSACTIONS_1.UNITS FROM ARCHIVE_TRANSACTIONS ARCHIVE_TRANSACTIONS_1 WHERE ( ARCHIVE_TRANSACTIONS_1.CPTCODE = 'J0561' ) AND ( ARCHIVE_TRANSACTIONS_1.DATE1 BETWEEN :start_date and :end_date ) AND ( ARCHIVE_TRANSACTIONS_1.ARCHIVE_FLAG = 1 ) AND ( ARCHIVE_TRANSACTIONS_1.UNITS NOT IN (6,12) )