Author Archives: gvr4wd

Unknown's avatar

About gvr4wd

...hmmm

Dong Shin 02.13.2013

  • VizTool status meeting at Fort
  • Changed Reported Actual Obligated to Reported FACTS Obligated, no need to update database as of today.
  • continue working on Planned Obligation/Outlay Editor
    • got edit to work – saves to database!
  • moved buttons to the top
  • resized the Financial Data Navigator window
  • added DropDownList to Status view to filter MIPRs
    • still needs filtering
  • managed to corrupt the workspace I was using Flash Builder 4.7 with… and couldn’t get 4.7 to start! removed and re-installed, but no luck. going back to 4.6

Dong Shin 02.11.2013

  • bugs
    • Replace “next incomplete record” tooltip with “next record”
    • Add text following “x of y” at the bottom left to indicate what is being stepped through
    • Take a look at users table cascading problem
    • Create a script that deletes all contracts that are not being used
      • RemoveUnusedContracts.sql in PPM
  • Flash Builder 4.6 has been crapping out on me past months continuously giving me various run time errors, ugh! – downloading 4.7 (1GB!) – working better but waiting for a license from Adobe (free upgrade from 4.5, 4.6)
  • working on queries to retrieve committed (Funded Budget) for PA
    • SELECT bc.*, (SELECT commit
      FROM _funding_requests_budget_centers frbc, funding_requests fr, budget_centers bc
      WHERE frbc.funding_request_id = fr.uid
      AND frbc.budget_center_id = bc.uid AND bc.uid = 18)
      FROM budget_centers bc
      WHERE bc.uid = 18
  • working on queries to retrieve contracts for PA
    • SELECT GROUP_CONCAT(c.contract_number)
      FROM _funding_requests_contracts frc, funding_requests fr, contracts c, projects p
      WHERE frc.funding_request_id = fr.uid
      AND c.uid = frc.contract_id
      AND fr.project_id = p.uid
      AND p.uid = 193
      GROUP BY fr.uid

Dong Shin 02.08.2013

  • PPM
    • select contract from funding request data instead of projects data in PPM for the Invoice
    • removed from Financial Data Navigator in both status and line item view
      • Expenditure Center
      • Investment Portfolio
      • Program Element
      • FACTS PE
    • changed Identifier to use MIPR (center_name) in Yearly View
    • Reported FACTS Obligated is disabled
    • added BETA image to PA