Page Comparison

ETL:

Worked with Janinewith Kevin, Kevin to Pramod to clarify requirements for OTHER_ATTR_NM,PMT_MTHD_DESC,PRJDIR_CNT_NBR.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

ETL:

Worked with Janine, Kevin to clarify requirements for OTHER_ATTR_NM,PMT_MTHD_DESC,PRJDIR_CNT_NBR.

Started mapping the Award dimension table.  Completed 98 columns out of 129132.

Misc.:

Attended 1-on-1 weekly status meeting

Attended KFS upgrade and Award dimension meeting

Attended Award dimension – specs 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 dimension table

KFS upgrade related activities

Informatica admin related activities