The EDAMS Commercial database forms the backbone of Commercial management where all commercial applications are based on.
Appropriate Data Model & Data Structures
EDAMS Management Systems have a dedicated data structure that has been specifically designed to address the realities facing Utilities and Municipalities. The software enforces data integrity through the nature of the relations between data elements, for example: it makes provision for both the owner and tenant of a particular property so that the owner could be held accountable should the tenant vacate the property.
Structured data capturing and data maintenance
Data capturing and/or data conversion data is captured, analysed, verified and validated in a structured and systematic manner through the respective systems in order to ensure a valid, up-to-date and reconciled database. The structured use of data validation routines and discrepancy reports, as provided by the systems, will ensure that all omissions, gaps, duplicates and erroneous data will be highlighted and rectified – whether during data capturing or subsequent data maintenance operations.
The EDAMS Management Systems utilise the Crystal Reports® for Windows by Seagate Software Inc. for the production of reports. Besides acting as a powerful standalone, report-creating application, Crystal Reports provides a report-writing module that developers can add to their applications.
A multitude of ready-made reports for users to execute are incorporated. Users can modify and customise these reports or add new ones by using Crystal Reports. The Report Engine enables printing to a printer or a Preview window. In addition, files can be exported through e-mail, directly to disk, to a Microsoft Exchange folder, to a Lotus Notes folder, or to an ODBC data source. The report can be exported in any of several word processing, spreadsheet, database file, or data exchange formats including HTML.
Intelligent Reporting: A large amount of data is stored in the EDAMS Database, which provides the platform for the EDAMS Management Systems. Directly accessing this information, if not already available in standard reports, requires a thorough knowledge of the database structure and querying language. To overcome this problem, EDAMS Technology has created a Components mechanism that provides a foundation for each of the reporting functions and pre-packages the database relationships and information in manageable objects. Components are provided in each of the functions of the Reporting module to help the user choose the desired data.
To enable further easy reporting, an Intelligent queries engine is made available. Reporting is available through Queries, in a Table format in a Thematic Map or as an Annotation in EDAMS GIS, through a Graphical Template or a Crystal Reports template.
Product Modules – main features & more information
Basic Commercial Management includes the modules listed in the table below.
|Code||Name||Brief description||Read more|
|EDAMS Billing & Customer Services Systems (B&CI)|
|EDAMS Basic Commercial Management Systems|
|B&CI-CORE||Commercial Database||EDAMS B&CI-General Pamphlet 5.0|
|B&CI-CONV||Data Conversion Utility|
|B&CI-MREP||Management Reporting||EDAMS B&CI-Management Reporting Pamphlet 5.0|
|B&CI-eCRM||Web CRM Portal||EDAMS B&CI-Portal Pamphlet 5.0|