07-01-2015 - 07-15-2015
DWH:
In Progress: Incident#0031497: problem from SOM-Joe
In Progress: Incident#0029563
In progress: testing new server for JasperETL- sd-dwhetl01.serverad.adcom.uci.edu- test one job it looks for Sybase jdbc-dwh_fs/ods,
try 2nd job pps home department it did not like one field and correct it to null but still error out. Other jobs for dwhs_ppscurr works.
Completed: request from Robert to update department codes for some fund codes.
In Progress: sending missing FS department codes from account and fund.
On Call from 07/04-07/10
DWH-PPS:
Completed: Incident#0031496: EX cycle have empty files, request to OP and load to DWH
In Progress: documenting DWH-PPS trouble shooting
In Progress: Preparing New Fiscal year
In Progress: Downloading PAR &HDB data for June after July 1.
LDAP:
LDAP deploy and node3dev did not run - rerun on node3dev: done
PPS:
Completed: question which database to used for compute this fiscal year.
UCPath:
Kuali:
In progress: question for PPS work study flow
Training:
None
06-16-2015 - 06-30-2015
DWH:
Completed: JIRA#1629-Orbit to sd-orbit-db
Completed: JIRA#1636 - Prod turn over for sd-orbit-db - modify property file on 06/29.
In progress: JIRA#1642-add temp_kfs_fund_oper
In Progress: populating uc_account_t with 2 new cols using Informatica -testing
In Progress: populating temp_kfs_account_oper, run manually and create job to check missing department codes
In progress: sending missing FS dept codes to Accounting
Completed: Darla request list
Completed: Incident#0030279-adding FS dept code for PCS
Closed: Incident#0026159: Linkserver for MySQL people_m database not necessary for analytics.
In Progress: PCS could not be created for fund: 78701
In Progress: Incident#0029563- Adding testid's for Facility from test0401-0430 - reply to Tom to used other userid
Completed: Vacation: 06/22-06/28
DWH-PPS:
In progress: check pps_expearn job not sending email
LDAP:
In progress: create summary of ldap_people table in sd-lunar.dss_kfs
NSP-qidata missing 9 employees-send to NSP error list.
PPS:
In progress: Incident#0029163-UCOP PPS screen error - add David to ticket
UCPath:
Kuali:
Training:
Continue: Informatica part 2
06-01-2015-06-15-2015
DWH:
Completed: JIRA#1628-SOM separation list from 2005-April 2015
Completed: JIRA#1630-Zenith to sd_zenith_db.oit.uci.edu
Completed: USGHelp#1901-dwhm_par and dwhm_hdb are uptodate at m3k2 till 2014.
Completed: Update fs_fund_oper request from Robert
In progress: JIRA#1629-Orbit to sd-orbit-db.oit.uci.edu
In progress: Jira#1636-Orbit changed in production
DWH-PPS:
Completed: fixed mssql_expearn for sd-nebula
Completed: download PAR &HDB for May, 2015
In Progress: deploy not sending email for pps_expearn job
LDAP:
Completed: adding 2 employee's missing from history, 1 was from 1997
PPS:
DWH-UCPATH:
Completed: List per-request UCPath-HR communication for PPS users-Inc#0024888.
DWH-KUALI:
TRAINING:
05-16-2015 - 06-01-2015
DWH:
Completed: patch fs_fund_oper (2 times) for PCS request.
Completed: Incident#0024458
In Progress: Incident#0024724
Completed Pager week: 04/15-04/22/2015
In Progress: Pager week: 05/29-06/04/2015
In Progress: JIRA DWH#1628, DWH#1629, DWH#1630
DWH-PPS:
Completed: loading PAR data for 2013 & 2014 at m3k0
Completed: loading HDB data for 2013 & 2014 at m3k0
In Progress: USGHelp#1901 to copy to m3k2 from m3k0 dwhm_par and dwhm_hdb.
LDAP:
In progress: new table ldap_people missing KFS Org level4 and name columns, missing test id's
PPS:
Completed: question from David for PPS Home department and control points
DWH-UCPATH:
In Progress: Incident Ticket#0024888-UCOP PPS user id extract from SAMS
Completed: question for survey from Academic Senate
DWH-KUALI:
In Progress: JIRA KFSDW#718: adding columns to kfs_account_oper. Due to uc_account_t missing 2 columns for MySQL, it is in nova to test it.
Send to Victor C., KFS org codes without department codes.
Training:
Completed: AB1825 -2 hours
Completed: REXX overview for window and mainframe
In progress: Informatica part 2
05-01-2015 - 05-15-2015
DWH:
Completed: JIRA#1597: user decided to used save query that I created instead domain query.
Completed: Send FY1415 expense for dept 4500 to user
Completed: Send FY1415 expense for dept 1500 to user
Completed: testing m3k2 after patch-05/02
Completed: Incident #0023904-download data for Darla, 2012-2015. Don't know how to give her access to DWH-PPS central office for history data-??
Mark Completed: Incident#0023190 by Database team, no need to update mssql driver and url at Connection manager java
DWH-PPS:
In Progress: loading dwhm_par for 2014 data at m3k0
LDAP:
Review new LDAP table from Adam at sd-nebula-??
PPS:
David request to review spreadsheets of PPS jobs upload and download data files
David request to help UCIMC decision support for DOS code pay category
Help Desk: PAN user
DWH-UCPATH:
None
DWH-KUALI:
None
04-15-2015 - 05-01-2015
DWH:
In progress: INC#0022710-wrong KFS Org for account:486796
Completed: JIRA 1597 to add sbs/aging report, sams, ods
Completed: Incident tickets: #0021885, #0021880
Completed: add some accounts to kfs/fs_account_oper - perDarla email
Reopen: Incident ticket: #19735-slow query for user expense earnings
Completed: JIRA#1619-jobs to convert nova to sd-nova
Completed: JIRA#1622-move to production for sd-nova
In Progress: JIRA#1567-revising Library queries and download to files
Completed: INC#0022236-Update fs_fund_oper department code and pi name for PCS
Completed: Correcting over 500 rows of wrong FS department codes for fs_fund_oper table
Completed: Darla requested download from 2013/14/15
Completed: Pager week-4/24 to 5/1
DWH-PPS:
Completed: Correction for KFS account with unknown for FY1415 expense earning. Some will still have 'Unknown' KFS account since it is not in any of the KFS tables. This correction based on Victor spreadsheet.
Question: from Lam-employee not in PPS-it is NSP need to merge
Webpan: have a long query -per Brian
Continue: Load/download PAR&HDB
LDAP:
Completed: employee id duplicate
PPS:
Support: David question to remove file at the mainframe.
Meeting: Keiko work study review for KUALI &UCPath.
Support: Help desk for PAN reviewer user not in the pan notices
Support: Download new files for Guna that did not get into MC.
Support: notify Payroll for duplicate employee id to be deleted
Check PPS jobs on 4/17 & 4/20 -David's out
DWH-UCPATH:
Join thru ready talk - 4/23-BICG
DWH_Kuali:
Completed: to add more to kfs_account_oper or fs_account oper with correct department codes
Completed: to add more to fs_hierarchy_latestmonth for accounts submitted by Victor.
Questions: from Modesto related to PPS tables-object codes
03-31-2015 - 04-15-2015
DWH:
Completed: Request by Darla for 2012/2013/2014: OIT employee list actions
Completed: JIRA DWH-1514-JIRA 1612: getHealthSciBenPayroll query to production and re-open to correct one user.
Completed: Fixed kfs_fund_oper to update fund code 19900, 19933 and 19934 to location code = '9' since KFS used 'R'
Completed: Fixed fs_hierarchy_latestmonth_1314 and 1415 to add 189 new accounts that was given by accounting and fixed invalid department codes
Completed: Fixed fs_fund_1415 with invalid department codes
Completed: JIRA 1597
Completed: JIRA 1598
Completed: back fill department codes for pps_expearn_1415 & pps_expearn_1415_kfs tables
Closed Incident ticket: 19656, 19957, since user can access DWH, and employee with truncate address is fixed.
Completed: on call: 04/03-04/10- Incident ticket#020806, ticket#021107
In Progress: JIRA 1618-for nova to sd-nova connection testing and stunnel configuration
DWH-PPS:
Completed: WebPan merge tables and starting new Jan 1,2015 data, and installing jobs
Issue with no page archive page display, only time to time with IE, using Fire Fox is fine.
Continue: PAR&HDB extract from UCOP
LDAP:
Completed: create new ldap table to populate at sd-nebula (from Adam)
Completed: JIRA-KFSI11950-missing employee
PPS:
Attended legacy system team meeting: 04/06
Paul's question to clean up other PPS files in Zeus
David's question for PPS checks printed to Piracle from ACOM
David's configuration of SQuirrel to UCOP-DB2 is finally resolved.
David's question for UCIMC-GL/KFS missing funds - RITM#0062781
DWH-UCPATH:
Reply to Jip's questions
Ying's request to get SQuirrel to work on DB2
DWH-Kuali:
In Progress: to create new job to populate fs_account_oper
03-10-2015 - 03-30-2015
DWH:
Completed: JIRA DWH-1594:Fixing getHealthSciPayroll for February, need to rebuild Employee.java domain
Completed: JIRA DWH-1600: to fixed Robert PCS pi name
Continue: Fixing FS&ODS tables for new account, fund, department codes
Continue: JIRA DWH-1567- Ask user to review results and wait for their response
Continue: JIRA DWH-1514-getHealthSciBenPayroll in review
In Progress: adding FS/ODS monthly jobs
In Progress: JIRA DWH-1597
In Progress: JIRA DWH-1598
Continue: PPS update expense earning FY1415 to update KFS Account, department codes and blank home department codes
Completed: PCS-missing employee id's due to blank home department code and department codes
Completed: PPS update expense earning for February, when department code is blank
In Progress: ticket#99560-DWH-stalling from ICS when running yearly expense
In Progress; ticket:#19656, #19957
Continue: Informatica on demand session and lab courses
Completed: On Call: 03/06 - 03/13- with 2 night of Talend jobs problems and sql server deadlock
In Progress: Checking which jobs for DWH-PPS/LDAP/USER MGMT can be run parallel
DWH-PPS:
Continue: Web Pan tables to be merge with prior years
Continue: Monitor of Web PAN Archive selections
Continue: Archive PAR&HDB loading for 2014
LDAP:
Continue: reruns due to qidata late arrivals
Completed: Ticket Issue#450: Jira-KFS11595:Adding missing campus id's for ldap history
PPS:
In Progress: Incident RITM#0061284:
Grace: I’m trying to find a copybook for our payroll checks we print. Joe Brennan said I should be able to use the working storage definition for CHECK-LAYOUT found in program PPP420. Do you have a copybook for mapping the check fields?
In Progress:
There is some weird file PP9.CKOVRID that is used to hold the check overrides. How is that used? Does the campus send into that file, or request updates for it, or ???
The other campuses send into &PREFIX..PPP420.&PAYTYPE..USR. I am going to be permanently reading that file and clearing it out at the end of the check write proc (PP9CHKS), but that won’t do any good if this additional file has data, and I don’t want to allocate the weird file name in the proc.
Completed: Submit home department control table
Completed: revoke DB2 access at UCOP
Completed: returning PPS access at UCOP
Completed: request to delete duplicate employee id's
Completed: Paul's request to delete tapes with PRS* files
Completed: Check AJS and Zeke -03/30 (David is on vacation)
Spend Analytics:
In progress: Cleaning up tables in dwhm_pal and dwhm_fs
DWH-UCPath:
Completed: Jip's questions
DWH-Kuali:
In Progress: FYE-per Modesto question for PPS month 13
02-23-2015 - 03-09-2015
DWH:
Done: Modify for kfs_fund_oper table beginning dates to follow KFS award tables-per Tammy&Robert
Done: request from Business Office to run OIT employees for 2014-2015
Continue: Fixing FS & ODS tables for new accounts, funds, department codes
Continue: PPS-expense transfer assigning department codes when it is blank and updating some KFS fields
Completed: HS request to run from October-December 2014
In Progress: JIRA 1567: For Library, send sql result for their review and finished build.
Completed: Jira-DWH-1590 to add 2 consultant to employee basic.
Continue: Informatica on demand session and lab courses.
DWH-PPS:
Continue: Web Pan jobs and tables for 2015
Continue: investigating why the Pan Archive screen did not show selection
Continue: Download data for February month end history PAR&HDB
Continue: To upload history data for 2014 to m3k0
LDAP:
Continue: support to check qidata file time run-not run 03/04
Completed: Jira-KFS-11595
Completed: 2 employee's rejected from NSP-due to duplicate and re-used employee id.
Completed: add guest consultant to active employee
PPS:
Duplicate employee id's and wrong new employee ids assignments, submit to Payroll office
Automatic Job scheduler at UCOP starting March 2
Spend Analytics:
Completed: Send new upload files for final.
DWH-Kuali:
N/A
DWH-UCPath:
Question for current deductions flow from Jip.
02-06-2015 - 02-20-2015
DWH:
Fixing FS oper's tables, to be updated by spreadsheet from Accounting after KFS live.
Update table pps expense earning with blank department codes
HS-request to rerun queries from July-in progress
University Hills-completed- JIRA 1570:closed
Query getAPMyDataSymplectic - JIRA 1486: completed
In Progress - JIRA 1567:queries for Library-could not build security role module.
Problem with query - getHealthSciPayroll not picking up some employees - Ticket #99490
Working on the download request from July,2014 by Joe, to correct blank department code
Request data for employees by OIT-business office
Informatica video and lab session
DWH-PPS:
Build for histories PAR&HDB and get the January data.
In progress: Web Pan 2015 jobs, tables.
LDAP:
Jira KFS-11649&other missing employee id's at ldap history
PPS:
No activity
Spend Analytics:
Modified scripts, and rerun all files PO&AP&AP-Pcard
DWH-Kuali
No activity
DWH-UCPATH:
question for employee hierarchy sources
question from for GAEL-object code for budget office.
01-26-2015 - 02-06-2015
DWH:
University Hills request to run housing ireport - open Jira1570
Jira#1486, user want to move to production-getAPMyDataSymplectic .
Help continue for user from Univ Advancement and set up meeting to meet other people from their department on Feb 2.
Build for getHealthSciBenPayroll successfully after Val help to search which jar library was missing. Pass it to test to Joe's group.
Both development and staging is ready for their testing.
Testing queries during production turnover switching to ddmtech.
DWH-PPS:
Build for histories PAR&HDB and get the December data download
LDAP;
ldap_people_his problem due to blank 'sn' and 'cn'-patch script-open footprint ticket#99455
LDAP run late for 2 days-foot print ticket#99463
Still checking and updating or inserting to people history tables during late runs of LDAP
PPS:
Faye request a list of employees of 2014 with medicare > 200K
Request Title code job to be scheduled, check zeke, check jobs, since David took a sick day on 01/29/2015
Submit home department update since David has problem with his PC-02/02/2015
User with work study PAN notices problem, supporting David questions.
Supporting help desk, related to PPS screens and access
Mainframe technical meeting & Legacy support meeting.
UCOP-PPS Automatic Job scheduler: need to try it in production.
Spend Analytics:
Rerun AP and creating AP-PCARD 2012-2013-2014. Problem with empty account codes, due to no ledger detail us-bank entry.
Recreate and modify codes for PO and AP per-testing result. AP-Pcard, Val help to modify the tables to be selected.
In testing mode for 2 days
DWH-Kuali:
No activity
DWH-UCPath:
Try out login to UCOP and configuring DB2-Spufi-Finally successful
Trying to configure squirrel for DB2.
Continue search for Work study and EPL/GAEL for Keiko questions
01-13-2015 - 01-23-2015
DWH:
User from Univ Advancement help for Contract Grants query.
Finishing to build getHealthSciBenefit query requested by Joe.
DWH-PPS:
Create and load 4 temp tables for 2014 to support HR request and Payroll Request.
Updating Java programs for history tables-November and December, 2014, and running the get the data.
Still investigating if special cycle from Jan 8/9 is in DWH-PAR tables-open JIRA-1560
Solving JIRA issues
LDAP:
Insert history tables, for missing employees by Warren and David.
Modify ldap_people in development for test userid's with KFS org/chart values for 5 id's, later all test user id's request by Josh.
Modify campus address table and the job to increase to 40 characters both in development and production.
PPS:
Answered David Carleton request for range adjustment error and exception questions
Research a user that need access for PAN work study
Need to download data from UCOP for development December PAR
Payroll support-W2-health insurance check.
Payroll support for FICA modify by a employee.
UCOP-PPS: Automatic Job Scheduler testing to production
Join mainframe meeting
Spend Analytics-2:
PO-2012/2013/2014 data downloads-continue
AP - AP-Pcard-2012-2013-2014 data downloads -continue
DWH-Kuali:
Run test for PCS implementation-kfs_fund_oper table
DWH-UCPath:
Collecting SQL's that was build to check data.
Ying request me to email to UCOP my UCOP-PPS login id and what tool to used to query DB2.
Work Study - for Keiko write up