DWH Team Status Report for 02/08/2013
DWH KFS Decision Support JIRA Tasks - Status Chart
Prior Two Week Activity
Kuali Financial System
Completed
- PURAP model
- Specs for highest priority reports delivered to General Accounting for sign off
- Feeder System Validation Report
- ETL specs for Capital Asset tables
- Met with Caryn Bender for Workflow & Access reporting requirements
In Progress
- Scripts to add KFS attributes to legacy data warehouse (employee, payroll, fs). Coding is complete - currently testing each time COA is re-loaded.
- Code review of ETL jobs delivered from consultant
- Prioritize All current FS reports according to definite time lines
- Report Specs for capital asset module reports
- ETL development for PURAP
- ETL specifications for PURAP
- Requirements for Accounts Payable and PURAP modules
- Hardware setup for Cognos production servers
- Report design guide document
Reports to Be Developed with Prioritization:
| Legacy System | Undecided | AP | KFS | SC | 12/1/2012 | 1/1/2013 | 4/1/2013 | 7/1/2013 | 10/1/2013 | 12/1/2013 | 4/1/2014 | Grand Total |
| DRS | 1 | 1 | ||||||||||
| EQS | 1 | 1 | 1 | 3 | ||||||||
| FS | 3 | 1 | 2 | 9 | 16 | 14 | 1 | 6 | 52 | |||
| PAL | 0 | 0 | 1 | 1 | 0 | 2 | ||||||
| PPP | 1 | 1 | ||||||||||
| UCAP | 3 | 1 | 1 | 1 | 1 | 4 | 4 | 1 | 16 | |||
| UCFS | 0 | 0 | ||||||||||
| UCOP | 1 | 1 | ||||||||||
| UCPO | 1 | 0 | 1 | 2 | ||||||||
| Grand Total | 8 | 1 | 2 | 1 | 2 | 3 | 10 | 21 | 19 | 1 | 9 | 78 |
Payroll Certification
Code changes completed for DHHS enhancement. We are currently testing the code changes and verifying the data.
Data Warehouse Support
DWH is operating well as usual, Grace is acting as primary DWH production support.
Recent support tasks include:
- Modify employee query for EROS to include separated employees
- Annual University Hills Report
- Automated Extracts for spend analysis
Next two week planned activities and deliverables
- Continue working on approval for high priority reports
- Data Model for Authorization module (KIM)
- Report development for highest priority reports
Production support trends in terms of tickets either in JIRA or Footprints.
DWH Production Support 10%, New development 90% (except Grace)
Staffing issues or personnel related matters
...