Identifier source/provenance in SQL Provisioner

Suggestion: Add identifier source details to sp_identifiers.

Right now SQL Provisioner is basically giving us this for sp_identifiers:

select id, co_person_id, identifier, type, login, status, created, modified from cm_identifiers where co_person_id=XXXX;

I think it would be useful to track the source/provenance of identifiers. For example, the UI  displays badges to indicate the source of an identifier in a person record. Our primary use case is org identity source, but department / group / organization could be useful for other users.

Something like this would be useful:

select
cmi1.id, cmi1.co_person_id, cmi1.identifier, cmi1.type,
cmi2.co_department_id, cmi2.co_group_id, cmi2.organization_id,
oisr.org_identity_source_id, ois.description as org_identity_source_description,
cmi1.login, cmi1.status,
cmi1.created, cmi1.modified
from cm_identifiers cmi1
left outer join cm_identifiers cmi2 on cmi1.source_identifier_id=cmi2.id
left outer join cm_org_identities oid on oid.id=cmi2.org_identity_id
left outer join cm_org_identity_source_records oisr on oisr.org_identity_id = oid.id
left outer join cm_org_identity_sources ois on oisr.org_identity_source_id=ois.id
where
cmi1.co_person_id = XXXX;