1 / 14

Financial Data Warehouse Update

Financial Data Warehouse Update. 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.).

burke
Download Presentation

Financial Data Warehouse Update

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. FinancialData Warehouse Update Data Warehouse Users' Group Meeting, May 16, 2002

  2. 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

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

  4. Changes to the following reports have been migrated to production to limit the reports to current data only: • ODW434R1 - Pre-encumbrances, Encumbrances And Job Expenditures And Charges, By Job Number • ODW438R1 - Detail Status Report For Annual Appropriations • ODW438R2 - Detail Status Report For Biennial Appropriations • ODW440R1 - Summary Status Of Annual Appropriations By Fund • ODW440R2 - Summary Status Of Biennial Apprs By Fund • ODW440R3 - Summary Status Of Appropriations By Fund Category • ODW440R4 - Summary Status Of Biennial Approps By Fund-cat • ODW442R1 - Annual Appr/budget Detail By House Bill Number • ODW442R2 - Biennial Appr/budget Detail By House Bill Number Data Warehouse Users' Group Meeting, May 16, 2002

  5. Similar changes are in the works for the following reports: • ODW436R1 - Pre-Encumbrances, Encumbrances, Expenditures by Project Number • ODW432R1 - Pre-Encumbrances, Encumbrances, and Federal Aid Expenditures and Charges by Federal Aid Number • ODW432R2 - Drawdown by Federal Aid Number Data Warehouse Users' Group Meeting, May 16, 2002

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

  7. 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

  8. 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

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

  10. 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

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

  12. 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

  13. Work Order 12247, Problems viewing front-end 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

  14. 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

More Related