/
Pramod Kunju Status Reports

Pramod Kunju Status Reports

Owned by vjones (Unlicensed)
Last updated: Apr 18, 2016 by Pramod KunjuVersion comment

2016 March

(1) Worked on the following JIRAs, primarily analysis and design , then hand-over to Analytix for ETL.

(2) Worked on PURAP Data Models and Source to target for:

  • PO
  • PREQ
  • RQSTN
  • Credit Memo
  • Disbursement
  • Disbursement voucher

(3) Discussion and analysis on Conformed Award dimension

(4) Data Modeling, and ETL specs for Pending entries

2016 February

 

JIRASummaryJIRA typeStatus
453Add   column to balance fact table for Beginning Current Budget AmountNew   featureDeployed   to production
699Create   a PL/SQL tableSub   TaskDeployed   to production
856Add   ICR Rate to the Account DimensionNew   featureDeployed   to production
857Add   MD balances to KFS_F_GL_BALANCE tableNew   featureDeployed   to production
890Modify   ITD Balances to include FIN_BEG_BAL_LN_AMT in calculationBugDeployed   to production
927Add   2 columns GL_ACTUALS_YTD_AMT_ADJ and GL_ACTUALS_AMT_ADJ in KFS-F_GL_BALANCETaskDeployed   to production
825Modify   logic for GL_EXPENSE_YTD_AMT calculation on KFS_F_GL_BALANCE table
   
    NEW LOGIC: select <all   months up to current month>+FIN_BEG_BAL_LN_AMT from GL_BALANCE_T where   FIN_BALANCE_TYP_CD = 'AC' and ACCTG_CTGRY_CD = 'EX'
   		BugDeployed   to production
980Modify   logic for GL_INCOME_YTD_AMT and GL_INCOME_AMT calculation on KFS_F_GL_BALANCE   tableBugDeployed   to production
1004Add   new column for MD balance type in GL entry fact, modify ETLImprovementDeployed   to production
1014GL   Base Budget Amount showing zero valuesBugDeployed   to production