Dong Shin 06.04.2013

  • deployed new FA/RA – few bugs
    • COGNOS contracts not grouping correctly
    • SQL errors retrieving comments (project id = null?)
  • discussion about COGNOS ingest
  • continue working on FA/RA
    • fixed COGNOS contracts data not grouping correclty
    • added Search/Filter to Unclaimed Contracts
    • moved all the icons in source file to stylesheet (AccordionDefaults.css)
    • working on query to update requisition data on data ingest – done
      • UPDATE budget_center_contracts bcc1
        LEFT JOIN
        (SELECT bcc.uid AS tuid, c.uid as cuid
        FROM projects p, budget_centers c, budget_center_contracts bcc
        WHERE p.uid = c.project_id
        AND p.center_name = bcc.budget_center
        AND c.funding_transaction_number = bcc.requisition_id) t
        ON bcc1.uid = t.tuid
        SET bcc1.budget_center_id = cuid