Category Archives: Dong Shin

Dong Shin 01.31.2013

  • presentation for Col. Duke – went pretty well!
  • finished up adding FMP View button – a new window and lots of back communications
  • FMPs are now required for only Reported Actual Obligated and Outlay $ Reported in FACTS, others are ignored.

Dong Shin 01.30.2013

  • prep for Col Duke’s presentation
    • latest data generation (script) and ingest – set to run every morning
    • alerts ingested – need to fix the script that contains the Stored Procedure
      • temporary and memory
    • went over the charts with Chris
  • FMP’s should only be Obligations and Outlays – tabled for discussion later
  • continue working on FMPs for PA

Dong Shin 01.29.2013

  • spent most of the morning working on queries and reports
    • got Committed ingested for FY13
    • cleaned up Ingest Manager data, Scripting
    • ingested FY12 data
  • working on adding FMP to PA
    • modify table – financial_mitigation_plans
      • ALTER TABLE `financial_mitigation_plans` CHANGE `type` `type` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Obligation'

Dong Shin 01.28.2013

  • spent most of the day working out queries and scripts for FY13 presentation for Col Duke
    • still need Committed from COGNOS
  • few bugs
    • FMP’s didn’t show for PM’s and Admins – Explained to Carla how it works
    • Add a “View Financial Mitigation Plans to Monthly Status View in PA
    • Add an “Outlay” field for NSA staff so we can tell the difference between the site outlay expectation and NSA expectation
  • working on adding View FMP to PA

Dong Shin 01.25.2013

  • Master Spreadsheet meeting – worked out most of the details
  • working on queries for Col. Duke’s presentation
    • created projects for each of Capabilities and Appropriations
    • built a query to retrieve PM Actuals grouped by capability
      • SELECT CONCAT(capability, ‘_’, TRIM(TRAILING ‘(FY10)’ FROM appropriation), ‘_PM_Actuals’) as Name,
        SUM(IF(o.year_count = 1, month_1, 0) )AS OCT_2012_FY13,
        SUM(IF(o.year_count = 1, month_1, 0) )AS NOV_2012_FY13,
        SUM(IF(o.year_count = 1, month_1, 0) )AS DEC_2012_FY13,
        SUM(IF(o.year_count = 1, month_1, 0) )AS JAN_2013_FY13,
        SUM(IF(o.year_count = 1, month_1, 0) )AS FEB_2013_FY13,
        SUM(IF(o.year_count = 1, month_1, 0) )AS MAR_2013_FY13,
        SUM(IF(o.year_count = 1, month_1, 0) )AS APR_2013_FY13,
        SUM(IF(o.year_count = 1, month_1, 0) )AS MAY_2013_FY13,
        SUM(IF(o.year_count = 1, month_1, 0) )AS JUN_2013_FY13,
        SUM(IF(o.year_count = 1, month_1, 0) )AS JUL_2013_FY13,
        SUM(IF(o.year_count = 1, month_1, 0) )AS AUG_2013_FY13,
        SUM(IF(o.year_count = 1, month_1, 0) )AS SEP_2013_FY13,
        SUM(IF(o.year_count = 2, month_1, 0) )AS OCT_2013_FY13,
        SUM(IF(o.year_count = 2, month_1, 0) )AS NOV_2013_FY13,
        SUM(IF(o.year_count = 2, month_1, 0) )AS DEC_2013_FY13,
        SUM(IF(o.year_count = 2, month_1, 0) )AS JAN_2014_FY13,
        SUM(IF(o.year_count = 2, month_1, 0) )AS FEB_2014_FY13,
        SUM(IF(o.year_count = 2, month_1, 0) )AS MAR_2014_FY13,
        SUM(IF(o.year_count = 2, month_1, 0) )AS APR_2014_FY13,
        SUM(IF(o.year_count = 2, month_1, 0) )AS MAY_2014_FY13,
        SUM(IF(o.year_count = 2, month_1, 0) )AS JUN_2014_FY13,
        SUM(IF(o.year_count = 2, month_1, 0) )AS JUL_2014_FY13,
        SUM(IF(o.year_count = 2, month_1, 0) )AS AUG_2014_FY13,
        SUM(IF(o.year_count = 2, month_1, 0) )AS SEP_2014_FY13
        FROM obligations_outlays o, budget_centers c, budget_amounts a
        WHERE
        o.year = 2013
        AND (o.year_count = 1 OR o.year_count = 2)
        AND o.type = ‘PM Actuals (Invoiced) Outlay $:’
        AND c.uid = o.funding_id
        AND c.uid = a.budget_center_id
        AND a.year = 1
        AND (capability = ‘TRCO’
        or capability = ‘ACC’
        or capability = ‘GCC’
        or capability = ‘MCC’
        or capability = ‘CCRSE’)
        GROUP BY Name

Dong Shin 01.24.2013

  • snow!
  • trying to figure out how to preserve datagrid sort
    • PA’s project list now preserves its state, Status and Sort
  • critical bug found – PM’s cannot save the data and line item view doesn’t show any data
    • fixed – problem with the datagrid filter function for non-admins
  • burned a CD to deploy this afternoon

Dong Shin 01.23.2013

  • working on PA for status issues – done
  • added preferences (columns selection for Project list) saving for PA
  • PA’s having some issues that we believe they were running old versions (without clearing history/cache)
    • In PA, set the compile date in the tab, so screen shots tell us what version
    • Add a method in Utils that test the compile date against a string in the DB, If the compile date is less than the stored string, a dialog is shown, telling how to update in IE and FF. If the date is greeater than the stored date, the date on the DB is update. If they are the same, nothing is done.

Dong Shin 01.22.2013

  • deployed new PA. works better but issues with Status and others
    • From the first of the month to the due date (e.g. the 10th), states may be DUE, OVERDUE, or Current. For the following, we will assume that the calendar month is May, and that the reporting month is April
      1. If it is May 1-10, state is OVERDUE, if any previous month’s data is incomplete (e.g. March and prior) ELSE
      2. If it is May 11-31, the April state is OVERDUE, if any previous month’s data is incomplete (e.g. April and prior) ELSE
      3. If if it May 1-10, the April state is DUE, if the data is incomplete for April and all previous months. ELSE
      4. If it is May 1-10, the April state is CURRENT, if the data is complete April and all previous months. ELSE
      5. If it is May 11-31, the April state is CURRENT, if the data is complete for all previous months
    • Sorting of status needs to maintain in PA
    • Need to keep preferences for users in PA
    • Queries for Tangie
      • Query for who has been in the tool in putting their information
      • Out of all of the TST sub budgets what is the top 10 projects offenders (not meeting DOD goals)
      • TST personal graph (just like the monthly brief

Dong Shin 01.18.13

  • cancelled deploy of PA due to SQL error – fixed
  • updated Java 7 and XAMPP 1.7.7 of I&T and production servers
    • max_allowed_packet in my.ini file under mysql should be set to 100M
    • tried to update MySQL 5.2.28 by replacing the folder – didn’t work, may need to figure out the way to update

Dong Shin 01.17.2013

  • status meeting at 8
    • discussion about new spreadsheet format
  • few bugs/enhancements
    • When contracts dialog comes up, limit the contracts to project related contracts in PA
    • Remove Incomplete status in PA
    • When committed == 0, auto fill current months (via script?) in PA
    • fix incorrect fiscal month in PA
    • Duplicating projects should have a checkbox for each of the following to appear in a dialog before the action
      • Budget Center line
      • Associated funding requests
    • Funding Requests should have a field that points back to the source project (UID, Project ID, etc.)
  • fixed the incorrect fiscal month in PA
  • removed Incomplete status and associated changes(!)
  • added projects to retrieve related contracts for invoices

Dong Shin 01.11.2013

  • meeting at Fort @ 7:30AM
    • Uniques ID# (String) to identify MIPR/Budget center for updating COGNOS/FACT data – discussion later
  • deployed new PA and PPM, few more bugs
    • Reported Outlay shows up in Summary in PPM
    • Current Month not correct in PPM
  • continue working on Financial Data Navigator

Dong Shin 01.10.2013

  • working on adding “DUE” status to individual projects
  • PA defaults to “Reporting Months” on CURRENT and DUE status
  • continue working on “DUE” status for list of projects in PA – done!
    • modified the query to get status
      • SELECT p.*, IF(p.uid IN (SELECT project_id FROM (SELECT project_id, year, year_count, count(funding_id) as data_count FROM obligations_outlays WHERE ((ISNULL(month_1) OR ISNULL(month_2)) AND (year+year_count-1) = 2013) OR ((ISNULL(month_1) OR ISNULL(month_2) OR ISNULL(month_3) OR ISNULL(month_4) OR ISNULL(month_5) OR ISNULL(month_6) OR ISNULL(month_7) OR ISNULL(month_8) OR ISNULL(month_9) OR ISNULL(month_10) OR ISNULL(month_11) OR ISNULL(month_12)) AND (year+year_count-1) < 2013) GROUP BY funding_id, year, year_count ) AS FOO WHERE data_count = 6), ‘OVERDUE’, IF(p.uid IN (SELECT project_id FROM (SELECT project_id, year, year_count, count(funding_id) as data_count FROM obligations_outlays WHERE ((ISNULL(month_1) OR ISNULL(month_2)) AND (year+year_count-1) = 2013) OR ((ISNULL(month_1) OR ISNULL(month_2) OR ISNULL(month_3) OR ISNULL(month_4) OR ISNULL(month_5) OR ISNULL(month_6) OR ISNULL(month_7) OR ISNULL(month_8) OR ISNULL(month_9) OR ISNULL(month_10) OR ISNULL(month_11) OR ISNULL(month_12)) AND (year+year_count-1) < 2013) GROUP BY funding_id, year, year_count ) AS FOO WHERE data_count < 6), ‘INCOMPLETE’, IF(p.uid IN (SELECT project_id FROM (SELECT project_id, year, year_count, count(funding_id) as data_count FROM obligations_outlays WHERE (ISNULL(month_3) AND (year+year_count-1) = 2013) GROUP BY funding_id, year, year_count ) AS FOO WHERE data_count > 1), ‘DUE’, ‘CURRENT’) ) ) as status FROM projects p WHERE p.uid in (SELECT project_id FROM budget_centers)