Dong Shin 10.02.2013

  • keeping track of what to deploy at https://viztales.wordpress.com/to-deploy-whenever-they-are-ready/
  • working on script to update Obligations/Outlays for EA’s 
    • created and ingested test data – Contracts Example.xlsx
    • set up projects for EA’s
    • query to get contracts data mapped to EA’s
      • SELECT *
        FROM budget_centers bc
        LEFT JOIN budget_center_contracts AS bcc ON bc.uid = bcc.budget_center_id
        LEFT JOIN contracts_cognos AS cc ON cc.sub_budget_center = bcc.sub_budget_center
        AND SUBSTRING(cc.requisition_id, 5) = bcc.requisition_id
        WHERE bc.req_type = ‘EA’
    • updated obligation_outlays_queries.sql
    • updating update_obligations_outlays.py to update!
    • fixed get_cognos_outlays query to use expensed_date, not committed_date