Uploaded image for project: 'mod-finance-storage'
  1. mod-finance-storage
  2. MODFISTO-35

Update GroupFundFY table

    XMLWordPrintable

Details

    • Story
    • Status: Closed (View Workflow)
    • P3
    • Resolution: Won't Do
    • None
    • 4.0.0
    • None
    • 2
    • Thunderjet

    Description

      Overview

      As funds are associated with groups, and fiscal years are created, we need to make corresponding changes to the GroupFundFY table.

      • When a FiscalYear is created, create a new GroupFundFY record for each existing Fund/Group pair.  (only if fiscalYear endDate > now)

      See the wiki for details

      • NOTE: Don't worry about delete for now... we'll probably need to implement a soft delete for group/fund/fy since they are referred to by several other records.

      Approach

      • Update the GroupFundFY table in a database transaction, or possibly via trigger function.

      Acceptance Criteria

      • GroupFundFY records are created as described in the wiki
      • Unit tests are updated

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                Unassigned Unassigned
                cmcnally Craig McNally
                Craig McNally Craig McNally
                Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases