7/14 - 7/27
ETL:
KFS_D_CG_AWD: kfsdw-1656
Completed coding, unit test for multiple directors group. Unit test passed.
Completed coding, unit test for CG_ORG_GRP_SID. Unit test failed due to incorrect type as bigint for strings in the table and requirement. Waiting to get fixed in order to re unit test to complete this jira.
KFS_D_CG_AGNCY: kfsdw-1669
Completed coding, unit test most of the columns. Test passed. There are two columns that need requirement (currently source tables, fields are "dummy"). Waiting for their requirements in order to complete. I emailed to appropriate team members to address this missing requirement.
Bridge tables (KFS_CG_ORG_GRP,KFS_CG_ORG_GRPMBR, KFS_D_CGAWD_BDGTPER)
I was told that our completed bridge tables for other projects, they don't have insert, update transformations, insert and update dates. I noticed that these bridge tables that were created, have all these dates. Please confirm if they need them or need to be removed from the table.
Misc.:
Attended 1-on-1 weekly status meeting
Attended KFS Upgrade for Decision Support meeting
Attended Weekly KFS Decision Support Meeting
Attended Weekly KFS Decision Support Technical Status
Next plan:
Continue with the Award task
KFS upgrade related activities
Informatica admin related activities
7/3 - 7/13
ETL:
Worked with Kevin, Pramod to clarify requirements below:
Order rows 132 for CG_ORG_GRP_SID using source field FIN_COA_CD, ORG_CD:
Select all rows from CG_AWD_ORG_T where CGPRPSL_NBR = CG_AWD_T.CGPRPSL_NBR Order by CGAWD_PRIM_ORG_IND descending, FIN_COA_CD ascending, ORG_CD ascending.
This should put the primary ORG first in the list. String together all of the FIN_COA_CD and ORG CD pairs or each returned row into a single string with each pair separated by a "~".
For example UC1632~UC1700~UC9000. Use the resulting value to look for a row in KFS_CG_ORG_GRP where the string value = CG_ORG_GRP_KEY. If a row is found, set the target column = KFS_CG_ORG_GRP.CG_ORG_GRP_SID.
If no row is found, create the new row in KFS_CG_ORG_GRP and use the sid of the new row in the target column. Please review the mapping instructions for KFS_CG_ORG_GRP and KFS_CG_ORG_GRPMBR when creating a new row.
Order rows order row 113 - 128:
Select PERSON_UNVL_ID from CG_AWD_PRJDIR_T where CGPRPSL_NBR = CG_AWD_T.CGPRPSL_NBR and CGAWD_PRMPRJDIR_IND = N and ROW_ACTIV_IND = Y. Order by PERSON_UNVL_ID. There may be 0 or many. Use the first 4 rows selected to fill in PRJDIR2, PRJDIR3, PRJDIR4, PRJDIR5 columns.
Completed additional columns for the KFS_D_CG_AWD table including the PRJDIR1_UNVL_ID, PRJDIR1_NM, PRJDIR1_TTL, PRJDIR1_PRMY_IND columns. Total 109 columns out of 132. 23 columns left to be completed. These require denormalize and possible Java transfomration. This session has been scheduled to run nightly on dev without issue. While completing the last part of this table, I already started ETL for the KFS_D_CG_AGNCY.
Misc.:
Attended 1-on-1 weekly status meeting
Attended KFS upgrade and Award dimension meeting
Attended KFS Upgrade for Decision Support meeting
Attended Weekly KFS Decision Support Meeting
Attended Weekly KFS Decision Support Technical Status
Attended KFS knowledge Transfer Document conducted by Pramod
Next plan:
Continue with the Award task
KFS upgrade related activities
Informatica admin related activities
...
Closed the following jiras:
Jira Legacy server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1550
Jira Legacy server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1549
Jira Legacy server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1579
UAT:
Test failed, reported to Analytix to fix the following jiras:
...
Continue
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
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:
(KFS_F_TEM_ACCTNG)Jira Legacy server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1443
(KFS_F_DSBRMNT_VCHR)Jira Legacy server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1436
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:
Jira Legacy server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1550
Jira Legacy server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1549
Jira Legacy server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1579
UATs
Continue with this activities.