> ## Documentation Index
> Fetch the complete documentation index at: https://docs.nexalis.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Data table examples

# Table and standardization examples

This page provides examples of the actual tables and values available when querying through the **Delta Sharing API**. It complements the [Data Model](./nexalis-cloud/data/data-model) page by showing concrete outputs for raw, standardized, averaged, and high-frequency data.

***

## Table examples

The patterns below reflect real sharing behavior.

* `nexalis_<org_name>_analog_Xminavg`: standardized analog values at fixed period (e.g., 5-minute intervals), with normalization fields: `assetType`, `logicalNode`, `dataObject`, `engUnits`, `multiplier` and `adder`.
* `nexalis_<org_name>_discrete`: discrete/event-oriented signals where `value` may be numeric code, boolean, or enum-like text.

**`avg_std` row shape (analog):**

| siteName | deviceModel      | deviceID         | subDeviceID | dataPoint                                               | description         | dtConnector          | value   | assetType | logicalNode | dataObject | subDataObject | engUnits | multiplier | adder |
| -------- | ---------------- | ---------------- | ----------- | ------------------------------------------------------- | ------------------- | -------------------- | ------- | --------- | ----------- | ---------- | ------------- | -------- | ---------- | ----- |
| Site\_A  | DemoSolar\_SCADA | DemoSolar\_SCADA | 021.03.07   | `ns=2;s=[SITE_A]/PV/ARRAY_021/INV_07/MEAS_ACTIVE_POWER` | MEAS\_ACTIVE\_POWER | 2026-03-01T12:10:00Z | 12.8741 | INV       | MMXU        | TotW       |               | kW       | 1          | 0     |

**`hf_std` row shape (discrete):**

| siteName | deviceModel      | deviceID         | subDeviceID | dataPoint                                                  | description           | dtConnector          | value | assetType | logicalNode | dataObject | subDataObject |
| -------- | ---------------- | ---------------- | ----------- | ---------------------------------------------------------- | --------------------- | -------------------- | ----- | --------- | ----------- | ---------- | ------------- |
| Site\_B  | DemoWind\_SCADA  | DemoWind\_SCADA  | 044.02.03   | `ns=2;s=[SITE_B]/WTG/TURBINE_044/CTRL/ENUM_OPERATING_MODE` | ENUM\_OPERATING\_MODE | 2026-03-01T12:11:19Z | 102   | WTG       | GAPC        | OpMode     |               |
| Site\_A  | DemoSolar\_SCADA | DemoSolar\_SCADA | 021.03.07   | `ns=2;s=[SITE_A]/PV/ARRAY_021/INV_07/ALARM_CODE_4`         | ALARM\_CODE\_4        | 2026-03-01T12:11:34Z | 1     | INV       | GAPC        | AlmSt      |               |
| Site\_B  | DemoWind\_SCADA  | DemoWind\_SCADA  | 044.02.09   | `ns=2;s=[SITE_B]/WTG/TURBINE_044/YAW/AUTO_MODE`            | AUTO\_MODE            | 2026-03-01T12:12:05Z | True  | TRKMOT    | MotCALH     | AutoCtl    |               |

***

## Standardization — Ten Practical Examples

Raw tags are mapped to the **Nexalis Reference Data Model**. This adds semantic fields such as `assetType`, `logicalNode`, `dataObject`, `subDataObject`, `engUnits`, and `measurementType`.

How to read this:
`assetType` = equipment class → `logicalNode` = tag group → `dataObject` (+ optional `subDataObject`) = the specific signal → `measurementType` = Analog/Discrete → `engUnits` = engineering units.

Example:

| subDeviceID          | dataPoint (raw tag, example)     | assetType | logicalNode | dataObject  | subDataObject | engUnits | measurementType |
| -------------------- | -------------------------------- | --------- | ----------- | ----------- | ------------- | -------- | --------------- |
| INV\_8896            | …/INV\_8896/VPHSCA               | INV       | MMXU        | PPV         | phsCA         | V        | Analog          |
| INV\_11B131          | …/INV\_11B131/TOTW               | INV       | MMXU        | TotW        | –             | kW       | Analog          |
| TRK\_88103/NCU\_2/37 | …/Tracker\_Setpoint\_37/Setpoint | TRKMOT    | GAPC¹       | PosReq      | –             | °        | Analog          |
| MTR\_451             | …/MTR\_451/DmdTotWh              | Meter     | MMXU        | DmdTotWh    | –             | kWh      | Analog          |
| MS\_01               | …/MS\_01/POAInsol                | MeteoSta  | MMET        | POAInsol    | –             | W/m2     | Analog          |
| SITE/HV              | …/SITE/XCBR/HV/Pos               | SITE      | XCBR        | Pos         | HV            | –        | Discrete        |
| STR\_112/Bifacial    | …/STR\_112/Amp/Bifacial          | String    | MMDC        | Amp         | Bifacial      | A        | Analog          |
| STO\_02              | …/STO\_02/SocEffWhPct            | STO       | DSTO        | SocEffWhPct | –             | %        | Analog          |
| STO\_INV\_07         | …/STO\_INV\_07/DmdW              | STO\_INV  | MMXU        | DmdW        | –             | kW       | Analog          |
| INV\_330             | …/INV\_330/TotWRefPct            | INV       | DINV        | TotWRefPct  | –             | %        | Analog          |

What each row means (using the model descriptions):

1. **Inverter line-to-line voltage (C–A)** → `INV.MMXU.PPV.phsCA`\
   *Three Phase Measurements → Phase-to-Phase Voltage → Phase C-A*, Analog in **V**.

2. **Inverter total active power** → `INV.MMXU.TotW`\
   *Three Phase Measurements → Active Power (P)*, Analog in **kW**.

3. **Tracker setpoint position** → `TRKMOT.GAPC.PosReq`\
   *Generic automatic process control → Motor setpoint position*, Analog in **°**.

4. **Meter energy imported (from grid)** → `Meter.MMXU.DmdTotWh`\
   *Three Phase Measurements → Energy absorbed from the grid*, Analog in **kWh**.

5. **Plane-of-Array irradiance** → `MeteoSta.MMET.POAInsol`\
   *Meteorological information → Plane of Array (POA) Irradiance*, Analog in **W/m2**.

6. **HV breaker position at site** → `SITE.XCBR.Pos.HV`\
   *Switching Circuit Breaker → Position status → High Voltage*, **Discrete** (open/closed).

7. **String DC current (bifacial)** → `String.MMDC.Amp.Bifacial`\
   *DC Electrical Measurements → DC Current → Bifacial*, Analog in **A**.

8. **BESS effective state of charge (energy-based)** → `STO.DSTO.SocEffWhPct`\
   *DER storage unit → Effective State of Charge based on available energy (Wh)*, Analog in **%**.

9. **BESS inverter AC charging power** → `STO_INV.MMXU.DmdW`\
   *Three Phase Measurements → AC Charging Power*, Analog in **kW**.

10. **Inverter active-power reference (percent)** → `INV.DINV.TotWRefPct`\
    *DER Inverter Model → Active Power Reference setpoint in percentage*, Analog in **%**.