{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Attachment 12 Interface List"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Attachment 12 Interface List","index":0,"n_rows":51,"n_cols":10,"rows_kept":51,"merged":[[0,0,0,8],[1,0,1,6],[2,0,2,8],[4,1,4,6],[5,1,5,3],[6,0,6,8],[7,0,7,8],[8,1,8,8],[9,1,9,8],[10,1,10,6],[11,1,11,8],[12,0,12,8],[13,1,13,8],[14,1,14,8],[15,0,15,8],[16,0,16,8],[17,1,17,8],[18,1,18,8],[19,1,19,8],[21,1,21,8],[23,0,23,8],[24,1,24,8],[25,1,25,8],[27,0,27,8],[28,0,28,2],[28,4,28,9]]}
["City of Johnson City, TN"]
["Attachment 12 (Interface List)"]
["Column E: Available Responses"]
["Replace w/ERP","System is replaced with functionality native to the new the ERP"]
["Replace w/New TPS","System is replaced with a new Third Party System (TPS) that has been proposed as part of the new solution "]
["Keep","Keep the current system and build a permanent interface as part of the project "]
[]
["Column F: Available Responses"]
["Inbound Only","Data will be pulled from the TPS into the ERP System"]
["Outbound Only","Data will be pushed from the ERP System into the TPS "]
["Bi-Directional","Data will be pushed from the ERP System into the TPS and pulled from the TPS into the ERP System  "]
[]
["Column G: Available Responses"]
["Temporary ","Interface will be needed for limited amount of time during the project be will not be necessary after the project is completed"]
["Permanent","Interface will be needed for the life-time of the ERP System"]
[]
["Column H: Available Responses"]
["Real-Time ","Data is transferred, at a minimum, every 15mins."]
["Hourly ","Data is transferred, at a minimum, every 60mins."]
["Daily","Data is transferred, at a minimum, every 24 hours"]
["Weekly","Data is transferred, at a minimum, every 7 days"]
["Monthly","Data is transferred, at a minimum, every 30/31 days"]
[]
["Column J: Available Responses"]
["Yes"]
["No"]
[]
["NOTE:  All new Third Party Systems (TPS)  that are part of the proposal should be added to this list."]
[{"$nulls":4},"THIS SECTION IS TO BE COMPLETED BY VENDOR/PROPOSER"]
["System Name ","Description / Use Case","Data Elements","City's Plan","Vendor Recommendation  ","Direction","Temporary / Permanent ","Frequency","Comments","Included in Price? (Y/N)"]
["Meter Reading Software (Neptune MX900)","System used to capture meter reads from customer location","• Meter ID\n• Customer ID / Account\n• Meter read value\n• Date of Read","City will need interface to Neptune, but will also be purchasing additional meters in the future - City will be implmenting AMR in the future"]
["Finance System / LocalGov","Current financial system at the City","• Daily revenue amount\n• Date","City will replace LocalGov with new ERP system in the future"]
["NextGen/TT","Local Government","• General Ledger","Will replace with new ERP"]
["ImageEase / LocalGov","Finance Document Management Software","• electronic records of all documents in finance. ","Replace with new ERP or integrate with DocStar/Eclipse"]
["Eclipse/Docstar","Electronic Records Management ","See ImageEase","Perhaps Interface"]
["ERP - TBD","New financial / ERP","• Daily revenue amount\n• Date","TBD ERP system"]
["IVR","IVR","• Daily revenue amount","Vendor to suggest or propose IVR system compatible with UBS software"]
["Payment Gateway ","Receiving of customer payments","• Daily revenue amount","Vendor to suggest or propose payment gateway compatible with UBS software"]
["BIS","Online Payment Provider","• 3rd party online payment provider","Interface or replace "]
["CityView /Harris Computer","Development Services (Permitting, Planning, Building Codes, Inspections, Code Enforcement, StormWater","• Daily revenue amount","Need to interface"]
["OMS / Cartegraph ","Enterprise work order system for Public Works & Water Sewer Services","• Material, equipment, labor cost, project costs","Need to interface"]
["CrewSense","Fire department labor & accrual Tracking","• Payroll / Time Entry","Need to interface"]
["Cash register support and maintenance","Golf Masters","• Daily revenue amount","Need to interface"]
["CFA SOFTWARE","Fleet Management Software","• Invendory, Fuel & Maintenance Expenses","Need to interface"]
["ESRI ELA","Enterprise GIS System","• Property, tax, utilities, etc.","Interface"]
["MySeniorCenter","Xavus Solutions","• Daily revenue amount","Interface"]
["OMNI Court","Southern Automated Systems, Inc.","• Daily revenue amount","Interface"]
["SoftTec","Juvenile Court Software","• Daily revenue amount","Interface"]
["Vendor Registration Solution (VNS)","Vendor Registry","• Purchasing / Bids / Vendor Registration","Replace with new ERP or integrate with Vendor Registry"]
["AFComply","ACA reporting for HR [wage reporting]","• 1095 IRS requirement - employee hours","Export to excel files"]
["Social Security Office","W-2 reporting","• Annual requirement","Export to excel files"]