Eucaim-template.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	tableName	tableExtends	tableType	columnName	columnType	key	required	refSchema	refTable	refLink	refBack	refLabel	defaultValue	validation	visible	computed	semantics	profiles	label	description
2	body_parts																			Body Parts(SNOMED-CT)
3	disease_types																			Conditions (SNOMED-CT)
4	persons																http://xmlns.com/foaf/0.1/Person			List of contact persons
5	networks																http://www.w3.org/ns/dcat#Catalog			Overview of networks
6	biobanks																http://www.w3.org/ns/dcat#DatasetSeries			Overview of imaging biobanks
7	topography																			Topography (ICD-O-3)
8	collections																http://www.w3.org/ns/dcat#Dataset			Overview of imaging collections in biobanks
9	biobanks			id		1	true					FALSE					http://purl.org/dc/terms/identifier		Id	Unique biobank ID
10	biobanks			name			TRUE										http://purl.org/dc/terms/title		Name	Name of the biobank.Textual string of letters denoting the name of the biobank in English [MIABIS-2.0-03]
11	biobanks			acronym													http://purl.org/dc/terms/alternative		Acronym	Biobank acronym. Textual string of short name in use for the biobank. If applicable [MIABIS-2.0-02]
12	biobanks			description	text												http://purl.org/dc/terms/description		Description	General description of the biobank. Textual string of letters with a description about the biobank in English. [MIABIS-2.0-08]
13	biobanks			url	hyperlink												http://www.w3.org/ns/dcat#landingPage		URL	Web address of the biobank. Textual string of letters with the complete http-address for the biobank [MIABIS-2.0-04]
14	biobanks			geographical_coverage	ontology		TRUE		countries			${label}					http://purl.org/dc/terms/spatial		Geographical coverage	Country hosting the biobank according to MIABIS 2.0 - MIABIS-2.0-06.
15	biobanks			juridical_person			TRUE										http://purl.org/dc/terms/publisher		Juridical person	Juristic person of the biobank. Textual string of letters denoting the juristic person e.g. a university, concern, county council etc. for the biobank [MIABIS-2.0-05]
16	biobanks			contact	ref				persons			${first_name} ${last_name}					http://www.w3.org/ns/dcat#contactPoint		Contact	Reference to a contact ID.
17	biobanks			head	ref				persons			${first_name} ${last_name}							Head	Person in charge of the biobank.
18	biobanks			role															Role of head	Official role of the person in charge of the biobank, e.g. PI or Director
19	biobanks			collections	refback				collections		biobank	${name}					http://purl.org/dc/terms/relation		Collections
20	biobanks			network	ref_array				networks			${name}					http://purl.org/dc/terms/relation		Provider
21	biobanks			withdrawn	bool		TRUE						FALSE						Withdrawn	Indicates if the biobank is withdrawn.
22	body_parts			order	int		FALSE													Order of this term within the code system.
23	body_parts			name		1	true													Unique name of the term within this table.
24	body_parts			label			FALSE													User-friendly label for this term. Should be unique in parent.
25	body_parts			parent	ref_array		FALSE		body_parts											The parent term(s), in case this code exists in a hierarchy.
26	body_parts			codesystem			FALSE													Abbreviation of the code system/ontology this term belongs to.
27	body_parts			code			FALSE													Identifier used for this term within this code system/ontology.
28	body_parts			ontologyTermURI	hyperlink		FALSE													Reference to structured definition of this term.
29	body_parts			definition	text		FALSE													A concise explanation of the meaning of this term.
30	body_parts			children	refback		FALSE		body_parts		parent									Child terms, in case this term is the parent of other terms.
31	body_parts			exact_mapping	ref_array		FALSE		body_parts										Exact matching code(s)	Matching code(s) from another ontology with exact mapping: the two concepts are equivalent.
32	body_parts			btnt_mapping	ref_array		FALSE		body_parts										BTNT matching code(s)	Matching code(s) from another ontology with broader to narrow term mapping: the code is broader than the targeted code used to represent it.
33	body_parts			ntbt_mapping	ref_array		FALSE		body_parts										NTBT matching code(s)	Matching code(s) from another ontology with narrow to broader term mapping: the code is narrower than the targeted code used to represent it.
34	collections			id		1	true					FALSE					http://purl.org/dc/terms/identifier		id	Unique collection ID.
35	collections			name			TRUE										http://purl.org/dc/terms/title		Collection name	Name of the image collection [MIABIS-2.0-03]
36	collections			acronym													http://purl.org/dc/terms/alternative		Collection acronym	Image collection acronym [MIABIS-2.0-02]
37	collections			description	text												http://purl.org/dc/terms/description		Description	Description of the image collection [MIABIS-2.0-08]. It should include country, year when the images were taken, type of disease, and if it is oncology related.
38	collections			biobank	ref		TRUE		biobanks			${name}					http://www.w3.org/ns/dcat#inSeries		Biobank	Reference to a biobank ID, to which the collection belongs.
39	collections			biobank_label															Biobank label
40	collections			network	ref_array				networks			${name}					http://purl.org/dc/terms/relation		Provider
41	collections			provider			TRUE										http://purl.org/dc/terms/publisher		Provider	Provider of the collection.
42	collections			publisherType			TRUE										https://healthdcat-ap.github.io/#healthdcatappublishertype		Provider Type	Type of organisation that makes the dataset avaiable.
43	collections			format	text		TRUE										http://purl.org/dc/terms/format		Data Format	The file format of the data included in the dataset
44	collections			sample	text												https://www.w3.org/TR/vocab-adms/#adms-sample		Data Sample	A sample distribution of the dataset
45	collections			parent_collection	ref				collections			${name}					http://purl.org/dc/terms/relation		Parent collection	Reference to a collection ID, refers to the superior collection (if applicable).
46	collections			head	ref				persons			${first_name} ${last_name}							Head	Person in charge of the collection.
47	collections			contact	ref				persons			${first_name} ${last_name}					http://www.w3.org/ns/dcat#contactPoint		Contact	Reference to a contact ID.
48	collections			order_of_magnitude	ontology		TRUE		biobank_size			${label}							Order of magnitude	Size of the collection measured as 10n subjects
49	collections			number_of_subjects	int												http://www.healthdcatap.org/numberofUniqueIndividuals		Number of subjects	Number of subjects whose images populate the collection
50	collections			number_of_studies	int												http://www.healthdcatap.org/numberofRecords		Number of studies	Number of subjects whose images populate the collection
51	collections			number_of_series	int												https:/www.eucaim.org/nbrofSeries		Number of series	Number of subjects whose images populate the collection
52	collections			body_part_examined	ontology_array				body_parts			${label}					https:/www.eucaim.org/hasImageBodyPart		Body part	The examined body part(s).
53	collections			condition	ontology_array				disease_types			${label}					https:/www.eucaim.org/hasCondition		Condition	Diagnosis available in the collection, with the ontology prefix - MIABIS-2.0-17, adapted.
54	collections			topography	ontology_array				topography			${label}							Topography	Specification of Anatomical site
55	collections			imaging_modality	ontology_array		TRUE		imaging_modality			${label}					https:/www.eucaim.org/hasImageModality		Imaging modality	The imaging modality/modalities.
56	collections			vendor	ontology_array				vendor			${label}					https:/www.eucaim.org/hasImageVendor		Vendor	Manufacturer of the imaging device. DICOM tag (0008,0070)
57	collections			image_year_range	text														Image year range	Year range when the images where produced (e.g. 2010 - present)
58	collections			image_size															Image size (GB)	Storage size of the imaging data.
59	collections			sex	ontology_array				sex			${label}					https:/www.eucaim.org/hasAssociatedSex		Sex
60	collections			geographical_coverage	ontology		TRUE		countries			${label}					http://purl.org/dc/terms/spatial		Geographical coverage	Country according to MIABIS 2.0 - MIABIS-2.0-07-H.
61	collections			age_high	int												http://www.healthdcatap.org/maxTypicalAge		Age, high	Highest age of the subjects in the collection
62	collections			age_low	int												http://www.healthdcatap.org/minTypicalAge		Age, low	Lowest age of the subjects in the collection
63	collections			age_median													https:/www.eucaim.org/ageMedian		Age, median	Median age of the subjects in the collection
64	collections			type	ontology_array		TRUE		data_types			${label}					http://purl.org/dc/terms/type		Dataset type	Denotes which imaging dataset types are available (e.g raw, annnotated or processed)
65	collections			theme	ontology_array				themes			${label}					http://www.w3.org/ns/dcat#theme		Theme	theme i.e. always http://publications.europa.eu/resource/authority/data-theme/HEAL
66	collections			interoperability_tier	ontology				tier			${label}					http://www.w3.org/ns/adms#interoperabilityLevel		Interoperability Tier
67	collections			collection_method	ontology_array		TRUE		collection_types			${label}					http://www.healthdcatap.org/healthCategory		Collection method	Type(s) of collection (e.g. Cohort, disease specific, population bases, other)
68	collections			provenance	text												http://purl.org/dc/terms/provenance		Provenance	A statement about the lineage of a Dataset.
69	collections			intended_purpose	text		TRUE										https://w3id.org/dpv/dpv-skos#hasPurpose		Intended purpose	The intended purpose of the collection
70	collections			terms_of_use	ontology_array				terms_of_use			${label}							Terms of use	Terms of use according to the Data Use Ontology
71	collections			commercial_use	bool														Available for commercial use	Can commercial users request access to samples and/or data
72	collections			image_access_type	ontology_array		TRUE		image_access_type			${label}							Image access type	Image access type
73	collections			image_access_description	text														Image access description	Short description of access rules.
74	collections			image_access_fee	bool														Image access fee	Denotes whether access to images may be obtained on fee-based basis.
75	collections			image_access_uri	hyperlink														Image access URI	URI describing access policy for the images.
76	collections			non_image_data_access_uri	hyperlink														Non image data access uri	URL where the non imaging data can be found/requested (if applicable)
77	collections			publication_uri	hyperlink														Publication URI	URI where the publication is available (paper describing the imaging collection)
78	collections			applicable_legislation	text												http://data.europa.eu/r5r/applicableLegislation		Applicable legislation	This property refers to an entity (organisation) responsible for making the Dataset available
79	collections			legal_basis	text												https://w3id.org/dpv/dpv-skos#hasLegalBasis		Legal basis	The legal basis used to justify processing of personal data
80	collections			retention_period	text												http://www.healthdcatap.org/retentionPeriod		Retention period	A temporal period which the dataset is available for secondary use.
81	collections			rights	ontology				rights			${label}					http://purl.org/dc/terms/rights		Rights
82	collections			health_data_access_body	ontology				hdab			${label}							Health Data Access Body
83	collections			quality_label	text												http://www.w3.org/ns/dqv#hasQualityAnnotation		Quality label	This property refers to a quality and utility label as defined by the QUANTUM health data quality framework.
84	collections			coding_systems	ontology_array				coding_systems			${label}					http://www.healthdcatap.org/hasCodingSystem		Coding system	Coding systems in use (ex: ICD-10-CM, DGRs, SNOMED=CT, ...). Wikidata URIs MUST be used.
85	collections			metadata_issued	date														Date metadata issued	Created date of the dataset entry
86	collections			last_modified	date												http://purl.org/dc/terms/modified		Date last modified	Most recent date on which the dataset was changed, updated or modified
87	collections			version													http://www.w3.org/ns/dcat#version		Version	Version of the collection
88	collections			withdrawn	bool		TRUE						FALSE						Withdrawn	Indicates if the collection is withdrawn.
89	disease_types			order	int		FALSE													Order of this term within the code system.
90	disease_types			name		1	true													Unique name of the term within this table.
91	disease_types			label			FALSE													User-friendly label for this term. Should be unique in parent.
92	disease_types			parent	ref_array		FALSE		disease_types											The parent term(s), in case this code exists in a hierarchy.
93	disease_types			codesystem			FALSE													Abbreviation of the code system/ontology this term belongs to.
94	disease_types			code			FALSE													Identifier used for this term within this code system/ontology.
95	disease_types			ontologyTermURI	hyperlink		FALSE													Reference to structured definition of this term.
96	disease_types			definition	text		FALSE													A concise explanation of the meaning of this term.
97	disease_types			children	refback		FALSE		disease_types		parent									Child terms, in case this term is the parent of other terms.
98	disease_types			exact_mapping	ref_array		FALSE		disease_types										Exact matching code(s)	Matching code(s) from another ontology with exact mapping: the two concepts are equivalent.
99	disease_types			btnt_mapping	ref_array		FALSE		disease_types										BTNT matching code(s)	Matching code(s) from another ontology with broader to narrow term mapping: the code is broader than the targeted code used to represent it.
100	disease_types			ntbt_mapping	ref_array		FALSE		disease_types										NTBT matching code(s)	Matching code(s) from another ontology with narrow to broader term mapping: the code is narrower than the targeted code used to represent it.