2h Capabilities
A dynamic, "intelligent", metadata-informed framework that is fully configurable by clients without programming (Federally copyrighted). Allows for client screen report configuration, data intake forms, and automated import/export of key data sets.
Solutions implemented to 5 State agencies, 4 private corporations, and 2 universities, and 36 counties, and numerous independent provider locations.
Can be configured as an ERP system to satisfy Legislative tracking mandates
Data models for multi-tiered application architecture that reflect ever-changing business needs.
Available databases: SQL Server, PostgreSQL, MS Access, Oracle, DB2, and MySQL.
Available platforms: Windows Server, and Linux.
Built-in development module for citizen developers
Data Import/Exporting modules.
Nightly uploads and downloads of entities' data.
Output formats: PDF, CSV, and/or automated Excel templates for final reports.
Tools and Features
REPORTING
Automated Data Harvester; Data Harvester can be configured to gather data from multiple data summary reports, return the data to one Excel spreadsheet, and present it in formatted Excel tables, pivot tables, or charts - with one button push.
Export function to Excel; any report screen - or queried contents of a report - can be exported by the user directly into MS Excel via an interface. Screens can also be configured to allow the user to first, narrow down the data, and then, auto-export to a pre-formatted Excel report. MS Word is also planned as an export interface.
DATA HANDLING
Automated Data Output Module; module can export the contents of any table or report (query) to a text file format. Entire parts of the database can be re-created and linked into from offsite database or summary level reports can be utilized by more common tools like MS Office.
Automated Data Input Module; module can pull data from a text file and can determine whether to update or create a new record in a table. It also has the capacity to update only specific fields within the table depending on the content of the file.
Parallel Database Capacity: using the Data Output Module, tables can be exported to text files on an FTP server, retrieved by another process, and migrated into another database OS.
FRAMEWORK ARCHITECTURE
Screen Generator; reads DB table structure - ability to instantly render report screens or add/input screens based upon the query or table structure - dependent upon the configuration of field security, options lists, field help, and screen help.
SYSTEM MAINTENANCE
Screen Configuration Utility; an online dashboard available to Administrators allows for the configuration of a two areas: Reports or Add/Edit screens.
Fields can be hidden and enabled/disabled.
Lookup lists can be attached to specific fields.
Help text with HTML capacity can be inserted adjacent to the field. Summary help as well as section separators can be inserted into the layout.
Aliases can be given to tables or reports
Encryption can be invoked for specific tables or reports
Automated Excel reports can be mapped to specific data summary reports