Familiarity with the CarteGraph application may not be necessary to answer this question. The CarteGraph application is largely constructed on VBS and C#. It fronts on a SQL Server or Oracle database. The database typically contains 200 plus tables. Each table contains a primary key field that is NOT and identity column. Instead, it appears that the the front end application populates the primary key field. I'm trying to figure out how it does so. I've attached a spreadsheet that provides a day's sample of data into one table ("signEvents"). The data is sorted by time of entry. The values in the signEventsOID appear to be random. However, the signEventsOID column contains values with only 9 digits. With the table itself containing over 100,000 rows, it seems to me that a purely random number 9 digit number in a 100,000 row table might result in duplicate primary key values.
I'm looking for some insight in how these numbers might be generated. I've spent several hours poking around the VBS modules looking for the code that produces the primary key values. I've struck out.