Use this spreadsheet to map all BEACON fields to corresponding fields in your billing or Customer Information System (CIS). If a given BEACON field cannot be mapped, mark it as N/A and include the reasons in this spreadsheet.
Click the link below to download and save a copy of the BEACON CIS Schema Mapping spreadsheet. Double-click the file to open it in a spreadsheet program such as Microsoft® Excel®. Alternately, you can import the file (do not double-click to open it) into an online CSV editor.
NOTE: Use the file to help you create Data Exchange files for synchronizing/interfacing BEACON and your CIS.
BEACON CIS Schema Mapping v1.3.
Last Update | What Changed | What You Need to Do |
July 26, 2016 v1.3 | Added the following fields: Account_Portal_Status, Account_Billing_Cycle, Location_Address_Line3 and Meter_Size_Unit per the BDE Specification v9.7 and v9.6.1 updates. | Use this form to match them to fields in your CIS database. |
March 24, 2016 v1.2 | Removed four fields: Service_Agreement_ID, Billing_Unit_of_Measure, Billing_Resolution and Billing_Offset per the BDE Specification v9.3 update. | Use this form to match them to fields in your CIS database. |
February 16, 2016 v1.1 | Added Person_ID and Service_Point_Timezone fields. | If your BDE files use the new fields, use this form to match them to fields in your CIS database. |
November 13, 2015 | First Post | Match Data Exchange fields to fields in your CIS database |