Category Archives: Dong Shin

Dong Shin 09.05.2012

  • status/staffing meeting
  • bugs
    • add more info (Budget Center/MIPR) for Financial Status Data selection
    • the current year seems incorrect in Financial Status Data
    • % calculation seems incorrect
    • make sure Total Allocated in Project Management panel are correct
  • meeting with WOTI folks at NBP

Dong Shin 08.31.2012

  • added Document Number in Funding Request Select window
  • Two problems reported
    1. SQL Error from Chris Gawdun – old version error, newly deployed PPM has the fix
    2. Sub projects showing 0 for Total Allocated – unable to duplicate here.
  • sent updated bugs list that JR maintains – fixed
    • 4. Nothing show under Manage Contracts when you go to the Projects toolbar and then Manage Contracts
      5. There are a few typos in some of the mitigation questions under the OUSD(I) section
      8. Handle Sub__BC problem in BC and scripts
      13. You cannot exit the financial mitigation plans without saving. Someone may just want to cancel without saving
      15. Make the month before the current month highlight pink in the monthly financial data spreadsheet
      16. Make a project past due if data is not entered by the 14th of each month
      17. The invoice form pops up even if the PM actual is zero (in PM, data entry screen)
      18. Allow editing of start year after project creation
      21. Allow editing to end year after project creation
  • Trouble shooting Project Mgmt panel not updating correctly after Project save

Dong Shin 08.30.2012

  • weekly status meeting
  • Funding Request save errors – caused by mailing_address_poc_id default set to NOT NULL
    • fixed it on site
    • ALTER TABLE `funding_requests` CHANGE `mailing_address_poc_id` `mailing_address_poc_id` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL
  • Monthly Financial Datagrid has current month set to 14th day of next month – configurable in setupModel.xml

Dong Shin 08.29.2012

  • Bug Fixes
    • enabled Start FY editing on existing projects
    • added SQL Error panel to capture SQL errors for better trouble-shooting
    • disabled Invoice Pop-up when PM Actual is 0
    • set cut-off day of the month is 14th in setupModel.xml
    • fixed SQL error for non-admins on Project Mgmt
  • reinstalled Eclipse Juno and plug-ins – Subclipse 1.8 is not compatible with OS X
  • minor tweaks to VisibilityScripting4
    • made all debug panel always on top
    • sorted published names in PublishedDataPanel
    • expanded publishedFullNameCombo
  • created scripts under src/main/resources/scripts/ in VS4 project
    • to get Current Year Procurement data – Procurement_Data_Current_Year.py
    • to get Current Year RDT&E data – RDT&E_Data_Current_Year.py
    • to get Current Year O&M data – O&M_Data_Current_Year.py
    • to get 2012 O&M data – O&M_Data_2012.py
  • query to get O&M(FY10) data with Obligation/Outlay goals
    • SELECT p.uid as project_uid, p.project_number, p.title, c.appropriation, c.center_number, c.center_name, a.year, a.amount,
      o.type as type,
      IF(o.year_count = 1, month_1, 0) as Oct_2011,
      IF(o.year_count = 1, month_2, 0) as Nov_2011,
      IF(o.year_count = 1, month_3, 0) as Dec_2011,
      IF(o.year_count = 1, month_4, 0) as Jan_2012,
      IF(o.year_count = 1, month_5, 0) as Feb_2012,
      IF(o.year_count = 1, month_6, 0) as Mar_2012,
      IF(o.year_count = 1, month_7, 0) as Apr_2012,
      IF(o.year_count = 1, month_8, 0) as May_2012,
      IF(o.year_count = 1, month_9, 0) as Jun_2012,
      IF(o.year_count = 1, month_10, 0) as Jul_2012,
      IF(o.year_count = 1, month_11, 0) as Aug_2012,
      IF(o.year_count = 1, month_12, 0) as Sep_2012,
      IF(o.year_count = 2, month_1, 0) as Oct_2012,
      IF(o.year_count = 2, month_2, 0) as Nov_2012,
      IF(o.year_count = 2, month_3, 0) as Dec_2012,
      IF(o.year_count = 2, month_4, 0) as Jan_2013,
      IF(o.year_count = 2, month_5, 0) as Feb_2013,
      IF(o.year_count = 2, month_6, 0) as Mar_2013,
      IF(o.year_count = 2, month_7, 0) as Apr_2013,
      IF(o.year_count = 2, month_8, 0) as May_2013,
      IF(o.year_count = 2, month_9, 0) as Jun_2013,
      IF(o.year_count = 2, month_10, 0) as Jul_2013,
      IF(o.year_count = 2, month_11, 0) as Aug_2013,
      IF(o.year_count = 2, month_12, 0) as Sep_2013
      FROM `projects` p, budget_centers c, budget_amounts a, obligations_outlays o
      WHERE
      p.uid = 176
      AND p.uid = c.project_id
      AND c.uid = a.budget_center_id
      AND p.begin_year + a.year = 2013
      AND c.uid = o.funding_id
      AND o.year = 2012
      AND c.appropriation IN (SELECT type FROM appropriations WHERE duration = 2)
      GROUP BY o.type, c.uid
      UNION
      SELECT p.uid as project_uid, p.project_number, p.title, c.appropriation, c.center_number, c.center_name, a.year, a.amount,
      ‘Obligation Goal’ as type,
      a.amount * SUM(IF(g.year = 1, obligation_month_1, 0)) / 100 as Oct_2011,
      a.amount * SUM(IF(g.year = 1, obligation_month_2, 0)) / 100 as Nov_2011,
      a.amount * SUM(IF(g.year = 1, obligation_month_3, 0)) / 100 as Dec_2011,
      a.amount * SUM(IF(g.year = 1, obligation_month_4, 0)) / 100 as Jan_2012,
      a.amount * SUM(IF(g.year = 1, obligation_month_5, 0)) / 100 as Feb_2012,
      a.amount * SUM(IF(g.year = 1, obligation_month_6, 0)) / 100 as Mar_2012,
      a.amount * SUM(IF(g.year = 1, obligation_month_7, 0)) / 100 as Apr_2012,
      a.amount * SUM(IF(g.year = 1, obligation_month_8, 0)) / 100 as May_2012,
      a.amount * SUM(IF(g.year = 1, obligation_month_9, 0)) / 100 as Jun_2012,
      a.amount * SUM(IF(g.year = 1, obligation_month_10, 0)) / 100 as Jul_2012,
      a.amount * SUM(IF(g.year = 1, obligation_month_11, 0)) / 100 as Aug_2012,
      a.amount * SUM(IF(g.year = 1, obligation_month_12, 0)) / 100 as Sep_2012,
      a.amount * SUM(IF(g.year = 2, obligation_month_1, 0)) / 100 as Oct_2012,
      a.amount * SUM(IF(g.year = 2, obligation_month_2, 0)) / 100 as Nov_2012,
      a.amount * SUM(IF(g.year = 2, obligation_month_3, 0)) / 100 as Dec_2012,
      a.amount * SUM(IF(g.year = 2, obligation_month_4, 0)) / 100 as Jan_2013,
      a.amount * SUM(IF(g.year = 2, obligation_month_5, 0)) / 100 as Feb_2013,
      a.amount * SUM(IF(g.year = 2, obligation_month_6, 0)) / 100 as Mar_2013,
      a.amount * SUM(IF(g.year = 2, obligation_month_7, 0)) / 100 as Apr_2013,
      a.amount * SUM(IF(g.year = 2, obligation_month_8, 0)) / 100 as May_2013,
      a.amount * SUM(IF(g.year = 2, obligation_month_9, 0)) / 100 as Jun_2013,
      a.amount * SUM(IF(g.year = 2, obligation_month_10, 0)) / 100 as Jul_2013,
      a.amount * SUM(IF(g.year = 2, obligation_month_11, 0)) / 100 as Aug_2013,
      a.amount * SUM(IF(g.year = 2, obligation_month_12, 0)) / 100 as Sep_2013
      FROM `projects` p, budget_centers c, budget_amounts a, obligations_outlays_goals g
      WHERE
      p.uid = 176
      AND p.uid = c.project_id
      AND c.uid = a.budget_center_id
      AND p.begin_year + a.year = 2013
      AND g.appropriation = c.appropriation
      AND c.appropriation = ‘O&M (FY10)’
      GROUP BY c.uid
      UNION
      SELECT p.uid as project_uid, p.project_number, p.title, c.appropriation, c.center_number, c.center_name, a.year, a.amount,
      ‘Outlay Goal’ as type,
      a.amount * SUM(IF(g.year = 1, outlay_month_1, 0)) / 100 as Oct_2011,
      a.amount * SUM(IF(g.year = 1, outlay_month_2, 0)) / 100 as Nov_2011,
      a.amount * SUM(IF(g.year = 1, outlay_month_3, 0)) / 100 as Dec_2011,
      a.amount * SUM(IF(g.year = 1, outlay_month_4, 0)) / 100 as Jan_2012,
      a.amount * SUM(IF(g.year = 1, outlay_month_5, 0)) / 100 as Feb_2012,
      a.amount * SUM(IF(g.year = 1, outlay_month_6, 0)) / 100 as Mar_2012,
      a.amount * SUM(IF(g.year = 1, outlay_month_7, 0)) / 100 as Apr_2012,
      a.amount * SUM(IF(g.year = 1, outlay_month_8, 0)) / 100 as May_2012,
      a.amount * SUM(IF(g.year = 1, outlay_month_9, 0)) / 100 as Jun_2012,
      a.amount * SUM(IF(g.year = 1, outlay_month_10, 0)) / 100 as Jul_2012,
      a.amount * SUM(IF(g.year = 1, outlay_month_11, 0)) / 100 as Aug_2012,
      a.amount * SUM(IF(g.year = 1, outlay_month_12, 0)) / 100 as Sep_2012,
      a.amount * SUM(IF(g.year = 2, outlay_month_1, 0)) / 100 as Oct_2012,
      a.amount * SUM(IF(g.year = 2, outlay_month_2, 0)) / 100 as Nov_2012,
      a.amount * SUM(IF(g.year = 2, outlay_month_3, 0)) / 100 as Dec_2012,
      a.amount * SUM(IF(g.year = 2, outlay_month_4, 0)) / 100 as Jan_2013,
      a.amount * SUM(IF(g.year = 2, outlay_month_5, 0)) / 100 as Feb_2013,
      a.amount * SUM(IF(g.year = 2, outlay_month_6, 0)) / 100 as Mar_2013,
      a.amount * SUM(IF(g.year = 2, outlay_month_7, 0)) / 100 as Apr_2013,
      a.amount * SUM(IF(g.year = 2, outlay_month_8, 0)) / 100 as May_2013,
      a.amount * SUM(IF(g.year = 2, outlay_month_9, 0)) / 100 as Jun_2013,
      a.amount * SUM(IF(g.year = 2, outlay_month_10, 0)) / 100 as Jul_2013,
      a.amount * SUM(IF(g.year = 2, outlay_month_11, 0)) / 100 as Aug_2013,
      a.amount * SUM(IF(g.year = 2, outlay_month_12, 0)) / 100 as Sep_2013
      FROM `projects` p, budget_centers c, budget_amounts a, obligations_outlays_goals g
      WHERE
      p.uid = 176
      AND p.uid = c.project_id
      AND c.uid = a.budget_center_id
      AND p.begin_year + a.year = 2013
      AND g.appropriation = c.appropriation
      AND c.appropriation = ‘O&M (FY10)’
      GROUP BY c.uid

Dong Shin 08.27.2012

  • updated database on site for 2013 data
  • fixed Project deletion errors by removing foreign keys on _projects_portfolio_admins table
  • Jessica reported
    • Funding Request Save errors – suspecting some invalid characters, but could not resolve it over the phone. more information needed
    • Total Allocated Budget is needed in addition to the Total Budget – added to Project Management Panel
      • SELECT p.*, p.uid as ID, p.project_number as ‘Project ID’, p.title as ‘Project Name’, begin_year as ‘Start FY’, end_year as ‘End FY’, begin_year as startYear, IF(ISNULL(lock_id), if (total_budget = 0, ‘INCOMPLETE’, ‘EDITABLE’),
        IF (lock_id=’projportfolio’, if (total_budget = 0, ‘INCOMPLETE’, ‘EDITABLE’), ‘LOCKED’)) as Status,
        (end_year – begin_year) as duration, services, p.total_budget as ‘Total Allocated’, sub.project_id as parent_project_id, sub.sub_project_id,
        SUM(IF(ISNULL(t.budget_amount), 0, t.budget_amount)) as ‘Total Budget’
        FROM projects p
        LEFT JOIN _project_sub_projects as sub ON p.uid = sub_project_id
        LEFT OUTER JOIN yearly_totals AS t ON p.uid = t.project_id
        GROUP BY p.uid

Dong Shin 08.24.2012

  • Jessica reported that she couldn’t delete projects – found too many foreign keys on _projects_portfolio_admins
    • need to remove by ALTER TABLE _projects_portfolio_admins DROP FOREIGN KEY <KEY_NAME>
  • starting fresh on Flex Projects with the SVN repo – done
  • query to retrieve O&M (FY10) data for 2012
    • SELECT p.project_number, p.title, c.appropriation, c.center_number, c.center_name, a.year, a.amount,
      o.uid, o.type, o.year, o.year_count,
      IF(o.year_count = 1, month_1, 0) as Oct_2011,
      IF(o.year_count = 1, month_2, 0) as Nov_2011,
      IF(o.year_count = 1, month_3, 0) as Dec_2011,
      IF(o.year_count = 1, month_4, 0) as Jan_2012,
      IF(o.year_count = 1, month_5, 0) as Feb_2012,
      IF(o.year_count = 1, month_6, 0) as Mar_2012,
      IF(o.year_count = 1, month_7, 0) as Apr_2012,
      IF(o.year_count = 1, month_8, 0) as May_2012,
      IF(o.year_count = 1, month_9, 0) as Jun_2012,
      IF(o.year_count = 1, month_10, 0) as Jul_2012,
      IF(o.year_count = 1, month_11, 0) as Aug_2012,
      IF(o.year_count = 1, month_12, 0) as Sep_2012,
      IF(o.year_count = 2, month_1, 0) as Oct_2012,
      IF(o.year_count = 2, month_2, 0) as Nov_2012,
      IF(o.year_count = 2, month_3, 0) as Dec_2012,
      IF(o.year_count = 2, month_4, 0) as Jan_2013,
      IF(o.year_count = 2, month_5, 0) as Feb_2013,
      IF(o.year_count = 2, month_6, 0) as Mar_2013,
      IF(o.year_count = 2, month_7, 0) as Apr_2013,
      IF(o.year_count = 2, month_8, 0) as May_2013,
      IF(o.year_count = 2, month_9, 0) as Jun_2013,
      IF(o.year_count = 2, month_10, 0) as Jul_2013,
      IF(o.year_count = 2, month_11, 0) as Aug_2013,
      IF(o.year_count = 2, month_12, 0) as Sep_2013
      FROM `projects` p, budget_centers c, budget_amounts a, obligations_outlays o
      WHERE
      p.uid = 176
      AND p.uid = c.project_id
      AND c.uid = a.budget_center_id
      AND p.begin_year + a.year = 2013
      AND c.uid = o.funding_id
      AND o.year = 2012
      AND c.appropriation IN (SELECT type FROM appropriations WHERE duration = 2)
      GROUP BY o.type, c.uid
    • SELECT p.project_number, p.title, c.appropriation, c.center_number, c.center_name, a.year, a.amount,
      a.amount * SUM(IF(g.year = 1, obligation_month_1, 0)) / 100 as Oct_2011,
      a.amount * SUM(IF(g.year = 1, obligation_month_2, 0)) / 100 as Nov_2011,
      a.amount * SUM(IF(g.year = 1, obligation_month_3, 0)) / 100 as Dec_2011,
      a.amount * SUM(IF(g.year = 1, obligation_month_4, 0)) / 100 as Jan_2012,
      a.amount * SUM(IF(g.year = 1, obligation_month_5, 0)) / 100 as Feb_2012,
      a.amount * SUM(IF(g.year = 1, obligation_month_6, 0)) / 100 as Mar_2012,
      a.amount * SUM(IF(g.year = 1, obligation_month_7, 0)) / 100 as Apr_2012,
      a.amount * SUM(IF(g.year = 1, obligation_month_8, 0)) / 100 as May_2012,
      a.amount * SUM(IF(g.year = 1, obligation_month_9, 0)) / 100 as Jun_2012,
      a.amount * SUM(IF(g.year = 1, obligation_month_10, 0)) / 100 as Jul_2012,
      a.amount * SUM(IF(g.year = 1, obligation_month_11, 0)) / 100 as Aug_2012,
      a.amount * SUM(IF(g.year = 1, obligation_month_12, 0)) / 100 as Sep_2012,
      a.amount * SUM(IF(g.year = 2, obligation_month_1, 0)) / 100 as Oct_2012,
      a.amount * SUM(IF(g.year = 2, obligation_month_2, 0)) / 100 as Nov_2012,
      a.amount * SUM(IF(g.year = 2, obligation_month_3, 0)) / 100 as Dec_2012,
      a.amount * SUM(IF(g.year = 2, obligation_month_4, 0)) / 100 as Jan_2013,
      a.amount * SUM(IF(g.year = 2, obligation_month_5, 0)) / 100 as Feb_2013,
      a.amount * SUM(IF(g.year = 2, obligation_month_6, 0)) / 100 as Mar_2013,
      a.amount * SUM(IF(g.year = 2, obligation_month_7, 0)) / 100 as Apr_2013,
      a.amount * SUM(IF(g.year = 2, obligation_month_8, 0)) / 100 as May_2013,
      a.amount * SUM(IF(g.year = 2, obligation_month_9, 0)) / 100 as Jun_2013,
      a.amount * SUM(IF(g.year = 2, obligation_month_10, 0)) / 100 as Jul_2013,
      a.amount * SUM(IF(g.year = 2, obligation_month_11, 0)) / 100 as Aug_2013,
      a.amount * SUM(IF(g.year = 2, obligation_month_12, 0)) / 100 as Sep_2013
      FROM `projects` p, budget_centers c, budget_amounts a, obligations_outlays_goals g
      WHERE
      p.uid = 176
      AND p.uid = c.project_id
      AND c.uid = a.budget_center_id
      AND p.begin_year + a.year = 2013
      AND g.appropriation = c.appropriation
      AND c.appropriation IN (SELECT type FROM appropriations WHERE duration = 2)
      GROUP BY c.uid

Dong Shin 08.23.2012

  • Added ChangeLogsPanel to EdgeUtils and FGMFlexUtils45
    1. define logs file in main application – <mx:XML id=”logsXML” source=”/assets/changeLogs.xml” /> or <fx:XML id=”logsXML” source=”/assets/changeLogs.xml” /> for Flex 4
    2. pass the logs file to the panel – logsXML = {logsXML} on the ChangeLogPanel
  • added FGMFlexUtils45’s ChangeLogPanel to ProjectAssistant
  • 10:30 status meeting
  • removed FAD from MIPR/FAD wording in Funding Request (per JR’s request)
  • fixed some Funding Request bugs resulted from the database changes (projects table)

Dong Shin 08.22.2012

  • FGM mail and timecard down today
  • created a SQL script to clean out PPM database to be used for setting up for ’13 data – DBClean.sql
  • IngestManager Errors at site
    • com.edgeti.VisibilityServer.Database.databaseIf.SQLError (DatabaseIf.java:108)
    • Data truncation: Data too long for column ‘FMP’ at row 1 (INSERT INTO…)
    • I believe this is cause by string too long for the database column type String
  • updating Eclipse to 4.2 Juno

Dong Shin 08.21.2012

  • attempted to deploy new PPM/PA with the database updates removing users in projects table that resulted in confusion….
    • ALTER TABLE projects DROP proj_mgr_login
    • ERROR 1025 (HY000) : Error on rename of ‘.project_portfolio#sql-6f4_5f3a’ to ‘.project_portfolioprojects’ (errno: 150
    • this is cause by existing foreign key set up on the column and command line solution is
      1. show create table projects;
      2. remove all the foreign keys by ALTER TABLE `projects` DROP FOREIGN KEY `projects_ibfk_7` ;
  • added Change Password capability to PA and PPM server
    • modified LoginScreen.mxml to have changePassword states and associated text fields/validators
    • added changePassword method to PPMUserService.java

Dong Shin 08.17.2012

  • working at home
  • removed all logins in projects to use relation tables (_projects_…. tables)
    • DBUpdateSQLs08172012.sql
  • changing PPM code to reflect the above
    • save/update projects
    • modified Monthly Financial Data to include the first PM and Admin
    • modified SelectProjectWindow to include the new schema
    • modified PA to work with new table structures

Dong Shin 08.16.2012

  • working at home
  • query to get projects that has same value in previous months
    • SELECT p.project_number, p.title, p.proj_mgr_login,
      c.uid, c.center_number, c.center_name, c.appropriation,
      a.year, a.amount,
      o.*
      FROM projects p,
      budget_centers c,budget_amounts a,obligations_outlays o
      WHERE p.uid = c.project_id
      AND a.budget_center_id = c.uid
      AND o.project_id = p.uid AND c.uid = o.funding_id AND o.year_count = a.year
      AND ((o.month_1 = o.month_2 AND NOT ISNULL(o.month_1))
      OR (o.month_2 = o.month_3 AND NOT ISNULL(o.month_2))
      OR (o.month_3 = o.month_4 AND NOT ISNULL(o.month_3))
      OR (o.month_4 = o.month_5 AND NOT ISNULL(o.month_4))
      OR (o.month_5 = o.month_6 AND NOT ISNULL(o.month_5))
      OR (o.month_6 = o.month_7 AND NOT ISNULL(o.month_6))
      OR (o.month_7 = o.month_8 AND NOT ISNULL(o.month_7))
      OR (o.month_8 = o.month_9 AND NOT ISNULL(o.month_8))
      OR (o.month_9 = o.month_10 AND NOT ISNULL(o.month_9))
      OR (o.month_10 = o.month_11 AND NOT ISNULL(o.month_10))
      OR (o.month_11 = o.month_12 AND NOT ISNULL(o.month_11)))
  • no 10:30 meeting
  • created script to generate project data that has same value as previous months – src/main/java/resources/scripts/EqualMonths.py
    • working on passover years
  • need to clean up associated managers in projects, move all the managers to separate table and remove the fields in the projects table

Dong Shin 08.15.2012

  • new query to get the latest FMP’s
    • SELECT o.uid, p.uid, o.project_id, max(fmp.uid) as maxid,
      (SELECT fmp2.financial_mitigation_plan FROM financial_mitigation_plans fmp2 WHERE fmp2.uid = max(fmp.uid) ORDER BY fmp.uid DESC LIMIT 1),
      fmp.obligation_outlay_uid
      FROM obligations_outlays AS o
      LEFT OUTER JOIN financial_mitigation_plans AS fmp ON o.uid = fmp.obligation_outlay_uid
      LEFT JOIN projects AS p ON p.uid = o.project_id
      GROUP BY o.uid
  • new bugs
    • Delete Table in IngestManager deleted Auto Ingest Config?
    • Run Now in IngestManager not working
    • Server Logs in VSS not showing up in the front
  • query to get goals for RDT&E
    • SELECT appropriation,
      SUM(IF(year = 1, obligation_month_1, 0)) as Oct_2012,
      SUM(IF(year = 1, obligation_month_2, 0)) as Nov_2012,
      SUM(IF(year = 1, obligation_month_3, 0)) as Dec_2012,
      SUM(IF(year = 1, obligation_month_4, 0)) as Jan_2013,
      SUM(IF(year = 1, obligation_month_5, 0)) as Feb_2013,
      SUM(IF(year = 1, obligation_month_6, 0)) as Mar_2013,
      SUM(IF(year = 1, obligation_month_7, 0)) as Apr_2013,
      SUM(IF(year = 1, obligation_month_8, 0)) as May_2013,
      SUM(IF(year = 1, obligation_month_9, 0)) as Jun_2013,
      SUM(IF(year = 1, obligation_month_10, 0)) as Jul_2013,
      SUM(IF(year = 1, obligation_month_11, 0)) as Aug_2013,
      SUM(IF(year = 1, obligation_month_12, 0)) as Sep_2013,
      SUM(IF(year = 2, obligation_month_1, 0)) as Oct_2013,
      SUM(IF(year = 2, obligation_month_2, 0)) as Nov_2013,
      SUM(IF(year = 2, obligation_month_3, 0)) as Dec_2013,
      SUM(IF(year = 2, obligation_month_4, 0)) as Jan_2014,
      SUM(IF(year = 2, obligation_month_5, 0)) as Feb_2014,
      SUM(IF(year = 2, obligation_month_6, 0)) as Mar_2014,
      SUM(IF(year = 2, obligation_month_7, 0)) as Apr_2014,
      SUM(IF(year = 2, obligation_month_8, 0)) as May_2014,
      SUM(IF(year = 2, obligation_month_9, 0)) as Jun_2014,
      SUM(IF(year = 2, obligation_month_10, 0)) as Jul_2014,
      SUM(IF(year = 2, obligation_month_11, 0)) as Aug_2014,
      SUM(IF(year = 2, obligation_month_12, 0)) as Sep_2014,
      SUM(IF(year = 3, obligation_month_1, 0)) as Oct_2014,
      SUM(IF(year = 3, obligation_month_2, 0)) as Nov_2014,
      SUM(IF(year = 3, obligation_month_3, 0)) as Dec_2014,
      SUM(IF(year = 3, obligation_month_4, 0)) as Jan_2015,
      SUM(IF(year = 3, obligation_month_5, 0)) as Feb_2015,
      SUM(IF(year = 3, obligation_month_6, 0)) as Mar_2015,
      SUM(IF(year = 3, obligation_month_7, 0)) as Apr_2015,
      SUM(IF(year = 3, obligation_month_8, 0)) as May_2015,
      SUM(IF(year = 3, obligation_month_9, 0)) as Jun_2015,
      SUM(IF(year = 3, obligation_month_10, 0)) as Jul_2015,
      SUM(IF(year = 3, obligation_month_11, 0)) as Aug_2015,
      SUM(IF(year = 3, obligation_month_12, 0)) as Sep_2015
      FROM `obligations_outlays_goals`
      WHERE  appropriation LIKE ‘RDT&E%’
      GROUP BY appropriation

Dong Shin 08.14.2012

  • spent some time at Fort preparing for Col. Duke’s presentation
    • alerts when a PM Actuals have stayed the same from one month to the next
    • alerts when COGNOS data (for a specific PFR or grouping of funding (budget centers)) has stayed the same from one month to next
    • add FMP to CurrentStatus.py
      • add this query to
      • SELECT o.uid, fmp.uid, fmp.obligation_outlay_uid
        FROM obligations_outlays as o
        LEFT OUTER JOIN financial_mitigation_plans as fmp ON o.uid = fmp.obligation_outlay_uid
        GROUP BY o.uid
  • VisibilityScripting bugs
    • scripts are not deleted by delete button
    • scripts persists after they are delete in the DB
  • checked in the latest VSS code that had delete script support