Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

DWH Team Status Report for 12/03/2012

DWH KFS Decision Support JIRA Tasks

 

 

  1. Prior Two Week Activity

    1. Kuali Financial System
      1. Complete - Cognos Performance Testing for Licensing needs for KFS Decision Support
      2. Complete - Talend Development Server - Install and Configure
      3. Complete - Write ETL staging jobs to load KRIM_* tables
      4. Complete - DWH KFS web service to retrieve all child orgs with flattened hierarchy
      5. Complete - Development of jobs to load organization dimension 
      6. Complete - Capital Asset data model delivered by consultant and reviewed
      7. In progress - 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.
      8. In progress - Specs for capital asset module reports (awaiting final approval from stakeholders)
      9. In progress - ETL specs for GL balances and chart of account dimensions
      10. In progress - Development of ETL to load GL balance table
      11. In progress - Development of ETL Staging jobs for all UCI_* tables
      12. 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 team.
      13. In progress - Scripts to add KFS attributes to the Internal Directory (people database) for Administrative LDAP
      14. In progress - ETL scripts for AR, AP, KREW tables
    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
    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. Requirements for Accounts Payable and PURAP modules
  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

 

  • No labels