Monthly central line days report
I am looking to create a report listing the total number of catheter days for my patient population. There is one table w/ patient demographics, including ID # (medical record number), dateassume (starting care), enddate (termination of care). There is another table w/ catheter information, including ID # (medical record number), dateinse (date of line insertion), remdate (date of line removal). The tables are linked by relationship ID#==ID#.
The maximum number of line days a patient can contribute is 30. Patients who haven't started care or who have terminated care will not contribute line days to a particular month. If they start midway through the month and line is in place all month, then they only contribute days when we cared for them. If the line is removed midway through the month and we are caring for them the whole month, then they only contributed a portion of the month. Please see example below of how to calculate line days for April 2012
The report should have a column with the month/year, say November 2012 and another column with the number of total # line days within the month -- which is sum of line days contributed by all the patients.
Appreciate any thoughts, BPR