- Report failures and timing issues will continue to result in lost data.

- Larger jurisdictions will never be able to run reports in a timely manner due to the

impacts to the system for all other users.

- Crucial accounting information and reporting will remain unavailable.

- Calculated estimates will continue to be used for financial reporting even where

Generally Accepted Accounting Standards require actual, auditable figures.

- The problem of irretrievable financial records will continue to grow.

- Cases will continue to become "out of balance", rendering financial history

irretrievable.

This request was endorsed by AOC at the direction of Jeff Hall and Vonnie Diseth.

     The purpose of this request is to move accounting data from the Judicial Information System (JIS) into the EDW.  In addition, the request seeks the creation of several reports to meet the needs of both Superior Courts and Courts of Limited Jurisdiction (CLJ).

     This request will provide the courts better tracking of accounting information, enhanced budget and revenue forecasting, and better audit and operational reports.  This request will also enhance the ability of the courts to answer inquiries from other agencies regarding accounting matters.  This enhancement will also eliminate the current timing restraints on certain reports from Judicial Accounting Subsystem (JASS).

     The solution that Administrative Office of the Courts (AOC) proposes will provide the courts with better tracking of accounting information, enhanced budget and revenue forecasting, and better audit and operational reports.  The solution shall provide accounting data in the data warehouse and create canned reports to provide the reporting capabilities specified in this request. 

     The accounting data in the data warehouse would be refreshed at regular intervals, which would be defined during the course of implementing the project. Requirements for the reports would be developed in close collaboration with court staff to ensure that the outcome meets the business needs of the courts.

     This project carries several risks that could impact the successful completion of the project.  The risks include:  a lack of accounting expertise among the AOC technical staff, the potential necessity of upgrading the infrastructure to accommodate the solution, and potential resource conflicts with other projects.

DMSC has narrowed the parameters of this request and returned it to AOC for re-analysis.

The purpose of this request is to move accounting data from the Judicial Information System (JIS) into the EDW.  In addition, the request seeks the creation of several reports to meet the needs of both Superior Courts and Courts of Limited Jurisdiction (CLJ).

This request will provide the courts better tracking of accounting information, enhanced budget and revenue forecasting, and better audit and operational reports.  This request will also enhance the ability of the courts to answer inquiries from other agencies regarding accounting matters.  This enhancement will also eliminate the current timing restraints on certain reports from Judicial Accounting Subsystem (JASS).

The solution the Administrative Office of the Courts (AOC) proposes will provide the courts with better tracking of accounting information, enhanced budget and revenue forecasting, and better audit and operational reports.  The solution shall provide accounting data in the data warehouse and create canned reports to provide the reporting capabilities specified in this request.  The accounting data in the data warehouse would be refreshed at regular intervals, which would be defined during the course of implementing the project. Requirements for the reports would be developed in close collaboration with court staff to ensure that the outcome meets the business needs of the courts.

Accounting information available at person and/or case level detail was identified as the highest priority area by an accounting work group comprised of both superior court and courts of limited jurisdiction accounting personnel.

Additionally, it was determined that making the reports available, without ad hoc capabilities, would be acceptable for the initial accounting implementation.  See attached analysis document for a list of the identified reports.

This request was authorized by the JISC on Feb 18, 2011.

Project is scheduled for Aug 1, 2011 - Aug 1, 2013.

This project has been re-scheduled for Aug 15, 2011 - Aug 1, 2013.

This project has been re-scheduled for Aug 1, 2011 - Aug 1, 2013. 

Work began on this project on Aug 1, 2011.

ITG Request 009 – Add Accounting Data to the Data Warehouse has completed its first implementation.  This request sought to add accounting data to the data warehouse and create 14 pre-defined reports in BOXI.  This first release included the following reports:

1.    Cases with AR Paid-in-Full Report (Courts of Limited Jurisdiction)

2.    Cases with AR Paid-in-Full Report (Superior Courts)

3.    Obligor Detail

4.    Obligation Detail

     These reports are fully operational and available for use at this time.  More information is available at EDW Release Notes for December 20, 2011.

     This ITG Request is the Multi Court Level CLUG’s #1 priority and is the JISC’s #4 overall project priority.  The next implementation of accounting reports for this project is scheduled for March of 2012.

The second increment was released on Feb 21, 2012.  The new report available is for CLJs.  The next increment is due to be released on April 17, 2012.

Description of new report:

The Cases with Disposed Charge in "Potential" Status (CLJ) report lists cases that have fines or condition-related costs listed on the Plea/Sentence (PLS) screen, but have ARs that have not been billed, or are still in a "Potential" status when the Create A/R (CAR) screen is viewed.  The Cases with Disposed Charges in "Potential" Status (CLJ) report is available in the Accounting folder in BOXI.

I am pleased to inform you that the third increment of ITG Request 009 – Accounting Data in the Data Warehouse was released on Apr 17, 2012.  This release provides Superior Courts and Courts of Limited Jurisdiction with new reports called AR Detail Report(CLJ) and AR Detail Report(SC).  This is the third increment that has been delivered on schedule. 

Description of new reports:

“AR Detail Report” is used to show summary and detail information for all open accounts receivable for the court, including joint and several billed ARs for superior courts. Open billed ARs include cases where the case obligations have not been paid in full. There are two versions of this report listed in the Accounting Folder. One is designated for Superior Courts and the other for Courts of Limited Jurisdiction.  The two reports display different, court level specific, information.

The full release not is available at:  EDW Release Notes for April 17, 2012

The fourth increment of this request was released on June 19, 2012.  This increment contains the following new reports and updates:

1.	New Report:
	1.1	“AR Summary Report” is used to show summary information for all open accounts receivable for the court. The AR (Accounts Receivable) Summary Report is used by both jurisdictions.
		The report is displayed with two tabs: AR Summary by AR Type on tab 1 and AR Summary by Case Type on tab 2.
		The AR Summary by AR Type tab contains Case Type Code, AR Type, Total Ordered Amount, Paid Amount, Total Adjustment Amount, Total Due Amount, and Total ARs with a Grand Total at the end of the report.
		The AR Summary by Case Type tab contains Case Type Code, AR Type, Total Ordered Amount, Paid Amount, Total Adjustment Amount, Total Due Amount, and Total ARs with a Total at the end of each case type and a Grand Total at the end of the report.
		The AR Type will link to the appropriate report for either AR Type or RCW.
	1.2	“AR Type Detail” is a standalone report and a drill report that will run when you click on the hyperlink of an AR Type Code in an accounting report. This report provides the list of cases and monetary amounts associated with the AR Type Code.
		The Case Number is a hyperlink to the previously released “Obligation Detail” report. The Obligor is a hyperlink to the previously released “Obligor Detail” report.
		This drill report is used by both court levels.
	1.3	“RCW Detail” is a standalone report and a drill report that will run when you click on the hyperlink of the RCW that was used to create the AR. This report provides the list of cases associated with an AR that is based on the RCW.
		The Case Number is a hyperlink to the previously released “Obligation Detail” report. The Obligor is a hyperlink to the previously released “Obligor Detail” report.
		This drill report will only be used by the courts of limited jurisdiction.
2.	Report Update:
	2.1	“Cases with ARs Paid-in-Full (CLJ)” report was changed to include columns for the Warrant and FTA Flags.
	2.2	“Obligation Detail” report was changed to include obligations that were added based on RCW.