Page Comparison

DWH Team Status Report for 12/17/2012

DWH KFS Decision Support JIRA Tasks

1. Prior Two Week Activity

   1. Kuali Financial System
      
      1. Complete - Finalization and Review of GL, COA, and CAM models
      2. Complete - Data Model delivered by consultant for PURAP - currently being reviewed
      3. Complete - Org Structure Assignment. Determine reprots to for eliminated orgs approx 400
      4. Complete - Write ETL Staging jobs for PUR_* tables
      5. Complete - Write ETL scripts for staging AR, AP, KREW tables
      6. Complete - Develop Talend job to load Document Details dimension
      7. Complete - Develop Talend job to load Doc Type dimension
      8. Complete - Develop Talend job to load Project dimension
      9. Complete - In progress Develop Talend script to load origin dimension
      10. Complete - Development for web service to retrieve all accounts by Org and all Org children. This will aide applications using KSR and KFS hierarchy for authorization.
      11. Complete - Scripts to add KFS attributes to the Internal Directory (people database) for Administrative LDAP
      12. In progress - Develop Talend job to load Time dimension (adding fiscal periods to existing time dimension)
      13. In progress - ETL specs for GL balances and chart of account dimensions(mostly complete, final meeting with Accounting tomorrow)
      14. In progress - Development of ETL to load GL balance table (waiting on final specs, mostly complete)
      15. In progress - Development  Development of ETL Staging jobs for all UCI_* tables
      16. In progress - Scripts to add KFS attributes to legacy data warehouse (employee, payroll). Currently analyzing how many accounts are missing after each account conversion load by the KFS teamCoding is complete - currently testing each time COA is re-loaded.
      17. In progress - Scripts to add KFS attributes to the Internal Directory (people database) for Administrative LDAPCreate a business process document to address old and new procedure for ad hoc querying within KFS and ad hoc querying within DWH
      18. In progress - Prioritize All current FS reports according to definite time lines
      19. In progress - ETL scripts for AR, AP, KREW tablesRequirements specification for the KFS equivalent of the FS0100 part 2 (Ledger Detail Report)
      20. In progress - Specs for capital asset module reports (awaiting final approval from stakeholders)In progress - Prioritization of report development by business analysts
      21. In progress - Set up logic to determine eliminated reports to orgs with new budget office org structure worksheet. Jason is currently working on this for Accounting.
   2. Payroll Certification
      
      1. Still waiting on Accounting to complete functional testing of mandated changes of NIH (DHHS) salary cap calculation. Federal code needs to be populated in SPA database. Accounting is working with Sponsored Projects on this issue.
   3. Data Warehouse Support
      
      1. DWH is operating well as usual, Grace is acting as primary DWH production support
      2. Complete - Query for Chancellor's Christmas Cards
      3. Complete - Changes to custom query to retrieve employees for the Library
      4. Complete - Changes to custom query to retrieve employees for EROS system
   4. Non-DWH Support
      
      1. Grace is still assisting with some PPS related projects (WebPan changes)
2. Next two week planned activities and deliverables
   
   1. Development of ETL specs for Capital Asset tables
   2. Development of ETL job for Capital Asset staging and dimension tables
   3. Begin documenting requirements for Accounts Payable and PURAP modules
   4. Meet with campus shadow systems group to finalize ledger reporting needs
   5. Update DWH database schemas based on recent database 'clean-up' work done in KFS
3. Production support trends in terms of tickets either in JIRA or Footprints.  
   
   1. DWH Production Support 10%, New development 90% (except Grace)
4. Staffing issues or personnel related matters
   
   1. None at this time
5. Budget requests for any new software or hardware
   
   1. None at this time
6. Training requests
   
   1. None at this time
7. Things learned, suggestions for improvements or anything else you think might be important
   
   1. None at this time