Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 RE7RECORDID int   The old ID value from the BANK table

Foreign Key Field Type Null Notes Description
 ID uniqueidentifier   FINANCIALINSTITUTION.ID The new guid-based ID value

Index Name Field(s) Unique Primary Clustered
 PK_RE7MAPBANK ID  
 UIX_RE7MAPBANK_RE7RECORDID RE7RECORDID  

Entity-Relationship diagram of this table