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

    Excluding Data From A Detail Trap

    HSACDM _

      I'm new to this forum and also a new user of Monarch 9.  I’ve created a detail template using the numerical trap on the MTD Usage column to capture the data for the following fields:

       

      CHG CODE

      Description

      MTD Usage

      MTD Revenue

      YTD Usage

      YTD Revenue

       

      The problem is that my template is also capturing the SUBTOTAL line, which is just excess data that isn’t needed.  How can I exclude it?  I couldn’t use the numeric trap on the Chg Code field because some of the data isn’t numerical.

       

      FOR DATE:     April 2009

       

                                             Mtd              Mtd         Ytd                Ytd

      CHG CODE     Description             Usage          Revenue       Usage            Revenue

      -


      Dept:        01 ROOM AND BOARD

      Sub-Dept:    01 ROOM AND BOARD

      INPATIENT

       

      0112011      SKILLED NURSING             0             0.00           0              0.00

      0112029      SKILLED NURSING-BED         0             0.00           0              0.00

      0112086      ACUTE MEDICAL OMS           0             0.00           0              0.00

      0112094      ACUTE MEDICAL               0             0.00           0              0.00

      0112102      SURGICAL ACUTE OMS          0             0.00           0              0.00

      0112110      SURGICAL ACUTE              0             0.00           0              0.00

      0112300      INTENSIVE CARE              0             0.00           0              0.00

      0112961      ICU - ADULT                 0             0.00           0              0.00

      0122010      SKILLED NURSING             0             0.00           0              0.00

      0122093      ACUTE MEDICAL               0             0.00           0              0.00

      0122119      SURGICAL ACUTE              0             0.00           0              0.00

      0122309      INTENSIVE CARE              0             0.00           0              0.00

      0122960      ICU - ADULT                 0             0.00           0              0.00

      0134015      SKILLED NURSING             0             0.00           0              0.00

      0134098      ACUTE MEDICAL               0             0.00           0              0.00

      0155010      SKILLED NURSING             0             0.00           0              0.00

      0155036      SKILLED NURSING TB          0             0.00           0              0.00

      0155093      ACUTE MEDICAL               0             0.00           0              0.00

      0178400      ORTHO-NEURO ACUTE           0             0.00           0              0.00

       

      SUBTOTAL INPATIENT                       0             0.00           0              0.00

       

      Dept:        01 ROOM AND BOARD

      Sub-Dept:    01 ROOM AND BOARD

      OUTPATIENT

       

      0112110      SURGICAL ACUTE              0             0.00           0              0.00

       

      SUBTOTAL OUTPATIENT                      0             0.00           0              0.00

       

      Dept:        01 ROOM AND BOARD

      Sub-Dept:    01 ROOM AND BOARD

      SERIES/RECURRING

       

      0112011      SKILLED NURSING             0             0.00           0              0.00

      0112029      SKILLED NURSING-BED         0             0.00           0              0.00

      0112086      ACUTE MEDICAL OMS           0             0.00           0              0.00

      0112094      ACUTE MEDICAL               0             0.00           0              0.00

      0112102      SURGICAL ACUTE OMS          0             0.00           0              0.00

      0112110      SURGICAL ACUTE              0             0.00           0              0.00

      0112151      SURGICAL ACUTE MEDI         0             0.00           0              0.00

      0112300      INTENSIVE CARE              0             0.00           0              0.00

      0122093      ACUTE MEDICAL               0             0.00           0              0.00

      0134601      ADM-A HOLD-ACUTE            0             0.00           0              0.00

      0155119      SURGICAL ACUTE              0             0.00           0              0.00

      0178400      ORTHO-NEURO ACUTE           0             0.00           0              0.00

      0178426      ORTHO-NEURO ACUTE M         0             0.00           0              0.00

       

      SUBTOTAL SERIES/RECURRING                0             0.00           0              0.00[/CODE]