Phil 11.22.13

8:00 – 5:00 SR

  • Backups
  • Move back into the office
  • Add date handling based on project start and whether current ObligationOutlay.value(type) is at total budget. Done.
  • Project SQL output testing – done
  • Start cognos spreadsheet outputs
  • The portfolio managers on the project information tab should see all the requisitions (in RA) that are behind that project (High Priority)
  • Need to list what users are active, and what roles they have (Can just be a query)
  • Purge users that are not assigned to a project or requisition.
  • Because of the Cognos line matching algorithm, should we be only pulling the minimum columns?
  • There can be multiple projects per sub-budget center.

Dong Shin 11.21.2013

  • new Furniture!
  • working on Reqonciler
    • trouble-shooting incorrect ingest… changed budget_center to sub_budget_center in post-processing query
    • added update obligations and outlays queries to the post processing

Phil 11.21.13

8:00 – 4:00 SR

  • One month to go until the days start getting longer
  • Backups
  • New furniture
  • Need to change column names in vis export so that there are no spaces (special characters) in the column names. Underscores should be used to match ingestor.

Dong Shin 11.20.2013

  • deployed FA – Export to Viz works!
    • fixed table name not using the textInput
  • duplicate projects listed in Project Mgmt Panel – fixed
    • caused by incorrect parent id set from the server….. 0 instead of NULL
    • must use ResultSet.wasNull() to see if the last getXXX returned is NULL
  • created test XSLX spreadsheet to duplicate incorrect Outlay data on-site….

Phil 11.20.13

8:00 – 5:00 SR

  • Backups
  • Deployed new FA
  • Verified that we could connect to Visibility, but the default table name is in there.
  • Discussed path forward with Chris and Lenny. Next discussion will be next Tuesday
  • Duplicate project listing in “Project Management” in FA
  • Fake data
    • Need to add start date
    • Need to stop PM Actuals, Outlays from being written in the future
    • Change OO from being nxn arrays to arrays of n OO classes each with 12 months?
    • Only one sub budget center per project. BC can be shared, but SBCs are not
    • Future values are null, not zero
    • Started writing out Project sql. Need to know what a few things are before finishing.

Phil 11.19.13

10:00 – 5:00 SR

  • Physicals have more components every year. I’m expecting one day that they’re take so much blood that one of the results of the testes will be “anemia”.
  • Working on Cognos generator. Breaking up the code into better manageable pieces.
  • Finished the main structure. Adding error injection

Phil 11.18.13

8:00 – 4:00 SR

  • This has been the craziest two weeks ever:
    • Dad has heart attack while I’m leaving for a conference
    • Conference, plus the most delayed flight I’ve ever been on, arriving at 1:30 am…
    • Comprehensive exam and portfolio
    • Final paper for 760 – 6 pages in 3 days
    • And, wait for it – I get hit by a car while out riding on Saturday.
    • Looking forward to a nice, slow week.
  • Backups
  • Fake Cognos

Phil 11.15.13

8:00 – 12:30 SR

  • Add appropriation name as a column
  • Overdue
    • Additional query Timeline – don’t cull the less than 21, but keep the greater than 2000
    • Acceptance – For any item that has a filled date field, don’t show.
    • Obligations – Don’t show if 100% obligated
  • Committed amount is currently using Cognos data for committed amount. Need to change to Req. Funded. Keep the committed date.
  • Presentation ready by COB Nov 27
  • November 2014 queries does not show out year 2013  etc.
  • More Face Cognos data

Dong Shin 11.14.2013

  • deployed new FA, RA, FinancialAssistant.jar, and queries
    • Obligations/Outlays not meeting goals (95%) should be navigated thru month combobox
    • change the query to include all fiscal years for the selected FY
    • Excel export from Query Builder
    • FA missing Roles Management panel
    • modified Overdue Obligations/Outlay queries to ignore more than 2000 days….
  • working on FA
    • changed the query to return all the data for the selected FY
    • added UserRolesManagement panel from FA3
    • working on queries to navigate obligations/outlays not meeting goals by monthly