Project

General

Profile

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 || '@@@' || o.country || '@@@dnet:countries@@@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

    
(6-6/9)