LamTran_2017_08

01 Jun 2017 -  30 Jun 2017

• BI/DWH
  • IN PROGRESS BLISS project
    • Reviewing the source code
      
      
• KVO
  • On-going support
  • COMPLETED Update Glacier email verbiage ( KFS-130 - Getting issue details... STATUS )
  • COMPLETED Installed and configured Visual Studio 2017 for KVO and ZotMail.
    
    
• ZotMail
  • On-going support
  • IN PROGRESSUCPath - Download Employee data using ESBAT from UCPath (will resume on 06/01/2017 when UCPath has testing data)
    
    • getIdentiy (returned data are bigger than the DB column length)
      • Download - completed
      • Created SP for insert/update/delete to uci_employee - completed
      • Test - completed
    • getJobInfo (returned data are bigger than the DB column length)
      • Download - completed
      • Created SP for insert/update/delete to uci_employee_appointment - completed
      • Test - completed
    • Developed a method to handle returned data in XML and JSON format - completed implementation.  Waiting for testing data. - completed.
  • IN PROGRESS New lists request from Ramona Agrela - Associate Chancellor and Chief Human Resources Executive
    • List#1047 All General Campus Staff (exclude HS and UCIMC)
    • List#1048 All Campus Supervisors
    • Sub-lists of All Campus staff and Campus Supervisors by Org code
      

      • Execute Management (5000)

      • Academic Affairs (1000)

      • Student Affairs (7000)

      • Advancement/Development (6000)

      • Administrative and Business Services (3000)

      • Control: Accounting (9070), Finance (9060), Financial Aid and Scholarships (9040), Office of Graduate Studies (9050), and Planning (9030)

    • Deployed to testing server
      
      
• eDocs
  • Assisted Robert with switching to KFS Viewer FileNet account.
  • Assisted Robert with migrating eDocs source from TFS to GitHub.oit.uci.edu