Decision Support Links
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
JIRAs Waiting for ETL or Package builds - KFS Decision Support
KFS Decision Support & Data Warehouse Team
Valerie Jones - Project Lead, Operational Support (50%)
Tammy Phan - ETL Developer, Operational Support, Technical Specifications (50%)
Anh Le - ETL Developer, Operational Support (100%)
Pramod Kunju - Data Modeler, ETL Developer, Technical Specifications (100%)
Eufemia Palomino - Lead Report Developer, Technical Specifications (100%)
Scott Kidder - Report Developer for KFS
Matthew Levin (student) - Report Developer
KFS Decision Support Project Page
/wiki/spaces/UCIKFS/pages/23315701
KFS Data Warehouse & Extract Transform Load (ETL) Documentation
Data Warehouse - KFS Data Conversion Considerations for Legacy Data Warehouse Queries
Highest Priority Reports Due by Fiscal Year End
| Report Name | JIRA | Specs Completed? | Cognos Framework Required? | ETL Required? | Due Date | Status | Comments |
|---|---|---|---|---|---|---|---|
| Schedule C | KFSDW-570 | No | unknown | unknown | 3/2/2015 | Spec In Progress | |
| GL070 | KFSDW-466 | Yes | No | No | 4/30/2015 | Ready for Test | |
Reclassify Principle and Interest Payments on Installment Purchases | KFSDW-509 | No | unknown | unknown | TBD | Spec Needed | |
| GEC Transfer | KFSDW-526 | Yes | Yes | Yes | 3/16/2015 | In Progress | |
| Small Business Subcontracting Plans Report | KFSDW-539 | Yes | Yes | No | 3/30/2015 | In Progress | |
| Open Fund Control Accounts with Cost Sharing | KFSDW-593 | Yes | Yes | No | 2/27/2015 | Ready for Test | |
| Small Business Utilization Report | KFSDW-543 | Yes | Yes | No | 9/30/2015 | Not Started | Should we take this one off the list since its not due by FYEC? |
| Bank Reconciliation and Intercampus | KFSDW-392 | No | Yes | Yes | TBD | In Progress | |
| Payment on Pcard by Vendor with Account Numbers | KFSDW-541 | Yes | Yes | Yes | 6/1/2015 | Not Started | Melissa will ask Purchasing if Spend Radar can satisfy this requirement |
| Payment on POs with Account Numbers | KFSDW-542 | Yes | Yes | Yes | 6/1/2015 | Not Started | Melissa will ask Purchasing if Spend Radar can satisfy this requirement |
| Award Lookup Report | KFSDW-508 | Yes | Yes | No | TBD | Ready for Test | |
| Account Transaction Detail Report Enhancements | KFSDW-540, KFSDW-610 | Yes | No | No | 4/30/2015 | In Progress | Need to modify document links per doc type. |
| Loan Fund Balances Report Enhancements | KFSDW-251 | No | No | No | TBD | Spec Needed | |
| Payquest Travel/Non Travel | KFSDW-552 | No | Yes | Yes | 4/1/2015 | Spec Needed | |
| Lease Expenses | KFSDW-569 | No | unknown | unknown | 5/1/2015 | Spec Needed | |
| Fund Balance and Transaction Code Summary Report | KFSDW-596 | No | No | No | TBD | Spec Needed | |
| Organization Account Status Code Report | KFSDW-595 | Yes | No | No | TBD | Ready for Test | Re-working a report that Katherine Gallardo has already developed |
| Statement of Revenues Expenses and Changes in Net Position (SRECNP) | KFSDW-613 | No | Yes | Yes | TBD | Not Started | Need to add UCOP object code to object dimension first. |
Completed Reports
Future Reports
Security Requirements
KSams Roles
- KFS Decision Report Viewer - allows users to view all reports in the 'General Ledger', 'Chart of Accounts', 'Capital Asset', and 'Purchasing/Accounts Payable' folders.
- Existing KFS Roles
- Explicit access to the KFS Decision Support Report Viewer Role
- KFS Decision Support Advanced (AdHoc) - allows users to the KFS Cognos Departmental Packages in Query Studio
- Explicit access to KFS Decision Support Advanced Role
- KFS Decision Support Central Office
- Existing KFS Roles
- Explicit access to the KFS Decision Support Report Viewer Role
- KBM Decision Support Central Office
- Existing KBM Roles (KFS-FP - University Budget Manager)
- Explicit access to KBM Decision Support Central Office Role
- KBM Decision Support Report Viewer - allows users to view all reports for all reports in the 'Budget' folder, restricted by organization code.
- Existing KBM Roles
- Explicit access to the KBM Decision Support Report Viewer Role, which will also be org based row-level security
Cognos Groups (Access will be by existing KBM/KFS roles ONLY)
KFS Central Purchasing/Accounts Payable
KFS PDP Check Report Viewer
Securing Reports
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.
KFS Decision Support Focus Group