/
KFS Feeder Systems Status Updates - 2013-04-08

KFS Feeder Systems Status Updates - 2013-04-08

Status Updates: 

  • Third Integration Test March 11th - April 13th. 


    • 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

     

    NoTaskSpec/MappingCoding/DeploymentAssigned ToStatus
    1Cache DB Upgrade on Test Servern/a AMS/UCIMCWaiting for approval by MC purchasing
    2Chart of Accounts Conversion StrategyCompletedIn testingAMS/UCIMCChanged the strategy to just map their code to KFS instead of conversion, using the web services; testing in progress
    3KFS to AMS Vendor FeedCompletedCompletedKFS Tech TeamCode installed in AMS Test Server, ready to be tested in ITC4
    4KFS to AMS Check Number FeedCompletedCompletedKFS Tech TeamWaiting for Test server
    5AMS Payment UploadCompletedIn progressAMSCoding in process
    6AMS AP Accrual Feed (Collector Flat)CompletedIn progressAMSTargeted completion date unknown
    7AMS to KFS Secure FTPCompletedIn progressModesto/Artie ButlerDiscussed the strategy; Artie to set up the server for ITC4
  • Facilities

    • Testing issues because of incomplete account conversion and organization codes.
    • 80% complete, 50% 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

Issues:

  • COA is not 100% complete.  In progress.
  • Organization codes are not complete.

Next Steps:

  • Finalize COA.  Progress has been made, new way to map Balance Sheet accounts is being tested.
  • Finalize Organization Codes.

Summary of Completion:

Task NameStartFinishResource Names% Complete
FEEDER AND CAMPUS SYSTEM MIGRATIONSFri 7/1/11Thu 1/30/14 25%
   Environment PreparationFri 7/1/11Sat 9/1/12 84%
      Priority 1 - before KFS Go-live and by December 1, 2012Fri 7/1/11Sun 12/1/13 61%
      Priority 2 - before KFS Go-live and by April, 2013Fri 7/1/11Fri 11/29/13 16%
      Priority 3 - after KFS Go-live migrate before December 2013Fri 7/1/11Thu 1/30/14 11%

Detailed Project Plan With Completion Percentage:

Task NameStartFinishResource Names% Complete
FEEDER AND CAMPUS SYSTEM MIGRATIONSFri 7/1/11Thu 1/30/14 25%
   Environment PreparationFri 7/1/11Sat 12/1/12 84%
      Meet with system owners and technical staffFri 7/1/11Sat 6/30/12 90%
         Identify campus systems and ownersFri 7/1/11Tue 2/28/12modesto,keiko,maria100%
         Educate functional and technical owners about KFSThu 3/1/12Sat 6/30/12maria90%
         Determine if campus systems can be replaced by KFS functionalityThu 3/1/12Sat 6/30/12maria70%
      Prepare documentation/materials for system migrationsFri 7/1/11Sun 7/15/12 82%
      Prepare data files and web services for system migrationsThu 9/1/11Sat 12/1/12 94%
         Build and refine database instance for feeder systemsThu 9/1/11Wed 8/1/12warren,keiko80%
         Develop KIM web services - access checkingTue 5/15/12Fri 6/1/12adam80%
         Build black box for conversionTue 11/1/11Sat 12/1/12 100%
         Develop data warehouse services for feeder & campus systemFri 5/18/12Wed 8/15/12 91%
            Define validation servicesFri 5/18/12 valerie,programmers80%
            Build DW repository for ledger detail downloadsFri 6/1/12Sat 6/30/12valerie80%
            Develop web services for validations (account, chart, fund group, object, organization, project, sub fund group, sub object, acct period, gl entry, encumbrance)Fri 6/1/12Wed 8/15/12adam,jarrod95%
      Define and develop SAMS replacement for campus systemsFri 1/6/12Mon 7/30/12 20%
         SAMS replacement analysis & designFri 1/6/12Mon 7/30/12josh,warren,marina,Carmen,Caryn,jason,etc20%
         Install KSRWed 2/1/12Wed 2/1/12warren100%
         Identify roles used in systemsFri 1/6/12Fri 1/6/12Caryn10%
         Populate KIM and test system accessFri 1/6/12 adam,programmers10%
         Train DSAs  Caryn0%
      LDAP changesFri 7/1/11 jason lin10%
   Feeder & Campus System Migrations (see individual system plans (rubric) for more details)Fri 7/1/11Tue 4/2/13 20%
      Priority 1 - before KFS Go-live and by December 1, 2012Fri 7/1/11Sat 12/7/13 61%
         eDocs: Rapid ReturnTue 5/1/12Thu 1/31/13?0%
         Cost Sharing SystemTue 5/1/12Sat 12/1/12jane,chris8%
         FacilitiesMon 4/16/12Tue 1/1/13 80%
            FM - Design DocumentMon 4/16/12Mon 4/16/12 100%
            FM - FacServe - Charges XML Upload to Kuali (Feeder)Mon 4/16/12Fri 6/1/12jyoti/alvin90%
            FM - FacServe - Lien XML Upload to Kuali (Feeder)Mon 6/4/12Sun 6/24/12jyoti/alvin50%
            FM - Utilities BillingMon 4/16/12 jyoti100%
            FM - Fau ValidationMon 4/16/12Mon 4/16/12 100%
            FM - FSSMon 4/16/12 alvin90%
            FM - Billing Review and Exception ReportsMon 4/16/12  90%
            FM - Data MigrationMon 4/16/12  50%
            FM - Projects 8iMon 10/1/12Fri 10/26/12?50%
            FM - Tririga Data Warehouse   0%
         Student Financial Systems - SfinSvcs (Phase I)Fri 7/1/11Fri 12/28/12 49%
            Campus Billing System OnlineTue 5/1/12Sat 12/1/12i-rong Lin[50%],lucy Zheng[50%],Calvin Yip[20%]50%
               CBSO Online Coding and Unit TestTue 5/1/12Tue 5/1/12 50%
               CBSO Batch Ledger Posting and Unit TestTue 5/1/12Tue 5/1/12 50%
               Data Feed from Library and LARCTue 5/1/12  50%
               Data Feed from Library and LARCTue 5/1/12Sat 12/1/12 50%
               KIM Integration for Access Management   0%
            OPAL Cashiering and Campus Online DepositMon 7/2/12Fri 6/28/13i-rong Lin[50%],Cecilia Do[50%],james Hsu[50%],Calvin Yip[20%]50%
               COD TemplateMon 7/2/12  50%
               COD DepositMon 7/2/12  50%
               Point of SaleMon 7/2/12  50%
               KIM Integration for Access ManagementMon 7/2/12  50%
            Campus Credit Card SystemMon 7/2/12Fri 6/28/13i-rong Lin[50%],Cecilia Do[50%],james Hsu[50%],Calvin Yip[20%]28%
               Online Credit Card Entry   0%
               Program ProfileMon 7/2/12  50%
               Void and Refund   0%
               KIM Integration for Access ManagementMon 7/2/12  20%
               Batch Ledger Posting to KFSMon 7/2/12  50%
               KFS COA ValidationMon 7/2/12  50%
            Foxpro/ARCWed 1/2/13Fri 6/28/13victor Tam[50%],Nasim Mohebbi[50%]0%
               ARC Interface with SBS for Write-off   0%
               ARC Interface with OPAL Cashiering   0%
               ARC Interface with CBSO   0%
            Student Housing (Feeder System)Mon 7/2/12Sat 12/7/13 86%
               Online System Community Accounts Receivable (OSCAR)Fri 7/1/11 markus71%
               Housing to KFSFri 7/1/11Fri 7/1/11markus100%
         HR QuickTemp[ (Feeder)Tue 5/1/12Wed 4/3/13Christa95%
         OIT - Data Warehouse (Cognos) - Val will link main project planTue 5/1/12Wed 4/3/13 53%
         OIT - Telecommunication (Feeder)Tue 5/1/12Sat 12/1/12theresa,anthony66%
            CFRTue 5/1/12Wed 4/3/13theresa66%
            Telephone BillingTue 5/1/12Wed 4/3/13theresa66%
            Acceptance testing & sign-off by AccountingTue 5/1/12Wed 4/3/13isabelle,victor66%
         PI ReportTue 5/1/12Sat 12/1/12alvin70%
            Convert applicationTue 5/1/12Sat 12/1/12alvin80%
            Migrate from SAMS to KSRTue 5/1/12Sat 12/1/12alvin60%
         Parking & Transportation - TDS Systems (feeder)Tue 5/1/12Sat 12/1/12Clint90%
            TDS - Financial Core (New System)Tue 5/1/12Sat 12/1/12Clint90%
            TDS - Authorize.net modules (relatedTue 5/1/12Sat 12/1/12Clint90%
      Priority 2 - before KFS Go-live and by April, 2013Fri 7/1/11Mon 4/1/13 16%
         AFSTue 5/1/12Mon 4/1/13 20%
            AFS - C&G BillingTue 5/1/12Mon 4/1/13jarrod40%
            AFS - Payroll CertificationTue 5/1/12Mon 4/1/13?0%
         FacilitiesMon 8/6/12Fri 9/14/12 77%
            FM - Ipool - XML Upload to Kuali (Feeder)Mon 8/6/12Fri 9/14/12jyoti/alvin90%
            FM - Utilities Master Excel SpreadsheetMon 8/6/12 jyoti/alvin65%
            FM - Workorder Printing  jyoti/alvin0%
         Graduate DivisionFri 7/1/11Fri 11/29/13 0%
            GD - Fellowship Web Application (enhance to handle FS * KFS FAU info)Tue 5/1/12Mon 4/1/13eric t5%
            GD - GradAid Backend ProcessingFri 7/1/11Fri 11/29/13eric t0%
            GD - GradAid Fellowships (enhace to handle FS & KFS FAU info)Tue 5/1/12Mon 4/1/13eric t0%
            GD - GradAid Remission (enhance to handle FS & KFS FAU info)Tue 5/1/12Mon 4/1/13eric t0%
            GD - GradAid Reports (enhance to handle FS & KFS FAU info)Tue 5/1/12Mon 4/1/13eric t0%
            GD - GradAid SBS DirectConnect InterfaceTue 5/1/12Mon 4/1/13eric t0%
            GD - GradAid Surf-Postdoc (enhance to handle FS & KFS FAU info)Tue 5/1/12Mon 4/1/13eric t0%
            GD - Graduate Student SupportTue 5/1/12Mon 4/1/13eric t0%
            GD - OGSNightJob  eric t0%
            GD - Tuition Fee Remission SystemTue 5/1/12Mon 4/1/13eric t0%
         Gift FormTue 5/1/12Mon 4/1/13jane0%
         OIT - Mobius ReportsTue 5/1/12Mon 4/1/13?0%
         Office of ResearchTue 5/1/12Mon 4/1/13 1%
            OR - ARRA Web Reporting SystemTue 5/1/12Mon 4/1/13eric t0%
            OR - ARS System (enhance to handle FS & KFS FAU info)Tue 5/1/12Mon 4/1/13eric t2%
            OR - Award eSynopsisTue 5/1/12Mon 4/1/13eric t0%
            OR - BMTA SystemTue 5/1/12Mon 4/1/13eric t0%
            OR - Contracts & Grants Online ProgramTue 5/1/12Mon 4/1/13eric t0%
            OR - HPS IRB Fee Recharge (enhance to send trans directly to KFS) (Feeder)Tue 5/1/12Mon 4/1/13eric t5%
            OR - SCRC Recharge SystemTue 5/1/12Mon 4/1/13eric t0%
            OR - SPA System (many changes)Tue 5/1/12Mon 4/1/13eric t0%
            OR - ULAR Animal Order Request System (enhance to handle FS & KFS FAU info)Tue 5/1/12Mon 4/1/13eric t2%
            OR - ULAR Cage Card Recharge (enhance to send trans directly to KFS) (Feeder)Tue 5/1/12Mon 4/1/13eric t5%
         SfinSvcs - DEFT (Employee might convert to ucop, but Students will not)Tue 5/1/12Mon 4/1/13?0%
            Migrate from SAMS to KSRTue 4/2/13Wed 4/3/13 0%
            Acceptance testing & sign-off by Accounting  isabelle,victor0%
         SNAPTue 5/1/12Mon 4/1/13sonja,katya0%
         Student Affairs TimeKeeperTue 5/1/12Thu 5/30/13ying0%
         Parking & Transportation - TDS Systems (feeder)Tue 5/1/12Mon 4/1/13 90%
            TDS - AntparkTue 5/1/12Mon 4/1/13Clint90%
            TDS - EPICS - collections moduleTue 5/1/12Mon 4/1/13Clint90%
            TDS - EPICS core financialTue 5/1/12Mon 4/1/13Clint90%
            TDS - Guest Reservation SystemTue 5/1/12Mon 4/1/13Clint90%
            TDS - Mail Services RechargeTue 5/1/12Mon 4/1/13Clint90%
      Priority 3 - after KFS Go-live migrate before December 2013Fri 7/1/11Thu 1/30/14 11%
         eDocs: Shredding, Scanning and Misc. (Provide a total recharge amt and enter directly into KFS)Tue 5/1/12Sun 12/1/13linh nguyen0%
         FacilitiesMon 2/25/13Sat 4/20/13 0%
            FM - Adhoc queriesMon 2/25/13Sat 4/20/13tammy0%
            FM - Financial Report   0%
            FM - Job Report   0%
            FM - Portfolio Updates (could be switched off temporarily)   0%
            FM - Projects Report   0%
            FM - Renovation Report (tentative, may be replaced)   0%
         Graduate DivisionFri 7/1/11Sun 12/1/13 7%
            GD - GradDiv Database Queries (Moderate - Enhancements to numerous queries to also use KFS Account line detail)Fri 7/1/11Sun 12/1/13eric t7%
            GD - OGSA CCCS Profile  eric t0%
            GD - TRA ReportingFri 7/1/11Sun 12/1/13eric t8%
            GD - UCOP Financial Input File (Extract to handle FS and KFS FAU info)Fri 7/1/11Sun 12/1/13eric t7%
         HRTue 5/1/12Thu 1/30/14 9%
            HR - ContractProTue 5/1/12Thu 1/30/14ying0%
            HR - Equity AdvisorTue 5/1/12Thu 1/30/14ying12%
            HR - FastClassTue 5/1/12Thu 1/30/14ying12%
            HR - QuickRec/GreentreeTue 5/1/12Thu 1/30/14ying12%
         Office of ResearchTue 5/1/12Sun 12/1/13 11%
            OR - Request for Approval to Spend FundsTue 5/1/12Sun 12/1/13 11%
         Parking & Transportation - TDS Systems (feeder)Tue 5/1/12Sun 12/1/13 7%
            TDS - Achohol Order, Stamp Order, Long-Term Storage, Receiving PU/Delivery, Bulkmail and Misc. (enter charge directly into KFS)Tue 5/1/12Sun 12/1/13Clint0%
            TDS - Citation Management?Tue 5/1/12Sun 12/1/13Clint20%
            TDS - Event Contracts System?Tue 5/1/12Sun 12/1/13Clint0%
         Student Financial Systems - SfinSvcs (Phase II)Sun 7/1/12Sat 12/7/13 18%
            Student Billing SystemTue 5/1/12Sat 12/7/13i-rong Lin[50%],tu Dang[50%],james Hsu[50%],victor Tam[50%],Nasim Mohebbi[50%]18%
               Check disbursement and Interface with KFS PDP/PURAP   0%
               Mapping between KFS COA and FS Full Accounting UnitTue 5/1/12Fri 12/28/12 1%
               Batch Ledger Posting to KFSTue 5/1/12  40%
               Development of Conversion from KFS COA to FS Full Accounting UnitTue 5/1/12Fri 12/28/12 0%
               Development of Conversion from Full Accounting Unit to KFS COATue 5/1/12Fri 12/28/12 0%
               SOA Web Services for Data Transmission between Housing and SBSTue 5/1/12Thu 10/18/12 0%
               Data Transmission between CBSO and SBS   0%
               SPOP Data FeedTue 5/1/12Sat 12/7/13 42%
               Re-admit Data FeedTue 5/1/12  40%
               Various Functional Modules in ZOT QueryTue 5/1/12Sat 12/7/13 50%
               Write-off and Uncollectible DebtTue 5/1/12Sat 12/7/13 20%
               OFAS (Office of Financial Aid and Scholarships) Data TransmissionTue 5/1/12Sat 12/7/13 0%
               Graduate Division Data Transmission   0%
               Functional Requirements DefinitionTue 5/1/12Mon 11/12/12 1%
               KFS COA Mapping and ValidationsTue 5/1/12Fri 12/28/12 1%
               KFS COA Conversion for DB Objects and DataTue 5/1/12  70%
               Test for KFS Black Box Mechanism to Verify for Data Accuracy   0%
            Tax Relief Act (TRA) systemWed 1/2/13Sat 12/7/13Nasim Mohebbi[50%],james Hsu[50%]0%
               Mods to Finaid for TRA Eligible Gift Aid   0%
               Mods to Gradaid for TRA Eligible Gift Aid   0%
            Student Loan and Collecitions Re-writeMon 7/2/12Sat 12/7/13i-rong Lin[50%],Calvin Yip[20%],lucy Zheng[80%]36%
               Functional Requirements DefinitionTue 5/1/12  80%
               User Sign-off for Functional Requirements DocumentTue 5/1/12Tue 5/1/12 100%
               Data Modeling for SLC Re-write   0%
               Online Coding and Unit Test   0%
               Batch Coding and Unit Test   0%
Non-OIT units to migrate their systemsTue 5/1/12Sun 12/1/13 35%
   Bookstore Recharges (Book, TOES)Fri 5/18/12Fri 5/18/12 67%
      AD Document in KFSFri 5/18/12Fri 5/18/12maria100%
       IB Document in KFSFri 5/18/12Fri 5/18/12maria100%
      Acceptance testing & sign-off by Accounting  Caryn0%
   Biological Sciences (Feeder)Mon 4/1/13Tue 4/30/13 50%
      IB Document in KFSMon 4/1/13Mon 4/1/13 100%
      Acceptance testing & sign-off by Accounting  isabelle,victor0%
   EH&S (Feeder)Mon 4/1/13Tue 4/30/13 50%
      IB Document in KFSMon 4/1/13Mon 4/1/13maria,modesto100%
      Acceptance testing & sign-off by AccountingMon 4/1/13Mon 4/1/13Caryn0%
   Physical Sciences (Feeder)Mon 4/1/13Tue 4/30/13tory graziano0%
      Acceptance testing & sign-off by Accounting  Caryn0%
   SRDV (Online Reports - SM)Fri 5/18/12Fri 5/18/12 0%
   UPS (University Physicians & Surgeons)Fri 5/18/12Fri 5/18/12Cyndy25%
      DV UploadFri 5/18/12 Cyndy50%
      Acceptance testing & sign-off by Accounting  Caryn0%
   L (Learning and Academic Resource Center) SBS FeedsTue 5/1/12Sat 12/1/12i-rong0%
   LibraryTue 5/1/12Sat 12/1/12beth wootten8%
      PDP UploadTue 5/1/12 archana chaudri15%
      Acceptance testing & sign-off by AccountingTue 5/1/12 beth wootten0%
   SOM Decision SupportTue 5/1/12Sat 12/1/12jason0%
   UCIMC (Feeder)Tue 5/1/12Sat 12/1/12keiko,jason22%
   UCIMC FacilitiesTue 5/1/12Sat 12/1/12joseph fleming0%
   UNEX applicationsTue 5/1/12Sat 12/1/12 13%
      Summer Session (Feeder)Tue 5/1/12 tom20%
      Extension (Feeder)Wed 5/2/12 tom20%
      Acceptance testing & sign-off by Accounting  isabelle,victor0%
   Pharm Sci Tracking SystemTue 5/1/12Sun 12/1/13amy ruth,jason lin100%