XDL Schema Reference

Question 1

What data source does XDL extract from nightly?

Answer 1

The Sensus Regional Network Interface (RNI) database.

Question 2

How often is data extracted into XDL from the RNI?

Answer 2

Once per day (nightly).

Question 3

What primary benefit does XDL provide to utility BI teams?

Answer 3

Centralizes meter and device data in a query‑ready schema for custom reports without direct RNI access.

Question 4

In XDL column names, what suffix marks local‑utility timezone timestamps?

Answer 4

_local

Question 5

For timestamps without the _local suffix, which timezone is assumed?

Answer 5

UTC

Question 6

Which tables store current and historical account metadata?

Answer 6

account (current) and account_history (historical)

Question 7

Which tables capture Actions taken on devices?

Answer 7

water_actions, gas_actions, electric_actions

Question 8

Which tables hold Consumption aggregates?

Answer 8

water_consumption, gas_consumption, electric_consumption

Question 9

Which table holds Device Group metadata?

Answer 9

device_group

Question 10

Which tables store Device Register Reads?

Answer 10

water_registers, electric_registers, gas_registers

Question 11

Which tables contain Events (alarms)?

Answer 11

water_events, electric_events, gas_events

Question 12

Which tables store Interval Reads?

Answer 12

water_intervals, electric_intervals, gas_intervals

Question 13

Which tables contain Metrology Device metadata?

Answer 13

metrology_device (current) and metrology_device_history (historical)

Question 14

Which table contains Permalog Device metadata?

Answer 14

permalog_device

Question 15

Which table contains Sensor metadata?

Answer 15

sensor

Question 16

Which table records Water Permalog Reads?

Answer 16

water_permalog_read

Question 17

Which table captures Manufacturing Info?

Answer 17

manufacturing

Question 18

What’s the naming pattern for service‑specific tables?

Answer 18

They start with water_, gas_, or electric_ depending on commodity.

Question 19

Which table holds historical metrology device records?

Answer 19

metrology_device_history

Question 20

Which Account table shows the latest values?

Answer 20

account

Question 21

Which table preserves past Account records?

Answer 21

account_history

Question 22

In most tables, which field uniquely identifies a meter?

Answer 22

device_id

Question 23

Which field links to the radio/endpoint identifier?

Answer 23

radio_id

Question 24

Which account field defines the billing cycle?

Answer 24

account_billing_cycle

Question 25

Which two fields give geographic coordinates for assets?

Answer 25

latitude and longitude

Question 26

In Actions tables, which column shows when an action was issued?

Answer 26

issued_date (UTC)

Question 27

Register vs Interval: which represents cumulative meter value?

Answer 27

Register Reads (e.g., water_registers)

Question 28

Register vs Interval: which represents discrete usage slices?

Answer 28

Interval Reads (e.g., water_intervals)

Question 29

In Events tables, where is the alarm timestamp stored?

Answer 29

event_time_timestamp

Question 30

Which Consumption columns mark the period start and end?

Answer 30

start_read_time_local and end_read_time_local

Question 31

Which Metrology field stores firmware version?

Answer 31

firmware_version

Question 32

Which Metrology flag shows encryption status?

Answer 32

is_encryption_enabled

Question 33

Which Metrology column records install date?

Answer 33

install_date

Question 34

Which column can you join on to relate tables across schema?

Answer 34

device_id

Question 35

Which column stores the unit of measurement text?

Answer 35

unit_of_measurement (or unit_of_measure)

Question 36

Which Redshift type is used for semi‑structured JSON data?

Answer 36

super

Question 37

Which data type stores true/false values?

Answer 37

boolean

Question 38

Which data type is 64‑bit double‑precision float?

Answer 38

double precision

Question 39

What data type is used for calendar dates formatted YYYY‑MM‑DD?

Answer 39

date

Question 40

Which type records Unix‑epoch timestamps with date & time?

Answer 40

timestamp