This report shows notes that were finalized between two dates that you specify.
A sample image of this SQL report run in the Database Viewer is shown below:
- The date range you specify is the date range when finalization occurred, not necessarily the date of service.
- Only finalized notes (both encounter and well) are shown.
- COSIGN_ADDR_ID is the OP user ID of the note-cosigner, and COSIGN DATE is the timestamp when the note was cosigned. If those last two fields are blank, the note was not co-signed.
To highlight and copy the code below to your clipboard, simply click the Copy button.
select patno, date1 as dos, 'encounter note' as note_type, staffname as rendering, final_date, cosign_addr_id, cosign_date from enc_note inner join staff1 on staff1.staffid = enc_note.p_addr_id where final_date between :Start_date and :end_date union select patno, date1 as dos, 'well note' as note_type, staffname as rendering, final_date, cosign_addr_id, cosign_date from physical inner join staff1 on staff1.staffid =physical.p_addr_id where final_date between :Start_date and :end_date