Page Comparison

Anh’s Status 3/Anh’s Status 3/25/2016 - 4/8/2016

•  Completed enhancing the fund name for the scenario where there’s no fund name in the source, make them N/A (fund_code) so that they can be unique.  
           The purpose is that when users report by name only, they don’t roll up.   The code changes were rolled out to production last night.  Durendal and I verified data.
•  Prepare ODS to roll out to production:  Completed verifying all ODS tables ODS jobs.  They’re ready to roll out to production as soon as cognos report developers confirm that they don’t break their reports.
•  SBS task:

Mappings of ods_sbs.agingreportcon_kfs, agingreport_det_kfs all have string type for all columns including date, amount.  These tables have accumulative records.  I’m in the process of fixing these mappings, export data, create new tables in DB to correct type  then import data from current tables (containing wrong types) to the new tables (with correct types).

• Month-end Outbound task:  The SMS Feed jobs loaded fine last night after they saw Jarrod’s triggers.  I verified data. 
•  Analytix task:  on-going with the user acceptance tests.
•  Supervised Bryce on connections with DBs per his request.

Anh’s Status 3/2/2016 - 3/24/2016

Completed adding new columns KFS_ORG_COA_CD, KFS_ORG_CD to ods_kfs.UC_ACCOUNT_T, modifing UC_ACCOUNT_T ETL.  

...

  Supervised Bryce. 

Anh’s Status 2/18/2016 - 3/3/2016

Resolved INC0071250, INC0067892

...

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

...