LamTran_2017_02

01 Feb 2017 -  28 Feb 2017

• BI/DWH
  • ON HOLD Develop Informatica ETL for downloading ZotMail data from UCPath
  • IN PROGRESS BLISS project
    • Reviewing the source code
• KVO
  • On-going support
• ZotMail
  • On-going support
  • ON HOLDUCPath - Download Employee data using ESBAT from UCPath (will resume on 03/01/2017 when UCPath has testing data)
    
    • Modified Download job to download getIdentity and getJobInfo from ESBAT (waiting for real data in testing env.)
    • Developed a method to handle returned data in XML and JSON format - completed implementation.  Waiting for testing data.
  • IN PROGRESS New lists request from Ramona Agrela - Associate Chancellor and Chief Human Resources Executive
    • Break-down 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)

• eDocs
  • ON HOLD UCPath ESBAT (will resume on 03/01/2017 when UCPath has testing data)
    
    • Modified ExFiles lookup web control for using data on-demand
      • Completed implementation.  Waiting for testing data.
    • Modified eDocs scanning download query
      • Completed implementation.  Waiting for testing data.
  •  FileNet Migration
    • IN PROGRESS ENTIS- imported 20 documents to FileNet Production
      • Migration script needs to create Tif image files and SABE server is out space.
    • IN PROGRESS ORTIS- Revisied migration script 
      • Imported 2 sample documents to FileNet Dev
    • IN PROGRESS - UROIS - Revisied migration script
      • Imported sample documents to FileNet Dev
    • COMPLETED Revisied Tax Form Generator - Uploaded W2/1099 forms to FileNet
      • Implementation (completed)
        • Additional changes:
          
          1. Check for duplication using Document Title, Document Date, and Document Type
          2. Assign Document Date value to “12/31/[YYYY] (selected year from drop down list)
          3. Replace the year part of document filing path in security file with selected year from drop down list
      • Set up an sFTP server on 236.19 for testing (completed)
      • Deployed to production (completed)
        
        • Compiled new code for 64-bit version
      • Issue: discrepancy in printed W2 count and FileNet account.
        • Printed: 8,070; FileNet: 8,069
        • Some foreign W2 data had names shifted from BoxE_2 to BoxE_1
        • Revised the logic on getting employee names.
        • Need to update employee names on some of the W2s that had invalid name in FileNet.
  • IN PROGRESS KFS viewer - Revise viewer to handle PDF, JPEG, and TIF format
    • Implementation (completed)
    • Deployed to edocstest server (completed)
    • Testing from KFS and QA team is in progress
      
      
• Upcoming tasks:
  • eDocs - ORTIS FileNet Import service