2H Systems focuses on the development of web-based applications within the 2H Systems Framework. The 2H Systems Framework is one that supports use, business content management, and developer tool construction – all within a web environment. The architecture accommodates multiple entities, divisions and units. Look, feel, and available tools vary to both the entity and user based upon authorities. The system is created to enable management of behavior and content by power users or system administrators. The framework is fully scalable and obtains operating parameters primarily from meta-data housed within the core data structure. Due to the nature of the technology used, the system is fault-tolerant both in hardware and in accessibility, and utilizes a thin client (a web browser). The system is accessible from anywhere in the world - which allows for maintenance and use from anywhere within the world. Accessibility to other ADO/ODBC compliant data sources is also possible. Tools can point to other systems on different platforms. Due to audit features, exterior systems listed as available tools can determine whether a user has logged in to the architecture and pass that login through to its own system. It is seamless to the user.
Within the base architecture, the following web tools and functions exist:
REPORTING
Online Ad-hoc Query and Reporting; ability to build ad hoc queries with Excel-like filters or using a SQL language generator. Ad hoc queries can be saved to the user's profile for later reference.
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.
Online Document Manager System - encrypts/decrypts with each request; allows specific user groups to access static documents
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.
Load Manager; system allows tools to point to other servers for better load management. Will preserve session state and authorizations as the transfer seamlessly occurs.
Multiple Agency Use; system allows for multiple agencies to use the same architecture with different database - or the same - while displaying their unique colors, logos, and tools. Data can be shared if needed or can be completely unique to the agency.
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
Securities and Authorities Management; module allows Administrators to manage the dispersal of individual tools to a single user, a single tool to a user group, the level of authorization a user has, and activation/deactivations. User levels are View Only, End User, Power User, Super User, Administrator.
System Parameters Management; this module allows the management of system parameters, tool creation, and group organization. Examples might be configuring the color of the application, changing the content of the help manuals, configuring the default record return on a summary screen, or creating a new tool to point to an internal web site or application.
Content Management and File Uploading Utility; graphics, site content, and document dispersal are handled by an internal file uploading tool. The tool, when dispersed to power users, limits access to files outside of their group designation.
Data Audits; system constantly tracks the following items for each data transaction: Last Edit, Last Modified By, Create Date/Time, Edit Date/Time, Entered By, Section, County, Entity.
Employee Profile Manager; End Users can modify only his/her own profile, Power Users modify anyone in their section, Super Users - anyone in their county, and Administrators, anyone in their agency.
EXISTING APPLICATIONS
Contacts Manager; quick telephone style lookup of active users in system with telephone numbers and clickable email links.
Random Moments Time Study System; system categorizes time spent on a specific day into agency-designated categories. Currently in use by the Medicaid Program (R1)
Training Tracker; system tracks the receipt of training by staff. Section supervisors can add to the available training topics for their staff. Agency Administrators can deploy global training topics with requirements. Currently in use by the Healthy Start Program (R2).
New Baby Intake System; Healthy Start new baby and family profiling system. Allows for the reassignment of cases to other sections/counties. Currently in use by the Healthy Start Program (R2).
Juvenile Intake and Assessment System; tracks change over time of risks where participants are assessed to be at risk. End result displays Excel graphs and filters that address average reduction of risks in specific risk domains, specific population risk areas for age, demographics, and response. Currently in use by the Juvenile Crime Prevention Division (R2)
Comprehensive Plan Manager; Agency-specific community and county commission planning tool. Identifies issues, gaps, and barriers. Targets specific groups of recipients with anticipated results. Currently in use by the Commission on Children and Families (R2)
Statewide Financial Management and Reporting System; allocates state funding streams to Oregon counties. Monitors allocation of dollars to specific programs carrying out the resolution of the issues identified in the Comprehensive Plans System. Measures results of programs and maps successes and losses to targeted population groups. Currently in use by the Commission on Children and Families (R2).
Relief Nurseries Case Management System; state-wide intake tracking system for at-risk families and monitors visits, schedules, and issues. Currently in use (R1).
Court Appointed Special Advocate (CASA) Management System; manages the oversight and aid to children who have been removed from their parents. Identifies relationships and schedules, manages cases, court interaction, and volunteers. Currently in use (R1).
Measure 37: system developed to track Measure 37 Oregon land claims. Required parallel database capacity (R1, R2).
Measure 49 Claim Management System; system tracks past Measure 37 claims and current Measure 49 claims, tracks handling of claims by both management and staff. Requires integrated dual agency use by Department of Justice and the Department of Lands Conservation and Development (R1, R2).
Family Building Blocks Data Migration Tool: a custom-built system that takes data from a legacy, flat-file data model and converts it into the relational database structure of the State of Oregon's Relief Nursery System. Currently in use by Family Building Blocks of Marion County (R1).
Clothes Circuit Report Tool: custom-built system using Excel Visual Basic for Applications, SQL, SQL Server, PostgreSQL, ASP and ASP.net to extract data generated from a Point of Sales software and generate automated Excel reports on movement of stock, brand performance, and profit margins. Currently in use.
