Page Comparison

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

• Anh's Status

...

• 11/

...

• 4 - 11/

...

• 17

ETL

INC0125556, INC0126590, https://jira.oit.uci.edu/browse/KFSDW-12901532 (Need to enhance the SBS Aging task to avoid duplicate records):  Completed loading new rafg data for October per user’s request .

https://jira.oit.uci.edu/browse/KFSDW-1537 Completed  ETL development. 

UATs: 

1444 (KFS_D_TEM_EXPENSE) Test passed. Ready to deploy

1445 (KFS_D_TEM_DOC) Test passed. Ready to deploy

1446 (KFS_D_TEM_PERDIEM) Test passed.

1447 (KFS_D_EMGCY_CNTCT) Passed test.  Ready to deploy.

1449 (KFS_D_SPCL_CRCMSTNCS) Passed. Ready to deploy

Next plan:

ETL

https://jira.oit.uci.edu/browse/KFSDW-1537 plan to start testing as soon as the Informatica DB connection is provided for kfstst2 where requester placed test data.

UAT

1442 (KFS_F_TEM_EXPENSE) Analytix’s development "In Progress" status. Wait to start testing.

1443 (KFS_F_TEM_ACCTNG) Analytix’s development "In Progress" status. . Wait to start testing.

1448 (KFS_D_EMGCY_CNTCT_BRIDGE). Analytix’s development  "In Progress" status. Wait to start testing.

1450 (KFS_D_SPCL_CRCMSTNCS_BRIDGE) Analytix’s development  "In Progress" status. Wait to start testing.

1451 (KFS_D_TEM_RLTD_DOC_BRIDGE) Analytix’s development  "In Progress" status. Wait to start testing.

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

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.

...

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

...