1 / 14

SAMII Data Warehouse User’s Group Update July 14 th , 2004

SAMII Data Warehouse User’s Group Update July 14 th , 2004. FINANCIAL UPDATE. FA Cancel documents were incorrectly posted to REF_FHIS table as positive dollar amounts. The program was fixed and a data fix was done to post as negative amounts on the table.

clarke
Download Presentation

SAMII Data Warehouse User’s Group Update July 14 th , 2004

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. SAMII Data Warehouse User’s Group Update July 14th, 2004

  2. FINANCIAL UPDATE

  3. FA Cancel documents were incorrectly posted to REF_FHIS table as positive dollar amounts. The program was fixed and a data fix was done to post as negative amounts on the table.

  4. Sub-project description is entered in SAMII production on the SPDT table. This corresponding field is reflected in the warehouse in the REF_SUB_PROJECT table. The field name is titled GEN_REMARKS. This information has been added as a description to the data model viewer and data dictionaries.

  5. A problem was discovered with the LED_JOBS table where the decimal places did not post correctly. The program was fixed and the decimal error was corrected on the JOB_FULL_COST_AMT.

  6. Purchase orders that were rolled over from FY04 to FY05 are marked as FY05 on both the Doc_PO_HEADER and DOC_PO_LN tables.

  7. A data warehouse update is planned for August 28th. Changes will include removing the quantity field from ledger tables where it is not populated and adding the vendor address to the check table.

  8. The vendor address field will be added to the DOC_CHECK_HEADER table. This will make it much easier to see the vendor address that was in effect as of the date of the check. You will no longer have to link to the vendor table and use effective dating to get to the information.

  9. The quantity field will be removed from the ledger tables where it is not applicable. These tables are: • LED_ASSETS • LED_LIABILITIES • LED_FUND_BALANCE • LED_REVENUES • LED_PRE-ENCUMBRANCES • LED_EXPENSES • LED_ENCUMBRANCES • LED_ASSETS_OFFSETS • LED_RECEIVABLES

  10. HR UPDATE

  11. A new report has been developed to assist agencies in processing ESMT's for the $1200 pay increase for NON-TABLE driven pay employees. The MOBIUS report number is ODW860 and is in agency/org/SS# order. This report was ran on 6/24/04(after the 6/1 thru 6/15 paycycle) and ran again on 7/9/04 (after the 6/16 thru 6/30 paycycle). Remember to send a security request to Angie Neiman for anyone who needs access to this report.

  12. The Leave Sweep Projection report in MOBIUS (OHB547R1) has been modified to include leave projections. This should be used as a means of determining which employees might lose leave because they are over their maximum limits. This report will be run at the beginning of September and October.

  13. A new report has been developed to show Military Leave Usage. It is available on the Data Warehouse Web Front-end under HR/PAYROLL:Agency Detail Leave:View Reports on the Flexible reports tab.

  14. If you have any questions about this data warehouse update, please contact Jan Heckemeyer at Jan.Heckemeyer@oa.mo.gov or 526-3863.

More Related