Dong Shin 04.18.2014

  • had discussion with Lenny on Reqonciler – needs to process Obligations and Outlays separate
    • Obligations
      • Budget Center, Sub Budget Center, Executing Budget Center, Appropriation Year, Appropriation, Requisition ID, PO Reference, ACR, Obligated Date, Obligated Amount (Bolds are the uniquely identifying fields)
      1. If all fields above match, ignore
      2. If only the obligation date changes, ignore
    • Outlays
      • Budget Center, Sub Budget Center, Executing Budget Center, Appropriation Year, Appropriation, Requisition ID, PO Reference, ACR, Expensed Date, Expensed Amount, Voucher ID (Bolds are the uniquely identifying fields)
      • If all fields match, ignore
    • Pre-Processing Steps
      • If line is ignored in previous steps, it should cascade down to follow on steps and not be shown
    • Appropriations – O&M, PROC, RDT&E
  • working on Reqonciler
    • created new tables – cognos_obligations and cognos_outlays
    • working on ContractsParser.java….