AnsweredAssumed Answered

Monthly central line days report

Question asked by BramRaphael on Dec 26, 2012
Latest reply on Dec 27, 2012 by BramRaphael

Title

Monthly central line days report

Post

     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

      

      

     CATHETER DAYS
          Case (
          Demographics::DATEASSUME  > Date ( 4 ; 30 ; 2012 ); 0;
           
          Demographics::ENDDATE < Date ( 4;1 ; 2012 ) and  Demographics::ENDDATE  ≠  Date ( 1 ;1 ; 1901 ); 0;
           
          DATEINSE < Date ( 4;1 ; 2011 ) and REMDATE   <   Date ( 4 ; 1 ; 2012 ) and REMDATE  ≠  Date ( 1 ;1 ; 1901 ); 0;
           
          Demographics::DATEASSUME  < Date ( 4 ; 30 ; 2012 ) and (Demographics::ENDDATE > Date ( 4 ;1 ; 2012 ) or  Demographics::ENDDATE  =  Date ( 1 ;1 ; 1901 )) and DATEINSE  ≤  Date ( 4 ;1 ; 2012 ) and REMDATE    ≥    Date ( 4 ; 1 ; 2012 ) and REMDATE   ≤   Date ( 4; 30 ; 2012 ); REMDATE - Date (4; 1; 2012) + 1;
           
          Demographics::DATEASSUME  < Date ( 4 ; 30 ; 2012 ) and (Demographics::ENDDATE > Date ( 4 ;1 ; 2012 ) or  Demographics::ENDDATE  =  Date ( 1 ;1 ; 1901 )) and DATEINSE  ≤  Date ( 4 ;1 ; 2012 ) and REMDATE   =   Date ( 1 ;1 ; 1901 ); 30;
           
          Demographics::DATEASSUME  < Date ( 4 ; 30 ; 2012 ) and (Demographics::ENDDATE > Date ( 4 ;1 ; 2012 ) or  Demographics::ENDDATE  =  Date ( 1 ;1 ; 1901 )) and DATEINSE  ≤  Date ( 4 ;1 ; 2012 ) and REMDATE  >  Date ( 4 ; 30 ; 2012 ); 30;
           
          Demographics::DATEASSUME  < Date ( 4 ; 30 ; 2012 ) and (Demographics::ENDDATE > Date ( 4 ;1 ; 2012 ) or  Demographics::ENDDATE  =  Date ( 1 ;1 ; 1901 )) and DATEINSE   ≥   Date ( 4 ;1 ; 2012 ) and DATEINSE    ≤   Date ( 4 ; 30 ; 2012 ) and REMDATE  >  Date ( 4 ; 30 ; 2012 ); Date (4; 30; 2012) - DATEINSE + 1;
           
          Demographics::DATEASSUME  < Date ( 4 ; 30 ; 2012 ) and (Demographics::ENDDATE > Date ( 4 ;1 ; 2012 ) or  Demographics::ENDDATE  =  Date ( 1 ;1 ; 1901 )) and DATEINSE   ≥   Date ( 4 ;1 ; 2012 ) and DATEINSE ≤ Date ( 4 ;31 ; 2012 ) and  REMDATE  =  Date ( 1 ;1 ; 1901 );  Date (4; 30; 2012) - DATEINSE + 1; 
           
          Demographics::DATEASSUME  < Date ( 4 ; 30 ; 2012 ) and (Demographics::ENDDATE > Date ( 4 ;1 ; 2012 ) or  Demographics::ENDDATE  =  Date ( 1 ;1 ; 1901 )) and DATEINSE   ≥   Date ( 4 ;1 ; 2012 ) and DATEINSE    ≤   Date ( 4 ; 30 ; 2012 ) and REMDATE   ≤   Date ( 4 ; 30 ; 2012 ) and REMDATE  ≠  Date ( 1 ;1 ; 1901 ); REMDATE - DATEINSE;
           
          DATEINSE > Date (4; 30; 2011); 0
          )

      

Outcomes