<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=iso-8859-1"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Cambria;
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
h1
{mso-style-name:"Heading 1\,h1\,Level 1 Topic Heading";
mso-style-priority:9;
mso-style-link:"Heading 1 Char\,h1 Char\,Level 1 Topic Heading Char";
margin-top:8.0pt;
margin-right:0in;
margin-bottom:48.0pt;
margin-left:.65in;
text-indent:-.65in;
page-break-before:always;
page-break-after:avoid;
mso-list:l1 level1 lfo1;
font-size:24.0pt;
font-family:"Cambria","serif";
color:#376092;
mso-fareast-language:EN-CA;
font-weight:normal;}
h2
{mso-style-name:"Heading 2\,h2\,Level 2 Topic Heading\,H2";
mso-style-priority:9;
mso-style-link:"Heading 2 Char";
margin-top:8.0pt;
margin-right:0in;
margin-bottom:4.0pt;
margin-left:.65in;
text-indent:-.65in;
line-height:115%;
page-break-after:avoid;
mso-list:l1 level2 lfo1;
font-size:14.0pt;
font-family:"Cambria","serif";
color:#4F81BD;
mso-fareast-language:EN-CA;
font-weight:normal;}
h3
{mso-style-name:"Heading 3\,h3\,Level 3 Topic Heading";
mso-style-priority:9;
mso-style-link:"Heading 3 Char\,h3 Char\,Level 3 Topic Heading Char";
margin-top:8.0pt;
margin-right:0in;
margin-bottom:4.0pt;
margin-left:.85in;
text-indent:-.85in;
line-height:115%;
page-break-after:avoid;
mso-list:l1 level3 lfo1;
font-size:13.0pt;
font-family:"Cambria","serif";
color:#4F81BD;
mso-fareast-language:EN-CA;
font-weight:normal;}
h4
{mso-style-name:"Heading 4\,h4\,First Subheading";
mso-style-priority:9;
mso-style-link:"Heading 4 Char\,h4 Char\,First Subheading Char";
margin-top:8.0pt;
margin-right:0in;
margin-bottom:4.0pt;
margin-left:1.05in;
text-indent:-1.05in;
line-height:115%;
page-break-after:avoid;
mso-list:l1 level4 lfo1;
font-size:12.0pt;
font-family:"Cambria","serif";
color:#4F81BD;
mso-fareast-language:EN-CA;
font-weight:normal;}
h5
{mso-style-name:"Heading 5\,h5\,Second Subheading";
mso-style-priority:9;
mso-style-link:"Heading 5 Char";
margin-top:8.0pt;
margin-right:0in;
margin-bottom:4.0pt;
margin-left:1.25in;
text-indent:-1.25in;
line-height:115%;
page-break-after:avoid;
mso-list:l1 level5 lfo1;
font-size:12.0pt;
font-family:"Cambria","serif";
color:#254061;
mso-fareast-language:EN-CA;
font-weight:normal;}
h6
{mso-style-name:"Heading 6\,h6\,Third Subheading";
mso-style-priority:9;
mso-style-link:"Heading 6 Char";
margin-top:8.0pt;
margin-right:0in;
margin-bottom:4.0pt;
margin-left:1.45in;
text-indent:-1.45in;
line-height:115%;
page-break-after:avoid;
mso-list:l1 level6 lfo1;
font-size:12.0pt;
font-family:"Cambria","serif";
color:#254061;
mso-fareast-language:EN-CA;
font-weight:normal;}
p.MsoHeading7, li.MsoHeading7, div.MsoHeading7
{mso-style-priority:4;
mso-style-link:"Heading 7 Char";
margin-top:10.0pt;
margin-right:0in;
margin-bottom:0in;
margin-left:1.65in;
margin-bottom:.0001pt;
text-indent:-1.65in;
line-height:115%;
page-break-after:avoid;
mso-list:l1 level7 lfo1;
font-size:11.0pt;
font-family:"Arial","sans-serif";
color:#254061;
mso-fareast-language:EN-CA;
font-weight:bold;}
p.MsoHeading8, li.MsoHeading8, div.MsoHeading8
{mso-style-priority:4;
mso-style-link:"Heading 8 Char";
margin-top:10.0pt;
margin-right:0in;
margin-bottom:0in;
margin-left:1.85in;
margin-bottom:.0001pt;
text-indent:-1.85in;
line-height:115%;
page-break-after:avoid;
mso-list:l1 level8 lfo1;
font-size:11.0pt;
font-family:"Arial","sans-serif";
color:#254061;
mso-fareast-language:EN-CA;
font-weight:bold;
font-style:italic;}
p.MsoHeading9, li.MsoHeading9, div.MsoHeading9
{mso-style-priority:4;
mso-style-link:"Heading 9 Char";
margin-top:10.0pt;
margin-right:0in;
margin-bottom:0in;
margin-left:2.05in;
margin-bottom:.0001pt;
text-indent:-2.05in;
line-height:115%;
page-break-after:avoid;
mso-list:l1 level9 lfo1;
font-size:11.0pt;
font-family:"Arial","sans-serif";
color:#254061;
mso-fareast-language:EN-CA;
font-style:italic;}
p.MsoListBullet, li.MsoListBullet, div.MsoListBullet
{mso-style-priority:99;
margin-top:0in;
margin-right:0in;
margin-bottom:10.0pt;
margin-left:.5in;
mso-add-space:auto;
text-indent:-.25in;
line-height:115%;
mso-list:l0 level1 lfo2;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-CA;}
p.MsoListBulletCxSpFirst, li.MsoListBulletCxSpFirst, div.MsoListBulletCxSpFirst
{mso-style-priority:99;
mso-style-type:export-only;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
mso-add-space:auto;
text-indent:-.25in;
line-height:115%;
mso-list:l0 level1 lfo2;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-CA;}
p.MsoListBulletCxSpMiddle, li.MsoListBulletCxSpMiddle, div.MsoListBulletCxSpMiddle
{mso-style-priority:99;
mso-style-type:export-only;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
mso-add-space:auto;
text-indent:-.25in;
line-height:115%;
mso-list:l0 level1 lfo2;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-CA;}
p.MsoListBulletCxSpLast, li.MsoListBulletCxSpLast, div.MsoListBulletCxSpLast
{mso-style-priority:99;
mso-style-type:export-only;
margin-top:0in;
margin-right:0in;
margin-bottom:10.0pt;
margin-left:.5in;
mso-add-space:auto;
text-indent:-.25in;
line-height:115%;
mso-list:l0 level1 lfo2;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-CA;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.Heading1Char
{mso-style-name:"Heading 1 Char\,h1 Char\,Level 1 Topic Heading Char";
mso-style-priority:9;
mso-style-link:"Heading 1\,h1\,Level 1 Topic Heading";
font-family:"Cambria","serif";
color:#376092;
mso-fareast-language:EN-CA;}
span.Heading2Char
{mso-style-name:"Heading 2 Char";
mso-style-priority:9;
mso-style-link:"Heading 2\,h2\,Level 2 Topic Heading\,H2";
font-family:"Cambria","serif";
color:#4F81BD;
mso-fareast-language:EN-CA;}
span.Heading3Char
{mso-style-name:"Heading 3 Char\,h3 Char\,Level 3 Topic Heading Char";
mso-style-priority:9;
mso-style-link:"Heading 3\,h3\,Level 3 Topic Heading";
font-family:"Cambria","serif";
color:#4F81BD;
mso-fareast-language:EN-CA;}
span.Heading4Char
{mso-style-name:"Heading 4 Char\,h4 Char\,First Subheading Char";
mso-style-priority:9;
mso-style-link:"Heading 4\,h4\,First Subheading";
font-family:"Cambria","serif";
color:#4F81BD;
mso-fareast-language:EN-CA;}
span.Heading5Char
{mso-style-name:"Heading 5 Char";
mso-style-priority:9;
mso-style-link:"Heading 5\,h5\,Second Subheading";
font-family:"Cambria","serif";
color:#254061;
mso-fareast-language:EN-CA;}
span.Heading6Char
{mso-style-name:"Heading 6 Char";
mso-style-priority:9;
mso-style-link:"Heading 6\,h6\,Third Subheading";
font-family:"Cambria","serif";
color:#254061;
mso-fareast-language:EN-CA;}
span.Heading7Char
{mso-style-name:"Heading 7 Char";
mso-style-priority:4;
mso-style-link:"Heading 7";
font-family:"Arial","sans-serif";
color:#254061;
mso-fareast-language:EN-CA;
font-weight:bold;}
span.Heading8Char
{mso-style-name:"Heading 8 Char";
mso-style-priority:4;
mso-style-link:"Heading 8";
font-family:"Arial","sans-serif";
color:#254061;
mso-fareast-language:EN-CA;
font-weight:bold;
font-style:italic;}
span.Heading9Char
{mso-style-name:"Heading 9 Char";
mso-style-priority:4;
mso-style-link:"Heading 9";
font-family:"Arial","sans-serif";
color:#254061;
mso-fareast-language:EN-CA;
font-style:italic;}
p.c, li.c, div.c
{mso-style-name:"c\,Code\,C";
margin-top:0in;
margin-right:0in;
margin-bottom:10.0pt;
margin-left:.2in;
mso-add-space:auto;
line-height:115%;
font-size:11.0pt;
font-family:Consolas;
mso-fareast-language:EN-CA;}
p.cCxSpFirst, li.cCxSpFirst, div.cCxSpFirst
{mso-style-name:"c\,Code\,CCxSpFirst";
mso-style-type:export-only;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.2in;
margin-bottom:.0001pt;
mso-add-space:auto;
line-height:115%;
font-size:11.0pt;
font-family:Consolas;
mso-fareast-language:EN-CA;}
p.cCxSpMiddle, li.cCxSpMiddle, div.cCxSpMiddle
{mso-style-name:"c\,Code\,CCxSpMiddle";
mso-style-type:export-only;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.2in;
margin-bottom:.0001pt;
mso-add-space:auto;
line-height:115%;
font-size:11.0pt;
font-family:Consolas;
mso-fareast-language:EN-CA;}
p.cCxSpLast, li.cCxSpLast, div.cCxSpLast
{mso-style-name:"c\,Code\,CCxSpLast";
mso-style-type:export-only;
margin-top:0in;
margin-right:0in;
margin-bottom:10.0pt;
margin-left:.2in;
mso-add-space:auto;
line-height:115%;
font-size:11.0pt;
font-family:Consolas;
mso-fareast-language:EN-CA;}
span.Non-normativeBracket
{mso-style-name:"Non-normative Bracket\,Example start\/end";
font-style:italic;}
span.Element
{mso-style-name:Element;
font-family:"Cambria","serif";}
span.Attributevalue
{mso-style-name:"Attribute value";
font-family:Consolas;}
span.Type
{mso-style-name:"Type\,XSD Base Type";
mso-style-priority:99;
font-family:"Cambria","serif";}
span.Attribute
{mso-style-name:Attribute;
font-family:"Cambria","serif";}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
..MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:-119;
mso-list-type:simple;
mso-list-template-ids:-1736827978;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-style-link:"List Bullet";
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l1
{mso-list-id:703868044;
mso-list-template-ids:-1492236614;
mso-list-style-priority:99;
mso-list-style-name:"Ecma Document Numbering";}
@list l1:level1
{mso-level-style-link:"Heading 1";
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:.65in;
text-indent:-.65in;}
@list l1:level2
{mso-level-style-link:"Heading 2";
mso-level-text:"%1\.%2";
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:.65in;
text-indent:-.65in;}
@list l1:level3
{mso-level-style-link:"Heading 3";
mso-level-text:"%1\.%2\.%3";
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:.85in;
text-indent:-.85in;}
@list l1:level4
{mso-level-style-link:"Heading 4";
mso-level-text:"%1\.%2\.%3\.%4";
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:1.05in;
text-indent:-1.05in;}
@list l1:level5
{mso-level-style-link:"Heading 5";
mso-level-text:"%1\.%2\.%3\.%4\.%5";
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:1.25in;
text-indent:-1.25in;}
@list l1:level6
{mso-level-style-link:"Heading 6";
mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6";
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:1.45in;
text-indent:-1.45in;}
@list l1:level7
{mso-level-style-link:"Heading 7";
mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7";
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:1.65in;
text-indent:-1.65in;}
@list l1:level8
{mso-level-style-link:"Heading 8";
mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7\.%8";
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:1.85in;
text-indent:-1.85in;}
@list l1:level9
{mso-level-style-link:"Heading 9";
mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7\.%8\.%9";
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:2.05in;
text-indent:-2.05in;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=Section1><p class=MsoNormal>Here is the proposed text change for this defect report ( in the table ):<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><h1 style='margin-left:0in;text-indent:0in;mso-list:none'><a name="_Toc231548092"><b><span style='color:#365F91'>DR 09-0069</span> — SML, Pivot Tables: <span class=Attribute>longText</span> attribute length</b></a><b><o:p></o:p></b></h1><p class=MsoNormal><b>Part 1, §18.10.1.90 will be updated as follows:</b><o:p></o:p></p><h4 style='margin-left:0in;text-indent:0in;mso-list:none'><a name="_Toc197336078"></a><a name=book5b7c5d50-0a4d-43ba-9dd2-d8c1c33c4659>18.10.1.90<span class=Element> </span></a><a name="_Toc197334495"><span class=Element>sharedItems</span> (</a><w:Sdt PrefixMappings="xmlns:ns0='http://schemas.microsoft.com/schemaDocumentation/2007/longNames'" Xpath="/ns0:longNames/ns0:bookece36d6a70274ccd9f3fd322abf805ea" Text="t" StoreItemID="X_C077731C-C7F2-42FA-ACA0-2E15C9DA31EE" ID="1882399261">Shared Items</w:Sdt>)<o:p></o:p></h4><p class=MsoNormal><a name=bookece36d6a-7027-4ccd-9f3f-d322abf805ea></a>Represents the collection of unique items for a field in the PivotCacheDefinition. The sharedItems complex type stores data type and formatting information about the data in a field. Items in the PivotCacheDefinition can be shared in order to reduce the redundancy of those values that are referenced in multiple places across all the PivotTable parts. [<span class=Non-normativeBracket>Example</span>: A value might be part of a filter, it might appear on a row or column axis, and will appear in the pivotCacheRecords definition as well. However, because of the performance cost of creating the optimized shared items, items are only shared if they are actually in use in the PivotTable. Therefore, depending on user actions on the PivotTable layout, the pivotCacheDefinition and underlying PivotCacheRecords part can be updated. <span class=Non-normativeBracket>end example</span>]<o:p></o:p></p><p class=MsoNormal>If there are no shared items, then field values are stored directly in the pivotCacheRecords part.<o:p></o:p></p><p class=MsoNormal>[<span class=Non-normativeBracket>Example</span>:<span class=Non-normativeBracket><o:p></o:p></span></p><p class=c><span lang=EN-CA><sharedItems count="1"><br> <s v="[Customer].[Customer Geography].[Country].&amp;[United States]" <br> c="United States"/><br></sharedItems><o:p></o:p></span></p><p class=MsoNormal><span class=Non-normativeBracket>end example</span>]<span class=Non-normativeBracket><o:p></o:p></span></p><p class=MsoNormal>The following attributes are not required or used if there are no items in sharedItems.<o:p></o:p></p><p class=MsoListBulletCxSpFirst style='mso-list:l0 level1 lfo2'><![if !supportLists]><span class=Attribute><span lang=EN-CA style='font-family:Symbol'><span style='mso-list:Ignore'>·<span style='font:7.0pt "Times New Roman"'> </span></span></span></span><![endif]><span class=Attribute><span lang=EN-CA>containsBlank<o:p></o:p></span></span></p><p class=MsoListBulletCxSpMiddle style='mso-list:l0 level1 lfo2'><![if !supportLists]><span class=Attribute><span lang=EN-CA style='font-family:Symbol'><span style='mso-list:Ignore'>·<span style='font:7.0pt "Times New Roman"'> </span></span></span></span><![endif]><span class=Attribute><span lang=EN-CA>containsSemiMixedTypes<o:p></o:p></span></span></p><p class=MsoListBulletCxSpMiddle style='mso-list:l0 level1 lfo2'><![if !supportLists]><span class=Attribute><span lang=EN-CA style='font-family:Symbol'><span style='mso-list:Ignore'>·<span style='font:7.0pt "Times New Roman"'> </span></span></span></span><![endif]><span class=Attribute><span lang=EN-CA>containsMixedTypes<o:p></o:p></span></span></p><p class=MsoListBulletCxSpLast style='mso-list:l0 level1 lfo2'><![if !supportLists]><span class=Attribute><span lang=EN-CA style='font-family:Symbol'><span style='mso-list:Ignore'>·<span style='font:7.0pt "Times New Roman"'> </span></span></span></span><![endif]><span class=Attribute><span lang=EN-CA>longText<o:p></o:p></span></span></p><p class=MsoNormal>The following attributes are not used unless there is more than one item in sharedItems or the one and only item is not a blank item. If the first item is a blank item the data type the field cannot be verified.<o:p></o:p></p><p class=MsoListBulletCxSpFirst style='mso-list:l0 level1 lfo2'><![if !supportLists]><span class=Attribute><span lang=EN-CA style='font-family:Symbol'><span style='mso-list:Ignore'>·<span style='font:7.0pt "Times New Roman"'> </span></span></span></span><![endif]><span class=Attribute><span lang=EN-CA>containsNumber<o:p></o:p></span></span></p><p class=MsoListBulletCxSpMiddle style='mso-list:l0 level1 lfo2'><![if !supportLists]><span class=Attribute><span lang=EN-CA style='font-family:Symbol'><span style='mso-list:Ignore'>·<span style='font:7..0pt "Times New Roman"'> </span></span></span></span><![endif]><span class=Attribute><span lang=EN-CA>containsDates<o:p></o:p></span></span></p><p class=MsoListBulletCxSpMiddle style='mso-list:l0 level1 lfo2'><![if !supportLists]><span class=Attribute><span lang=EN-CA style='font-family:Symbol'><span style='mso-list:Ignore'>·<span style='font:7.0pt "Times New Roman"'> </span></span></span></span><![endif]><span class=Attribute><span lang=EN-CA>containsString<o:p></o:p></span></span></p><p class=MsoListBulletCxSpLast style='mso-list:l0 level1 lfo2'><![if !supportLists]><span class=Attribute><span lang=EN-CA style='font-family:Symbol'><span style='mso-list:Ignore'>·<span style='font:7.0pt "Times New Roman"'> </span></span></span></span><![endif]><span class=Attribute><span lang=EN-CA>containsInteger<o:p></o:p></span></span></p><p class=MsoNormal>The following attributes can be omitted without loss of functionality.<o:p></o:p></p><p class=MsoListBulletCxSpFirst style='mso-list:l0 level1 lfo2'><![if !supportLists]><span class=Attribute><span lang=EN-CA style='font-family:Symbol'><span style='mso-list:Ignore'>·<span style='font:7.0pt "Times New Roman"'> </span></span></span></span><![endif]><span class=Attribute><span lang=EN-CA>containsNonDate<o:p></o:p></span></span></p><p class=MsoListBulletCxSpLast style='mso-list:l0 level1 lfo2'><![if !supportLists]><span class=Attribute><span lang=EN-CA style='font-family:Symbol'><span style='mso-list:Ignore'>·<span style='font:7.0pt "Times New Roman"'> </span></span></span></span><![endif]><span class=Attribute><span lang=EN-CA>count<o:p></o:p></span></span></p><p class=MsoNormal>The following attributes are not required and can be omitted. However, refreshing the PivotTable could produce different groupings than before.<o:p></o:p></p><p class=MsoListBulletCxSpFirst style='mso-list:l0 level1 lfo2'><![if !supportLists]><span class=Attribute><span lang=EN-CA style='font-family:Symbol'><span style='mso-list:Ignore'>·<span style='font:7.0pt "Times New Roman"'> </span></span></span></span><![endif]><span class=Attribute><span lang=EN-CA>maxDate<o:p></o:p></span></span></p><p class=MsoListBulletCxSpMiddle style='mso-list:l0 level1 lfo2'><![if !supportLists]><span class=Attribute><span lang=EN-CA style='font-family:Symbol'><span style='mso-list:Ignore'>·<span style='font:7.0pt "Times New Roman"'> </span></span></span></span><![endif]><span class=Attribute><span lang=EN-CA>minDate<o:p></o:p></span></span></p><p class=MsoListBulletCxSpMiddle style='mso-list:l0 level1 lfo2'><![if !supportLists]><span class=Attribute><span lang=EN-CA style='font-family:Symbol'><span style='mso-list:Ignore'>·<span style='font:7.0pt "Times New Roman"'> </span></span></span></span><![endif]><span class=Attribute><span lang=EN-CA>maxValue<o:p></o:p></span></span></p><p class=MsoListBulletCxSpLast style='mso-list:l0 level1 lfo2'><![if !supportLists]><span class=Attribute><span lang=EN-CA style='font-family:Symbol'><span style='mso-list:Ignore'>·<span style='font:7.0pt "Times New Roman"'> </span></span></span></span><![endif]><span class=Attribute><span lang=EN-CA>minValue<o:p></o:p></span></span></p><p class=MsoNormal>Applications should ensure that “date” attributes are not mixed with “value” attributes.<o:p></o:p></p><table class=ElementTable border=1 cellspacing=0 cellpadding=0 width="100%" style='width:100.0%;border-collapse:collapse;border:none'><thead><tr style='page-break-inside:avoid'><td width="100%" valign=top style='width:100.0%;border:solid black 1.0pt;background:silver;padding:2.15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal align=center style='text-align:center'><b><span style='font-size:10.0pt'>Parent Elements<o:p></o:p></span></b></p></td></tr></thead><tr><td width="100%" valign=top style='width:100.0%;border:solid black 1.0pt;border-top:none;padding:2.15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal><span class=Element><span style='font-size:10.0pt'>cacheField</span></span><span style='font-size:10.0pt'> (§</span><span style='font-size:10.0pt'>18.10.1.3</span><span style='font-size:10.0pt'>)<o:p></o:p></span></p></td></tr></table><p class=MsoNormal><o:p> </o:p></p><table class=ElementTable border=1 cellspacing=0 cellpadding=0 width="100%" style='width:100.0%;border-collapse:collapse;border:none'><thead><tr style='page-break-inside:avoid'><td width="85%" valign=top style='width:85.0%;border:solid black 1.0pt;background:silver;padding:2.15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal align=center style='text-align:center'><b><span style='font-size:10.0pt'>Child Elements<o:p></o:p></span></b></p></td><td width="15%" valign=top style='width:15.0%;border:solid black 1.0pt;border-left:none;background:silver;padding:2.15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal align=center style='text-align:center'><b><span style='font-size:10.0pt'>Subclause<o:p></o:p></span></b></p></td></tr></thead><tr><td width="85%" valign=top style='width:85.0%;border:solid black 1.0pt;border-top:none;padding:2.15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal><span class=Element><span style='font-size:10.0pt'>b</span></span><span style='font-size:10.0pt'> (<w:Sdt PrefixMappings="xmlns:ns0='http://schemas.microsoft.com/schemaDocumentation/2007/longNames'" Xpath="/ns0:longNames/ns0:book08f04d53843c4be892a90f6d03a6926b" Text="t" StoreItemID="X_C077731C-C7F2-42FA-ACA0-2E15C9DA31EE" ID="1882399263">Boolean</w:Sdt>)<o:p></o:p></span></p></td><td width="15%" valign=top style='width:15.0%;border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:2.15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal><span style='font-size:10.0pt'>§</span><span style='font-size:10.0pt'>18.10.1.2</span><span style='font-size:10.0pt'><o:p></o:p></span></p></td></tr><tr><td width="85%" valign=top style='width:85.0%;border:solid black 1.0pt;border-top:none;padding:2.15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal><span class=Element><span style='font-size:10.0pt'>d</span></span><span style='font-size:10.0pt'> (<w:Sdt PrefixMappings="xmlns:ns0='http://schemas.microsoft.com/schemaDocumentation/2007/longNames'" Xpath="/ns0:longNames/ns0:bookb195777110ae4e1aa7890632662e3da2" Text="t" StoreItemID="X_C077731C-C7F2-42FA-ACA0-2E15C9DA31EE" ID="1882399264">Date Time</w:Sdt>)<o:p></o:p></span></p></td><td width="15%" valign=top style='width:15.0%;border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:2.15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal><span style='font-size:10.0pt'>§</span><span style='font-size:10.0pt'>18.10.1.21</span><span style='font-size:10.0pt'><o:p></o:p></span></p></td></tr><tr><td width="85%" valign=top style='width:85.0%;border:solid black 1.0pt;border-top:none;padding:2.15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal><span class=Element><span style='font-size:10.0pt'>e</span></span><span style='font-size:10.0pt'> (<w:Sdt PrefixMappings="xmlns:ns0='http://schemas.microsoft.com/schemaDocumentation/2007/longNames'" Xpath="/ns0:longNames/ns0:bookca3deaf3f2aa4b23aa323be1752648fe" Text="t" StoreItemID="X_C077731C-C7F2-42FA-ACA0-2E15C9DA31EE" ID="1882399265">Error Value</w:Sdt>)<o:p></o:p></span></p></td><td width="15%" valign=top style='width:15.0%;border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:2..15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal><span style='font-size:10.0pt'>§</span><span style='font-size:10.0pt'>18.10.1.27</span><span style='font-size:10.0pt'><o:p></o:p></span></p></td></tr><tr><td width="85%" valign=top style='width:85.0%;border:solid black 1.0pt;border-top:none;padding:2.15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal><span class=Element><span style='font-size:10.0pt'>m</span></span><span style='font-size:10.0pt'> (<w:Sdt PrefixMappings="xmlns:ns0='http://schemas.microsoft.com/schemaDocumentation/2007/longNames'" Xpath="/ns0:longNames/ns0:book62c58d23115843638558012676682cb6" Text="t" StoreItemID="X_C077731C-C7F2-42FA-ACA0-2E15C9DA31EE" ID="1882399266">No Value</w:Sdt>)<o:p></o:p></span></p></td><td width="15%" valign=top style='width:15.0%;border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:2.15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal><span style='font-size:10.0pt'>§</span><span style='font-size:10.0pt'>18.10.1.50</span><span style='font-size:10.0pt'><o:p></o:p></span></p></td></tr><tr><td width="85%" valign=top style='width:85.0%;border:solid black 1.0pt;border-top:none;padding:2.15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal><span class=Element><span style='font-size:10.0pt'>n</span></span><span style='font-size:10.0pt'> (<w:Sdt PrefixMappings="xmlns:ns0='http://schemas.microsoft.com/schemaDocumentation/2007/longNames'" Xpath="/ns0:longNames/ns0:bookd280b16078c8417cba1700c8914da5f5" Text="t" StoreItemID="X_C077731C-C7F2-42FA-ACA0-2E15C9DA31EE" ID="1882399267">Numeric</w:Sdt>)<o:p></o:p></span></p></td><td width="15%" valign=top style='width:15.0%;border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:2.15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal><span style='font-size:10.0pt'>§</span><span style='font-size:10.0pt'>18.10.1.60</span><span style='font-size:10.0pt'><o:p></o:p></span></p></td></tr><tr><td width="85%" valign=top style='width:85.0%;border:solid black 1.0pt;border-top:none;padding:2.15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal><span class=Element><span style='font-size:10.0pt'>s</span></span><span style='font-size:10.0pt'> (<w:Sdt PrefixMappings="xmlns:ns0='http://schemas.microsoft.com/schemaDocumentation/2007/longNames'" Xpath="/ns0:longNames/ns0:booke94a1a8ede674979ae0045832871d7d8" Text="t" StoreItemID="X_C077731C-C7F2-42FA-ACA0-2E15C9DA31EE" ID="1882399268">Character Value</w:Sdt>)<o:p></o:p></span></p></td><td width="15%" valign=top style='width:15.0%;border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:2.15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal><span style='font-size:10.0pt'>§</span><span style='font-size:10.0pt'>18.10.1.85</span><span style='font-size:10.0pt'><o:p></o:p></span></p></td></tr></table><p class=MsoNormal><o:p> </o:p></p><table class=ElementTable border=1 cellspacing=0 cellpadding=0 width="100%" style='width:100.0%;border-collapse:collapse;border:none'><thead><tr style='page-break-inside:avoid'><td width="20%" valign=top style='width:20.0%;border:solid black 1.0pt;background:silver;padding:2.15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal align=center style='text-align:center'><b><span style='font-size:10.0pt'>Attributes<o:p></o:p></span></b></p></td><td width="80%" valign=top style='width:80.0%;border:solid black 1.0pt;border-left:none;background:silver;padding:2.15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal align=center style='text-align:center'><b><span style='font-size:10.0pt'>Description<o:p></o:p></span></b></p></td></tr></thead><tr><td width="20%" valign=top style='width:20.0%;border:solid black 1.0pt;border-top:none;padding:2.15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal><span class=Attribute><span style='font-size:10.0pt'>containsBlank</span></span><span style='font-size:10.0pt'> (<w:Sdt PrefixMappings="xmlns:ns0='http://schemas.microsoft.com/schemaDocumentation/2007/longNames'" Xpath="/ns0:longNames/ns0:book58b4b18cd73049d693f77fc55fee6899" Text="t" StoreItemID="X_C077731C-C7F2-42FA-ACA0-2E15C9DA31EE" ID="1882399269">Contains Blank</w:Sdt>)<o:p></o:p></span></p></td><td width="80%" valign=top style='width:80.0%;border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:2.15pt 5.75pt 2.15pt 5.75pt'><w:Sdt SdtTag="58b4b18c-d730-49d6-93f7-7fc55fee6899" ID="1882399270"><p class=MsoNormal><span style='font-size:10.0pt'>Specifies a boolean value that indicates whether this field contains a blank value. <o:p></o:p><w:sdtPr></w:sdtPr></span></p><p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'>A value of </span><span class=Attributevalue><span style='font-size:10.0pt'>1</span></span><span style='font-size:10.0pt'> or </span><span class=Attributevalue><span style='font-size:10.0pt'>true</span></span><span style='font-size:10.0pt'> indicates this field contains one or more blank values.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'>A value of </span><span class=Attributevalue><span style='font-size:10.0pt'>0</span></span><span style='font-size:10.0pt'> or </span><span class=Attributevalue><span style='font-size:10.0pt'>false</span></span><span style='font-size:10.0pt'> indicates this field does not contain blank values.<o:p></o:p></span></p></w:Sdt><p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'>The possible values for this attribute are defined by the W3C XML Schema </span><span class=Type><span style='font-size:10.0pt'>boolean</span></span><span style='font-size:10.0pt'> datatype.<o:p></o:p></span></p></td></tr><tr><td width="20%" valign=top style='width:20.0%;border:solid black 1.0pt;border-top:none;padding:2.15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal><span class=Attribute><span style='font-size:10.0pt'>containsDate</span></span><span style='font-size:10.0pt'> (<w:Sdt PrefixMappings="xmlns:ns0='http://schemas.microsoft.com/schemaDocumentation/2007/longNames'" Xpath="/ns0:longNames/ns0:book2fbca2e614dc46c79d0402bc2ec4a28c" Text="t" StoreItemID="X_C077731C-C7F2-42FA-ACA0-2E15C9DA31EE" ID="1882399271">Contains Date</w:Sdt>)<o:p></o:p></span></p></td><td width="80%" valign=top style='width:80..0%;border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:2.15pt 5.75pt 2.15pt 5.75pt'><w:Sdt SdtTag="2fbca2e6-14dc-46c7-9d04-02bc2ec4a28c" ID="1882399272"><p class=MsoNormal><span style='font-size:10.0pt'>Specifies a boolean value that indicates that the field contains at least one date. <o:p></o:p><w:sdtPr></w:sdtPr></span></p><p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'>A value of </span><span class=Attributevalue><span style='font-size:10.0pt'>1</span></span><span style='font-size:10.0pt'> or </span><span class=Attributevalue><span style='font-size:10.0pt'>true</span></span><span style='font-size:10.0pt'> indicates the field contains at least one date value.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'>A value of </span><span class=Attributevalue><span style='font-size:10.0pt'>0</span></span><span style='font-size:10.0pt'> or </span><span class=Attributevalue><span style='font-size:10.0pt'>false</span></span><span style='font-size:10.0pt'> indicates the field does not contain any date values.<o:p></o:p></span></p></w:Sdt><p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'>The possible values for this attribute are defined by the W3C XML Schema </span><span class=Type><span style='font-size:10.0pt'>boolean</span></span><span style='font-size:10.0pt'> datatype.<o:p></o:p></span></p></td></tr><tr><td width="20%" valign=top style='width:20.0%;border:solid black 1.0pt;border-top:none;padding:2.15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal><span class=Attribute><span style='font-size:10.0pt'>containsInteger</span></span><span style='font-size:10.0pt'> (<w:Sdt PrefixMappings="xmlns:ns0='http://schemas.microsoft.com/schemaDocumentation/2007/longNames'" Xpath="/ns0:longNames/ns0:book2b0e0e3ad6784bb0b29058a40a538818" Text="t" StoreItemID="X_C077731C-C7F2-42FA-ACA0-2E15C9DA31EE" ID="1882399273">Contains Integer</w:Sdt>)<o:p></o:p></span></p></td><td width="80%" valign=top style='width:80.0%;border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:2.15pt 5.75pt 2.15pt 5.75pt'><w:Sdt SdtTag="2b0e0e3a-d678-4bb0-b290-58a40a538818" ID="1882399274"><p class=MsoNormal><span style='font-size:10.0pt'>Specifies a boolean value that indicates whether this field contains integer values. <o:p></o:p><w:sdtPr></w:sdtPr></span></p><p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'>A value of </span><span class=Attributevalue><span style='font-size:10.0pt'>1</span></span><span style='font-size:10.0pt'> or </span><span class=Attributevalue><span style='font-size:10.0pt'>true</span></span><span style='font-size:10.0pt'> indicates this field contains integer values.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'>A value of </span><span class=Attributevalue><span style='font-size:10.0pt'>0</span></span><span style='font-size:10.0pt'> or </span><span class=Attributevalue><span style='font-size:10.0pt'>false</span></span><span style='font-size:10.0pt'> indicates non-integer or mixed values.<o:p></o:p></span></p></w:Sdt><p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'>The possible values for this attribute are defined by the W3C XML Schema </span><span class=Type><span style='font-size:10.0pt'>boolean</span></span><span style='font-size:10.0pt'> datatype.<o:p></o:p></span></p></td></tr><tr><td width="20%" valign=top style='width:20.0%;border:solid black 1.0pt;border-top:none;padding:2.15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal><span class=Attribute><span style='font-size:10.0pt'>containsMixedTypes</span></span><span style='font-size:10.0pt'> (<w:Sdt PrefixMappings="xmlns:ns0='http://schemas.microsoft.com/schemaDocumentation/2007/longNames'" Xpath="/ns0:longNames/ns0:book3a3bd73d98bd4cfa87706b3f788e6bd3" Text="t" StoreItemID="X_C077731C-C7F2-42FA-ACA0-2E15C9DA31EE" ID="1882399275">Contains Mixed Data Types</w:Sdt>)<o:p></o:p></span></p></td><td width="80%" valign=top style='width:80.0%;border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1..0pt;padding:2.15pt 5.75pt 2.15pt 5.75pt'><w:Sdt SdtTag="3a3bd73d-98bd-4cfa-8770-6b3f788e6bd3" ID="1882399276"><p class=MsoNormal><span style='font-size:10.0pt'>Specifies a boolean value that indicates whether this field contains more than one data type. <o:p></o:p><w:sdtPr></w:sdtPr></span></p><p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'>A value of </span><span class=Attributevalue><span style='font-size:10.0pt'>1</span></span><span style='font-size:10.0pt'> or </span><span class=Attributevalue><span style='font-size:10.0pt'>true</span></span><span style='font-size:10.0pt'> indicates this field contains more than one data type.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'>A value of </span><span class=Attributevalue><span style='font-size:10.0pt'>0</span></span><span style='font-size:10.0pt'> or </span><span class=Attributevalue><span style='font-size:10.0pt'>false</span></span><span style='font-size:10.0pt'> indicates contains only one data type. The field can still contain blank values.<o:p></o:p></span></p></w:Sdt><p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'>The possible values for this attribute are defined by the W3C XML Schema </span><span class=Type><span style='font-size:10.0pt'>boolean</span></span><span style='font-size:10.0pt'> datatype.<o:p></o:p></span></p></td></tr><tr><td width="20%" valign=top style='width:20.0%;border:solid black 1.0pt;border-top:none;padding:2.15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal><span class=Attribute><span style='font-size:10.0pt'>containsNonDate</span></span><span style='font-size:10.0pt'> (<w:Sdt PrefixMappings="xmlns:ns0='http://schemas.microsoft.com/schemaDocumentation/2007/longNames'" Xpath="/ns0:longNames/ns0:book34ee8fbdf42744fbbec23dfc3faa98b2" Text="t" StoreItemID="X_C077731C-C7F2-42FA-ACA0-2E15C9DA31EE" ID="1882399277">Contains Non Date</w:Sdt>)<o:p></o:p></span></p></td><td width="80%" valign=top style='width:80.0%;border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:2.15pt 5.75pt 2.15pt 5.75pt'><w:Sdt SdtTag="34ee8fbd-f427-44fb-bec2-3dfc3faa98b2" ID="1882399278"><p class=MsoNormal><span style='font-size:10.0pt'>Specifies a boolean value that indicates that the field contains at least one value that is not a date. <o:p></o:p><w:sdtPr></w:sdtPr></span></p><p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'>A value of </span><span class=Attributevalue><span style='font-size:10.0pt'>1</span></span><span style='font-size:10.0pt'> or </span><span class=Attributevalue><span style='font-size:10.0pt'>true</span></span><span style='font-size:10.0pt'> indicates the field contains at least one non-date values.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'>A value of </span><span class=Attributevalue><span style='font-size:10.0pt'>0</span></span><span style='font-size:10.0pt'> or </span><span class=Attributevalue><span style='font-size:10.0pt'>false</span></span><span style='font-size:10.0pt'> indicates this field contains no date fields.<o:p></o:p></span></p></w:Sdt><p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'>The possible values for this attribute are defined by the W3C XML Schema </span><span class=Type><span style='font-size:10.0pt'>boolean</span></span><span style='font-size:10.0pt'> datatype.<o:p></o:p></span></p></td></tr><tr><td width="20%" valign=top style='width:20.0%;border:solid black 1.0pt;border-top:none;padding:2.15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal><span class=Attribute><span style='font-size:10.0pt'>containsNumber</span></span><span style='font-size:10.0pt'> (<w:Sdt PrefixMappings="xmlns:ns0='http://schemas.microsoft.com/schemaDocumentation/2007/longNames'" Xpath="/ns0:longNames/ns0:book0bfe98c50944481da84fa05b49f52994" Text="t" StoreItemID="X_C077731C-C7F2-42FA-ACA0-2E15C9DA31EE" ID="1882399279">Contains Numbers</w:Sdt>)<o:p></o:p></span></p></td><td width="80%" valign=top style='width:80.0%;border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:2.15pt 5.75pt 2.15pt 5.75pt'><w:Sdt SdtTag="0bfe98c5-0944-481d-a84f-a05b49f52994" ID="1882399280"><p class=MsoNormal><span style='font-size:10.0pt'>Specifies a boolean value that indicates whether this field contains numeric values. <o:p></o:p><w:sdtPr></w:sdtPr></span></p><p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'>A value of </span><span class=Attributevalue><span style='font-size:10.0pt'>1</span></span><span style='font-size:10.0pt'> or </span><span class=Attributevalue><span style='font-size:10.0pt'>true</span></span><span style='font-size:10.0pt'> indicates this field contains at least one numeric value.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'>A value of </span><span class=Attributevalue><span style='font-size:10.0pt'>0</span></span><span style='font-size:10.0pt'> or </span><span class=Attributevalue><span style='font-size:10.0pt'>false</span></span><span style='font-size:10.0pt'> indicates this field contains no numeric values.<o:p></o:p></span></p></w:Sdt><p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'>The possible values for this attribute are defined by the W3C XML Schema </span><span class=Type><span style='font-size:10.0pt'>boolean</span></span><span style='font-size:10.0pt'> datatype.<o:p></o:p></span></p></td></tr><tr><td width="20%" valign=top style='width:20.0%;border:solid black 1.0pt;border-top:none;padding:2.15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal><span class=Attribute><span style='font-size:10.0pt'>containsSemiMixedTypes</span></span><span style='font-size:10.0pt'> (<w:Sdt PrefixMappings="xmlns:ns0='http://schemas.microsoft.com/schemaDocumentation/2007/longNames'" Xpath="/ns0:longNames/ns0:book06833c5492854c00a049a10ffa002f9f" Text="t" StoreItemID="X_C077731C-C7F2-42FA-ACA0-2E15C9DA31EE" ID="1882399281">Contains Semi Mixed Data Types</w:Sdt>)<o:p></o:p></span></p></td><td width="80%" valign=top style='width:80.0%;border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:2.15pt 5.75pt 2.15pt 5.75pt'><w:Sdt SdtTag="06833c54-9285-4c00-a049-a10ffa002f9f" ID="1882399282"><p class=MsoNormal><span style='font-size:10.0pt'>Specifies a boolean value that indicates that this field contains text values. The field can also contain a mix of other data type and blank values. <o:p></o:p><w:sdtPr></w:sdtPr></span></p><p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'>A value of </span><span class=Attributevalue><span style='font-size:10.0pt'>1</span></span><span style='font-size:10.0pt'> or </span><span class=Attributevalue><span style='font-size:10.0pt'>true</span></span><span style='font-size:10.0pt'> indicates at least one text value, and can also contain a mix of other data types and blank values.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'>A value of </span><span class=Attributevalue><span style='font-size:10.0pt'>0</span></span><span style='font-size:10.0pt'> or </span><span class=Attributevalue><span style='font-size:10.0pt'>false</span></span><span style='font-size:10.0pt'> indicates the field does not have a mix of text and other values.<o:p></o:p></span></p></w:Sdt><p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'>The possible values for this attribute are defined by the W3C XML Schema </span><span class=Type><span style='font-size:10.0pt'>boolean</span></span><span style='font-size:10.0pt'> datatype.<o:p></o:p></span></p></td></tr><tr><td width="20%" valign=top style='width:20.0%;border:solid black 1.0pt;border-top:none;padding:2.15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal><span class=Attribute><span style='font-size:10.0pt'>containsString</span></span><span style='font-size:10.0pt'> (<w:Sdt PrefixMappings="xmlns:ns0='http://schemas.microsoft.com/schemaDocumentation/2007/longNames'" Xpath="/ns0:longNames/ns0:book858db231fac24f9da1ad718e6271fb1a" Text="t" StoreItemID="X_C077731C-C7F2-42FA-ACA0-2E15C9DA31EE" ID="1882399283">Contains String</w:Sdt>)<o:p></o:p></span></p></td><td width="80%" valign=top style='width:80.0%;border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:2.15pt 5.75pt 2.15pt 5.75pt'><w:Sdt SdtTag="858db231-fac2-4f9d-a1ad-718e6271fb1a" ID="1882399284"><p class=MsoNormal><span style='font-size:10.0pt'>Specifies a boolean value that indicates whether this field contains a text value. <o:p></o:p><w:sdtPr></w:sdtPr></span></p><p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'>A value of </span><span class=Attributevalue><span style='font-size:10.0pt'>1</span></span><span style='font-size:10.0pt'> or </span><span class=Attributevalue><span style='font-size:10.0pt'>true</span></span><span style='font-size:10.0pt'> indicates this field contains at least one text value.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'>A value of </span><span class=Attributevalue><span style='font-size:10.0pt'>0</span></span><span style='font-size:10.0pt'> or </span><span class=Attributevalue><span style='font-size:10.0pt'>false</span></span><span style='font-size:10.0pt'> indicates this field does not contain any text values.<o:p></o:p></span></p></w:Sdt><p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'>The possible values for this attribute are defined by the W3C XML Schema </span><span class=Type><span style='font-size:10.0pt'>boolean</span></span><span style='font-size:10.0pt'> datatype.<o:p></o:p></span></p></td></tr><tr><td width="20%" valign=top style='width:20.0%;border:solid black 1.0pt;border-top:none;padding:2.15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal><span class=Attribute><span style='font-size:10.0pt'>count</span></span><span style='font-size:10.0pt'> (<w:Sdt PrefixMappings="xmlns:ns0='http://schemas.microsoft.com/schemaDocumentation/2007/longNames'" Xpath="/ns0:longNames/ns0:bookdc7068d62d8c4784a4d8690ef5effd3a" Text="t" StoreItemID="X_C077731C-C7F2-42FA-ACA0-2E15C9DA31EE" ID="1882399285">Shared Items Count</w:Sdt>)<o:p></o:p></span></p></td><td width="80%" valign=top style='width:80..0%;border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:2.15pt 5.75pt 2.15pt 5.75pt'><w:Sdt SdtTag="dc7068d6-2d8c-4784-a4d8-690ef5effd3a" ID="1882399286"><p class=MsoNormal><span style='font-size:10.0pt'>Specifies the number of shared items to load for this field.<o:p></o:p><w:sdtPr></w:sdtPr></span></p></w:Sdt><p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'>The possible values for this attribute are defined by the W3C XML Schema </span><span class=Type><span style='font-size:10.0pt'>unsignedInt</span></span><span style='font-size:10.0pt'> datatype.<o:p></o:p></span></p></td></tr><tr><td width="20%" valign=top style='width:20.0%;border:solid black 1.0pt;border-top:none;padding:2.15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal><span class=Attribute><span style='font-size:10.0pt'>longText</span></span><span style='font-size:10.0pt'> (<w:Sdt PrefixMappings="xmlns:ns0='http://schemas.microsoft.com/schemaDocumentation/2007/longNames'" Xpath="/ns0:longNames/ns0:book0d715b98edea416584d42827373036e5" Text="t" StoreItemID="X_C077731C-C7F2-42FA-ACA0-2E15C9DA31EE" ID="1882399287">Long Text</w:Sdt>)<o:p></o:p></span></p></td><td width="80%" valign=top style='width:80.0%;border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:2.15pt 5.75pt 2.15pt 5.75pt'><w:Sdt SdtTag="0d715b98-edea-4165-84d4-2827373036e5" ID="1882399288"><p class=MsoNormal><span style='font-size:10.0pt'>Specifies a boolean value that indicates whether this field contains a long text value. A string is considered long if it is over 255 <u><span style='color:blue'>Unicode</span></u> characters. <o:p></o:p><w:sdtPr></w:sdtPr></span></p><p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'>A value of </span><span class=Attributevalue><span style='font-size:10.0pt'>1</span></span><span style='font-size:10.0pt'> or </span><span class=Attributevalue><span style='font-size:10.0pt'>true</span></span><span style='font-size:10.0pt'> indicates the value contains more than 255 <u><span style='color:blue'>Unicode</span></u> characters of text.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'>A value of </span><span class=Attributevalue><span style='font-size:10.0pt'>0</span></span><span style='font-size:10.0pt'> or </span><span class=Attributevalue><span style='font-size:10.0pt'>false</span></span><span style='font-size:10.0pt'> indicates the value contains less than 255 <u><span style='color:blue'>Unicode</span></u> characters.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'>[<span class=Non-normativeBracket>Note</span>: This is used as many legacy spreadsheet application support a limit of 255 <u><span style='color:blue'> Unicode</span></u> characters for text values. <span class=Non-normativeBracket>end note</span>]<o:p></o:p></span></p></w:Sdt><p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'>The possible values for this attribute are defined by the W3C XML Schema </span><span class=Type><span style='font-size:10.0pt'>boolean</span></span><span style='font-size:10.0pt'> datatype.<o:p></o:p></span></p></td></tr><tr><td width="20%" valign=top style='width:20.0%;border:solid black 1.0pt;border-top:none;padding:2.15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal><span class=Attribute><span style='font-size:10.0pt'>maxDate</span></span><span style='font-size:10.0pt'> (<w:Sdt PrefixMappings="xmlns:ns0='http://schemas.microsoft.com/schemaDocumentation/2007/longNames'" Xpath="/ns0:longNames/ns0:bookbc48943acfd84ee594ff4b67baadf7e9" Text="t" StoreItemID="X_C077731C-C7F2-42FA-ACA0-2E15C9DA31EE" ID="1882399289">Maximum Date Time Value</w:Sdt>)<o:p></o:p></span></p></td><td width="80%" valign=top style='width:80.0%;border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:2.15pt 5.75pt 2.15pt 5.75pt'><w:Sdt SdtTag="bc48943a-cfd8-4ee5-94ff-4b67baadf7e9" ID="1882399290"><p class=MsoNormal><span style='font-size:10.0pt'>Specifies the maximum date/time value found in a date field.<o:p></o:p><w:sdtPr></w:sdtPr></span></p></w:Sdt><p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'>The possible values for this attribute are defined by the W3C XML Schema </span><span class=Type><span style='font-size:10..0pt'>dateTime</span></span><span style='font-size:10.0pt'> datatype.<o:p></o:p></span></p></td></tr><tr><td width="20%" valign=top style='width:20.0%;border:solid black 1.0pt;border-top:none;padding:2.15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal><span class=Attribute><span style='font-size:10.0pt'>maxValue</span></span><span style='font-size:10.0pt'> (<w:Sdt PrefixMappings="xmlns:ns0='http://schemas.microsoft.com/schemaDocumentation/2007/longNames'" Xpath="/ns0:longNames/ns0:booke604e086350d418887493649405bf054" Text="t" StoreItemID="X_C077731C-C7F2-42FA-ACA0-2E15C9DA31EE" ID="1882399291">Maximum Numeric Value</w:Sdt>)<o:p></o:p></span></p></td><td width="80%" valign=top style='width:80.0%;border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:2.15pt 5.75pt 2.15pt 5.75pt'><w:Sdt SdtTag="e604e086-350d-4188-8749-3649405bf054" ID="1882399292"><p class=MsoNormal><span style='font-size:10.0pt'>Specifies the maximum numeric value found in a numeric field.<o:p></o:p><w:sdtPr></w:sdtPr></span></p></w:Sdt><p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'>The possible values for this attribute are defined by the W3C XML Schema </span><span class=Type><span style='font-size:10.0pt'>double</span></span><span style='font-size:10.0pt'> datatype.<o:p></o:p></span></p></td></tr><tr><td width="20%" valign=top style='width:20.0%;border:solid black 1.0pt;border-top:none;padding:2.15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal><span class=Attribute><span style='font-size:10.0pt'>minDate</span></span><span style='font-size:10.0pt'> (<w:Sdt PrefixMappings="xmlns:ns0='http://schemas.microsoft.com/schemaDocumentation/2007/longNames'" Xpath="/ns0:longNames/ns0:book8d89817c4187492b9d0df28a3be21295" Text="t" StoreItemID="X_C077731C-C7F2-42FA-ACA0-2E15C9DA31EE" ID="1882399293">Minimum Date Time</w:Sdt>)<o:p></o:p></span></p></td><td width="80%" valign=top style='width:80.0%;border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:2.15pt 5.75pt 2.15pt 5.75pt'><w:Sdt SdtTag="8d89817c-4187-492b-9d0d-f28a3be21295" ID="1882399294"><p class=MsoNormal><span style='font-size:10.0pt'>Specifies the minimum date/time value found in a date field.<o:p></o:p><w:sdtPr></w:sdtPr></span></p></w:Sdt><p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'>The possible values for this attribute are defined by the W3C XML Schema </span><span class=Type><span style='font-size:10.0pt'>dateTime</span></span><span style='font-size:10.0pt'> datatype.<o:p></o:p></span></p></td></tr><tr><td width="20%" valign=top style='width:20.0%;border:solid black 1.0pt;border-top:none;padding:2.15pt 5.75pt 2.15pt 5.75pt'><p class=MsoNormal><span class=Attribute><span style='font-size:10.0pt'>minValue</span></span><span style='font-size:10.0pt'> (<w:Sdt PrefixMappings="xmlns:ns0='http://schemas.microsoft.com/schemaDocumentation/2007/longNames'" Xpath="/ns0:longNames/ns0:bookc9ac5924c51e4d7b8ea10728b55c4e06" Text="t" StoreItemID="X_C077731C-C7F2-42FA-ACA0-2E15C9DA31EE" ID="1882399295">Minimum Numeric Value</w:Sdt>)<o:p></o:p></span></p></td><td width="80%" valign=top style='width:80.0%;border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:2.15pt 5.75pt 2.15pt 5.75pt'><w:Sdt SdtTag="c9ac5924-c51e-4d7b-8ea1-0728b55c4e06" ID="1882399296"><p class=MsoNormal><span style='font-size:10.0pt'>Specifies the minimum numeric value found in a numeric field.<o:p></o:p><w:sdtPr></w:sdtPr></span></p></w:Sdt><p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt'>The possible values for this attribute are defined by the W3C XML Schema </span><span class=Type><span style='font-size:10.0pt'>double</span></span><span style='font-size:10.0pt'> datatype.<o:p></o:p></span></p></td></tr></table><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>[<span class=Non-normativeBracket>Note</span>: The W3C XML Schema definition of this element’s content model (<a href="#xsd_s_9f717ae1-0af6-4dea-b4bd-428e881e9">CT_SharedItems</a>) is located in §A.2. <span class=Non-normativeBracket>end note</span>]<o:p></o:p></p><h3 style='margin-left:0in;text-indent:0in;mso-list:none'><b><o:p> </o:p></b></h3><p class=MsoNormal><o:p> </o:p></p></div></body></html>