Versions Compared

Version Old Version 4 New Version 5
Changes made by

Modesto Sevilla

Modesto Sevilla

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Second Integration Test occurring February 15th. 


    • Parking (Completed)
    • Housing/OSCAR (Completed)
    • CTES (Completed)
    • ARC/OPAL (Completed)
    • Library (Completed)
    • Payroll (Incomplete, Black Box file, file provided manually)
    • CBSO (Completed)
    • CCCS (Incomplete, file provided manually)
    • SBS (Completed)
    • SLC (Completed)
    • Telecomm/COMPCO (Completed)
    • C&G Billing (Incomplete)
    • IRB (Incomplete)
    • ULAR (Incomplete)
    • Facilities (Completed)
    • Medical Center (Incomplete)
    • UCOP (Incomplete)
    • PBS (Incomplete)
    • Bio Sci (Incomplete)
    • Phy Sci (Completed)
    • 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

    • KFS to SMS GL transaction feed -- Coding complete 100%, ready for testing.
      KFS to AMS check number feed - Requirement complete.  The check feed file will be consolidated with SBS feed file. 90% complete.
      KFS to AMS vendor feed - Spec completed.  Coding complete 100%, ready for testing.
      AMS to KFS payment upload ..... 90% crosswalk completed, working with AMS to complete the spec.  Coding will be done by AMS.
    • AMS to KFS collector batch upload of invoice accruals -- 0%.  Sent required format to AMS but no work delivered yet.
  • Facilities

    • Testing issues because of incomplete account conversion and organization codes.
    • There are 104 records where the New Org ID did not appear in the New Org Structure I was provided. I was hoping you could provide or direct me to the latest copies of this information or confirm that these are a "work in progress" and will appear in later revisions of those files. There also happens to be a couple of missing Old Org names too. I was hoping you could point me to where I can find the appropriate names for these "old orgs"
  • Housing

    • 12% completion.  Testing GL file upload.
  • Biological Sciences

    • Restarted their efforts to convert to KFS after being put on hold.
  • Telecommunications

    • The Business Office's Revenue Management System (RMS) application has been updated to use KFS Account #s.

    • We are in the process of testing the updated application.

    • There are RMS RMS: We are still working to update RMS's own "feeder" systems that also need to be updated in support of KFS. Hopefully they can turn to you and your team for support if needed. Unfortunately, we are heavily dependent on datawarehouse's url-based calls for validation, and I just learned from you that we are suppose to move away from that and use "DWH Web Services" instead.The Telecomm "Service Request Form" also depends on DWH's url calls to validate account numbers. That will also need to be updated to use Web Services, although this is a PHP-applicationso 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: 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.

...