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) )
