Finished outstanding doc TODOs in meta document. (#6987)
[openemr.git] / Documentation / EHI_Export / docs / tables / procedure_result.html
blob0a5c65a010e27b94aec51bab2b72139449e8e572
1 <!DOCTYPE html>
2 <html>
3 <head>
4 <meta charset="utf-8">
5 <meta http-equiv="X-UA-Compatible" content="IE=edge">
6 <title>procedure_result - openemr.openemr</title>
7 <!-- Tell the browser to be responsive to screen width -->
8 <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
9 <link rel="icon" type="image/png" sizes="16x16" href="../favicon.png">
10 <!-- Bootstrap 3.3.5 -->
11 <link rel="stylesheet" href="../bower/admin-lte/bootstrap/css/bootstrap.min.css">
12 <!-- Font Awesome -->
13 <link rel="stylesheet" href="../bower/font-awesome/css/font-awesome.min.css">
14 <!-- Ionicons -->
15 <link rel="stylesheet" href="../bower/ionicons/css/ionicons.min.css">
16 <!-- DataTables -->
17 <link rel="stylesheet" href="../bower/datatables.net-bs/css/dataTables.bootstrap.min.css">
18 <link rel="stylesheet" href="../bower/datatables.net-buttons-bs/css/buttons.bootstrap.min.css">
19 <!-- Code Mirror -->
20 <link rel="stylesheet" href="../bower/codemirror/codemirror.css">
21 <!-- Fonts -->
22 <link href='../fonts/indieflower/indie-flower.css' rel='stylesheet' type='text/css'>
23 <link href='../fonts/source-sans-pro/source-sans-pro.css' rel='stylesheet' type='text/css'>
25 <!-- Theme style -->
26 <link rel="stylesheet" href="../bower/admin-lte/dist/css/AdminLTE.min.css">
27 <!-- Salvattore -->
28 <link rel="stylesheet" href="../bower/salvattore/salvattore.css">
29 <!-- AdminLTE Skins. Choose a skin from the css/skins
30 folder instead of downloading all of them to reduce the load. -->
31 <link rel="stylesheet" href="../bower/admin-lte/dist/css/skins/_all-skins.min.css">
32 <!-- SchemaSpy -->
33 <link rel="stylesheet" href="../schemaSpy.css">
35 <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
36 <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
37 <!--[if lt IE 9]>
38 <script src="../bower/html5shiv/html5shiv.min.js"></script>
39 <script src="../bower/respond/respond.min.js"></script>
40 <![endif]-->
41 </head>
42 <!-- ADD THE CLASS layout-top-nav TO REMOVE THE SIDEBAR. -->
43 <body class="hold-transition skin-blue layout-top-nav">
44 <div class="wrapper">
45 <header class="main-header">
46 <nav class="navbar navbar-static-top">
47 <div class="container">
48 <div class="navbar-header">
49 <a href="../index.html" class="navbar-brand"><b>openemr</b></a><span class="navbar-brand" style="padding-left: 0">.openemr</span>
50 <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar-collapse"><i class="fa fa-bars"></i></button>
51 </div>
53 <!-- Collect the nav links, forms, and other content for toggling -->
54 <div class="collapse navbar-collapse pull-left" id="navbar-collapse">
55 <ul class="nav navbar-nav">
56 <li><a href="../index.html">Tables <span class="sr-only">(current)</span></a></li>
57 <li><a href="../columns.html" title="All of the columns in the schema">Columns</a></li>
58 <!-- <li><a href="../constraints.html" title="Useful for diagnosing error messages that just give constraint name or number">Constraints</a></li>-->
59 <li><a href="../relationships.html" title="Diagram of table relationships">Relationships</a></li>
60 <!-- <li><a href="../orphans.html" title="View of tables with neither parents nor children">Orphan&nbsp;Tables</a></li> -->
61 <!-- <li><a href="../anomalies.html" title="Things that might not be quite right">Anomalies</a></li> -->
62 <!-- <li><a href="../routines.html" title="Procedures and functions">Routines</a></li> -->
63 </ul>
64 </div>
65 <!-- /.navbar-collapse -->
66 <!-- Navbar Right Menu -->
67 </div>
68 <!-- /.container-fluid -->
69 </nav>
70 </header>
71 <!-- Main content -->
72 <!-- Full Width Column -->
73 <div class="content-wrapper">
74 <!-- Content Header (Page header) -->
75 <section class="content-header">
76 <h1>procedure_result</h1><br />
77 <p>If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of procedure_result.csv</p>
78 <p>If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element</p>
79 <div class="box box-primary">
80 <div class="box-header with-border">
81 <i class="fa fa-file-text-o"></i>
82 <h3 id="Description" class="box-title">Description</h3>
83 <div class="box-tools pull-right">
84 <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button>
85 <button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button>
86 </div>
87 </div><!-- /.box-header -->
88 <div class="box-body clearfix">
89 <p>The table stores the actual results and findings from medical procedures and tests, such as laboratory tests, radiology reports, diagnostic imaging, and other clinical tests.</p>
90 </div><!-- /.box-body -->
91 </div>
92 </section>
93 <!-- Main content -->
94 <section class="content">
95 <div class="box box-primary">
96 <div class="box-header with-border">
97 <span class="glyphicon glyphicon-list-alt" aria-hidden="true"></span>
98 <h3 id="Columns" class="box-title">Columns</h3>
99 <div class="box-tools pull-right">
100 <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button>
101 <button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button>
102 </div>
103 </div>
104 <div class="box-body">
105 <table
106 id="standard_table"
107 class="table table-bordered table-striped dataTable"
108 role="grid"
109 data-paging="false"
110 data-page-length="10"
111 data-length-change="false">
112 <thead align='left'>
113 <tr>
114 <th>Column</th>
115 <th>Type</th>
116 <th>Size</th>
117 <th title='Are nulls allowed?'>Nulls</th>
118 <th title='Is column automatically updated?'>Auto</th>
119 <th title='Default value'>Default</th>
120 <th title='Columns in tables that reference this column'>Children</th>
121 <th title='Columns in tables that are referenced by this column'>Parents</th>
122 <th title='Comments' class="toggle"><span>Comments</span></th>
123 </tr>
124 </thead>
125 <tbody>
126 <tr>
127 <td class='primaryKey' title='Primary Key'><i class='icon ion-key iconkey' style='padding-left: 5px;'></i><span id="procedure_result_id">procedure_result_id</span></td>
128 <td>BIGINT</td>
129 <td>19</td>
130 <td title=''></td>
131 <td title='Automatically updated by the database'></td>
132 <td>null</td>
133 <td>
134 <table border='0' cellspacing='0' cellpadding='0'>
135 </table>
136 </td>
137 <td>
138 <table border='0' cellspacing='0' cellpadding='0'>
139 </table>
140 </td>
141 <td><p>Surrogate id of the record used as the primary incrementing key</p></td>
142 </tr>
143 <tr>
144 <td class='indexedColumn' title='Indexed'><i class='fa fa-sitemap fa-rotate-120' style='padding-right: 5px;'></i><span id="uuid">uuid</span></td>
145 <td>BINARY</td>
146 <td>16</td>
147 <td title='nullable'></td>
148 <td title=''></td>
149 <td>null</td>
150 <td>
151 <table border='0' cellspacing='0' cellpadding='0'>
152 </table>
153 </td>
154 <td>
155 <table border='0' cellspacing='0' cellpadding='0'>
156 </table>
157 </td>
158 <td><p>UUID of the record</p></td>
159 </tr>
160 <tr>
161 <td class='foreignKey' title='Foreign Key'><i class='icon ion-key iconkey' style='padding-left: 5px;'></i><span id="procedure_report_id">procedure_report_id</span></td>
162 <td>BIGINT</td>
163 <td>19</td>
164 <td title=''></td>
165 <td title=''></td>
166 <td>null</td>
167 <td>
168 <table border='0' cellspacing='0' cellpadding='0'>
169 </table>
170 </td>
171 <td>
172 <table border='0' cellspacing='0' cellpadding='0'>
173 <tr>
174 <td title="procedure_result.procedure_report_id references procedure_report.procedure_report_id"><a href='procedure_report.html'>procedure_report</a><span class='relatedKey'>.procedure_report_id</span></td>
175 <td class="constraint detail">Defined in XML</td>
176 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
177 </tr>
178 </table>
179 </td>
180 <td><p>references procedure_report.procedure_report_id</p></td>
181 </tr>
182 <tr>
183 <td><span id="result_data_type">result_data_type</span></td>
184 <td>CHAR</td>
185 <td>1</td>
186 <td title=''></td>
187 <td title=''></td>
188 <td>S</td>
189 <td>
190 <table border='0' cellspacing='0' cellpadding='0'>
191 </table>
192 </td>
193 <td>
194 <table border='0' cellspacing='0' cellpadding='0'>
195 </table>
196 </td>
197 <td><p>N=Numeric, S=String, F=Formatted, E=External, L=Long text as the first line of comments</p></td>
198 </tr>
199 <tr>
200 <td><span id="result_code">result_code</span></td>
201 <td>VARCHAR</td>
202 <td>31</td>
203 <td title=''></td>
204 <td title=''></td>
205 <td></td>
206 <td>
207 <table border='0' cellspacing='0' cellpadding='0'>
208 </table>
209 </td>
210 <td>
211 <table border='0' cellspacing='0' cellpadding='0'>
212 </table>
213 </td>
214 <td><p>LOINC code, might match a procedure_type.procedure_code</p></td>
215 </tr>
216 <tr>
217 <td><span id="result_text">result_text</span></td>
218 <td>VARCHAR</td>
219 <td>255</td>
220 <td title=''></td>
221 <td title=''></td>
222 <td></td>
223 <td>
224 <table border='0' cellspacing='0' cellpadding='0'>
225 </table>
226 </td>
227 <td>
228 <table border='0' cellspacing='0' cellpadding='0'>
229 </table>
230 </td>
231 <td><p>Description of result_code</p></td>
232 </tr>
233 <tr>
234 <td><span id="date">date</span></td>
235 <td>DATETIME</td>
236 <td>19</td>
237 <td title='nullable'></td>
238 <td title=''></td>
239 <td>null</td>
240 <td>
241 <table border='0' cellspacing='0' cellpadding='0'>
242 </table>
243 </td>
244 <td>
245 <table border='0' cellspacing='0' cellpadding='0'>
246 </table>
247 </td>
248 <td><p>Lab-provided date specific to this result</p></td>
249 </tr>
250 <tr>
251 <td><span id="facility">facility</span></td>
252 <td>VARCHAR</td>
253 <td>255</td>
254 <td title=''></td>
255 <td title=''></td>
256 <td></td>
257 <td>
258 <table border='0' cellspacing='0' cellpadding='0'>
259 </table>
260 </td>
261 <td>
262 <table border='0' cellspacing='0' cellpadding='0'>
263 </table>
264 </td>
265 <td><p>Lab-provided testing facility ID</p></td>
266 </tr>
267 <tr>
268 <td><span id="units">units</span></td>
269 <td>VARCHAR</td>
270 <td>31</td>
271 <td title=''></td>
272 <td title=''></td>
273 <td></td>
274 <td>
275 <table border='0' cellspacing='0' cellpadding='0'>
276 </table>
277 </td>
278 <td>
279 <table border='0' cellspacing='0' cellpadding='0'>
280 </table>
281 </td>
282 <td><p>Units for the result</p></td>
283 </tr>
284 <tr>
285 <td><span id="result">result</span></td>
286 <td>VARCHAR</td>
287 <td>255</td>
288 <td title=''></td>
289 <td title=''></td>
290 <td></td>
291 <td>
292 <table border='0' cellspacing='0' cellpadding='0'>
293 </table>
294 </td>
295 <td>
296 <table border='0' cellspacing='0' cellpadding='0'>
297 </table>
298 </td>
299 <td><p>Result data</p></td>
300 </tr>
301 <tr>
302 <td><span id="range">range</span></td>
303 <td>VARCHAR</td>
304 <td>255</td>
305 <td title=''></td>
306 <td title=''></td>
307 <td></td>
308 <td>
309 <table border='0' cellspacing='0' cellpadding='0'>
310 </table>
311 </td>
312 <td>
313 <table border='0' cellspacing='0' cellpadding='0'>
314 </table>
315 </td>
316 <td><p>Result range</p></td>
317 </tr>
318 <tr>
319 <td><span id="abnormal">abnormal</span></td>
320 <td>VARCHAR</td>
321 <td>31</td>
322 <td title=''></td>
323 <td title=''></td>
324 <td></td>
325 <td>
326 <table border='0' cellspacing='0' cellpadding='0'>
327 </table>
328 </td>
329 <td>
330 <table border='0' cellspacing='0' cellpadding='0'>
331 </table>
332 </td>
333 <td><p>Abnormal values (no, yes, high, low)</p></td>
334 </tr>
335 <tr>
336 <td><span id="comments">comments</span></td>
337 <td>TEXT</td>
338 <td>65535</td>
339 <td title='nullable'></td>
340 <td title=''></td>
341 <td>null</td>
342 <td>
343 <table border='0' cellspacing='0' cellpadding='0'>
344 </table>
345 </td>
346 <td>
347 <table border='0' cellspacing='0' cellpadding='0'>
348 </table>
349 </td>
350 <td><p>Comments from the lab</p></td>
351 </tr>
352 <tr>
353 <td class='foreignKey' title='Foreign Key'><i class='icon ion-key iconkey' style='padding-left: 5px;'></i><span id="document_id">document_id</span></td>
354 <td>BIGINT</td>
355 <td>19</td>
356 <td title=''></td>
357 <td title=''></td>
358 <td>0</td>
359 <td>
360 <table border='0' cellspacing='0' cellpadding='0'>
361 </table>
362 </td>
363 <td>
364 <table border='0' cellspacing='0' cellpadding='0'>
365 <tr>
366 <td title="procedure_result.document_id references documents.id"><a href='documents.html'>documents</a><span class='relatedKey'>.id</span></td>
367 <td class="constraint detail">Defined in XML</td>
368 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
369 </tr>
370 </table>
371 </td>
372 <td><p>References documents.id if this result is a document</p></td>
373 </tr>
374 <tr>
375 <td><span id="result_status">result_status</span></td>
376 <td>VARCHAR</td>
377 <td>31</td>
378 <td title=''></td>
379 <td title=''></td>
380 <td></td>
381 <td>
382 <table border='0' cellspacing='0' cellpadding='0'>
383 </table>
384 </td>
385 <td>
386 <table border='0' cellspacing='0' cellpadding='0'>
387 </table>
388 </td>
389 <td><p>Result status (preliminary, cannot be done, final, corrected, incomplete, etc.)</p></td>
390 </tr>
391 <tr>
392 <td><span id="date_end">date_end</span></td>
393 <td>DATETIME</td>
394 <td>19</td>
395 <td title='nullable'></td>
396 <td title=''></td>
397 <td>null</td>
398 <td>
399 <table border='0' cellspacing='0' cellpadding='0'>
400 </table>
401 </td>
402 <td>
403 <table border='0' cellspacing='0' cellpadding='0'>
404 </table>
405 </td>
406 <td><p>Lab-provided end date specific to this result</p></td>
407 </tr>
408 </tbody>
409 </table>
410 </div>
411 </div>
412 <div class="box box-primary">
413 <div class="box-header with-border">
414 <i class="fa fa-sitemap"></i>
415 <h3 id="Indexes" class="box-title">Indexes</h3>
416 <div class="box-tools pull-right">
417 <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button>
418 <button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button>
419 </div>
420 </div>
421 <div class="box-body">
422 <table
423 id="indexes_table"
424 class="table table-bordered table-striped dataTable"
425 role="grid"
426 data-paging="false"
427 data-page-length="10"
428 data-length-change="false">
429 <thead>
430 <tr>
431 <th>Constraint Name</th>
432 <th>Type</th>
433 <th>Sort</th>
434 <th>Column(s)</th>
435 </tr>
436 </thead>
437 <tbody>
438 <tr>
439 <td class='primaryKey' title='Primary Key'><i class='icon ion-key iconkey'></i> PRIMARY</td>
440 <td>Primary key</td>
441 <td><span title='Ascending'>Asc</span></td>
442 <td>procedure_result_id</td>
443 </tr>
444 <tr>
445 <td title='Indexed'>procedure_report_id</td>
446 <td>Performance</td>
447 <td><span title='Ascending'>Asc</span></td>
448 <td>procedure_report_id</td>
449 </tr>
450 <tr>
451 <td class='uniqueKey' title='Unique Key'><i class='icon ion-key iconkey'></i> uuid</td>
452 <td>Must be unique</td>
453 <td><span title='Ascending'>Asc</span></td>
454 <td>uuid</td>
455 </tr>
456 </tbody>
457 </table>
458 </div><!-- /.box-body -->
459 </div>
460 <div class="box box-primary">
461 <div class="box-header with-border">
462 <i class="fa fa-code-fork"></i>
463 <h3 id="Relationships" class="box-title">Relationships</h3>
464 <div class="box-tools pull-right">
465 <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button>
466 <button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button>
467 </div>
468 </div>
469 <div class="box-body">
470 <div class="nav-tabs-custom"><!-- Tabs within a box -->
471 <h5>Close relationships within degrees of separation</h5>
472 <ul class="nav nav-tabs pull-left ui-sortable-handle">
473 <li class="active"><a href="#oneDegreeImg-chart" data-toggle="tab" aria-expanded="true">One</a></li>
474 <li class=""><a href="#twodegreesDegreeImg-chart" data-toggle="tab" aria-expanded="true">Two degrees</a></li>
475 </ul>
476 <div class="tab-content no-padding">
477 <div class="chart tab-pane active" id="oneDegreeImg-chart" style="position: relative; overflow-x:auto;">
479 <a name='diagram'><object type="image/svg+xml" id="oneDegreeImg" data="../diagrams/tables/procedure_result.1degree.svg" class="diagram" border="0" align="left"></object></a>
480 </div>
481 <div class="chart tab-pane " id="twodegreesDegreeImg-chart" style="position: relative; overflow-x:auto;">
483 <a name='diagram'><object type="image/svg+xml" id="twodegreesDegreeImg" data="../diagrams/tables/procedure_result.2degrees.svg" class="diagram" border="0" align="left"></object></a>
484 </div>
485 </div>
486 </div>
487 </div><!-- /.box-body -->
488 </div>
489 </section>
490 <script>
491 var config = {
492 pagination: false
494 </script>
496 </div>
497 <!-- /.content-wrapper -->
498 <footer class="main-footer">
499 <div>
500 <div class="pull-right hidden-xs">
501 <a href="https://github.com/schemaspy/schemaspy" title="GitHub for SchemaSpy"><i class="fa fa-github-square fa-2x"></i></a>
502 <a href="http://stackoverflow.com/questions/tagged/schemaspy" title="StackOverflow for SchemaSpy"><i class="fa fa-stack-overflow fa-2x"></i></a>
503 </div>
504 <strong>Generated by <a href="http://schemaspy.org/" class="logo-text"><i class="fa fa-database"></i> SchemaSpy 6.2.4</a></strong>
505 </div>
506 <!-- /.container -->
507 </footer>
508 </div>
509 <!-- ./wrapper -->
511 <!-- jQuery 2.2.3 -->
512 <script src="../bower/admin-lte/plugins/jQuery/jquery-2.2.3.min.js"></script>
513 <script src="../bower/admin-lte/plugins/jQueryUI/jquery-ui.min.js"></script>
514 <!-- Bootstrap 3.3.5 -->
515 <script src="../bower/admin-lte/bootstrap/js/bootstrap.min.js"></script>
516 <!-- DataTables -->
517 <script src="../bower/datatables.net/jquery.dataTables.min.js"></script>
518 <script src="../bower/datatables.net-bs/js/dataTables.bootstrap.min.js"></script>
519 <script src="../bower/datatables.net-buttons/dataTables.buttons.min.js"></script>
520 <script src="../bower/datatables.net-buttons-bs/js/buttons.bootstrap.min.js"></script>
521 <script src="../bower/datatables.net-buttons/buttons.html5.min.js"></script>
522 <script src="../bower/datatables.net-buttons/buttons.print.min.js"></script>
523 <script src="../bower/datatables.net-buttons/buttons.colVis.min.js"></script>
524 <!-- SheetJS -->
525 <script src="../bower/js-xlsx/xlsx.full.min.js"></script>
526 <!-- pdfmake -->
527 <script src="../bower/pdfmake/pdfmake.min.js"></script>
528 <script src="../bower/pdfmake/vfs_fonts.js"></script>
529 <!-- SlimScroll -->
530 <script src="../bower/admin-lte/plugins/slimScroll/jquery.slimscroll.min.js"></script>
531 <!-- FastClick -->
532 <script src="../bower/admin-lte/plugins/fastclick/fastclick.js"></script>
533 <!-- Salvattore -->
534 <script src="../bower/salvattore/salvattore.min.js"></script>
535 <!-- AnchorJS -->
536 <script src="../bower/anchor-js/anchor.min.js"></script>
537 <!-- CodeMirror -->
538 <script src="../bower/codemirror/codemirror.js"></script>
539 <script src="../bower/codemirror/sql.js"></script>
540 <!-- AdminLTE App -->
541 <script src="../bower/admin-lte/dist/js/app.min.js"></script>
542 <script src="table.js"></script>
543 <script src="../schemaSpy.js"></script>
544 </body>
545 </html>