...
ZotPortal Channel - KFS Decision Support (under 'Faculty & Staff' tab, 'KFS' tab)
Cognos - KFS Decision Support
Cognos Report Deployment Master - KFS Decision Support
KFS DW Report Development JIRA Dashboard - KFS Decision Support
KFS Decision Support & Data Warehouse Team
Valerie Jones - Manager, Business Intelligence and Data WarehousePramod Kunju - Project Manager, Data Modeler, ETL Developer, Technical Specifications (100%Lead, Operational Support (20%)
Tammy PhanMatatall- ETL DeveloperProject Liason, Operational Support, Technical Specifications, DWQuery (50%)Anh Le -
Pramod Kunju - Data Modeler, ETL Developer, Operational Support Technical Specifications (100%25%)
Eufemia Palomino - Report Developer (KBM Reporting Lead), Report Developer, Technical Specifications (100%)Ursula Hill - KFS Reporting Lead
, Ramesh - Report Developer (KFS), Technical Specifications (100%)
Allison Bennett - ETL Developer (25%)
Rudy Serna (student) - Report & DWQuery Developer
/wiki/spaces/UCIKFS/pages/23298164
...
Data Warehouse - KFS Data Conversion Considerations for Legacy Data Warehouse Queries
OC Zip Code List for OC Vendor Economic Impact Report
Projects
| Project Name | Project Description | Estimated Completion |
|---|---|---|
| Purchasing/Accounts Payable | Add a new data mart to include data from the Accounts Payable, Purchasing, Travel and Entertainment and Accounts Receivable modules in KFS. Reports will also be developed to utilize the new features included in the data warehouse. | Winter 2017 |
| Enhance the existing GL data mart to track historical changes on specified chart of accounts fields, add more balance options to the balance table, as well as add pending entries. Reports will also be developed to utilize the new features included in the data warehouse. | Spring 2017 | |
| Kuali Budget Module | Add a new data mart to include data from the Kuali Budget Module in KFS. Reports will also be developed to utilize the new features included in the data warehouse. | Winter 2017 |
| KFS Upgrade | Winter 2018 | |
| Capital Assets | Enhance existing data mart, which includes historical tracking and monthly snapshots of capital asset data. Reports will also be developed to utilize the new features included in the data warehouse. | TBA |
| Workflow | Add a new data mart to include workflow data from KFS. Reports will also be developed to utilize the new features included in the data warehouse. | TBASpring 2019 |
Security Requirements
/wiki/spaces/UCIKFS/pages/23298280
...
Reports will be secured by KSAMS role or Cognos group.
Securing Data/wiki/spaces/UCIKFS/pages/23315993
All TEM, PO, DV and payment information will be restricted.