07-16-2015 - 07-24-2015

DWH:

In Progress: JIRA#1648: create temp table and check the difference and blank KFS fields.

In Progress: JIRA#1649: Finished writing job mssql for ldap_people_his_new both doing insert and update table.

In Progress: testing Talend jobs from Jasper. For dwhs_pps and dwhs_ppscurr it all works exception home_department and FS&ODS job

In Progress: writing wiki Trouble shooting DWH jobs

DWH-PPS:

In progress: run utility job to create new fiscal year

LDAP:

Completed: missing campus id for Ryan

PPS:

none

UCPath:

Completed: answering question

Kuali:

none

Training:

none

07-01-2015 - 07-15-2015

DWH:

Completed: Incident#0032442 - PCS - missing FS department code

Completed: Incident#0032171 - PCS - missing FS department code

Completed: Incident#0032173 -PCS - missing PI name for chancellor

Completed: Incident#0032178 - PCS - update department code

In progress: Incident#0031496 - Payroll records with no KFS accounts

In Progress: Incident#0031497: problem from getHealthSci & gethealthSciBen queries - java error

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.

In Progress: Incident#0029563 - test user id's for Facility testing- Tom B will ask NSP to release some new test id's.

In Progress: sending missing FS department codes from account and fund.

In Progress: JIRA#1648: testing ldap_people_new in mssql sd-nebula. Create spreadsheet and load to MySQL the missing KFS values.

In Progress: JIRA#1649: create new ldap_people_his one time script in sd-nebula and inserting to the new ldap_people_his table. Question on the update if it need to create a new row daily for the uciCampusID that is matching or just update the rows with the daily information.

In Progress: writing in wiki Trouble shooting DWH-PPS jobs

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

Browser not supported