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:

(3) Discussion and analysis on Conformed Award dimension

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

2016 February

JIRA	Summary	JIRA type	Status
453	Add column to balance fact table for Beginning Current Budget Amount	New feature	Deployed to production
699	Create a PL/SQL table	Sub Task	Deployed to production
856	Add ICR Rate to the Account Dimension	New feature	Deployed to production
857	Add MD balances to KFS_F_GL_BALANCE table	New feature	Deployed to production
890	Modify ITD Balances to include FIN_BEG_BAL_LN_AMT in calculation	Bug	Deployed to production
927	Add 2 columns GL_ACTUALS_YTD_AMT_ADJ and GL_ACTUALS_AMT_ADJ in KFS-F_GL_BALANCE	Task	Deployed to production
825	Modify 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'	Bug	Deployed to production
980	Modify logic for GL_INCOME_YTD_AMT and GL_INCOME_AMT calculation on KFS_F_GL_BALANCE table	Bug	Deployed to production
1004	Add new column for MD balance type in GL entry fact, modify ETL	Improvement	Deployed to production
1014	GL Base Budget Amount showing zero values	Bug	Deployed to production

Browser not supported