Dong Shin 04.23.2014

  • got the dump from the _reqonciler_processing table
  • talked Lenny about the columns that could have missing data – ACR for Obligations and ACR, PO Reference for Outlays
  • added obligations/outlays blacklist and whitelist to FinancialAssistant.properties
    • added \FinancialAssistant\src\main\webapp\WEB-INF\ to ClassPath in Run Configurations in Eclipse to read the prop file!!
  • updating pre-processing queries – done
  • updating post-processing queries
  • added appropriation column and removed unnecessary columns from budget_center_contracts
    • ALTER TABLE `budget_center_contracts` ADD `appropriation` VARCHAR(20) NULL AFTER `appropriation_year`;
    • ALTER TABLE `budget_center_contracts`
      DROP `budget_center_name`,
      DROP `sub_budget_center_name`,
      DROP `ebc_name`,
      DROP `committed_date`,
      DROP `committed_amount`,
      DROP `po_start_date`,
      DROP `po_end_date`,
      DROP `contract_type`,
      DROP `po_type_code`,
      DROP `contract_no`,
      DROP `vendor_id`;