Dong Shin 01.07.2015

  • adding data for dropdown list in server – done
    • Budget Centers – FRBudgetCenter
    • Sub Budget Centers – FRSubBudgetCenter
    • Requisition IDs – RequisitionId
    • Project Numbers – ProjectNumber
    • Project Labs – ProjectLab
  • generate_monthly_status_data.py not working properly
    • add data to __view_project_detailed_data
      •  `oog`.`obligation_goal_pct_year_1_month_1` * `bc`.`total_budget` / 100 AS `obligation_goal_year_1_month_1`,
      • `oog`.`outlay_goal_pct_year_1_month_1` * `bc`.`total_budget` / 100 AS `outlay_goal_year_1_month_1`,
      • up to year 4 month 12
    • add/change fields
      • typeDict = {“Obligated”:”reported_facts_obligated”,\
        “Committed”:”committed_amount”,\
        “Outlay Goal”:”outlay_goal”,\
        “Obligation Goal”:”obligation_goal”,\
        “Committed”:”committed_amount”,\
        “PM Actuals”:”pm_actuals”,\
        “Outlays”:”reported_facts_outlay”};