porcvser.ItemGUID field shows 2000+ repeated values.

I'm reviewing data quality for porcvser.ItemGUID field. I expect that these fields be unique. I've found that this field contains 2589 repeated GUIDs. I provide a sample of them below, along with their counts. As you can see, some of them are repeated over 100 times.

Question: Am I not understanding the purpose of this field properly? Is this GUID supposed to be a foreign key to another table?

Terry Swiers Replied

2/6/2023 at 11:30 AM

Employee Post Marked As Answer

Is this GUID supposed to be a foreign key to another table?

Yes. It is a reference back to the owning record ItemGUID on the porcv table. So if you receive 100 serial number for an item, you will have 100 entries in the porcvser table with the same ItemGUID reference

Stan Paulauskas Replied

2/6/2023 at 2:14 PM

Gotcha, so I need to stop thinking about this guy as a GUID on *this* table. Thanks!

2 Replies

Reply to Thread

Related Knowledge Base Articles