Displayed Column Name | Originating Table | Column in originating table |
---|---|---|
id | cu_service_points | serv_point_id |
h_cls | supply_nodes | device_cls |
h_idx | supply_nodes | device_idx |
supply_idx | supply_nodes | h_idx |
meter_number | cu_meters | meter_no |
device_id | supply_nodes | device_id |
account_type | cu_service_points | account_type |
account_number (not null) | cu_service_locations | serv_account_number |
account_name | cu_customers | cust_name |
address_building | cu_service_locations | serv_str_struc |
block | cu_service_locations | serv_str_block |
address | cu_service_locations | serv_concat_address |
city_state | cu_service_locations | serv_city_state |
zip_code | cu_service_locations | serv_postcode_1 |
phone_area | cu_customers | cust_day_ac |
phone_number | cu_customers | cust_day_phone |
priority | cu_service_locations | serv_cumulative_priority |
a_priority | cu_service_locations | serv_a_priority |
b_priority | cu_service_locations | serv_b_priority |
c_priority | cu_service_locations | serv_c_priority |
d_priority | cu_service_locations | serv_d_priority |
e_priority | cu_service_locations | serv_e_priority |
f_priority | cu_service_locations | serv_f_priority |
g_priority | cu_service_locations | serv_g_priority |
h_priority | cu_service_locations | serv_h_priority |
i_priority | cu_service_locations | serv_i_priority |
j_priority | cu_service_locations | serv_j_priority |
k_priority | cu_service_locations | serv_k_priority |
l_priority | cu_service_locations | serv_l_priority |
m_priority | cu_service_locations | serv_m_priority |
n_priority | cu_service_locations | serv_n_priority |
o_priority | cu_service_locations | serv_o_priority |
p_priority | cu_service_locations | serv_p_priority |
q_priority | cu_service_locations | serv_q_priority |
r_priority | cu_service_locations | serv_r_priority |
s_priority | cu_service_locations | serv_s_priority |
t_priority | cu_service_locations | serv_t_priority |
u_priority | cu_service_locations | serv_u_priority |
v_priority | cu_service_locations | serv_v_priority |
w_priority | cu_service_locations | serv_w_priority |
x_priority | cu_service_locations | serv_x_priority |
y_priority | cu_service_locations | serv_y_priority |
z_priority | cu_service_locations | serv_z_priority |
life_support | cu_service_locations | serv_life_support |
avg_revenue | cu_service_locations | serv_revenue_class |
name_initials | cu_customers | cust_name_initials |
town | cu_service_locations | serv_town |
feeder_id | supply_nodes | feeder_id |
lot | cu_service_locations | serv_lot |
apt | cu_service_locations | serv_apt |
cust_id (not null) | cu_customers | cust_id |
meter_id (not null) | cu_meters | meter_id |
serv_loc_id (not null) | cu_service_locations | serv_loc_id |
amr_enabled | cu_meters | amr_enabled |
der_unit_count | cu_ders | count of records for the meter_id |
x_coord | cu_service_locations | serv_map_loc_x |
y_coord | cu_service_locations | serv_map_loc_y |
user_geographic_log | cu_service_locations | serv_user_geog_1 |
Displayed Column Name | Originating Table | Column in originating table |
supply_cls | supply_nodes | h_cls (=994) |
supply_idx | supply_nodes | h_idx |
device_id | supply_nodes | device_id |
revenue | cu_service_locations | serv_revenue_class |
customer_count | count(distinct cu_service_points) | cust_id |
critical_a | sum(cu_service_locations) | serv_a_priority |
critical_b | sum(cu_service_locations) | serv_b_priority |
critical_c | sum(cu_service_locations) | serv_c_priority |
critical_d | sum(cu_service_locations) | serv_d_priority |
critical_e | sum(cu_service_locations) | serv_e_priority |
critical_f | sum(cu_service_locations) | serv_f_priority |
critical_g | sum(cu_service_locations) | serv_g_priority |
critical_h | sum(cu_service_locations) | serv_h_priority |
critical_i | sum(cu_service_locations) | serv_i_priority |
critical_j | sum(cu_service_locations) | serv_j_priority |
critical_k | sum(cu_service_locations) | serv_k_priority |
critical_l | sum(cu_service_locations) | serv_l_priority |
critical_m | sum(cu_service_locations) | serv_m_priority |
critical_n | sum(cu_service_locations) | serv_n_priority |
critical_o | sum(cu_service_locations) | serv_o_priority |
critical_p | sum(cu_service_locations) | serv_p_priority |
critical_q | sum(cu_service_locations) | serv_q_priority |
critical_r | sum(cu_service_locations) | serv_r_priority |
critical_s | sum(cu_service_locations) | serv_s_priority |
critical_t | sum(cu_service_locations) | serv_t_priority |
critical_u | sum(cu_service_locations) | serv_u_priority |
critical_v | sum(cu_service_locations) | serv_v_priority |
critical_w | sum(cu_service_locations) | serv_w_priority |
critical_x | sum(cu_service_locations) | serv_x_priority |
critical_y | sum(cu_service_locations) | serv_y_priority |
critical_z | sum(cu_service_locations) | serv_z_priority |
critical_both | sum(cu_service_locations) | Sum of all critical customers of any types. |
x_coord | point_coordinates | x_coord |
y_coord | point_coordinates | y_coord |
ddo | Historical – likely should be removed at some point. Often set the same as customer_count to satisfy JMService. | |
zip_code | ces_customers | zip_code |
city_state | ces_customers | city_state |
user_geographic_loc | ces_customers | user_geographic_loc |