> Conceptually, any information created or consumed outside your organization is not valid as part of a surrogate key, so SSNs are not a surrogate key.
SSNs are created within the organization. Maybe not within your organization, but nobody is talking about you. They are a surrogate key.
SSNs are created within the organization. Maybe not within your organization, but nobody is talking about you. They are a surrogate key.