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|