We are currently updating the OP Help Center content for the release of OP 19, which is a member of the certified OP 14 family of products. OP 19’s official version is 14.19.1, which you may see in your software (such as in Help > About) and in the Help Center tabs labeled 14.19. You may also notice that the version number in content and videos may not match the version of your software, and some procedural content may not match the workflow in your software. We appreciate your patience and understanding as we make these enhancements.

SQL: Nurse Charting Productivity

About

This report indicates which staff member (other than a provider) opened sick and well notes for a period. The report is based upon the staff ID number in the Entered by field on the visit's Visit Info tab for a Patient's Well or Encounter note. Data in this report is summed by staff member, according to the date range you select.

A sample image of this SQL report run in the Database Viewer is shown below:

Caveats

  • “Entered by” is defined as the person who was logged in when the note was opened. This might be the nurse/assistant, the rendering provider, or another person. Note that this field, while it defaults to the logged in user, may be manually changed. 
  • The Entered by field does not correlate with the Nurse/assistant field. The Nurse/assistant field and the Entered By field may be two different users. 
  • If the “Entered by” person is the same person as the rendering provider, the rendering provider is assumed to have created his or her own note, and nothing appears in this report.

Code

To highlight and copy the code below to your clipboard, simply click the Copy button.

select total_patient_charted, dos, staffname from
(
select count(patno) as total_patient_charted, date1 as dos, s_addr_id from
(
select patno, date1, p_addr_id, s_addr_id from
(
select patno, date1, p_addr_id, s_addr_id, a_addr_id from enc_note where date1 between :Start_date and :end_date
union
select patno, date1, p_addr_id, s_addr_id, a_addr_id from enc_note where date1 between :Start_date and :end_date
) where s_addr_id <> p_addr_id
) group by date1, s_addr_id
) a left outer join staff1 on 
staff1.staffid = a.s_addr_id