Need to get XML out put

Discussion in 'XML' started by gsoftwares@gmail.com, Dec 16, 2004.

  1. Guest

    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
     
    , Dec 16, 2004
    #1
    1. Advertising

  2. Joris Gillis Guest

    > 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-view.cgi?userid=38041)
    Spread the wiki (http://en.wikipedia.org)
     
    Joris Gillis, Dec 16, 2004
    #2
    1. Advertising

  3. Guest

    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
     
    , Dec 16, 2004
    #3
    1. Advertising

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Replies:
    0
    Views:
    457
  2. Peng Yu
    Replies:
    3
    Views:
    342
    Victor Bazarov
    Nov 19, 2004
  3. Kenneth McDonald
    Replies:
    3
    Views:
    337
  4. Gabriel Rossetti
    Replies:
    3
    Views:
    578
    Jerry Hill
    Apr 25, 2008
  5. newbie30

    Why cant i get out put from this

    newbie30, Aug 13, 2009, in forum: C Programming
    Replies:
    0
    Views:
    280
    newbie30
    Aug 13, 2009
Loading...

Share This Page