Financial Data Warehouse Update Data Warehouse Users Group

Financial Data Warehouse Update Data Warehouse Users' Group Meeting, May 16, 2002

Changes to Data Warehouse Tables: • Acceptance Date and Fiscal Year will be added back to the DOC tables • Empty fields will be removed from DOC, LED and SUM tables • Some name fields will be removed from the SUM tables (type, category, group etc. ) Data Warehouse Users' Group Meeting, May 16, 2002

Update on Data Warehouse COBOL Reports Data Warehouse Users' Group Meeting, May 16, 2002

Changes to the following reports have been migrated to production to limit the reports to current data only: • ODW 434 R 1 - Pre-encumbrances, Encumbrances And Job Expenditures And Charges, By Job Number • ODW 438 R 1 - Detail Status Report For Annual Appropriations • ODW 438 R 2 - Detail Status Report For Biennial Appropriations • ODW 440 R 1 - Summary Status Of Annual Appropriations By Fund • ODW 440 R 2 - Summary Status Of Biennial Apprs By Fund • ODW 440 R 3 - Summary Status Of Appropriations By Fund Category • ODW 440 R 4 - Summary Status Of Biennial Approps By Fund-cat • ODW 442 R 1 - Annual Appr/budget Detail By House Bill Number • ODW 442 R 2 - Biennial Appr/budget Detail By House Bill Number Data Warehouse Users' Group Meeting, May 16, 2002

Similar changes are in the works for the following reports: • ODW 436 R 1 - Pre-Encumbrances, Expenditures by Project Number • ODW 432 R 1 - Pre-Encumbrances, and Federal Aid Expenditures and Charges by Federal Aid Number • ODW 432 R 2 - Drawdown by Federal Aid Number Data Warehouse Users' Group Meeting, May 16, 2002

Update On Data Warehouse Work Orders Data Warehouse Users' Group Meeting, May 16, 2002

Work Order 12320, Project 5/Subproject/Phase not on LED_CR table: • Assigned to DIS to add missing fields to LED_CR and LED_JV tables • Ready for implementation this weekend • Financial Data Warehouse will not be available on Saturday until approximately 10: 00 AM • LED_CR and LED_JV tables will be unavailable all weekend Data Warehouse Users' Group Meeting, May 16, 2002

Work Order 12310, Bad Checks not included on Cash Collection Report: • Removed cash Collection Report from front-end • Recommend users use the Budgetary Basis Revenue by Accounting Distribution report Data Warehouse Users' Group Meeting, May 16, 2002

Work Order 12264, Add encumbered/preencumbered options to expenditures area: • Encumbered and pre-encumbered amounts were added back to the create reports section of the expenditures frontend area Data Warehouse Users' Group Meeting, May 16, 2002

Work Orders 12243 and 12262, Problems running personal reports: • Saved personal reports on the front-end that won’t run because of punctuation in description fields will need to be deleted and recreated • Saved personal reports that would not run again after being created and saved will need to be recreated Data Warehouse Users' Group Meeting, May 16, 2002

Work Order 12203, Missing descriptions from data dictionary: • Data dictionary has been updated with missing descriptions Data Warehouse Users' Group Meeting, May 16, 2002

Work Order 12205, Problems trying to run JV detail transaction report for one month; too many records: • To improve performance of the front-end JV detail transaction report, Fund and Agency are now both required fields Data Warehouse Users' Group Meeting, May 16, 2002

Work Order 12247, Problems viewing frontend fixed asset reports: • To improve performance with viewing the report results, the subtotals were removed from some of the fixed asset front-end reports Data Warehouse Users' Group Meeting, May 16, 2002

New Data Warehouse information added to SAM II web site: • List of Indexes • Focus Join Master File Descriptions • Changes to LED_JV and LED_CR tables Data Warehouse Users' Group Meeting, May 16, 2002