Page Comparison

8/25 - 9/7 (campus closed on Labor Day on the 4th)

ETL:

Fixed CGAWD_ENTRY_DT.  This data is now available.

Fixed ETL for ucinetids.  This data is now available.  Regarding the multiple project director ucinetids, Kevin said that he'll get back to me on my questions to confirm on requirements for getting this data.   

Misc.:

Worked with Kevin from the Accounting on multiple project director ucinetids issues found in the ward task.

Worked with Eufemia from the Cognos team to finalize additional requirement for KBM.

Attended Weekly KFS Decision Support Meeting

Next plan:

Continue with the Award task

KFS upgrade related activities

Informatica admin related activities

8/11 - 8/24 

ETL:

Met with Kevin to gather detail information/logic on the remaining requirement: To create CG_ORG_GRP_KEY and CG_ORG_GRP_SID: Concat string using criteria of FIN_COA_CD,ORG_CD,CGPRPSL_NBR, CGAWD_PRM_ORG_IND from the CG_AWD_ORG_T  table in the CG_ORG_GRP table.  Then in the KFS_D_CG_AWD table, create the key using the same criteria to create a key, then use this key to look up in the CG_ORG_GRP table to get the value of the CG_ORG_GRP_SID (integer). 

...

Closed the following jiras:  

UAT:

Test failed, reported to Analytix to fix the following jiras:

...

Continue

  UATs

     Continue with this activity.

1/3 - 1/12

ETL

     Completed, verified SBS, Outbound month-end.

     Completed https://jira.oit.uci.edu/projects/KFSDW/issues/KFSDW-1496  (Modify Balance ETL for all ITD balances to remove SFG 2xxxxx).  Unit test is in progress.

UATs:

     Following jiras are completed, ready for deploy:

Training

...

     Complete testing to be ready for deploy https://jira.oit.uci.edu/projects/KFSDW/issues/KFSDW-1496 (Modify Balance ETL for all ITD balances to remove SFG 2xxxxx). 

     As soon as migration completes on the production informatica server and to prepare for the next month-end, I need to work with Jarrod to verify, test the following jiras to ensure that his aps send triggers to the appropriate locations:

  UATs

     Continue with this activities.