Category Archives: VizTool Priority List

Dong Shin 06.11.2014

  • working on Query Builder
    • adding Lenny’s queries to database
      • Overdue Acceptances
      • Overdue Obligations
      • Under performing obligations
      • FY14 Financial Status
      • FY14 Outlay Plan
      • FY13 Financial Status
      • FY14 current month Planned vs. PM Actuals
      • FY13 TST Financial Status
      • FY14 TST Financial STatus
      • FY14 ISR-PMO Financial Status
      • FY14 Financial Status (duplicate?)

Dong Shin 06.03.2014

  • working on Query Builder (6 hours)
    • cleaned up database views – _view_project_detailed_data
  • working on scripts to add parent project users to children… (2 hours)
    • INSERT INTO _projects_portfolio_mgrs
      (SELECT sub_project_id, login FROM _projects_portfolio_mgrs ppa
      LEFT JOIN _project_sub_projects psp
      ON psp.project_id = ppa.project_id WHERE (sub_project_id, login) NOT IN (SELECT * FROM (_projects_portfolio_mgrs)))
    • INSERT INTO _projects_portfolio_admins
      (SELECT sub_project_id, login FROM _projects_portfolio_admins ppa
      LEFT JOIN _project_sub_projects psp
      ON psp.project_id = ppa.project_id WHERE (sub_project_id, login) NOT IN (SELECT * FROM (_projects_portfolio_admins)))

Dong Shin 05.30.2014

  • working on other stuff (6 hours)
    • trouble shooting incorrect outlay calculation in cognos summary data
      • cannot duplicate outlay problem for Req 198874, need to clear budget_center_contracts entry and run post processing on-site.
    • created project_portfolio_enh_clean for testing
    • trouble shooting obligations stored in a month behind for 206756…. cannot duplicate.. need to look at __view_monthly_obligations_by_contract and __view_monthly_obligations_by_req_id on-site
  • added hierarchical filtering to DGSearchTextInput (2 hours)

Dong Shin 05.29.2014

  • on-site support (2 hours)
    • deployed FA/Reqonciler – fixed percentages and pre-processing
    • found some obligations are put in a month behind?
    • double counting outlays with ACR field
    • show previous month PM Actuals in Query Builder
  • working on other (5 hours)
    • added PM Actuals % to Query Builder
    • PM Actuals show previous month (month label added)

Dong Shin 05.28.2014

  • working on *other* stuff
    • added ignore previously reviewed… filtering out previously viewed data
    • fixed incorrect percent values for obligated/oulays in Query Builder
    • added queries to remove duplicate obligations and outlays in pre-processing according to the rules.
    • adding PM Actuals Percentages….

Dong Shin 05.27.2014

  • deployed FA/RA with new filterable combo boxes (2 hours)
    • works well, but needs tweaking on Hierarchical data in Project Mgmt
  • working on Reqonciler Pre-Processing (6 hours)
    • removing duplicate rows query sample
      • DELETE n1 FROM test n1, test n2 WHERE n1.uid > n2.uid AND n1.name = n2.name
        AND n1.name2 = n2.name2

Dong Shin 05.19.2014

  • went over FA and Reqonciler with Lenny ( 2 hours)
    • The first month in the second year not calculating correctly
    • verified fixes
      • duplicating Outlays problem
      • rolling months for Planned Outlays, Planned Obligations, PM Actuals for non-admins
      • show all rows in Financial Data
  • working on Filterable Columns for DataGrid (6 hours)