Laserfiche WebLink
From the common complaint database, we should be able to generate various reports. <br />For example, the Clerk's office can generate a report for the Council that includes only <br />those contacts that came in threugh a Council member. Another report can show the <br />complaints per department, or all the complaints of a particular category. <br /> <br />Database fla,qs <br />For each contact logged into the common database there should be a number of fields <br />from which queries can be built, including: <br /> <br /> · The relevant Department or division <br /> · Geographic location, if any, of the subject matter <br /> · The name and address of the person making the complaint (how do we deal with <br /> requests for anonymity?) <br /> · Relevant neighborhood association (based on the address of the citizen) <br /> · To whom the complaint was referred (the department and/or staff) <br /> · Category of complaint (from list above) <br /> · Type of service requested, if the contact was a ser,,,'i~:e request <br /> · History of complaint - was there an eariiar contact ~: ' the same issue? Has the <br /> citizen already gone to the appropriate department-level, and didn't get <br /> satisfaction? <br /> · Mechanism by which the complaint was made (letter, email, walk-in, phone call) <br /> and whether it came via a member of Council <br /> <br /> <br />