# Presentation: 281710

## Tribal Systems Update

**A Status of Tribal Automation Today**
**An Update on the Model Tribal System****Development Project**
***And A Sneak Peek At The ******Model Tribal System (MTS)***

**Joseph Bodmer, PMP**
*Senior IT Specialist and Project Director, MTS Project*

## Tribal Automation And Systems 

**Current Tribal Program Regulations**
- Relevant Systems Citation is 45 CFR 309.145(h)(1-5)
- Limit Federal Funding For Automation In Tribal IV-D Programs To The Following:
- Operating and maintenance costs for existing Tribal Child Support systems
- Operating costs/chargebacks to use another State or Tribal Child Support system under intergovernmental agreement
- Costs for planning phase (identify, evaluate and select) activities to acquire new Child Support system
- Acquisition and maintenance costs of office automation
- Other costs deemed appropriate by the Secretary

- National Council of Child Support Directors Annual Conference, Ashville, North Carolina,  May 2008

## Tribal Systems Policy (PIQT)

**Last Year’s Release Of Tribal PIQ 07-02, Started A Number Of Requests From States To Make “Maintenance Fixes” To Support Tribes Using Their State Systems.  Some Examples Include:**** **
- OK – originally requested $432,212.  Request was pulled.  No word on a resubmission at this time.
- WI – requested $210,851 to make changes to support Lac Du Flambeau, Menominee and Potawatomi, and add Oneida.  This was approved.
- SD – requested $3,000 to support Sisseton-Wahpeton.  This was approved.
- WA – Initial inquiries ended without request submission.

- National Council of Child Support Directors Annual Conference, Ashville, North Carolina,  May 2008

## Tribal And State Systems

**OCSE Publicly Has No Position On Whether A Tribe Should Or Should Not Seek To Use A State’s CSE System.  **
- OCSE Considers This An Internal Tribal Determination To Be Made In Consultation And Collaboration With Their State Partners.
**DSTS Continues To Monitor The Use Of Intergovernmental Agreements.**
- Cost Reasonableness Of Operational Costs Being Charged
- For Scope, Type, And Cost Of Any System Modifications Being Requested.

- National Council of Child Support Directors Annual Conference, Ashville, North Carolina,  May 2008

## Tribal Systems Regulations

**45 CFR Part 310 Regulations In Clearance **
- A Notice Of Proposed Rulemaking (NPRM) Is Expected To Finally Be Published In The Federal Register Within The Next 30 Days
- 60 Days For Comment Period
- 4 Tribal Consultations Scheduled In June And July
- North Carolina June 11th and Washington June 27th
- Oklahoma July 8th and Wisconsin July 9th
- High Profile Regulation – Fast Tracked
- Publication Of The Final Rule Required Before Pilot Test In A Tribal Program Can Begin

- National Council of Child Support Directors Annual Conference, Ashville, North Carolina,  May 2008

## A Brief History

**Where We’ve Been**
- Process Began In 2002 After Release Of Tribal Program Regulations:  45 CFR 309.
- First Of Four Workgroups Organized In 2002
- Workgroup identified organizational, operational, technical, financial, regulatory, and legal landscapes we were dealing with in Indian Country.
- That 1st Workgroup’s Charter:  ***Teach the Feds.***

- National Council of Child Support Directors Annual Conference, Ashville, North Carolina,  May 2008

## A Brief History

**Where We’ve Been**
- The “***Tribal Systems Workgroup***” Reconvened In 2004 And Continued Documenting Tribal IV-D Program Operations.
- Workgroup Developed Two Key Documents:
***Concept Of Operations***
***Tribal Systems Guide - Essential Requirements***** **

- National Council of Child Support Directors Annual Conference, Ashville, North Carolina,  May 2008

## A Brief History

**Where We’ve Been**
- In 2005, The ***Tribal Systems Workgroup*** Began JAD Sessions To Develop Business Process Workflows (Flow Diagrams), And A Comprehensive Data Element Dictionary.
- All Workgroup Products Required Complete (Meaning 100%) Consensus Of All Members.
- 2005’s Major Product Release Was:
***General System Design Document (GSD)***

- National Council of Child Support Directors Annual Conference, Ashville, North Carolina,  May 2008

## A Brief History

**Where We’ve Been**
- In Late 2006, The Commissioner Approved Staff To Explore The Feasibility Of Building The Tribal Systems Workgroup’s Solution Design For A System.
- OCSE Then Developed A Feasibility Study Including A Market Survey And A Cost-Benefit Analysis.
- In November 2007, The Commissioner Received The Concurrence Of The Assistant Secretary, ACF, To Build The ***Model Tribal System.***

- National Council of Child Support Directors Annual Conference, Ashville, North Carolina,  May 2008

## MTS Project Status

**Where We Are Today**
- Development Began Immediately With Contract Staff Resources From ***BAE IT Systems***, And ***SYSRAD***.
- Current Development Team Composition
- Project Director, Two Project Managers/Architects.
- 4 FTE Highly Skilled Architects/Senior Programmers.
- 6 PTE Skilled Programmer-Analysts.
- 4 PTE Quality Assurance/Testers and a Technical Writer
- 1 PTE Database Administrator.

- National Council of Child Support Directors Annual Conference, Ashville, North Carolina,  May 2008

## MTS Project Status

**Where We Are Today**
- Current System Design Status
- Concept of Operations completed.
- System Requirements Specification (SRS) completed.
- General System Design (GSD) and Detailed System Design (DSD) completed.  Updates only.
- Database built, and Data Dictionary validated.  Updates only.
- All Use Cases completed.  Adding new ones as needed.
- All Integrated Development Environment (IDE) and Server Architecture operational components validated.

- National Council of Child Support Directors Annual Conference, Ashville, North Carolina,  May 2008

## MTS Project Status

**Where We Are Today**
- Current System Development Status
- Print Management – design complete, building data access.
- Application Security – validating solution and completing application integration.
- All screens and many of the screen components, validators, and behaviors are built – an object-oriented, reusable design.  We are continuously “*refactoring*” all components.
- Backup and Recovery – installed a new server for failover support for development environment.  Eliminated a risk.

- National Council of Child Support Directors Annual Conference, Ashville, North Carolina,  May 2008

## MTS Project Status

**Where We Are Today**
- Current System Development Status
- Code Development ongoing
- Data Formatters, Validators (simple and full field, panel integration and execution), Exception Processing, and Common Values are built.  Refactoring as needed.
- Calendaring, Document Management, Third Party (search and CRUD data access) functions are built.
- Application Setup and Configuration in coding.
- Data Access (Flex 3) for Case Intake and Case Management, Worker Assignment, Office Management, Worklist (Tickler) Management, and Income and Asset functions in coding.

- National Council of Child Support Directors Annual Conference, Ashville, North Carolina,  May 2008

## MTS Project Schedule

**Where We Are Today**
- Current System Development Schedule
- We Have, So Far, Recouped 1 Month Of Schedule Lost To Late Start (December 1, 2007) Of Development Phase
- Target Code Development Completion Is September 2008
- User Acceptance Testing Begins July 2008 (Iterative)
- Pilot Test Proposed Start Is October 15, 2008
- Pilot Start Date Is Dependent On Publication of Final Rule on Tribal Systems at 45 CFR 310.
- General Availability and National Roll-Out to Tribes is scheduled for January 2009 if Pilot is completed by then

- National Council of Child Support Directors Annual Conference, Ashville, North Carolina,  May 2008

## MTS Project Status

**Where We Are Today**
- Dear Colleague Letter (DCL) To Go To Tribal IV-D Program Directors In the Coming Month, After Publication of NPRM On Tribal Systems, Seeking Volunteer Tribal IV-D Program(s) To Be Pilot Site
- Pilot Expected To Last 2-3 Months
- Includes Training Of Program Staff On System Use, Security, Configuration and Setup, and Management
- Training Of Technical Staff On System Operations, Maintenance, And Procuring Software Development Support (Sample RFP’s, ITB’s, Technical SOW’s, etc.)

- National Council of Child Support Directors Annual Conference, Ashville, North Carolina,  May 2008

## MTS On The Leading Edge

**Some Unique Design Aspects of MTS**
- Design Is Built For Transaction Speed And Application Performance By Loading Most User Interface (Presentation Layer) Components And Objects Into Dynamic (RAM) Memory At Login-in, And Using *Prefetch* And *Caching* Of All Case Data Into RAM.
- Development Server’s Baseline Configuration, Allowing For Virtual Workstations, Completed.  Allows Remote (Off-site) Development, Testing, And Debug By MTS Project Team.
- Automated Testing – Built Code Is Tested Nightly In Automated Build Runs, With Error Reporting Output To Developers.  Two Levels Of Automated Testing – An Hourly Compile Test, And A Nightly Deploy Test With Scripted Error Testing.

- National Council of Child Support Directors Annual Conference, Ashville, North Carolina,  May 2008

## MTS On The Leading Edge

**What’s So Unique About This “Model” System?**
- The MTS Is A Complete Out-Of-The-Box Child Support System Solution For Tribal IV-D Programs.
- Designed With The 80/20 Rule In Mind, It Will Serve Better Than 80 Percent Of Tribes Immediately Without Any Redesign Or Enhancement.
- Specifications Include:
- Scalability to 25,000 cases with no performance degradation.
- Support for up to 100 concurrent users with no performance hit.
- Zero license fee costs for both the operational environment (operating system, utilities, and database) or for the development environment (Eclipse, Flex, Hibernate, etc.)  The system is built with Community-based, Open-Source software.
- Training materials come with the delivered solution (January 2009.)

- National Council of Child Support Directors Annual Conference, Ashville, North Carolina,  May 2008

## MTS On The Leading Edge

**Nothing Like It in Any State’s System**
- A Unique Configuration and System Administration Module Provides Extensive Up-Front Customization To Tribal Programs:
- Requires no special training, highly intuitive, wizard-based module.
- Just answer questions or enter data for a customized look and feel:
- by checking boxes,
- making *yes* or *no* selections (example: auto-generate Form X, Y or Z),
- entering timeframes (in numbers of days, for ticklers, etc.),
- uploading the Tribe’s logo (a .JPG or .GIF picture file),
- entering staff names and assigning them roles (for security, workload assignment and workflow), and,
- entering other Tribe-specific information: Tribal Program name, address, phone numbers, Court name and address, Judges names, things like that.

- National Council of Child Support Directors Annual Conference, Ashville, North Carolina,  May 2008

## MTS On The Leading Edge

**Nothing Like It in Any State’s System**
- The Unique Configuration and System Administration Module Also Includes Extensive Document Management Capabilities:
- A Capable Word Processor Is Built-In.
- Allowing Tribes to create and edit forms right in the Configuration Module and those new documents are then immediately available to the system and users.
- Allows User assignment and selection of printers.
- The system already comes with over 125 generic template forms, notices, documents, and reports – all designed by Tribes, for Tribes – from the Tribal Systems Workgroup.
- Documents can contain graphics, different fonts, and automated, intelligent data merge – all built with the word processor.
- Or import your own templates and work on them in the MTS.

- National Council of Child Support Directors Annual Conference, Ashville, North Carolina,  May 2008

## MTS Architecture

- National Council of Child Support Directors Annual Conference, Ashville, North Carolina,  May 2008

## MTS Solution Architecture

- National Council of Child Support Directors Annual Conference, Ashville, North Carolina,  May 2008

## MTS Has Role-Based Security

****** ** **Role-based Access Control:**
- MTS screens are rendered with different icons/links and behaviors based on the role of the user logged in.
- For instance an “*Approve Transaction*” icon/link will not be available or even appear on screen to any other role but Financial Supervisor.
- Similarly security maintenance is not available to or accessible by any other role but the Security Administrator.

******  ****Rule Checkers:**
- In addition to role-based security access, various operations in MTCSE are restricted by state-based business rules.
- For instance a Case Worker may be able to view another user’s case but may not transfer or close that case.

- National Council of Child Support Directors Annual Conference, Ashville, North Carolina,  May 2008

## MTS Has Role-Based Security

| Actors | Task-Level Goal |
| --- | --- |
| Case Worker | Read/Write In Case Management, Locate, Paternity, Orders, Enforcement, 
Reports, Interfaces.  Read-Only Financial Management.  |
| Supervisor | Read/Write In Case Management, Locate, Paternity, Orders, Enforcement,
Reports, Interfaces, Supervisor Controls.  Read-Only In Financial Management. |
| System
Administrator | Read/Write In Application Administration.  No Security Administration Access.
No Other Application Access.  No Master File Access. |
| Security 
Administrator | Read/Write In Security Administration.  No System Operation or Administration
Access.  No Other Application Access.  No Master File Access. |
| Financial 
Worker | Read-Only For Case Management, Locate, Paternity, Orders, Enforcement, 
Read/Write for Financial Management, Reports, Interfaces. |
| Financial
Supervisor | Read-Only For Case Management, Locate, Paternity, Orders, Enforcement. 
Read/Write for Financial Management, Reports, Interfaces, Supervisor Controls. |
| Super-User | Read/Write In Case Management, Locate, Paternity, Orders, Enforcement, 
Reports, Interfaces, Supervisor Controls.  Read-Only For Financial Management.  |

- National Council of Child Support Directors Annual Conference, Ashville, North Carolina,  May 2008

## MTS Development Environment

| Integrated Development Environment (IDE) | Eclipse WTP 1.5.2 |
| --- | --- |
| Universal Markup Language (UML) | Visio 2003 |
| J2SE, J2EE | Java 2 Standard & Enterprise |
| Configuration & Content Management | Alfresco 2.2 |
| Web Services | Axis v2 by Apache |
| Build/Compile | Apache ANT 1.5.1 |
| Continuous Integration Builder | Continuum and Maven  |
| Unit Testing | Apache JUnit v4 |
| Version Control | Subversion 1.3 by Tigris |
| Federal Accessibility Validation (§508) | WEBXACT 1.0 by Watchfire |
| User Interface | Flex3 by Adobe |
| Business Process Modeling (workflow) | jBPM 3.2 by JBoss |
| Database | MySQL 5.1 |

- National Council of Child Support Directors Annual Conference, Ashville, North Carolina,  May 2008

## MTS Runtime Environment

| Application Server | JBoss Application Server 4.2 |
| --- | --- |
| Database | MySQL 5.1 |
| OR (Object Relational) Mapping | Hibernate 3.1 |
| Registry | ebXML 2.0 |
| HTTPServer | Apache HttpServer |
| Reporting | SourceForge’s JasperReports 1.2.2 |
| Logging | Apache Commons Logging 1.2 |
| Operating System (Server-side) | MS Windows Server 2003 
Red Hat Enterprise Linux 5
Novell SUSE Linux Enterprise 10 |
| Operating System (Desktop) | MS Windows 2000, XP, 
Linux (MTS is version agnostic) |

- National Council of Child Support Directors Annual Conference, Ashville, North Carolina,  May 2008

## The Model Tribal SystemA Sneak Peek

**The Model Tribal System****A Sneak Peek**

- National Council of Child Support Directors Annual Conference, Ashville, North Carolina,  May 2008

## Standard Screen Components

- Functional Panel

**Standard Screen Components**

- National Council of Child Support Directors Annual Conference, Ashville, North Carolina,  May 2008

## Standard Screen Layout

**Standard Screen Layout**

- National Council of Child Support Directors Annual Conference, Ashville, North Carolina,  May 2008

## Tribal Systems UpdateQuestions?

**Tribal Systems Update****Questions?**

**Joseph Bodmer, PMP**
*Senior IT Specialist and Project Director, MTS Project*

- National Council of Child Support Directors Annual Conference, Ashville, North Carolina,  May 2008