Status Updates:
Third Integration Test March 11th - April
6th13th.
- Parking (Completed)
- Housing/OSCAR (Completed)
- CTES (Completed)
- ARC/OPAL (Completed)
- Library (Completed)
- Payroll (Incomplete, Black Box file, file provided manually)
- CBSO (Completed)
- CCCS (Completed)
- SBS (Completed)
- SLC (Incomplete, Black Box)
- Telecomm/COMPCO (Completed, Black Box)
- C&G Billing (Incomplete)
- IRB (Incomplete)
- ULAR (Incomplete)
- Facilities (Completed)
- Medical Center (Incomplete)
- UCOP (Incomplete)
- PBS (Incomplete)
- Bio Sci (Incomplete, Black Box file)
- Phy Sci (Complete)
- UNEX/Summer Session (Incomplete)
PI Report
- 70% complete, is not able to test because lack of data, the month end balances for awards, and income and expense balances from C&G. Waiting for balance from DataWarehouse, being worked on.
C&G Billing
- 40% complete, need month end data, balances, need the KFS accounts that link up to the balances. Talked to Maria regarding the accounts she is working with Valerie to get test data.
HR
Implementation is completed including translation of FS data to KFS counterparts, validation, GUI, ledger posting, invoice, BLISS reports as well as first time database alter script. One time data migration will utilize the web service client. All FAUs will be translated per function user's request. This means even closed FAUs need to have a match in KFS.
Outstanding items: There is no 2013 chart of account data in KFS test server, so "2012" is hard-coded for object code translation and validation. Ledger posting is hard-coded to post to fiscal year 2012. Once the 2013 data is loaded in KFS, hard-coding needs to be removed. There is no object code mapping for 7217 and 3900 under MC chart. Alerted KFS team of this issue. This means full testing will be delayed until these object codes are added. Default CTES account/fund is translated to different values every time in KFS. However the default CTES account info is hard-coded. Once the translation is finalized, the default CTES chart/account/object will needs to be set. Implementation to generate GL collector file is complete. However there is no KFS test server to upload the collector file from Unix. Currently must go through the Kuali Portal to manually upload the file.
Medical Center
No Task Spec/Mapping Coding/Deployment Assigned To Status 1 Cache DB Upgrade on Test Server n/a AMS/UCIMC Waiting for approval by MC purchasing 2 Chart of Accounts Conversion Completed AMS/UCIMC Ready for conversion 3 KFS to AMS Vendor Feed Completed Completed KFS Tech Team Waiting for Test server 4 KFS to AMS Check Number Feed Completed Completed KFS Tech Team Waiting for Test server 5 AMS Payment Upload Completed In progress AMS Targeted completion date unknown 6 AMS AP Accrual Feed (Collector Flat) Completed In progress AMS Targeted completion date unknown 7 AMS to KFS Secure FTP Completed In progress Modesto/Artie Butler Facilities
- Testing issues because of incomplete account conversion and organization codes.
- 80% complete, 90% complete for liens.
Housing
Biological Sciences
- Restarted their efforts to convert to KFS after being put on hold.
Telecommunications
- RMS: We are still working to update RMS's own "feeder" systems so that we can proceed with testing. We will be doing another "conversion" of a past month's billing cycle to test the feed generation and upload.
- Compco: COMPLETED - We are working with you (Modesto) to upload our Compco feed. However, we do have an issue, as discussed over the phone. First, you confirmed that when new accounts are created, legacy "account-fund" information is created for those new accounts as well. Compco updates its collection of account-funds weekly by importing an "aftable" and "dptable" from the IBM mainframe, zeus. Unfortunately, zeus is going away, along with those data tables. I didn't ask, but are there plans for KFS to provide these files, or an equivalent? Otherwise, we will need to work with KFS and Datawarehouse to create the equivalent of those tables, so that Compco can import them. This can entail using KFS Web Services, getting direct access to the MSSQL database, reading from a CSV dump, or something else to create the "aftable" and "dptable" for Compco's use.
Student Financial Systems
- Testing GL feeds for SBS, SLC, and OPAL. They were successfully converted and loaded. Need to reconcile to assure they are correct.
Parking
- 90% complete
...