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,

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
------------------------------
"

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
------------------------------
"

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
------------------------------
"

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
------------------------------"