A user is using MapCapture Interface to bulk export an asset to a shape file to edit. However, attribute (depth) exports as a rounded integer value in the shape file not as that stored in the form eg exports as 7 instead of 6.7
Go to asset metamodel form (NM0410) and query back asset, select attribute tab. Query back appropriate attribute IIT_NUM_ATTRIB18( in example investigated) then execute query. Check length - length was 4, decimal places was 2. However, in block below also check Display width for the attribute. This was set to 4. So amended to 6 to reflect what it should be. Than got user to amend a value for depth to check could input decimal value and export correctly in shape file.
If that doesn't work check the following
As the top user ( owner of the tables ) not a sub user....
Query back Asset type GY in Asset Metamodel NM0410 form select create view button
From maintain MCP layers form MCP0300 query back asset and check views displayed in theme name and feature view. if no there select create button to create views, if create button ghosted select refresh button to update.. Then try again to export to see what happens.
If that doesn't work check the view definition for the extract process in Maintain MCP Layers, select a record from the view via sql to see what is stored ie a decimal value ? choose view sql button to see which field the attribute is exported too.
Finally if that does not work it could be due to how the information is stored internally.
Please contact exor support and send through the output from the following sql from the view being used in Maintain MCP layers for the asset extract (V_MCP_EXTRACT_GY) and the exported attribute values (ATTR_9) and owner of tables HIGHWAYS
select * from sde.column_registry
where table_name='V_MCP_EXTRACT_GY'
and owner = 'HIGHWAYS'
and column)name ='ATTR_9'
A sql change had to be made to correct this issue from data returned above to resolve