A surrogate key is a single-part, artificially established identifier for an entity. Surrogate key assignment is a special case of derived data––one where the primary key is derived. A common way of deriving surrogate key values is to assign integer values sequentially.
