tribal systems update 1 tribal child support enforcement systems and the model tcses presented by:...

Tribal Systems Update 1

Tribal Child Support Enforcement Systems and the Model TCSES

Presented by:

Joe Bodmer, Senior IT SpecialistOCSE

Jackie Pische, Director, Forest County Potawatomi Tribal Child

Support

Wednesday, July 25, 2007


• In 2002, OCSE hosted four meetings of a newly formed workgroup called the “Tribal Systems Workgroup.”

• The meetings focused on issues such as:– Executive Commitment, Sovereignty, Organizational Realities,

Interfaces, Current Technology, Software Development, and Proprietary versus Open-source Software among many topics.

• This first workgroup’s charter was to educate Federal representatives who hoped for a better understanding of Tribal needs and their intersection with existing State and Federal systems.

Some History


• The workgroup did not meet in 2003.

• In 2004 the workgroup had four meetings focused on:– Project organization and executive commitment, project

management, planning, security, budgeting, project personnel needs, dealing with software development contracts, describing project tasks, schedules, and organizational structures.

• In addition, this workgroup created a set of high-level functional requirements any system would minimally need to support a Tribal CSE program. This document came to be known as the “The Essentials Document”

Some History


• The workgroup again formed in 2005. In four meetings, the workgroup created data definitions and business process workflow charts defining a Model Tribal System’s operation.

• This third workgroup also created a “Concept of Operations” for the Model System with the end result of these 2005/2006 meetings being development of a “General System Design”.

• During this time OCSE developed a “Feasibility Study” to explore the costs, benefits, and reasonableness of a Model System..

Some History


• In August 2006, continuation of the Model TCSES project was predicated on Assistant Secretary approval to proceed, which we received in November 2006.

• Three workgroup meetings will be held in 2007. Dallas in April, Denver in June, and Chicago on August 20-21. We actually demonstrated a working “Document Management Module” in Denver (a proof-of-concept exercise.) In Chicago we expect to be able to share most all of the system’s screen designs from Use Cases.

IT WORKS !

Some History


• The 2007 workgroup meetings provide a platform for grantees to comment, counsel, and provide collaboration and concurrence on the Detailed System Design documentation and work products.

• There’s a lot of “homework”.

• Throughout all Tribal Systems Workgroup meetings, decision-making is driven by consensus, with items not achieving consensus being either tabled for later discussion or dropped from consideration.

Some History


• Beginning in late 2005, OCSE began the process of writing a regulation to address the need for Tribal Child Support automation. The process was based on existing regulations, for consistency, and drew heavily on the information, consultations, and guidance gathered in the Tribal Systems Workgroups meetings held in 2002, 2004, and 2005.

• DP and DSTS have jointly developed a Tribal systems regulation that will set forth the process that Tribal IV-D grantees must adhere to if they want Federal funding to acquire automation to support their program.

The Systems Regulation


• These Tribal Systems regulations have been in the clearance process for some months now.

• The Tribal Systems Regulations have to be published in final before we can release the Model TCSES to Tribes to install and use in their programs.

• We hope, and are pushing very hard, to have a final rule issued by October 2008, if not sooner. This will enable us to stick to our Model TCSES development schedule which calls for Pilot Testing in at least one Tribal program by October 2008.



• We are analyzing, and discussing with our General Counsel, Policy Division staff, etc., various scenarios with regard to the timing of when the regulation is published.

• Though we have no answers yet, we’re looking at what impact, if any, not having the regulation published in final might have on the Model TCSES Pilot projected to start in October 2008, including what options we might have to get around this potential problem.



• With the recent release of Tribal PIQ 07-02, we’re starting to see a number of requests come in from States to make “maintenance fixes” to support Tribes using those States’ systems. Some examples include:

– OK – requested $432,212, plus some as-yet unknown costs. Not all of this is now likely approvable based on PIQ 07-02.

– WI – requesting $300,000 to make changes to support Lac Du Flambeau, Menominee and Potawatomi, and add Oneida. More information needed before a decision can be made.

– SD – requested $3,000 to support Sisseton-Wahpeton. Allowable.

– WA – Initial ended without request submission (before PIQ 07-02 was published).

States, Tribes and 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 will provide technical assistance if requested. We continue to monitor the use of intergovernmental use agreements for cost reasonableness of operational costs being charged, and for scope, type, and cost of any system modifications being requested.

States, Tribes and Systems


• What State systems expenditures associated with a Tribal IV-D program using the State’s automated system are eligible for FFP?

• May a State claim FFP for costs to modify its system to meet the needs of a Tribal IV-D program?

Tribal PIQ 07-02


• May a State and Tribal IV-D program enter into a service agreement under which the Tribal IV-D program reimburses the State for its the costs associated with the Tribe’s use of the State’s’ automated system and the Tribal IV-D program submits such costs as part of its program expenditures?

Tribal PIQ 07-02


• What costs may a start-up Tribal grantee claim in order to prepare for automation?

• What are the circumstances under which a State IV-D agency may submit arrearages owed in a Tribal IV-D case for Federal tax refund offset?

Tribal PIQ 07-02


• What are the responsibilities of States and Tribes if the above conditions are not met?

• May a State send the names of individuals that Tribal IV-D program is attempting to locate to the FPLS for locate purposes and share that information with the Tribal IV-D program?

Tribal PIQ 07-02


• This effort has been very well received by the Tribal child support grantees, many of whom have limited financial resources and very little experience in application systems development or management.

• The system has been designed, as previously discussed, in a collaborative, consultative approach using a fully consensus-driven model.

• The Model Tribal Child Support Enforcement System (Model TCSES) is totally unique amongst all Human Services systems nationwide that are in operation or being built today.

The Model TCSES


• Why is the Model TCSES totally unique amongst all Human Services systems in operation or being built today?

– Scalable up to at least a caseload of 25,000, large enough to support every Tribal agency nationwide, (not to mention Guam, the Virgin Islands, etc.,)

– The Model TCSES is being built entirely with “Open-Source” public-domain software, products, tools, and databases.

– As a result, there will be zero licensing costs to Tribes once installed and operational in their programs; extending tremendous cost savings to Tribes and the Federal government.

The Model TCSES


• Why is the Model TCSES totally unique amongst all Human Services systems in operation or being built today (Continued)?

– The Model TCSES project is delivering a complete system development environment, including all requisite development tools, database software, project management utilities, and a complete library of application code and documentation.

– The Federal OCSE is serving as the “System Developer” for the Tribes participating in the Model TCSES.

– The Federal OCSE will be providing technical support to Tribes, first in the Pilot Test in Tribal program(s), and later in support any Tribe’s installation and training for the Model TCSES.

The Model TCSES

Design Phase

J F M A M J J A S O N D J F M A M J J A S2007 2008

Code Phase

Test Phase

Development Environment

Order

User AccessSecurity

Document GenerationApplication Cache

Case Intake

Financial

LocatePaternity

EnforcementReporting

Database

Member MatchError Handling

The Model TCSES Project Status


Documentation PercentComplete

Software Requirements Specification Revisions Only

General Design Revisions Only

System Architecture 90

Designer Readiness Guide Revisions Only

Database Standards Revisions Only

Detailed Design 50

The Model TCSES Project Status


Next Model TCSES Milestones• NTCSA - Oklahoma City - July 2007

• MTCSE Design Complete - August 2007 • System Workgroup – Chicago - August 2007 • Development Contract Renewal – September 2007• System Workgroup 2008 – Location and Date TBD• MTCSE Code and Test complete - August 2008 • Pilot Test - September 2008 • MTCSE general release - January 2009 • Systems Workgroup 2009 - Location and Date TBD


• Hyatt Regency Chicago, IL• August 20-21, 2007 • Held in conjunction with the 2nd Annual

Tri-Regional (Region V, VII & VIII) Tribal and State Cooperation Workgroup Meeting, August 22nd and 23rd.

• Phone - (312) 565-1234• www.chicagoregency.hyatt.com

Next Session

What Will The System Do?

• Case Intake and Update• Case Management• Locate • Paternity and Order Establishment• Enforcement• Financial Management

– Obligation Management– Collections– Distribution– Disbursement

• Reporting

Case History and Participant Data

• Case history – a record of all actions taken on and in a case

• Linking participants to other participants and other cases – You will only enter participant data once

• Linking participants to employers – You will only enter employer data once

• Personal data – multiple addresses, multiple employers, multiple cases, multiple relationships – Everything is linked


Case History and Participant Data

• Search and match tools – participants (name, date of birth, SSN), employers, relationships – uniquely identify participants

• Provides capability to eliminate duplicate case and participant data

• Some data validation (error and edit checks)• Will support capture of all relevant personal data

on clients


Financial Data

• Calculation of current support owed based on support orders/accounts

• Record of collections• Record of disbursements • Calculation of arrears based on support

orders and collection history• Automatic billing• Check generation (if required)• Supports separation of financial duties –

caseworker/financial worker/supervisor/


Security

• Security features to prevent unauthorized access to data through the system

• User ID’s, passwords, user roles• Add, delete, authorize users• Security administered by staff that do not

have access to the system’s data – separation of duties is maintained


System Access

• Permits access over a Tribal intranet (LAN or WAN) or through the internet, if enabled

• Provides an interface with other MTCSE systems – cases can be transferred easily between Tribal systems

• Standard record layout for interfaces to State and Tribal TANF, Foster Care, other Tribal or State agencies


Document Generation

• Automatically or semi-automatically generates documents using system data

• Allows documents to be previewed before printing

• Allows document templates to be modified to produce customized documents

• All documents created on a case are stored and can be retrieved on-line (maintains confidence that the on-line document is what was sent to participant)


Document Generation

The system will generate documents for:• Motions • Petitions• Court Orders• Letters• Notices• Billing• Affidavits• Stipulations• Acknowledgments


Management and Reporting

• Timeframes and ticklers – will remind you when actions need to be taken

• Organizes work by function and worker• Management reports – worker and office

productivity• Financial reports • Federal reporting


Garbage in, Garbage out

• The system will not correct bad data.• The system is only as good as the data

entered Security Practices

• System contains features to prevent unauthorized to access to data won’t work if not used in conjunction with good physical and personnel security policies and practices


The System is not designed to perform:

• Guideline calculations (will store the results)• Federal automated interfaces (FPLS,

CSENet, QUICK, MSFIDM, etc)• State interfaces (IV-A interface, Motor

Vehicle Administration, etc.)• Internet access• Mass mailings


Hardware and Software• Personal Computers, Printers • Office Automation, Internet Access, LAN• Server and Operating System (OS)• Backup Media and Storage

Operations and Maintenance• Development Environment• Technical Services

Case Conversion• State average was approximately $40 per case

What You’ll Need


Standard System Initial Cost Item Price Quantity Total

Dell GX520 PC $1,673 5 $8,365 3.4 GHZ Pentium 4 2 GB SDRAM 19” LCD Monitor MS Office Professional Adobe Acrobat Firefox Browser $0 5 $0 Dell Power Edge 1800 Server

4GB DDR2 Memory

$5,032 1 $5,032

SUSE Enterprise Linux or Windows 2003 Server RAID 1 Controller Dual 500 GB SATA Hard Drives Uninterruptible Power Supply Internal Tape Backup 17” LCD Monitor Apache Web Server $0 1 $0 MySQL DBMS $0 1 $0 JBoss Application Server $0 1 $0 HP Laserjet 1160 $329 2 $658 SonicWALL TZ150 Firewall $273 1 $273Linksys 8 Port Ethernet Hub $51 2 $102 Total $14,430

Does not include ISP costs, case conversion, cabling, installation, training, and maintenance


Tribal System Workplace

• Logging On • http://ocse2.acf.hhs.gov/WP_TSW.nsf/

• Reviewing Topics• Responding• Posting files• Group e-mails• Tech Support

– Tom Mahony– 202-401-5565– [email protected]


Tribal System Workplace


• Workplace – Log on the workplace if you haven’t

already done so http://ocse2.acf.hhs.gov/WP_TSW.nsf/

– Check for updates and additional homework

• Homework– Complete All Assignments – More User Interface Screens Coming

Prep for Next Session


Questions and

Answers

tribal systems update 1 tribal child support enforcement systems and the model tcses presented by:...

Documents

model tribal systems

federal systems

formed workgroup

history slide

tribal cse program

model system

systems screen designs

model tcses project