Page Comparison

Anh’s Status 8/15/2016 - 8/26/2016

Labor Ledger model task

https://services.adcom.uci.edu/jira/browse/KFSDW-1460: Done adding additional requirement to KBM.  It’s now ready for test.

Post ODS migration activities: 

 ods_kfs.TEM_TRVL_EXP_T:   Missing CREATED_EW_DTTM for insert date.  Fixed mapping in both dev, prod.  Users confirmed.

AR Reconciliation Balance Tables:

 Fixed in mapping and DB backend to add 2 decimal  points to all amount colums  to load data to [ods_kfs].[UCI_AR_RECON_BAL_DETAIL_T], UCI_AR_RECON_BAL_SUMMARY_T per jira  https://services.adcom.uci.edu/jira/browse/KFSDW-1253.  This jira is ready for test.

Updated:  Users confirmed that data looks good on dev, requested to deploy to production.  On production ran DDLs to drop, then to create these tables to have precision of 2 for all amount columns.  Trial ran wklt_UCI_AR on production before nighttime load without issue.  This task is ready for nightly load.

DW annual passwords needing change

Completed on production for dssreader, dwhreader, ppsreader: Completed.   To prepare for the last group (…oper) needing pw change on 9/16, per Thomas Bindewald’s request, I send him our annual DW passwords needing change kiwi page that shows all the login IDs so he could start request for access the production Unix servers.

UATs:

Found issues during user acceptance testing for Analytix ETLjiras below:

https://services.adcom.uci.edu/jira/browse/KFSDW-1415

Error when running the workflow: "Invalid object name '."  Informed Analytix to fix.

Requested Analytix to fix the invalid KFS_D_CRDT_MEMO_DOC object error found during UAT.

https://services.adcom.uci.edu/jira/browse/KFSDW-1416

Requested Analytix to fix the invalid 'KFS_D_CRDT_MEMO_IT object error found during UAT.

Requested Analytix to provide missing their unit test scripts for jiras below:

https://services.adcom.uci.edu/jira/browse/KFSDW-1417

https://services.adcom.uci.edu/jira/browse/KFSDW-1418

UATs for PO ETL completed for jiras below:

https://services.adcom.uci.edu/jira/browse/KFSDW-1258

https://services.adcom.uci.edu/jira/browse/KFSDW-1259

https://services.adcom.uci.edu/jira/browse/KFSDW-1261

https://services.adcom.uci.edu/jira/browse/KFSDW-1262

https://services.adcom.uci.edu/jira/browse/KFSDW-1263

https://services.adcom.uci.edu/jira/browse/KFSDW-1264

https://services.adcom.uci.edu/jira/browse/KFSDW-1265

https://services.adcom.uci.edu/jira/browse/KFSDW-1266

https://services.adcom.uci.edu/jira/browse/KFSDW-1267

https://services.adcom.uci.edu/jira/browse/KFSDW-1268

https://services.adcom.uci.edu/jira/browse/KFSDW-1269

https://services.adcom.uci.edu/jira/browse/KFSDW-1270

The above jiras are now ready for deploy. 

Anh’s Status 7/29/2016 - 8/12/2016

...

1) Completed fixing staging krns job

2) Pager duty this week. 

3)  Completed

     Completed setting up to schedule this job to run nightly.

4)  Emailed ddls scripts to Analytix per their request to create tables below:

...

6)  Need to schedule syncInvoiceNumberSundryDebtors to run on production

Anh’s Status 3/28/2015 – 4/10/2015

...

1)  Fixed uciSmsGIFeed.  ods_kfs.UCI_SMS_FEED_DETAIL_T table now has all records for Feb. data with batch date ’06-MAR-15’, matching Oracle side:  31,647 records, debit amount total is $3,647,165,482.52. 

...

5)  Analytix:  Provided our versions of our DBs that they asked.  They confirmed access to talenddev server.  Attended weekly status meeting this Friday morning.  They're going to send me a list of sqlsver tables so I can send them DDLs to them to create these tables.

6)  uciSmsGIFeed:  The job loaded month-end data this month without problem.  FYI -  Following day, this was the 2nd time this month that Jarrod reran, regenerated the trigger.  The job ran fine 2nd time. 

7)  Completed

• Not complete yet section: 

  1)  Staging krns job loaded all tables but Talend sent false notification.  I need to debug this job.
  2)  Export all talend jobs on new server
  3)  ACCOUNT_CG_PRPSL_NBR not being populated in dss_kfs.KFS_D_ACCOUNT

...

5)  SBSO: 

6) Pager duty next week. 

Anh’s Status 3/16/2015 – 3/27/2015

...