DWH Team Status Report for 01/17/2014
DWH KFS Decision Support JIRA Tasks - Status Chart
Prior Two Week Activity
Kuali Financial System
Report List
Module | Report ID | Report Title | Equivalent Legacy Reports | Number of Drill-Through Reports | Priority (1-Critical, 2-Before go-live, 3-After go-live ) | JIRA | Due Date | Spec Status | Data Certified? | Report Development Status | Report Development Assigned To | User Acceptance Completed Date | Comments |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
AP | Use Tax Payment Detail Report | UCAP*MUT | 2 | KFSDW-245 | TBD | Specs Needed | Incomplete | TBD | Specs needed. | ||||
AP | KFS-AP-001 | Stale Dated Check Report | PAL214 | 2 | KFSDW-243 | TBD | Specs Needed | Incomplete | TBD | Specs needed. | |||
AP | Purchase Order Status | 3 | TBD | Specs Needed | Incomplete | TBD | |||||||
AP | EFT Approved Vendor Monthly Summary | UCAP*EFM | 2 | KFSDW-244 | 4/30/2014 | Specs Needed | Incomplete | Specs needed. | |||||
AP | 1042S Reporting (list of NRA tax withholdings paid from AP) | 2 | KFSDW-24 | TBD | Specs Needed | Incomplete | TBD | list of NRA tax withholdings paid from AP. Specs needed. | |||||
AP | DW-AP-005 | Uncleared Checks by Chart Code | UCAP*FMCS | 3 | KFSDW-267 | 3/31/2015 | Specs Needed | Incomplete | TBD | not needed until FYEC 2015 | |||
CAM | Plant Capitalization Worksheet | FS0879H | 3 | KFSDW-234 | 11/30/2014 | Complete | In Progress | Jason Jensen | Request for additional ETL balances by Jason 12-26 Specs complete & ready for development. Report is not needed until January 2015. | ||||
CAM | Inventorial Equipment Report | EQ920 | 3 | KFSDW-237 | 11/30/2014 | Complete | Incomplete | Jason Jensen | Report will be generated 2x/year. Specs require tying an asset to a purchase order, which is problematic because an asset can have multiple POs associated with it. All assets migrated from EQS will not have a PO associated with it, so what do we show for these? | ||||
CAM | Inventorial Asset Disposal Report | EQS032C1 | 3 | KFSDW-238 | 11/30/2014 | Complete | Incomplete | Jason Jensen | |||||
CAM | Fixed Asset Balance Sheet Report | FS0866C | 3 | KFSDW-240 | 11/30/2014 | Complete | In Progress | Jason Jensen | 14-1-2 Parsing ledger description field to generate sub report. This may be too labor intensive to accommodate. Jason needs a list of object codes that are needed for this report. | ||||
CAM | Depreciation Report | EQS240A | 2 | KFSDW-239 | 3/31/2014 | Complete | Incomplete | Jason Jensen | Book value needs to be populated in fact table. ETL changes needed. | ||||
CAM | Asset Inventory List | EQS? | 1 | KFSDW-259 | 2/28/2014 | Specs Needed | Incomplete | TBD | Most likely needed before go-live. Specs are still needed. | ||||
CAM | Construction in Progress` | FS0865A - Capitalizable Asset/Building Report | 1 | KFSDW-256 | 12/31/2013 | Backfill Specs | Complete | Jason Jensen | Need to Submit to QA area. | ||||
CG | Letter of Credit Report | FS0209 series | 2 | KFSDW-262 | TBD | Specs Needed | Incomplete | TBD | Last time of inquiry (October) LOC code not being populated. Is this being populated and where? ETL work needs to be done, and data model changes are needed. | ||||
COA | Organizational Hierarchy | n/a | 1 | n/a | 12/31/2013 | n/a | Completed | ||||||
COA | Chart of Accounts Listings/Lookups | too many to list | 1 | KFSDW-135 | 12/31/2013 | N/A | Completed - revisions requested | Tammy Phan & Students | Focus group has requested some changes | ||||
GL | KFS-GL-001 | Trend Analysis Report | new | 3 | KFSDW-222 | TBD | On Hold | On Hold | Jason Jensen | Based off Paige's report in Excel | |||
GL | KFS-GL-002 | Pivot Object Code Transaction Report | FS0105/106 (Source/Reference control Ledger reports) | 1 | 12/31/2013 | Backfill Specs | Completed | Jason Jensen | |||||
GL | KFS-GL-003 | Object Trans Code Report | FS0212 reports (STIP) | 2 | KFSDW-275 | TBD | Specs Needed | Incomplete | TBD | Waiting on feeds with trans code objects As of 2014-1-2 do not have AGC for transcodes. Need this to group by AGC. | |||
GL | KFS-GL-004 | Object Summary Report | FS0100, FS0200 | 2 | 1 | KFSDW-274 | 1/31/2014 | Backfill Specs | Completed | Jason Jensen | |||
GL | KFS-GL-005 | Object Summary (AS LI) | FS0200B | 2 | 1 | KFSDW-273 | 1/31/2014 | Backfill Specs | Completed | Jason Jensen | |||
GL | KFS-GL-006 | Income Object Code Summary Report | FS0200R reports for income summaries | 1 | KFSDW-272 | 1/31/2014 | Backfill Specs | Completed | Jason Jensen | ||||
GL | KFS-GL-007 | C&G INCOME Object Code Summary Report | FS200R RC for C&G only Acitivity | 1 | KFSDW-271 | 1/31/2014 | Backfill Specs | Complete | Jason Jensen | Need to have students format and send to QA area. | |||
GL | KFS-GL-008 | Multi-year Account Transaction Search | FS0100, DWH multi-year GL query | 3 | KFSDW-270 | 5/31/2015 | Specs Needed | Incomplete | TBD | This is based off of the KFS DS focus group's request. Specs are still needed. This is not needed until we have more than one fiscal year in KFS. | |||
GL | KFS-GL-009 | Encumbrance Report | FS0109 series | 2 | KFSDW-266 | 3/31/2014 | Backfill Specs | Complete | Jason Jensen | Needed daily | |||
GL | KFS-GL-010 | Designated Object Summary for Central Office | FS0218 (specific object code ranges only) | 1 | KFSDW-265 | 12/31/2013 | Backfill Specs | Complete | Jason Jensen | Will hard code in lieu of configuring and saving report. as of 1-2-14 need students to edit and post. | |||
GL | KFS-GL-011 | Control Account Summary Report - Central Office | FS0150 (Fund Summary) | 4 | 1 | KFSDW-124, KFSDW-263 | 12/31/2013 | Backfill Specs | Completed | Jason Jensen | |||
GL | KFS-GL-012 | Control Account Summary Report - Departmental | FS0150 (Fund Summary) - Showing expenses only | 4 | 1 | KFSDW-264 | 1/25/2014 | Backfill Specs | Incomplete | Jason Jensen | |||
GL | KFS-GL-013 | Campus Report | FS0400 series (401-407) | 1 | KFSDW-261 | 1/31/2014 | Backfill Specs | In Development | Jason Jensen | Final touch-ups needed. Fund group ranges are needed. Will we use a KFS field to determine fund groupings or create our own fund group table? | |||
GL | KFS-GL-014 | Account Transaction Report | FS0100 (multiple), FS0213 | 1 | KFSDW-257 | 12/31/2013 | Backfill Specs | Completed | Jason Jensen | ||||
GL | KFS-GL-015 | Credit Balances C&G Only | FSO219 Series reports. For accounts and or object codes with credit balances. All Accounts C&G ONLY versions | 1 | KFSDW-255 | 12/27/2013 | Backfill Specs | Complete | Jason Jensen | Will modify object summary report to return only those accounts and or object codes with credit balances... AS OF with C&G only variants. as of 1-2-14: Need to have students edit and format.
| |||
GL | KFS-GL-016 | Fund Overdrafts by Agency | FS0221 - Fund Over Drafts by Agency | 1 | KFSDW-254 | 2/14/2014 | Backfill Specs | Incomplete | Jason Jensen | We do not have award/proposal numbers in data warehouse/dss_KFS. We need this to complete the report. | |||
GL | KFS-GL-017 | Total Fund Overdraft Expenditures for C&G | FS0220 C & G ONLY | 1 | KFSDW-253 | 12/28/2013 | Backfill Specs | Complete | Jason Jensen | Will modify account summary report to grab only C&G Subfund groups and accounts that have negative variances. Need students to edit and post. | |||
GL | KFS-GL-018 | Overhead Transaction Report | FS0213 | 1 | KFSDW-252 | 1/31/2014 | Backfill Specs | Incomplete | Jason Jensen | All Transcode object codes do not have AGC data in source system. This is necessary for the report. Accounting systems needs to let OIT know when AGC is assigned to all transcode object codes in KFS. | |||
GL | KFS-GL-019 | Loan Fund Balances & Receivables | FSO 203A | 1 | KFSDW-251 | 12/31/2013 | Backfill Specs | Complete | Jason Jensen | ||||
KBM | 1 | KFSDW-224 | 1/31/2014 | Complete | In Progress | Susie Nies | |||||||
KBM | 2 | KFSDW-226 | 3/31/2014 | Complete | Incomplete | Susie Nies | KBM | ||||||
KBM | Budget Adjustment Document Report | FS0BUD Reports, FS0FJ10 | ? - need to discuss with stakeholders (Budget) | KFSDW-260 | TBD | Specs Needed | Incomplete | TBD | Report may not even be needed. There are processes in KFS that potentially eliminate the need for this report. More discussion with Budget Office needed. Allows users to pick by document type and breaks on document number. Specs are still needed. | ||||
KBM | 2 | KFSDW-225 | 2/28/2014 | Complete | Incomplete | Susie Nies | |||||||
KREW | Workflow Action List Report | 2 | KFSDW-288 | TBD | Specs Needed | Incomplete | TBD | This report needs to be real-time. Will be live against KFS db, will use SQL statement from Simran. We will need to build a special Cognos package for just this report. | |||||
KSAMS | Organizational User Access Report | n/a | 3/1/2014 | n/a | Incomplete | KSAMS team | To be done by KSAMS team |
Completed
- Correction of all signage (-/+) in balance jobs - currently being tested
- Report template has been developed
- Document report development process
- Develop QA checklist for reports
Develop Talend jobs to copy procurement card tables (FP_PRCRMNT_*) from KFS to DS
- Introduction/training for new report & ETL developers
- Review specs for new reports
In Progress
- Kuali Budget Reporting - Consultant is developing Sub 0 report
- Report spec developing for CAM and PURAP
- Configuration of TalenD on UNIX server in new version 5.3
- UCPath - analysis of people and people history jobs that create LDAP files in preparation for migration to UCPath
- Cognos framework development for KSAMS
- Determine how we will derive General Accounting fund group ranges
- Ongoing meetings with Focus group
- Build data warehouse tables in production server for KFS, move Cognos reports to point to production database
- Training materials are in development (Kevin)
- Scripts to add KFS attributes to legacy data warehouse (employee, payroll, fs). Coding is complete - currently testing every night for pps daily and every pps month-end. (Grace)
- Conversion of KFS data into legacy tables for use by Payroll Certification and legacy DWH (Grace)
Data Warehouse Support
Next two week planned activities and deliverables
- Continue making bug fixes to ETL scripts and testing
- Continue report development for highest priority reports
- Complete testing of TalenD install on UNIX
Production support trends in terms of tickets either in JIRA or Footprints.
Staffing issues or personnel related matters
Budget requests for any new software or hardware
Training requests
Things learned, suggestions for improvements or anything else you think might be important
UCOP has contacted us regarding Phase 2 of the Spend Analytics project. We will need some additional resources to work on this project next year.