Storage of UNSPSC and/or HCPCS Codes

Hi,

We are interested in finding out what other facilities are currenlty utilizing UNSPSC codes and/or HCPCS codes within Lawson and where you are storing that information.

Feel free to contact me with questions

Thanks!
John

[Updated on 1/23/2015 11:30 AM]

Find more posts tagged with

Infor Lawson Supply Chain Group - Discussion

Comments

Legacy Contributor

We are recording HCPCs code and an Epic ID code (combines a billing code and HCPCS ie: TC272A4649) on IC11 user fields. The field used to record the Epic ID is mapped to interface to Epic OpTime and HB.

Legacy Contributor

Thanks!

How is the Epic ID code mapped to OpTime? Is it a script you run, or is Epic able to integrate that through each system?

0911060553270289.pdf

Legacy Contributor

An HL7 Item Master ZZ528 job is run late each day, an interface script or job then follows to move the item master data file to Epic.

VISUAL Roadmap - July 2020-Seminar Series.pdf

Legacy Contributor

Great, thanks again!! Very helpful

Legacy Contributor

We store the UNSPSC in the item master in the class tab. We don't store the HCPCS but we do put the epic eap and it's associated lawson item(s) in PC10.

We interface to Optime, Cupid and Radiant with a custom sql that Cloverleaf makes an HL7 compliant file. (This lets us do things like map the generic noun as Supply Type/Implant Type, etc)

jreese

Kat,
Does your custom SQL program pass the entire item master each time or does it just pass changes and new items similar to the IC527 program in Lawson? We currently use a modified version of the IC527 program to pass the item master changes to EPIC, but if I could find another solution I would like to get rid of this program which is the only modification we have to any of the Cobol programs in Lawson.

221201 presentation complete.pdf

Legacy Contributor

The query grabs all item master items that are in the Epic IC12 locations. I believe it's Cloverleaf that looks at the record and determines if it is (A) New, (B) Change or (C) No Change from the previous night's file and then processes the record accordingly. But they may be passing all records along.

I can share the SQL if needed, you can reach me at kvila@mhs.net

[Updated on 1/26/2015 5:12 PM]

jreese

Is there any chance of getting a copy of your SQL query?

0904200117254579.pdf

Legacy Contributor

HA. Just edited my response. Yes - email me at kvila@mhs.net and I can share.

Copyright © 2025 Infor. All rights reserved.