PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 07/19/2016 3:19 PM by  JonA
Passing Item Cost to Surgical Systems
 7 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Kathy Todt
MMIS Specialist
WellSpan Health
New Member
(5 points)
New Member
Posts:3


Send Message:

--
12/15/2015 2:15 PM

    For those that are using Lawson Clinical Bridge, how have you gotten item cost from Lawson over to your surgical systems (ie Cerner, Epic)?  What is your process? 

    Do you wait until a PO is issued to capture updated pricing and interface it over, or do you have a mechanism that interfaces cost over at the time the item is changed in Lawson which could be in advance of a PO being issued?

    Patricia Mane
    Systems Analyst II
    Private
    Basic Member
    (42 points)
    Basic Member
    Posts:22


    Send Message:

    --
    06/22/2016 12:19 PM
    We currently have an interface that send data over including pricing when an item is added as new, or updated. Based on that, not all items are updated, so we are having to determine a way to get pricing over when received, to ensure that Cerner/Surginet is updated timely for case reporting...
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (1831 points)
    Veteran Member
    Posts:625


    Send Message:

    --
    06/22/2016 1:59 PM
    It's not Clinical Bridge - we're using a sql through cloverleaf - and it's based on PO25.6 pricing, not last PO cost. There's no link patient to PO unless it's a bill only implant.
    JonA
    Private
    Private
    Veteran Member
    (2766 points)
    Veteran Member
    Posts:972


    Send Message:

    --
    07/07/2016 8:19 AM
    Kat, how do you handle items on multiple contracts?
    Jon Athey - Supply Chain Analyst - Materials Management - MidMichigan Health
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (1831 points)
    Veteran Member
    Posts:625


    Send Message:

    --
    07/07/2016 4:12 PM
    Benefits of being a taxing authority. We have one price for all locations. The only exception is Arthrex that charges more for bill only delivered - Epic gets the lower direct pricing per Corporate Finance. We do not charge the patient more for a facility choosing not to load a consignment.
    JonA
    Private
    Private
    Veteran Member
    (2766 points)
    Veteran Member
    Posts:972


    Send Message:

    --
    07/13/2016 12:59 PM
    So if you have a group of items on two different Arthrex contracts, how does the interface know which cost to pass to Epic? We've hit a roadblock with capitated pricing for total joints. We have hundreds implants on 2 different contracts for Depuy, Biomet and Smith & Nephew. On the capitated contract there is a cost for the implant "system" and the cost for the actual items are set at $0. The cost of the system is less than the aggregate cost of the implants used for the case. For revisions we have another contract with discounted pricing on each item. My SQL query currently does not pull pricing from the base cost in POVAGRMTLN but rather from last received cost in ITEMLOC. Most of our cases are total joint so the last cost will be $0 for most joint implants. I've thought about pulling cost from the contract but I don't know how to write the query so it would pull the cost from the correct contract for specific items.
    Jon Athey - Supply Chain Analyst - Materials Management - MidMichigan Health
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (1831 points)
    Veteran Member
    Posts:625


    Send Message:

    --
    07/18/2016 9:23 AM
    For capitated - there's an item built for the system - it's listed as an implant so the nurse in the room charts all the pieces. The individuals are there as well for revisions.

    How the nurses are trained when to pull the system vs list individuals is not something I was involved in, but per my counterpart in Epic, they aren't having too many issues.

    I don't know how I'd get the $0 system pricing off of yours other than putting the lines on hold? You have the system on the same PO25.6 - yes? You'd almost have to put that on a separate one and then put the old one on hold from PO25.1.
    JonA
    Private
    Private
    Veteran Member
    (2766 points)
    Veteran Member
    Posts:972


    Send Message:

    --
    07/19/2016 3:19 PM
    Our solution is to keep the non-capitated cost in a user field for these specific items and pass that to the interface which will use that field when populated, otherwise use last received cost. This means we'll have to manually update that field when the contract is updated. I don't like adding a manual process to this but unless contracts decides to stop using cap codes we're stuck.
    Jon Athey - Supply Chain Analyst - Materials Management - MidMichigan Health
    You are not authorized to post a reply.