Page Comparison

Anh's Status 10/21 - 11/3

ETL

https://jira.oit.uci.edu/browse/KFSDW-1290:  Completed loading new rafg data for October per user’s request https://jira.oit.uci.edu/browse/KFSDW-1290

INC0125556, INC0126590, https://jira.oit.uci.edu/browse/KFSDW-1532 (Need to enhance the SBS Aging task to avoid duplicate records):  Completed the development of this task.  The final testing phase is in progress.

UATs:

1. Disbursement

1361 (KFS_F_DSBRMNT_ITM) Encountered problem.  Waiting for Analytix to fix

1362 (KFS_F_DSBRMNT_ITM_ACCTNG) Encountered problem.  Waiting for Analytix to fix

2. TEM

1444 (KFS_D_TEM_EXPENSE) Encountered problem.  Waiting for Analytix to fix

1446 (KFS_D_TEM_PERDIEM) Encountered problem.  Waiting for Analytix to fix

1449 (KFS_D_SPCL_CRCMSTNCS) Encountered problem.  Waiting for Analytix to fi

Next plan:

ETL

• Complete and migrate to production https://jira.oit.uci.edu/browse/KFSDW-1532 (Need to enhance the SBS Aging task to avoid duplicate records)
• https://jira.oit.uci.edu/browse/KFSDW-1537 (Load CG_AGENCY_ADDR_T to dwhs_ods db on nebula/nova once the table is installed in KFS)
  work on this as soon as CG_AGENCY_ADDR_T is in KFS per jira https://jira.oit.uci.edu/browse/KFSI-13803.
• https://jira.oit.uci.edu/projects/KFSDW/issues/KFSDW-1496 (Modify Balance ETL for all ITD balances to remove SFG 2xxxxx)

UATs

     Continue with TEM as soon as receiving Analytix's fixes

Anh’s Status 9/23/2016 - 10/20/2016 (took vacation 9/28 - 10/11)

...

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

...