dwh-flat.txt 2.03 KB
Newer Older
1
patid	encounter	concept	type	value	units	start	end	provider	location	flag
2 3
#@meta(source.id)=test
#@meta(source.timestamp)=2015-04-21T08:58:00
4 5
#@meta(etl.strategy)=replace-source
# etl strategie: replace-source|replace-visit|insert
6 7 8 9 10
# fallid darf leer sein (nicht erlaubt bei replacevisit)
# dann wird pro patient ein neuer fall angelegt
# da die echte fallid nicht bertragen werden darf, kann der importer einen hash ber die echte id bilden
# etwa fallid -> crc16(fallid+lokales geheimnis)
# metainformation ber besondere felder
11 12 13 14 15 16 17
#@concept(patient.birthdate)=geb
#@concept(patient.deathdate)=gest
#@concept(patient.sex)=sex
#@concept(patient.surname)=psurname
#@concept(patient.names)=pnames
#@concept(visit)=visit
# bei besonderen Feldern darf start leer sein, dann wird meta(source.timestamp) verwendet.
18
# visit start, end, location, provider
19
# eav eintrge folgen
20 21 22 23 24 25
# patid	fallid	konzept	typ	wert	einheit	start	ende	provider	location	flag
XX12345	XXE12345	geb	dat	2001-01-01
XX12345	XXE12345	gest	dat	2020
XX12345	XXE12345	sex	str	F
XX12345	XXE12345	psurname	str	Dampf
XX12345	XXE12345	pnames	str	A B
26
XX12345	XXE12345	visit	@	@	@	2014-01-01T10:30:00	2014-01-05T10:30:00.123	xxxa	Zuhause
27
# normale werte
28
XX12345	XXE12345	T:date:secs	@	@	@	2014-09-07T10:40:03
29
XX12345	XXE12345	T:date:msec	@	@	@	2014-09-07T10:40:03.123
30 31 32 33 34
XX12345	XXE12345	T:date:mins	@	@	@	2014-09-07T10:40
XX12345	XXE12345	T:date:hours	@	@	@	2014-09-07T10
XX12345	XXE12345	T:date:day	@	@	@	2014-09-07
XX12345	XXE12345	T:date:month	@	@	@	2014-09
XX12345	XXE12345	T:date:year	@	@	@	2014
35 36 37 38
XX12345	XXE12345	T:type:str	str	abc123
XX12345	XXE12345	T:type:int	int	123
# value attributes can be used in elements eav-item and value -->
XX12345	XXE12345	T:type:dec	dec	123.456	mm	
39
XX12345	XXE12345	T:full	dec	123.456	mm	2010	2011	T:PROV	T:LOC	A
40
#  test group items
41
#@group(start)
rwm's avatar
rwm committed
42
XX12345	XXE12345	T:group:1	str	groupvalue
43
XX12345	XXE12345	T:mod:1	@
44
XX12345	XXE12345	T:mod:2	str	def456
45 46
XX12345	XXE12345	T:mod:3	dec	78.9	mm					A
#@group(end)
47 48 49 50
#@group(start)
XX12345	XXE12345	T:group:2	@
XX12345	XXE12345	T:mod:1	@
#@group(end)
51