Need to get XML out put

G

gsoftwares

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"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:eek:utput 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
 
J

Joris Gillis

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.
Click to expand...
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,
 
G

gsoftwares

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"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:eek:utput 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Minimum Total Difficulty 0
Taskcproblem calendar 4
How to use ufixed when it involves multiplication a number of times?(VHDL question) 0
xsltproc question - wondering what I did wrong? 4
Need to group elements using XSLT 1
Please critique my solution: rendering HTML table using sparse data 3
Problem in xml transformation using xslt 0
Cleaning out my disk 3

Members online

No members online now.
Total: 29 (members: 0, guests: 29)
Robots: 431

Forum statistics

Threads
473,768
Messages
2,569,574
Members
45,048
Latest member
verona

Latest Threads

Top