getClassificationSchemeItemHierarchyByName
Sample Input
<RepositoryId>CAPITOL</RepositoryId>
<UserId>admin</UserId>
<Password>1563472D29F72A2F0482818D662E31F8</Password>
<ClientId>1</ClientId>
<ProjectId>1</ProjectId>
<SchemaId>2</SchemaId>
<ClassificationScheme>
PersonalPropertyAsset_ClassFull_Code
</ClassificationScheme>
<ContextName>Generic</ContextName>
<NameColumnName/>
<ExcludeAuditColumns>true</ExcludeAuditColumns>
<IncludeAdministeredItems>false</ IncludeAdministeredItems>
Sample Output
<?xml version="1.0" encoding="UTF-8" ?>
<OUTPUT>
<DATA>
<ADMIN_ITEM>
<RECORD>
<COLUMN>
<NAME>ADMIN_ITEM_TYP_ID</NAME>
<VALUE>9</VALUE>
</COLUMN>
<COLUMN>
<NAME>ADMIN_ITEM_TYP_ID_DESC</NAME>
<VALUE><![CDATA[Classification Scheme]]></VALUE>
</COLUMN>
<COLUMN>
<NAME>ITEM_NM</NAME>
<VALUE><![CDATA[PersonalPropertyAsset_ClassFull_Code]]></VALUE>
</COLUMN>
<COLUMN>
<NAME>VER_NR</NAME>
<VALUE>1</VALUE>
</COLUMN>
<COLUMN>
<NAME>ITEM_ID</NAME>
<VALUE>6020</VALUE>
</COLUMN>
<COLUMN>
<NAME>CURRNT_VER_IND</NAME>
<VALUE>0</VALUE>
</COLUMN>
<COLUMN>
<NAME>CREATION_DT</NAME>
<VALUE>2006-05-16 15:00:26</VALUE>
</COLUMN>
<COLUMN>
<NAME>FLD_DELETE</NAME>
<VALUE>0</VALUE>
</COLUMN>
<COLUMN>
<NAME>LST_DEL_DT</NAME>
<VALUE>2006-05-16 15:00:26</VALUE>
</COLUMN>
<COLUMN>
<NAME>S2P_TRN_DT</NAME>
<VALUE>2006-05-16 15:00:26</VALUE>
</COLUMN>
<COLUMN>
<NAME>CREAT_USR_ID</NAME>
<VALUE><![CDATA[ADMIN]]></VALUE>
</COLUMN>
<COLUMN>
<NAME>LST_UPD_USR_ID</NAME>
<VALUE><![CDATA[ADMIN]]></VALUE>
</COLUMN>
<COLUMN>
<NAME>LST_UPD_DT</NAME>
<VALUE>2006-05-16 15:00:26</VALUE>
</COLUMN>
<COLUMN>
<NAME>CREAT_DT</NAME>
<VALUE>2006-05-16 15:00:28</VALUE>
</COLUMN>
<CLSFCTN_SCHM_ITEM>
<RECORD>
<COLUMN>
<NAME>CLSFCTN_SCHM_ITEM_NM</NAME>
<VALUE><![CDATA[ci1]]></VALUE>
</COLUMN>
<COLUMN>
<NAME>CLSFCTN_SCHM_ID</NAME>
<VALUE>6020</VALUE>
</COLUMN>
<COLUMN>
<NAME>CLSFCTN_SCHM_VER_NR</NAME>
<VALUE>1</VALUE>
</COLUMN>
<COLUMN>
<NAME>CLSFCTN_SCHM_ITEM_ID</NAME>
<VALUE>101</VALUE>
</COLUMN>
<COLUMN>
<NAME>CREAT_DT</NAME>
<VALUE>2006-06-05 16:44:00</VALUE>
</COLUMN>
<COLUMN>
<NAME>CREAT_USR_ID</NAME>
<VALUE><![CDATA[ADMIN]]>
</VALUE>
</COLUMN>
<COLUMN>
<NAME>LST_UPD_USR_ID</NAME>
<VALUE><![CDATA[ADMIN]]></VALUE>
</COLUMN>
<COLUMN>
<NAME>FLD_DELETE</NAME>
<VALUE>0</VALUE>
</COLUMN>
<COLUMN>
<NAME>LST_DEL_DT</NAME>
<VALUE>2006-06-05 16:44:00</VALUE>
</COLUMN>
<COLUMN>
<NAME>S2P_TRN_DT</NAME>
<VALUE>2006-06-05 16:44:00</VALUE>
</COLUMN>
<COLUMN>
<NAME>LST_UPD_DT</NAME>
<VALUE>2006-06-05 16:44:00</VALUE>
</COLUMN>
<CLSFCTN_SCHM_ITEM>
<RECORD>
<COLUMN>
<NAME>CLSFCTN_SCHM_ITEM_NM</NAME>
<VALUE><![CDATA[CI11]]></VALUE>
</COLUMN>
<COLUMN>
<NAME>CLSFCTN_SCHM_ID</NAME>
<VALUE>6020</VALUE>
</COLUMN>
<COLUMN>
<NAME>CLSFCTN_SCHM_VER_NR</NAME>
<VALUE>1</VALUE>
</COLUMN>
<COLUMN>
<NAME>PRNT_CLSFCTN_SCHM_ITEM_ID</NAME>
<VALUE>101</VALUE>
</COLUMN>
<COLUMN>
<NAME>CLSFCTN_SCHM_ITEM_ID</NAME>
<VALUE>102</VALUE>
</COLUMN>
<COLUMN>
<NAME>CREAT_DT</NAME>
<VALUE>2006-06-05 16:44:00</VALUE>
</COLUMN>
<COLUMN>
<NAME>CREAT_USR_ID</NAME>
<VALUE><![CDATA[ADMIN]]></VALUE>
</COLUMN>
<COLUMN>
<NAME>LST_UPD_USR_ID</NAME>
<VALUE><![CDATA[ADMIN]]></VALUE>
</COLUMN>
<COLUMN>
<NAME>FLD_DELETE</NAME>
<VALUE>0</VALUE>
</COLUMN>
<COLUMN>
<NAME>LST_DEL_DT</NAME>
<VALUE>2006-06-05 16:44:00</VALUE>
</COLUMN>
<COLUMN>
<NAME>S2P_TRN_DT</NAME>
<VALUE>2006-06-05 16:44:00</VALUE>
</COLUMN>
<COLUMN>
<NAME>LST_UPD_DT</NAME>
<VALUE>2006-06-05 16:44:05</VALUE>
</COLUMN>
<CLSFCTN_SCHM_ITEM>
<RECORD>
<COLUMN>
<NAME>CLSFCTN_SCHM_ITEM_NM</NAME>
<VALUE><![CDATA[CI111]]></VALUE>
</COLUMN>
<COLUMN>
<NAME>CLSFCTN_SCHM_ID</NAME>
<VALUE>6020</VALUE>
</COLUMN>
<COLUMN>
<NAME>CLSFCTN_SCHM_VER_NR</NAME>
<VALUE>1</VALUE>
</COLUMN>
<COLUMN>
<NAME>PRNT_CLSFCTN_SCHM_ITEM_ID</NAME>
<VALUE>102</VALUE>
</COLUMN>
<COLUMN>
<NAME>CLSFCTN_SCHM_ITEM_ID</NAME>
<VALUE>103</VALUE>
</COLUMN>
<COLUMN>
<NAME>CREAT_DT</NAME>
<VALUE>2006-06-05 16:44:00</VALUE>
</COLUMN>
<COLUMN>
<NAME>CREAT_USR_ID</NAME>
<VALUE><![CDATA[ADMIN]]></VALUE>
</COLUMN>
<COLUMN>
<NAME>LST_UPD_USR_ID</NAME>
<VALUE><![CDATA[ADMIN]]></VALUE>
</COLUMN>
<COLUMN>
<NAME>FLD_DELETE</NAME>
<VALUE>0</VALUE>
</COLUMN>
<COLUMN>
<NAME>LST_DEL_DT</NAME>
<VALUE>2006-06-05 16:44:00</VALUE>
</COLUMN>
<COLUMN>
<NAME>S2P_TRN_DT</NAME>
<VALUE>2006-06-05 16:44:00</VALUE>
</COLUMN>
<COLUMN>
<NAME>LST_UPD_DT</NAME>
<VALUE>2006-06-05 16:44:05</VALUE>
</COLUMN>
</RECORD>
</CLSFCTN_SCHM_ITEM>
</RECORD>
<RECORD>
<COLUMN>
<NAME>CLSFCTN_SCHM_ITEM_NM</NAME>
<VALUE><![CDATA[ci12]]></VALUE>
</COLUMN>
<COLUMN>
<NAME>CLSFCTN_SCHM_ID</NAME>
<VALUE>6020</VALUE>
</COLUMN>
<COLUMN>
<NAME>CLSFCTN_SCHM_VER_NR</NAME>
<VALUE>1</VALUE>
</COLUMN>
<COLUMN>
<NAME>PRNT_CLSFCTN_SCHM_ITEM_ID</NAME>
<VALUE>101</VALUE>
</COLUMN>
<COLUMN>
<NAME>CLSFCTN_SCHM_ITEM_ID</NAME>
<VALUE>104</VALUE>
</COLUMN>
<COLUMN>
<NAME>CREAT_DT</NAME>
<VALUE>2006-06-05 16:44:00</VALUE>
</COLUMN>
<COLUMN>
<NAME>CREAT_USR_ID</NAME>
<VALUE><![CDATA[ADMIN]]></VALUE>
</COLUMN>
<COLUMN>
<NAME>LST_UPD_USR_ID</NAME>
<VALUE><![CDATA[ADMIN]]></VALUE>
</COLUMN>
<COLUMN>
<NAME>FLD_DELETE</NAME>
<VALUE>0</VALUE>
</COLUMN>
<COLUMN>
<NAME>LST_DEL_DT</NAME>
<VALUE>2006-06-05 16:44:00</VALUE>
</COLUMN>
<COLUMN>
<NAME>S2P_TRN_DT</NAME>
<VALUE>2006-06-05 16:44:00</VALUE>
</COLUMN>
<COLUMN>
<NAME>LST_UPD_DT</NAME>
<VALUE>2006-06-05 16:44:05</VALUE>
</COLUMN>
<CLSFCTN_SCHM_ITEM />
</RECORD>
</CLSFCTN_SCHM_ITEM>
</RECORD>
<RECORD>
<COLUMN>
<NAME>CLSFCTN_SCHM_ITEM_NM</NAME>
<VALUE><![CDATA[ci2]]></VALUE>
</COLUMN>
<COLUMN>
<NAME>CLSFCTN_SCHM_ID</NAME>
<VALUE>6020</VALUE>
</COLUMN>
<COLUMN>
<NAME>CLSFCTN_SCHM_VER_NR</NAME>
<VALUE>1</VALUE>
</COLUMN>
<COLUMN>
<NAME>CLSFCTN_SCHM_ITEM_ID</NAME>
<VALUE>105</VALUE>
</COLUMN>
<COLUMN>
<NAME>CREAT_DT</NAME>
<VALUE>2006-06-05 16:44:00</VALUE>
</COLUMN>
<COLUMN>
<NAME>CREAT_USR_ID</NAME>
<VALUE><![CDATA[ADMIN]]></VALUE>
</COLUMN>
<COLUMN>
<NAME>LST_UPD_USR_ID</NAME>
<VALUE><![CDATA[ADMIN]]></VALUE>
</COLUMN>
<COLUMN>
<NAME>FLD_DELETE</NAME>
<VALUE>0</VALUE>
</COLUMN>
<COLUMN>
<NAME>LST_DEL_DT</NAME>
<VALUE>2006-06-05 16:44:00</VALUE>
</COLUMN>
<COLUMN>
<NAME>S2P_TRN_DT</NAME>
<VALUE>2006-06-05 16:44:00</VALUE>
</COLUMN>
<COLUMN>
<NAME>LST_UPD_DT</NAME>
<VALUE>2006-06-05 16:44:00</VALUE>
</COLUMN>
<CLSFCTN_SCHM_ITEM>
<RECORD>
<COLUMN>
<NAME>CLSFCTN_SCHM_ITEM_NM</NAME>
<VALUE><![CDATA[ci21]]></VALUE>
</COLUMN>
<COLUMN>
<NAME>CLSFCTN_SCHM_ID</NAME>
<VALUE>6020</VALUE>
</COLUMN>
<COLUMN>
<NAME>CLSFCTN_SCHM_VER_NR</NAME>
<VALUE>1</VALUE>
</COLUMN>
<COLUMN>
<NAME>PRNT_CLSFCTN_SCHM_ITEM_ID</NAME>
<VALUE>105</VALUE>
</COLUMN>
<COLUMN>
<NAME>CLSFCTN_SCHM_ITEM_ID</NAME>
<VALUE>106</VALUE>
</COLUMN>
<COLUMN>
<NAME>CREAT_DT</NAME>
<VALUE>2006-06-05 16:44:00</VALUE>
</COLUMN>
<COLUMN>
<NAME>CREAT_USR_ID</NAME>
<VALUE><![CDATA[ADMIN]]></VALUE>
</COLUMN>
<COLUMN>
<NAME>LST_UPD_USR_ID</NAME>
<VALUE><![CDATA[ADMIN]]></VALUE>
</COLUMN>
<COLUMN>
<NAME>FLD_DELETE</NAME>
<VALUE>0</VALUE>
</COLUMN>
<COLUMN>
<NAME>LST_DEL_DT</NAME>
<VALUE>2006-06-05 16:44:00</VALUE>
</COLUMN>
<COLUMN>
<NAME>S2P_TRN_DT</NAME>
<VALUE>2006-06-05 16:44:00</VALUE>
</COLUMN>
<COLUMN>
<NAME>LST_UPD_DT</NAME>
<VALUE>2006-06-05 16:44:05</VALUE>
</COLUMN>
<CLSFCTN_SCHM_ITEM />
</RECORD>
</CLSFCTN_SCHM_ITEM>
</RECORD>
<RECORD>
<COLUMN>
<NAME>CLSFCTN_SCHM_ITEM_NM</NAME>
<VALUE><![CDATA[new1ci1]]></VALUE>
</COLUMN>
<COLUMN>
<NAME>CLSFCTN_SCHM_ID</NAME>
<VALUE>6020</VALUE>
</COLUMN>
<COLUMN>
<NAME>CLSFCTN_SCHM_VER_NR</NAME>
<VALUE>1</VALUE>
</COLUMN>
<COLUMN>
<NAME>CLSFCTN_SCHM_ITEM_ID</NAME>
<VALUE>121</VALUE>
</COLUMN>
<COLUMN>
<NAME>CREAT_DT</NAME>
<VALUE>2006-07-10 11:34:19</VALUE>
</COLUMN>
<COLUMN>
<NAME>CREAT_USR_ID</NAME>
<VALUE><![CDATA[ADMIN]]></VALUE>
</COLUMN>
<COLUMN>
<NAME>LST_UPD_USR_ID</NAME>
<VALUE><![CDATA[ADMIN]]></VALUE>
</COLUMN>
<COLUMN>
<NAME>FLD_DELETE</NAME>
<VALUE>0</VALUE>
</COLUMN>
<COLUMN>
<NAME>LST_DEL_DT</NAME>
<VALUE>2006-07-10 11:34:19</VALUE>
</COLUMN>
<COLUMN>
<NAME>S2P_TRN_DT</NAME>
<VALUE>2006-07-10 11:34:19</VALUE>
</COLUMN>
<COLUMN>
<NAME>LST_UPD_DT</NAME>
<VALUE>2006-07-10 11:34:19</VALUE>
</COLUMN>
<CLSFCTN_SCHM_ITEM>
<RECORD>
<COLUMN>
<NAME>CLSFCTN_SCHM_ITEM_NM</NAME>
<VALUE><![CDATA[new1CI11]]></VALUE>
</COLUMN>
<COLUMN>
<NAME>CLSFCTN_SCHM_ID</NAME>
<VALUE>6020</VALUE>
</COLUMN>
<COLUMN>
<NAME>CLSFCTN_SCHM_VER_NR</NAME>
<VALUE>1</VALUE>
</COLUMN>
<COLUMN>
<NAME>PRNT_CLSFCTN_SCHM_ITEM_ID</NAME>
<VALUE>121</VALUE>
</COLUMN>
<COLUMN>
<NAME>CLSFCTN_SCHM_ITEM_ID</NAME>
<VALUE>122</VALUE>
</COLUMN>
<COLUMN>
<NAME>CREAT_DT</NAME>
<VALUE>2006-07-10 11:34:19</VALUE>
</COLUMN>
<COLUMN>
<NAME>CREAT_USR_ID</NAME>
<VALUE><![CDATA[ADMIN]]></VALUE>
</COLUMN>
<COLUMN>
<NAME>LST_UPD_USR_ID</NAME>
<VALUE><![CDATA[ADMIN]]></VALUE>
</COLUMN>
<COLUMN>
<NAME>FLD_DELETE</NAME>
<VALUE>0</VALUE>
</COLUMN>
<COLUMN>
<NAME>LST_DEL_DT</NAME>
<VALUE>2006-07-10 11:34:19</VALUE>
</COLUMN>
<COLUMN>
<NAME>S2P_TRN_DT</NAME>
<VALUE>2006-07-10 11:34:19</VALUE>
</COLUMN>
<COLUMN>
<NAME>LST_UPD_DT</NAME>
<VALUE>2006-07-10 11:34:48</VALUE>
</COLUMN>
<CLSFCTN_SCHM_ITEM>
<RECORD>
<COLUMN>
<NAME>CLSFCTN_SCHM_ITEM_NM</NAME>
<VALUE><![CDATA[new1CI111]]></VALUE>
</COLUMN>
<COLUMN>
<NAME>CLSFCTN_SCHM_ID</NAME>
<VALUE>6020</VALUE>
</COLUMN>
<COLUMN>
<NAME>CLSFCTN_SCHM_VER_NR</NAME>
<VALUE>1</VALUE>
</COLUMN>
<COLUMN>
<NAME>PRNT_CLSFCTN_SCHM_ITEM_ID</NAME>
<VALUE>122</VALUE>
</COLUMN>
<COLUMN>
<NAME>CLSFCTN_SCHM_ITEM_ID</NAME>
<VALUE>123</VALUE>
</COLUMN>
<COLUMN>
<NAME>CREAT_DT</NAME>
<VALUE>2006-07-10 11:34:19</VALUE>
</COLUMN>
<COLUMN>
<NAME>CREAT_USR_ID</NAME>
<VALUE><![CDATA[ADMIN]]></VALUE>
</COLUMN>
<COLUMN>
<NAME>LST_UPD_USR_ID</NAME>
<VALUE><![CDATA[ADMIN]]></VALUE>
</COLUMN>
<COLUMN>
<NAME>FLD_DELETE</NAME>
<VALUE>0</VALUE>
</COLUMN>
<COLUMN>
<NAME>LST_DEL_DT</NAME>
<VALUE>2006-07-10 11:34:19</VALUE>
</COLUMN>
<COLUMN>
<NAME>S2P_TRN_DT</NAME>
<VALUE>2006-07-10 11:34:19</VALUE>
</COLUMN>
<COLUMN>
<NAME>LST_UPD_DT</NAME>
<VALUE>2006-07-10 11:34:48</VALUE>
</COLUMN>
</RECORD>
</CLSFCTN_SCHM_ITEM>
</RECORD>
</CLSFCTN_SCHM_ITEM>
</RECORD>
</CLSFCTN_SCHM_ITEM>
</RECORD>
</ADMIN_ITEM>
</DATA>
</OUTPUT>