4 Replies Latest reply: May 15, 2014 10:08 AM by dpetrauskas _ RSS

    Gathering data for export

    dpetrauskas _

      I have been put into a postion of gathering information from reports and putting them into some type of coherent form.  I have a model that allows me to sellect the FC of the patients seen by the hospital. The issue I have is that the Patient type does not continue thru the entire report as seen in the example.  As with the first patient type 'E' there may be 241 (as in the example) or 15.  I would like to be able to gather the patient type and the FC code for each.  The Patient Type 'E' with all the variances of the FC Code.

       

      PAT    ACCOUNT    FC       PATIENT NAME           TOTAL       ADMIT     DISCHARGE    TRANS     PROCESS       AMOUNT

      TYPE   NUMBER    CODE                             AMOUNT       DATE       DATE        DATE      DATE

       

      E  

       

       

       

      E                                                                               

      TOTAL NUMBER OF ACCOUNTS FOR PAT TYPE E IS   241

       

      I    

       

       

       

      I                                                                               

      TOTAL NUMBER OF ACCOUNTS FOR PAT TYPE I IS    37

       

      N    

       

       

       

      N                                                                               

      TOTAL NUMBER OF ACCOUNTS FOR PAT TYPE N IS     2

       

      O   

       

       

       

      O                                                                               

      TOTAL NUMBER OF ACCOUNTS FOR PAT TYPE O IS   107

       

      P   

       

       

       

      P                                                                               

      TOTAL NUMBER OF ACCOUNTS FOR PAT TYPE P IS     6

                                                                                      TOTAL NUMBER OF ACCOUNTS FOR RUN IS   393

      TOTAL NUMBER OF INPATIENT ACCOUNTS IS    45

      TOTAL NUMBER OF OUTPATIENT ACCOUNTS IS   348

      /CODE

       

      The next part of the information is based upon date.  I know that I can just put in the date and have it pull the information accordingly.  I have been trying to use a formula to have it take what the current date is and then subtract however many days to get to the target date or dates.

      Today would be 07-15-10 and the target date would be -4 days (07-11-10) or greater.  None of the formulas that I have been trying work correctly.

       

      I am using version 10 of monarch, Office 2007.

       

      Thank you in advance.

        • Gathering data for export
          Olly Bond

          Hello dpetrauskas, and welcome,

           

          I'd like to help, but I can't say that I find your post very clear. In the sample report, I can see patients of type E, I, N, O & P, and totals for these as well as for Inpatients and Outpatients. But from the sample data posted, there's no way to find out the number if Inpatients of type E, for example, as the data simply isn't there.

           

          As for dates, Today()-[DateField] will give you a number of days in Monarch, so a filter with expression Today()-[DateField] < 5 will limit the records to just those where the DateField value is within four days of today's date. But your sample data appears not to contain any dates, so I don't know where you are planning to get the from.

           

          Best wishes,

           

          Olly

            • Gathering data for export
              dpetrauskas _

              I am sorry for the missing data.  I was removing anything that may have been sensitive.  I am edited the data so I can post a more complete report that i am trying to use in Monarch.

               

              PAT    ACCOUNT    FC       PATIENT NAME           TOTAL       ADMIT     DISCHARGE    TRANS     PROCESS       AMOUNT

              TYPE   NUMBER    CODE                             AMOUNT       DATE       DATE        DATE      DATE

               

              E    1234567    P   DOE, JOHN                            1.00-  06/30/2010 07/01/2010  07/01/2010 07/01/2010          1.00-  MDANIEL

                     1234567    P   DOE, JOHN                           20.00-  07/01/2010 07/01/2010  07/01/2010 07/01/2010         20.00-  CVALDEZ

                     1234567    D   DOE, JOHN                           75.00-  07/01/2010 07/01/2010  07/01/2010 07/01/2010         75.00-  CVALDEZ

                     1234567    A   DOE, JOHN                         100.00-  07/01/2010 07/01/2010  07/01/2010 07/01/2010        100.00-  CVALDEZ

                     1234567    D   DOE, JOHN                           50.00-  07/01/2010 07/01/2010  07/01/2010 07/01/2010         50.00-  CVALDEZ

                     1234567    E   DOE, JOHN                           50.00-  07/01/2010 07/01/2010  07/01/2010 07/01/2010         50.00-  AHALL

                     1234567    B   DOE, JOHN                         100.00-  07/01/2010 07/01/2010  07/01/2010 07/01/2010        100.00-  CVALDEZ

                     

              E                                                                               

              TOTAL NUMBER OF ACCOUNTS FOR PAT TYPE E IS   241

               

              I     1234567    P   DOE, JOHN                            1.00-  06/30/2010 07/01/2010  07/01/2010 07/01/2010          1.00-  MDANIEL

                     1234567    P   DOE, JOHN                           20.00-  07/01/2010 07/01/2010  07/01/2010 07/01/2010         20.00-  CVALDEZ

                     1234567    D   DOE, JOHN                           75.00-  07/01/2010 07/01/2010  07/01/2010 07/01/2010         75.00-  CVALDEZ

                     1234567    A   DOE, JOHN                         100.00-  07/01/2010 07/01/2010  07/01/2010 07/01/2010        100.00-  CVALDEZ

                     1234567    D   DOE, JOHN                           50.00-  07/01/2010 07/01/2010  07/01/2010 07/01/2010         50.00-  CVALDEZ

                     1234567    E   DOE, JOHN                           50.00-  07/01/2010 07/01/2010  07/01/2010 07/01/2010         50.00-  AHALL

                     1234567    B   DOE, JOHN                         100.00-  07/01/2010 07/01/2010  07/01/2010 07/01/2010        100.00-  CVALDEZ

                     1234567    P   DOE, JOHN                            1.00-  06/30/2010 07/01/2010  07/01/2010 07/01/2010          1.00-  MDANIEL

                     1234567    P   DOE, JOHN                           20.00-  07/01/2010 07/01/2010  07/01/2010 07/01/2010         20.00-  CVALDEZ

                     1234567    D   DOE, JOHN                           75.00-  07/01/2010 07/01/2010  07/01/2010 07/01/2010         75.00-  CVALDEZ

                     1234567    A   DOE, JOHN                         100.00-  07/01/2010 07/01/2010  07/01/2010 07/01/2010        100.00-  CVALDEZ

                     1234567    D   DOE, JOHN                           50.00-  07/01/2010 07/01/2010  07/01/2010 07/01/2010         50.00-  CVALDEZ

                     1234567    E   DOE, JOHN                           50.00-  07/01/2010 07/01/2010  07/01/2010 07/01/2010         50.00-  AHALL

                     1234567    B   DOE, JOHN                         100.00-  07/01/2010 07/01/2010  07/01/2010 07/01/2010        100.00-  CVALDEZ

                     

              I                                                                               

              TOTAL NUMBER OF ACCOUNTS FOR PAT TYPE I IS    37

               

              N     1234567    P   DOE, JOHN                            1.00-  06/30/2010 07/01/2010  07/01/2010 07/01/2010          1.00-  MDANIEL

                     1234567    P   DOE, JOHN                           20.00-  07/01/2010 07/01/2010  07/01/2010 07/01/2010         20.00-  CVALDEZ

              N                                                                               

              TOTAL NUMBER OF ACCOUNTS FOR PAT TYPE N IS     2

               

              O    1234567    P   DOE, JOHN                            1.00-  06/30/2010 07/01/2010  07/01/2010 07/01/2010          1.00-  MDANIEL

                     1234567    P   DOE, JOHN                           20.00-  07/01/2010 07/01/2010  07/01/2010 07/01/2010         20.00-  CVALDEZ

                     1234567    D   DOE, JOHN                           75.00-  07/01/2010 07/01/2010  07/01/2010 07/01/2010         75.00-  CVALDEZ

                     1234567    A   DOE, JOHN                         100.00-  07/01/2010 07/01/2010  07/01/2010 07/01/2010        100.00-  CVALDEZ

                     1234567    D   DOE, JOHN                           50.00-  07/01/2010 07/01/2010  07/01/2010 07/01/2010         50.00-  CVALDEZ

                     1234567    E   DOE, JOHN                           50.00-  07/01/2010 07/01/2010  07/01/2010 07/01/2010         50.00-  AHALL

                     1234567    B   DOE, JOHN                         100.00-  07/01/2010 07/01/2010  07/01/2010 07/01/2010        100.00-  CVALDEZ

                     1234567    P   DOE, JOHN                            1.00-  06/30/2010 07/01/2010  07/01/2010 07/01/2010          1.00-  MDANIEL

                    

              O                                                                               

              TOTAL NUMBER OF ACCOUNTS FOR PAT TYPE O IS   107

               

              P    1234567    P   DOE, JOHN                            1.00-  06/30/2010 07/01/2010  07/01/2010 07/01/2010          1.00-  MDANIEL

                     1234567    P   DOE, JOHN                           20.00-  07/01/2010 07/01/2010  07/01/2010 07/01/2010         20.00-  CVALDEZ

                     1234567    D   DOE, JOHN                           75.00-  07/01/2010 07/01/2010  07/01/2010 07/01/2010         75.00-  CVALDEZ

                     1234567    A   DOE, JOHN                         100.00-  07/01/2010 07/01/2010  07/01/2010 07/01/2010        100.00-  CVALDEZ

                     1234567    D   DOE, JOHN                           50.00-  07/01/2010 07/01/2010  07/01/2010 07/01/2010         50.00-  CVALDEZ

                     1234567    E   DOE, JOHN                           50.00-  07/01/2010 07/01/2010  07/01/2010 07/01/2010         50.00-  AHALL

                     1234567    B   DOE, JOHN                         100.00-  07/01/2010 07/01/2010  07/01/2010 07/01/2010        100.00-  CVALDEZ

                     1234567    P   DOE, JOHN                            1.00-  06/30/2010 07/01/2010  07/01/2010 07/01/2010          1.00-  MDANIEL

              P                                                                               

              TOTAL NUMBER OF ACCOUNTS FOR PAT TYPE P IS     6

                                                                                              TOTAL NUMBER OF ACCOUNTS FOR RUN IS   393

              TOTAL NUMBER OF INPATIENT ACCOUNTS IS    45

              TOTAL NUMBER OF OUTPATIENT ACCOUNTS IS   348

              /CODE

               

              Thank you for the welcome and the help.

                • Gathering data for export
                  Olly Bond

                  Hello dpetrauskas,

                   

                  This looks clearer! It also looks fairly simple in Monarch.

                   

                  If you open the report in Monarch, and highlight the first line of data:

                   

                  E    1234567    P   DOE, JOHN                            1.00-  06/30/2010 07/01/2010  07/01/2010 07/01/2010          1.00-  MDANIEL[/CODE]

                   

                  then go to the Template menu, and select New template. You should see a dialog at the top of the page with a trap line (labelled T) and a selection line (labelled S). In the trap line, position the cursor above the 1 of the account number, and then click on the N button just above.

                   

                  Does this highlight all the data lines in your report?

                   

                  HTH,

                   

                  Olly