02/01 to 02/29/20162016 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
| 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 |