******************************************************************* * PostgreSQL File/Block Formatted Dump Utility - Version 11.0 * * File: 111088 * Options used: -v -f -i -k * * Dump created on: Thu Nov 1 15:37:24 2018 ******************************************************************* Block 0 ********************************************************

----- Block Offset: 0x00000000 Offsets: Lower 68 (0x0044) Block: Size 8192 Version 4 Upper 2680 (0x0a78) LSN: logid 0 recoff 0x46a073a0 Special 8192 (0x2000) Items: 11 Free Space: 2612 Checksum: 0x3086 Prune XID: 0x0001df49 Flags: 0x0000 () Length (including item array): 68 0000: 00000000 a073a046 86300000 4400780a .....s.F.0..D.x. 0010: 00200420 49df0100 009e0004 00800100 . . I........... 0020: 00800100 e89a2a06 48994003 00800100 ......*.H.@..... 0030: 14956208 b892b604 b890fa03 3c8df606 ..b.........<... 0040: 788a8405 x... ------ Item 1 -- Length: 512 Offset: 7680 (0x1e00) Flags: NORMAL XMIN: 119568 XMAX: 0 CID|XVAC: 0 Block Id: 0 linp Index: 1 Attributes: 12 Size: 24 infomask: 0x0902 (HASVARWIDTH|XMIN_COMMITTED|XMAX_INVALID) 1e00: 10d30100 00000000 00000000 00000000 ................ 1e10: 01000c00 02091800 a6340000 00000000 .........4...... 1e20: 8f2bee84 971c0200 676d2d64 626f0000 .+......gm-dbo.. 1e30: 00000000 00000000 00000000 00000000 ................ 1e40: 00000000 00000000 00000000 00000000 ................ 1e50: 00000000 00000000 00000000 00000000 ................ 1e60: 00000000 00000000 01000000 fb53454c .............SEL 1e70: 45435420 45584953 54532853 454c4543 ECT EXISTS(SELEC 1e80: 54203120 46524f4d 20636c69 6e2e765f T 1 FROM clin.v_ 1e90: 66616d69 6c795f68 6973746f 72792057 family_history W 1ea0: 48455245 20636f6e 64697469 6f6e207e HERE condition ~ 1eb0: 2a202764 656e6576 616e2e2a 70617261 * 'denevan.*para 1ec0: 73697427 20414e44 20706b5f 70617469 sit' AND pk_pati 1ed0: 656e7420 3d204944 5f414354 4956455f ent = ID_ACTIVE_ 1ee0: 50415449 454e5429 3b595374 61727472 PATIENT);YStartr 1ef0: 656b3a20 44656e65 76616e20 6e657572 ek: Denevan neur 1f00: 616c2070 61726173 69746520 73637265 al parasite scre 1f10: 656e696e 67ed5061 7469656e 74732077 ening.Patients w 1f20: 69746820 6578706f 73757265 20746f20 ith exposure to 1f30: 44656e65 76616e20 4e657572 616c2050 Denevan Neural P 1f40: 61726173 69746520 63617272 69657273 arasite carriers 1f50: 2073686f 756c6420 756e6465 72676f20 should undergo 1f60: 45454720 7363616e 6e696e67 20616e64 EEG scanning and 1f70: 20627261 696e2069 6d616769 6e672062 brain imaging b 1f80: 692d616e 6e75616c 6c792e83 68747470 i-annually..http 1f90: 3a2f2f77 77772e73 74617274 72656b2e ://www.startrek. 1fa0: 636f6d2f 64617461 62617365 5f617274 com/database_art 1fb0: 69636c65 2f64656e 6576616e 2d6e6575 icle/denevan-neu 1fc0: 72616c2d 70617261 73697465 01615374 ral-parasite.aSt 1fd0: 6172666c 65657420 43656e74 72616c20 arfleet Central 1fe0: 50726576 656e7469 76652054 61736b20 Preventive Task 1ff0: 466f7263 65202876 31372e30 2907656e Force (v17.0).en Item 2 -- Length: 0 Offset: 0 (0x0000) Flags: DEAD Item 3 -- Length: 0 Offset: 0 (0x0000) Flags: DEAD Item 4 -- Length: 789 Offset: 6888 (0x1ae8) Flags: NORMAL XMIN: 122698 XMAX: 128765 CID|XVAC: 0 Block Id: 0 linp Index: 4 Attributes: 12 Size: 24 infomask: 0x0102 (HASVARWIDTH|XMIN_COMMITTED|KEYS_UPDATED) 1ae8: 4adf0100 fdf60100 00000000 00000000 J............... 1af8: 04000c20 02011800 53350000 00000000 ... ....S5...... 1b08: 69bd669a 971c0200 676d2d64 626f0000 i.f.....gm-dbo.. 1b18: 00000000 00000000 00000000 00000000 ................ 1b28: 00000000 00000000 00000000 00000000 ................ 1b38: 00000000 00000000 00000000 00000000 ................ 1b48: 00000000 00000000 04000000 c0060000 ................ 1b58: 53454c45 43542045 58495354 5320280a SELECT EXISTS (. 1b68: 0953454c 45435420 31204652 4f4d2063 .SELECT 1 FROM c 1b78: 6c696e2e 765f7375 62737461 6e63655f lin.v_substance_ 1b88: 696e7461 6b657320 57484552 450a0909 intakes WHERE... 1b98: 706b5f70 61746965 6e74203d 2049445f pk_patient = ID_ 1ba8: 41435449 56455f50 41544945 4e540a09 ACTIVE_PATIENT.. 1bb8: 0909414e 440a0909 73756273 74616e63 ..AND...substanc 1bc8: 65207e2a 20272e2a 73617274 616e2e2a e ~* '.*sartan.* 1bd8: 270a0909 094f520a 09097375 62737461 '....OR...substa 1be8: 6e636520 7e2a2027 2e2a616e 67696f74 nce ~* '.*angiot 1bf8: 656e7369 6e2e2a27 0a090909 4f520a09 ensin.*'....OR.. 1c08: 09737562 7374616e 6365207e 20272e2a .substance ~ '.* 1c18: 4143452e 2a270a09 09094f52 0a090973 ACE.*'....OR...s 1c28: 75627374 616e6365 207e2a20 272e2a70 ubstance ~* '.*p 1c38: 72696c2e 2a270a09 09094f52 0a090961 ril.*'....OR...a 1c48: 74635f62 72616e64 207e2a20 275e4330 tc_brand ~* '^C0 1c58: 392e2a27 0a090909 4f520a09 09617463 9.*'....OR...atc 1c68: 5f737562 7374616e 6365207e 2a20275e _substance ~* '^ 1c78: 4330392e 2a270a29 20414e44 20455849 C09.*'.) AND EXI 1c88: 53545320 280a0953 454c4543 54203120 STS (..SELECT 1 1c98: 46524f4d 20636c69 6e2e765f 6e617272 FROM clin.v_narr 1ca8: 61746976 65347365 61726368 20574845 ative4search WHE 1cb8: 52450a09 09706b5f 70617469 656e7420 RE...pk_patient 1cc8: 3d204944 5f414354 4956455f 50415449 = ID_ACTIVE_PATI 1cd8: 454e540a 09090941 4e440a09 096e6172 ENT....AND...nar 1ce8: 72617469 7665207e 2a20272e 2a736368 rative ~* '.*sch 1cf8: 77616e67 65722e2a 270a293b 634b6f6e wanger.*'.);cKon 1d08: 74726169 6e64696b 6174696f 6e3a2041 traindikation: A 1d18: 43452f53 61727461 6e203c2d 3e205363 CE/Sartan <-> Sc 1d28: 6877616e 67657273 63686166 74ad4143 hwangerschaft.AC 1d38: 452d4865 6d6d6572 20756e64 20536172 E-Hemmer und Sar 1d48: 74616e65 206bc3b6 6e6e656e 20696d20 tane k..nnen im 1d58: 322e2075 6e642033 2e205472 696d656e 2. und 3. Trimen 1d68: 6f6e2073 63687765 72652046 65746f70 on schwere Fetop 1d78: 61746869 656e2068 6572766f 72727566 athien hervorruf 1d88: 656e2ea5 68747470 3a2f2f77 77772e61 en..http://www.a 1d98: 6b646165 2e64652f 41727a6e 65696d69 kdae.de/Arzneimi 1da8: 7474656c 73696368 65726865 69742f42 ttelsicherheit/B 1db8: 656b616e 6e746761 62656e2f 41726368 ekanntgaben/Arch 1dc8: 69762f32 3031302f 32303130 31303135 iv/2010/20101015 1dd8: 312e7064 66013947 4e556d65 64206465 1.pdf.9GNUmed de 1de8: 6661756c 74202841 6b64c384 20323031 fault (Akd.. 201 1df8: 32290764 65 2).de Item 5 -- Length: 416 Offset: 6472 (0x1948) Flags: NORMAL XMIN: 127397 XMAX: 0 CID|XVAC: 0 Block Id: 0 linp Index: 5 Attributes: 13 Size: 28 infomask: 0x0903 (HASNULL|HASVARWIDTH|XMIN_COMMITTED|XMAX_INVALID) t_bits: [0]: 0xff [1]: 0x0e 1948: a5f10100 00000000 00000000 00000000 ................ 1958: 05000d00 03091cff 0e000000 da350000 .............5.. 1968: 00000000 33f70adf 981c0200 676d2d64 ....3.......gm-d 1978: 626f0000 00000000 00000000 00000000 bo.............. 1988: 00000000 00000000 00000000 00000000 ................ 1998: 00000000 00000000 00000000 00000000 ................ 19a8: 00000000 00000000 00000000 05000000 ................ 19b8: 80020000 53454c45 4354204e 4f542045 ....SELECT NOT E 19c8: 58495354 53285345 4c454354 20312046 XISTS(SELECT 1 F 19d8: 524f4d20 636c696e 2e765f6e 6f6e6272 ROM clin.v_nonbr 19e8: 616e645f 696e7461 6b657320 57484552 and_intakes WHER 19f8: 4520706b 5f706174 69656e74 203d2049 E pk_patient = I 1a08: 445f4143 54495645 5f504154 49454e54 D_ACTIVE_PATIENT 1a18: 20414e44 20617463 5f737562 7374616e AND atc_substan 1a28: 6365203d 20274e30 37424130 31272041 ce = 'N07BA01' A 1a38: 4e442068 61726d66 756c5f75 73655f74 ND harmful_use_t 1a48: 79706520 4953204e 4f54204e 554c4c29 ype IS NOT NULL) 1a58: 4b4c6163 6b206f66 20736d6f 6b696e67 KLack of smoking 1a68: 20737461 74757320 646f6375 6d656e74 status document 1a78: 6174696f 6e875468 65726520 68617320 ation.There has 1a88: 6e657665 72206265 656e2061 6e792073 never been any s 1a98: 6d6f6b69 6e672073 74617475 73207265 moking status re 1aa8: 636f7264 65642066 6f722074 68697320 corded for this 1ab8: 70617469 656e742e 01494157 4d46204e patient..IAWMF N 1ac8: 564c2053 6368c3a4 646c6963 68657220 VL Sch..dlicher 1ad8: 54616261 6b676562 72617563 6807656e Tabakgebrauch.en Item 6 -- Length: 0 Offset: 0 (0x0000) Flags: DEAD Item 7 -- Length: 1073 Offset: 5396 (0x1514) Flags: NORMAL XMIN: 127399 XMAX: 0 CID|XVAC: 0 Block Id: 0 linp Index: 7 Attributes: 13 Size: 24 infomask: 0x0902 (HASVARWIDTH|XMIN_COMMITTED|XMAX_INVALID) 1514: a7f10100 00000000 00000000 00000000 ................ 1524: 07000d00 02091800 dc350000 00000000 .........5...... 1534: 2af90bdf 981c0200 676d2d64 626f0000 *.......gm-dbo.. 1544: 00000000 00000000 00000000 00000000 ................ 1554: 00000000 00000000 00000000 00000000 ................ 1564: 00000000 00000000 00000000 00000000 ................ 1574: 00000000 00000000 07000000 a8090000 ................ 1584: 53454c45 43542045 58495354 5320280a SELECT EXISTS (. 1594: 092d2d20 73756273 74616e63 65206368 .-- substance ch 15a4: 65636b0a 0953454c 45435420 31204652 eck..SELECT 1 FR 15b4: 4f4d2063 6c696e2e 765f7375 62737461 OM clin.v_substa 15c4: 6e63655f 696e7461 6b657320 57484552 nce_intakes WHER 15d4: 450a0909 706b5f70 61746965 6e74203d E...pk_patient = 15e4: 2049445f 41435449 56455f50 41544945 ID_ACTIVE_PATIE 15f4: 4e540a09 0909414e 440a0909 2d2d206f NT....AND...-- o 1604: 6e205361 7274616e 206f7220 41434549 n Sartan or ACEI 1614: 0a090928 0a090909 73756273 74616e63 ...(....substanc 1624: 65207e2a 20272e2a 73617274 616e2e2a e ~* '.*sartan.* 1634: 270a0909 09094f52 0a090909 73756273 '.....OR....subs 1644: 74616e63 65207e2a 20272e2a 616e6769 tance ~* '.*angi 1654: 6f74656e 73696e2e 2a270a09 0909094f otensin.*'.....O 1664: 520a0909 09737562 7374616e 6365207e R....substance ~ 1674: 20272e2a 4143452e 2a270a09 0909094f '.*ACE.*'.....O 1684: 520a0909 092d2d20 6d696768 74207265 R....-- might re 1694: 73756c74 20696e20 66616c73 6520706f sult in false po 16a4: 73697469 76657320 282e5072 696c6f63 sitives (.Priloc 16b4: 61727069 6e290a09 09097375 62737461 arpin)....substa 16c4: 6e636520 7e2a2027 2e2b7072 696c2e2a nce ~* '.+pril.* 16d4: 270a0909 09094f52 0a090909 6174635f '.....OR....atc_ 16e4: 6272616e 64207e2a 20275e43 30392e2a brand ~* '^C09.* 16f4: 270a0909 09094f52 0a090909 6174635f '.....OR....atc_ 1704: 73756273 74616e63 65207e2a 20275e43 substance ~* '^C 1714: 30392e2a 270a0929 0a292041 4e442045 09.*'..).) AND E 1724: 58495354 5320280a 092d2d20 70726567 XISTS (..-- preg 1734: 6e616e63 79206368 65636b0a 0953454c nancy check..SEL 1744: 45435420 31204652 4f4d2063 6c696e2e ECT 1 FROM clin. 1754: 70617469 656e7420 57484552 450a0909 patient WHERE... 1764: 666b5f69 64656e74 69747920 3d204944 fk_identity = ID 1774: 5f414354 4956455f 50415449 454e540a _ACTIVE_PATIENT. 1784: 09090941 4e440a09 09636f61 6c657363 ...AND...coalesc 1794: 65286564 63204245 54574545 4e206e6f e(edc BETWEEN no 17a4: 77282920 2d202731 206d6f6e 7468273a w() - '1 month': 17b4: 3a696e74 65727661 6c20414e 44206e6f :interval AND no 17c4: 77282920 2b202731 31206d6f 6e746873 w() + '11 months 17d4: 273a3a69 6e746572 76616c2c 2046414c '::interval, FAL 17e4: 5345290a 293b5943 6f6e7472 61696e64 SE).);YContraind 17f4: 69636174 696f6e3a 20414345 492f5361 ication: ACEI/Sa 1804: 7274616e 203c2d3e 20507265 676e616e rtan <-> Pregnan 1814: 6379a741 43454920 616e6420 53617274 cy.ACEI and Sart 1824: 616e7320 63616e20 63617573 65207365 ans can cause se 1834: 76657265 20666574 6f706174 68696573 vere fetopathies 1844: 20696620 75736564 20647572 696e6720 if used during 1854: 326e6420 616e6420 33726420 7472696d 2nd and 3rd trim 1864: 656e6f6e 2ea56874 74703a2f 2f777777 enon..http://www 1874: 2e616b64 61652e64 652f4172 7a6e6569 .akdae.de/Arznei 1884: 6d697474 656c7369 63686572 68656974 mittelsicherheit 1894: 2f42656b 616e6e74 67616265 6e2f4172 /Bekanntgaben/Ar 18a4: 63686976 2f323031 302f3230 31303130 chiv/2010/201010 18b4: 3135312e 70646601 39474e55 6d656420 151.pdf.9GNUmed 18c4: 64656661 756c7420 28416b64 c3842032 default (Akd.. 2 18d4: 30313229 07656ed5 53454c45 4354205f 012).en.SELECT _ 18e4: 28274544 433a2027 29207c7c 20746f5f ('EDC: ') || to_ 18f4: 63686172 28656463 2c202759 59595920 char(edc, 'YYYY 1904: 4d6f6e20 44442729 2046524f 4d20636c Mon DD') FROM cl 1914: 696e2e70 61746965 6e742057 48455245 in.patient WHERE 1924: 20666b5f 6964656e 74697479 203d2049 fk_identity = I 1934: 445f4143 54495645 5f504154 49454e54 D_ACTIVE_PATIENT 1944: 3b ; Item 8 -- Length: 603 Offset: 4792 (0x12b8) Flags: NORMAL XMIN: 127400 XMAX: 0 CID|XVAC: 0 Block Id: 0 linp Index: 8 Attributes: 13 Size: 28 infomask: 0x0803 (HASNULL|HASVARWIDTH|XMAX_INVALID) t_bits: [0]: 0xff [1]: 0x1e 12b8: a8f10100 00000000 00000000 00000000 ................ 12c8: 08000d00 03081cff 1e000000 dd350000 .............5.. 12d8: 00000000 a4230cdf 981c0200 676d2d64 .....#......gm-d 12e8: 626f0000 00000000 00000000 00000000 bo.............. 12f8: 00000000 00000000 00000000 00000000 ................ 1308: 00000000 00000000 00000000 00000000 ................ 1318: 00000000 00000000 00000000 08000000 ................ 1328: 1c040000 53454c45 43542045 58495354 ....SELECT EXIST 1338: 5320280a 0953454c 45435420 31204652 S (..SELECT 1 FR 1348: 4f4d2063 6c696e2e 70617469 656e7420 OM clin.patient 1358: 57484552 450a0909 666b5f69 64656e74 WHERE...fk_ident 1368: 69747920 3d204944 5f414354 4956455f ity = ID_ACTIVE_ 1378: 50415449 454e540a 09090941 4e440a09 PATIENT....AND.. 1388: 09636f61 6c657363 6528280a 0909092d .coalesce((....- 1398: 2d206c6f 6e676572 20746861 6e203320 - longer than 3 13a8: 6d6f6e74 68732061 676f0a09 09096564 months ago....ed 13b8: 63203c20 6e6f7728 29202d20 2733206d c < now() - '3 m 13c8: 6f6e7468 73273a3a 696e7465 7276616c onths'::interval 13d8: 0a090909 094f520a 0909092d 2d203220 .....OR....-- 2 13e8: 79656172 7320696e 20746865 20667574 years in the fut 13f8: 7572650a 09090965 6463203e 206e6f77 ure....edc > now 1408: 2829202b 20273220 79656172 73273a3a () + '2 years':: 1418: 696e7465 7276616c 0a090929 2c204641 interval...), FA 1428: 4c534529 0a293b3b 4f757464 61746564 LSE).);;Outdated 1438: 206f7220 71756573 74696f6e 61626c65 or questionable 1448: 20454443 95546865 20454443 20646f63 EDC.The EDC doc 1458: 756d656e 74656420 666f7220 74686973 umented for this 1468: 20706174 69656e74 20697320 6f757464 patient is outd 1478: 61746564 206f7220 746f6f20 66617220 ated or too far 1488: 696e2074 68652066 75747572 652e011f in the future... 1498: 474e556d 65642064 65666175 6c740765 GNUmed default.e 14a8: 6ed55345 4c454354 205f2827 4544433a n.SELECT _('EDC: 14b8: 20272920 7c7c2074 6f5f6368 61722865 ') || to_char(e 14c8: 64632c20 27595959 59204d6f 6e204444 dc, 'YYYY Mon DD 14d8: 27292046 524f4d20 636c696e 2e706174 ') FROM clin.pat 14e8: 69656e74 20574845 52452066 6b5f6964 ient WHERE fk_id 14f8: 656e7469 7479203d 2049445f 41435449 entity = ID_ACTI 1508: 56455f50 41544945 4e543b VE_PATIENT; Item 9 -- Length: 509 Offset: 4280 (0x10b8) Flags: NORMAL XMIN: 127401 XMAX: 0 CID|XVAC: 0 Block Id: 0 linp Index: 9 Attributes: 13 Size: 28 infomask: 0x0803 (HASNULL|HASVARWIDTH|XMAX_INVALID) t_bits: [0]: 0xff [1]: 0x1e 10b8: a9f10100 00000000 00000000 00000000 ................ 10c8: 09000d00 03081cff 1e000000 de350000 .............5.. 10d8: 00000000 244e0cdf 981c0200 676d2d64 ....$N......gm-d 10e8: 626f0000 00000000 00000000 00000000 bo.............. 10f8: 00000000 00000000 00000000 00000000 ................ 1108: 00000000 00000000 00000000 00000000 ................ 1118: 00000000 00000000 00000000 09000000 ................ 1128: 34030000 53454c45 43542028 0a095345 4...SELECT (..SE 1138: 4c454354 20645f69 2e67656e 64657220 LECT d_i.gender 1148: 3d20276d 27204652 4f4d2064 656d2e69 = 'm' FROM dem.i 1158: 64656e74 69747920 645f6920 57484552 dentity d_i WHER 1168: 450a0909 645f692e 706b203d 2049445f E...d_i.pk = ID_ 1178: 41435449 56455f50 41544945 4e540a29 ACTIVE_PATIENT.) 1188: 20414e44 20455849 53545320 280a0953 AND EXISTS (..S 1198: 454c4543 54203120 46524f4d 20636c69 ELECT 1 FROM cli 11a8: 6e2e7061 7469656e 74205748 4552450a n.patient WHERE. 11b8: 0909666b 5f696465 6e746974 79203d20 ..fk_identity = 11c8: 49445f41 43544956 455f5041 5449454e ID_ACTIVE_PATIEN 11d8: 540a0909 09414e44 0a090965 64632049 T....AND...edc I 11e8: 53204e4f 54204e55 4c4c0a29 3b235175 S NOT NULL.);#Qu 11f8: 65737469 6f6e6162 6c652045 44436554 estionable EDCeT 1208: 68657265 20697320 616e2045 44432064 here is an EDC d 1218: 6f63756d 656e7465 6420666f 72207468 ocumented for th 1228: 6973204d 414c4520 70617469 656e742e is MALE patient. 1238: 011f474e 556d6564 20646566 61756c74 ..GNUmed default 1248: 07656ed5 53454c45 4354205f 28274544 .en.SELECT _('ED 1258: 433a2027 29207c7c 20746f5f 63686172 C: ') || to_char 1268: 28656463 2c202759 59595920 4d6f6e20 (edc, 'YYYY Mon 1278: 44442729 2046524f 4d20636c 696e2e70 DD') FROM clin.p 1288: 61746965 6e742057 48455245 20666b5f atient WHERE fk_ 1298: 6964656e 74697479 203d2049 445f4143 identity = ID_AC 12a8: 54495645 5f504154 49454e54 3b TIVE_PATIENT; Item 10 -- Length: 891 Offset: 3388 (0x0d3c) Flags: NORMAL XMIN: 127841 XMAX: 0 CID|XVAC: 0 Block Id: 0 linp Index: 10 Attributes: 13 Size: 28 infomask: 0x0803 (HASNULL|HASVARWIDTH|XMAX_INVALID) t_bits: [0]: 0xff [1]: 0x1e 0d3c: 61f30100 00000000 00000000 00000000 a............... 0d4c: 0a000d00 03081cff 1e000000 0f360000 .............6.. 0d5c: 00000000 3bc315e2 981c0200 676d2d64 ....;.......gm-d 0d6c: 626f0000 00000000 00000000 00000000 bo.............. 0d7c: 00000000 00000000 00000000 00000000 ................ 0d8c: 00000000 00000000 00000000 00000000 ................ 0d9c: 00000000 00000000 00000000 0a000000 ................ 0dac: cc050000 53454c45 43542028 0a09092d ....SELECT (...- 0dbc: 2d206e6f 74206465 63656173 65640a09 - not deceased.. 0dcc: 0953454c 45435420 64656365 61736564 .SELECT deceased 0ddc: 20697320 4e554c4c 2046524f 4d206465 is NULL FROM de 0dec: 6d2e6964 656e7469 74792057 48455245 m.identity WHERE 0dfc: 20706b20 3d204944 5f414354 4956455f pk = ID_ACTIVE_ 0e0c: 50415449 454e540a 09292041 4e44204e PATIENT..) AND N 0e1c: 4f542045 58495354 5320280a 09092d2d OT EXISTS (...-- 0e2c: 206e6f20 74657461 6e757320 73686f74 no tetanus shot 0e3c: 20646f63 756d656e 7465640a 09095345 documented...SE 0e4c: 4c454354 20312046 524f4d20 636c696e LECT 1 FROM clin 0e5c: 2e765f70 61745f76 61636373 34696e64 .v_pat_vaccs4ind 0e6c: 69636174 696f6e0a 09095748 4552450a ication...WHERE. 0e7c: 09090970 6b5f7061 7469656e 74203d20 ...pk_patient = 0e8c: 49445f41 43544956 455f5041 5449454e ID_ACTIVE_PATIEN 0e9c: 540a0909 0909414e 440a0909 09696e64 T.....AND....ind 0eac: 69636174 696f6e20 3d202774 6574616e ication = 'tetan 0ebc: 7573270a 09090909 414e440a 09090964 us'.....AND....d 0ecc: 6174655f 67697665 6e203e20 6e6f7728 ate_given > now( 0edc: 29202d20 27313020 79656172 73273a3a ) - '10 years':: 0eec: 696e7465 7276616c 0a09094f 52444552 interval...ORDER 0efc: 2042590a 09090964 6174655f 67697665 BY....date_give 0f0c: 6e204445 53430a09 094c494d 49542031 n DESC...LIMIT 1 0f1c: 0a293b43 54657461 6e75732d 496d7066 .);CTetanus-Impf 0f2c: 67203e20 3130204a 61687265 20285354 g > 10 Jahre (ST 0f3c: 494b4f29 774c6574 7a746520 54657461 IKO)wLetzte Teta 0f4c: 6e757369 6d706675 6e672076 6f72206d nusimpfung vor m 0f5c: 65687220 616c7320 3130204a 61687265 ehr als 10 Jahre 0f6c: 6e20646f 6b756d65 6e746965 72742e01 n dokumentiert.. 0f7c: 17535449 4b4f2032 30313607 64650000 .STIKO 2016.de.. 0f8c: ac040000 53454c45 43542063 6f616c65 ....SELECT coale 0f9c: 73636520 280a0928 53454c45 43540a09 sce (..(SELECT.. 0fac: 09274c65 747a7465 20546574 616e7573 .'Letzte Tetanus 0fbc: 696d7066 756e673a 2027207c 7c20746f impfung: ' || to 0fcc: 5f636861 72286461 74655f67 6976656e _char(date_given 0fdc: 2c202759 59595920 4d6f6e20 44442729 , 'YYYY Mon DD') 0fec: 0a094652 4f4d2063 6c696e2e 765f7061 ..FROM clin.v_pa 0ffc: 745f7661 63637334 696e6469 63617469 t_vaccs4indicati 100c: 6f6e0a09 57484552 450a0909 706b5f70 on..WHERE...pk_p 101c: 61746965 6e74203d 2049445f 41435449 atient = ID_ACTI 102c: 56455f50 41544945 4e540a09 0909414e VE_PATIENT....AN 103c: 440a0909 696e6469 63617469 6f6e203d D...indication = 104c: 20277465 74616e75 73270a09 4f524445 'tetanus'..ORDE 105c: 52204259 0a090964 6174655f 67697665 R BY...date_give 106c: 6e204445 53430a09 4c494d49 54203129 n DESC..LIMIT 1) 107c: 2c0a0927 6b65696e 65205465 74616e75 ,..'keine Tetanu 108c: 73696d70 66756e67 20646f6b 756d656e simpfung dokumen 109c: 74696572 74270a29 20617320 7265636f tiert'.) as reco 10ac: 6d6d656e 64617469 6f6e3b mmendation; Item 11 -- Length: 706 Offset: 2680 (0x0a78) Flags: NORMAL XMIN: 127860 XMAX: 127860 CID|XVAC: 0 Block Id: 0 linp Index: 11 Attributes: 13 Size: 28 infomask: 0x2093 (HASNULL|HASVARWIDTH|XMAX_KEYSHR_LOCK|XMAX_LOCK_ONLY|UPDATED) t_bits: [0]: 0xff [1]: 0x0f 0a78: 74f30100 74f30100 00000000 00000000 t...t........... 0a88: 0b000d00 93201cff 0f000000 52350000 ..... ......R5.. 0a98: 01000000 98ba89e2 981c0200 676d2d64 ............gm-d 0aa8: 626f0000 00000000 00000000 00000000 bo.............. 0ab8: 00000000 00000000 00000000 00000000 ................ 0ac8: 00000000 00000000 00000000 00000000 ................ 0ad8: 00000000 00000000 00000000 03000000 ................ 0ae8: 30070000 53454c45 43542028 0a095345 0...SELECT (..SE 0af8: 4c454354 0a09092d 2d206b6e 6f776e20 LECT...-- known 0b08: 444f420a 0909645f 692e646f 62206973 DOB...d_i.dob is 0b18: 206e6f74 204e554c 4c0a0909 09414e44 not NULL....AND 0b28: 0a09092d 2d206e6f 74206465 63656173 ...-- not deceas 0b38: 65640a09 09645f69 2e646563 65617365 ed...d_i.decease 0b48: 64206973 204e554c 4c0a0946 524f4d0a d is NULL..FROM. 0b58: 09096465 6d2e6964 656e7469 74792064 ..dem.identity d 0b68: 5f690a09 57484552 450a0909 645f692e _i..WHERE...d_i. 0b78: 706b203d 2049445f 41435449 56455f50 pk = ID_ACTIVE_P 0b88: 41544945 4e540a29 20414e44 20280a09 ATIENT.) AND (.. 0b98: 53454c45 43540a09 09616765 28645f69 SELECT...age(d_i 0ba8: 2e646f62 29203e3d 20273335 20796561 .dob) >= '35 yea 0bb8: 7273273a 3a696e74 65727661 6c0a0946 rs'::interval..F 0bc8: 524f4d0a 09096465 6d2e6964 656e7469 ROM...dem.identi 0bd8: 74792064 5f690a09 57484552 450a0909 ty d_i..WHERE... 0be8: 645f692e 706b203d 2049445f 41435449 d_i.pk = ID_ACTI 0bf8: 56455f50 41544945 4e540a29 20414e44 VE_PATIENT.) AND 0c08: 204e4f54 20455849 53545320 280a0953 NOT EXISTS (..S 0c18: 454c4543 54203120 46524f4d 20636c69 ELECT 1 FROM cli 0c28: 6e2e765f 656d725f 6a6f7572 6e616c0a n.v_emr_journal. 0c38: 09574845 52450a09 09706b5f 70617469 .WHERE...pk_pati 0c48: 656e7420 3d204944 5f414354 4956455f ent = ID_ACTIVE_ 0c58: 50415449 454e540a 09090941 4e440a09 PATIENT....AND.. 0c68: 096e6172 72617469 7665207e 2a20272e .narrative ~* '. 0c78: 2a636865 636b7570 2e2a270a 09090941 *checkup.*'....A 0c88: 4e440a09 09616765 28636c69 6e5f7768 ND...age(clin_wh 0c98: 656e2920 3c202732 20796561 7273273a en) < '2 years': 0ca8: 3a696e74 65727661 6c0a293b 33474b56 :interval.);3GKV 0cb8: 2d436865 636b7570 20c3bc62 657266c3 -Checkup ..berf. 0cc8: a46c6c69 677d4465 72205061 7469656e .llig}Der Patien 0cd8: 74206861 74746520 696e2064 656e206c t hatte in den l 0ce8: 65747a74 656e2032 204a6168 72656e20 etzten 2 Jahren 0cf8: 6b65696e 656e2047 4b562d43 6865636b keinen GKV-Check 0d08: 75702e39 64696520 c3bc626c 69636865 up.9die ..bliche 0d18: 6e205665 7264c3a4 63687469 67656e01 n Verd..chtigen. 0d28: 1f474e55 6d656420 64656661 756c7407 .GNUmed default. 0d38: 6465 de Block 1 ********************************************************

----- Block Offset: 0x00002000 Offsets: Lower 44 (0x002c) Block: Size 8192 Version 4 Upper 1108 (0x0454) LSN: logid 0 recoff 0x46a08fc0 Special 8192 (0x2000) Items: 5 Free Space: 1064 Checksum: 0x67c1 Prune XID: 0x00000000 Flags: 0x0000 () Length (including item array): 44 0000: 00000000 c08fa046 c1670000 2c005404 .......F.g..,.T. 0010: 00200420 00000000 2c99a40d 4091d80f . . ....,...@... 0020: 588cca09 c0882a07 5484d808 X.....*.T... ------ Item 1 -- Length: 1746 Offset: 6444 (0x192c) Flags: NORMAL XMIN: 127843 XMAX: 0 CID|XVAC: 0 Block Id: 1 linp Index: 1 Attributes: 13 Size: 28 infomask: 0x0903 (HASNULL|HASVARWIDTH|XMIN_COMMITTED|XMAX_INVALID) t_bits: [0]: 0xff [1]: 0x1e 192c: 63f30100 00000000 00000000 00000100 c............... 193c: 01000d00 03091cff 1e000000 11360000 .............6.. 194c: 00000000 301228e2 981c0200 676d2d64 ....0.(.....gm-d 195c: 626f0000 00000000 00000000 00000000 bo.............. 196c: 00000000 00000000 00000000 00000000 ................ 197c: 00000000 00000000 00000000 00000000 ................ 198c: 00000000 00000000 00000000 0b000000 ................ 199c: 000b0000 2d2d203e 36302079 65617273 ....-- >60 years 19ac: 0a53454c 45435420 45584953 54532028 .SELECT EXISTS ( 19bc: 0a095345 4c454354 20312046 524f4d20 ..SELECT 1 FROM 19cc: 64656d2e 6964656e 74697479 20574845 dem.identity WHE 19dc: 52450a09 0928706b 203d2049 445f4143 RE...(pk = ID_AC 19ec: 54495645 5f504154 49454e54 290a0909 TIVE_PATIENT)... 19fc: 09414e44 0a090928 646f6220 3c206e6f .AND...(dob < no 1a0c: 77282920 2d202736 30207965 61727327 w() - '60 years' 1a1c: 3a3a696e 74657276 616c290a 2920414e ::interval).) AN 1a2c: 44204558 49535453 20280a2d 2d204173 D EXISTS (.-- As 1a3c: 74686d61 2f434f50 442f456d 70687973 thma/COPD/Emphys 1a4c: 656d2f4c 756e6765 6e666962 726f7365 em/Lungenfibrose 1a5c: 0a53454c 45435420 31204652 4f4d2063 .SELECT 1 FROM c 1a6c: 6c696e2e 765f7072 6f626c65 6d5f6c69 lin.v_problem_li 1a7c: 73742057 48455245 0a092870 6b5f7061 st WHERE..(pk_pa 1a8c: 7469656e 74203d20 49445f41 43544956 tient = ID_ACTIV 1a9c: 455f5041 5449454e 54290a09 09414e44 E_PATIENT)...AND 1aac: 0a092809 2d2d2073 686f756c 64206368 ..(.-- should ch 1abc: 65636b20 49435043 2f494344 31300a09 eck ICPC/ICD10.. 1acc: 09287072 6f626c65 6d20696c 696b6520 .(problem ilike 1adc: 27256173 74686d61 2527290a 0909094f '%asthma%')....O 1aec: 520a0909 2870726f 626c656d 20696c69 R...(problem ili 1afc: 6b652027 25434f50 44252729 0a090909 ke '%COPD%').... 1b0c: 4f520a09 09287072 6f626c65 6d20696c OR...(problem il 1b1c: 696b6520 2725656d 70687973 656d2527 ike '%emphysem%' 1b2c: 290a0909 094f520a 0909280a 09090928 )....OR...(....( 1b3c: 70726f62 6c656d20 696c696b 65202725 problem ilike '% 1b4c: 66696272 6f732527 290a0909 0909414e fibros%').....AN 1b5c: 440a0909 09280a09 09090928 70726f62 D....(.....(prob 1b6c: 6c656d20 696c696b 65202725 6c756e67 lem ilike '%lung 1b7c: 2527290a 09090909 094f520a 09090909 %')......OR..... 1b8c: 2870726f 626c656d 20696c69 6b652027 (problem ilike ' 1b9c: 2570756c 6d6f6e25 27290a09 0909290a %pulmon%')....). 1bac: 0909290a 09290a29 20414e44 204e4f54 ..)..).) AND NOT 1bbc: 20455849 53545320 280a2d2d 206b6569 EXISTS (.-- kei 1bcc: 6e652049 6d706675 6e672050 6e65756d ne Impfung Pneum 1bdc: 6f6b6f6b 6b656e0a 53454c45 43542031 okokken.SELECT 1 1bec: 2046524f 4d20636c 696e2e76 5f706174 FROM clin.v_pat 1bfc: 5f766163 63733469 6e646963 6174696f _vaccs4indicatio 1c0c: 6e205748 4552450a 0928706b 5f706174 n WHERE..(pk_pat 1c1c: 69656e74 203d2049 445f4143 54495645 ient = ID_ACTIVE 1c2c: 5f504154 49454e54 290a0909 414e440a _PATIENT)...AND. 1c3c: 0928696e 64696361 74696f6e 203d2027 .(indication = ' 1c4c: 706e6575 6d6f636f 63637573 27290a29 pneumococcus').) 1c5c: 4b4c756e 67652d3e 506e6575 6d6f6b6f KLunge->Pneumoko 1c6c: 6b6b656e 2d496d70 66672028 4447502f kken-Impfg (DGP/ 1c7c: 4447494d 29974c75 6e67656e 6b72616e DGIM).Lungenkran 1c8c: 6b6520c3 a46c7465 72203630 20736f6c ke ..lter 60 sol 1c9c: 6c656e20 65696e65 20506e65 756d6f6b len eine Pneumok 1cac: 6f6b6b65 6e696d70 66756e67 20616e67 okkenimpfung ang 1cbc: 65626f74 656e2062 656b6f6d 6d656e2e eboten bekommen. 1ccc: 015f2247 656d6569 6e73616d 206b6c75 ._"Gemeinsam klu 1cdc: 6720656e 74736368 65696465 6e222028 g entscheiden" ( 1cec: 4447494d 3a204447 502c2032 30313629 DGIM: DGP, 2016) 1cfc: 07646500 f80b0000 53454c45 43540a28 .de.....SELECT.( 1d0c: 092d2d20 6578706c 61696e0a 0953454c .-- explain..SEL 1d1c: 45435420 45274573 20697374 206b6569 ECT E'Es ist kei 1d2c: 6e652049 6d706675 6e672067 6567656e ne Impfung gegen 1d3c: 20506e65 756d6f6b 6f6b6b65 6e20646f Pneumokokken do 1d4c: 6b756d65 6e746965 72742e5c 6e5c6e27 kumentiert.\n\n' 1d5c: 0a09097c 7c204527 45732073 6f6c6c74 ...|| E'Es sollt 1d6c: 65206569 6e652049 6d706675 6e672061 e eine Impfung a 1d7c: 6e676562 6f74656e 20776572 64656e2c ngeboten werden, 1d8c: 20776569 6c5c6e27 0a09092d 2d206167 weil\n'...-- ag 1d9c: 650a0909 7c7c2027 20646173 20416c74 e...|| ' das Alt 1dac: 65722028 27207c7c 20747269 6d286c65 er (' || trim(le 1dbc: 6164696e 67202730 27206672 6f6d2074 ading '0' from t 1dcc: 6f5f6368 6172286a 75737469 66795f69 o_char(justify_i 1ddc: 6e746572 76616c28 6e6f7728 29202d20 nterval(now() - 1dec: 646f6229 2c202759 59592729 29207c7c dob), 'YYY')) || 1dfc: 20452729 203e2036 30204a61 68726520 E') > 60 Jahre 1e0c: 69737420 756e645c 6e270a09 46524f4d ist und\n'..FROM 1e1c: 2064656d 2e696465 6e746974 79205748 dem.identity WH 1e2c: 45524520 706b203d 2049445f 41435449 ERE pk = ID_ACTI 1e3c: 56455f50 41544945 4e540a29 207c7c20 VE_PATIENT.) || 1e4c: 280a092d 2d207072 6f626c65 6d0a0953 (..-- problem..S 1e5c: 454c4543 54202720 65696e20 4c756e67 ELECT ' ein Lung 1e6c: 656e7072 6f626c65 6d202227 207c7c20 enproblem "' || 1e7c: 70726f62 6c656d20 7c7c2027 2220646f problem || '" do 1e8c: 6b756d65 6e746965 72742069 7374270a kumentiert ist'. 1e9c: 0946524f 4d20636c 696e2e76 5f70726f .FROM clin.v_pro 1eac: 626c656d 5f6c6973 74205748 4552450a blem_list WHERE. 1ebc: 09092870 6b5f7061 7469656e 74203d20 ..(pk_patient = 1ecc: 49445f41 43544956 455f5041 5449454e ID_ACTIVE_PATIEN 1edc: 54290a09 0909414e 440a0909 28092d2d T)....AND...(.-- 1eec: 2073686f 756c6420 63686563 6b204943 should check IC 1efc: 50432f49 43443130 0a090909 2870726f PC/ICD10....(pro 1f0c: 626c656d 20696c69 6b652027 25617374 blem ilike '%ast 1f1c: 686d6125 27290a09 0909094f 520a0909 hma%').....OR... 1f2c: 09287072 6f626c65 6d20696c 696b6520 .(problem ilike 1f3c: 2725434f 50442527 290a0909 09094f52 '%COPD%').....OR 1f4c: 0a090909 2870726f 626c656d 20696c69 ....(problem ili 1f5c: 6b652027 25656d70 68797365 6d252729 ke '%emphysem%') 1f6c: 0a090909 094f520a 09090928 0a090909 .....OR....(.... 1f7c: 09287072 6f626c65 6d20696c 696b6520 .(problem ilike 1f8c: 27256669 62726f73 2527290a 09090909 '%fibros%')..... 1f9c: 09414e44 0a090909 09280a09 09090909 .AND.....(...... 1fac: 2870726f 626c656d 20696c69 6b652027 (problem ilike ' 1fbc: 256c756e 67252729 0a090909 0909094f %lung%').......O 1fcc: 520a0909 09090928 70726f62 6c656d20 R......(problem 1fdc: 696c696b 65202725 70756c6d 6f6e2527 ilike '%pulmon%' 1fec: 290a0909 0909290a 09090929 0a090929 ).....)....)...) 1ffc: 0a29 .) Item 2 -- Length: 2028 Offset: 4416 (0x1140) Flags: NORMAL XMIN: 127844 XMAX: 0 CID|XVAC: 0 Block Id: 1 linp Index: 2 Attributes: 13 Size: 28 infomask: 0x0803 (HASNULL|HASVARWIDTH|XMAX_INVALID) t_bits: [0]: 0xff [1]: 0x1e 1140: 64f30100 00000000 00000000 00000100 d............... 1150: 02000d00 03081cff 1e000000 12360000 .............6.. 1160: 00000000 645b28e2 981c0200 676d2d64 ....d[(.....gm-d 1170: 626f0000 00000000 00000000 00000000 bo.............. 1180: 00000000 00000000 00000000 00000000 ................ 1190: 00000000 00000000 00000000 00000000 ................ 11a0: 00000000 00000000 00000000 0c000000 ................ 11b0: 240f0000 0a53454c 4543540a 092d2d20 $....SELECT..-- 11c0: 6265796f 6e642041 75677573 74203f20 beyond August ? 11d0: 2d3e2070 726f6261 626c7920 6f6e6c79 -> probably only 11e0: 2076616c 6964206f 6e207468 65204e6f valid on the No 11f0: 72746865 726e2048 656d6973 70686572 rthern Hemispher 1200: 650a0928 65787472 61637428 6d6f6e74 e..(extract(mont 1210: 68206672 6f6d206e 6f772829 29203e20 h from now()) > 1220: 38290a41 4e442045 58495354 5320280a 8).AND EXISTS (. 1230: 092d2d20 3e363020 79656172 730a0953 .-- >60 years..S 1240: 454c4543 54203120 46524f4d 2064656d ELECT 1 FROM dem 1250: 2e696465 6e746974 79205748 4552450a .identity WHERE. 1260: 09092870 6b203d20 49445f41 43544956 ..(pk = ID_ACTIV 1270: 455f5041 5449454e 54290a09 0909414e E_PATIENT)....AN 1280: 440a0909 28646f62 203c206e 6f772829 D...(dob < now() 1290: 202d2027 36302079 65617273 273a3a69 - '60 years'::i 12a0: 6e746572 76616c29 0a292041 4e442045 nterval).) AND E 12b0: 58495354 5320280a 2d2d2041 7374686d XISTS (.-- Asthm 12c0: 612f434f 50442f45 6d706879 73656d2f a/COPD/Emphysem/ 12d0: 4c756e67 656e6669 62726f73 650a5345 Lungenfibrose.SE 12e0: 4c454354 20312046 524f4d20 636c696e LECT 1 FROM clin 12f0: 2e765f70 726f626c 656d5f6c 69737420 .v_problem_list 1300: 57484552 450a0928 706b5f70 61746965 WHERE..(pk_patie 1310: 6e74203d 2049445f 41435449 56455f50 nt = ID_ACTIVE_P 1320: 41544945 4e54290a 0909414e 440a0928 ATIENT)...AND..( 1330: 092d2d20 73686f75 6c642063 6865636b .-- should check 1340: 20494350 432f4943 4431300a 09092870 ICPC/ICD10...(p 1350: 726f626c 656d2069 6c696b65 20272561 roblem ilike '%a 1360: 7374686d 61252729 0a090909 4f520a09 sthma%')....OR.. 1370: 09287072 6f626c65 6d20696c 696b6520 .(problem ilike 1380: 2725434f 50442527 290a0909 094f520a '%COPD%')....OR. 1390: 09092870 726f626c 656d2069 6c696b65 ..(problem ilike 13a0: 20272565 6d706879 73656d25 27290a09 '%emphysem%').. 13b0: 09094f52 0a090928 0a090909 2870726f ..OR...(....(pro 13c0: 626c656d 20696c69 6b652027 25666962 blem ilike '%fib 13d0: 726f7325 27290a09 09090941 4e440a09 ros%').....AND.. 13e0: 0909280a 09090909 2870726f 626c656d ..(.....(problem 13f0: 20696c69 6b652027 256c756e 67252729 ilike '%lung%') 1400: 0a090909 09094f52 0a090909 09287072 ......OR.....(pr 1410: 6f626c65 6d20696c 696b6520 27257075 oblem ilike '%pu 1420: 6c6d6f6e 2527290a 09090929 0a090929 lmon%')....)...) 1430: 0a09290a 2920414e 44204e4f 54204558 ..).) AND NOT EX 1440: 49535453 20280a2d 2d206b65 696e6520 ISTS (.-- keine 1450: 496d7066 756e6720 496e666c 75656e7a Impfung Influenz 1460: 6120696e 2064656e 206c6574 7a74656e a in den letzten 1470: 2036204d 6f6e6174 656e2072 c3bc636b 6 Monaten r..ck 1480: 626c6963 6b656e64 2c206661 6c6c7320 blickend, falls 1490: 77697220 696d2053 65707465 6d626572 wir im September 14a0: 2073696e 640a5345 4c454354 20312046 sind.SELECT 1 F 14b0: 524f4d20 636c696e 2e765f70 61745f76 ROM clin.v_pat_v 14c0: 61636373 34696e64 69636174 696f6e20 accs4indication 14d0: 57484552 450a0928 706b5f70 61746965 WHERE..(pk_patie 14e0: 6e74203d 2049445f 41435449 56455f50 nt = ID_ACTIVE_P 14f0: 41544945 4e54290a 0909414e 440a0928 ATIENT)...AND..( 1500: 696e6469 63617469 6f6e203d 2027696e indication = 'in 1510: 666c7565 6e7a6120 28736561 736f6e61 fluenza (seasona 1520: 6c292729 0a090941 4e440a09 64617465 l)')...AND..date 1530: 5f676976 656e203e 206e6f77 2829202d _given > now() - 1540: 20273620 6d6f6e74 6873273a 3a696e74 '6 months'::int 1550: 65727661 6c0a4f52 44455220 42590a09 erval.ORDER BY.. 1560: 64617465 5f676976 656e2044 4553430a date_given DESC. 1570: 4c494d49 5420310a 29454c75 6e67652d LIMIT 1.)ELunge- 1580: 3e496e66 6c75656e 7a612d49 6d706667 >Influenza-Impfg 1590: 20284447 502f4447 494d2991 4c756e67 (DGP/DGIM).Lung 15a0: 656e6b72 616e6b65 20c3a46c 74657220 enkranke ..lter 15b0: 36302073 6f6c6c65 6e206569 6e652049 60 sollen eine I 15c0: 6e666c75 656e7a61 696d7066 756e6720 nfluenzaimpfung 15d0: 616e6765 626f7465 6e206265 6b6f6d6d angeboten bekomm 15e0: 656e2e01 5f224765 6d65696e 73616d20 en.._"Gemeinsam 15f0: 6b6c7567 20656e74 73636865 6964656e klug entscheiden 1600: 22202844 47494d3a 20444750 2c203230 " (DGIM: DGP, 20 1610: 31362907 64650000 500c0000 53454c45 16).de..P...SELE 1620: 43540a28 092d2d20 6578706c 61696e0a CT.(.-- explain. 1630: 0953454c 45435420 45274573 20697374 .SELECT E'Es ist 1640: 20696e20 64656e20 6c65747a 74656e20 in den letzten 1650: 36204d6f 6e617465 6e206b65 696e6520 6 Monaten keine 1660: 496d7066 756e6720 67656765 6e20496e Impfung gegen In 1670: 666c7565 6e7a6120 646f6b75 6d656e74 fluenza dokument 1680: 69657274 2e5c6e5c 6e270a09 097c7c20 iert.\n\n'...|| 1690: 45274573 20736f6c 6c746520 65696e65 E'Es sollte eine 16a0: 20496d70 66756e67 20616e67 65626f74 Impfung angebot 16b0: 656e2077 65726465 6e2c2077 65696c5c en werden, weil\ 16c0: 6e270a09 092d2d20 6167650a 09097c7c n'...-- age...|| 16d0: 20272064 61732041 6c746572 20282720 ' das Alter (' 16e0: 7c7c2074 72696d28 6c656164 696e6720 || trim(leading 16f0: 27302720 66726f6d 20746f5f 63686172 '0' from to_char 1700: 286a7573 74696679 5f696e74 65727661 (justify_interva 1710: 6c286e6f 77282920 2d20646f 62292c20 l(now() - dob), 1720: 27595959 27292920 7c7c2045 2729203e 'YYY')) || E') > 1730: 20363020 4a616872 65206973 7420756e 60 Jahre ist un 1740: 645c6e27 0a094652 4f4d2064 656d2e69 d\n'..FROM dem.i 1750: 64656e74 69747920 57484552 4520706b dentity WHERE pk 1760: 203d2049 445f4143 54495645 5f504154 = ID_ACTIVE_PAT 1770: 49454e54 0a29207c 7c20280a 092d2d20 IENT.) || (..-- 1780: 70726f62 6c656d0a 0953454c 45435420 problem..SELECT 1790: 27206569 6e204c75 6e67656e 70726f62 ' ein Lungenprob 17a0: 6c656d20 2227207c 7c207072 6f626c65 lem "' || proble 17b0: 6d207c7c 20272220 646f6b75 6d656e74 m || '" dokument 17c0: 69657274 20697374 270a0946 524f4d20 iert ist'..FROM 17d0: 636c696e 2e765f70 726f626c 656d5f6c clin.v_problem_l 17e0: 69737420 57484552 450a0909 28706b5f ist WHERE...(pk_ 17f0: 70617469 656e7420 3d204944 5f414354 patient = ID_ACT 1800: 4956455f 50415449 454e5429 0a090909 IVE_PATIENT).... 1810: 414e440a 09092809 2d2d2073 686f756c AND...(.-- shoul 1820: 64206368 65636b20 49435043 2f494344 d check ICPC/ICD 1830: 31300a09 09092870 726f626c 656d2069 10....(problem i 1840: 6c696b65 20272561 7374686d 61252729 like '%asthma%') 1850: 0a090909 094f520a 09090928 70726f62 .....OR....(prob 1860: 6c656d20 696c696b 65202725 434f5044 lem ilike '%COPD 1870: 2527290a 09090909 4f520a09 09092870 %').....OR....(p 1880: 726f626c 656d2069 6c696b65 20272565 roblem ilike '%e 1890: 6d706879 73656d25 27290a09 0909094f mphysem%').....O 18a0: 520a0909 09280a09 09090928 70726f62 R....(.....(prob 18b0: 6c656d20 696c696b 65202725 66696272 lem ilike '%fibr 18c0: 6f732527 290a0909 09090941 4e440a09 os%')......AND.. 18d0: 09090928 0a090909 09092870 726f626c ...(......(probl 18e0: 656d2069 6c696b65 2027256c 756e6725 em ilike '%lung% 18f0: 27290a09 09090909 094f520a 09090909 ').......OR..... 1900: 09287072 6f626c65 6d20696c 696b6520 .(problem ilike 1910: 27257075 6c6d6f6e 2527290a 09090909 '%pulmon%')..... 1920: 290a0909 09290a09 09290a29 )....)...).) Item 3 -- Length: 1253 Offset: 3160 (0x0c58) Flags: NORMAL XMIN: 127845 XMAX: 0 CID|XVAC: 0 Block Id: 1 linp Index: 3 Attributes: 13 Size: 28 infomask: 0x0803 (HASNULL|HASVARWIDTH|XMAX_INVALID) t_bits: [0]: 0xff [1]: 0x1e 0c58: 65f30100 00000000 00000000 00000100 e............... 0c68: 03000d00 03081cff 1e000000 13360000 .............6.. 0c78: 00000000 b18228e2 981c0200 676d2d64 ......(.....gm-d 0c88: 626f0000 00000000 00000000 00000000 bo.............. 0c98: 00000000 00000000 00000000 00000000 ................ 0ca8: 00000000 00000000 00000000 00000000 ................ 0cb8: 00000000 00000000 00000000 0d000000 ................ 0cc8: 3c080000 53454c45 43542045 58495354 <...SELECT EXIST 0cd8: 5320280a 092d2d20 74616b65 73206f78 S (..-- takes ox 0ce8: 7967656e 0a095345 4c454354 20312046 ygen..SELECT 1 F 0cf8: 524f4d20 636c696e 2e765f73 75627374 ROM clin.v_subst 0d08: 616e6365 5f696e74 616b6573 20574845 ance_intakes WHE 0d18: 52450a09 0928706b 5f706174 69656e74 RE...(pk_patient 0d28: 203d2049 445f4143 54495645 5f504154 = ID_ACTIVE_PAT 0d38: 49454e54 290a0909 09414e44 0a090928 IENT)....AND...( 0d48: 6174635f 73756273 74616e63 65203d20 atc_substance = 0d58: 27563033 414e3031 2729092d 2d206f78 'V03AN01').-- ox 0d68: 7967656e 0a090909 414e440a 09092828 ygen....AND...(( 0d78: 64697363 6f6e7469 6e756564 20495320 discontinued IS 0d88: 4e554c4c 29204f52 20286469 73636f6e NULL) OR (discon 0d98: 74696e75 6564203e 206e6f77 28292929 tinued > now())) 0da8: 0a292041 4e44204e 4f542045 58495354 .) AND NOT EXIST 0db8: 5320280a 092d2d20 6e6f2042 4741206f S (..-- no BGA o 0dc8: 72205370 4f322077 69746869 6e206c61 r SpO2 within la 0dd8: 73742033 206d6f6e 7468730a 0953454c st 3 months..SEL 0de8: 45435420 31204652 4f4d2063 6c696e2e ECT 1 FROM clin. 0df8: 765f7465 73745f72 6573756c 74732057 v_test_results W 0e08: 48455245 0a090928 706b5f70 61746965 HERE...(pk_patie 0e18: 6e74203d 2049445f 41435449 56455f50 nt = ID_ACTIVE_P 0e28: 41544945 4e54290a 09090941 4e440a09 ATIENT)....AND.. 0e38: 0928756e 69666965 645f6c6f 696e6320 .(unified_loinc 0e48: 494e2028 73656c65 63742063 6f646520 IN (select code 0e58: 66726f6d 20726566 2e6c6f69 6e632077 from ref.loinc w 0e68: 68657265 20746572 6d20696c 696b6520 here term ilike 0e78: 27256f78 7967656e 25272061 6e642074 '%oxygen%' and t 0e88: 65726d20 696c696b 65202725 70726573 erm ilike '%pres 0e98: 73757265 25272929 0a090909 414e440a sure%'))....AND. 0ea8: 09092863 6c696e5f 7768656e 203e206e ..(clin_when > n 0eb8: 6f772829 202d2027 33206d6f 6e746873 ow() - '3 months 0ec8: 273a3a69 6e746572 76616c29 0a293b3f '::interval).);? 0ed8: 4fc2b22d 47616265 2d3e4247 412f5370 O..-Gabe->BGA/Sp 0ee8: 4fc2b220 28444750 2f444749 4d29a142 O.. (DGP/DGIM).B 0ef8: 65692061 6d62756c 616e7465 72204fc2 ei ambulanter O. 0f08: b22d5468 65726170 69652073 6f6c6c20 .-Therapie soll 0f18: 616c6c65 72203320 4d6f6e61 74652064 aller 3 Monate d 0f28: 69652049 6e64696b 6174696f 6e206765 ie Indikation ge 0f38: 7072c3bc 66742077 65726465 6e2e015f pr..ft werden.._ 0f48: 2247656d 65696e73 616d206b 6c756720 "Gemeinsam klug 0f58: 656e7473 63686569 64656e22 20284447 entscheiden" (DG 0f68: 494d3a20 4447502c 20323031 36290764 IM: DGP, 2016).d 0f78: 65000000 04070000 0a53454c 45435420 e........SELECT 0f88: 636f616c 65736365 20280a09 2853454c coalesce (..(SEL 0f98: 4543540a 09092744 69652048 79706f78 ECT...'Die Hypox 0fa8: c3a46d69 65207775 72646520 7a756c65 ..mie wurde zule 0fb8: 747a7420 696d2027 207c7c20 746f5f63 tzt im ' || to_c 0fc8: 68617228 636c696e 5f776865 6e2c2027 har(clin_when, ' 0fd8: 4d6f6e20 59595959 2729207c 7c202720 Mon YYYY') || ' 0fe8: c3bc6265 727072c3 bc66742e 270a0946 ..berpr..ft.'..F 0ff8: 524f4d20 636c696e 2e765f74 6573745f ROM clin.v_test_ 1008: 72657375 6c747320 57484552 450a0909 results WHERE... 1018: 28706b5f 70617469 656e7420 3d204944 (pk_patient = ID 1028: 5f414354 4956455f 50415449 454e5429 _ACTIVE_PATIENT) 1038: 0a090909 414e440a 09092875 6e696669 ....AND...(unifi 1048: 65645f6c 6f696e63 20494e20 2873656c ed_loinc IN (sel 1058: 65637420 636f6465 2066726f 6d207265 ect code from re 1068: 662e6c6f 696e6320 77686572 65207465 f.loinc where te 1078: 726d2069 6c696b65 2027256f 78796765 rm ilike '%oxyge 1088: 6e252720 616e6420 7465726d 20696c69 n%' and term ili 1098: 6b652027 25707265 73737572 65252729 ke '%pressure%') 10a8: 290a094f 52444552 2042590a 0909636c )..ORDER BY...cl 10b8: 696e5f77 68656e20 44455343 0a094c49 in_when DESC..LI 10c8: 4d495420 310a0929 3a3a7465 78742c0a MIT 1..)::text,. 10d8: 09285345 4c454354 20274573 20697374 .(SELECT 'Es ist 10e8: 206b6569 6e6520c3 9c626572 7072c3bc keine ..berpr.. 10f8: 66756e67 20646572 20487970 6f78c3a4 fung der Hypox.. 1108: 6d696520 696e2064 656e206c 65747a74 mie in den letzt 1118: 656e2033 204d6f6e 6174656e 20646f6b en 3 Monaten dok 1128: 756d656e 74696572 742e273a 3a746578 umentiert.'::tex 1138: 74290a29 3b t).); Item 4 -- Length: 917 Offset: 2240 (0x08c0) Flags: NORMAL XMIN: 127847 XMAX: 0 CID|XVAC: 0 Block Id: 1 linp Index: 4 Attributes: 13 Size: 28 infomask: 0x0803 (HASNULL|HASVARWIDTH|XMAX_INVALID) t_bits: [0]: 0xff [1]: 0x1e 08c0: 67f30100 00000000 00000000 00000100 g............... 08d0: 04000d00 03081cff 1e000000 15360000 .............6.. 08e0: 00000000 b42e3be2 981c0200 676d2d64 ......;.....gm-d 08f0: 626f0000 00000000 00000000 00000000 bo.............. 0900: 00000000 00000000 00000000 00000000 ................ 0910: 00000000 00000000 00000000 00000000 ................ 0920: 00000000 00000000 00000000 0e000000 ................ 0930: fc060000 2d2d2070 7265676e 616e6379 ....-- pregnancy 0940: 20636865 636b0a53 454c4543 54204558 check.SELECT EX 0950: 49535453 20280a09 53454c45 43542031 ISTS (..SELECT 1 0960: 2046524f 4d20636c 696e2e70 61746965 FROM clin.patie 0970: 6e742057 48455245 0a090966 6b5f6964 nt WHERE...fk_id 0980: 656e7469 7479203d 2049445f 41435449 entity = ID_ACTI 0990: 56455f50 41544945 4e540a09 0909414e VE_PATIENT....AN 09a0: 440a0909 636f616c 65736365 28656463 D...coalesce(edc 09b0: 20424554 5745454e 206e6f77 2829202d BETWEEN now() - 09c0: 20273120 6d6f6e74 68273a3a 696e7465 '1 month'::inte 09d0: 7276616c 20414e44 206e6f77 2829202b rval AND now() + 09e0: 20273131 206d6f6e 74687327 3a3a696e '11 months'::in 09f0: 74657276 616c2c20 46414c53 45290a2d terval, FALSE).- 0a00: 2d206275 74206e6f 206a6f64 20696e20 - but no jod in 0a10: 6d656469 63617469 6f6e0a29 20414e44 medication.) AND 0a20: 204e4f54 20455849 53545320 280a0953 NOT EXISTS (..S 0a30: 454c4543 54203120 46524f4d 20636c69 ELECT 1 FROM cli 0a40: 6e2e765f 73756273 74616e63 655f696e n.v_substance_in 0a50: 74616b65 73205748 4552450a 09092870 takes WHERE...(p 0a60: 6b5f7061 7469656e 74203d20 49445f41 k_patient = ID_A 0a70: 43544956 455f5041 5449454e 54290a09 CTIVE_PATIENT).. 0a80: 0909414e 440a0909 2d2d2069 6f64696e ..AND...-- iodin 0a90: 650a0909 28617463 5f737562 7374616e e...(atc_substan 0aa0: 6365203d 20274430 38414730 3327290a ce = 'D08AG03'). 0ab0: 09090941 4e440a09 09282864 6973636f ...AND...((disco 0ac0: 6e74696e 75656420 4953204e 554c4c29 ntinued IS NULL) 0ad0: 204f5220 28646973 636f6e74 696e7565 OR (discontinue 0ae0: 64203e20 6e6f7728 2929290a 09293b41 d > now()))..);A 0af0: 53636877 616e6765 72736368 6166742d Schwangerschaft- 0b00: 3e4a6f64 20284447 452f4447 494d2977 >Jod (DGE/DGIM)w 0b10: 53636877 616e6765 72656e20 736f6c6c Schwangeren soll 0b20: 2065696e 65204a6f 64737570 706c656d eine Jodsupplem 0b30: 656e7461 74696f6e 20616e67 65626f74 entation angebot 0b40: 656e2077 65726465 6e2e015f 2247656d en werden.._"Gem 0b50: 65696e73 616d206b 6c756720 656e7473 einsam klug ents 0b60: 63686569 64656e22 20284447 494d3a20 cheiden" (DGIM: 0b70: 4447452c 20323031 36290764 65000000 DGE, 2016).de... 0b80: 54030000 53454c45 43540a09 09275061 T...SELECT...'Pa 0b90: 7469656e 74696e20 69737420 73636877 tientin ist schw 0ba0: 616e6765 72202827 0a090909 7c7c2027 anger ('....|| ' 0bb0: 5465726d 696e3a20 270a0909 097c7c20 Termin: '....|| 0bc0: 746f5f63 68617228 6564632c 20275959 to_char(edc, 'YY 0bd0: 5959204d 6f6e2044 4427290a 0909097c YY Mon DD')....| 0be0: 7c202729 2c206e69 6d6d7420 61626572 | '), nimmt aber 0bf0: 206b6569 6e204a6f 64205b44 30384147 kein Jod [D08AG 0c00: 30335d2e 270a0909 61732072 65636f6d 03].'...as recom 0c10: 6d656e64 6174696f 6e0a0946 524f4d20 mendation..FROM 0c20: 636c696e 2e706174 69656e74 0a095748 clin.patient..WH 0c30: 45524520 666b5f69 64656e74 69747920 ERE fk_identity 0c40: 3d204944 5f414354 4956455f 50415449 = ID_ACTIVE_PATI 0c50: 454e543b 0a ENT;. Item 5 -- Length: 1132 Offset: 1108 (0x0454) Flags: NORMAL XMIN: 127858 XMAX: 0 CID|XVAC: 0 Block Id: 1 linp Index: 5 Attributes: 13 Size: 28 infomask: 0x0803 (HASNULL|HASVARWIDTH|XMAX_INVALID) t_bits: [0]: 0xff [1]: 0x1e 0454: 72f30100 00000000 00000000 00000100 r............... 0464: 05000d00 03081cff 1e000000 1d360000 .............6.. 0474: 00000000 df6d77e2 981c0200 676d2d64 .....mw.....gm-d 0484: 626f0000 00000000 00000000 00000000 bo.............. 0494: 00000000 00000000 00000000 00000000 ................ 04a4: 00000000 00000000 00000000 00000000 ................ 04b4: 00000000 00000000 00000000 0f000000 ................ 04c4: fc040000 53454c45 43542045 58495354 ....SELECT EXIST 04d4: 5320280a 09095345 4c454354 20312046 S (...SELECT 1 F 04e4: 524f4d20 636c696e 2e765f6e 6f6e6272 ROM clin.v_nonbr 04f4: 616e645f 696e7461 6b657320 57484552 and_intakes WHER 0504: 450a0909 0928706b 5f706174 69656e74 E....(pk_patient 0514: 203d2049 445f4143 54495645 5f504154 = ID_ACTIVE_PAT 0524: 49454e54 290a0909 0909414e 440a0909 IENT).....AND... 0534: 09286174 635f7375 62737461 6e636520 .(atc_substance 0544: 3d20274e 30374241 30312729 0a090909 = 'N07BA01').... 0554: 09414e44 0a090909 28636f61 6c657363 .AND....(coalesc 0564: 65286861 726d6675 6c5f7573 655f7479 e(harmful_use_ty 0574: 70652c20 2d312920 494e2028 312c3229 pe, -1) IN (1,2) 0584: 290a0909 0909414e 440a0909 09282864 ).....AND....((d 0594: 6973636f 6e74696e 75656420 4953204e iscontinued IS N 05a4: 554c4c29 204f5220 28646973 636f6e74 ULL) OR (discont 05b4: 696e7565 64203e20 6e6f7728 2929290a inued > now())). 05c4: 09090909 414e440a 09090928 6c617374 ....AND....(last 05d4: 5f636865 636b6564 5f776865 6e203c20 _checked_when < 05e4: 6e6f7728 29202d20 27312079 65617227 now() - '1 year' 05f4: 3a3a696e 74657276 616c290a 09293b4d ::interval)..);M 0604: 4f757464 61746564 20736d6f 6b696e67 Outdated smoking 0614: 20737461 74757320 646f6375 6d656e74 status document 0624: 6174696f 6e93536d 6f6b696e 67207374 ation.Smoking st 0634: 61747573 20776173 206c6173 74207265 atus was last re 0644: 636f7264 6564206d 6f726520 7468616e corded more than 0654: 206f6e65 20796561 72206167 6f20666f one year ago fo 0664: 72207468 69732073 6d6f6b65 722e0149 r this smoker..I 0674: 41574d46 204e564c 20536368 c3a4646c AWMF NVL Sch..dl 0684: 69636865 72205461 62616b67 65627261 icher Tabakgebra 0694: 75636807 656e0000 90080000 53454c45 uch.en......SELE 06a4: 43540a09 095f2827 536d6f6b 696e6720 CT..._('Smoking 06b4: 73746174 75732729 207c7c20 45275c6e status') || E'\n 06c4: 270a0909 7c7c2027 2027207c 7c205f28 '...|| ' ' || _( 06d4: 274c6173 74206368 65636b65 643a2729 'Last checked:') 06e4: 207c7c20 27202720 7c7c2074 6f5f6368 || ' ' || to_ch 06f4: 6172286c 6173745f 63686563 6b65645f ar(last_checked_ 0704: 7768656e 2c20274d 6f6e2059 59595927 when, 'Mon YYYY' 0714: 290a0909 7c7c2028 63617365 0a090909 )...|| (case.... 0724: 09776865 6e206861 726d6675 6c5f7573 .when harmful_us 0734: 655f7479 7065203d 20312074 68656e20 e_type = 1 then 0744: 45275c6e 27207c7c 205f2827 6861726d E'\n' || _('harm 0754: 66756c20 75736527 290a0909 09097768 ful use').....wh 0764: 656e2068 61726d66 756c5f75 73655f74 en harmful_use_t 0774: 79706520 3d203220 7468656e 2045275c ype = 2 then E'\ 0784: 6e27207c 7c205f28 27616464 69637469 n' || _('addicti 0794: 6f6e2729 0a090909 09776865 6e206861 on').....when ha 07a4: 726d6675 6c5f7573 655f7479 7065203d rmful_use_type = 07b4: 20332074 68656e20 45275c6e 27207c7c 3 then E'\n' || 07c4: 205f2827 70726576 696f7573 20616464 _('previous add 07d4: 69637469 6f6e2729 0a090909 656e6429 iction')....end) 07e4: 0a09097c 7c20636f 616c6573 63652845 ...|| coalesce(E 07f4: 275c6e20 27207c7c 205f2827 51756974 '\n ' || _('Quit 0804: 20646174 653a2729 207c7c20 27202720 date:') || ' ' 0814: 7c7c2074 6f5f6368 61722864 6973636f || to_char(disco 0824: 6e74696e 7565642c 20275959 5959204d ntinued, 'YYYY M 0834: 6f6e2044 4427292c 20272729 0a09097c on DD'), '')...| 0844: 7c20636f 616c6573 63652845 275c6e20 | coalesce(E'\n 0854: 27207c7c 205f2827 4e6f7465 733a2729 ' || _('Notes:') 0864: 207c7c20 27202720 7c7c206e 6f746573 || ' ' || notes 0874: 2c202727 290a0946 524f4d0a 0909636c , '')..FROM...cl 0884: 696e2e76 5f6e6f6e 6272616e 645f696e in.v_nonbrand_in 0894: 74616b65 730a0957 48455245 20706b5f takes..WHERE pk_ 08a4: 70617469 656e7420 3d204944 5f414354 patient = ID_ACT 08b4: 4956455f 50415449 454e543b IVE_PATIENT; *** End of File Encountered. Last Block Read: 1 ***