select  'hr#'||substr(t.private_identity_id,length(t.private_identity_id)-5,6) from isc_user t
where t.private_identity_id is not null