...
Fourth Integration Test: April 22nd - June 5th.
- Parking (Completed)
- Housing/OSCAR (Completed)
- CTES (Completed)
- ARC/OPAL (Completed)
- Library (Completed)
- Payroll (Completed, Black Box file)
- 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
- 85% complete, will finish this week.
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 Strategy Completed In testing AMS/UCIMC Changed the strategy to just map their code to KFS instead of conversion, using the web services; testing in progress 3 KFS to AMS Vendor Feed Completed Completed KFS Tech Team Code installed in AMS Test Server, ready to be tested in ITC4 4 KFS to AMS Check Number Feed Completed Completed KFS Tech Team Waiting for Test server 5 AMS Payment Upload Completed In progress AMS Coding in process 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 Discussed the strategy; Artie to set up the server for ITC4 Facilities
- Figuring out process outside of feeding. Feeding process is complete.
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
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
- 95% complete, functional users are looking at the GL.
the
Telecommunications
RMS: Feed generation and upload was successful, after stripping legacy project codes from feed.
Currently unable to test fields: sub-account, sub-object, project - test/sample data still not available to test with?
Testing and fixing web form, but that's not directly related to the KFS upload process.
Compco: Relying on blackbox conversion. Some charges are being rejected because "closed" accounts are still being used. A meeting is scheduled for the Business Office to meet with FS to figure out what happens to the charges, what the Business Office needs to do, and how we'll be notified in order to remove these "closed" accounts from our Compco billing system.
Modesto will regularly provide updated "aftable" and "dptable" data files on xfer.adcom.uci.edu for
Compco's useCompco to update from.
Other than that, Compco KFS upload is pretty much done.
...