Waters Empower Table Structure and Relationships

This page describes the Waters Empower Table structure. Understanding the structure of the IDS Entity Relationship diagrams may help you determine:

What data to query
How to structure your SQL queries

This diagram shows the Empower entity relationship:

Tables

This table describes the Water Empower tables. For more details, you can search the table and view its table definition.

Table Name	Description
lcuv_empower_v5_injection	This is the root table. It provides basic information about each injection including: assigned name, description of the injection, and the dimension, measure, and project names.
lcuv_empower_v5_injection_custom_fields	Provides information about each injection, including a key value (such as: Storage Conditions, Stability Point, Analysis Number, or Batch Number. The value, data type, any numerical or boolean values, and project information is also included.
lcuv_empower_v5_method_instrument_columns	Provides information on the serial number, name, injection and sample counts, maximum pressure values and units, maximum temperature value and unit, ecord serial number name, and project name.
lcuv_empower_v5_results	Contains information on ID, time, set information, and sample information (for example: name, weight value and unit, sample type, dilution, and more.
lcuv_empower_v5_results_peaks	Contains information about the number, analyte, height area and retention time values and units, resolution, USP tailing and resolution, signal to noise ratio, K-prime, amount value and unit, area percentage, integration value, code, retention time and start time values, and more.
lcuv_empower_v5_results_peaks_custom_fields	Provides information about result peak values, organized by key and value.
lcuv_empower_v5_results_custom_fields	Provides information about result organized by key and value.
lcuv_empower_v5_results_sign_offs	Provides information on who completed the signoff, the level, date, method information, reason, type, project, and result ID information.
lcuv_empower_v5_method_instrument_setups	Provides details, instrument status, and other instrument setting information such as the flow_unit, pump mode, and degas mode.
lcuv_empower_v5_sample_set_custom_fields	(see other custom field description).
lcuv_empower_v5_sample_set_method_custom_fields	Provides information about sample set methods, organized by key and value.
lcuv_empower_v5_method_processing _parameter_integration_custom_fields	Provides information about parameter integration, organized by key and value.
lcuv_empower_v5_method_processing _parameter_system_suitability_custom_fields	Provides information about parameter system suitability information, organized by key and value.
lcuv_empower_v5_method_processing	Contains parameter information such as the name of the parameter, the system suitability information and algorithmic information.
lcuv_empower_v5_datacubes	Provides dimensional and measure information for datacubes.
lcuv_empower_v5_datacubes_data	Provides data for the datacubes' measures and dimensions.

Columns

For more details about table columns, click here.