...
Seventh Integration Test: August 16th - September 9th
- Parking (Completed)
- Housing/OSCAR (Completed)
- CTES (Completed)
- Library (Completed)
- Payroll (Completed, Black Box file)
- Student Financial Systems
- ARC (Completed, Black Box)
- SBS (Completed)
- CBSO (Completed)
- CCCS (Completed
- OPAL (Completed)
- SLC (Incomplete, Black Box)
- Fin Aid (Incomplete)
- Grad Div (Incomplete)
- Telecomm/COMPCO (Completed, Black Box)
- C&G Billing (Incomplete)
- IRB (Incomplete)
- ULAR (Incomplete)
- Facilities (Completed)
- Medical Center (Incomplete)
- UCOP (Incomplete)
- Bio Sci (Incomplete, Black Box file)
- Phy Sci (Complete)
- UNEX/Summer Session (Incomplete)
Summary of Completion:
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
- 100% complete. Testing in progress.
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 In Testing KFS Tech Team In Testing 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 NA In Testing Modesto/Artie Butler In testing with AMS Test Server. 8 KFS to SMS FTP NA In progress Modesto/Phil Obregon Files are being sent, however, no feedback has been provided. MC is still to set up XFER connection
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: 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 to update from.
Other than that, Compco KFS upload is pretty much done.
Student Financial Systems
For the project status of student financial systems KFS conversion, please view our project plan in dfs\adcom\shares\docs\applicationdoc\sbs\kfs\project_plan_sfinsvcs_kfs_20130606.pdf
In summary, we are currently performing user acceptance test and cycle test to process data feed from Housing, Grad Division, Office of Financial Aid and Scholarships, Library, and LARC. However, the test progress is falling behind our project schedule because the user community including developers is swamped with Fiscal Year-end Closing. Thanks.
Parking
- 95% complete with the GL feed, functional users are looking at the GL. Other systems still in progress.
Grad Division/Office of Research
...
Payroll
- 100% Completed FS Legacy file conversion, in the process of testing.
...
- Working on getting Webservices to work for account conversion.
...
- Need sample data, reviewing data loading. Issues with Orgs and missing Account-Fund crosswalk entries.
Summary of Completion:
Feeder Systems:
| Task Name | % Complete | Last Update |
| HR QuickTemp (Feeder) | 100% | |
| OIT - Telecommunication (Feeder) | 100% | |
| Bookstore Recharges (Book, TOES) (Feeder) | 100% | |
| EH&S (Feeder) | 100% | |
| AFS - C&G Billing (Feeder) | 100% | |
| Payroll (Feeder) | 100% | |
| Campus Billing System Online (Feeder) | 60% | 07/02/2013 |
| OPAL Cashiering and Campus Online Deposit (Feeder) | 60% | 07/02/2013 |
| Foxpro/ARC (Feeder) | 60% | 07/02/2013 |
| Student Housing (Feeder) | 98% | 07/09/2013 |
| Campus Credit Card System (Feeder) | 60% | 07/02/2013 |
| Facilities (Feeder) | 92% | 07/02/2013 |
| UNEX applications (Feeder) | 85% | 07/29/2013 |
| PI Report (Feeder) | 70% | 07/02/2013 |
| Library (Feeder) | 65% | 07/15/2013 |
| Student Billing System (Feeder) | 60% | 07/02/2013 |
| Biological Sciences (Feeder) | 50% | 07/02/2013 |
| Physical Sciences (Feeder) | 50% | 07/15/2013 |
| UPS (University Physicians & Surgeons) (Feeder) | 50% | 07/02/2013 |
| Student Loan and Collections Re-write (Feeder) | 30% | 07/02/2013 |
| Parking & Transportation - TDS Systems (Feeder) | 53% | 07/02/2013 |
| UCIMC (Feeder) | 40% | 07/02/2013 |
| Cost Sharing System (Feeder) | 10% | 07/02/2013 |
| Office of Research (Feeder) | 9% | 07/09/2013 |
| Graduate Division (Feeder) | 8% | 07/09/2013 |
...
| Task Name | % Complete | Last Update |
| Pharm Sci Tracking System | 100% | |
| Learning and Academic Resource Center to SBS Feeds - I-Rong | 100% | 07/29/2013 |
| eDocs: Rapid Return | 75% | 06/20/2013 |
| OIT - Data Warehouse (Cognos) - Val will link main project plan | 53% | 07/09/2013 |
| Gift Form | 30% | 07/05/2013 |
| SOM Decision Support - Joe Liu | 20% | 07/29/2013 |
| AFS - Payroll Certification | 15% | 07/05/2013 |
| DEFT (Employee might convert to ucop, but Students will not) | 10% | 07/02/2013 |
| SNAP Documents - Sonja | 7% | 07/15/2013 |
| Tax Relief Act (TRA) system | 5% | 07/02/2013 |
| OIT - Mobius Reports | 0% | 07/15/2013 |
Status Report:
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
- 100% complete. Testing in progress.
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 In Testing KFS Tech Team In Testing 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 NA In Testing Modesto/Artie Butler In testing with AMS Test Server. 8 KFS to SMS FTP NA In progress Modesto/Phil Obregon Files are being sent, however, no feedback has been provided. MC is still to set up XFER connection
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: 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 to update from.
Other than that, Compco KFS upload is pretty much done.
Student Financial Systems
For the project status of student financial systems KFS conversion, please view our project plan in dfs\adcom\shares\docs\applicationdoc\sbs\kfs\project_plan_sfinsvcs_kfs_20130606.pdf
In summary, we are currently performing user acceptance test and cycle test to process data feed from Housing, Grad Division, Office of Financial Aid and Scholarships, Library, and LARC. However, the test progress is falling behind our project schedule because the user community including developers is swamped with Fiscal Year-end Closing. Thanks.
Parking
- 95% complete with the GL feed, functional users are looking at the GL. Other systems still in progress.
Grad Division/Office of Research
Payroll
- 100% Completed FS Legacy file conversion, in the process of testing.
- UNEX/ Summer Session
- Working on getting Webservices to work for account conversion.
- SOM
- Need sample data, reviewing data loading. Issues with Orgs and missing Account-Fund crosswalk entries.
Detailed Project Plan With Completion Percentage:
...