Index: modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/patch-db/patch-pics.sql
===================================================================
--- modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/patch-db/patch-pics.sql (nonexistent)
+++ modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/patch-db/patch-pics.sql (revision 61029)
@@ -0,0 +1,16 @@
+BEGIN;
+-- Add constraint to FK
+ALTER TABLE dsm_organizationpids DROP CONSTRAINT dsm_organizationpids_pid_fkey;
+ALTER TABLE dsm_organizationpids ADD CONSTRAINT dsm_organizationpids_pid_fkey
+ FOREIGN KEY (pid) REFERENCES dsm_identities (pid)
+ ON UPDATE CASCADE;
+ -- Update
+ UPDATE dsm_identities
+ set pid = substring(pid,5)
+ where issuertype ='PIC';
+ -- Add original FK
+ ALTER TABLE dsm_organizationpids DROP CONSTRAINT dsm_organizationpids_pid_fkey;
+ ALTER TABLE dsm_organizationpids ADD CONSTRAINT dsm_organizationpids_pid_fkey
+ FOREIGN KEY (pid) REFERENCES dsm_identities (pid);
+COMMIT
+;
\ No newline at end of file
Index: modules/dnet-openaireplus-profiles/trunk/src/main/resources/eu/dnetlib/test/profiles/TransformationRuleDSResources/TransformationRuleDSResourceType/funders/corda_2_db.xml
===================================================================
--- modules/dnet-openaireplus-profiles/trunk/src/main/resources/eu/dnetlib/test/profiles/TransformationRuleDSResources/TransformationRuleDSResourceType/funders/corda_2_db.xml (revision 61028)
+++ modules/dnet-openaireplus-profiles/trunk/src/main/resources/eu/dnetlib/test/profiles/TransformationRuleDSResources/TransformationRuleDSResourceType/funders/corda_2_db.xml (revision 61029)
@@ -277,11 +277,11 @@
-
+
+ select="concat($organizationPIC, '@@PIC')"/>
Index: modules/dnet-openaireplus-profiles/trunk/src/main/resources/eu/dnetlib/test/profiles/TransformationRuleDSResources/TransformationRuleDSResourceType/funders/cordah2020_2_db.xml
===================================================================
--- modules/dnet-openaireplus-profiles/trunk/src/main/resources/eu/dnetlib/test/profiles/TransformationRuleDSResources/TransformationRuleDSResourceType/funders/cordah2020_2_db.xml (revision 61028)
+++ modules/dnet-openaireplus-profiles/trunk/src/main/resources/eu/dnetlib/test/profiles/TransformationRuleDSResources/TransformationRuleDSResourceType/funders/cordah2020_2_db.xml (revision 61029)
@@ -224,7 +224,7 @@
-
+