EDIFICE Frequently Used Tables and Linking

Here is a list of the most commonly used EDIFICE tables.  You may find this list helpful for third-party reporting purposes.  In addition, below you will find information that pertains to linking (or joining) tables to retrieve the desired information for third-party reporting purposes.

 

Commonly Used EDIFICE Tables

EDIFICE Table

    

Location Files

location_billing

    

location_connection

    

location_master

    

location_service

    

st_index

    

Customer Files

cust_usr_definable

    

custlien

    

customer_financial

    

customer_master

    

customer_service

    

Connection Files

meter_master

    

meter_reading

    

meter_user

    

Linking (Joining) EDIFICE Tables

There are times that you will need to link information from one table to create the common threads needed to retrieve the information you want.  Below are some examples of commonly used table links.

Note:  For more information, please contact NDS Support.

Linking Location Billing file to the Location Master file

To link the Location Billing File to the Location Master File, you will need to incorporate a third file to create the common threads needed to link  the information.

Linking the Customer Mailing Address to the Service Location Information:

Tip:  This will provide a report for owners.  If billing for tenants, you can create another report using the Tenant_ID instead of the Owner_ID.

Linking the Meter Information to the Customer Mailing Information