Project

General

Profile

Bug #1079 » stem_irregTaxa_chngs_3OPTIONS.htm

Michael Lee, 07/07/2003 04:02 PM

 
1
<html xmlns:o="urn:schemas-microsoft-com:office:office"
2
xmlns:x="urn:schemas-microsoft-com:office:excel"
3
xmlns="http://www.w3.org/TR/REC-html40">
4

    
5
<head>
6
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
7
<meta name=ProgId content=Excel.Sheet>
8
<meta name=Generator content="Microsoft Excel 10">
9
<!--- <link rel=File-List href="stem_irregTaxa_chngs_3OPTIONS_files/filelist.xml">
10
<link rel=Edit-Time-Data href="stem_irregTaxa_chngs_3OPTIONS_files/editdata.mso">
11
<link rel=OLE-Object-Data href="stem_irregTaxa_chngs_3OPTIONS_files/oledata.mso"> -->
12
<!--[if gte mso 9]><xml>
13
 <o:DocumentProperties>
14
  <o:Author>Michael Lee</o:Author>
15
  <o:LastAuthor>Michael Lee</o:LastAuthor>
16
  <o:Created>2003-07-01T19:22:47Z</o:Created>
17
  <o:LastSaved>2003-07-07T22:41:47Z</o:LastSaved>
18
  <o:Company>VegBank / UNC</o:Company>
19
  <o:Version>10.4219</o:Version>
20
 </o:DocumentProperties>
21
 <o:OfficeDocumentSettings>
22
  <o:DownloadComponents/>
23
  <o:LocationOfComponents HRef="file:///\\"/>
24
 </o:OfficeDocumentSettings>
25
</xml><![endif]-->
26
<style>
27
<!--table
28
	{mso-displayed-decimal-separator:"\.";
29
	mso-displayed-thousand-separator:"\,";}
30
@page
31
	{margin:1.0in .75in 1.0in .75in;
32
	mso-header-margin:.5in;
33
	mso-footer-margin:.5in;}
34
tr
35
	{mso-height-source:auto;}
36
col
37
	{mso-width-source:auto;}
38
br
39
	{mso-data-placement:same-cell;}
40
.style0
41
	{mso-number-format:General;
42
	text-align:general;
43
	vertical-align:bottom;
44
	white-space:nowrap;
45
	mso-rotate:0;
46
	mso-background-source:auto;
47
	mso-pattern:auto;
48
	color:windowtext;
49
	font-size:10.0pt;
50
	font-weight:400;
51
	font-style:normal;
52
	text-decoration:none;
53
	font-family:Arial;
54
	mso-generic-font-family:auto;
55
	mso-font-charset:0;
56
	border:none;
57
	mso-protection:locked visible;
58
	mso-style-name:Normal;
59
	mso-style-id:0;}
60
.style20
61
	{mso-number-format:General;
62
	text-align:general;
63
	vertical-align:bottom;
64
	white-space:nowrap;
65
	mso-rotate:0;
66
	mso-background-source:auto;
67
	mso-pattern:auto;
68
	color:black;
69
	font-size:10.0pt;
70
	font-weight:400;
71
	font-style:normal;
72
	text-decoration:none;
73
	font-family:Arial;
74
	mso-generic-font-family:auto;
75
	mso-font-charset:0;
76
	border:none;
77
	mso-protection:locked visible;
78
	mso-style-name:Normal_Sheet1;}
79
td
80
	{mso-style-parent:style0;
81
	padding-top:1px;
82
	padding-right:1px;
83
	padding-left:1px;
84
	mso-ignore:padding;
85
	color:windowtext;
86
	font-size:10.0pt;
87
	font-weight:400;
88
	font-style:normal;
89
	text-decoration:none;
90
	font-family:Arial;
91
	mso-generic-font-family:auto;
92
	mso-font-charset:0;
93
	mso-number-format:General;
94
	text-align:general;
95
	vertical-align:bottom;
96
	border:none;
97
	mso-background-source:auto;
98
	mso-pattern:auto;
99
	mso-protection:locked visible;
100
	white-space:nowrap;
101
	mso-rotate:0;}
102
.xl25
103
	{mso-style-parent:style20;
104
	color:black;
105
	border:.5pt solid gray;
106
	mso-background-source:auto;
107
	mso-pattern:auto;
108
	white-space:normal;}
109
.xl26
110
	{mso-style-parent:style20;
111
	color:black;
112
	mso-background-source:auto;
113
	mso-pattern:auto;
114
	white-space:normal;}
115
.xl27
116
	{mso-style-parent:style20;
117
	color:black;
118
	font-weight:700;
119
	font-family:Arial, sans-serif;
120
	mso-font-charset:0;
121
	text-align:center;
122
	border:.5pt solid black;
123
	background:silver;
124
	mso-pattern:black none;}
125
.xl28
126
	{mso-style-parent:style0;
127
	font-weight:700;
128
	font-family:Arial, sans-serif;
129
	mso-font-charset:0;}
130
.xl29
131
	{mso-style-parent:style20;
132
	color:black;
133
	border:.5pt solid gray;
134
	white-space:normal;}
135
.xl30
136
	{mso-style-parent:style20;
137
	color:black;
138
	border:.5pt solid gray;
139
	background:#CCFFFF;
140
	mso-pattern:black none;
141
	white-space:normal;}
142
.xl31
143
	{mso-style-parent:style20;
144
	color:black;
145
	border-top:none;
146
	border-right:.5pt solid gray;
147
	border-bottom:none;
148
	border-left:.5pt solid gray;
149
	background:#CCFFFF;
150
	mso-pattern:black none;
151
	white-space:normal;}
152
.xl32
153
	{mso-style-parent:style20;
154
	color:black;
155
	font-weight:700;
156
	font-family:Arial, sans-serif;
157
	mso-font-charset:0;
158
	text-align:center;
159
	background:silver;
160
	mso-pattern:black none;}
161
-->
162
</style>
163
<!--[if gte mso 9]><xml>
164
 <x:ExcelWorkbook>
165
  <x:ExcelWorksheets>
166
   <x:ExcelWorksheet>
167
    <x:Name>Sheet1</x:Name>
168
    <x:WorksheetOptions>
169
     <x:DefaultRowHeight>285</x:DefaultRowHeight>
170
     <x:Unsynced/>
171
     <x:Print>
172
      <x:ValidPrinterInfo/>
173
      <x:HorizontalResolution>600</x:HorizontalResolution>
174
      <x:VerticalResolution>600</x:VerticalResolution>
175
     </x:Print>
176
     <x:Selected/>
177
     <x:LeftColumnVisible>3</x:LeftColumnVisible>
178
     <x:Panes>
179
      <x:Pane>
180
       <x:Number>3</x:Number>
181
       <x:ActiveRow>1</x:ActiveRow>
182
       <x:ActiveCol>7</x:ActiveCol>
183
      </x:Pane>
184
     </x:Panes>
185
     <x:ProtectContents>False</x:ProtectContents>
186
     <x:ProtectObjects>False</x:ProtectObjects>
187
     <x:ProtectScenarios>False</x:ProtectScenarios>
188
    </x:WorksheetOptions>
189
   </x:ExcelWorksheet>
190
   <x:ExcelWorksheet>
191
    <x:Name>Sheet2</x:Name>
192
    <x:WorksheetOptions>
193
     <x:ProtectContents>False</x:ProtectContents>
194
     <x:ProtectObjects>False</x:ProtectObjects>
195
     <x:ProtectScenarios>False</x:ProtectScenarios>
196
    </x:WorksheetOptions>
197
   </x:ExcelWorksheet>
198
   <x:ExcelWorksheet>
199
    <x:Name>Sheet3</x:Name>
200
    <x:WorksheetOptions>
201
     <x:ProtectContents>False</x:ProtectContents>
202
     <x:ProtectObjects>False</x:ProtectObjects>
203
     <x:ProtectScenarios>False</x:ProtectScenarios>
204
    </x:WorksheetOptions>
205
   </x:ExcelWorksheet>
206
  </x:ExcelWorksheets>
207
  <x:WindowHeight>13035</x:WindowHeight>
208
  <x:WindowWidth>17115</x:WindowWidth>
209
  <x:WindowTopX>360</x:WindowTopX>
210
  <x:WindowTopY>30</x:WindowTopY>
211
  <x:ProtectStructure>False</x:ProtectStructure>
212
  <x:ProtectWindows>False</x:ProtectWindows>
213
 </x:ExcelWorkbook>
214
</xml><![endif]-->
215
</head>
216

    
217
<body link=blue vlink=purple>
218

    
219
<table x:str border=0 cellpadding=0 cellspacing=0 width=1777 style='border-collapse:
220
 collapse;table-layout:fixed;width:1333pt'>
221
 <col width=127 style='mso-width-source:userset;mso-width-alt:4644;width:95pt'>
222
 <col width=180 style='mso-width-source:userset;mso-width-alt:6582;width:135pt'>
223
 <col width=239 style='mso-width-source:userset;mso-width-alt:8740;width:179pt'>
224
 <col width=198 style='mso-width-source:userset;mso-width-alt:7241;width:149pt'>
225
 <col width=92 style='mso-width-source:userset;mso-width-alt:3364;width:69pt'>
226
 <col width=123 style='mso-width-source:userset;mso-width-alt:4498;width:92pt'>
227
 <col width=166 style='mso-width-source:userset;mso-width-alt:6070;width:125pt'>
228
 <col class=xl25 width=289 style='mso-width-source:userset;mso-width-alt:10569;
229
 width:217pt'>
230
 <col class=xl25 width=363 style='mso-width-source:userset;mso-width-alt:13275;
231
 width:272pt'>
232
 <col width=140 style='mso-width-source:userset;mso-width-alt:5120;width:105pt'>
233
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
234
  <td height=17 width=127 style='height:12.75pt;width:95pt'>Curent Situation</td>
235
  <td width=180 style='width:135pt'></td>
236
  <td width=239 style='width:179pt'>OPTION A: no model changes: comment<span
237
  style='display:none'>s here</span></td>
238
  <td width=198 style='width:149pt'>OPTION B field changes only</td>
239
  <td width=92 style='width:69pt'>B comments</td>
240
  <td width=123 style='width:92pt'>OPTION C changes</td>
241
  <td width=166 style='width:125pt'></td>
242
  <td class=xl25 width=289 style='width:217pt'>comments about field</td>
243
  <td class=xl25 width=363 style='border-left:none;width:272pt'>MTL's thoughts
244
  on option C</td>
245
 </tr>
246
 <tr class=xl28 height=17 style='mso-height-source:userset;height:12.75pt'>
247
  <td height=17 class=xl27 style='height:12.75pt'>TableName</td>
248
  <td class=xl27 style='border-left:none'>FieldName</td>
249
  <td colspan=3 class=xl32 style='mso-ignore:colspan'>&nbsp;</td>
250
  <td class=xl27>TableName</td>
251
  <td class=xl27 style='border-left:none'>FieldName</td>
252
  <td class=xl27 style='border-left:none'>see bugs 786 and 1079</td>
253
  <td class=xl25 width=363 style='border-top:none;width:272pt'>&nbsp;</td>
254
 </tr>
255
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
256
  <td height=17 class=xl25 width=127 style='height:12.75pt;width:95pt'>stemCount</td>
257
  <td class=xl25 width=180 style='border-left:none;width:135pt'>STEMCOUNT_ID</td>
258
  <td class=xl25 width=239 style='border-left:none;width:179pt'>split into 2
259
  tables is not necessary</td>
260
  <td class=xl25 width=198 style='border-left:none;width:149pt'>&nbsp;</td>
261
  <td class=xl25 width=92 style='border-left:none;width:69pt'>&nbsp;</td>
262
  <td class=xl30 width=123 style='border-left:none;width:92pt'>stem</td>
263
  <td class=xl30 width=166 style='border-left:none;width:125pt'>STEM_ID</td>
264
  <td class=xl25 width=289 style='border-left:none;width:217pt'>consolidated to
265
  one stem table</td>
266
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
267
 </tr>
268
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
269
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
270
  width:95pt'>stemCount</td>
271
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>TAXONOBSERVATION_ID</td>
272
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
273
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>&nbsp;</td>
274
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
275
  <td class=xl30 width=123 style='border-top:none;border-left:none;width:92pt'>stem</td>
276
  <td class=xl25 width=166 style='border-top:none;border-left:none;width:125pt'>TAXONOBSERVATION_ID</td>
277
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>&nbsp;</td>
278
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
279
 </tr>
280
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
281
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
282
  width:95pt'>stemCount</td>
283
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>stemDiameter</td>
284
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
285
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>&nbsp;</td>
286
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
287
  <td class=xl30 width=123 style='border-top:none;border-left:none;width:92pt'>stem</td>
288
  <td class=xl25 width=166 style='border-top:none;border-left:none;width:125pt'>stemDiameter</td>
289
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>&nbsp;</td>
290
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
291
 </tr>
292
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
293
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
294
  width:95pt'>stemCount</td>
295
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>stemDiameterAccuracy</td>
296
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
297
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>&nbsp;</td>
298
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
299
  <td class=xl30 width=123 style='border-top:none;border-left:none;width:92pt'>stem</td>
300
  <td class=xl25 width=166 style='border-top:none;border-left:none;width:125pt'>stemDiameterAccuracy</td>
301
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>&nbsp;</td>
302
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
303
 </tr>
304
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
305
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
306
  width:95pt'>stemCount</td>
307
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>stemHeight</td>
308
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
309
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>&nbsp;</td>
310
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
311
  <td class=xl30 width=123 style='border-top:none;border-left:none;width:92pt'>stem</td>
312
  <td class=xl25 width=166 style='border-top:none;border-left:none;width:125pt'>stemHeight</td>
313
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>&nbsp;</td>
314
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
315
 </tr>
316
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
317
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
318
  width:95pt'>stemCount</td>
319
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>stemHeightAccuracy</td>
320
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
321
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>&nbsp;</td>
322
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
323
  <td class=xl30 width=123 style='border-top:none;border-left:none;width:92pt'>stem</td>
324
  <td class=xl25 width=166 style='border-top:none;border-left:none;width:125pt'>stemHeightAccuracy</td>
325
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>&nbsp;</td>
326
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
327
 </tr>
328
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
329
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
330
  width:95pt'>stemCount</td>
331
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>stemCount</td>
332
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
333
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>&nbsp;</td>
334
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
335
  <td class=xl30 width=123 style='border-top:none;border-left:none;width:92pt'>stem</td>
336
  <td class=xl25 width=166 style='border-top:none;border-left:none;width:125pt'>stemCount</td>
337
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>&nbsp;</td>
338
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
339
 </tr>
340
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
341
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
342
  width:95pt'>stemCount</td>
343
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>stemTaxonArea</td>
344
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
345
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>&nbsp;</td>
346
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
347
  <td class=xl30 width=123 style='border-top:none;border-left:none;width:92pt'>stem</td>
348
  <td class=xl25 width=166 style='border-top:none;border-left:none;width:125pt'>stemTaxonArea</td>
349
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>&nbsp;</td>
350
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
351
 </tr>
352
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
353
  <td height=17 class=xl29 width=127 style='height:12.75pt;border-top:none;
354
  width:95pt'>stemLocation</td>
355
  <td class=xl29 width=180 style='border-top:none;border-left:none;width:135pt'>STEMLOCATION_ID</td>
356
  <td class=xl29 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
357
  <td class=xl29 width=198 style='border-top:none;border-left:none;width:149pt'>&nbsp;</td>
358
  <td class=xl29 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
359
  <td class=xl25 width=123 style='border-top:none;border-left:none;width:92pt'>&nbsp;</td>
360
  <td class=xl25 width=166 style='border-top:none;border-left:none;width:125pt'>&nbsp;</td>
361
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>&nbsp;</td>
362
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
363
 </tr>
364
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
365
  <td height=17 class=xl29 width=127 style='height:12.75pt;border-top:none;
366
  width:95pt'>stemLocation</td>
367
  <td class=xl29 width=180 style='border-top:none;border-left:none;width:135pt'>STEMCOUNT_ID</td>
368
  <td class=xl29 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
369
  <td class=xl29 width=198 style='border-top:none;border-left:none;width:149pt'>&nbsp;</td>
370
  <td class=xl29 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
371
  <td class=xl25 width=123 style='border-top:none;border-left:none;width:92pt'>&nbsp;</td>
372
  <td class=xl25 width=166 style='border-top:none;border-left:none;width:125pt'>&nbsp;</td>
373
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>&nbsp;</td>
374
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
375
 </tr>
376
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
377
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
378
  width:95pt'>stemLocation</td>
379
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>stemCode</td>
380
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
381
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>&nbsp;</td>
382
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
383
  <td class=xl30 width=123 style='border-top:none;border-left:none;width:92pt'>stem</td>
384
  <td class=xl25 width=166 style='border-top:none;border-left:none;width:125pt'>stemCode</td>
385
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>author's
386
  code</td>
387
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
388
 </tr>
389
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
390
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
391
  width:95pt'>stemLocation</td>
392
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>stemXPosition</td>
393
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
394
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>&nbsp;</td>
395
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
396
  <td class=xl30 width=123 style='border-top:none;border-left:none;width:92pt'>stem</td>
397
  <td class=xl25 width=166 style='border-top:none;border-left:none;width:125pt'>stemXPosition</td>
398
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>&nbsp;</td>
399
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
400
 </tr>
401
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
402
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
403
  width:95pt'>stemLocation</td>
404
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>stemYPosition</td>
405
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
406
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>&nbsp;</td>
407
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
408
  <td class=xl30 width=123 style='border-top:none;border-left:none;width:92pt'>stem</td>
409
  <td class=xl25 width=166 style='border-top:none;border-left:none;width:125pt'>stemYPosition</td>
410
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>&nbsp;</td>
411
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
412
 </tr>
413
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
414
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
415
  width:95pt'>&nbsp;</td>
416
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>&nbsp;</td>
417
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>previous
418
  stem accessible via stemCode and obs.previousObservation_ID</td>
419
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>&nbsp;</td>
420
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
421
  <td class=xl30 width=123 style='border-top:none;border-left:none;width:92pt'>stem</td>
422
  <td class=xl30 width=166 style='border-top:none;border-left:none;width:125pt'>PREVIOUSSTEM_ID</td>
423
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>recursive
424
  key back to previous observation of same stem</td>
425
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>unnecessary
426
  or minimally an implementation field.<span style='mso-spacerun:yes'>
427
  </span>Previous observation, same stem code should suffice.</td>
428
 </tr>
429
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
430
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
431
  width:95pt'>taxonInterpretation</td>
432
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>TAXONINTERPRETATION_ID</td>
433
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
434
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>TAXONINTERPRETATION_ID</td>
435
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
436
  <td class=xl30 width=123 style='border-top:none;border-left:none;width:92pt'>taxonClass</td>
437
  <td class=xl30 width=166 style='border-top:none;border-left:none;width:125pt'>TAXONCLASS_ID</td>
438
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>&nbsp;</td>
439
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
440
 </tr>
441
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
442
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
443
  width:95pt'>taxonInterpretation</td>
444
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>TAXONOBSERVATION_ID</td>
445
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
446
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>TAXONOBSERVATION_ID</td>
447
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
448
  <td class=xl30 width=123 style='border-top:none;border-left:none;width:92pt'>taxonClass</td>
449
  <td class=xl25 width=166 style='border-top:none;border-left:none;width:125pt'>TAXONOBSERVATION_ID</td>
450
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>&nbsp;</td>
451
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
452
 </tr>
453
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
454
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
455
  width:95pt'>taxonInterpretation</td>
456
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>interpretationDate</td>
457
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
458
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>interpretationDate</td>
459
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
460
  <td class=xl30 width=123 style='border-top:none;border-left:none;width:92pt'>taxonClass</td>
461
  <td class=xl25 width=166 style='border-top:none;border-left:none;width:125pt'>interpretationDate</td>
462
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>&nbsp;</td>
463
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
464
 </tr>
465
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
466
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
467
  width:95pt'>taxonInterpretation</td>
468
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>PARTY_ID</td>
469
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
470
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>PARTY_ID</td>
471
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
472
  <td class=xl30 width=123 style='border-top:none;border-left:none;width:92pt'>taxonClass</td>
473
  <td class=xl25 width=166 style='border-top:none;border-left:none;width:125pt'>PARTY_ID</td>
474
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>&nbsp;</td>
475
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
476
 </tr>
477
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
478
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
479
  width:95pt'>taxonInterpretation</td>
480
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>ROLE_ID</td>
481
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
482
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>ROLE_ID</td>
483
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
484
  <td class=xl30 width=123 style='border-top:none;border-left:none;width:92pt'>taxonClass</td>
485
  <td class=xl25 width=166 style='border-top:none;border-left:none;width:125pt'>ROLE_ID</td>
486
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>&nbsp;</td>
487
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
488
 </tr>
489
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
490
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
491
  width:95pt'>taxonInterpretation</td>
492
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>interpretationType</td>
493
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>add
494
  values 'author, less precise, but absolutely certain' AND 'author, more
495
  precise, but less certain'</td>
496
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>interpretationType</td>
497
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>leave
498
  values alone</td>
499
  <td class=xl30 width=123 style='border-top:none;border-left:none;width:92pt'>taxonClass</td>
500
  <td class=xl25 width=166 style='border-top:none;border-left:none;width:125pt'>interpretationType</td>
501
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>Author,
502
  Computer, Correction?</td>
503
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
504
 </tr>
505
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
506
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
507
  width:95pt'>taxonInterpretation</td>
508
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>reference_ID</td>
509
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
510
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>reference_ID</td>
511
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
512
  <td class=xl30 width=123 style='border-top:none;border-left:none;width:92pt'>taxonClass</td>
513
  <td class=xl25 width=166 style='border-top:none;border-left:none;width:125pt'>reference_ID</td>
514
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>&nbsp;</td>
515
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
516
 </tr>
517
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
518
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
519
  width:95pt'>taxonInterpretation</td>
520
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>originalInterpretation</td>
521
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
522
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>originalInterpretation</td>
523
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
524
  <td class=xl30 width=123 style='border-top:none;border-left:none;width:92pt'>taxonClass</td>
525
  <td class=xl25 width=166 style='border-top:none;border-left:none;width:125pt'>originalInterpretation</td>
526
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>boolean</td>
527
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
528
 </tr>
529
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
530
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
531
  width:95pt'>taxonInterpretation</td>
532
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>currentInterpretation</td>
533
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
534
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>currentInterpretation</td>
535
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
536
  <td class=xl30 width=123 style='border-top:none;border-left:none;width:92pt'>taxonClass</td>
537
  <td class=xl25 width=166 style='border-top:none;border-left:none;width:125pt'>currentInterpretation</td>
538
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>boolean</td>
539
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
540
 </tr>
541
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
542
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
543
  width:95pt'>taxonInterpretation</td>
544
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>notes</td>
545
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
546
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>notes</td>
547
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
548
  <td class=xl30 width=123 style='border-top:none;border-left:none;width:92pt'>taxonClass</td>
549
  <td class=xl25 width=166 style='border-top:none;border-left:none;width:125pt'>notes</td>
550
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>&nbsp;</td>
551
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
552
 </tr>
553
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
554
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
555
  width:95pt'>taxonInterpretation</td>
556
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>notesPublic</td>
557
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
558
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>notesPublic</td>
559
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
560
  <td class=xl30 width=123 style='border-top:none;border-left:none;width:92pt'>taxonClass</td>
561
  <td class=xl25 width=166 style='border-top:none;border-left:none;width:125pt'>notesPublic</td>
562
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>implementation
563
  field</td>
564
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
565
 </tr>
566
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
567
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
568
  width:95pt'>taxonInterpretation</td>
569
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>notesMgt</td>
570
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
571
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>notesMgt</td>
572
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
573
  <td class=xl30 width=123 style='border-top:none;border-left:none;width:92pt'>taxonClass</td>
574
  <td class=xl25 width=166 style='border-top:none;border-left:none;width:125pt'>notesMgt</td>
575
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>implementation
576
  field</td>
577
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
578
 </tr>
579
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
580
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
581
  width:95pt'>taxonInterpretation</td>
582
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>revisions</td>
583
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
584
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>revisions</td>
585
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
586
  <td class=xl30 width=123 style='border-top:none;border-left:none;width:92pt'>taxonClass</td>
587
  <td class=xl25 width=166 style='border-top:none;border-left:none;width:125pt'>revisions</td>
588
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>implementation
589
  field</td>
590
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
591
 </tr>
592
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
593
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
594
  width:95pt'>&nbsp;</td>
595
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>&nbsp;</td>
596
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
597
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>&nbsp;</td>
598
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
599
  <td class=xl30 width=123 style='border-top:none;border-left:none;width:92pt'>taxonClass</td>
600
  <td class=xl30 width=166 style='border-top:none;border-left:none;width:125pt'>taxonClassType</td>
601
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>exact,
602
  aggregate, one-of, subset</td>
603
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>I
604
  suggested this in new comment on bug 1079</td>
605
 </tr>
606
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
607
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
608
  width:95pt'>&nbsp;</td>
609
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>&nbsp;</td>
610
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
611
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>&nbsp;</td>
612
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
613
  <td class=xl30 width=123 style='border-top:none;border-left:none;width:92pt'>taxonInterpretation</td>
614
  <td class=xl30 width=166 style='border-top:none;border-left:none;width:125pt'>TAXONINTERPRETATION_ID</td>
615
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>&nbsp;</td>
616
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
617
 </tr>
618
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
619
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
620
  width:95pt'>&nbsp;</td>
621
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>&nbsp;</td>
622
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
623
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>&nbsp;</td>
624
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
625
  <td class=xl30 width=123 style='border-top:none;border-left:none;width:92pt'>taxonInterpretation</td>
626
  <td class=xl30 width=166 style='border-top:none;border-left:none;width:125pt'>TAXONCLASS_ID</td>
627
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>&nbsp;</td>
628
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
629
 </tr>
630
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
631
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
632
  width:95pt'>taxonInterpretation</td>
633
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>PLANTCONCEPT_ID</td>
634
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
635
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>PLANTCONCEPT_ID</td>
636
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
637
  <td class=xl25 width=123 style='border-top:none;border-left:none;width:92pt'>taxonInterpretation</td>
638
  <td class=xl25 width=166 style='border-top:none;border-left:none;width:125pt'>PLANTCONCEPT_ID</td>
639
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>&nbsp;</td>
640
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
641
 </tr>
642
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
643
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
644
  width:95pt'>taxonInterpretation</td>
645
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>PLANTNAME_ID</td>
646
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
647
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>PLANTNAME_ID</td>
648
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
649
  <td class=xl25 width=123 style='border-top:none;border-left:none;width:92pt'>taxonInterpretation</td>
650
  <td class=xl25 width=166 style='border-top:none;border-left:none;width:125pt'>PLANTNAME_ID</td>
651
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>&nbsp;</td>
652
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>keep
653
  this as PLANTNAME_ID or just a text field, as in TaxonObservation?</td>
654
 </tr>
655
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
656
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
657
  width:95pt'>&nbsp;</td>
658
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>&nbsp;</td>
659
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
660
  <td class=xl31 width=198 style='border-left:none;width:149pt'>classFit</td>
661
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>values?</td>
662
  <td class=xl30 width=123 style='border-top:none;border-left:none;width:92pt'>taxonInterpretation</td>
663
  <td class=xl31 width=166 style='border-left:none;width:125pt'>classFit</td>
664
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>absolutely
665
  right, good answer, understandable but wrong, ?</td>
666
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
667
 </tr>
668
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
669
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
670
  width:95pt'>&nbsp;</td>
671
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>&nbsp;</td>
672
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
673
  <td class=xl31 width=198 style='border-left:none;width:149pt'>classConfidence</td>
674
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>H-M-low</td>
675
  <td class=xl30 width=123 style='border-top:none;border-left:none;width:92pt'>taxonInterpretation</td>
676
  <td class=xl31 width=166 style='border-left:none;width:125pt'>classConfidence</td>
677
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>high,
678
  medium, low</td>
679
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
680
 </tr>
681
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
682
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
683
  width:95pt'>taxonObservation</td>
684
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>TAXONOBSERVATION_ID</td>
685
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
686
  <td class=xl25 width=198 style='border-left:none;width:149pt'>TAXONOBSERVATION_ID</td>
687
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
688
  <td class=xl25 width=123 style='border-top:none;border-left:none;width:92pt'>taxonObservation</td>
689
  <td class=xl25 width=166 style='border-left:none;width:125pt'>TAXONOBSERVATION_ID</td>
690
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>&nbsp;</td>
691
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
692
 </tr>
693
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
694
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
695
  width:95pt'>taxonObservation</td>
696
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>OBSERVATION_ID</td>
697
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
698
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>OBSERVATION_ID</td>
699
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
700
  <td class=xl25 width=123 style='border-top:none;border-left:none;width:92pt'>taxonObservation</td>
701
  <td class=xl25 width=166 style='border-top:none;border-left:none;width:125pt'>OBSERVATION_ID</td>
702
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>&nbsp;</td>
703
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
704
 </tr>
705
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
706
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
707
  width:95pt'>taxonObservation</td>
708
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>PLANTNAME_ID</td>
709
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>nulls
710
  allowed for weird taxa</td>
711
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>PLANTNAME_ID</td>
712
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>nulls
713
  allowed for weird taxa</td>
714
  <td class=xl25 width=123 style='border-top:none;border-left:none;width:92pt'>taxonObservation</td>
715
  <td class=xl30 width=166 style='border-top:none;border-left:none;width:125pt'>plantName</td>
716
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>text
717
  field now</td>
718
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
719
 </tr>
720
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
721
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
722
  width:95pt'>taxonObservation</td>
723
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>reference_ID</td>
724
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
725
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>reference_ID</td>
726
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
727
  <td class=xl25 width=123 style='border-top:none;border-left:none;width:92pt'>taxonObservation</td>
728
  <td class=xl25 width=166 style='border-top:none;border-left:none;width:125pt'>reference_ID</td>
729
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>&nbsp;</td>
730
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
731
 </tr>
732
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
733
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
734
  width:95pt'>taxonObservation</td>
735
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>taxonCollection</td>
736
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>treat
737
  voucher as separate issue</td>
738
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>taxonCollection</td>
739
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>treat
740
  voucher as separate issue</td>
741
  <td class=xl25 width=123 style='border-top:none;border-left:none;width:92pt'>&nbsp;</td>
742
  <td class=xl25 width=166 style='border-top:none;border-left:none;width:125pt'>&nbsp;</td>
743
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>collection
744
  handled in voucher table</td>
745
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
746
 </tr>
747
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
748
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
749
  width:95pt'>taxonObservation</td>
750
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>taxonCover</td>
751
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
752
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>taxonCover</td>
753
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
754
  <td class=xl25 width=123 style='border-top:none;border-left:none;width:92pt'>taxonObservation</td>
755
  <td class=xl25 width=166 style='border-top:none;border-left:none;width:125pt'>taxonCover</td>
756
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>&nbsp;</td>
757
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
758
 </tr>
759
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
760
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
761
  width:95pt'>taxonObservation</td>
762
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>taxonBasalArea</td>
763
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
764
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>taxonBasalArea</td>
765
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
766
  <td class=xl25 width=123 style='border-top:none;border-left:none;width:92pt'>taxonObservation</td>
767
  <td class=xl25 width=166 style='border-top:none;border-left:none;width:125pt'>taxonBasalArea</td>
768
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>&nbsp;</td>
769
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
770
 </tr>
771
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
772
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
773
  width:95pt'>taxonObservation</td>
774
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>taxonInferenceArea</td>
775
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
776
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>taxonInferenceArea</td>
777
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
778
  <td class=xl25 width=123 style='border-top:none;border-left:none;width:92pt'>taxonObservation</td>
779
  <td class=xl25 width=166 style='border-top:none;border-left:none;width:125pt'>taxonInferenceArea</td>
780
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>&nbsp;</td>
781
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
782
 </tr>
783
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
784
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
785
  width:95pt'>taxonObservation</td>
786
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>cheatPlantName</td>
787
  <td class=xl26>&nbsp;</td>
788
  <td class=xl25 width=198 style='border-top:none;width:149pt'>cheatPlantName</td>
789
  <td></td>
790
  <td class=xl25 width=123 style='border-top:none;width:92pt'>&nbsp;</td>
791
  <td class=xl25 width=166 style='border-top:none;border-left:none;width:125pt'>&nbsp;</td>
792
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>cheatPlantName
793
  no longer needed</td>
794
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
795
 </tr>
796
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
797
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
798
  width:95pt'>&nbsp;</td>
799
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>&nbsp;</td>
800
  <td class=xl26 width=239 style='width:179pt'>deal with this idea with
801
  business rules: if a 'cheatplantname' occurs on a plot more than once, any
802
  records that have a stemCount record are considered 'individual', those
803
  without would be considered 'collective' (new BusRule: only one 'collective'
804
  taxonObs per cheatplantName per observation should be allowed.<span
805
  style='mso-spacerun:yes'>? </span>For option A, that would mean that only one
806
  taxonObs is allowed without stemCount record(s) referencing it.</td>
807
  <td class=xl30 width=198 style='border-top:none;width:149pt'>taxonObservationType</td>
808
  <td>add field</td>
809
  <td class=xl30 width=123 style='border-top:none;width:92pt'>taxonObservation</td>
810
  <td class=xl30 width=166 style='border-top:none;border-left:none;width:125pt'>taxonObservationType</td>
811
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>individual,
812
  collective</td>
813
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>perhaps
814
  new terms are needed - 'entire taxon' or 'partial taxon' might be better
815
  terms as someone might have a taxonObservation and voucher for multiple
816
  individuals, but still just a subset of the taxon on a plot</td>
817
 </tr>
818
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
819
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
820
  width:95pt'>&nbsp;</td>
821
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>&nbsp;</td>
822
  <td class=xl25 width=239 style='border-left:none;width:179pt'>&nbsp;</td>
823
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>&nbsp;</td>
824
  <td class=xl25 width=92 style='border-left:none;width:69pt'>&nbsp;</td>
825
  <td class=xl30 width=123 style='border-top:none;border-left:none;width:92pt'>voucher</td>
826
  <td class=xl30 width=166 style='border-top:none;border-left:none;width:125pt'>VOUCHER_ID</td>
827
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>new
828
  table to attach to taxonObs (and, by reference, stem)</td>
829
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>voucher
830
  could be very easily added, regardless of option A,B,C being chosen.<span
831
  style='mso-spacerun:yes'>? </span>I feel that this is a separate issue.</td>
832
 </tr>
833
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
834
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
835
  width:95pt'>&nbsp;</td>
836
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>&nbsp;</td>
837
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
838
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>&nbsp;</td>
839
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
840
  <td class=xl30 width=123 style='border-top:none;border-left:none;width:92pt'>voucher</td>
841
  <td class=xl30 width=166 style='border-top:none;border-left:none;width:125pt'>TaxonObservation_ID</td>
842
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>&nbsp;</td>
843
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
844
 </tr>
845
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
846
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
847
  width:95pt'>&nbsp;</td>
848
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>&nbsp;</td>
849
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
850
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>&nbsp;</td>
851
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
852
  <td class=xl30 width=123 style='border-top:none;border-left:none;width:92pt'>voucher</td>
853
  <td class=xl30 width=166 style='border-top:none;border-left:none;width:125pt'>Party_ID</td>
854
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>collector</td>
855
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
856
 </tr>
857
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
858
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
859
  width:95pt'>&nbsp;</td>
860
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>&nbsp;</td>
861
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
862
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>&nbsp;</td>
863
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
864
  <td class=xl30 width=123 style='border-top:none;border-left:none;width:92pt'>voucher</td>
865
  <td class=xl30 width=166 style='border-top:none;border-left:none;width:125pt'>CollectionNumber</td>
866
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>&nbsp;</td>
867
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
868
 </tr>
869
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
870
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
871
  width:95pt'>&nbsp;</td>
872
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>&nbsp;</td>
873
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
874
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>&nbsp;</td>
875
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
876
  <td class=xl30 width=123 style='border-top:none;border-left:none;width:92pt'>voucher</td>
877
  <td class=xl30 width=166 style='border-top:none;border-left:none;width:125pt'>Museum</td>
878
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>&nbsp;</td>
879
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
880
 </tr>
881
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
882
  <td height=17 class=xl25 width=127 style='height:12.75pt;border-top:none;
883
  width:95pt'>&nbsp;</td>
884
  <td class=xl25 width=180 style='border-top:none;border-left:none;width:135pt'>&nbsp;</td>
885
  <td class=xl25 width=239 style='border-top:none;border-left:none;width:179pt'>&nbsp;</td>
886
  <td class=xl25 width=198 style='border-top:none;border-left:none;width:149pt'>&nbsp;</td>
887
  <td class=xl25 width=92 style='border-top:none;border-left:none;width:69pt'>&nbsp;</td>
888
  <td class=xl30 width=123 style='border-top:none;border-left:none;width:92pt'>voucher</td>
889
  <td class=xl30 width=166 style='border-top:none;border-left:none;width:125pt'>AccessionNumber</td>
890
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>&nbsp;</td>
891
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
892
 </tr>
893
 <tr height=19 style='mso-height-source:userset;height:14.25pt'>
894
  <td height=19 colspan=5 style='height:14.25pt;mso-ignore:colspan'></td>
895
  <td class=xl30 width=123 style='border-top:none;width:92pt'>voucher</td>
896
  <td class=xl30 width=166 style='border-top:none;border-left:none;width:125pt'>CollectionDate</td>
897
  <td class=xl25 width=289 style='border-top:none;border-left:none;width:217pt'>&nbsp;</td>
898
  <td class=xl25 width=363 style='border-top:none;border-left:none;width:272pt'>&nbsp;</td>
899
 </tr>
900
 <![if supportMisalignedColumns]>
901
 <tr height=0 style='display:none'>
902
  <td width=127 style='width:95pt'></td>
903
  <td width=180 style='width:135pt'></td>
904
  <td width=239 style='width:179pt'></td>
905
  <td width=198 style='width:149pt'></td>
906
  <td width=92 style='width:69pt'></td>
907
  <td width=123 style='width:92pt'></td>
908
  <td width=166 style='width:125pt'></td>
909
  <td width=289 style='width:217pt'></td>
910
  <td width=363 style='width:272pt'></td>
911
 </tr>
912
 <![endif]>
913
</table>
914

    
915
</body>
916

    
917
</html>
(1-1/2)