The MET/TEAM database schema was changed from using decimal identifiers to a globally unique identifier (GUID) in version 2.2. The new column type is [uniqueidentifier], which can be converted to a 36 character string value. As a result, records referenced by their UID in your data checks will need to be updated.
To assist with this conversion, the converted MET/TEAM 2.2 database contains a set of lookup tables, which are named Guid_<xyz>, where <xyz> is the name of the originating table. For example, to find the GUID for a given decimal reference for nUserUID, look it up in the table called Guid_Users.
Related Topics