It all ends up in the EHR, which is a legal document and considered THE source of truth about a patient’s care. Without seeing you hospital IT system I can guess with pretty high certainty that you are getting manufacturer info and model number, and very sparse coverage off lot number.

The problem is that this is not enough to unambiguously resolve the identity of devices across databases, or even within the same database at different time points.

For example, mapping between model number and UDI is often one to many. Model numbers might be omitted or mutated across databases and time. Manufacturer and device names are most definitely mutated. Overall it is a nightmare of an entity resolution problem.