10 Replies Latest reply: May 15, 2014 10:05 AM by Olly Bond RSS

    template issue

    PamHR _

      I worked with Hospitals and extract the data from a Medicare report.  I have a model set up for the report and 99.9% of the time I have no issues.  Eash hospital is given a Medicare provider number and each report normally has 1 provider number, the report I am having porblems has 2 provider numbers, but I'm not sure that is the problem. All my data is highlighted but the 2nd half of the report does not show in the table, I'm not sure if this is because of the contrasting data in the middle or not.  Is there a limit of rows on the table?? I am currently using MOnarch 9.0.

      This is what the layout of the report looks like- I can't show any data as that is confidential.

      1                    P R O V I D E R   S T A T I S T I C A L   A N D   R E I M B U R S E M E N T   S Y S T E M                          

      0PROGRAM ID: MD420501 - V40.0                                                                                PAGE: 271126       

      SERVICE MONTH END:  01/31/06                       PAYMENT RECONCILIATION REPORT                                                       

      RUN DATE:        08/18/09                                                                                REPORT #: OD44202         

      PROVIDER FYE:    12/31                              INPATIENT - PART A (MSP-LCC)                             REPORT TYPE:  11A         

      PROVIDER: 11111111        Name of hospital goes here                                                        PAID DATES:  01/01/06 THRU 07/31/09       

      0************************************************************************************************************************************   

      PATIENT     CONTROL            HIC       MEDICARE     TOT COVRD       GROSS           NET      -


      DEDUCTIBLES -
         

       

      • NAME        NUMBER          NUMBER        DAYS        CHARGES    REIMBURSEMENT  REIMBURSEMENT     CASH        BLOOD       COINS  *   

       

                                                                                                                                                                                                                                                                            •     

       

       

       

      different report foramtting goes here and should be ignored.

       

       

       

      1                    P R O V I D E R   S T A T I S T I C A L   A N D   R E I M B U R S E M E N T   S Y S T E M                          

      0PROGRAM ID: MD420501 - V40.0                                                                                PAGE: 271126       

      SERVICE MONTH END:  01/31/06                       PAYMENT RECONCILIATION REPORT                                                       

      RUN DATE:        08/18/09                                                                                REPORT #: OD44202         

      PROVIDER FYE:    12/31                              INPATIENT - PART A (MSP-LCC)                             REPORT TYPE:  11A         

      PROVIDER: 1111111122       Name of hospital goes here                                                        PAID DATES:  01/01/06 THRU 07/31/09       

      0************************************************************************************************************************************   

      PATIENT     CONTROL            HIC       MEDICARE     TOT COVRD       GROSS           NET      -


      DEDUCTIBLES -
         

       

      • NAME        NUMBER          NUMBER        DAYS        CHARGES    REIMBURSEMENT  REIMBURSEMENT     CASH        BLOOD       COINS  *   

       

                                                                                                                                                                                                                                                                            •     

      /code

        • template issue
          Data Kruncher

          It's a bit challenging to determine what's going on based on your sample, which given the data, had to be edited.

           

          On that note, please check your private messages Pam.

          • template issue
            Grant Perkins

            H PamHR,

             

            I would imagine your provider number is an append of some sort and assume that the field is long enough to store any reference number/code it is likely to find. If it is short it is just possible that the field reports the two proviers as the same nmber I guess but I'm not sure what effect that might have on what you see in the table.

             

            Three other possibilities come to mind:

             

            1) You have a filter in play somewhere that excludes the second half of the report.

             

            2) Although the line highlight as selectable something else is stopping that happening in the second part of the report. For example if you are using a multiple line detail template and for some reason the trap line is overlapped by a previous occurrence of the template you might miss the selection in practice even though in theory it looks OK. This could happen if, say, you have a 5 line sample selection for your tmplate but in the second part of the report the records are only 4 lines. The fifth line would make the 'cover' the selection of the first line of the next record. Howecver that would normally mean that some record, typically alternate records,  are missed, not all of them and you are reporting all missing.

             

            3) You happen to have reached some sort of internal technical limit co-incidentally with the start of the second part of the report. That's a long shot but have you checked that you are actually getting all of the first part and none of the second? (I mention it because the PAGE NUMBERs in your sample are very large but I might also guess they are not real). There are limitation on the total size of the work file created by the extraction but typically it will accomodate several million records. If you are likely to be dealing with that sort of number we may need to look into that but I wold start elsewhere if that is not the case.

             

            Have you run the VERIFY feature to see what it tells you?

             

            HTH,

             

             

             

            Grant

              • template issue
                PamHR _

                yes the provider number and the report type are an append the detail is  a 2 line detial it starts with the patient name and ends with the patient status.  I have no other templates.  the page numbers are real- the  text file I am working with is 1.32 GIG- yes GIG. I have verify and it all seems ok.  I have talked to our Hipaa person here and after changing all the patient data I can show you a little bit more detailed of my issue.

                In the example below the inpatient data for both provider numbers( the data I want) is trapped and the Outpatient data ( data I don't want) is not trapped.  yet when I transferr to the table only the inpatient data for the 1st provider number shows up.  I keep maxing out at 469,973 rows. I don't think memory is an issue- I have Vista- I have 158 Gigs of free drive, and I have 4 gig of RAM. 

                1                    P R O V I D E R   S T A T I S T I C A L   A N D   R E I M B U R S E M E N T   S Y S T E M                          

                0PROGRAM ID: MD420501 - V40.0                                                                                PAGE:     12       

                SERVICE MONTH END:  01/31/06                       PAYMENT RECONCILIATION REPORT                                                       

                RUN DATE:        08/18/09                                                                                REPORT #: OD44202         

                PROVIDER FYE:    12/31                                   INPATIENT - PART A                                  REPORT TYPE:  110         

                PROVIDER: 111111           Hospital Name here                                                PAID DATES:  01/01/06 THRU 07/31/09       

                0************************************************************************************************************************************   

                PATIENT     CONTROL            HIC       MEDICARE     TOT COVRD       GROSS           NET      -


                DEDUCTIBLES -
                   

                 

                • NAME        NUMBER          NUMBER        DAYS        CHARGES    REIMBURSEMENT  REIMBURSEMENT     CASH        BLOOD       COINS  *   

                 

                                                                                                                                                                                                                                                                                      •     

                -


                     

                smith  b 11111111111111    111111111A         3       $27,351.65   $10,775.23    $9,863.23        $912.00         $.00         $.00    

                  PIP*BILL         DRG CODE: 127       FROM: 99/99/99/ THRU: 22/11/33  PAID DATE: 11/11/11  BILL FREQ: 1 DSCHRG-PATNT STATUS:YES   01    

                   HSP:            $.00  FSP:       $5,984.38                            DSH:       $1,847.98  IME (AFTER 9/88):       $2,165.58        

                0REVENUE CODES :  0214  2   $15,030.00   0214  1    $8,267.00   0250 22       $37.65   0270  2       $42.00   0300  3      $365.00      

                                  0301 13    $1,237.00   0305  4      $387.00   0324  1      $241.00   0450  1      $974.00   0730  4      $771.00      

                                                                   DRG WGHT:          1.0345 DSCHG FRCTN:       1.0000 DSCHG WGHT FRCTN:      1.0345    

                (CAPITAL)  PYMNT:        $777.29      HSP:           $.00      FSP:        $541.90    OUTLR:           $.00  DSH ADJ:        $58.36    

                        HOLD HARM:           $.00 IME-ADJ :        $177.03 EXCPTONS:           $.00                                                                               

                B-FSP:        $541.90   B-OUTLR:          $.00    CAPITAL PAY CODE:  B    

                -


                     

                jones j 22222222222222    222222222A         1        $7,919.39    $7,606.71    $6,654.71        $952.00         $.00         $.00    

                  PIP*BILL         DRG CODE: 096       FROM: 99/99/99 THRU: 99/99/99  PAID DATE: 11/11/11 BILL FREQ: 1 DSCHRG-PATNT STATUS:YES   01    

                   HSP:            $.00  FSP:       $4,224.64                            DSH:       $1,304.57  IME (AFTER 9/88):       $1,528.78        

                0REVENUE CODES :  0121  1    $4,937.00   0250 47       $40.39   0300  3      $402.00   0301  6      $684.00   0305  4      $426.00      

                                  0307  1       $51.00   0324  1      $308.00   0450  1    $1,071.00                                                                               

                DRG WGHT:          0.7303 DSCHG FRCTN:       1.0000 DSCHG WGHT FRCTN:      0.7303    

                (CAPITAL)  PYMNT:        $548.72      HSP:           $.00      FSP:        $382.55    OUTLR:           $.00  DSH ADJ:        $41.20    

                        HOLD HARM:           $.00 IME-ADJ :        $124.97 EXCPTONS:           $.00                                                                               

                B-FSP:        $382.55   B-OUTLR:          $.00    CAPITAL PAY CODE:  B    

                -


                     

                smith k 33333333333333    111111111C1        1       $13,287.16    $8,762.87    $8,524.87           $.00         $.00      $238.00    

                  PIP*BILL         DRG CODE: 182       FROM: 99/99/99 THRU: 01/02/06  PAID DATE: 11/11/11  BILL FREQ: 1 DSCHRG-PATNT STATUS:YES   07    

                   HSP:            $.00  FSP:       $4,866.75                            DSH:       $1,502.85  IME (AFTER 9/88):       $1,761.14        

                0REVENUE CODES :  0121  1    $4,937.00   0250 17       $51.16   0272  2      $279.00   0301  7      $595.00   0305  4      $426.00      

                                  0352  2    $4,034.00   0450  1    $1,071.00   0801  1    $1,894.00                                                                               

                DRG WGHT:          0.8413 DSCHG FRCTN:       1.0000 DSCHG WGHT FRCTN:      0.8413    

                (CAPITAL)  PYMNT:        $632.13      HSP:           $.00      FSP:        $440.70    OUTLR:           $.00  DSH ADJ:        $47.46    

                        HOLD HARM:           $.00 IME-ADJ :        $143.97 EXCPTONS:           $.00                                                                               

                B-FSP:        $440.70   B-OUTLR:          $.00    CAPITAL PAY CODE:  B    

                 

                1                    P R O V I D E R   S T A T I S T I C A L   A N D   R E I M B U R S E M E N T   S Y S T E M                          

                0PROGRAM ID: MD420501 - V40.0                                                                                PAGE: 191441       

                SERVICE MONTH END:  07/31/06                       PAYMENT RECONCILIATION REPORT                                                       

                RUN DATE:        08/18/09                                                                                REPORT #: OD44202         

                PROVIDER FYE:    12/31                                  HOSPITAL OUTPATIENT                                  REPORT TYPE:  998         

                PROVIDER: 111111          hospital name                                                 PAID DATES:  01/01/06 THRU 07/31/09       

                0************************************************************************************************************************************   

                0TYPE       CHARGES          REIM       CASH     BLOOD DED        COINS           MSP          OTL      INT        PRICE  ESRD / GAPC   

                -


                       -


                          -


                       -


                     -


                        -


                           ---          ---      ---        -


                  -


                     

                P-137       105.00          8.49                                                                               

                Q-13x        80.00         57.44                                 14.36                                                        71.80    

                ====================================================================================================================================   

                TOTAL       185.00         65.93                                 14.36                                                        71.80    

                0      ******        ************       ***********************                                                                         

                NAME: smith   HIC: 111111111A    MRN: 99999999999999999                    FI CTRL:     12345678912345            BILL FREQ: 1        

                        

                          •        ************       ***********************           PAID DATE: 99/99/99 FROM DATE: 01/01/01 THRU DATE: 01/23/45   

                0T-REV HCPCS UNT    CHARGES  FEE-PRICE   ASC *T-REV HCPCS UNT    CHARGES  FEE-PRICE   ASC *T-REV HCPCS UNT    CHARGES FEE-PRICE   ASC   

                -


                -


                ---    -


                  -


                   - *--- -


                ---    -


                  -


                   - *--- -


                ---    -


                -


                   ---   

                P-300 36415   1      32.00       3.00        P-301 84153   1     158.00      25.70                                                     

                0TYPE       CHARGES          REIM       CASH     BLOOD DED        COINS           MSP          OTL      INT        PRICE  ESRD / GAPC   

                -


                       -


                          -


                       -


                     -


                        -


                           ---          ---      ---        -


                  -


                     

                P-135       190.00         28.70                                                                               

                ====================================================================================================================================   

                TOTAL       190.00         28.70                                                                               

                0      ******        ************       ***********************                                                                         

                NAME: jones   HIC: 111111111A    MRN: 99999999999999999                    FI CTRL:     98765432198765            BILL FREQ: 1        

                        

                          •        ************       ***********************           PAID DATE: 01/23/45 FROM DATE: 99/99/99 THRU DATE: 11/22/33   

                0T-REV HCPCS UNT    CHARGES  FEE-PRICE   ASC *T-REV HCPCS UNT    CHARGES  FEE-PRICE   ASC *T-REV HCPCS UNT    CHARGES FEE-PRICE   ASC   

                -


                -


                ---    -


                  -


                   - *--- -


                ---    -


                  -


                   - *--- -


                ---    -


                -


                   ---   

                Q-510 99211   1      70.00                                                                               

                0TYPE       CHARGES          REIM       CASH     BLOOD DED        COINS           MSP          OTL      INT        PRICE  ESRD / GAPC   

                -


                       -


                          -


                       -


                     -


                        -


                           ---          ---      ---        -


                  -


                     

                Q-13P        70.00         49.93                                 12.48                                                        62.41    

                ====================================================================================================================================   

                TOTAL        70.00         49.93                                 12.48                                                        62.41    

                0      ******        ************       ***********************                                                                         

                NAME: smith   HIC: 111111111A    MRN: 999999999999999999                    FI CTRL:     111222333445678            BILL FREQ: 1        

                        

                          •        ************       ***********************           PAID DATE: 01/32/01 FROM DATE: 13/33/99 THRU DATE: 01/01/01   

                0T-REV HCPCS UNT    CHARGES  FEE-PRICE   ASC *T-REV HCPCS UNT    CHARGES  FEE-PRICE   ASC *T-REV HCPCS UNT    CHARGES FEE-PRICE   ASC   

                -


                -


                ---    -


                  -


                   - *--- -


                ---    -


                  -


                   - *--- -


                ---    -


                -


                   ---   

                Q-324 71020   1     308.00                                                                               

                1                    P R O V I D E R   S T A T I S T I C A L   A N D   R E I M B U R S E M E N T   S Y S T E M                          

                0PROGRAM ID: MD420501 - V40.0                                                                                PAGE: 277307       

                SERVICE MONTH END:  03/31/06                       PAYMENT RECONCILIATION REPORT                                                       

                RUN DATE:        08/18/09                                                                                REPORT #: OD44202         

                PROVIDER FYE:    12/31                             INPATIENT - PART A MANAGED CARE                           REPORT TYPE:  118         

                PROVIDER: 111111112        another hospital name here                                       PAID DATES:  01/01/01 THRU 99/99/99       

                0************************************************************************************************************************************   

                PATIENT     CONTROL            HIC       MEDICARE     TOT COVRD       GROSS           NET      -


                DEDUCTIBLES -
                   

                 

                • NAME        NUMBER          NUMBER        DAYS        CHARGES    REIMBURSEMENT  REIMBURSEMENT     CASH        BLOOD       COINS  *   

                 

                                                                                                                                                                                                                                                                                      •     

                -


                     

                smith  k 11111111111111    999999999A         3       $43,187.90   $20,210.39    $4,061.83           $.00         $.00         $.00    

                  PIP*BILL         DRG CODE: 544       FROM: 99/99/99 THRU: 99/99/99  PAID DATE: 99/99/99  BILL FREQ: 1 DSCHRG-PATNT STATUS:YES   03    

                   HSP:            $.00  FSP:      $11,224.51                            DSH:       $3,466.13  IME (AFTER 9/88):       $4,061.83        

                                                                   OTHER:    $16,148.56  MSP:            $.00               INT:            $.00        

                0REVENUE CODES :  0121  3   $14,811.00   0250 85      $347.50   0258  4         $.40   0270  2    $1,460.00   0272  1   $10,008.00      

                                  0301  6      $542.00   0305  4      $436.00   0360  1   $12,500.00   0390  2      $898.00   0420  2      $209.00      

                                  0424  1      $245.00   0434  1      $273.00   0710  1    $1,458.00                                                                               

                DRG WGHT:          1.9643 DSCHG FRCTN:       0.9878 DSCHG WGHT FRCTN:      1.9403    

                (CAPITAL)  PYMNT:      $1,457.92      HSP:           $.00      FSP:      $1,016.41    OUTLR:           $.00  DSH ADJ:       $109.47    

                        HOLD HARM:           $.00 IME-ADJ :        $332.04 EXCPTONS:           $.00                                                                               

                B-FSP:      $1,016.41   B-OUTLR:          $.00    CAPITAL PAY CODE:  B    

                -


                     

                jones b 22222222222222    999999999A         3       $30,886.79   $10,478.36    $2,105.92           $.00         $.00         $.00    

                  PIP*BILL         DRG CODE: 174       FROM: 99/99/99 THRU: 99/99/99  PAID DATE: 99/99/99  BILL FREQ: 1 DSCHRG-PATNT STATUS:YES   01    

                   HSP:            $.00  FSP:       $5,819.51                            DSH:       $1,797.06  IME (AFTER 9/88):       $2,105.92        

                                                                   OTHER:     $8,372.44  MSP:            $.00               INT:            $.00        

                0REVENUE CODES :  0121  3   $14,811.00   0250137    $1,132.59   0258  4       $13.20   0270  2       $46.00   0300  3      $402.00      

                                  0301 36    $3,665.00   0305  9      $908.00   0310  2      $528.00   0324  1      $265.00   0390  4    $1,796.00      

                                  0450  1    $1,071.00   0801  3    $6,249.00                                                                               

                DRG WGHT:          1.0060 DSCHG FRCTN:       1.0000 DSCHG WGHT FRCTN:      1.0060    

                (CAPITAL)  PYMNT:        $755.87      HSP:           $.00      FSP:        $526.97    OUTLR:           $.00  DSH ADJ:        $56.75    

                        HOLD HARM:           $.00 IME-ADJ :        $172.15 EXCPTONS:           $.00                                                                               

                B-FSP:        $526.97   B-OUTLR:          $.00    CAPITAL PAY CODE:  B    

                 

                /code

                  • template issue
                    Olly Bond

                    Hello Pam,

                     

                    If you're faced with 1.3 GB of data there's a way to cope - it's a bit crude but should work reliably.

                     

                    I'm assuming, I hope, that for your detail trap there is a numeric wildcard trap character being used somewhere. In your case perhaps the control number could serve. Edit your trap so that you only select the detailed entries with a specific numeric value in one position - say the last numeric value of the Control Number being 0. Then copy the model 9 times, editing the trap to select detail lines with this character set to 1,2,3,4,5,6,7,8,9.

                     

                    This will give you ten smaller subsets of the overall data. Using project exports, and ten projects, you can then export the 0 dataset to Access or CSV, and follow up by appending the 1, the 2, the 3 etc to build up the total data set.

                     

                    Hope that helps!

                     

                    Olly

                      • template issue
                        Grant Perkins

                        Hi Pam,

                         

                        There is a technical limit within the Monarch 'engine' for the size of the workfile into which the extraction is collected. It is possible that, with your large file input, you are hitting that limit although it would be a huge co-incidence of that happened to match exactly the end of the last record in the first section of the the report! When I have found that limit before during experiments with very large database inputs the extraction woould often just stop part way through a record

                         

                        In theory the limit is 2Gb but in practice it is closer to 1Gb in my experience.

                         

                        Monarch processes things in a TEMP directory - usually a default but sometimes specifically set. The temporary files are cleared when you close Monarch unless an error occurs. The default location of the directory will be slightly different depending upon which operating system you are using.

                         

                        In a corportae environment it is possible that you have a machine set up to restrict access to what is considered to be 'operating system level' folders but if you DO have access perhaps the most direct way to find the files (you need to see how big the workfles are to assess if you have hit this limit) is to run a search for a file named FILEnnnn.MDB (i.e. FILE0003.mdb for example) You should also find another files with the same name but extension .rdf and a small 1kb LOCK file. Possibly also a .ERR file. To find which files relate to your current activity (there tend to be a number of files from different processes lying around in the temp folder I find but that may be to do with system set up and tidying rules) have a not of the dtae and time the process started and its last likely activity so that you can identify based on date and time of last change.

                         

                        If the .MDB file is over 1Gb  (or about 1065Mb as I recall from back in time) the chances are you have hot the limit. That said I'm sure I have processed more records than the 490,000+ you mention BUT the size of the record also determines the size of the work files so number of records alone cannot be conclusive for this assessment.

                         

                        Assuming this IS the problem then I think the approach that Olly has outlined probably offers the best way forward - split the extraction into smaller chunks and then work with the outputs to create something usable form the smaller, re-combined sets.

                         

                         

                        HTH.

                         

                         

                        Grant

                          • template issue
                            PamHR _

                            But I guess the file is just too big to do in one peice- the last 2 times I had to work a file from this client I had to copy and paste the 2nd half of the file into a new file to work it. Unfortunately when you have to copy 10,000 pages and the clipboard can only hold about 900 pages it takes a while.

                            I really did hope that breaking the template down to 10 different ones would help, I do know it gave me a new way of thinking about it, but It just doesn't work. 

                            Thanks anyways, luckily this only happens on this particular client.

                              • template issue
                                Joe Berry

                                Have you tried using a text editor to split the file.  Several will open a file that big and split it in less than 20 minutes.  Most of that time you can be working in another window.  Two who are beefy enough to do that are The Semware Editor (http://www.semware.com/[/url]) and UltraEdit (http://www.ultraedit.com/[/url]). 

                                Might be a little easier than copy and paste.

                                  • template issue
                                    Olly Bond

                                    Hello Pam,

                                     

                                    I'm surprised to hear that the 0-9 approach didn't work - it must be a very big file. You could extend that approach, and have one hundred models 00-99. If you try with one model with 00 - are you able to get an accurate export of that subset?

                                     

                                    Best wishes,

                                     

                                    Olly

                                      • template issue
                                        PamHR _

                                        It works! The first time after creating all the different models, I guess I didn't run a verification on each of them and....

                                        But I just ran all 10 models again and I balance to the printed report totals.

                                         

                                        Thank you so very much, I never would have even thought about breaking it up  like that.

                                         

                                        Pam

                                          • template issue
                                            Olly Bond

                                            Hello Pam,

                                             

                                            Delighted to hear you got it to work that way.

                                             

                                            I'm sure you've seen this elsewhere on the forum, but if you are trying to run ten projects one after another it's much easier to create a batch file than to run them by hand.

                                             

                                            If you visit www.********************[/url] there's a really helpful free tool to build Monarch batch files easily, so you don't have to learn syntax like /rpt:" and /pxall etc.

                                             

                                            Best wishes,

                                             

                                            Olly