source: ruby/trunk/terminology/db/development.sqlite3@ 164

Last change on this file since 164 was 164, checked in by KOBAYASHI, Shinji, 15 years ago

simple terminology commit

  • Property svn:mime-type set to application/octet-stream
File size: 28.0 KB
Line 
1SQLite format 3@
2*|*P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)ƒ''…
3GtableterminologiesterminologiesCREATE TABLE "terminologies" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "code" varchar(255) DEFAULT NULL NULL, "name" varchar(255) DEFAULT NULL NULL, "lang" varchar(255) DEFAULT NULL NULL, "group" text DEFAULT NULL NULL, "rubric" varchar(255) DEFAULT NULL NULL, "description" text DEFAULT NULL NULL, "mappings" varchar(255) DEFAULT NULL NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)
4îî)20090725052538
5íí)20090725052538Š
6ûöñìçâÝØÓÎÉÄ¿º´®¨¢œ–Š relationshipbrotherRelationship of brother to subject of EHR HL7: CEN: {
75)!22openehrensubject relationshippartner/spouseThe husband or wife or life partner of the subject of EHR HL7: CEN: f 5i!10openehrensubject relationshipmotherThe party is the mother of the subject of EHR HL7: CEN: i 5q!9openehrensubject relationshipfatherThe party is the father of the subject of the EHR HL7: CEN: | 55{!8openehrensubject relationshipmaternal grandfatherRelationship of maternal grandfather to subject of EHR HL7: CEN: | 55{!7openehrensubject relationshipmaternal grandmotherRelationship of maternal grandmother to subject of EHR HL7: CEN: 
85!!6openehrensubject relationshipdonorThe party is a donor of organs or other body products to the EHR subject. HL7: CEN: M 59!3openehrensubject relationshipfoetusThe party i?82-&
9{g\UMF
10@
118
122
13+ %
14ìì'terminologiesÀ
15 ŸPÌNÐeý€c 5a!23openehrensubject relationshipbrotherRelationship of brother to subject of EHR HL7: CEN: {
165)!22openehrensubject relationshippartner/spouseThe husband or wife or life partner of the subject of EHR HL7: CEN: f 5i!10openehrensubject relationshipmotherThe party is the mother of the subject of EHR HL7: CEN: i 5q!9openehrensubject relationshipfatherThe party is the father of the subject of the EHR HL7: CEN: | 55{!8openehrensubject relationshipmaternal grandfatherRelationship of maternal grandfather to subject of EHR HL7: CEN: | 55{!7openehrensubject relationshipmaternal grandmotherRelationship of maternal grandmother to subject of EHR HL7: CEN: 
175!!6openehrensubject relationshipdonorThe party is a donor of organs or other body products to the EHR subject. HL7: CEN: M 59!3openehrensubject relationshipfoetusThe party is a foetus HL7: CEN: _ 5M50openehrensubject relationshipselfThe party is the subject of EHR HL7_RoleCode:: CEN:
18 
19¡<Ût™} 55{!37openehrensubject relationshippaternal grandmotherRelationship of paternal grandmother to subject of EHR HL7: CEN: | 55y!36openehrensubject relationshippaternal grandfatherRelationship of aternal grandfather to subject of EHR HL7: CEN: [ 5Y!31openehrensubject relationshipsonRelationship of son to subject of EHR HL7: CEN: e 5
20c!29openehrensubject relationshipdaughterRelationship of daughter to subject of EHR HL7: CEN: _ 5]!28openehrensubject relationshipchildRelationship of child to subject of EHR HL7: CEN: c
21 5a!27openehrensubject relationshipsiblingRelationship of sibling to subject of EHR HL7: CEN: {
22 53y!26openehrensubject relationshipstep or half sisterRelationship of step or half sister to subject of EHR HL7: CEN: }
23 55{!25openehrensubject relationshipstep or half brotherRelationship of step or half brother to subject of EHR HL7: CEN: a
24 5_!24openehrensubject relationshipsisterRelationship of sister to subject of EHR HL7: CEN:
25
26©8™sM%Ù¨}Y3$
27
28
29129openehrenpropertyVolume "
30
31
32128openehrenpropertyTime )
33
34%
35
36127openehrenpropertyTemperature /
37
381
39
40126openehrenpropertyFlow rate volume &
41
42
43
44125openehrenpropertyPressure "
45
46
47124openehrenpropertyMass &
48
49
50123openehrenpropertyLoudness $
51
52
53122openehrenpropertyLength $
54
55
56121openehrenpropertyEnergy 
57
583g
5945openehrenevent math functionminimumValue of the interval-event is the minimum value of the discrete events which the interval-event summarises. o 5'm!41openehrensubject relationshippaternal auntRelationship of paternal aunt to subject of EHR HL7: CEN: q 5)o!40openehrensubject relationshippaternal uncleRelationship of paternal uncle to subject of EHR HL7: CEN: o 5'm!39openehrensubject relationshipmaternal auntRelationship of maternal aunt to subject of EHR HL7: CEN: q 5)o!38openehrensubject relationshipmaternal uncleRelationship of maternal uncle to subject of EHR HL7: CEN:
60,Ü<Ÿ
61,[%
623‚g
63148openehrenevent math functiontotalValue of the interval-event is the sum of the values of the discrete events which the interval-event summarises (typically differential flow measurements e.g. blood loss). $
643S
65147openehrenevent math functionchangeValue of the interval-event is the net change over the period which the interval-event summarises. #
663g
67146openehrenevent math functionmeanValue of the interval-event is the average value of the discrete events which the interval-event summarises. 
68"
693g
70144openehrenevent math functionmaximumValue of the interval-event is the maximum value of the discrete events which the interval-event summarises. "!
71
72
73130openehrenpropertyWork
74W©6ÐWÚW+ 1ge
75195openehrenparticipation modelive audiovisual; videoconference; videophoneAny audio-visual communication in real time {* 1]e
76194openehrenparticipation modeasynchronous audiovisual; recorded videoAudio-visual communication that is not live w)
771'
78193openehrenparticipation modenot specifiedMode of participation is not specified; use only for legacy data. d( 5a!189openehrensubject relationshipneonateRelationship of neonate to subject of EHR HL7: CEN: q'
79
80166openehrenInstruction transitionscancelCancel a planned Instruction before it is booked or started. ‚T&
813„Q
82149openehrenevent math functionvariationValue of the interval-event is difference between the point maximum and point minimum over the period in other words the value band into which all sample during a period fit. Useful for specifying a maximal allowed variation in a datum to still be considered the same (approximate) value.
83…
84¬Y­,…
85
8632
871Si202openehrenparticipation modelive audio-only; telephone; internet phone; teleconferenceAny live audio-only communication. HL7_ParticipationMode::V16544 (includes live) H1 1!;
88201openehrenparticipation modevoice-mailAudio messaging system $0
891
90;G200openehrenparticipation modedictatedNon-interactive audio-only information recorded on some medium such as cassette tape. HL7_ParticipationMode::16547 / 1gc
91199openehrenparticipation modeasynchronous audio-only; dictated; voice mailAudio-only communication that is not live. ).
921/3G198openehrenparticipation modevideoconferencingLive audio-visual communication over videoconferencing or other similar equipment. HL7_ParticipationMode::16548 Q- 1!M
93197openehrenparticipation modevideophoneLive audio-visual communication R, 1)G
94196openehrenparticipation moderecorded videoRecorded video or video mail
95e}õz ùe8
961/G208openehrenparticipation modefacsimile/telefaxNon-interactive written communication using a fax machine. HL7_ParticipationMode::16552 $7
971M;207openehrenparticipation modeemailWritten communication by email. HL7_ParticipationMode::16553 [ inlcude HL7_ParticipationMode::16554 (electronic data)] W6
981%I206openehrenparticipation modeasynchronous text; email; fax; letter; handwritten note; SMS messageAny text-only communication including email written text SMS message etc. HL7_ParticipationMode::V16549 y5 1eG205openehrenparticipation modetelephoneLive verbal communication over a telephone. HL7_ParticipationMode::16546 4 11kG204openehrenparticipation modeinternet telephoneLive verbal communication over a the internet. HL7_ParticipationMode::16546 3 1)iG203openehrenparticipation modeteleconferenceLive verbal communication over teleconference HL7_ParticipationMode::16546
99¨
100˜
101¦Jº
102@
1031A G216openehrenparticipation modeface-to-face communicationFace to face communications between parties in the same room. HL7_ParticipationMode::16545 
104? 1=oG215openehrenparticipation modeinteractive written noteLive text-only communication using written notes HL7_ParticipationMode::16550 Z> 1
105c
106214openehrenparticipation modeSMS chatLive text-only chat over mobile/cell phone c= 1'k
107213openehrenparticipation modeinternet chatLive text-only communication over the internet 
108<
1091O
110212openehrenparticipation modelive text-only; internet chat; SMS chat; interactive written noteAny live text-only communication ; 1-kG211openehrenparticipation modehandwritten noteWritten communication by handwritten document. HL7_ParticipationMode::16550 : 15kG210openehrenparticipation modeprinted/typed letterWritten communication by typewritten document. HL7_ParticipationMode::16551 V9 1#U
111209openehrenparticipation modeSMS messageMessages sent via mobile/cell phone
112buœb#F 19}i222openehrenparticipation modeinterpreted audio-onlyAny live audio-only communication using an interpreter. HL7_ParticipationMode::V16544 (includes live) E
1131+I221openehrenparticipation modetranslated textNon-interactive written communication requiring translation HL7_ParticipationMode::V16549 VD
1141/‚
115G220openehrenparticipation modephysically remoteParticipation by actions where the participant is not physically present and the actions are transmitted by electronic means. HL7_ParticipationMode::16557 
116C
11711G219openehrenparticipation modephysically presentParticipation by actions where the participant is physically present. HL7_ParticipationMode::16556 gB 11i
118218openehrenparticipation modesigning over videoLive video communication using sign language. A
11917
120217openehrenparticipation modesigning (face-toface)Live face-to-face communication using a recognised sign language.
121‚BÁ3Ðxô‚pM /%m)251openehrenaudit change typemodificationChange type was update of the previous version. HL7_CDA: CEN: L
122/)250openehrenaudit change typeamendmentChange type was amendment i.e. correction of the previous version. HL7_CDA: CEN: VK /
123A)249openehrenaudit change typecreationChange type was creation. HL7_CDA: CEN: aJ ;k
124245openehrenInstruction transitionsactiveThe instruction is currently being carried out 
125I
1261Q240openehrenattestation reasonsignedThe attested information has been signed by its signatory. HL7_ParticipationSignature::10284 H 1K
127224openehrenparticipation modeinterpreted video communicationLive audio-visual communication involving an interpreter ;G
1281W/G223openehrenparticipation modeinterpreted face-toface communicationFace to face communications between parties in the same room with an interpreter HL7_ParticipationMode::16545
129G^3½GtU 5+q!259openehrensubject relationshipadoptive fatherRelationship of adoptive father to subject of EHR HL7: CEN: tT 5+q!258openehrensubject relationshipadoptive motherRelationship of adoptive mother to subject of EHR HL7: CEN: bS 5_!257openehrensubject relationshipcousinRelationship of cousin to subject of EHR HL7: CEN: xR 5/u!256openehrensubject relationshipbiological fatherRelationship of biological father to subject of EHR HL7: CEN: xQ 5/u!255openehrensubject relationshipbiological motherRelationship of biological mother to subject of EHR HL7: CEN: bP 5_!254openehrensubject relationshipparentRelationship of parent to subject of EHR HL7: CEN: mO 'g;253openehrennull flavoursunknownA possible value exists but is not provided. HL7_NullFlavor::V10612 N
130/O)252openehrenaudit change typesynthesisChange type was creation synthesis of data due to conversion process typically a data importer. HL7_CDA: CEN:
131Ғ¬>×{ҁ&\
1323
133267openehrenevent math functionmodeValue of the interval-event is the modal (most common) value of the discrete events which the interval-event summarises. Z[ 5I!265openehrensubject relationshipcohabiteeLives with the subject of EHR HL7: CEN: eZ 5
134a!264openehrensubject relationshipguardianRelationship of guardianto subject of EHR HL7: CEN: lY 5#i!263openehrensubject relationshipstep fatherRelationship of step father to subject of EHR HL7: CEN: lX 5#i!262openehrensubject relationshipstep motherRelationship of step mother to subject of EHR HL7: CEN: vW 5-s!261openehrensubject relationshipadopted daughterRelationship of adopted daughter to subject of EHR HL7: CEN: lV 5#i!260openehrensubject relationshipadopted sonRelationship of adopted son to subject of EHR HL7: CEN:
135
136OBkò€N*ûË£wO&g
137
138
139340openehrenpropertyMomentum *f
140'
141
142339openehrenpropertyAcceleration &e
143
144
145338openehrenpropertyVelocity .d
146/
147
148337openehrenpropertySpecific surface -c
149-
150
151336openehrenpropertySpecific volume "b
152
153
154335openehrenpropertyArea 0a
1553
156
157334openehrenpropertyElectrical current p` ')a9273openehrennull flavoursnot applicableNo valid value exists for this data item. HL7_NullFlavor::10611 w_ '9272openehrennull flavoursmaskedThe value has not been provided due to privacy settings. HL7_NullFlavor::17932 T^
158')‚%;271openehrennull flavoursno informationNo information provided; nothing can be inferred as to the reason why including whether there might be a possible applicable value or not. HL7_NullFlavor::V10610 ;]
1593‚%
160268openehrenevent math functionmedianValue of the interval-event is the median (centre value in sorted series) value of the discrete events which the interval-event summarises.
161AϚi5ΟuH!붑b7ӞoA,{
162+
163
164366openehrenpropertyEnergy density -z
165-
166
167365openehrenpropertyEnergy per area 3y
1689
169
170362openehrenpropertyDiffusion coefficient 1x
1715
172
173361openehrenpropertyVelocity kinematic /w
1741
175
176360openehrenpropertyVelocity dynamic )v
177%
178
179357openehrenpropertyForce body -u
180-
181
182356openehrenpropertySurface tension #t
183
184
185355openehrenpropertyForce 3s
1869
187
188352openehrenpropertyFlow rate mass/force 4r
189;
190
191351openehrenpropertyFlow rate mass/volume %q
192
193
194
195350openehrenpropertyDensity +p
196)
197
198349openehrenpropertyMass per area (o
199#
200
201348openehrenpropertyFlux mass -n
202-
203
204347openehrenpropertyFlow rate mass 1m
2055
206
207346openehrenpropertyMomentum flow rate 2l
2087
209
210345openehrenpropertyMoment inertia mass 2k
2117
212
213344openehrenpropertyMoment inertia area /j
2141
215
216343openehrenpropertyMomentum angular 3i
2179
218
219342openehrenpropertyAcceleration angular /h
2201
221
222341openehrenpropertyVelocity angular
223QÓ©|Mؤy?æÿÓ©{Q'
224
225!
226
227385openehrenpropertyMass (IU) +
228
229)
230
231384openehrenpropertyAmount (mole) '
232!
233
234382openehrenpropertyFrequency )
235%
236
237381openehrenpropertyAmount (Eq) c
238
239+‚y
240380openehrenpropertyQualified real This is a number with an arithmetic qualification (which may be no units 103 etc) allowing integers to be expressed as reals raised to a nominated power or for real numbers alone. (
241#
242
243379openehrenpropertyInductance +
244)
245
246378openehrenpropertyMagnetic flux 7
247A
248
249377openehrenpropertyElectrical field strength (
250#
251
252375openehrenpropertyResistance 1
2535
254
255374openehrenpropertyVoltage electrical 7
256A
257
258373openehrenpropertyHeat transfer coefficient 8
259C
260
261371openehrenpropertySpecific heat gas content -
262-
263
264370openehrenpropertySpecific energy +~
265)
266
267369openehrenpropertyPower density (}
268#
269
270368openehrenpropertyPower flux +|
271)
272
273367openehrenpropertyPower linear
274
275.†è»‰Y,õ¾ˆZ.)
276%
277
278505openehrenpropertyIlluminance +
279)
280
281504openehrenpropertyLuminous flux 3
2829
283
284503openehrenpropertyMagnetic flux density 4
285;
286
287502openehrenpropertyElectrical conductance 4
288;
289
290501openehrenpropertyElectrical capacitance *
291'
292
293500openehrenpropertyAngle solid -
294-
295
296499openehrenpropertyLight intensity /
2971
298
299498openehrenpropertyElectrical charge *
300'
301
302497openehrenpropertyAngle plane 
3035c
304433openehrencomposition categoryeventThis composition pertains to a point in time or brief episode. Change types may usually be modificationor ‚v
305
3065!…
307
308431openehrencomposition categorypersistentThis Composition contains information which remains valid for (more or less) the life of the EHR. Typical persistent Compositions include family history” problem list” current medications” and vaccination history”. The usual change type when creating a new version of a persistent composition is modification”.
309
310Ò§{d‘:Úm
311N ;C
312526openehrenInstruction transitionsplannedThe instruction is planned j
313 ;{
314524openehrenInstruction transitionsinitialThe instruction is recorded but no state is determined ]
315 /Q)523openehrenaudit change typedeletedChange type was logical deletion. HL7_CDA: CEN: T
316 ;O
317523openehrenversion lifecycle statedeletedItem has been logically deleted. O
3183
319‚I
320522openehrenevent math functionincreaseThis is also a change but is only a positive change and cannot be expressed as a negative. This can be used for positive changes like Weight gain: 2.5kg”. ‚
3213
322ƒQ
323521openehrenevent math functiondecreaseThis is a change - as in 147 - except indicates that the value while a positive number is actually a negative change. Typically used for negative changes like weight loss: 5kgor blood pressure postural drop of 10 mm[Hg]”. )
324%
325
326508openehrenpropertyEnergy dose (
327#
328
329507openehrenpropertyProportion +
330)
331
332506openehrenpropertyRadioactivity
333B‹îj¶ûBX& ;S
334532openehrenInstruction transitionscompletedThe instruction has been completed [% ;
335[
336532openehrenversion lifecycle statecompleteItem is complete at time of committal. 7$
337
338531openehrenInstruction transitionsabortedThe instruction is aborted it has been activated but ceased before it has been completed and will not be restarted in the future. 0#
339
340530openehrenInstruction transitionssuspendedThe instruction is suspended it has been activated but is not active at present. It could be active again in the future. "
341;!
342529openehrenInstruction transitionsscheduledThe instruction has been scheduled to be carried out at a particular time !
343;S
344528openehrenInstruction transitionscancelledThe instruction has been cancelled - it had not been commenced and will not commence in the future r
345
346527openehrenInstruction transitionspostponedThe instruction has been posponed - it had not be commenced
347,_þyÏR¿,-
348;G
349540openehrenInstruction transitionsstartStart executing the activities in the Instruction e.g. commence drug administration course. ,
350;
351A
352539openehrenInstruction transitionsscheduleWhere booking is required book the activities in the Instruction in a scheduling system. z+
353
354538openehrenInstruction transitionsrestoreRestore a previously postponed Instruction back to the planned state. &*
355;
356o
357537openehrenInstruction transitionspostponePut a planned Instruction on hold while still in the planning stage i.e. before it has been booked or started. )
358;#
359536openehrenInstruction transitionsplan stepAny step in the planned state of the Instruction e.g. signing approving. ^( ;
360a
361535openehrenInstruction transitionsinitiateInitiate the planning of the Instruction. 
362'
363;_
364533openehrenInstruction transitionsexpiredThe instruction has expired timed out - and assumed to have either been cancelled aborted or completed
365škBÑ*š
3662
367;=
368544openehrenInstruction transitionssuspendSuspend the activities from the active phase with the possibility of later resumption. #1
369;#c
370543openehrenInstruction transitionsactive stepAny step taken during the active phase of the Instruction e.g. nurse’s observation adjustment of dose. n0 ;)u
371542openehrenInstruction transitionspostponed stepAny step in the postponed state of the Instruction. ‚%/
372;ƒy
373541openehrenInstruction transitionsdoDo the activities in the Instruction in one go taking the state machine directly from the planned to the completed state. Used for Instructions whose activities are instantaneous in the practical sense e.g. a single vaccination single tablet. .
374;)9
375540openehrenInstruction transitionsnotify abortedOccurs when notification of Instruction having been aborted is received after expiry.
376†¹2·†8
377;-=
378551openehrenInstruction transitionsnotify completedOccurs when notification of Instruction having been completed is received after expiry. 7
379;
380K
381549openehrenInstruction transitionstime outTime out has occurred taking the Instruction from some pervious state into the expired state. x6
382
383548openehrenInstruction transitionsfinishFinish performing the Instruction taking it to the completed state. 5
384;/
385547openehrenInstruction transitionsabortAbort the Instruction i.e. stop its execution permanently after it has started. c4 ;o
386546openehrenInstruction transitionsresumeResume the Instruction from the suspended state. ]3
387;)‚Q
388545openehrenInstruction transitionssuspended stepAny step taken in the suspended state e.g. nurse’s observation pathology test to determine if the Instruction should be resumed remain suspended or aborted.
389Lg™âo³Ld? 5'i
390670openehrenterm mapping purposereimbursementReimbrusement / billing related term mapping. Z> 5'U
391669openehrenterm mapping purposepublic healthPublic health related term mapping. \= /#G)666openehrenaudit change typeattestationExisting data were attested. HL7_CDA: CEN: p<
392
393
394648openehrenattestation reasonwitnessedThis attested information has been witnessed by the signatory. 3;
395
396640openehrenevent math functionactualValue of the datum was the value indicated during the entire time of the event i.e. it is not an averaged or other computed value. J:
397;!‚3
398553openehrenversion lifecycle stateincompleteItem is incomplete at time of committal in the view of the author. Further editing or review needed before its status will be set to finished”. 9
399;-=
400552openehrenInstruction transitionsnotify cancelledOccurs when notification of Instruction having been cancelled is received after expiry.
401¦¦W@ 5)M
402671openehrenterm mapping purposeresearch studyTerm mapping.for research study
Note: See TracBrowser for help on using the repository browser.