Use this spreadsheet to map all AquaCUE fields to corresponding fields in your Customer Information System (CIS). If a given AquaCUE 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 CIS Schema Mapping spreadsheet. Double-click the file to open it in a spreadsheet program such as Microsoft® Excel®.
NOTE: Use the file to help you create Data Exchange files for synchronizing/interfacing AquaCUE and your CIS. AquaCUE 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 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 |
