Enrich Funding models to capture many new attributes

[fgregg]

• Phase
• Funded/unfunded
• Funding source
• Year takes place
• Project category
• Funding amount
• Highlight total budget from all phases.
• Grant and Grant amount for phase
• Grant obligated w/ completion date of obligation
• Completed – Yes/No
• Required – Yes/No
• Estimated Bid Quarter
• Notes

[fgregg]

We need to interview @glw about the details of this.

[fgregg]

• Attributes / Foreign key relations to Phases

  • Funded/unfunded
  • Funding source
  • Year takes place
  • Funding amount
  • Grant and Grant amount for phase
  • Grant obligated w/ completion date of obligation
  • Completed – Yes/No
  • Required – Yes/No
  • Estimated Bid Quarter
  • Notes

• Views on Project

  • Highlight total budget from all phases.

• No longer needed?

[fgregg]

• Phase -> Money budgeted -> Funding source
• Phase -> Money budgeted -> Money spent

Funding Stream

• obligated year
• obligated completion date
• funding secured?

Money spent

• amount
• period spent
• (not a CIP feature but could be useful?)

Funding Source

• Type
  • grant
  • other things

Phase

• completed
• required: obligated to perform/complete project
  • obligated date instead of required?
• year takes place
• funded / unfunded
• estimated bid quarter

obligation

More questions:

1. Finance year. If the money allocated for a project is spent over multiple years, how did need to track that?
2. Identifier for phases
3. Where does bid quarter belong?