porcvser.ItemGUID field shows 2000+ repeated values.
Question asked by Stan Paulauskas - 2/6/2023 at 8:36 AM
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? 

2 Replies

Reply to Thread
Terry Swiers Replied
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
Gotcha, so I need to stop thinking about this guy as a GUID on *this* table. Thanks!

Reply to Thread