Master Data Management with webMethods OneData : Working with webMethods OneData MDR : Appendix of Examples : getDataElementDetailbyID
getDataElementDetailbyID
Sample Input
<RepositoryId >CAPITOL</RepositoryId>
<UserId >admin</UserId>
<Password >1563472D29F72A2F0482818D662E31F8</Password>
<ClientId>1</ClientId>
<ProjectId>1</ProjectId>
<SchemaId>2</SchemaId>
<DataElementItemId >4771</DataElementItemId>
< DataElementVersionId>1</ DataElementVersionId>
<ExcludeAuditColumns >true</ExcludeAuditColumns>
Sample Output
<?xml version="1.0" encoding="UTF-8" ?>
- <OUTPUT>
- <DATA>
- <ADMIN_ITEM>
- <RECORD>
 <COLUMN>
  <NAME>ADMIN_ITEM_TYP_ID</NAME>
  <VALUE>4</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>ADMIN_ITEM_TYP_ID_DESC</NAME>
  <VALUE><![CDATA[Data Element]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>ITEM_NM</NAME>
  <VALUE><![CDATA[FLIGHT_AirborneCommNavApproachEquipment_code-ICAO]]>
  </VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>ITEM_DESC</NAME>
  <VALUE><![CDATA[Indicates the kinds of communication, navigation and
approach aid equipment available and serviceable carried on aircraft.
Represented as one to 24 one-letter codes.]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CNTXT_ITEM_ID</NAME>
  <VALUE>1569</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CNTXT_ITEM_ID_DESC</NAME>
  <VALUE><![CDATA[Generic]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>REGSTR_STUS_ID</NAME>
  <VALUE>2</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>REGSTR_STUS_ID_DESC</NAME>
  <VALUE><![CDATA[RECORDED]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>ADMIN_STUS_ID</NAME>
  <VALUE>8</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>ADMIN_STUS_ID_DESC</NAME>
  <VALUE><![CDATA[CANDIDATE]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>DATA_ID_STR</NAME>
  <VALUE><![CDATA[1893]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>VER_NR</NAME>
  <VALUE>1</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>ITEM_ID</NAME>
  <VALUE>4771</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CNTXT_VER_NR</NAME>
  <VALUE>1</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CURRNT_VER_IND</NAME>
  <VALUE>1</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CREATION_DT</NAME>
  <VALUE>2004-05-03 14:13:46</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>EFF_DT</NAME>
  <VALUE>2004-05-03 00:00:00</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CHNG_DESC_TXT</NAME>
  <VALUE><![CDATA[removed repeated terms from name. Added representation
to defn.]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>REGSTR_AUTH_ID</NAME>
  <VALUE>26</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>REGSTR_AUTH_ID_DESC</NAME>
  <VALUE><![CDATA[TEST REGISTRATION AUTHORITY]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>SUBMT_ORG_ID</NAME>
  <VALUE>26</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>SUBMT_ORG_ID_DESC</NAME>
  <VALUE><![CDATA[TEST REGISTRATION AUTHORITY]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>REGISTRR_CNTCT_ID</NAME>
  <VALUE>7</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>REGISTRR_CNTCT_ID_DESC</NAME>
  <VALUE><![CDATA[Test User]]> </VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>SUBMT_CNTCT_ID</NAME>
  <VALUE>7</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>SUBMT_CNTCT_ID_DESC</NAME>
  <VALUE><![CDATA[Test User]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CASE_FILE_ID</NAME>
  <VALUE>10</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CASE_FILE_ID_DESC</NAME>
  <VALUE><![CDATA[IO300-NAS-003]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>DE_CONC_ITEM_ID</NAME>
  <VALUE>3181</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>DE_CONC_ITEM_ID_DESC</NAME>
  <VALUE><![CDATA[FLIGHT_AirborneCommNavApproachEquipment]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>DE_CONC_VER_NR</NAME>
  <VALUE>1</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>VAL_DOM_ITEM_ID</NAME>
  <VALUE>4219</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>VAL_DOM_ITEM_ID_DESC</NAME>
  <VALUE><![CDATA[code-airborne-comm-nav-approach-equipment-ICAO]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>VAL_DOM_VER_NR</NAME>
  <VALUE>1</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CONC_DOM_ITEM_ID</NAME>
  <VALUE>2468</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CONC_DOM_ITEM_ID_DESC</NAME>
  <VALUE><![CDATA[altitude]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CONC_DOM_VER_NR</NAME>
  <VALUE>1</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>VAL_DOM_TYP_ID</NAME>
  <VALUE>17</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>VAL_DOM_TYP_ID_DESC</NAME>
  <VALUE><![CDATA[Enumerated]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>DTTYPE_ID</NAME>
<VALUE>28</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>DTTYPE_ID_DESC</NAME>
  <VALUE><![CDATA[LETTERSTRING]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CHAR_SET_ID</NAME>
  <VALUE>5</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CHAR_SET_ID_DESC</NAME>
  <VALUE><![CDATA[Extended Binary-Coded Decimal Interchange Code]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>VAL_DOM_FMT_ID</NAME>
  <VALUE>1202</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>VAL_DOM_FMT_ID_DESC</NAME>
  <VALUE><![CDATA[L...L(1,25)]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>VAL_DOM_MAX_CHAR</NAME>
  <VALUE>25</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>VAL_DOM_MIN_CHAR</NAME>
  <VALUE>1</VALUE>
 </COLUMN>
<ADMIN_ITEM_AUDIT>
<RECORD>
 <COLUMN>
  <NAME>ITEM_ID</NAME>
  <VALUE>4771</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>ITEM_ID_DESC</NAME>
  <VALUE><![CDATA[FLIGHT_AirborneCommNavApproachEquipment_code-ICAO]]>
  </VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>VER_NR</NAME>
  <VALUE>1</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CHNG_TYP_ID</NAME>
  <VALUE>45</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CHNG_TYP_ID_DESC</NAME>
  <VALUE><![CDATA[Creation]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CHNG_DESC</NAME>
  <VALUE><![CDATA[Item Created]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>TS</NAME>
  <VALUE>2004-05-03 14:13:46</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>LOG_ID</NAME>
  <VALUE>3772</VALUE>
 </COLUMN>
</RECORD>
</ADMIN_ITEM_AUDIT>

<ADMIN_ITEM_CLSFCTN_SCHM_ITEM />
<ADMIN_ITEM_REF_DOC />
<ALT_DEF />
<ALT_NMS>

<RECORD>
 <COLUMN>
  <NAME>NM_DESC</NAME>
  <VALUE><![CDATA[Field 910a]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>NM_TYP_ID</NAME>
  <VALUE>1008</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>NM_TYP_ID_DESC</NAME>
  <VALUE><![CDATA[SYSTEM SPEC REFERENC]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CNTXT_ITEM_ID</NAME>
  <VALUE>1569</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CNTXT_ITEM_ID_DESC</NAME>
  <VALUE><![CDATA[Generic]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CNTXT_VER_NR</NAME>
  <VALUE>1</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>LANG_ID</NAME>
  <VALUE>1000</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>LANG_ID_DESC</NAME>
  <VALUE><![CDATA[ENGLISH]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>ITEM_ID</NAME>
  <VALUE>4771</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>ITEM_ID_DESC</NAME>
  <VALUE><![CDATA[4771]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>VER_NR</NAME>
  <VALUE>1</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>NM_ID</NAME>
  <VALUE>102</VALUE>
 </COLUMN>
</RECORD>
</ALT_NMS>
<DE_DERV />
<DE_REL />
<VW_CMNTS />
<VW_EXMPLS />
<PERM_VAL>
<RECORD>
 <COLUMN>
  <NAME>PERM_VAL_NM</NAME>
  <VALUE><![CDATA[SEE TEST ORDER 7110.10]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>VAL_MEAN_ID</NAME>
  <VALUE>32</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>VAL_MEAN_ID_DESC</NAME>
  <VALUE><![CDATA[AIRBORNE COMM/NAV/APPROACH EQUIPMENT: Indicates which
of 24 ICAO groupings of communications, navigation, and approach equipment
are available and serviceable for the flight.]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>VAL_DOM_ITEM_ID</NAME>
  <VALUE>4219</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>VAL_DOM_ITEM_ID_DESC</NAME>
  <VALUE><![CDATA[4219]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>PERM_VAL_BEG_DT</NAME>
  <VALUE>2004-11-02 09:23:19</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>VAL_DOM_VER_NR</NAME>
  <VALUE>1</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>VAL_ID</NAME>
  <VALUE>33</VALUE>
 </COLUMN>
</RECORD>
</PERM_VAL>
</RECORD>
</ADMIN_ITEM>
</DATA>
</OUTPUT>
Copyright © 2011-2017 Software AG, Darmstadt, Germany. (Innovation Release)

Product LogoContact Support   |   Community   |   Feedback