Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > XML > Need to get XML out put

Reply
Thread Tools

Need to get XML out put

 
 
gsoftwares@gmail.com
Guest
Posts: n/a
 
      12-16-2004
Hi,

I have a XML string and I want to transform this xml with xsl to get a
xml out put. I am trying this with java code, can any one point out
where is the problem.

XML file
<ROWSET>
<ROW num="1">
<NODE_ID>1</NODE_ID>
<NODE_VALUE>DAAAA</NODE_VALUE>
<PARENT_NODE_ID>0</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_1</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>0</NODE_LEVEL_NO>
<NODE_DESC>ALL DEPARTMENTS_RANGE 00000 - 99999</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>1</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>00000</LOW_VALUE>
<HIGH_VALUE>99999</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>0</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:44</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004
18:59:44</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="2">
<NODE_ID>2</NODE_ID>
<NODE_VALUE>D1AAA</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_2</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>COST OF SALES DEPTS_RANGE 10000 - 19999</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>2</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>10000</LOW_VALUE>
<HIGH_VALUE>19999</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>1</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:44</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004
18:59:44</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="3">
<NODE_ID>4</NODE_ID>
<NODE_VALUE>D14AA</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_3</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>SERVICE COS DEPTS_RANGE 14000 - 19999</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>3</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>14000</LOW_VALUE>
<HIGH_VALUE>19999</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>1</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:44</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004
18:59:44</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="4">
<NODE_ID>6</NODE_ID>
<NODE_VALUE>D150A</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_4</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>EDUCATION DEPTS_RANGE 15000 - 15999</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>15000</LOW_VALUE>
<HIGH_VALUE>15999</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>1</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:44</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004
18:59:44</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="5">
<NODE_ID>8</NODE_ID>
<NODE_VALUE>D2AAA</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_2</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>RESEARCH AND DEVELOPMENT DEPTS_RANGE 20000 -
29999</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>2</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>20000</LOW_VALUE>
<HIGH_VALUE>29999</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>1</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:44</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004
18:59:44</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="6">
<NODE_ID>9</NODE_ID>
<NODE_VALUE>D3AAA</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_2</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>SALES DEPTS_RANGE 30000 - 69999</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>2</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>30000</LOW_VALUE>
<HIGH_VALUE>69999</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>1</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:44</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004
18:59:44</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="7">
<NODE_ID>12</NODE_ID>
<NODE_VALUE>D50AA</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_3</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>MARKETING DEPTS_RANGE 50000 - 59999</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>3</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>50000</LOW_VALUE>
<HIGH_VALUE>59999</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>1</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:45</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004
18:59:45</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="8">
<NODE_ID>14</NODE_ID>
<NODE_VALUE>D530A</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_4</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>REGIONAL MARKETING DEPTS_RANGE 53000 -
55999</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>53000</LOW_VALUE>
<HIGH_VALUE>55999</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>1</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:45</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004
18:59:45</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="9">
<NODE_ID>16</NODE_ID>
<NODE_VALUE>D60AA</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_3</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>OPEN RANGE DEPTS_RANGE 60000 - 69999</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>3</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>60000</LOW_VALUE>
<HIGH_VALUE>69999</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>1</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:45</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004
18:59:45</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="10">
<NODE_ID>25</NODE_ID>
<NODE_VALUE>D76AA</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_4</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>FACILITIES DEPTS_RANGE 76000 - 76999</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>76000</LOW_VALUE>
<HIGH_VALUE>76999</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>1</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004
18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="11">
<NODE_ID>24</NODE_ID>
<NODE_VALUE>D755A</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_4</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>OPERATIONS DEPTS_RANGE 75500 - 75999</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>75500</LOW_VALUE>
<HIGH_VALUE>75999</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>1</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004
18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="12">
<NODE_ID>23</NODE_ID>
<NODE_VALUE>D750A</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_4</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>PROCUREMENT DEPTS_RANGE 75000 - 75499</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>75000</LOW_VALUE>
<HIGH_VALUE>75499</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>1</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004
18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="13">
<NODE_ID>22</NODE_ID>
<NODE_VALUE>D74AA</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_4</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>LEGAL DEPTS_RANGE 74000 - 74999</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>74000</LOW_VALUE>
<HIGH_VALUE>74999</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>1</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:45</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004
18:59:45</LAST_UPDATED_DATETIME>
</ROW>
</ROWSET>

XLST File:

<xsl:stylesheet version="1.0"
xmlnssl="http://www.w3.org/1999/XSL/Transform">

<xslutput method="html" omit-xml-declaration="yes" indent="yes"/>

<xsl:template match="ROWSET">
<hierarchy>
<xsl:apply-templates select="ROW[PARENT_NODE_ID=0]" mode="copy"/>
</hierarchy>
</xsl:template>
<xsl:template match="ROW" mode="copy">
<xsl:element name="entity">
<xsl:attribute name="id">id<xsl:value-of
select="NODE_ID"/></xsl:attribute>
<xsl:attribute name="parent_id">id<xsl:value-of
select="PARENT_NODE_ID"/></xsl:attribute>
<xsl:attribute name="name"><xsl:value-of
select="NODE_VALUE"/></xsl:attribute>
<xsl:attribute name="description"><xsl:value-of
select="NODE_DESC"/></xsl:attribute>
<xsl:attribute name="node_state">original</xsl:attribute>
<xsl:element name="leafNode">
<xsl:value-of select="NODE_TYPE"></xsl:value-of>
</xsl:element>
<contents>
<xsl:apply-templates
select="//ROW[PARENT_NODE_ID=current()/NODE_ID]"/>
</contents>
</xsl:element>
</xsl:template>
<xsl:template match="ROW">
<xsl:apply-templates select="." mode="copy"/>
</xsl:template>

</xsl:stylesheet>


when I apply this it works fine, but result i am getting is
0111111111111111112211111

instead i want output as
<hierarchy>
<entity id="id1" parent_id="id0" name="DAAAA" description="ALL
DEPARTMENTS_RANGE 00000 - 99999" node_state="original">
<leafNode>0</leafNode>
<contents>
<entity id="id2" parent_id="id1" name="D1AAA" description="COST OF
SALES DEPTS_RANGE 10000 - 19999" node_state="original">
<leafNode>1</leafNode>
<contents />
</entity>
<entity id="id4" parent_id="id1" name="D14AA" description="SERVICE
COS DEPTS_RANGE 14000 - 19999" node_state="original">
<leafNode>1</leafNode>
<contents />
</entity>
</hierarchy>

Thanks
~GBK

 
Reply With Quote
 
 
 
 
Joris Gillis
Guest
Posts: n/a
 
      12-16-2004
> I have a XML string and I want to transform this xml with xsl to get a
> xml out put. I am trying this with java code, can any one point out
> where is the problem.
>

Hi,

You are getting the output you want, it's just that you user agent thinks it is html, so it shows html i.d. ingores any non-html elements, which results in just seeing the text nodes.
If you want to output XML, just specify it (method="xml")

regards,
--
Joris Gillis (http://www.ticalc.org/cgi-bin/acct-v...i?userid=38041)
Spread the wiki (http://en.wikipedia.org)
 
Reply With Quote
 
 
 
 
gsoftwares@gmail.com
Guest
Posts: n/a
 
      12-16-2004
hi joris,

Even after changing method="xml" i still get results as 1 01 11111

For reference my java code and xSLT:

<xsl:stylesheet version="2.0"
xmlnssl="http://www.w3.org/1999/XSL/Transform">

<xslutput method="xml" indent="yes"/>
<xsl:template match="/ROWSET">
<hierarchy>
<xsl:apply-templates select="ROW[PARENT_NODE_ID=0]" mode="copy"/>
</hierarchy>
</xsl:template>
<xsl:template match="ROW" mode="copy">
<entity>
<xsl:attribute name="id">id<xsl:value-of
select="NODE_ID"/></xsl:attribute>
<xsl:attribute name="parent_id">id<xsl:value-of
select="PARENT_NODE_ID"/></xsl:attribute>
<xsl:attribute name="name"><xsl:value-of
select="NODE_VALUE"/></xsl:attribute>
<xsl:attribute name="description"><xsl:value-of
select="NODE_DESC"/></xsl:attribute>
<xsl:attribute name="node_state">original</xsl:attribute>
<leafNode>
<xsl:value-of select="NODE_TYPE"></xsl:value-of>
</leafNode>
<contents>
<xsl:apply-templates
select="//ROW[PARENT_NODE_ID=current()/NODE_ID]"/>
</contents>
</entity>
</xsl:template>
<xsl:template match="ROW">
<xsl:apply-templates select="." mode="copy"/>
</xsl:template>

</xsl:stylesheet>

XML*********************************************** ***
<?xml version="1.0"?>
<ROWSET>
<ROW num="1">
<NODE_ID>1</NODE_ID>
<NODE_VALUE>DAAAA</NODE_VALUE>
<PARENT_NODE_ID>0</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_1</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>0</NODE_LEVEL_NO>
<NODE_DESC>ALL DEPARTMENTS_RANGE 00000 - 99999</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>1</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>00000</LOW_VALUE>
<HIGH_VALUE>99999</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>0</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:44</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:44</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="2">
<NODE_ID>2</NODE_ID>
<NODE_VALUE>D1AAA</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_2</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>COST OF SALES DEPTS_RANGE 10000 - 19999</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>2</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>10000</LOW_VALUE>
<HIGH_VALUE>19999</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>1</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:44</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:44</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="3">
<NODE_ID>4</NODE_ID>
<NODE_VALUE>D14AA</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_3</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>SERVICE COS DEPTS_RANGE 14000 - 19999</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>3</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>14000</LOW_VALUE>
<HIGH_VALUE>19999</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>1</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:44</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:44</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="4">
<NODE_ID>6</NODE_ID>
<NODE_VALUE>D150A</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_4</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>EDUCATION DEPTS_RANGE 15000 - 15999</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>15000</LOW_VALUE>
<HIGH_VALUE>15999</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>1</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:44</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:44</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="5">
<NODE_ID>8</NODE_ID>
<NODE_VALUE>D2AAA</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_2</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>RESEARCH AND DEVELOPMENT DEPTS_RANGE 20000 -
29999</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>2</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>20000</LOW_VALUE>
<HIGH_VALUE>29999</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>1</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:44</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:44</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="6">
<NODE_ID>9</NODE_ID>
<NODE_VALUE>D3AAA</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_2</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>SALES DEPTS_RANGE 30000 - 69999</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>2</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>30000</LOW_VALUE>
<HIGH_VALUE>69999</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>1</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:44</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:44</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="7">
<NODE_ID>12</NODE_ID>
<NODE_VALUE>D50AA</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_3</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>MARKETING DEPTS_RANGE 50000 - 59999</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>3</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>50000</LOW_VALUE>
<HIGH_VALUE>59999</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>1</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:45</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:45</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="8">
<NODE_ID>14</NODE_ID>
<NODE_VALUE>D530A</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_4</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>REGIONAL MARKETING DEPTS_RANGE 53000 - 55999</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>53000</LOW_VALUE>
<HIGH_VALUE>55999</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>1</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:45</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:45</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="9">
<NODE_ID>16</NODE_ID>
<NODE_VALUE>D60AA</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_3</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>OPEN RANGE DEPTS_RANGE 60000 - 69999</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>3</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>60000</LOW_VALUE>
<HIGH_VALUE>69999</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>1</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:45</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:45</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="10">
<NODE_ID>25</NODE_ID>
<NODE_VALUE>D76AA</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_4</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>FACILITIES DEPTS_RANGE 76000 - 76999</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>76000</LOW_VALUE>
<HIGH_VALUE>76999</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>1</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="11">
<NODE_ID>24</NODE_ID>
<NODE_VALUE>D755A</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_4</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>OPERATIONS DEPTS_RANGE 75500 - 75999</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>75500</LOW_VALUE>
<HIGH_VALUE>75999</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>1</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="12">
<NODE_ID>23</NODE_ID>
<NODE_VALUE>D750A</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_4</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>PROCUREMENT DEPTS_RANGE 75000 - 75499</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>75000</LOW_VALUE>
<HIGH_VALUE>75499</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>1</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="13">
<NODE_ID>22</NODE_ID>
<NODE_VALUE>D74AA</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_4</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>LEGAL DEPTS_RANGE 74000 - 74999</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>74000</LOW_VALUE>
<HIGH_VALUE>74999</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>1</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:45</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:45</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="14">
<NODE_ID>21</NODE_ID>
<NODE_VALUE>D73AA</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_4</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>IT DEPTS_RANGE 73000 - 73999</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>73000</LOW_VALUE>
<HIGH_VALUE>73999</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>1</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:45</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:45</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="15">
<NODE_ID>20</NODE_ID>
<NODE_VALUE>D72AA</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_4</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>HUMAN RESOURCES DEPTS_RANGE 72000 - 72999</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>72000</LOW_VALUE>
<HIGH_VALUE>72999</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>1</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:45</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:45</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="16">
<NODE_ID>19</NODE_ID>
<NODE_VALUE>D71AA</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_4</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>FINANCE DEPTS_RANGE 71000 - 71999</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>71000</LOW_VALUE>
<HIGH_VALUE>71999</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>1</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:45</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:45</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="17">
<NODE_ID>17</NODE_ID>
<NODE_VALUE>D7AAA</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_2</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>GENERAL DEPTS_RANGE 70000 - 89999</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>2</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>70000</LOW_VALUE>
<HIGH_VALUE>89999</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>1</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:45</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:45</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="18">
<NODE_ID>15</NODE_ID>
<NODE_VALUE>D560A</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_4</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>OTHER MARKETING DEPTS_RANGE 56000 - 59999</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>56000</LOW_VALUE>
<HIGH_VALUE>59999</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>1</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:45</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:45</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="19">
<NODE_ID>72</NODE_ID>
<NODE_VALUE>90000</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>Other Intangibles Amortization</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>2</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="20">
<NODE_ID>121</NODE_ID>
<NODE_VALUE>70000</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>Executive</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>2</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="21">
<NODE_ID>28</NODE_ID>
<NODE_VALUE>D9AAA</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_2</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>CORPORATE ONLY DEPTS_RANGE 90000 - 99999</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>2</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>90000</LOW_VALUE>
<HIGH_VALUE>99999</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>1</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="22">
<NODE_ID>27</NODE_ID>
<NODE_VALUE>D80AA</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_4</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>ALLOCATIONS DEPTS_RANGE 80000 - 89999</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>80000</LOW_VALUE>
<HIGH_VALUE>89999</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>1</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="23">
<NODE_ID>26</NODE_ID>
<NODE_VALUE>D77AA</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_4</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>OTHER G DEPTS_RANGE 77000 - 79999</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>77000</LOW_VALUE>
<HIGH_VALUE>79999</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>1</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="24">
<NODE_ID>11</NODE_ID>
<NODE_VALUE>D49AA</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_3</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>OTHER TECH SUPPORT DEPTS_RANGE 49000 - 49999</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>3</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>49000</LOW_VALUE>
<HIGH_VALUE>49999</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>1</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:44</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:44</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="25">
<NODE_ID>7</NODE_ID>
<NODE_VALUE>D160A</NODE_VALUE>
<PARENT_NODE_ID>1</PARENT_NODE_ID>
<NODE_LEVEL_NAME>VRTS_GL_DEPARTMENT_4</NODE_LEVEL_NAME>
<NODE_LEVEL_NO>1</NODE_LEVEL_NO>
<NODE_DESC>TECH SUPPORT DEPTS_RANGE 16000 - 19999</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<LOW_VALUE>16000</LOW_VALUE>
<HIGH_VALUE>19999</HIGH_VALUE>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>1</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:44</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:44</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="26">
<NODE_ID>156</NODE_ID>
<NODE_VALUE>30130</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Field Sales - Enterprise Natl Sales</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="27">
<NODE_ID>164</NODE_ID>
<NODE_VALUE>34005</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Reseller Sales</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="28">
<NODE_ID>166</NODE_ID>
<NODE_VALUE>32100</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>National Sales Exec</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="29">
<NODE_ID>187</NODE_ID>
<NODE_VALUE>40200</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Business Development/Strategic</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="30">
<NODE_ID>186</NODE_ID>
<NODE_VALUE>40210</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Strategic Ops HP</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="31">
<NODE_ID>185</NODE_ID>
<NODE_VALUE>40215</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Strategic Ops IBM</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="32">
<NODE_ID>184</NODE_ID>
<NODE_VALUE>40050</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>DMD-OEM</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="33">
<NODE_ID>183</NODE_ID>
<NODE_VALUE>40250</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Platform Alliances</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="34">
<NODE_ID>182</NODE_ID>
<NODE_VALUE>40800</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>IT Direct Charge Allocation-Sales</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="35">
<NODE_ID>180</NODE_ID>
<NODE_VALUE>32040</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Field Sales - Canada Regional</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="36">
<NODE_ID>179</NODE_ID>
<NODE_VALUE>32044</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Field Sales - Canada West</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="37">
<NODE_ID>178</NODE_ID>
<NODE_VALUE>32045</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Field Sales - Canada East</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="38">
<NODE_ID>196</NODE_ID>
<NODE_VALUE>34003</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Field Sales Engineers Disti</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="39">
<NODE_ID>195</NODE_ID>
<NODE_VALUE>36005</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Sales Automation</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="40">
<NODE_ID>194</NODE_ID>
<NODE_VALUE>36500</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>E-Business</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="41">
<NODE_ID>193</NODE_ID>
<NODE_VALUE>40000</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>OEM Sales</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="42">
<NODE_ID>192</NODE_ID>
<NODE_VALUE>40010</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>OEM Sales Exec</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="43">
<NODE_ID>191</NODE_ID>
<NODE_VALUE>40020</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>OEM Sales Regional</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="44">
<NODE_ID>190</NODE_ID>
<NODE_VALUE>40030</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>OEM MS Business Team</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="45">
<NODE_ID>189</NODE_ID>
<NODE_VALUE>40100</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Mergers test</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="46">
<NODE_ID>188</NODE_ID>
<NODE_VALUE>40205</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Global Partner Operations</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="47">
<NODE_ID>213</NODE_ID>
<NODE_VALUE>30201</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Sales Inside Renewals APM/SRM</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="48">
<NODE_ID>212</NODE_ID>
<NODE_VALUE>31200</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Appliance Advanced Products</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="49">
<NODE_ID>211</NODE_ID>
<NODE_VALUE>31201</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Sales Training</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="50">
<NODE_ID>210</NODE_ID>
<NODE_VALUE>31000</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Reseller Sales Operations</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="51">
<NODE_ID>209</NODE_ID>
<NODE_VALUE>31210</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Sales Finance Americas</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="52">
<NODE_ID>208</NODE_ID>
<NODE_VALUE>31211</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Professional Services Finance</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="53">
<NODE_ID>207</NODE_ID>
<NODE_VALUE>39007</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Sales Integration</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="54">
<NODE_ID>206</NODE_ID>
<NODE_VALUE>34080</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Field Sales Engineers</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="55">
<NODE_ID>205</NODE_ID>
<NODE_VALUE>34060</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Field Sales Engineers West</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="56">
<NODE_ID>230</NODE_ID>
<NODE_VALUE>32480</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Field Sales ROEMEA</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="57">
<NODE_ID>229</NODE_ID>
<NODE_VALUE>32066</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Field Sales Latin America</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="58">
<NODE_ID>228</NODE_ID>
<NODE_VALUE>32411</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Field Sales Asia Pac</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="59">
<NODE_ID>227</NODE_ID>
<NODE_VALUE>32026</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Nationals Telco</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="60">
<NODE_ID>226</NODE_ID>
<NODE_VALUE>32027</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Nationals Commercial</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="61">
<NODE_ID>225</NODE_ID>
<NODE_VALUE>39008</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Disti Sales Exec</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="62">
<NODE_ID>224</NODE_ID>
<NODE_VALUE>33001</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Americas Partner Sales</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="63">
<NODE_ID>223</NODE_ID>
<NODE_VALUE>33030</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Disti Channel Northeast</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="64">
<NODE_ID>222</NODE_ID>
<NODE_VALUE>33040</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Disti Channel South Central</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="65">
<NODE_ID>236</NODE_ID>
<NODE_VALUE>32303</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Field Sales - APM Americas</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="66">
<NODE_ID>235</NODE_ID>
<NODE_VALUE>40220</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Solution Partner Sales</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="67">
<NODE_ID>234</NODE_ID>
<NODE_VALUE>31203</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Field Sales Business Development</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="68">
<NODE_ID>233</NODE_ID>
<NODE_VALUE>31001</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Field Sales Strategy</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="69">
<NODE_ID>232</NODE_ID>
<NODE_VALUE>35020</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Field Sales BDM</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="70">
<NODE_ID>231</NODE_ID>
<NODE_VALUE>39006</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Field Sales SIP</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="71">
<NODE_ID>221</NODE_ID>
<NODE_VALUE>33025</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Disti Channel West</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="72">
<NODE_ID>220</NODE_ID>
<NODE_VALUE>33021</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Disti Channel Government</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="73">
<NODE_ID>219</NODE_ID>
<NODE_VALUE>32412</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Field Sales Greater China Region</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="74">
<NODE_ID>218</NODE_ID>
<NODE_VALUE>30300</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Sales Inside Regional</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="75">
<NODE_ID>217</NODE_ID>
<NODE_VALUE>30301</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Sales Inside Regional APM</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="76">
<NODE_ID>216</NODE_ID>
<NODE_VALUE>31204</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Inside Sales VES</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="77">
<NODE_ID>215</NODE_ID>
<NODE_VALUE>30302</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Sales Inside Regional SRM</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="78">
<NODE_ID>214</NODE_ID>
<NODE_VALUE>30200</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Sales Inside Renewals</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="79">
<NODE_ID>340</NODE_ID>
<NODE_VALUE>39900</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>I/C Service Fees</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:47</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:47</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="80">
<NODE_ID>301</NODE_ID>
<NODE_VALUE>31100</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Field Sales WW Exec</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="81">
<NODE_ID>300</NODE_ID>
<NODE_VALUE>30100</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Field Sales Global Accounts</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="82">
<NODE_ID>299</NODE_ID>
<NODE_VALUE>39080</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Field Sales EMEA Exec</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="83">
<NODE_ID>298</NODE_ID>
<NODE_VALUE>30900</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Field Sales Regional Exec</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="84">
<NODE_ID>297</NODE_ID>
<NODE_VALUE>32061</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Field Sales Regional</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="85">
<NODE_ID>296</NODE_ID>
<NODE_VALUE>32062</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Field Sales MV Briefing Center</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="86">
<NODE_ID>295</NODE_ID>
<NODE_VALUE>32280</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Named Accounts</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="87">
<NODE_ID>294</NODE_ID>
<NODE_VALUE>32180</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>General and Commercial</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="88">
<NODE_ID>293</NODE_ID>
<NODE_VALUE>33180</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>E-VAR's</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="89">
<NODE_ID>292</NODE_ID>
<NODE_VALUE>32054</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Field Sales West-Other</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="90">
<NODE_ID>291</NODE_ID>
<NODE_VALUE>32052</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Field Sales Pacific NW</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="91">
<NODE_ID>290</NODE_ID>
<NODE_VALUE>32051</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Field Sales Bay Area</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="92">
<NODE_ID>289</NODE_ID>
<NODE_VALUE>39051</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Field Sales Bay Area 2</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="93">
<NODE_ID>288</NODE_ID>
<NODE_VALUE>32053</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Field Sales SW</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="94">
<NODE_ID>287</NODE_ID>
<NODE_VALUE>39041</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Field Sales Central - Other</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="95">
<NODE_ID>286</NODE_ID>
<NODE_VALUE>32041</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Field Sales - Central Plains</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="96">
<NODE_ID>285</NODE_ID>
<NODE_VALUE>32042</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Field Sales - Midwest</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="97">
<NODE_ID>284</NODE_ID>
<NODE_VALUE>32031</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Field Sales Great Lakes</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="98">
<NODE_ID>283</NODE_ID>
<NODE_VALUE>32043</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Field Sales Southeast</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="99">
<NODE_ID>282</NODE_ID>
<NODE_VALUE>32034</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Field Sales Northeast GC</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="100">
<NODE_ID>281</NODE_ID>
<NODE_VALUE>32033</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>Field Sales NE Financials</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
<ROW num="101">
<NODE_ID>280</NODE_ID>
<NODE_VALUE>32035</NODE_VALUE>
<PARENT_NODE_ID>10</PARENT_NODE_ID>
<NODE_LEVEL_NO>3</NODE_LEVEL_NO>
<NODE_DESC>East Strategic Accounts</NODE_DESC>
<NODE_LEVEL_FOR_REPORTING>4</NODE_LEVEL_FOR_REPORTING>
<HIERARCHY_ID>60</HIERARCHY_ID>
<NODE_TYPE>2</NODE_TYPE>
<CREATION_DATETIME>12/16/2004 18:59:46</CREATION_DATETIME>
<LAST_UPDATED_DATETIME>12/16/2004 18:59:46</LAST_UPDATED_DATETIME>
</ROW>
</ROWSET>

and java code*******************************************
public static String transformXmlUsingXSL(String xmlString, String
xsltString) throws IOException,
TransformerConfigurationException, TransformerException {
String transformedXmlString = null;
TransformerFactory factory;



StringWriter outputString = new StringWriter();
TransformerFactory tFactory = TransformerFactory.newInstance();
Transformer transformer = tFactory.newTransformer(new
StreamSource(new
StringReader(xsltString)));



transformer.transform(new StreamSource(new
StringReader(xmlString)),
new StreamResult(outputString));



outputString.close();
transformedXmlString = outputString.toString();
tFactory = null;
transformer = null;
outputString = null;
return transformedXmlString;
}


can you please help me find error

thanks agian

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Put Eye Out - Need Advice James Smith Computer Support 23 12-11-2010 03:14 AM
Why cant i get out put from this newbie30 C Programming 0 08-13-2009 03:12 PM
why does the following with Queue, q.put('\x02', True) not put itin the queue? Gabriel Rossetti Python 3 04-25-2008 03:41 PM
Registration opens for XML 2005; Respected XML Forum Delivers Practical Information That Attendees Can Put to Immediate Use within Their Organizations melledge XML 0 07-21-2005 07:27 PM
Print XML parsing to JspWriter (out) Class org.xml.sax.helpers.NewInstance can not access a member of class javax.xml.parsers.SAXParser with modifiers "protected" Per Magnus L?vold Java 0 11-15-2004 02:27 PM



Advertisments