KFS Feeder Systems Status Updates - 2014-05-22

Status Updates: 

• UAT 1

  
  
  • Parking (Complete)
  • Housing/OSCAR (Complete)
  • CTES (Completed)
  • Library (Complete)
  • Payroll (Incomplete, Black Box file)
  • Student Financial Systems
    
    • ARC (Complete, Black Box)
    • SBS (Complete)
    • CBSO (Complete)
    • CCCS (Incomplete)
    • OPAL (Complete)
    • SLC (Complete)
    • Fin Aid (Complete)
    • Grad Div (Complete)
  • Telecomm/COMPCO (Completed, Black Box)
  • C&G Billing (Incomplete)
  • IRB (Incomplete)
  • ULAR (Incomplete)
  • Facilities (Complete)
  • Medical Center (Complete)
  • UCOP (Incomplete)
  • Bio Sci (Incomplete, Will use Internal Billing instead)
  • Phy Sci (Complete)
  • UNEX/Summer Session (Complete)
  • EH&S (Incomplete, Will use Internal Billing instead)
    
    

Summary of Completion:

Feeder Systems:

Shadow Systems:

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.
• EH & S

  • HI Modesto,

    Not sure who else to send this to so here goes… Sorry to stick you in my mess again! We were so close to having our end programmed last year so I didn’t think I would have any trouble switching to the new template so I have kinda lagged in getting this moving again. Unfortunately I fould a problem…

    Back when I was first working on this we were asked to use AD_CR_CCR_DV_SB_Import.xls as our upload temple. When our file was ready to test and I sent it to Maria to help with a small upload issue she discovered a bug that was to be worked out by OIT (as per the email below) not sure if bug was fixed but she also let me know that we needed to switch templates and to use DI_YEDI_IB_TF_YETF_PE_Encumbrance_Only_import.xls. instead. I just discovered that there is an important difference between the templates: The AD_CR_CCR_DV_SB_Import template contained a “Line Description” field as we had indicated we needed at the start of this project. The DI_YEDI_IB_TF_YETF_PE_Encumbrance_Only_import.xls does not. We really need to have that description field if at all possible. Also, should  ACCOUNTS_CAN_CROSS_CHARTS_IND parameter be set to NO? I’m guessing it should be.

    If you can help in any way I would appreciate it!

    Jen

• 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

  
  
  • OSCAR-KFS Integration Project

• 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.

  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.

  • 90%  ->  Preparation for production implementation including turnover and deployment.  Coding and testing are completed.

    85%  ->  Coding is completed but user test is still going.

    75%  ->  Coding and testing are in progress.

    Please note that SLC is scheduled to go live by July 31, 2014 instead of June 30, 2014.  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

  
  
  • GD - KFS Integration Projects Overview
  • Student side is being tested with SBS, they will do a back-end sync on Oct 21st, 2013.

  • OR is 100% and fully tested.  GD is 100% but we’re still doing more testing (mainly so we can show GD staff how things will look in KFS and Cognos).  Our testing continues to be complicated by the SBS and KFS data resets, but overall we’re in fine shape for the go-live.

• 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.
  • Joe asked: Did you hear any decision of changing the org code?  Reject too?  I heard SOM Finance team had submitted a revision of org codes last month again, and wait for the other schools to submit.  I knew Campus rejected another SOM request to add additional level of organization (i.e. an additional level under department/subdivision/division/organization in Data Warehouse). 

Detailed Project Plan With Completion Percentage: