Advanced Topics: Waters Empower Table Structure and Relationships

Understanding the structure of the IDS Entity Relationship diagrams can help you determine what data to query and how to structure your SQL queries. This topic addresses the Waters Empower Table structure.

Entity Relationship Diagram

The Empower entity relationship diagram is shown below.

Tables

The following provides a description of the Water Empower tables.

For more detailed information, you can search the table and view the table definition.

Table NameDescription
lcuv_empower_v5_injectionThis is the root table, which provides basic information about each injection including the assigned name, and a description of the injection as well as the dimension, measure, and project names.
lcuv_empower_v5_injection_custom_fieldsProvides 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_columnsProvides 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 the project name.
lcuv_empower_v5_resultsContains information on ID, time, set information, and sample information (e.g. name, weight value and unit, sample type, dilution and more.
lcuv_empower_v5_results_peaksContains 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 as well as code, retention time and start time values, and more.
lcuv_empower_v5_results_peaks_custom_fieldsProvides information about result peak values, organized by key and value.
lcuv_empower_v5_results_custom_fieldsProvides information about result organized by key and value.
lcuv_empower_v5_results_sign_offsProvides information on who completed the signoff, the level, date, method information, reason, type, project, and result ID information.
lcuv_empower_v5_method_instrument_setupsProvides 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_fieldsProvides 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_processingContains parameter information such as the name of the parameter, the system suitability information and algorithmic information.
lcuv_empower_v5_datacubesProvides dimensional and measure information for datacubes.
lcuv_empower_v5_datacubes_dataProvides data for the datacube's measures and dimensions.

Columns

If you need to find more specific information on table columns, see this topic.


Did this page help you?