Dong Shin 03.18.2013

  • working on Budget Center to save to database…..
  • add required columns to budget_centers table
    • ALTER TABLE `budget_centers` ADD `funded_budget` DECIMAL( 10, 2 ) NULL , ADD `date_submitted_to_services` DATE NULL , ADD `date_received_from_services` DATE NULL , ADD `date_submitted_to_babf` DATE NULL , ADD `acceptance_date` DATE NULL , ADD `sow` TEXT NULL
  • modified SQL to insert budget_center_contacts data – need sum of all amounts
    • INSERT INTO budget_center_contracts( budget_center, appropriation_year, requisition_id, po_reference, acr, committed_date, committed_amount, obligation_date, obligated_amount, expensed_date, expensed_amount, po_start_date, po_end_date, contract_type, po_type_code, contract_no, vendor_id ) SELECT budget_center, appropriation_year, requisition_id, po_reference, acr, committed_date, SUM(committed_amount), obligation_date, SUM(obligated_amount), expensed_date, SUM(expensed_amount), po_start_date, po_end_date, contract_type, po_type_code, contract_no, vendor_id FROM contracts_cognos GROUP BY requisition_id, po_reference