Docstoc

Financial Data Warehouse Update

Document Sample
Financial Data Warehouse Update Powered By Docstoc
					                                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:
             • 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
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
                                      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/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
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 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
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

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:5
posted:8/17/2012
language:
pages:14