Dong Shin 06.06.2013

  • continue working on FA/RA
    • working off the list from today’s meeting
    • changing table names and column names to match application fields
      • budget_centers
        • funding_transaction_name -> req_description (fundingTransName, fundingTransactionName)
        • funding_transaction_number -> req_id (fundingTransNumber
        • funding_transaction_type -> req_type (fundingTransType
      • funding_transaction_names -> req_descriptions (FundingTransactionName
      • funding_transaction_numbers – > req_ids (FundingTrasactionNumber
      • funding_trasaction_types -> req_types (FundingTransactionType
  • Viz Tool meeting – copy from Phil’s blog
    • Not quite ready for the demo
    • Req Amt -> “Amount”
    • MIPR Desc -> Funding Description
    • Fix “#” tab title
    • Remove Sub-budget Center name and number from project and move to Req Line
    • Test search/auto claim (add sub-budget ctr) add debug statements so we can see what’s going on in production environment
    • Add columns for sub budget center and executing budget ctr
    • Project management screen in doubling Total Budget need to clean up tables…
    • Search functions (still!) need to be query driven
    • When searching for sub-budget centers, the default should be to cull based on the budget center prefix. There should be an additional search box which overrides the default search (* lists everything)
    • Use alert SQL to produce charts (There needs to be date information, so this may mean that we have to edit the source for text panels)
    • Fix Lenny’s email problem (may be the DB misbehaving. Bounced MySQL)
      • Date field tries to save empty string.
      • Look MySqlIf for clean up after a sql error.
    • Funding status should default to current month
    • Column names
      • Budget Center
      • Budget Center Name
      • Sub-Budget Center
      • Sub-Budget Center Name
      • Executing Budget Center
      • EBC Name
      • Appropriation Year
      • Requisition ID
      • PO Reference
      • ACR
      • Vendor Name
      • Address Line 1
      • City
      • Postal Code
      • Comitted Date
      • Comitted Amount
      • Obligation Date Obligated Amount
      • Expensed Date
      • Expensed Amount
      • Vendor ID
      • Vendor Abbr.
      • PO Start Date PO End Date
      • Contract Type
      • PO Type Code
      • Contract No.
  • Took FA offline until null date error is resolved
  • Demo is now scheduled for June 14