Remit lines that vary

Stephanie_21597
Stephanie_21597 Altair Community Member
edited February 2019 in Community Q&A
​ I have a remit that has lines that vary in the length.  So 1 patient could have 5 lines but other could have 8.  It just depends on how many rev codes are listed.  I have gotten all the data that is the same and in the same place for all the patients trapped and ready.  It's just the data in the rev codes that I have an issue with.

If I do these separate, then I pull in the monthly totals that throw off the rows so they don't align with the correct patients.

I am not sure what is the best way to fix this.

Thanks.

------------------------------
Stephanie Lynch
Net Revenue Analyst
St. Thomas Health
TN
615.284.7376
------------------------------
Tagged:

Answers

  • Ermela
    Ermela
    Altair Employee
    edited February 2019
    Hi Stephanie,

    That depends on how your report is arranged.  If rev codes is nicely formatted in a column then you can use the Advanced tab of Edit Field Properties when defining fields/columns during report trapping.  Note that the screen capture is from Data Prep Studio Report Design but Monarch Classic also has this feature.


    Or you can extract succeeding lines using the Group Footer template.

    If you can show us a sample of how your report is formatted that would be helpful.

    Hope this helps,
    Mela

    ------------------------------
    Mela Sarenas
    Software Quality Manager
    Datawatch Corporation
    Bedford MA
    + 1.800.445.3311
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 02-12-2019 04:18 PM
    From: Stephanie Lynch
    Subject: Remit lines that vary

    I have a remit that has lines that vary in the length.  So 1 patient could have 5 lines but other could have 8.  It just depends on how many rev codes are listed.  I have gotten all the data that is the same and in the same place for all the patients trapped and ready.  It's just the data in the rev codes that I have an issue with.

    If I do these separate, then I pull in the monthly totals that throw off the rows so they don't align with the correct patients.

    I am not sure what is the best way to fix this.

    Thanks.

    ------------------------------
    Stephanie Lynch
    Net Revenue Analyst
    St. Thomas Health
    TN
    615.284.7376
    ------------------------------
    "
  • Stephanie_21597
    Stephanie_21597 Altair Community Member
    edited February 2019
    Ermela said:

    Hi Stephanie,

    That depends on how your report is arranged.  If rev codes is nicely formatted in a column then you can use the Advanced tab of Edit Field Properties when defining fields/columns during report trapping.  Note that the screen capture is from Data Prep Studio Report Design but Monarch Classic also has this feature.


    Or you can extract succeeding lines using the Group Footer template.

    If you can show us a sample of how your report is formatted that would be helpful.

    Hope this helps,
    Mela

    ------------------------------
    Mela Sarenas
    Software Quality Manager
    Datawatch Corporation
    Bedford MA
    + 1.800.445.3311
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 02-12-2019 04:18 PM
    From: Stephanie Lynch
    Subject: Remit lines that vary

    I have a remit that has lines that vary in the length.  So 1 patient could have 5 lines but other could have 8.  It just depends on how many rev codes are listed.  I have gotten all the data that is the same and in the same place for all the patients trapped and ready.  It's just the data in the rev codes that I have an issue with.

    If I do these separate, then I pull in the monthly totals that throw off the rows so they don't align with the correct patients.

    I am not sure what is the best way to fix this.

    Thanks.

    ------------------------------
    Stephanie Lynch
    Net Revenue Analyst
    St. Thomas Health
    TN
    615.284.7376
    ------------------------------
    "

    I wish it was that easy.  I have 4 lines that are the same for every patient.  I have been able to get that data, no problem.  after that the lines vary depending on how many rev codes were billed to Medicare.  Some could be 1 line, some could be 5. 

    There is also the drg weight that I need to pull.  I tried to pull that in a separate template, but since there are monthly totals at the end of each remit, those monthly totals throw off the alignment.

    ------------------------------
    Stephanie Lynch
    Net Revenue Analyst
    St. Thomas Health
    TN
    615.284.7376
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 02-13-2019 03:41 AM
    From: Mela Sarenas
    Subject: Remit lines that vary

    Hi Stephanie,

    That depends on how your report is arranged.  If rev codes is nicely formatted in a column then you can use the Advanced tab of Edit Field Properties when defining fields/columns during report trapping.  Note that the screen capture is from Data Prep Studio Report Design but Monarch Classic also has this feature.


    Or you can extract succeeding lines using the Group Footer template.

    If you can show us a sample of how your report is formatted that would be helpful.

    Hope this helps,
    Mela

    ------------------------------
    Mela Sarenas
    Software Quality Manager
    Datawatch Corporation
    Bedford MA
    + 1.800.445.3311
    ------------------------------

    Original Message:
    Sent: 02-12-2019 04:18 PM
    From: Stephanie Lynch
    Subject: Remit lines that vary

    I have a remit that has lines that vary in the length.  So 1 patient could have 5 lines but other could have 8.  It just depends on how many rev codes are listed.  I have gotten all the data that is the same and in the same place for all the patients trapped and ready.  It's just the data in the rev codes that I have an issue with.

    If I do these separate, then I pull in the monthly totals that throw off the rows so they don't align with the correct patients.

    I am not sure what is the best way to fix this.

    Thanks.

    ------------------------------
    Stephanie Lynch
    Net Revenue Analyst
    St. Thomas Health
    TN
    615.284.7376
    ------------------------------
    "
  • Ermela
    Ermela
    Altair Employee
    edited February 2019
    Stephanie_21597 said:

    I wish it was that easy.  I have 4 lines that are the same for every patient.  I have been able to get that data, no problem.  after that the lines vary depending on how many rev codes were billed to Medicare.  Some could be 1 line, some could be 5. 

    There is also the drg weight that I need to pull.  I tried to pull that in a separate template, but since there are monthly totals at the end of each remit, those monthly totals throw off the alignment.

    ------------------------------
    Stephanie Lynch
    Net Revenue Analyst
    St. Thomas Health
    TN
    615.284.7376
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 02-13-2019 03:41 AM
    From: Mela Sarenas
    Subject: Remit lines that vary

    Hi Stephanie,

    That depends on how your report is arranged.  If rev codes is nicely formatted in a column then you can use the Advanced tab of Edit Field Properties when defining fields/columns during report trapping.  Note that the screen capture is from Data Prep Studio Report Design but Monarch Classic also has this feature.


    Or you can extract succeeding lines using the Group Footer template.

    If you can show us a sample of how your report is formatted that would be helpful.

    Hope this helps,
    Mela

    ------------------------------
    Mela Sarenas
    Software Quality Manager
    Datawatch Corporation
    Bedford MA
    + 1.800.445.3311
    ------------------------------

    Original Message:
    Sent: 02-12-2019 04:18 PM
    From: Stephanie Lynch
    Subject: Remit lines that vary

    I have a remit that has lines that vary in the length.  So 1 patient could have 5 lines but other could have 8.  It just depends on how many rev codes are listed.  I have gotten all the data that is the same and in the same place for all the patients trapped and ready.  It's just the data in the rev codes that I have an issue with.

    If I do these separate, then I pull in the monthly totals that throw off the rows so they don't align with the correct patients.

    I am not sure what is the best way to fix this.

    Thanks.

    ------------------------------
    Stephanie Lynch
    Net Revenue Analyst
    St. Thomas Health
    TN
    615.284.7376
    ------------------------------
    "

    How about a 2 model approach?  Create another model with rev codes as detail template, patient info as append (this will be used to join the 2 models) and a footer template for the drg weight line.  Note that if monthly totals for drg line will not be extracted in this case.

    If you are using Data Prep Studio, you can use 2 models for the same report then join both tables in one workspace.

    I am sure there are more suggestions from other members of the community. :)

    Mela

    ------------------------------
    Mela Sarenas
    Software Quality Manager
    Datawatch Corporation
    Bedford MA
    + 1.800.445.3311
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 02-13-2019 07:21 AM
    From: Stephanie Lynch
    Subject: Remit lines that vary

    I wish it was that easy.  I have 4 lines that are the same for every patient.  I have been able to get that data, no problem.  after that the lines vary depending on how many rev codes were billed to Medicare.  Some could be 1 line, some could be 5.

    There is also the drg weight that I need to pull.  I tried to pull that in a separate template, but since there are monthly totals at the end of each remit, those monthly totals throw off the alignment.

    ------------------------------
    Stephanie Lynch
    Net Revenue Analyst
    St. Thomas Health
    TN
    615.284.7376
    ------------------------------

    Original Message:
    Sent: 02-13-2019 03:41 AM
    From: Mela Sarenas
    Subject: Remit lines that vary

    Hi Stephanie,

    That depends on how your report is arranged.  If rev codes is nicely formatted in a column then you can use the Advanced tab of Edit Field Properties when defining fields/columns during report trapping.  Note that the screen capture is from Data Prep Studio Report Design but Monarch Classic also has this feature.


    Or you can extract succeeding lines using the Group Footer template.

    If you can show us a sample of how your report is formatted that would be helpful.

    Hope this helps,
    Mela

    ------------------------------
    Mela Sarenas
    Software Quality Manager
    Datawatch Corporation
    Bedford MA
    + 1.800.445.3311

    Original Message:
    Sent: 02-12-2019 04:18 PM
    From: Stephanie Lynch
    Subject: Remit lines that vary

    I have a remit that has lines that vary in the length.  So 1 patient could have 5 lines but other could have 8.  It just depends on how many rev codes are listed.  I have gotten all the data that is the same and in the same place for all the patients trapped and ready.  It's just the data in the rev codes that I have an issue with.

    If I do these separate, then I pull in the monthly totals that throw off the rows so they don't align with the correct patients.

    I am not sure what is the best way to fix this.

    Thanks.

    ------------------------------
    Stephanie Lynch
    Net Revenue Analyst
    St. Thomas Health
    TN
    615.284.7376
    ------------------------------
    "
  • Steve_Caiels
    Steve_Caiels
    Altair Employee
    edited February 2019
    Stephanie_21597 said:

    I wish it was that easy.  I have 4 lines that are the same for every patient.  I have been able to get that data, no problem.  after that the lines vary depending on how many rev codes were billed to Medicare.  Some could be 1 line, some could be 5. 

    There is also the drg weight that I need to pull.  I tried to pull that in a separate template, but since there are monthly totals at the end of each remit, those monthly totals throw off the alignment.

    ------------------------------
    Stephanie Lynch
    Net Revenue Analyst
    St. Thomas Health
    TN
    615.284.7376
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 02-13-2019 03:41 AM
    From: Mela Sarenas
    Subject: Remit lines that vary

    Hi Stephanie,

    That depends on how your report is arranged.  If rev codes is nicely formatted in a column then you can use the Advanced tab of Edit Field Properties when defining fields/columns during report trapping.  Note that the screen capture is from Data Prep Studio Report Design but Monarch Classic also has this feature.


    Or you can extract succeeding lines using the Group Footer template.

    If you can show us a sample of how your report is formatted that would be helpful.

    Hope this helps,
    Mela

    ------------------------------
    Mela Sarenas
    Software Quality Manager
    Datawatch Corporation
    Bedford MA
    + 1.800.445.3311
    ------------------------------

    Original Message:
    Sent: 02-12-2019 04:18 PM
    From: Stephanie Lynch
    Subject: Remit lines that vary

    I have a remit that has lines that vary in the length.  So 1 patient could have 5 lines but other could have 8.  It just depends on how many rev codes are listed.  I have gotten all the data that is the same and in the same place for all the patients trapped and ready.  It's just the data in the rev codes that I have an issue with.

    If I do these separate, then I pull in the monthly totals that throw off the rows so they don't align with the correct patients.

    I am not sure what is the best way to fix this.

    Thanks.

    ------------------------------
    Stephanie Lynch
    Net Revenue Analyst
    St. Thomas Health
    TN
    615.284.7376
    ------------------------------
    "

    Hi Stephanie,

    Do you want one record per patient or one record per Medicare code? 

    Either should be possible.  Do you have Monarch complete (Classic and Data Prep Studio) or just Classic?  As Mela mentioned, there are features in DPS that might be helpful such as multiple extractions per workspace and the unpivot/pivot functionality if you want each Medicare code in a separate column of a single patient record.

    Is this a text report or PDF?  If text, is there any chance you could edit a one page sample to remove confidential information and provide it to us?

    Thanks, 
    Steve.

    ------------------------------
    Steve Caiels
    Professional Service
    Datawatch Corporation
    +44 203 868 0253
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 02-13-2019 07:21 AM
    From: Stephanie Lynch
    Subject: Remit lines that vary

    I wish it was that easy.  I have 4 lines that are the same for every patient.  I have been able to get that data, no problem.  after that the lines vary depending on how many rev codes were billed to Medicare.  Some could be 1 line, some could be 5.

    There is also the drg weight that I need to pull.  I tried to pull that in a separate template, but since there are monthly totals at the end of each remit, those monthly totals throw off the alignment.

    ------------------------------
    Stephanie Lynch
    Net Revenue Analyst
    St. Thomas Health
    TN
    615.284.7376
    ------------------------------

    Original Message:
    Sent: 02-13-2019 03:41 AM
    From: Mela Sarenas
    Subject: Remit lines that vary

    Hi Stephanie,

    That depends on how your report is arranged.  If rev codes is nicely formatted in a column then you can use the Advanced tab of Edit Field Properties when defining fields/columns during report trapping.  Note that the screen capture is from Data Prep Studio Report Design but Monarch Classic also has this feature.


    Or you can extract succeeding lines using the Group Footer template.

    If you can show us a sample of how your report is formatted that would be helpful.

    Hope this helps,
    Mela

    ------------------------------
    Mela Sarenas
    Software Quality Manager
    Datawatch Corporation
    Bedford MA
    + 1.800.445.3311

    Original Message:
    Sent: 02-12-2019 04:18 PM
    From: Stephanie Lynch
    Subject: Remit lines that vary

    I have a remit that has lines that vary in the length.  So 1 patient could have 5 lines but other could have 8.  It just depends on how many rev codes are listed.  I have gotten all the data that is the same and in the same place for all the patients trapped and ready.  It's just the data in the rev codes that I have an issue with.

    If I do these separate, then I pull in the monthly totals that throw off the rows so they don't align with the correct patients.

    I am not sure what is the best way to fix this.

    Thanks.

    ------------------------------
    Stephanie Lynch
    Net Revenue Analyst
    St. Thomas Health
    TN
    615.284.7376
    ------------------------------
    "
  • Austin_22207
    Austin_22207 Altair Community Member
    edited February 2019
    Stephanie_21597 said:

    I wish it was that easy.  I have 4 lines that are the same for every patient.  I have been able to get that data, no problem.  after that the lines vary depending on how many rev codes were billed to Medicare.  Some could be 1 line, some could be 5. 

    There is also the drg weight that I need to pull.  I tried to pull that in a separate template, but since there are monthly totals at the end of each remit, those monthly totals throw off the alignment.

    ------------------------------
    Stephanie Lynch
    Net Revenue Analyst
    St. Thomas Health
    TN
    615.284.7376
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 02-13-2019 03:41 AM
    From: Mela Sarenas
    Subject: Remit lines that vary

    Hi Stephanie,

    That depends on how your report is arranged.  If rev codes is nicely formatted in a column then you can use the Advanced tab of Edit Field Properties when defining fields/columns during report trapping.  Note that the screen capture is from Data Prep Studio Report Design but Monarch Classic also has this feature.


    Or you can extract succeeding lines using the Group Footer template.

    If you can show us a sample of how your report is formatted that would be helpful.

    Hope this helps,
    Mela

    ------------------------------
    Mela Sarenas
    Software Quality Manager
    Datawatch Corporation
    Bedford MA
    + 1.800.445.3311
    ------------------------------

    Original Message:
    Sent: 02-12-2019 04:18 PM
    From: Stephanie Lynch
    Subject: Remit lines that vary

    I have a remit that has lines that vary in the length.  So 1 patient could have 5 lines but other could have 8.  It just depends on how many rev codes are listed.  I have gotten all the data that is the same and in the same place for all the patients trapped and ready.  It's just the data in the rev codes that I have an issue with.

    If I do these separate, then I pull in the monthly totals that throw off the rows so they don't align with the correct patients.

    I am not sure what is the best way to fix this.

    Thanks.

    ------------------------------
    Stephanie Lynch
    Net Revenue Analyst
    St. Thomas Health
    TN
    615.284.7376
    ------------------------------
    "

    Hi Stephanie! I could be wrong on this without seeing a full data set but I would think you would be able to capture the 4 lines that are the same for every patient using an Append template and then use the Detail template for the revenue code lines and a Group Footer for the DRG WGHT.

    I'd be happy to help you create a template if you wanted to send me an original file and take out any PHI. Alternatively, I work for a healthcare consulting company so we could also get a non-disclosure between us to allow for sharing of PHI if it's too much trouble to remove.

    EDIT: I just found out that we are in the process of signing a master services agreement with Ascension and should have an executed copy any day now. If that goes through, it will cover your ability to share PHI. Feel free to reach out anytime, always happy to help.

    ------------------------------
    Austin Perkins, CPA
    Managing Consultant
    BKD, LLP
    Louisville, Kentucky
    502-963-0812
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 02-13-2019 07:21 AM
    From: Stephanie Lynch
    Subject: Remit lines that vary

    I wish it was that easy.  I have 4 lines that are the same for every patient.  I have been able to get that data, no problem.  after that the lines vary depending on how many rev codes were billed to Medicare.  Some could be 1 line, some could be 5.

    There is also the drg weight that I need to pull.  I tried to pull that in a separate template, but since there are monthly totals at the end of each remit, those monthly totals throw off the alignment.

    ------------------------------
    Stephanie Lynch
    Net Revenue Analyst
    St. Thomas Health
    TN
    615.284.7376
    ------------------------------

    Original Message:
    Sent: 02-13-2019 03:41 AM
    From: Mela Sarenas
    Subject: Remit lines that vary

    Hi Stephanie,

    That depends on how your report is arranged.  If rev codes is nicely formatted in a column then you can use the Advanced tab of Edit Field Properties when defining fields/columns during report trapping.  Note that the screen capture is from Data Prep Studio Report Design but Monarch Classic also has this feature.


    Or you can extract succeeding lines using the Group Footer template.

    If you can show us a sample of how your report is formatted that would be helpful.

    Hope this helps,
    Mela

    ------------------------------
    Mela Sarenas
    Software Quality Manager
    Datawatch Corporation
    Bedford MA
    + 1.800.445.3311

    Original Message:
    Sent: 02-12-2019 04:18 PM
    From: Stephanie Lynch
    Subject: Remit lines that vary

    I have a remit that has lines that vary in the length.  So 1 patient could have 5 lines but other could have 8.  It just depends on how many rev codes are listed.  I have gotten all the data that is the same and in the same place for all the patients trapped and ready.  It's just the data in the rev codes that I have an issue with.

    If I do these separate, then I pull in the monthly totals that throw off the rows so they don't align with the correct patients.

    I am not sure what is the best way to fix this.

    Thanks.

    ------------------------------
    Stephanie Lynch
    Net Revenue Analyst
    St. Thomas Health
    TN
    615.284.7376
    ------------------------------"

Categories