To inspect field table on the Data Pump SQL series.
/* Show all fields and properties */ USE ASI2353; SELECT * FROM [dbo].[Field] WHERE [Name] IS NOT NULL ORDER BY [Position]; -– /* Show fields which have units */ USE ASI2353; SELECT [Name], [Unit] FROM [dbo].[Field] WHERE [Name] IS NOT NULL AND [Unit] IS NOT NULL ORDER BY [Position]; -– /* Show all measurement fields */ USE ASI2353; SELECT [Name], [Unit] FROM [dbo].[Field] WHERE [Name] IS NOT NULL AND [IsMeasurement] = 1 ORDER BY [Position]; -– /* Show all result fields */ USE ASI2353; SELECT [Name] FROM [dbo].[Field] WHERE [Name] IS NOT NULL AND [IsResult] = 1 ORDER BY [Position];
See more about the fields in the knowledge database.