1
|
SELECT
|
2
|
o.id AS organizationid,
|
3
|
o.legalshortname AS legalshortname,
|
4
|
o.legalname AS legalname,
|
5
|
o.websiteurl AS websiteurl,
|
6
|
o.logourl AS logourl,
|
7
|
o.ec_legalbody AS eclegalbody,
|
8
|
o.ec_legalperson AS eclegalperson,
|
9
|
o.ec_nonprofit AS ecnonprofit,
|
10
|
o.ec_researchorganization AS ecresearchorganization,
|
11
|
o.ec_highereducation AS echighereducation,
|
12
|
o.ec_internationalorganizationeurinterests AS ecinternationalorganizationeurinterests,
|
13
|
o.ec_internationalorganization AS ecinternationalorganization,
|
14
|
o.ec_enterprise AS ecenterprise,
|
15
|
o.ec_smevalidated AS ecsmevalidated,
|
16
|
o.ec_nutscode AS ecnutscode,
|
17
|
o.dateofcollection AS dateofcollection,
|
18
|
o.lastupdate AS dateoftransformation,
|
19
|
false AS inferred,
|
20
|
false AS deletedbyinference,
|
21
|
o.trust AS trust,
|
22
|
'' AS inferenceprovenance,
|
23
|
d.id AS collectedfromid,
|
24
|
d.officialname AS collectedfromname,
|
25
|
|
26
|
o.country || '@@@dnet:countries' AS country,
|
27
|
'sysimport:crosswalk:entityregistry@@@sysimport:crosswalk:entityregistry@@@dnet:provenance_actions@@@dnet:provenance_actions' AS provenanceaction,
|
28
|
|
29
|
ARRAY[]::text[] AS pid
|
30
|
FROM dsm_organizations o
|
31
|
LEFT OUTER JOIN dsm_datasources d ON (d.id = o.collectedfrom)
|
32
|
|
33
|
|
34
|
|
35
|
|
36
|
|